thr3ads.net - asterisk users - [Asterisk-Users] Realtime UPDATE [Apr 2005]

If this information is useful, please help other people find it:
Share via:

Rod Bacon

2005-Apr-06 16:06 UTC

[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
==========================================

Rod Bacon

2005-Apr-06 16:11 UTC

head link

[Asterisk-Users] Realtime UPDATE

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@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@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@192.168.0.137:5060
for
3600
Apr  7 09:09:35 DEBUG[3672]: chan_sip.c:937 __sip_autodestruct: Auto 
destroying call 'cdb927ab9f85be9f@192.168.0.137'



----- Original Message ----- 
From: "Rod Bacon" <rod.bacon@empoweredcomms.com.au>
To: <asterisk-users@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@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
>

Thierry Wehr

2005-Apr-06 16:36 UTC

head link

[Asterisk-Users] Realtime UPDATE

> -----Message d'origine-----
> De : asterisk-users-bounces@lists.digium.com 
> [mailto:asterisk-users-bounces@lists.digium.com] De la part 
> de Rod Bacon
> Envoy? : jeudi 7 avril 2005 01:06
> ? : asterisk-users@lists.digium.com
> Objet : [Asterisk-Users] Realtime UPDATE
> 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).
Hi

I'd the same problem and discovered that you have to put

rtnoupdate=no in you'r sip.conf

Hope it helps you

Thierry

asterisk users - Apr 2005 - Realtime UPDATE

[Asterisk-Users] Realtime UPDATE

[Asterisk-Users] Realtime UPDATE

[Asterisk-Users] Realtime UPDATE