In article <cacolbwuid-noos3qp9x3cp+ffmrkzk+qjuyxtqnnow4bs2t...@mail.gmail.com>, Atux Atux <atuxn...@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@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: t...@softins.co.uk - http://www.softins.co.uk Play: t...@mountifield.org - http://tony.mountifield.org -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users