[asterisk-bugs] [Asterisk 0015077]: [patch] Realtime SIP not working in current SVN

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15077 
====================================================================== 
Reported By:                MichaelLinke
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   15077
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!): 147 
Request Review:              
====================================================================== 
Date Submitted:             2009-05-11 06:22 CDT
Last Modified:              2009-05-12 17:00 CDT
====================================================================== 
Summary:                    [patch] Realtime SIP not working in current SVN
Description: 
There seams to be an broken connection beetwen the Aterisk SIP Module in
Realtime mode and res_config_mysql.
Asterisk report an missimg mysql table for alle configured tables in
extconfig.conf.
The mysql server is working and the tables exist. The mysql server log
shows that no request hast been send to the server.
And "realtime mysql status" shows that the realtime module is connected to
the mysql server.
Using the same configurations files, this mysql configuration is working
in Asterisk 1.4 and 1.6.0 without any problems. 
And the  cdr_addon_mysql.c works in this svn version using the same mysql
parameters.

It seams as the there is a bug so that no request is send and so the
asterisk think that there is no table. So the error message is wrong.


====================================================================== 

---------------------------------------------------------------------- 
 (0104632) tilghman (administrator) - 2009-05-12 17:00
 https://issues.asterisk.org/view.php?id=15077#c104632 
---------------------------------------------------------------------- 
Found the problem:

Change your extconfig.conf to:

meetme => mysql,general,meetme
sippeers => mysql,general,sip_intern
sipusers => mysql,general,sip_intern
;sipregs => mysql,general,sip_intern
extensions => mysql,general,dialplan

speak => mysql,general,dialplan_helper_record
record => mysql,general,dialplan_helper_speak

Please see the first 6 lines of UPGRADE.txt in asterisk-addons trunk. 
Note that this is not the same UPGRADE.txt as core Asterisk, but is
specific to asterisk-addons. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-05-12 17:00 tilghman       Note Added: 0104632                          
======================================================================