# Asterisk RealTime Extensions Problem

**URL:** <https://community.asterisk.org/t/asterisk-realtime-extensions-problem/7905>\
**Category:** Asterisk Support\
**Created:** [July 19, 2006, 4:17pm UTC](https://community.asterisk.org/t/asterisk-realtime-extensions-problem/7905 "2006-07-19T16:17:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aleem6](https://avatars.discourse-cdn.com/v4/letter/a/43a26b/32.png) [@aleem6](https://community.asterisk.org/u/aleem6)\
**Post date:** [July 19, 2006, 4:17pm UTC](https://community.asterisk.org/t/asterisk-realtime-extensions-problem/7905/1 "2006-07-19T16:17:43Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![eric\_f](https://avatars.discourse-cdn.com/v4/letter/e/48db29/32.png) [@eric\_f](https://community.asterisk.org/u/eric_f)\
**Post date:** [July 20, 2006, 6:31pm UTC](https://community.asterisk.org/t/asterisk-realtime-extensions-problem/7905/2 "2006-07-20T18:31:47Z")

</div>

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](http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip) and just left everything there, while only using the fields i needed.

hope that helps

-Eric

---

<div class="post-metadata">

**Author:** ![chipsake](https://avatars.discourse-cdn.com/v4/letter/c/278dde/32.png) [@chipsake](https://community.asterisk.org/u/chipsake)\
**Post date:** [July 20, 2006, 7:12pm UTC](https://community.asterisk.org/t/asterisk-realtime-extensions-problem/7905/3 "2006-07-20T19:12:37Z")

</div>

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