[asterisk-bugs] [Asterisk 0013603]: [patch] Database from extconfig.conf ignored

[Asterisk Bug Tracker]

The following issue has been RESOLVED. 
====================================================================== 
http://bugs.digium.com/view.php?id=13603 
====================================================================== 
Reported By:                atis
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   13603
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     resolved
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases): 1.6.0 
SVN Revision (number only!): 595 
Disclaimer on File?:        N/A 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2008-10-02 08:34 CDT
Last Modified:              2008-11-10 14:25 CST
====================================================================== 
Summary:                    [patch] Database from extconfig.conf ignored
Description: 
For example if i set in res_mysql.conf:
dbname = asteriskcdrdb

and in extconfig.conf:
sippeers => mysql,asterisk,sip_buddies
sipusers => mysql,asterisk,sip_buddies

i get:
[Oct  2 06:21:09] DEBUG[16812] res_config_mysql.c: MySQL RealTime:
Connection okay.
[Oct  2 06:21:09] DEBUG[16812] res_config_mysql.c: MySQL RealTime:
Retrieve SQL: SELECT * FROM sip_buddies WHERE name = '90132'
[Oct  2 06:21:09] WARNING[16812] res_config_mysql.c: MySQL RealTime:
Failed to query database. Check debug for more info.        

It seems that refactoring of res_config_mysql missed switch to correct
database at some point. In 1.4 code I've found that database name is passed
to mysql_reconnect, however in 1.6 there's some handle structure. 

Of course i could use one db for everything, but i would want to have
queue_log next to cdr, so main config can be backed up easily :)
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0005881 [patch] Allow use of separate MySQL ser...
====================================================================== 

---------------------------------------------------------------------- 
 (0094716) svnbot (reporter) - 2008-11-10 14:25
 http://bugs.digium.com/view.php?id=13603#c94716 
---------------------------------------------------------------------- 
Repository: asterisk-addons
Revision: 690

U   branches/1.6.0/configs/res_mysql.conf.sample
U   branches/1.6.0/res/res_config_mysql.c

------------------------------------------------------------------------
r690 | tilghman | 2008-11-10 14:25:48 -0600 (Mon, 10 Nov 2008) | 7 lines

Fix specification of different databases in extconfig.conf when using
MySQL
backend.  This fixes a regression.
(closes issue http://bugs.digium.com/view.php?id=13603)
 Reported by: atis
 Patches: 
       multi_db.patch uploaded by atis (license 242)

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk-addons?view=rev&revision=690 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-11-10 14:25 svnbot         Checkin                                      
2008-11-10 14:25 svnbot         Note Added: 0094716                          
2008-11-10 14:25 svnbot         Status                   assigned => resolved
2008-11-10 14:25 svnbot         Resolution               reopened => fixed   
======================================================================