Re: [SR-Users] DBText does not exists!

I’ve done a completely fresh machine using the config from the GitHub issues using Amazon Linux 2 and registration is sending. I’m unsure what is varying, but I think I’ll rebuild this whole thing as an Ansible playbook anyway so I can redeploy quickly.

Here’s the bash history for anyone curious: 1 yum install -y gcc gcc-c++ bison flex make ruby-devel git 2 git clone https://github.com/kamailio/kamailio.git 3 cd kamailio/ 4 make include_modules="app_ruby" cfg 5 make all && make install 6 cd /usr/local/etc/kamailio/ 7 ls 8 vim kamailio.cfg 9 vim /etc/systemd/system/multi-user.target.wants/kamailio.service 10 systemctl daemon-reload 11 systemctl start kamailio 12 tail -f /var/log/messages 13 ls 14 mkdir /usr/local/etc/kamailio/dbtext 15 cd /usr/local/etc/kamailio/dbtext 16 ls 17 vim uacreg 18 systemctl restart kamailio 19 tail -f /var/log/messages Mar 26 14:18:00 ip-10-0-0-3 /usr/local/sbin/kamailio[17873]: ERROR: <core> [core/resolve.c:1698]: sip_hostport2su(): could not resolve hostname: "sip.example.org" Mar 26 14:18:00 ip-10-0-0-3 /usr/local/sbin/kamailio[17873]: ERROR: tm [ut.h:309]: uri2dst2(): failed to resolve "sip.example.org" Mar 26 14:18:00 ip-10-0-0-3 /usr/local/sbin/kamailio[17873]: ERROR: tm [uac.c:452]: t_uac_prepare(): no socket found Mar 26 14:18:00 ip-10-0-0-3 /usr/local/sbin/kamailio[17873]: ERROR: uac [uac_reg.c:1181]: uac_reg_update(): failed to send request for [12345678] If anyone can help find the issue I’d be very interested, however it looks like issue is package/config somewhere rather than kamailio. Thanks ________________________________ Andrew White - Director uConnected Email: andrew(a)uconnected.com.au Web: www.uConnected.com.au > On 27 Mar 2019, at 12:23 am, Andrew White &lt;andrew(a)uconnected.com.au&gt; > wrote: > > Update: > > I’ve just tried the config from the GitHub issue on another server (CentOS > 7) and get the following console output: > > Mar 26 13:08:48 voice-test2 /usr/local/sbin/kamailio[29762]: ERROR: <core> > [core/resolve.c:1699]: sip_hostport2su(): could not resolve hostname: > "sip.example.org <http://sip.example.org/>" Mar 26 13:08:48 voice-test2 > /usr/local/sbin/kamailio[29762]: ERROR: tm [ut.h:309]: uri2dst2(): failed > to resolve "sip.example.org <http://sip.example.org/>" Mar 26 13:08:48 > voice-test2 /usr/local/sbin/kamailio[29762]: ERROR: tm [uac.c:452]: > t_uac_prepare(): no socket found Mar 26 13:08:48 voice-test2 > /usr/local/sbin/kamailio[29762]: ERROR: uac [uac_reg.c:1181]: > uac_reg_update(): failed to send request for [12345678] > > This looks to me like it is attempting registration and failing. > > I’ve tried this same config on my main server (Amazon Linux 2) and am not > getting any such messages. > > Both are built from the same master commit: > > AL2: > > version: kamailio 5.3.0-dev4 (x86_64/linux) 97189d > flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, > DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, > F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, > USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, > HAVE_RESOLV_RES ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, > MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB poll method > support: poll, epoll_lt, epoll_et, sigio_rt, select. > id: 97189d > compiled on 13:18:22 Mar 26 2019 with gcc 7.3.1 > > CentOS 7: > > version: kamailio 5.3.0-dev4 (x86_64/linux) 97189d > flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, > DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, > F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, > USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, > HAVE_RESOLV_RES ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, > MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB poll method > support: poll, epoll_lt, epoll_et, sigio_rt, select. > id: 97189d > compiled on 13:52:08 Mar 23 2019 with gcc 4.8.5 > > I’m assuming we’re missing a package, a socket definition varies, > something like that. How can I further debug this? > > Thanks! > > Andrew > >> On 27 Mar 2019, at 12:01 am, Andrew White &lt;andrew(a)uconnected.com.au >> <mailto:andrew@uconnected.com.au>> wrote: >> >> Thanks so much Miko! >> >> You’re completely right. This is also in the docs for the module, it >> appears I’ve skimmed over that part! >> >> It appears the DB is now loading without error, however I don’t see any >> attempting for registration in Wireshark. A kamcmd uac.reg_dump doesn’t >> return any result. >> >> I’ve copied config shown to be working from a GitHub issue on an >> unrelated problem (https://github.com/kamailio/kamailio/issues/936 >> <https://github.com/kamailio/kamailio/issues/936>). Relevant lines >> below: >> >> #!define DBURL "text:///etc/kamailio/dbtext >> <text:///etc/kamailio/dbtext>" >> >> modparam("rr", "append_fromtag", 1) >> modparam("dialog", "dlg_flag", 4) >> modparam("dialog", "track_cseq_updates", 1) >> modparam("uac", "restore_dlg", 1) >> modparam("uac", "reg_db_url", DBURL) >> modparam("uac", "reg_timer_interval", 60) >> modparam("uac", "reg_retry_interval", 60) >> modparam("uac", "reg_contact_addr", "1.2.3.4:5060") >> >> And /etc/kamailio/dbtext/uacreg: >> >> l_uuid(string) l_username(string) l_domain(string) r_username(string) >> r_domain(string) realm(string) auth_username(string) >> auth_password(string) auth_proxy(string) expires(int) flags(int) >> reg_delay(int) 12345678:user:domain.local:11111111:sip.example.org >> <http://sip.example.org/>:sip.example.org >> <http://sip.example.org/>:11111111:XXXXXXXXXXXXXXXX:sip\:sip.example.org >> :600 <http://sip.example.org:600/>:0:0 >> >> Both an lsof and a WITH_DEBUG show uac.so is being loaded without issue, >> however no messages relevant to registration are showing, and no >> REGISTER messages appear in Wireshark. >> >> A kamcmd to query the record shows it does not appear loaded: >> >> [root@ip-10-0-0-2 kamailio]# kamcmd uac.reg_info l_uuid 12345678 >> error: 404 - Record not found >> >> I feel like I’m missing something obvious here! >> ________________________________ >> >> Andrew White - Director >> uConnected >> Email: andrew(a)uconnected.com.au <mailto:andrew@uconnected.com.au> >> Web: www.uConnected.com.au <http://www.uconnected.com.au/> >> >>> On 26 Mar 2019, at 8:06 pm, Mikko Lehto &lt;mslehto(a)iki.fi >>> <mailto:mslehto@iki.fi>> wrote:>>> >>> Andrew White &lt;andrew(a)uconnected.com.au

