[SR-Users] DBText does not exists!
Andrew White
andrew at uconnected.com.au
Wed Mar 27 15:29:10 CET 2019
Hi Henning,
Thanks for this! That’s not actually the issue though. On one of my instances no registration at all was being sent. On the other, it was. I was using dummy credentials just to see if I could get a REGISTER message.
I’ve since rebuilt my deployment as a playbook and launched to a fresh AL2/EC2 instance, and all is working. Guess it was something specific to the old machine.
Thanks for your help all!
Cheers,
________________________________
Andrew White - Director
uConnected
Email: andrew at uconnected.com.au
Web: www.uConnected.com.au
> On 27 Mar 2019, at 6:33 am, Henning Westerholt <hw at kamailio.org> wrote:
>
> Am Dienstag, 26. März 2019, 15:23:05 CET schrieb Andrew White:
>> 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.
>
> Hello Andrew,
>
> the error below is from the config, that it can't resolve the sip.example.com
> domain. You need to replace this domain with a domain that you own, or use IP
> addresses.
>
> Best regards,
>
> Henning
>
>
>> 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
>>>>> ---
>
>
> --
> Henning Westerholt - https://skalatan.de/blog/
> Kamailio services - https://skalatan.de/services
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190328/d710959a/attachment.html>
More information about the sr-users
mailing list