[Asterisk-Users] Realtime UPDATE

[Rod Bacon]

I found the logging stuff.

Here is the * debug info.


Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:117 realtime_mysql: MySQL 
RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
    -- SIP Seeding peers from Astdb: '9999' at 9999 at 192.168.0.137:5060 for 
3600
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:117 realtime_mysql: MySQL 
RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
    -- SIP Seeding peers from Astdb: '9999' at 9999 at 192.168.0.137:5060 for 
3600
    -- Unregistered SIP '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:311 update_mysql: MySQL 
RealTime: Update SQL: UPDATE sip SET ipaddr = '', port = '', regseconds = 
'0', username = '9999' WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:330 update_mysql: MySQL 
RealTime: Updated 0 rows on table: sip
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:117 realtime_mysql: MySQL 
RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
Apr  7 09:09:20 DEBUG[3672]: db.c:177 ast_db_get: Unable to find key '9999' 
in family 'SIP/Registry'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:117 realtime_mysql: MySQL 
RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
Apr  7 09:09:20 DEBUG[3672]: db.c:177 ast_db_get: Unable to find key '9999' 
in family 'SIP/Registry'
    -- Registered SIP '9999' at 192.168.0.137 port 5060 expires 3600
    -- Saved useragent "Grandstream BT100 1.0.5.22" for peer 9999
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:311 update_mysql: MySQL 
RealTime: Update SQL: UPDATE sip SET ipaddr = '', port = '', regseconds = 
'0', username = '9999' WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:330 update_mysql: MySQL 
RealTime: Updated 0 rows on table: sip
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:117 realtime_mysql: MySQL 
RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '9999'
Apr  7 09:09:20 DEBUG[3672]: res_config_mysql.c:605 mysql_reconnect: MySQL 
RealTime: Everything is fine.
    -- SIP Seeding peers from Astdb: '9999' at 9999 at 192.168.0.137:5060 for 
3600
Apr  7 09:09:35 DEBUG[3672]: chan_sip.c:937 __sip_autodestruct: Auto 
destroying call 'cdb927ab9f85be9f at 192.168.0.137'



----- Original Message ----- 
From: "Rod Bacon" <rod.bacon at empoweredcomms.com.au>
To: <asterisk-users at lists.digium.com>
Sent: Thursday, April 07, 2005 9:06 AM
Subject: [Asterisk-Users] Realtime UPDATE


> I'm sorry if this has been answered before, but I've been through all the 
> (lengthy) threads on Realtime, and can't find the answer.
>
> My problem is that upon registration, the UA's IP address and port 
> information isn't being written to the MYSQL realtime database. 
> Subsequently, calls to the UA fail if they originate from another * server 
> (The server DOES attempt a lookup, but obviously gets no value for IP 
> address / PORT).
>
> From the MYSQL logs, I see the folowing at registration;
>
> UPDATE sip SET ipaddr = '', port = '', regseconds = '0', username = '9998' 
> WHERE name = '9998'
>
> The weird thing is that it was working at some point yesterday.
>
> Can anyone suggest a place to start looking?
>
> Also, how do I enable debug logging so I can see the realtime info in the 
> * CLI or logs?
>
>
> -- 
> ==========================================
> Rod Bacon - VOIP Systems Engineer
> Empowered Communications
> Ground Floor, 102 York St. South Melbourne
> Victoria, Australia. 3205
> Phone: +613 99401600    Fax: +613 99401650
> ==========================================
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>