>>>> I’m currently playing with the UAC module to hand off remote >>>> registrations with trunks to Kamailio. >>>> >>>> I want to keep Kamailio’s external connections low, so I’m planning to >>>> use db_text to load the UAC info, and populate the flat file via other >>>> methods. >>>> >>>> When attempting to load my UAC DB via db_text however, I get the >>>> following: >>>> >>>> Mar 26 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: >>>> db_text [dbt_lib.c:143]: dbt_cache_get_db(): database >>>> [/etc/kamailio/uac.db] does not exists! Mar 26 04:59:30 ip-10-0-0-2 >>>> /usr/local/sbin/kamailio[31902]: INFO: jsonrpcs [jsonrpcs_sock.c:443]: >>>> jsonrpc_dgram_process(): a new child 0/31902 Mar 26 04:59:30 >>>> ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: db_text >>>> [dbt_base.c:102]: dbt_init(): cannot get the link to database Mar 26 >>>> 04:59:30 ip-10-0-0-2 /usr/local/sbin/kamailio[31904]: ERROR: uac >>>> [uac_reg.c:1318]: uac_reg_load_db(): failed to connect to the database >>>> . >>>> . >>>> . >>>> 2) Why is my db_text failing to load the file? >>> >>> Hi >>> >>> I think your db_url should point to directory instead of file. >>> >>> >>> Here is one working example using other modules: >>> --- >>> modparam("mtree", "db_url", "text:///opt/stuff/cfg/db_text >>> <text:///opt/stuff/cfg/db_text>") modparam("htable", "db_url", >>> "text:///opt/stuff/cfg/db_text <text:///opt/stuff/cfg/db_text>") --- >>> >>> In directory /opt/stuff/cfg/db_text I have files "htable", "mtrees" and >>> "version": >>> >>> --- >>> $ cat version >>> htable:2 >>> mtrees:2 >>> $ cat mtrees >>> id(int,auto) tname(string) tprefix(string) tvalue(string) >>> 1:uni:3581234567:24 >>> $ cat htable >>> id(int,auto) key_name(string) key_type(int) value_type(int) >>> key_value(string) >>> 0:3581234567\:\:timerc:0:1:30 >>> ---