date:20181004

[asterisk-users] CURL to post application/json (David P)

2018-10-04 Thread Stefan Viljoen

>We tried to use the CURL fn to POST json, but it's sent as form data and
>there seems no support for changing the Content-Type header. We switched to
>invoking curl in the shell.

Hi David

If you've got if fixed that way, great.

Just thought I'd comment and share the scripts / manner we use this, using 
CURL, and mention one major gotcha I ran into that took me a few hours to solve 
related with using CURL in Centos 7 on Asterisk 1.8.32.3, and then switching to 
13.22.0.

This is what our dialplan logic looks like to get a UUID from a CURL call made 
in a BASH file to our back-end application's API.

Dialplan:

same=>n,Set(curlResult=${SHELL(/usr/src/bash/getUUID.sh)})
---

BASH file:

getUUID.sh
---
#!/bin/bash
function jsonval {
temp=`echo $jsonResult | sed 's/\//\//g' | sed 's/[{}]//g' | awk -v 
k="text" '{n=split($0,a,","); for (i=1; i<=n; i++) print a[i]}' | sed 
's/\"\:\"/\|/g' | sed 's/[\,]/ /g' | sed 's/\"//g'`
echo ${temp##*|}
}

baseUrl=http://127.0.0.1/api/getUUID

jsonResult=$(curl --connect-timeout 16 --max-time 32 -s -X GET $baseUrl)

uuid=`jsonval`

echo -n $uuid
---

This returns our UUID (from the Java app) into the dialplan variable curlResult 
which we then use further on in the dialplan.

The MAJOR gotcha in this above is the

>echo -n $uuid

line...

On Asterisk 1.8.32.3, this worked fine in the BASH script:

echo $uuid

However, on Asterisk 13.22.0, it did NOT work - the dialplan variable 
curlResult stayed empty on any calls to the BASH script vir SET() in Asterisk.

Turns out that 13.22.0 does NOT like line feed / new line (\n) in ANY strings 
that come back from BASH.

So I had to change the above line in the BASH file to

echo -n $uuid

so that the line-feed / newline was omitted from being returned to the Asterisk 
13 instance.

Just some two cents worth.

Regards

Stefan


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

[asterisk-users] Spontaneous reboot due to MySQL lookups ? (Jonas Kellens)

2018-10-04 Thread Stefan Viljoen

   == 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-4184", "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-4184", "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-08cb", "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-08cb", "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-0001.html>

--

Message: 3
Date: Thu, 4 Oct 2018 17:36:08 +0200
From: Antony Stone 
To: "Asterisk Users Mailing List - Non-Commercial Discussion"

Re: [asterisk-users] CURL to post application/json

2018-10-04 Thread Nasir Iqbal

My mistake, CURLOPT(header) is only to retrieve headers, not to sent. sorry.

Nasir Iqbal

ICTBroadcast - an Auto Dialer software for ITSP

SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns
http://www.ictbroadcast.com/


On Fri, Oct 5, 2018 at 8:53 AM Nasir Iqbal  wrote:

> Hi David,
>
> Have you tried CURLOPT function.
> i.e
> Set(CURLOPT(header)=Content-Type: application/json)
>
> Regards
>
> Nasir Iqbal
>
> ICTBroadcast - an Auto Dialer software for ITSP
> 
> SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns
> http://www.ictbroadcast.com/
>
>
> On Fri, Oct 5, 2018 at 1:59 AM David P  wrote:
>
>> We tried to use the CURL fn to POST json, but it's sent as form data and
>> there seems no support for changing the Content-Type header. We switched to
>> invoking curl in the shell.
>>
>> All the documentation I could find says there is just one parameter for
>> the url and an optional second for POST body. Is there an undocumented way
>> to set Content-Type?
>> --
>> _
>> -- 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

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

2018-10-04 Thread Nasir Iqbal

Hi Jonas Kellens,

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.

For example with following odbc settings you can achieve 500+ concurrent
channels (approx 2500 queries / minute) without any performance issue.

pooling => yes
limit   => 16
pre-connect => yes

Regards

Nasir Iqbal

ICTBroadcast - an Auto Dialer software for ITSP

SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns
http://www.ictbroadcast.com/


On Fri, Oct 5, 2018 at 4:26 AM John Novack  wrote:

> 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-317d", "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-317d", "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

Re: [asterisk-users] CURL to post application/json

2018-10-04 Thread Nasir Iqbal

Hi David,

Have you tried CURLOPT function.
i.e
Set(CURLOPT(header)=Content-Type: application/json)

Regards

Nasir Iqbal

ICTBroadcast - an Auto Dialer software for ITSP

SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns
http://www.ictbroadcast.com/


On Fri, Oct 5, 2018 at 1:59 AM David P  wrote:

> We tried to use the CURL fn to POST json, but it's sent as form data and
> there seems no support for changing the Content-Type header. We switched to
> invoking curl in the shell.
>
> All the documentation I could find says there is just one parameter for
> the url and an optional second for POST body. Is there an undocumented way
> to set Content-Type?
> --
> _
> -- 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

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

2018-10-04 Thread 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-317d", "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-317d", "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-4184", "Connect connid 
localhost myuser mypwd myDB") in new stack
[Aug 22 16:23:25]

[asterisk-users] CURL to post application/json

2018-10-04 Thread David P

We tried to use the CURL fn to POST json, but it's sent as form data and
there seems no support for changing the Content-Type header. We switched to
invoking curl in the shell.

All the documentation I could find says there is just one parameter for the
url and an optional second for POST body. Is there an undocumented way to
set Content-Type?
-- 
_
-- 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

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

2018-10-04 Thread Jonathan H

On Thu, 4 Oct 2018 at 20:36, Jonas Kellens  wrote:

> I stick to 1.8 because it just works.

Well, clearly it doesn't because you're posting here! In a few days time,
the *8-year-old* Asterisk 1.8 line will be *three years past EOL.*
That means End of Life. Do not use. No more support.

Now, if you were to bring yourself onto the current 13.x LTS (or perhaps
better still wait a few days until the 16.x LTS which will be supported
until 2023), then you might get more answers.

> I had some issues with version 11 and 13 in the past.

Especially if you explain what issues you had with version 13 in the past.
-- 
_
-- 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

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

2018-10-04 Thread Jonas Kellens


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-317d", "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-317d", "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-4184", "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-4184", "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:

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

2018-10-04 Thread 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-317d", "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-317d", "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-4184", "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-4184", "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-08cb", "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] 
M

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

2018-10-04 Thread Antony Stone

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.

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

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

2018-10-04 Thread Jonas Kellens


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-317d", 
"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-317d", "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-4184", "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-4184", "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-08cb", "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-08cb", "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:

[asterisk-users] CURL to post application/json (David P)

[asterisk-users] Spontaneous reboot due to MySQL lookups ? (Jonas Kellens)

Re: [asterisk-users] CURL to post application/json

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

Re: [asterisk-users] CURL to post application/json

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

[asterisk-users] CURL to post application/json

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

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

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

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

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

12 matches

Site Navigation

Mail list logo

Footer information