[SR-Users] DBText does not exists!
Andrew White
andrew at uconnected.com.au
Tue Mar 26 15:23:05 CET 2019
Hi all,
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 at uconnected.com.au
Web: www.uConnected.com.au
> On 27 Mar 2019, at 12:23 am, Andrew White <andrew at uconnected.com.au> 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 <andrew at uconnected.com.au <mailto:andrew at 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 at 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 at uconnected.com.au <mailto:andrew at uconnected.com.au>
>> Web: www.uConnected.com.au <http://www.uconnected.com.au/>
>>
>>> On 26 Mar 2019, at 8:06 pm, Mikko Lehto <mslehto at iki.fi <mailto:mslehto at iki.fi>> wrote:
>>>
>>> Andrew White <andrew at uconnected.com.au <mailto:andrew at 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
>>> ---
>>>
>>> --
>>> Mikko
>>>
>>> _______________________________________________
>>> Kamailio (SER) - Users Mailing List
>>> sr-users at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190327/7c85e9df/attachment.html>
More information about the sr-users
mailing list