Hi guys,
I'm trying to connect Asterisk to the MySQL, but I can't execute it. It
returns an error, as below:
-- Executing [200@teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/
ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack
[Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 aMYSQL_query: aMYSQL_query:
mysql_query failed. Error: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200' at line 1
Its seems it can connect to mysql
My extension (AEL) is:
MySQL(Connect conn_id localhost root 123456 crm);
MySQL(Query resultid ${conn_id} SELECT/ ramal/ FROM/
colaboradores/ WHERE/ ramal=${EXTEN});
MySQL(Fetch fetchid ${resultid} RAMAL);
MySQL(Clear ${fetchid});
MySQL(Disconnect ${connid});
MySQL(Clear ${connid});
NoOp(${RAMAL});
Where is the error? Thanks!!
The MySQL server is in the same server where Asterisk is running.
Thanks!!!
--
_____________________________________________________________________
-- 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
