Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-17 Thread Jonas Kellens
On 09/16/2010 07:58 PM, Paul Belanger wrote:
 Please do not send me direct email, post them to the list for others
 to help.  Your backtrace is optimized (value optimized out).  You
 need to reinstall asterisk with DONT_OPTIMIZE enabled, described in
 doc/backtrace.txt.


Hello,

I have compiled with DONT_OPTIMIZE.

When generating the backtrace, I get the following output now :

[r...@asterisk16 tmp]# ls
core.asterisk16.jocan.local-2010-09-17T10:03:15+0200
[r...@asterisk16 tmp]# gdb -se /usr/sbin/asterisk -ex bt full -ex 
thread apply all bt --batch -c 
/tmp/core.asterisk16.jocan.local-2010-09-17T10\:03\:15+0200  
/tmp/backtrace.txt

warning: exec file is newer than core file.

warning: .dynamic section for /lib/libcrypt.so.1 is not at the 
expected address

warning: difference appears to be caused by prelink, adjusting expectations

warning: .dynamic section for /lib/libnsl.so.1 is not at the expected 
address

warning: difference appears to be caused by prelink, adjusting expectations



Is the backtrace well generated and so can I post it ?! Or will I have 
to make adjustments and do it again ?

Jonas.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-17 Thread Mark Deneen
On Fri, Sep 17, 2010 at 4:21 AM, Jonas Kellens jonas.kell...@telenet.be wrote:

 warning: exec file is newer than core file.

Jonas,

I encourage you to read the output.  Did you run gdb with a core file
dumped from the old build?  You need to generate a new core dump with
the new executable.

Best Regards,
Mark Deneen

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-17 Thread Jonas Kellens
On 09/17/2010 05:29 PM, Mark Deneen wrote:
 On Fri, Sep 17, 2010 at 4:21 AM, Jonas Kellensjonas.kell...@telenet.be  
 wrote:

 warning: exec file is newer than core file.
  
 Jonas,

 I encourage you to read the output.  Did you run gdb with a core file
 dumped from the old build?  You need to generate a new core dump with
 the new executable.

 Best Regards,
 Mark Deneen



1. I have re-compiled asterisk 1.6.2 with dont_optimize
2. I have generated the restart/reload of asterisk that I expercience
3. I have built a backtrace with gdb from the resulting core.pid file

Don't know what I could have been doing wrong...

Jonas.


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-17 Thread Mark Deneen
On Fri, Sep 17, 2010 at 11:51 AM, Jonas Kellens
jonas.kell...@telenet.be wrote:
 On 09/17/2010 05:29 PM, Mark Deneen wrote:
 On Fri, Sep 17, 2010 at 4:21 AM, Jonas Kellensjonas.kell...@telenet.be  
 wrote:

 warning: exec file is newer than core file.

 Jonas,

 I encourage you to read the output.  Did you run gdb with a core file
 dumped from the old build?  You need to generate a new core dump with
 the new executable.

 Best Regards,
 Mark Deneen



 1. I have re-compiled asterisk 1.6.2 with dont_optimize
 2. I have generated the restart/reload of asterisk that I expercience
 3. I have built a backtrace with gdb from the resulting core.pid file

 Don't know what I could have been doing wrong...

 Jonas.

Jonas,

What is the timestamp on your asterisk binary and what is the
timestamp of the core file?

Also, you restarted asterisk after installing the dont_optimize binary?

The message suggests that your core file is older than your
executable, which should not be possible.

Best Regards,
Mark Deneen

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-17 Thread Jonas Kellens

On 09/17/2010 06:00 PM, Mark Deneen wrote:

On Fri, Sep 17, 2010 at 11:51 AM, Jonas Kellens
jonas.kell...@telenet.be  wrote:
   

On 09/17/2010 05:29 PM, Mark Deneen wrote:
 

On Fri, Sep 17, 2010 at 4:21 AM, Jonas Kellensjonas.kell...@telenet.be
wrote:

   

warning: exec file is newer than core file.

 

Jonas,

I encourage you to read the output.  Did you run gdb with a core file
dumped from the old build?  You need to generate a new core dump with
the new executable.

Best Regards,
Mark Deneen


   

1. I have re-compiled asterisk 1.6.2 with dont_optimize
2. I have generated the restart/reload of asterisk that I expercience
3. I have built a backtrace with gdb from the resulting core.pid file

Don't know what I could have been doing wrong...

Jonas.
 

Jonas,

What is the timestamp on your asterisk binary and what is the
timestamp of the core file?

Also, you restarted asterisk after installing the dont_optimize binary?

The message suggests that your core file is older than your
executable, which should not be possible.

Best Regards,
Mark Deneen
   


Thank you for your feedback.

I have stopped asterisk (/sbin/service asterisk stop), then re-compiled 
and then restarted asterisk (/sbin/service asterisk start)


