[asterisk-users] asterisk name in mysql

[Tony Mountifield]

In article <CACoLBwUid-NOos3Qp9x3CP+fFmrKzk+QJuYXTQnnOw4BS2thaw at mail.gmail.com>,
Atux Atux <atuxnull at gmail.com> wrote:
> 
> Thanks a lot for the reply.
> I did follow that already, but i do have a problem. Here is my
> extensions.conf part for that particular number
> exten => 6912345678,1,Answer()
> exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk)
> exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8)
> exten => 6912345678,n,GotoIf($["${connid}" = ""]?nodb)
> exten => 6912345678,n,MYSQL(Query resultid ${connid} SELECT displayname
> FROM root WHERE phonenumber="${CALLERID(num)}" LIMIT 1)
> exten => 6912345678,n,MYSQL(Fetch fetchid ${resultid} displayname)
> exten => 6912345678,n,MYSQL(Clear ${resultid})
> exten => 6912345678,n,Set(CALLERID(name)=${displayname})
> exten => 6912345678,n,MYSQL(Disconnect ${connid})
> exten => 6912345678,n(nodb),NoOp(DoneDB)
> exten => 6912345678,n,Dial(SIP/450&SIP/451,20)
> exten => 6912345678,n,VoiceMail(450 at Office,su)
> exten => 6912345678,n,Busy(3)
> 
> 6912345678 is my DID
> 
> 
> and here is the error i am getting
> [Apr 22 23:20:29] WARNING[9725][C-00000002]: pbx.c:4991
> pbx_extension_helper: No application 'MYSQL' for extension (IncomingDial,
> 6951921078, 2)
>   == Spawn extension (DialIn, 6912345678, 2) exited non-zero on
> 'Dongle/dongle0-0100000002'

That means that your copy of asterisk does not have the "app_mysql" module.
If you compiled asterisk yourself, you need to go into menuselect and make
sure app_mysql is selected, and then recompile.

You will probably find app_mysql under "Addons".

If it does not let you select app_mysql, you will need to install the mysql
development package (e.g. mysql-devel) to get the headers and libraries.

Cheers
Tony

-- 
Tony Mountifield
Work: tony at softins.co.uk - http://www.softins.co.uk
Play: tony at mountifield.org - http://tony.mountifield.org