[asterisk-bugs] [Asterisk 0015375]: [patch] realtime mysql status always shows connected for 0 seconds/no connection

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15375 
====================================================================== 
Reported By:                kowalma
Assigned To:                lmadsen
====================================================================== 
Project:                    Asterisk
Issue ID:                   15375
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.6.1.1 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-06-22 06:31 CDT
Last Modified:              2009-07-03 11:58 CDT
====================================================================== 
Summary:                    [patch] realtime mysql status always shows connected
for 0 seconds/no connection
Description: 
I've found issue with DB connection.

Asterisk-node1(active):/usr/src#  rasterisk  -x "realtime mysql status"
general connected to asterisk at 127.0.0.1, port 3306 with username cdr for 0
seconds.
Asterisk-node1(active):/usr/src#

shows always 0 seconds. Sometime rt shows that there is no db connection
(and then sip show peers show no sip-peer configured) but DB is queried
====================================================================== 

---------------------------------------------------------------------- 
 (0107395) tilghman (administrator) - 2009-07-03 11:58
 https://issues.asterisk.org/view.php?id=15375#c107395 
---------------------------------------------------------------------- 
kowalma:  This is actually expected behavior, but it can be configured on
the MySQL server side.  The issue is that idle connections are dropped. 
The connection time reflects the amount of time that the connection is
actually up, not the time that Asterisk is up (for that, see 'core show
uptime'). 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-07-03 11:58 tilghman       Note Added: 0107395                          
======================================================================