[r...@asterisk16 ~]# ls -l /usr/sbin/asterisk
-rwxr-xr-x 1 root root 15880306 *Sep 17 11:41* /usr/sbin/asterisk
[r...@asterisk16 ~]# ls -l 
/tmp/core.asterisk16.jocan.local-2010-09-17T10\:03\:15+0200
-rw--- 1 root root 16609280 *Sep 17 10:03* 
/tmp/core.asterisk16.jocan.local-2010-09-17T10:03:15+0200



This tells you are right...

Jonas.
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Jonas Kellens

Hello,

I have new information from a newly created test environment :


[Sep 16 13:41:01] -- Executing [...@macro-vakantie:1] 
MYSQL(SIP/test1-0008, Connect connid localhost username passwd 
AsteriskHosted) in new stack
[Sep 16 13:41:01] -- Executing [...@macro-vakantie:2] 
MYSQL(SIP/test1-0008, Query resultid 1 SELECT ast1, ast2, na, 
naID FROM vakantiedata where ID=59) in new stack

asterisk16*CLI
Disconnected from Asterisk server
[Sep 16 13:41:01] Executing last minute cleanups
/usr/sbin/safe_asterisk: line 145:  3508 Segmentation fault  (core 
dumped) nice -n $PRIORITY ${ASTSBINDIR}/asterisk -f ${CLIARGS} 
${ASTARGS}  /dev/${TTY} 21  /dev/${TTY}

Asterisk ended with exit status 139
Asterisk exited on signal 11.


Does this shine new light to the problem ?!

Kind regards,
Jonas.


On 09/15/2010 06:49 PM, jon pounder wrote:

On 09/15/2010 12:42 PM, Leif Madsen wrote:
   

On 10-09-15 05:25 AM, Jonas Kellens wrote:

 

I think I've found it :

Asterisk always reboots on this part :

[Sep 15 11:16:32] -- Goto (azura,pbx,1)
[Sep 15 11:16:32] -- Executing [...@azura:1]
NoOp(SIP/INTERTELin-, 3252480333 = pbx formule) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:2]
Set(SIP/INTERTELin-, CDR(accountcode)=AZURAin) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:3]
Set(SIP/INTERTELin-, BRON=473555006473555006) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:4]
Goto(SIP/INTERTELin-, vakantie) in new stack
[Sep 15 11:16:32] -- Goto (azura,pbx,5)
[Sep 15 11:16:32] -- Executing [...@azura:5]
Macro(SIP/INTERTELin-, vakantie,58) in new stack
[Sep 15 11:16:32] -- Executing [...@macro-vakantie:1]
MYSQL(SIP/INTERTELin-, Connect connid localhost username
passwd AsteriskHosted) in new stack
[Sep 15 11:16:32] -- Executing [...@macro-vakantie:2]
MYSQL(SIP/INTERTELin-, Query resultid 1 SELECT ast1 , ast2 ,
na , naID FROM vakantiedata where ID=58) in new stack
vps2301*CLI
Disconnected from Asterisk server
[Sep 15 11:16:32] Executing last minute cleanups


Dialplan :

[macro-vakantie]
exten =   s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
exten =   s,n,MYSQL(Query resultid ${connid} SELECT ast1 , ast2 , na ,
naID FROM vakantiedata where ID=${ARG1})
exten =   s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID )
exten =   s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na =
${NA} naID = ${naID})
exten =   s,n,MYSQL(Clear ${resultid})
exten =   s,n,MYSQL(Disconnect ${connid})

exten =   s,n,NoOp(fetchid = ${fetchid})
exten =   s,n,GoToIf($[${fetchid}==0]?exit)

exten =   s,n,NoOp()
exten =   s,n,GoToIfTime(${AST1}?opvakantie)
exten =   s,n,GoToIfTime(${AST2}?opvakantie)

exten =   s,n(exit),NoOp()
exten =   s,n,Set(vakantieresult=continue)
exten =   s,n,MacroExit

exten =   s,n(opvakantie),NoOp(op vakantie !)
exten =   s,n,GoToIf($[${NA}=hangup]?hangup:route)


Do you guys see why Asterisk has problems with this part of the dialplan ?!
   


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Philipp von Klitzing
Hi!

 Does this shine new light to the problem ?!

No. Once more: Go and read doc/backtrace.txt.

And check if you have any meaningful information in /var/log/messages for 
the timestamp when asterisk crashed.

Philipp


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Jonas Kellens
On 09/16/2010 12:41 PM, Philipp von Klitzing wrote:
 Hi!

 Does this shine new light to the problem ?!
  
 No. Once more: Go and read doc/backtrace.txt.

 And check if you have any meaningful information in /var/log/messages for
 the timestamp when asterisk crashed.

 Philipp


