Yes, you have to set non-caching mode for db_text.

You can also look at db_sqlite, maybe suits better your needs.

Cheers,
Daniel

Do I understand correctly that if db_text is in caching mode ( db_mode=0 ), then changes in the dbtext/domain file are not updated by the kamcmd domain.reload command?

чт, 13 янв. 2022 г. в 12:17, Denys Pozniak <denys.pozniak@gmail.com>:

Thanks! Now it works!

чт, 13 янв. 2022 г. в 11:55, Daniel-Constantin Mierla <miconda@gmail.com>:

Hello,

alias_db is for user aliases, not for host aliases. For multi-domain support with database storage, use domain module and set register myself mod param.

Anyhow, the domains won't show up in core.aliases_list rpc response, that's only for host aliases set in config file, but domain module has also rpc command for listing its records.

Cheers,
Daniel

On 13.01.22 10:49, Denys Pozniak wrote:

Hello!

I need help uploading a list of aliases through a dbtext to use them via myself.
It is likely that there is some configuration problem:

loadmodule "db_text.so"

modparam("db_text", "db_mode", 1)
modparam("db_text", "emptystring", 1)

loadmodule "alias_db.so"
modparam("alias_db", "db_url", "text:///etc/kamailio/dbtext")

[root@kamailio]$ cat dbtext/dbaliases
id(int,auto) alias_username(string) alias_domain(string) username(string) domain(string)
1::sip.test.local::

[root@kamailio]$ kamcmd core.aliases_list
{
        myself_callbacks: yes
        aliases: {
        }
}

If done through a script (alias=sip.test.local), then everything works fine:

[root@kamailio]$ kamcmd core.aliases_list
{
        myself_callbacks: yes
        aliases: {
                alias: {
                        proto: *
                        address: sip.test.local
                        port: *
                }
        }
}

--

BR,

Denys Pozniak

__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
  * sr-users@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
  * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Online
  Feb 21-24, 2022 (America Timezone)
  * https://www.asipto.com/sw/kamailio-advanced-training-online/

--

BR,

Denys Pozniak

--

BR,

Denys Pozniak

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Online
  Feb 21-24, 2022 (America Timezone)
  * https://www.asipto.com/sw/kamailio-advanced-training-online/