Re: [asterisk-users] MySQL Connect problem...
On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee gera...@gmail.com wrote: This is what I ended up doing, working fine now. Cheers On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose LOL, I hate to say this but writing an AGI script just adds yet another application layer to your total solution. OP, if you'd like to figure out WHY that was happening instead of abandoning the ship, I'd be glad to work with you to discover the cause. I've been using the MySQL Addon since the early days of ViaTalk back when 1.4 was still trunk code and the ARA was considered VERY experimental. I've never come across a problem with it that I couldn't figure out within a day so long as I stepped back and worked the logical path model of problem solving... Drop me a line, I think that I can figure it out within 20 questions and maybe a peek at a log ;-) Slainte, Sherwood McGowan -- _ -- 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] MySQL Connect problem...
I would like to figure out why but can't really switch back now it works since to replicate the problem... whatever it may be... i'd need to leave it running live and wait for the live system to die... which obviously isn't what i really want to happen :) On 19 August 2010 08:11, Sherwood McGowan sherwood.mcgo...@gmail.comwrote: On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee gera...@gmail.com wrote: This is what I ended up doing, working fine now. Cheers On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose LOL, I hate to say this but writing an AGI script just adds yet another application layer to your total solution. OP, if you'd like to figure out WHY that was happening instead of abandoning the ship, I'd be glad to work with you to discover the cause. I've been using the MySQL Addon since the early days of ViaTalk back when 1.4 was still trunk code and the ARA was considered VERY experimental. I've never come across a problem with it that I couldn't figure out within a day so long as I stepped back and worked the logical path model of problem solving... Drop me a line, I think that I can figure it out within 20 questions and maybe a peek at a log ;-) Slainte, Sherwood McGowan -- _ -- 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] MySQL Connect problem...
On Thu, Aug 19, 2010 at 4:27 AM, Geraint Lee gera...@gmail.com wrote: I would like to figure out why but can't really switch back now it works since to replicate the problem... whatever it may be... i'd need to leave it running live and wait for the live system to die... which obviously isn't what i really want to happen :) On 19 August 2010 08:11, Sherwood McGowan sherwood.mcgo...@gmail.com wrote: On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee gera...@gmail.com wrote: This is what I ended up doing, working fine now. Cheers On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose LOL, I hate to say this but writing an AGI script just adds yet another application layer to your total solution. OP, if you'd like to figure out WHY that was happening instead of abandoning the ship, I'd be glad to work with you to discover the cause. I've been using the MySQL Addon since the early days of ViaTalk back when 1.4 was still trunk code and the ARA was considered VERY experimental. I've never come across a problem with it that I couldn't figure out within a day so long as I stepped back and worked the logical path model of problem solving... Drop me a line, I think that I can figure it out within 20 questions and maybe a peek at a log ;-) Slainte, Sherwood McGowan -- _ -- 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 Totally understandable mate, trust me, I know how telecom/voip works..if it's working right now, DONT SCREW IT UP! -- _ -- 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] MySQL Connect problem...
On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee gera...@gmail.com wrote: This is what I ended up doing, working fine now. Cheers On Thu, 19 Aug 2010, Sherwood McGowan wrote: LOL, I hate to say this but writing an AGI script just adds yet another application layer to your total solution. Yes, another layer, but a layer where you will have full access to what's going on -- like what errors are being returned by MySQL and can be debugged completely external from Asterisk via the shell command line. -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000-- _ -- 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] MySQL Connect problem...
On Thu, Aug 19, 2010 at 6:05 PM, Steve Edwards asterisk@sedwards.com wrote: On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee gera...@gmail.com wrote: This is what I ended up doing, working fine now. Cheers On Thu, 19 Aug 2010, Sherwood McGowan wrote: LOL, I hate to say this but writing an AGI script just adds yet another application layer to your total solution. Yes, another layer, but a layer where you will have full access to what's going on -- like what errors are being returned by MySQL and can be debugged completely external from Asterisk via the shell command line. -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _ -- 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 I'll just leave this be...I'm in an irate mood, and I've been using the MySQL addons since 2005...I don't have problems like this, and you CAN see what MySQL is saying...THERE'S LOGS ON BOTH SYSTEMS.. I'll leave the Surely you thought of checking THIS discussion for when I'm a little less likely to spill Jameson and/or Guiness on me lappy -- _ -- 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] MySQL Connect problem...
Avoid to use MySQL dialplan application, instead write an AGI script for this purpose On Tue, Aug 17, 2010 at 4:59 PM, Geraint Lee gera...@gmail.com wrote: Right, I'm baffled. I have: exten = s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2) exten = s,n,MYSQL(Query NORESULT ${DB1} INSERT\ INTO\ recordings\ (caller_number\,called_number\,date_created\,date_started\,in_use\,server_id)\ VALUES\ (\'${CALLERID(number)}\'\,\'${ARG1}\'\,NOW()\,NOW()\,\'Yes\'\,12)) exten = s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID()) exten = s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1) exten = s,n,MYSQL(Clear ${RESULT1}) exten = s,n,MYSQL(Disconnect ${DB1}) exten = s,n,MixMonitor(${VALUE1}.wav) exten = s,n,Set(CALLERID(all)=xxx) exten = s,n,Dial(SIP/prov1/${ARG1}) in a macro to dial numbers... Every few hours or so every call hangs on the s,1 MYSQL(Connect) and won't work until i restart asterisk. The mysql server has a maximum connections of 2048 (of which around 90 are in use) so it's not a mysql connection limit problem from what i can tell since while asterisk is stuck i can still log in to mysql just fine, as can the web server. Does anyone have any suggestions what could be causing asterisk to get stuck here? i don't see anything in cli and core show channels just shows everyone stuck in state ring on the connect string with no errors. Cheers Geraint -- _ -- 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 -- Nasir Iqbal ICT Innovations http://www.ictinnovations.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] MySQL Connect problem...
This is what I ended up doing, working fine now. Cheers On 18 August 2010 08:52, Nasir Iqbal na...@ictinnovations.com wrote: Avoid to use MySQL dialplan application, instead write an AGI script for this purpose On Tue, Aug 17, 2010 at 4:59 PM, Geraint Lee gera...@gmail.com wrote: Right, I'm baffled. I have: exten = s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2) exten = s,n,MYSQL(Query NORESULT ${DB1} INSERT\ INTO\ recordings\ (caller_number\,called_number\,date_created\,date_started\,in_use\,server_id)\ VALUES\ (\'${CALLERID(number)}\'\,\'${ARG1}\'\,NOW()\,NOW()\,\'Yes\'\,12)) exten = s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID()) exten = s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1) exten = s,n,MYSQL(Clear ${RESULT1}) exten = s,n,MYSQL(Disconnect ${DB1}) exten = s,n,MixMonitor(${VALUE1}.wav) exten = s,n,Set(CALLERID(all)=xxx) exten = s,n,Dial(SIP/prov1/${ARG1}) in a macro to dial numbers... Every few hours or so every call hangs on the s,1 MYSQL(Connect) and won't work until i restart asterisk. The mysql server has a maximum connections of 2048 (of which around 90 are in use) so it's not a mysql connection limit problem from what i can tell since while asterisk is stuck i can still log in to mysql just fine, as can the web server. Does anyone have any suggestions what could be causing asterisk to get stuck here? i don't see anything in cli and core show channels just shows everyone stuck in state ring on the connect string with no errors. Cheers Geraint -- _ -- 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 -- Nasir Iqbal ICT Innovations http://www.ictinnovations.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 -- _ -- 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
[asterisk-users] MySQL Connect problem...
Right, I'm baffled. I have: exten = s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2) exten = s,n,MYSQL(Query NORESULT ${DB1} INSERT\ INTO\ recordings\ (caller_number\,called_number\,date_created\,date_started\,in_use\,server_id)\ VALUES\ (\'${CALLERID(number)}\'\,\'${ARG1}\'\,NOW()\,NOW()\,\'Yes\'\,12)) exten = s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID()) exten = s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1) exten = s,n,MYSQL(Clear ${RESULT1}) exten = s,n,MYSQL(Disconnect ${DB1}) exten = s,n,MixMonitor(${VALUE1}.wav) exten = s,n,Set(CALLERID(all)=xxx) exten = s,n,Dial(SIP/prov1/${ARG1}) in a macro to dial numbers... Every few hours or so every call hangs on the s,1 MYSQL(Connect) and won't work until i restart asterisk. The mysql server has a maximum connections of 2048 (of which around 90 are in use) so it's not a mysql connection limit problem from what i can tell since while asterisk is stuck i can still log in to mysql just fine, as can the web server. Does anyone have any suggestions what could be causing asterisk to get stuck here? i don't see anything in cli and core show channels just shows everyone stuck in state ring on the connect string with no errors. Cheers Geraint -- _ -- 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