I get so little output :

Core was generated by `/usr/sbin/asterisk -f -vvvg -c'.
Program terminated with signal 6, Aborted.
#0  0x2b4f70970265 in ?? ()
(gdb) set logging on
Copying output to gdb.txt.
(gdb) bt
#0  0x2b4f70970265 in ?? ()
(gdb) bt full
#0  0x2b4f70970265 in ?? ()
No symbol table info available.
(gdb)


The generated files are also very small :

bash-3.2# ls -lh
total 408M
-rw-rw-r-- 1 root root 4.0K Sep 16 14:17 backtrace.txt
-rw--- 1 root root  42M Sep 15 21:46 core.4569
-rw-rw-r-- 1 root root 2.6K Sep 16 14:17 gdb.txt


I followed the steps in :
---
--- Getting Information After A Crash
---



Jonas.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Paul Belanger
On Thu, Sep 16, 2010 at 8:19 AM, Jonas Kellens jonas.kell...@telenet.be wrote:
 I get so little output :

You are still doing it incorrectly. As said, doc/backtrace.txt has all
the required information.

-- 
Paul Belanger | dCAP
Polybeacon | Consultant
Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode)
blog.polybeacon.com

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Jonas Kellens
On 09/16/2010 05:45 PM, Paul Belanger wrote:
 On Thu, Sep 16, 2010 at 8:19 AM, Jonas Kellensjonas.kell...@telenet.be  
 wrote:

 I get so little output :

  
 You are still doing it incorrectly. As said, doc/backtrace.txt has all
 the required information.


bash-3.2# gdb -se /usr/sbin/asterisk -ex bt full -ex thread apply 
all bt --batch -c /tmp/core.4569  /tmp/backtrace.txt
bash-3.2# ls -lh /tmp/
total 408M
-rw-rw-r-- 1 root root  30K Sep 16 18:09 backtrace.txt


Is it normal that backtrace.txt is only 30K ??


When I do the different steps, I have a lot of output. So I think I'm 
doing it correct now.

Jonas.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Paul Belanger
On Thu, Sep 16, 2010 at 12:11 PM, Jonas Kellens
jonas.kell...@telenet.be wrote:
 Is it normal that backtrace.txt is only 30K ??

Normal or not, simply post the results of backtrace.txt

-- 
Paul Belanger | dCAP
Polybeacon | Consultant
Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode)
blog.polybeacon.com

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-16 Thread Paul Belanger
On Thu, Sep 16, 2010 at 12:46 PM, Paul Belanger
paul.belan...@polybeacon.com wrote:
 On Thu, Sep 16, 2010 at 12:11 PM, Jonas Kellens
 jonas.kell...@telenet.be wrote:
 Is it normal that backtrace.txt is only 30K ??

 Normal or not, simply post the results of backtrace.txt

Please do not send me direct email, post them to the list for others
to help.  Your backtrace is optimized (value optimized out).  You
need to reinstall asterisk with DONT_OPTIMIZE enabled, described in
doc/backtrace.txt.

-- 
Paul Belanger | dCAP
Polybeacon | Consultant
Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode)
blog.polybeacon.com

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens

I think I've found it :

Asterisk always reboots on this part :

[Sep 15 11:16:32] -- Goto (azura,pbx,1)
[Sep 15 11:16:32] -- Executing [...@azura:1] 
NoOp(SIP/INTERTELin-, 3252480333 = pbx formule) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:2] 
Set(SIP/INTERTELin-, CDR(accountcode)=AZURAin) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:3] 
Set(SIP/INTERTELin-, BRON=473555006 473555006) in new stack
[Sep 15 11:16:32] -- Executing [...@azura:4] 
Goto(SIP/INTERTELin-, vakantie) in new stack

[Sep 15 11:16:32] -- Goto (azura,pbx,5)
[Sep 15 11:16:32] -- Executing [...@azura:5] 
Macro(SIP/INTERTELin-, vakantie,58) in new stack
[Sep 15 11:16:32] -- Executing [...@macro-vakantie:1] 
MYSQL(SIP/INTERTELin-, Connect connid localhost username 
passwd AsteriskHosted) in new stack
[Sep 15 11:16:32] -- Executing [...@macro-vakantie:2] 
MYSQL(SIP/INTERTELin-, Query resultid 1 SELECT ast1 , ast2 , 
na , naID FROM vakantiedata where ID=58) in new stack

vps2301*CLI
Disconnected from Asterisk server
[Sep 15 11:16:32] Executing last minute cleanups


Dialplan :

[macro-vakantie]
exten = s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
exten = s,n,MYSQL(Query resultid ${connid} SELECT ast1 , ast2 , na , 
naID FROM vakantiedata where ID=${ARG1})

exten = s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID )
exten = s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na = 
${NA} naID = ${naID})

exten = s,n,MYSQL(Clear ${resultid})
exten = s,n,MYSQL(Disconnect ${connid})

exten = s,n,NoOp(fetchid = ${fetchid})
exten = s,n,GoToIf($[${fetchid}==0]?exit)

exten = s,n,NoOp()
exten = s,n,GoToIfTime(${AST1}?opvakantie)
exten = s,n,GoToIfTime(${AST2}?opvakantie)

exten = s,n(exit),NoOp()
exten = s,n,Set(vakantieresult=continue)
exten = s,n,MacroExit

exten = s,n(opvakantie),NoOp(op vakantie !)
exten = s,n,GoToIf($[${NA}=hangup]?hangup:route)


Do you guys see why Asterisk has problems with this part of the dialplan ?!



Jonas.



On 09/15/2010 10:58 AM, Jonas Kellens wrote:

Hello,

these are my settings in asterisk.conf :

;maxcalls = 10 ; Maximum amount of calls allowed
;maxload = 0.9 ; Asterisk stops accepting new calls if the load 
average exceed this limit

;maxfiles = 1000 ; Maximum amount of openfiles
;minmemfree = 1 ; in MBs, Asterisk stops accepting new calls if the 
amount of free memory falls below this watermark


So I don't think that asterisk restarts/reloads because of the above 
settings ?!



Jonas.


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Philipp von Klitzing
Jonas,

everyone here supports you in your effort to get a good Asterisk 
installation going, but could you ... maybe restrain yourself a little 
bit and reduce the number of hasty postings you are sending to this 
mailing list?

Thank you,
Philipp


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens

Hello Philipp,

I know I post a lot concerning this issue, but this is because this 
problem occurs on a production system and I feel very hot breathing down 
my neck.


I have tested during several weeks my implementation on a test system 
which is similar to the production system. The only difference is : 
test-system on VirtualBox, production system on Xen.


Also now I can not reproduce this reboot of asterisk on my test 
system. While on the production system the part of the dialplan gives 
the spontaneous reboot every time over and over again.


I have now placed this part of the dialplan in comment, and it seems to 
help.


I was wrong yesterday thinking it was a bug in version 1.6.2.11. The 
problem today occurs when the specific macro needs to be executed... Did 
not saw this yesterday...


I hope I have found the *problem* now.


Can you help me with the *solution* please ?!


Kind regards,
Jonas.


On 09/15/2010 12:20 PM, Philipp von Klitzing wrote:

Jonas,

everyone here supports you in your effort to get a good Asterisk
installation going, but could you ... maybe restrain yourself a little
bit and reduce the number of hasty postings you are sending to this
mailing list?

Thank you,
Philipp


   
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Gareth Blades
I cant help you with fixing the actual cause but have you considered 
moving the mysql and as much of the associated logic to an AGI running 
something like a perl or php script. From previous posts that generally 
seems to me the more reliable way of making mysql queries.

Jonas Kellens wrote:
 Hello Philipp,
 
 I know I post a lot concerning this issue, but this is because this 
 problem occurs on a production system and I feel very hot breathing down 
 my neck.
 
 I have tested during several weeks my implementation on a test system 
 which is similar to the production system. The only difference is : 
 test-system on VirtualBox, production system on Xen.
 
 Also now I can not reproduce this reboot of asterisk on my test 
 system. While on the production system the part of the dialplan gives 
 the spontaneous reboot every time over and over again.
 
 I have now placed this part of the dialplan in comment, and it seems to 
 help.
 
 I was wrong yesterday thinking it was a bug in version 1.6.2.11. The 
 problem today occurs when the specific macro needs to be executed... Did 
 not saw this yesterday...
 
 I hope I have found the *problem* now.
 
 
 Can you help me with the *solution* please ?!
 
 
 Kind regards,
 Jonas.
 
 
 On 09/15/2010 12:20 PM, Philipp von Klitzing wrote:
 Jonas,

 everyone here supports you in your effort to get a good Asterisk 
 installation going, but could you ... maybe restrain yourself a little 
 bit and reduce the number of hasty postings you are sending to this 
 mailing list?

 Thank you,
 Philipp


   


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens
On 09/15/2010 12:59 PM, Gareth Blades wrote:
 I cant help you with fixing the actual cause but have you considered
 moving the mysql and as much of the associated logic to an AGI running
 something like a perl or php script. From previous posts that generally
 seems to me the more reliable way of making mysql queries.

I have always used mysql directly in the dialplan. Also, I have several 
other mysql-statements in other parts of the dialplan that do not make 
asterisk crash.

These 2 things make what I'm experciencing odd :

- same setup on TEST-server : no problem
- other mysql-statements in same dialplan : no problem


I have posted the part of the dialplan that makes asterisk reset on this 
mailinglist.
I have also posted the debug log concerning these mysql-lookups.
It is actually very basic. If anyone has feedback, please share.


Jonas.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Philipp von Klitzing
Hi!

 I know I post a lot concerning this issue, but this is because this 
 problem occurs on a production system and I feel very hot breathing down
 my neck.

Why not reduce the pressure and revert to 1.4.30 for the production 
system until you have figued out the issue? That will give you more time 
for (off-hours) testing and a more thorough look at what is going on.

Look in /tmp if you can't find the core file elsewhere.
http://svn.digium.com/svn/asterisk/trunk/doc/HOWTO_collect_debug_informati
on.txt

Philipp

P.S.: reboot usually refers to the OS, whereas Asterisk crashes or 
restarts. From your messages I understand that your linux box is not 
rebooting itself regularly.


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens
On 09/15/2010 02:03 PM, Philipp von Klitzing wrote:
 Hi!


 I know I post a lot concerning this issue, but this is because this
 problem occurs on a production system and I feel very hot breathing down
 my neck.
  
 Why not reduce the pressure and revert to 1.4.30 for the production
 system until you have figued out the issue? That will give you more time
 for (off-hours) testing and a more thorough look at what is going on.

 Look in /tmp if you can't find the core file elsewhere.
 http://svn.digium.com/svn/asterisk/trunk/doc/HOWTO_collect_debug_informati
 on.txt

 Philipp

 P.S.: reboot usually refers to the OS, whereas Asterisk crashes or
 restarts. From your messages I understand that your linux box is not
 rebooting itself regularly.


Hello Philipp,

I have indeed found the core file in /tmp (that is where 'locate' does 
not look huh...)

It indicates to be a binary file, however I have not found instructions 
on dealing with this @ the link you gave me.

Can you give me instruction on how to handle the core.pid file ?

THANKS !

Jonas.


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Steve Howes
On 15 Sep 2010, at 13:22, Jonas Kellens wrote:
 I have indeed found the core file in /tmp (that is where 'locate' does 
 not look huh...)

'updatedb'?

S

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Philipp von Klitzing
Hi Jonas!

 It indicates to be a binary file, however I have not found instructions on
 dealing with this @ the link you gave me.
 
 Can you give me instruction on how to handle the core.pid file ?

Could I ask you again to make an effort to reduce your number of daily 
postings to this list? If you google for Asterisk core - or rather 
search this list's archive - I am quite sure you will very quickly find 
additional info.

In case that fails (for reasons that I cannot imagine) here is another 
keyword to look for: gdb

So please do put a little bit more effort into attacking the issues 
yourself before creating a post for every single tiny question that you 
might come across in the process. That's what everyone else here does - 
we all have to do our own homework first.

Philipp


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens

On 09/15/2010 02:45 PM, Steve Howes wrote:

On 15 Sep 2010, at 13:22, Jonas Kellens wrote:
   

I have indeed found the core file in /tmp (that is where 'locate' does
not look huh...)
 

'updatedb'?

S
   


Off course I did that, Steve, before I did a locate on 'core'. But 
doesn't locate also have some PATH ? Where in my case /tmp is not in it.


Meanwhile I have come across this :

  1. start Asterisk with safe_asterisk
  2. enter gdb asterisk core.
  3. enter bt while in gdb (or do a bt full)
  4. enter thread apply all bt


I have no experience with this, so I post my output :

[r...@asterisk ~]# gdb asterisk core.4483
snip
This GDB was configured as i386-redhat-linux-gnu...
/root/core.4483 is not a core dump: File format not recognized
(gdb) bt
No stack.
(gdb) Quit


Jonas.
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Bruce Ferrell
On 09/15/2010 05:45 AM, Steve Howes wrote:
 On 15 Sep 2010, at 13:22, Jonas Kellens wrote:
   
 I have indeed found the core file in /tmp (that is where 'locate' does 
 not look huh...)
 
 'updatedb'?

 S
   
off topic, but updatedb deliberately doesn't usually look in /tmp

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Zeeshan Zakaria
Hi,

I went over your dialplan and though it looks fine at first glance, but
because I have no experience with Asterisk 1.6, so I would like to ask if
commas in mysql query are ok without escape character? In my asterisk 1.4 I
would type it like:

SELECT var1\, var2\, var3 FROM ...

Other things which come to mind:

1. Is your MySQL up to date?
2. Software versions on your test system are the same as on the production
system?
3. Can you post a MySQL query from your dialplan which works fine.

Regards,

Zeeshan A Zakaria

--
www.ilovetovoip.com

On 2010-09-15 9:20 AM, Jonas Kellens jonas.kell...@telenet.be wrote:

On 09/15/2010 02:45 PM, Steve Howes wrote:

 On 15 Sep 2010, at 13:22, Jonas Kellens wrote:

...
Off course I did that, Steve, before I did a locate on 'core'. But doesn't
locate also have some PATH ? Where in my case /tmp is not in it.

Meanwhile I have come across this :


   1. start Asterisk with safe_asterisk
   2. enter gdb asterisk core.
   3. enter bt while in gdb (or do a bt full)
   4. enter thread apply all bt


I have no experience with this, so I post my output :

[r...@asterisk ~]# gdb asterisk core.4483
snip
This GDB was configured as i386-redhat-linux-gnu...
/root/core.4483 is not a core dump: File format not recognized
(gdb) bt
No stack.
(gdb) Quit


Jonas.

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
  http://www.asterisk.org/hello

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 --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Jonas Kellens
On 09/15/2010 03:47 PM, Zeeshan Zakaria wrote:

 Hi,

 I went over your dialplan and though it looks fine at first glance, 
 but because I have no experience with Asterisk 1.6, so I would like to 
 ask if commas in mysql query are ok without escape character? In my 
 asterisk 1.4 I would type it like:

 SELECT var1\, var2\, var3 FROM ...

 Other things which come to mind:

 1. Is your MySQL up to date?
 2. Software versions on your test system are the same as on the 
 production system?
 3. Can you post a MySQL query from your dialplan which works fine.

 Regards,

 Zeeshan A Zakaria


Indeed the mysql queries on asterisk 1.4 need escape characters. But 
when upgrading to 1.6, I noticed that these were misinterpreted. So I 
dropped them...

Point 1

Mysql :

mysql status
--
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using 
readline 5.1

Connection id:2314
Current database:
Current user:r...@localhost
SSL:Not in use
Current pager:stdout
Using outfile:''
Using delimiter:;
Server version:5.0.77 Source distribution
Protocol version:10
Connection:Localhost via UNIX socket
Server characterset:latin1
Db characterset:latin1
Client characterset:latin1
Conn.  characterset:latin1
UNIX socket:/var/lib/mysql/mysql.sock
Uptime:5 hours 51 min 17 sec

Threads: 3  Questions: 238036  Slow queries: 0  Opens: 51  Flush tables: 
1  Open tables: 42  Queries per second avg: 11.294

Point 2

Asterisk is the same version (compiled from source)
CentOS is the same version, php is the same version, mysql is the same 
version (yum update)

!!! one difference : x64 (x86_64 x86_64 x86_64 GNU/Linux) on production 
system, and x86 (i686 i686 i386 GNU/Linux) on test environment !!!

Point 3

Mysql from dialplan that works :

[macro-QueryAstDB]
exten = s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
exten = s,n,MYSQL(Query resultid ${connid} SELECT KNUMMER , vmcontext , 
accountcode_out , hostedformule , mohclass FROM AstDB where klantID=${ARG1})
exten = s,n,MYSQL(Fetch fetchid ${resultid} KNUMMER VMCONTEXT ACCOUT 
FORMULE MOHCLASS)
exten = s,n,NoOp(knummer = ${KNUMMER} vmcontext = ${VMCONTEXT} 
accountcode_out = ${ACCOUT} hostedformule = ${FORMULE} mohclass = 
${MOHCLASS})
exten = s,n,MYSQL(Clear ${resultid})
exten = s,n,MYSQL(Disconnect ${connid})
exten = s,n,MacroExit()



Thanks !

Jonas.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Paul Belanger
On Wed, Sep 15, 2010 at 9:14 AM, Jonas Kellens jonas.kell...@telenet.be wrote:
 I have no experience with this, so I post my output :

Read doc/backtrace.txt it will explain how to generate a backtrace
from a core dump.

-- 
Paul Belanger | dCAP
Polybeacon | Consultant
Jabber: paul.belan...@polybeacon.com | IRC: pabelanger (Freenode)
blog.polybeacon.com

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Leif Madsen
On 10-09-15 05:25 AM, Jonas Kellens wrote:
 I think I've found it :

 Asterisk always reboots on this part :

 [Sep 15 11:16:32] -- Goto (azura,pbx,1)
 [Sep 15 11:16:32] -- Executing [...@azura:1]
 NoOp(SIP/INTERTELin-, 3252480333 = pbx formule) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:2]
 Set(SIP/INTERTELin-, CDR(accountcode)=AZURAin) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:3]
 Set(SIP/INTERTELin-, BRON=473555006 473555006) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:4]
 Goto(SIP/INTERTELin-, vakantie) in new stack
 [Sep 15 11:16:32] -- Goto (azura,pbx,5)
 [Sep 15 11:16:32] -- Executing [...@azura:5]
 Macro(SIP/INTERTELin-, vakantie,58) in new stack
 [Sep 15 11:16:32] -- Executing [...@macro-vakantie:1]
 MYSQL(SIP/INTERTELin-, Connect connid localhost username
 passwd AsteriskHosted) in new stack
 [Sep 15 11:16:32] -- Executing [...@macro-vakantie:2]
 MYSQL(SIP/INTERTELin-, Query resultid 1 SELECT ast1 , ast2 ,
 na , naID FROM vakantiedata where ID=58) in new stack
 vps2301*CLI
 Disconnected from Asterisk server
 [Sep 15 11:16:32] Executing last minute cleanups


 Dialplan :

 [macro-vakantie]
 exten = s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
 exten = s,n,MYSQL(Query resultid ${connid} SELECT ast1 , ast2 , na ,
 naID FROM vakantiedata where ID=${ARG1})
 exten = s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID )
 exten = s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na =
 ${NA} naID = ${naID})
 exten = s,n,MYSQL(Clear ${resultid})
 exten = s,n,MYSQL(Disconnect ${connid})

 exten = s,n,NoOp(fetchid = ${fetchid})
 exten = s,n,GoToIf($[${fetchid}==0]?exit)

 exten = s,n,NoOp()
 exten = s,n,GoToIfTime(${AST1}?opvakantie)
 exten = s,n,GoToIfTime(${AST2}?opvakantie)

 exten = s,n(exit),NoOp()
 exten = s,n,Set(vakantieresult=continue)
 exten = s,n,MacroExit

 exten = s,n(opvakantie),NoOp(op vakantie !)
 exten = s,n,GoToIf($[${NA}=hangup]?hangup:route)


 Do you guys see why Asterisk has problems with this part of the dialplan ?!

I've seen problems with MYSQL() application crashing on customers boxes before. 
It is not that well supported, and would greatly recommend you move to 
func_odbc 
usage for dialplan-database integration.

Not only will it simplify your dialplan, but likely will resolve your crashing 
issues as well. I've done this for at least 3 customers who were using MYSQL() 
and all crashing issues stopped and their dialplans ended up becoming 
significantly more readable.

Leif.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread jon pounder
On 09/15/2010 12:42 PM, Leif Madsen wrote:
 On 10-09-15 05:25 AM, Jonas Kellens wrote:

 I think I've found it :

 Asterisk always reboots on this part :

 [Sep 15 11:16:32] -- Goto (azura,pbx,1)
 [Sep 15 11:16:32] -- Executing [...@azura:1]
 NoOp(SIP/INTERTELin-, 3252480333 = pbx formule) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:2]
 Set(SIP/INTERTELin-, CDR(accountcode)=AZURAin) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:3]
 Set(SIP/INTERTELin-, BRON=473555006473555006) in new stack
 [Sep 15 11:16:32] -- Executing [...@azura:4]
 Goto(SIP/INTERTELin-, vakantie) in new stack
 [Sep 15 11:16:32] -- Goto (azura,pbx,5)
 [Sep 15 11:16:32] -- Executing [...@azura:5]
 Macro(SIP/INTERTELin-, vakantie,58) in new stack
 [Sep 15 11:16:32] -- Executing [...@macro-vakantie:1]
 MYSQL(SIP/INTERTELin-, Connect connid localhost username
 passwd AsteriskHosted) in new stack
 [Sep 15 11:16:32] -- Executing [...@macro-vakantie:2]
 MYSQL(SIP/INTERTELin-, Query resultid 1 SELECT ast1 , ast2 ,
 na , naID FROM vakantiedata where ID=58) in new stack
 vps2301*CLI
 Disconnected from Asterisk server
 [Sep 15 11:16:32] Executing last minute cleanups


 Dialplan :

 [macro-vakantie]
 exten =  s,1,MYSQL(Connect connid localhost username passwd AsteriskHosted)
 exten =  s,n,MYSQL(Query resultid ${connid} SELECT ast1 , ast2 , na ,
 naID FROM vakantiedata where ID=${ARG1})
 exten =  s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID )
 exten =  s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na =
 ${NA} naID = ${naID})
 exten =  s,n,MYSQL(Clear ${resultid})
 exten =  s,n,MYSQL(Disconnect ${connid})

 exten =  s,n,NoOp(fetchid = ${fetchid})
 exten =  s,n,GoToIf($[${fetchid}==0]?exit)

 exten =  s,n,NoOp()
 exten =  s,n,GoToIfTime(${AST1}?opvakantie)
 exten =  s,n,GoToIfTime(${AST2}?opvakantie)

 exten =  s,n(exit),NoOp()
 exten =  s,n,Set(vakantieresult=continue)
 exten =  s,n,MacroExit

 exten =  s,n(opvakantie),NoOp(op vakantie !)
 exten =  s,n,GoToIf($[${NA}=hangup]?hangup:route)


 Do you guys see why Asterisk has problems with this part of the dialplan ?!
  
 I've seen problems with MYSQL() application crashing on customers boxes 
 before.
 It is not that well supported, and would greatly recommend you move to 
 func_odbc
 usage for dialplan-database integration.

 Not only will it simplify your dialplan, but likely will resolve your crashing
 issues as well. I've done this for at least 3 customers who were using MYSQL()
 and all crashing issues stopped and their dialplans ended up becoming
 significantly more readable.


This will also fix any real or perceived mysql takeover issues since 
odbc can be attached to any backend without changing the code.
 Leif.




-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk 1.6.2.11

2010-09-15 Thread Alec Davis
Just a quick note: may not be related, but may help.

See https://issues.asterisk.org/view.php?id=14757#107179

We have been using mysql queries within macros for a few years.
But initially there was a problem, mysql connections were not clearing, if a
caller hungup while an mysql connection was open.

In mysql.conf:
[general]
autoclear=yes

Alec Davis


-Original Message-
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of jon pounder
Sent: Thursday, 16 September 2010 4:49 a.m.
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] UPDATE !! Spontaneous reboots on asterisk
1.6.2.11

On 09/15/2010 12:42 PM, Leif Madsen wrote:
 On 10-09-15 05:25 AM, Jonas Kellens wrote:

 I think I've found it :

 Asterisk always reboots on this part :

 [Sep 15 11:16:32] -- Goto (azura,pbx,1) [Sep 15 11:16:32] -- 
 Executing [...@azura:1] NoOp(SIP/INTERTELin-, 3252480333 = 
 pbx formule) in new stack [Sep 15 11:16:32] -- Executing 
 [...@azura:2] Set(SIP/INTERTELin-, 
 CDR(accountcode)=AZURAin) in new stack [Sep 15 11:16:32] -- 
 Executing [...@azura:3] Set(SIP/INTERTELin-, 
 BRON=473555006473555006) in new stack [Sep 15 11:16:32] -- 
 Executing [...@azura:4] Goto(SIP/INTERTELin-, vakantie) 
 in new stack [Sep 15 11:16:32] -- Goto (azura,pbx,5) [Sep 15 
 11:16:32] -- Executing [...@azura:5] Macro(SIP/INTERTELin-, 
 vakantie,58) in new stack [Sep 15 11:16:32] -- Executing 
 [...@macro-vakantie:1] MYSQL(SIP/INTERTELin-, Connect connid 
 localhost username passwd AsteriskHosted) in new stack [Sep 15 
 11:16:32] -- Executing [...@macro-vakantie:2] 
 MYSQL(SIP/INTERTELin-, Query resultid 1 SELECT ast1 , ast2 
 , na , naID FROM vakantiedata where ID=58) in new stack vps2301*CLI 
 Disconnected from Asterisk server [Sep 15 11:16:32] Executing last 
 minute cleanups


 Dialplan :

 [macro-vakantie]
 exten =  s,1,MYSQL(Connect connid localhost username passwd 
 AsteriskHosted) exten =  s,n,MYSQL(Query resultid ${connid} SELECT 
 ast1 , ast2 , na , naID FROM vakantiedata where ID=${ARG1}) exten =  
 s,n,MYSQL(Fetch fetchid ${resultid} AST1 AST2 NA naID ) exten =  
 s,n,NoOp(vakantie-ast1 = ${AST1} vakantie-ast2 = ${AST2} na = ${NA} 
 naID = ${naID}) exten =  s,n,MYSQL(Clear ${resultid}) exten =  
 s,n,MYSQL(Disconnect ${connid})

 exten =  s,n,NoOp(fetchid = ${fetchid}) exten =  
 s,n,GoToIf($[${fetchid}==0]?exit)

 exten =  s,n,NoOp()
 exten =  s,n,GoToIfTime(${AST1}?opvakantie)
 exten =  s,n,GoToIfTime(${AST2}?opvakantie)

 exten =  s,n(exit),NoOp()
 exten =  s,n,Set(vakantieresult=continue) exten =  s,n,MacroExit

 exten =  s,n(opvakantie),NoOp(op vakantie !) exten =  
 s,n,GoToIf($[${NA}=hangup]?hangup:route)


 Do you guys see why Asterisk has problems with this part of the dialplan
?!
  
 I've seen problems with MYSQL() application crashing on customers boxes
before.
 It is not that well supported, and would greatly recommend you move to 
 func_odbc usage for dialplan-database integration.

 Not only will it simplify your dialplan, but likely will resolve your 
 crashing issues as well. I've done this for at least 3 customers who 
 were using MYSQL() and all crashing issues stopped and their dialplans 
 ended up becoming significantly more readable.


This will also fix any real or perceived mysql takeover issues since odbc
can be attached to any backend without changing the code.
 Leif.




--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to
Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

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 --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users