Re: MYSQL INSERT QUESTION IN DIALPLAN

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



-----Original Message-----
From: asterisk-users-bounces@xxxxxxxxxxxxxxxx
[mailto:asterisk-users-bounces@xxxxxxxxxxxxxxxx] On Behalf Of Noah
Engelberth
Sent: Monday, April 09, 2012 9:52 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re:  MYSQL INSERT QUESTION IN DIALPLAN

>-----Original Message-----
>From: asterisk-users-bounces@xxxxxxxxxxxxxxxx
[mailto:asterisk-users-bounces@xxxxxxxxxxxxxxxx] On Behalf Of
lists65@xxxxxxxxx
>Sent: Monday, April 09, 2012 8:34 PM
>To: asterisk-users@xxxxxxxxxxxxxxxx
>Subject:  MYSQL INSERT QUESTION IN DIALPLAN

>I am not a programmer and I have learned so much from examples and the
list.
>Perhaps someone could tell me what I am doing wrong in my example below:

>I am getting the caller ID and caller name from my local POTS line and I
want to add it into a sql table.  I am trying with the following code but
the data never gets put into the table.

>Can anyone correct my syntax and tell me what I am doing wrong?


>[callerinfo]
>exten => s,1,MYSQL(Connect connid localhost myuser mypassword cnam) exten
=> s,n,MYSQL(Query resultid ${connid} INSERT INTO `calleridcapture`
>(`number`,`name`) VALUES (${CALLERID(num)},${CALLERID(name)})
>exten => s,n,MYSQL(Clear ${resultid})
>exten => s,n,MYSQL(Disconnect ${connid}) exten => s,n,NoOp(Callerid Name
${CALLERID(name)}) exten => s,n,NoOp(Callerid Number  ${CALLERID(num)})


>The NoOP does show the correct CALLERID name & number when I test it.  The
information just doesn't go into my calleridcapture table in the cnam
database.

>Thanks very much for your help
>Again I am not a programmer and I am sure my syntax is wrong.

>This is Asterisk 1.8.10.0
>

As the previous two posters alluded, you need to encapsulate your values in
quotes.  I think you can get by without the backticks, not 100% sure as I've
converted from MYSQL to func_odbc.  If you're not going to go with Steve's
recommendation of AGI, I would highly recommend  switching from func_mysql
to func_odbc; func_odbc is much more straightforward in my opinion, and you
definitely get much better error messages within the CLI as you're watching
your code execute.  ofps.oreilly.com/titles/9780596517342/asterisk-DB.html
is a good resource for setting up odbc.

Noah


Thanks for your responses.

Well, the AGI piece sounds good, but again I am not a programmer but I
certainly will try and try to find some code that I could piece together and
try to make it work.

I will check out Oreilly's stuff, they always seem to have good books when
you are trying to learn something new.

Thanks again, I really appreciate your resonse.



--
_____________________________________________________________________
-- 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


[Gnu Gatekeeper]     [IETF Sipping]     [Info Cyrus]     [ALSA User]     [Fedora Linux Users]     [DCCP]     [Gimp]     [100% Free Online Dating]     [Yosemite News]     [Arts & Crafts]     [Yosemite Photos]     [Deep Creek Hot Springs]     [Yosemite Campsites]     [ISDN Cause Codes]


Add to Google Powered by Linux