<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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>
</body>
</html>