[asterisk-bugs] [JIRA] (ASTERISK-23937) Syntax Error ODBC SQL

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-23937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-23937:
------------------------------------

    Assignee: Rusty Newton  (was: Simon Balkau)
      Status: Triage  (was: Waiting for Feedback)

> Syntax Error ODBC SQL
> ---------------------
>
>                 Key: ASTERISK-23937
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23937
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_odbc, Resources/res_odbc
>    Affects Versions: 12.3.2
>         Environment: Ubuntu 12.04.4 LTS Server
> Asterisk 12.3.2
> ODBC on local MySQL
>            Reporter: Simon Balkau
>            Assignee: Rusty Newton
>            Severity: Trivial
>
> Hi there,
> currently I tried to find the string where the SQL is built.
> There is an missing apostroph or missing backslash depends on what should be achieved.
> look on this debug:
> {noformat}
> [Jun 25 22:52:21] DEBUG[3692][C-00000002]: res_config_odbc.c:112 custom_prepare:                                                                                                                                                              Skip: 0; SQL: SELECT * FROM sippeers WHERE host = ? AND insecure LIKE ? ESCAPE                                                                                                                                                              '\' ORDER BY host
> [Jun 25 22:52:21] DEBUG[3692][C-00000002]: res_config_odbc.c:128 custom_prepare:                                                                                                                                                              Parameter 1 ('host') = 'xxx.xxx.xxx.xxx'
> [Jun 25 22:52:21] DEBUG[3692][C-00000002]: res_config_odbc.c:128 custom_prepare:                                                                                                                                                              Parameter 2 ('insecure LIKE') = '%port%'
> [Jun 25 22:52:21] WARNING[3692][C-00000002]: res_odbc.c:655 ast_odbc_prepare_and                                                                                                                                                             _execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysq                                                                                                                                                             ld-5.5.37-0ubuntu0.12.04.1]You have an error in your SQL syntax; check the manua                                                                                                                                                             l that corresponds to your MySQL server version for the right syntax to use near                                                                                                                                                              ''\' ORDER BY host' at line 1 (219)
> [Jun 25 22:52:21] WARNING[3692][C-00000002]: res_odbc.c:667 ast_odbc_prepare_and                                                                                                                                                             _execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-conne                                                                                                                                                             ctor]...
> {noformat}
> and second:
> {noformat}
> [Jun 25 22:52:51] DEBUG[3692][C-00000002]: res_config_odbc.c:112 custom_prepare: Skip: 0; SQL: SELECT * FROM sippeers WHERE ipaddr = ? AND insecure LIKE ? ESCAPE '\' ORDER BY ipaddr
> [Jun 25 22:52:51] DEBUG[3692][C-00000002]: res_config_odbc.c:128 custom_prepare: Parameter 1 ('ipaddr') = 'xxx.xxx.xxx.xxx'
> [Jun 25 22:52:51] DEBUG[3692][C-00000002]: res_config_odbc.c:128 custom_prepare: Parameter 2 ('insecure LIKE') = '%port%'
> [Jun 25 22:52:51] WARNING[3692][C-00000002]: res_odbc.c:655 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.37-0ubuntu0.12.04.1]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 ''\' ORDER BY ipaddr' at line 1 (221)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)