<div dir="ltr"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="color:rgb(51,0,153)">Hi Jonas Kellens,<br><br>Like everybody else, I also recommend to upgrade your Asterisk version, and replace mysql driver with odbc. the one big advantage of odbc driver is its pooling feature, you can configure odbc to create a reusable pool of active connections, so Asterisk does't needs to reconnect for each query. <br><br>For example with following odbc settings you can achieve 500+ concurrent channels (approx 2500 queries / minute) without any performance issue.</div><div class="gmail_default" style="color:rgb(51,0,153)"><br></div><div class="gmail_default"><div class="gmail_default" style="color:rgb(51,0,153)">pooling => yes</div><div class="gmail_default"><font color="#330099">limit => 16</font><br><font color="#330099">pre-connect => yes<br></font><br></div><div class="gmail_default" style="color:rgb(51,0,153)">Regards</div><div class="gmail_default" style="color:rgb(51,0,153)"><br></div></div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Nasir Iqbal<br><br>ICTBroadcast - an <a href="https://www.ictbroadcast.com/how-become-internet-telephony-service-provider-itsp-using-ictbroadcast-sp-edition" target="_blank">Auto Dialer software for ITSP</a><div>SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns</div><div><a href="http://www.ictbroadcast.com/" target="_blank">http://www.ictbroadcast.com/</a><br></div></div></div></div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Oct 5, 2018 at 4:26 AM John Novack <<a href="mailto:jnovack@comcast.net">jnovack@comcast.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<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="m_6657569798807467392moz-cite-prefix">Jonas Kellens wrote:<br>
</div>
<blockquote type="cite">
<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="m_6657569798807467392moz-cite-prefix">Op 04-10-18 om 17:49 schreef John
Novack:<br>
</div>
<blockquote type="cite">
<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="m_6657569798807467392moz-cite-prefix">Jonas Kellens wrote:<br>
</div>
<blockquote type="cite">
<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="m_6657569798807467392mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<pre class="m_6657569798807467392moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</blockquote>
<br>
<br>
<fieldset class="m_6657569798807467392mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<pre class="m_6657569798807467392moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</div>
-- <br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Astricon is coming up October 9-11! Signup is available at: <a href="https://www.asterisk.org/community/astricon-user-conference" rel="noreferrer" target="_blank">https://www.asterisk.org/community/astricon-user-conference</a><br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wiki/display/AST/Getting+Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></blockquote></div>