[asterisk-bugs] [Asterisk 0013916]: addmin/res_config_mysql - Invalid Database

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
http://bugs.digium.com/view.php?id=13916 
====================================================================== 
Reported By:                visu
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   13916
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 157167 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-11-17 22:17 CST
Last Modified:              2008-11-18 23:52 CST
====================================================================== 
Summary:                    addmin/res_config_mysql - Invalid Database
Description: 
MySQL realtime stopped working on latest trunk 157167. Same database works
fine with older trunk (114093)

Following is warning message I get from asterisk:

[Nov 17 08:56:49] WARNING[29489]: res_config_mysql.c:317 realtime_mysql:
MySQL RealTime: Invalid database specified: ast_db

*CLI> realtime mysql status
general connected to ast_db at 127.0.0.1, port 3306 with username ast_db for
0 seconds.

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

---------------------------------------------------------------------- 
 (0095048) visu (reporter) - 2008-11-18 23:52
 http://bugs.digium.com/view.php?id=13916#c95048 
---------------------------------------------------------------------- 
yes, it is picked up from latest trunk.

Below are content

#cat /etc/asterisk/res_mysql.conf
;
[general]
dbhost = 127.0.0.1
dbname = ast_db 
dbuser = ast_db 
dbpass = somepass
dbport = 3306
;dbsock = /tmp/mysql.sock


# cat /etc/asterisk/extconfig.conf
[settings]
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
sipusers => mysql,ast_db,sip_buddies
sippeers => mysql,ast_db,sip_buddies
extensions => mysql,ast_db,extensions_table
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;queues => odbc,asterisk
;queue_members => odbc,asterisk 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-11-18 23:52 visu           Note Added: 0095048                          
2008-11-18 23:52 visu           Status                   closed => new       
2008-11-18 23:52 visu           Resolution               no change required =>
reopened
======================================================================