Asterisk RealTime Extensions Problem

Asterisk Asterisk Support
1

I have made settings in extensions.conf as described below

[from-sip]
switch => Realtime/@realtime_ext

and made entries in extconfig.conf file as follow
realtime_ext => mysql,tdirect,textensions

i have database in mysql named "tdirect"
and for extensions the table named “textensions”

Asterisk is showing following lines and no call can be established between sip clients

*CLI> – Registered SIP ‘333’ at 10.0.0.12 port 50126 expires 3600
Jul 19 21:02:28 WARNING[6134]: res_config_mysql.c:331 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
– SIP Seeding peer from astdb: ‘333’ at 333@10.0.0.12:50126 for 3600
– Registered SIP ‘444’ at 10.0.0.13 port 40062 expires 3600
Jul 19 21:02:37 WARNING[6134]: res_config_mysql.c:331 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info.
– SIP Seeding peer from astdb: ‘444’ at 444@10.0.0.13:40062 for 3600
– SIP Seeding peer from astdb: ‘444’ at 444@10.0.0.13:40062 for 3600
– Executing Dial(“SIP/444-8c09”, “SIP/333,20”)
Jul 19 21:02:45 WARNING[6147]: chan_sip.c:1980 create_addr: No such host: 333,20
Jul 19 21:02:45 NOTICE[6147]: app_dial.c:1040 dial_exec_full: Unable to create channel of type ‘SIP’ (cause 3 - No route to destination)

2

I was having the same problem. my probelm was caused because i had “cleaned” up my database and removed things i didnt think i’d need, and while doing this i removed things that asterisk needed. so to fix it, i made the database as described on the voip info wiki and just left everything there, while only using the fields i needed.

hope that helps

-Eric

3

asterisk tells You to "Check debug for more info"
did You check it ?

res_config_mysql.c gives You that warning, so res_config_mysql is first in line to check
there is possibility that this file is misconfigured. post it.

-FD