Re: [asterisk-users] MySQL Connect problem...
On Thu, Aug 19, 2010 at 6:05 PM, Steve Edwards wrote: >>> On 18 August 2010 08:52, Nasir Iqbal 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 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...
On 18 August 2010 08:52, Nasir Iqbal 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 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 4:27 AM, Geraint Lee 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 > wrote: >> >> On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee wrote: >> > This is what I ended up doing, working fine now. >> > Cheers >> > >> > On 18 August 2010 08:52, Nasir Iqbal 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...
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 wrote: > On Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee wrote: > > This is what I ended up doing, working fine now. > > Cheers > > > > On 18 August 2010 08:52, Nasir Iqbal 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 Wed, Aug 18, 2010 at 3:59 PM, Geraint Lee wrote: > This is what I ended up doing, working fine now. > Cheers > > On 18 August 2010 08:52, Nasir Iqbal 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...
This is what I ended up doing, working fine now. Cheers On 18 August 2010 08:52, Nasir Iqbal 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 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
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 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
[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
[asterisk-users] mysql connect
I have asterisk 1.4 ,the function that I am using in extensions.conf is not functioning Its was functioning on asterisk 1.2.further more cdr_addon_mysql.so cdr_csv.so cdr_custom.so cdr_manager.so cdr are loaded Is there any missing module ? Function IS for example exten => *70,n,MYSQL(Connect connid 127.0.0.1 root passw0rd asterisk) exten => *70,n,MYSQL(Query resultid ${connid} UPDATE\ devices\ set\ cw\=\'1\'\ WHERE \ID\ = \'${CALLERIDNUM}\') ;exten => *70,n,MYSQL(Clear ${resultid}) ;exten => *70,n,MYSQL(Disconnect ${connid}) * No employee or agent is authorized to conclude any binding agreement on behalf of Xplorium with another party by e-mail without express written confirmation by an officer of Xplorium. Any views expressed by an individual in this electronic message do not necessarily reflect views of Xplorium or its subsidiaries and associates. This electronic message and its attachments are solely addressed to the addressee(s), and contain confidential information protected from disclosure belonging to Xplorium. If you are not the intended addressee of this electronic message and its attachments, kindly delete it immediately from your system and notify the sender by electronic mail. You must not copy this message or attachment or disclose its content to any other person. Xplorium does not guarantee the integrity of this electronic message and any of its attachments, or that they are free from computer viruses or other defects. * ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users