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