Or better still, skip straight to the current LTS version 16 which was release a few days ago, supported right through until 10-2023!
If you're going to do a big upgrade, might as well leap onto the current release :) https://wiki.asterisk.org/wiki/display/AST/Asterisk+Versions On Fri, 12 Oct 2018 at 09:40, Jonas Kellens <jonas.kell...@telenet.be> wrote: > > Hello > > thank you for your answer. > > 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. > > If Asterisk 13 handels MYSQL connections in a better way, then indeed I > should look for upgrade. > > > > Kind regards. > > > > Op 05-10-18 om 01:25 schreef John Novack: > > As others have said, clearly it ISN'T "just working" or you would not have > posted the question > > 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 > > 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 > > 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. > > Although I may be using it quite differently that you, it simply works. > Is this a newly developing issue, or has it persisted for some time > What if any changes have been made to the dialplan etc? > > Have you considered a strictly hardware issue? Memory? HD? MB?? > > The crystal ball is very cloudy on this one! > > John Novack > > > Jonas Kellens wrote: > > Hello > > thank you for your answer. > > 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 ? > > > You should know that the MySQL database is heavily questioned : > > > mysql> show status like '%onn%'; > +--------------------------+--------+ > | Variable_name | Value | > +--------------------------+--------+ > | Aborted_connects | 469 | > | Connections | 132762 | > | Max_used_connections | 8 | > | Ssl_client_connects | 0 | > | Ssl_connect_renegotiates | 0 | > | Ssl_finished_connects | 0 | > | Threads_connected | 3 | > +--------------------------+--------+ > 7 rows in set (0.00 sec) > > > > I stick to 1.8 because it just works. I had some issues with version 11 and > 13 in the past. > > > Regards > > Jonas. > > > Op 04-10-18 om 17:49 schreef John Novack: > > Woefully out of date. > You really need to put your efforts into at least a modest upgrade > 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 > > 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. > > Given that even version 11 is EOL, you really need to put your efforts into > doing the migration rather than tracking this one down > > JMO > > John Novack > > > > Jonas Kellens wrote: > > Hello > > using Asterisk 1.8.32. > > I notice that there is a spontaneous reboot of the Asterisk system from time > to time. > > 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. > > 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. > > > An idea how to overcome this problem ? Seems a "performance" issue, no ?! > > 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) ? > > > Here are some examples from the verbose file. > > > > [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 > [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 > [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 > [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 > [Aug 22 15:19:18] VERBOSE[3306] manager.c: [Aug 22 15:19:18] == Manager > registered action DataGet > [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 > [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] Asterisk Dynamic > Loader Starting: > [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 > [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 > [Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug 22 15:19:18] == > MySQL RealTime driver loaded. > [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > [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 > [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 > [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 > [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 > [Aug 22 16:23:32] VERBOSE[24309] manager.c: [Aug 22 16:23:32] == Manager > registered action DataGet > [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 > [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32] Asterisk > Dynamic Loader Starting: > [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 > [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 > [Aug 22 16:23:32] VERBOSE[24309] res_config_mysql.c: [Aug 22 16:23:32] == > MySQL RealTime driver loaded. > [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > [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 > [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 > [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 > [Oct 4 10:11:29] VERBOSE[4961] manager.c: [Oct 4 10:11:29] == Manager > registered action DataGet > [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 > [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29] Asterisk Dynamic > Loader Starting: > [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 > [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 > [Oct 4 10:11:29] VERBOSE[4961] res_config_mysql.c: [Oct 4 10:11:29] == > MySQL RealTime driver loaded. > [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > > Kind regards > > Jonas. > > > > > > -- > > Dog is my Co-pilot > > > > > > -- > > Dog is my Co-pilot > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Astricon is coming up October 9-11! Signup is available at: > https://www.asterisk.org/community/astricon-user-conference > > Check out the new Asterisk community forum at: https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Astricon is coming up October 9-11! Signup is available at: https://www.asterisk.org/community/astricon-user-conference Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users