<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello</p>
<p>thank you for your answer.</p>
<p>This does not happen all the time. It happens about once every 4
months. I just can not pinpoint WHEN exactly it occurs. I just see
in the verbose logfile that it occurs after a MYSQL
insert/update/delete statement.</p>
<p>If Asterisk 13 handels MYSQL connections in a better way, then
indeed I should look for upgrade.<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>Kind regards.<br>
</p>
<p><br>
</p>
<br>
<div class="moz-cite-prefix">Op 05-10-18 om 01:25 schreef John
Novack:<br>
</div>
<blockquote type="cite"
cite="mid:6817cb22-0cfd-dded-7544-93fdf471ec1b@comcast.net">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<font size="+1">As others have said, clearly it ISN'T "just
working" or you would not have posted the question<br>
<br>
To state again, I am using Version 13, though a few minor
revisions behind, with MySql, on CentOS 6 and have no rebooting
or other MySql related issues<br>
<br>
Clearly you need to state in more detail what issues remain,
once you migrate to AT LEAST 13.xx, and state your OS after
becoming current with Asterisk, MySql and the OS<br>
<br>
I use MySql on every incoming call, and also maintain call
detail records in MySql for every call, and it just simply
works, and has for some time.<br>
<br>
Although I may be using it quite differently that you, it simply
works. <br>
Is this a newly developing issue, or has it persisted for some
time<br>
What if any changes have been made to the dialplan etc?<br>
<br>
Have you considered a strictly hardware issue? Memory? HD? MB??<br>
<br>
The crystal ball is very cloudy on this one!<br>
<br>
John Novack<br>
<br>
</font><br>
<div class="moz-cite-prefix">Jonas Kellens wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1586b7ba-61c4-e0a1-24fc-f6e5902668f3@telenet.be">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<p><font face="Helvetica, Arial, sans-serif">Hello</font></p>
<p><font face="Helvetica, Arial, sans-serif">thank you for your
answer.</font></p>
<p><font face="Helvetica, Arial, sans-serif">If I read your (and
others) reaction correctly I can conclude that this is an
Asterisk problem and not a problem of MySQL or dialplan
logic ?</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">You should know
that the MySQL database is heavily questioned :</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">mysql> show
status like '%onn%';<br>
+--------------------------+--------+<br>
| Variable_name | Value |<br>
+--------------------------+--------+<br>
| Aborted_connects | 469 |<br>
| Connections | 132762 |<br>
| Max_used_connections | 8 |<br>
| Ssl_client_connects | 0 |<br>
| Ssl_connect_renegotiates | 0 |<br>
| Ssl_finished_connects | 0 |<br>
| Threads_connected | 3 |<br>
+--------------------------+--------+<br>
7 rows in set (0.00 sec)<br>
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">I stick to 1.8
because it just works. I had some issues with version 11 and
13 in the past.<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Regards</font></p>
<p><font face="Helvetica, Arial, sans-serif">Jonas.</font><br>
</p>
<br>
<div class="moz-cite-prefix">Op 04-10-18 om 17:49 schreef John
Novack:<br>
</div>
<blockquote type="cite"
cite="mid:763b4ac9-5bbd-4f7a-144c-5cf32b2a339d@comcast.net">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<font size="+1">Woefully out of date.<br>
You really need to put your efforts into at least a modest
upgrade<br>
I use version 13 with MySql queries built into the dialplan
on CentOs 6 and have NO such issues, either performance or
any restart or reboot. It simply works<br>
<br>
I never used either 1.6 or 1.8, going from 1.4 to version
11, which did require some syntax changes to the dialplan.<br>
<br>
Given that even version 11 is EOL, you really need to put
your efforts into doing the migration rather than tracking
this one down<br>
<br>
JMO<br>
<br>
John Novack<br>
<br>
<br>
</font><br>
<div class="moz-cite-prefix">Jonas Kellens wrote:<br>
</div>
<blockquote type="cite"
cite="mid:bf23646c-cc52-6744-5748-65727405ff57@telenet.be">
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<font face="Helvetica, Arial, sans-serif"> </font>
<p><font face="Helvetica, Arial, sans-serif">Hello</font></p>
<p><font face="Helvetica, Arial, sans-serif">using Asterisk
1.8.32.<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">I notice that
there is a spontaneous reboot of the Asterisk system
from time to time.</font></p>
<p><font face="Helvetica, Arial, sans-serif">When I look in
the logs (verbose file) I noticed that every time this
occurs it's at a moment that there is a MySQL action, be
it a lookup or an insert/update/delete.</font></p>
<p><font face="Helvetica, Arial, sans-serif">I must say I do
have some MySQL queries that occur in my dialplan when a
call comes in, to look up different actions to perform
on this call.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">An idea how to
overcome this problem ? Seems a "performance" issue, no
?!</font></p>
<p><font face="Helvetica, Arial, sans-serif">Is it better to
have these MySQL queries to be done by an external
script (like a php script that I call with the
System()-command or a SHELL()-command) ?<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Here are some
examples from the verbose file.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
<br>
[Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22
15:19:10] -- Executing [s@sub-GetAlertInfo:3]
MYSQL("SIP/SipAgenT01-0000317d", "Connect connid
localhost myuser mypwd myDB") in new stack<br>
[Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22
15:19:10] -- Executing [s@sub-GetAlertInfo:5]
MYSQL("SIP/SipAgenT01-0000317d", "Query resultid 1
SELECT uri, callinfo FROM distringtone WHERE onoff='1'")
in new stack<br>
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Parsing '/etc/asterisk/logger.conf': [Aug
22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]
== Found<br>
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Parsing '/etc/asterisk/asterisk.conf':
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Found<br>
[Aug 22 15:19:18] VERBOSE[3306] manager.c: [Aug 22
15:19:18] == Manager registered action DataGet<br>
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Parsing '/etc/asterisk/codecs.conf': [Aug
22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]
== Found<br>
[Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22
15:19:18] Asterisk Dynamic Loader Starting:<br>
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Parsing '/etc/asterisk/modules.conf':
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Found<br>
[Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22
15:19:18] == Parsing
'/etc/asterisk/res_config_mysql.conf': [Aug 22 15:19:18]
VERBOSE[3306] config.c: [Aug 22 15:19:18] == Found<br>
[Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug
22 15:19:18] == MySQL RealTime driver loaded.<br>
[Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22
15:19:18] res_config_mysql.so => (MySQL RealTime
Configuration Driver)<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
<br>
[Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22
16:23:25] -- Executing
[s@sub-GetSipAccountdetails:3]
MYSQL("SIP/SipAgenT01-00004184", "Connect connid
localhost myuser mypwd myDB") in new stack<br>
[Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22
16:23:25] -- Executing
[s@sub-GetSipAccountdetails:4]
MYSQL("SIP/SipAgenT01-00004184", "Query resultid 1
SELECT SIPusername, currstatus, available FROM tbl_SIP
WHERE ID="800"") in new stack<br>
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Parsing '/etc/asterisk/logger.conf': [Aug
22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Found<br>
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Parsing '/etc/asterisk/asterisk.conf':
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Found<br>
[Aug 22 16:23:32] VERBOSE[24309] manager.c: [Aug 22
16:23:32] == Manager registered action DataGet<br>
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Parsing '/etc/asterisk/codecs.conf': [Aug
22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Found<br>
[Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22
16:23:32] Asterisk Dynamic Loader Starting:<br>
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Parsing '/etc/asterisk/modules.conf':
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Found<br>
[Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22
16:23:32] == Parsing
'/etc/asterisk/res_config_mysql.conf': [Aug 22 16:23:32]
VERBOSE[24309] config.c: [Aug 22 16:23:32] == Found<br>
[Aug 22 16:23:32] VERBOSE[24309] res_config_mysql.c:
[Aug 22 16:23:32] == MySQL RealTime driver loaded.<br>
[Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22
16:23:32] res_config_mysql.so => (MySQL RealTime
Configuration Driver)<br>
<br>
<br>
<br>
[Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4
10:11:25] -- Executing [s@sub-settings:16]
MYSQL("SIP/SipAgenT01-000008cb", "Connect connid
localhost myuser mypwd myDB") in new stack<br>
[Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4
10:11:25] -- Executing [s@sub-settings:17]
MYSQL("SIP/SipAgenT01-000008cb", "Query resultid 1
SELECT blockID from DID where DID=987654321") in new
stack<br>
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Parsing '/etc/asterisk/asterisk.conf':
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Found<br>
[Oct 4 10:11:29] VERBOSE[4961] manager.c: [Oct 4
10:11:29] == Manager registered action DataGet<br>
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Parsing '/etc/asterisk/codecs.conf':
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Found<br>
[Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4
10:11:29] Asterisk Dynamic Loader Starting:<br>
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Parsing '/etc/asterisk/modules.conf':
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Found<br>
[Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4
10:11:29] == Parsing
'/etc/asterisk/res_config_mysql.conf': [Oct 4 10:11:29]
VERBOSE[4961] config.c: [Oct 4 10:11:29] == Found<br>
[Oct 4 10:11:29] VERBOSE[4961] res_config_mysql.c:
[Oct 4 10:11:29] == MySQL RealTime driver loaded.<br>
[Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4
10:11:29] res_config_mysql.so => (MySQL RealTime
Configuration Driver)<br>
<br>
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Kind regards</font></p>
<p><font face="Helvetica, Arial, sans-serif">Jonas.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font> </p>
<font face="Helvetica, Arial, sans-serif"> </font> <br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</blockquote>
<br>
</body>
</html>