search for: mysql_fail

Hi, I am trying to connect the outbound dialing with mysql with the following code, exten => 88,1,MYSQL(Connect connid hostname username password dbname) exten => 88,2,GotoIf($["${connid}" = ""]?error,1) exten => 88,3,MYSQL(Query resultid ${connid} SELECT\ phone\ FROM\ <tablename>\ WHERE\ phone =${a}) exten => 88,4,MYSQL(Fetch fetchid ${resultid} ph\ sa)

Hi all, What's the best method to send automon call recordings (*1) to the voicemail box of the Asterisk user? Do you have to trap hangups, etc, or is there some global variable that can be set? Thanks! S.

Greetings all- I have a handful of Asterisk 1.4.x installations where users dial 'outbound calls' to the PSTN even though the destination is on the same Asterisk box or on another Asterisk box on the same network. Instead of paying twice for the call to go out to the PSTN on one channel and back in on another channel, I'd like the ability to lookup the destination number in a MySQL

I have a working dialplan for our phone system with Mon-Fri, business hours identification, etc. But what I'm lacking right now is support for company holiday dates. What I'd like to do is to create a database of these dates and just update them as new years rollover. I suspect others have done this sort of thing with Asterisk before, but I've not found any resources so far.

Does anybody know of a way to test whether a mySQL connection invoked from the dialplan is current or not? For example: extensions.conf =============== [context] exten => _X.,1,MYSQL(Connect connid localhost user pass db) exten => _X.,n,MYSQL(Query resultid ${connid} SELECT `something` FROM `table` WHERE `number` = ${EXTEN}) exten => _X.,n,MYSQL(Fetch foundRow ${resultid} something)