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

Asterisk Bug Tracker noreply at bugs.digium.com
Mon Nov 10 12:32:47 CST 2008


A NOTE has been added to this issue. 
====================================================================== 
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:                     closed
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 12:32 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...
====================================================================== 

---------------------------------------------------------------------- 
 (0094714) atis (reporter) - 2008-11-10 12:32
 http://bugs.digium.com/view.php?id=13603#c94714 
---------------------------------------------------------------------- 
Reopening this, until distinct database names can be used for different
families in extconfig.conf

For reference - discussion on asterisk-dev list:

http://lists.digium.com/pipermail/asterisk-dev/2008-November/035129.html 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-11-10 12:32 atis           Note Added: 0094714                          
======================================================================




More information about the asterisk-bugs mailing list