[asterisk-bugs] [Asterisk 0005881]: [patch] Allow use of separate MySQL servers for SELECT and UPDATE queries

[Asterisk Bug Tracker]

The following issue has been set as RELATED TO issue 0013603. 
====================================================================== 
http://bugs.digium.com/view.php?id=5881 
====================================================================== 
Reported By:                voipgate
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   5881
Category:                   Core/Configuration
Reproducibility:            N/A
Severity:                   feature
Priority:                   normal
Status:                     closed
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases): trunk 
SVN Revision (number only!): 356 
Disclaimer on File?:        Yes 
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2005-11-28 16:14 CST
Last Modified:              2008-10-02 08:58 CDT
====================================================================== 
Summary:                    [patch] Allow use of separate MySQL servers for
SELECT and UPDATE queries
Description: 
Hello,
I am using the realtime mysql addon in asterisk-1.2. For testing purposes
I tried to simulate network problems so that asterisk can not connect to
the mysql server. For this tests I just used simple IPTABLES rules on the
asterisk server: 
 - iptables -j DROP -A OUTPUT -d MYSQL_SERVER
 - iptables -j REJECT -A OUTPUT -d MYSQL_SERVER
....

So after installing the iptables rules I did an "realtime mysql status" on
the asterisk-cli. After executing this command the asterisk-cli was no
longer reacting to any commands. I had to quit using CTRL-C and reconnect
with asterisk-rvvvv. 

After this I deleted the iptables rules: iptables --flush. I connect again
to the asterisk-cli and execute "realtime mysql status" After this asterisk
crashes without and hints in any logfile.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0013603 Database from extconfig.conf ignored
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-10-02 08:58 Corydon76      Relationship added       related to 0013603  
======================================================================