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