<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Shahid Tel escribió:
<blockquote
cite="mid:c6c7fd510907071526p2d57045bkba82bf94a0248f60@mail.gmail.com"
type="cite">
<div>Hi Guys,<br>
<br>
As it looks like from CLI command " show cdr mysql " , can somebody
confirms that cdr-mysql creates persistent connection with in asterisk?<br>
<br>
" show cdr mysql " shows " connected to <a moz-do-not-send="true"
href="mailto:user@dbhost">user@dbhost</a> from 18 hours ......."</div>
<div> </div>
</blockquote>
Yes, the MySQL CDR addon creates a persistent connection to the
database. If the database server goes down, the addon tries to
reconnect so if it succeeds no records are lost or only a few, I'm not
sure. The addon won't die, neither asterisk. For example:<br>
<br>
"cdr mysql status" CLI command shows me this:<br>
<br>
Connected to <user>@<IP>, port 3306 using table
<table> for 19 days, 19 hours, 32 minutes, 2 seconds.<br>
Wrote 4256045 records since last restart and 294847 records since
last reconnect.<br>
<br>
Restart is the last asterisk restart. Last reconnect, is the last time
the connection went down and reconnected because the server went down
or you killed the connection from the MySQL monitor. So if for any
reason you need to do a quick restart of MySQL, you won't lose CDR
records if no calls are hungup during the MySQL restart cycle.<br>
<br>
Cheers,<br>
<pre class="moz-signature" cols="72">--
Ing. Miguel Molina
Grupo de Tecnología
Millenium Phone Center
</pre>
</body>
</html>