Hello,
I just noticed a weird behavior when using ODBC functions. If the content
of any of the paramter has a "=" inside, then the function is not processed
correctly by asterisk.
Let's take for example the following ODBC function in func_odbc.conf
[LOG_SMS]
dsn=asterisk1,asterisk2
synopsis=Log the route of a SMS
writesql=INSERT INTO
sm_smslogs(sm_te_id,sm_date,sm_direction,sm_sourceraw,sm_destraw,sm_from,sm_to,sm_body,sm_fullresult,sm_response)
values
('${ARG1}',NOW(),'${ARG2}','${ARG3}','${ARG4}','${ARG5}','${ARG6}','${SQL_ESC(${ARG7})}','${SQL_ESC(${ARG8})}','${SQL_ESC(${VAL1})}')
When it is called using:
[2015-08-31 16:35:16] VERBOSE[29562][C-00000001] pbx.c: Executing
[103@astsms:37] Set("Message/ast_msg_queue", "ODBC_LOG_SMS(1,ONNET,<
sip:102-de...@devel.mirtapbx.com;transport=UDP>,sip:1...@devel.mirtapbx.com;transport=UDP,102,103,Second
test 4,)=SUCCESS") in new stack
Asterisk interprets the first "=" as assignment. In the debug log I found:
Variable: ODBC_LOG_SMS(1,ONNET,<sip:102-de...@devel.mirtapbx.com;transport
AppData: UDP>,sip:1...@devel.mirtapbx.com;transport=UDP,102,103,Second test
4,)=SUCCESS
And the ODBC function is not executed.
Is there a way, beside using REPLACE, to avoid this problem?
Leandro
--
_____________________________________________________________________
-- 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
