thr3ads.net - asterisk users - [asterisk-users] Spontaneous reboot due to MySQL lookups ? [Oct 2018]

If this information is useful, please help other people find it:
Share via:

Jonas Kellens

2018-Oct-04 15:10 UTC

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

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 at 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 at 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 at 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 at 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 at 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 at 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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181004/e150402e/attachment.html>

Antony Stone

2018-Oct-04 15:36 UTC

head link

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

On Thursday 04 October 2018 at 17:10:01, Jonas Kellens wrote:
> Hello
> 
> using Asterisk 1.8.32.
Ooh, vintage :)
> 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 ?
I would recommend (a) update to a current and supported version of Asterisk, 
and (b) use the ODBC driver.

If the problem persists then with that setup you're more likely to get help 
here or be able to file a bug report, but no-one's going to fix a problem in
1.8
now.


Regards,


Antony.

-- 
3 logicians walk into a bar. The bartender asks "Do you all want a
drink?"
The first logician says "I don't know."
The second logician says "I don't know."
The third logician says "Yes!"

                                                   Please reply to the list;
                                                         please *don't* CC
me.

John Novack

2018-Oct-04 15:49 UTC

head link

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

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 at
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 at
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
at 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
at 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 at
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 at
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181004/34745a47/attachment.html>

Jonas Kellens

2018-Oct-04 19:35 UTC

head link

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

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 at 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 at 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 at 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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181004/3bfd3409/attachment.html>

Seemingly Similar Threads

Search for more apparently analagous threads

asterisk users - Oct 2018 - Spontaneous reboot due to MySQL lookups ?

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

[asterisk-users] Spontaneous reboot due to MySQL lookups ?

Seemingly Similar Threads