[Spce-user] sip registration stuck 3.5.16

[Aziz Palmer]

I also have 4 nics

eth0
web_ext

eth1
sip_ext

eth2
rtp_ext

eth3
ssh_ext

the rest is standard

+-----+--------------------+--------+--------------------------------------------+----------+-------------------------------------------------------+---------------------+-------+-------------------------------------------------+------+---------------------+-------+--------+---------------------+--------------------+---------+-----------------------+--------+----------+
| id  | username           | domain | contact                                    | received | path                                                  | expires             | q     | callid                                          | cseq | last_modified       | flags | cflags | user_agent          | socket             | methods | ruid                  | reg_id | instance |
+-----+--------------------+--------+--------------------------------------------+----------+-------------------------------------------------------+---------------------+-------+-------------------------------------------------+------+---------------------+-------+--------+---------------------+--------------------+---------+-----------------------+--------+----------+
|  99 | master.sample.edge | NULL   | sip:master.sample.edge at 104.34.42.10:5060 | NULL     | <sip:lb at 127.0.0.1;lr;socket=sip:117.152.244.201:5060> | 2014-11-12 21:22:01 | -1.00 | 1f2b2c7e4142023636e4cffd33fd03ac at 104.34.42.10 |  130 | 2014-11-12 21:20:01 |     0 |      0 | FPBX-2.11.0(11.7.0) | udp:127.0.0.1:5062 |    NULL | uloc-54641ecf-35b4-1  |      0 | NULL     |
| 100 | master.sample.edge | NULL   | sip:master.sample.edge at 104.34.42.10:5060 | NULL     | <sip:lb at 127.0.0.1;lr;socket=sip:117.152.244.201:5060> | 2014-11-12 23:39:43 | -1.00 | 0c271bd71629b10e05953f1f4a1861a9 at 104.34.42.10 |  147 | 2014-11-12 23:37:43 |     0 |      0 | FPBX-2.11.0(11.7.0) | udp:127.0.0.1:5062 |    NULL | uloc-54642080-57c9-01 |      0 | NULL     |
| 101 | master.sample.edge | NULL   | sip:master.sample.edge at 104.34.42.10:5060 | NULL     | <sip:lb at 127.0.0.1;lr;socket=sip:117.152.244.201:5060> | 2014-11-13 07:31:55 | -1.00 | 7233034d51f47c1a7ca56eb2353030ae at 104.34.42.10 |  461 | 2014-11-13 07:29:55 |     0 |      0 | FPBX-2.11.0(11.7.0) | udp:127.0.0.1:5062 |    NULL | uloc-54642080-57ce-c  |      0 | NULL     |
+-----+--------------------+--------+--------------------------------------------+----------+-------------------------------------------------------+---------------------+-------+-------------------------------------------------+------+---------------------+-------+--------+---------------------+--------------------+---------+-----------------------+--------+----------+




________________________________________
From: Spce-user [spce-user-bounces at lists.sipwise.com] on behalf of Victor Seva [vseva at sipwise.com]
Sent: Thursday, November 13, 2014 5:12 AM
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] sip registration stuck 3.5.16

On 11/13/2014 02:00 PM, Aziz Palmer wrote:
> kamailio.location
> what command do I need to execute to provide this information?
>

mysql -e "select * from kamailio.location;"

> what does this mean "WARNING: app_lua [app_lua_sr.c:100]: lua_sr_log(): lost database connection. Reconnecting"?

Means that the connection that app_lua has was disconnected or not
existent. mysql disconnects idle connections automatically. This is not
a problem at all, expected behavior on non high busy servers.