Summary:ASTERISK-10030: Brand new bug: Asterisk dose not load information from mysql
Reporter:Denes Dolhay (denke)Labels:
Date Opened:2007-08-06 07:39:04Date Closed:2007-08-06 09:08:40
Versions:Frequency of
Description:Hi all!
This is a new bug created today, or yesterday.
Im useing realtime with mysql, storeing sip accounts under a mysql realtime dynamic table.
The new issue is, that asterisk query-es the database for the account, which it is eeking for, but does not load the info from the respond from mysql (at least it dose not use the hostname given in the database.)


[Aug  6 14:48:00] DEBUG[12434]: res_config_mysql.c:650 mysql_reconnect: MySQL RealTime: Everything is fine.
[Aug  6 14:48:00] DEBUG[12434]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_realtime WHERE name = 'voiparound'
[Aug  6 14:48:00] WARNING[12434]: chan_sip.c:2840 create_addr: No such host: voiparound

but there is a line in that table where `name` is voiparound, and `host` is 'sip.voiparound.com', amd I get back that line from mysql if I copy the query to mysql, and exec it.

It worked properely until I downloaded the latest snapshot today.
Comments:By: Denes Dolhay (denke) 2007-08-06 08:00:34

Now I can see, there is a problem with inbound sip registrations too.

By: Tilghman Lesher (tilghman) 2007-08-06 09:08:40

Should be fixed in 78164.  Reopen if this is still broken.