Hello friends,
We have problem working asterisk with ODBC.
node1-pbx*CLI> core show version
Asterisk 13.19.0 built by root @ localhost.localdomain on a x86_64 running Linux on 2018-01-15 15:14:23 UTC
[root@node1-pbx ~]# odbcinst --verison
unixODBC 2.3.1
postgres=# select version();
version
PostgreSQL 10.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
(1 row)
Asterisk don’t can load config
node1-pbx*CLI> odbc show
ODBC DSN Settings
Name: stolon
DSN: stolon
Last connection attempt: 1970-01-01 05:00:00
Number of active connections: 2 (out of 20)
node1-pbx*CLI> pjsip show aors
No objects found.
[Jun 6 01:53:04] WARNING[12474]: res_odbc.c:460 ast_odbc_print_errors: SQL Execute returned an error: 22025: ERROR: invalid escape string;
Error while executing the query
[Jun 6 01:53:04] WARNING[12474]: res_odbc.c:404 ast_odbc_prepare_and_execute: SQL Execute error -1!
postgresql log
2018-06-06 01:52:18.709 +05 [9491] ERROR: invalid escape string
2018-06-06 01:52:18.709 +05 [9491] HINT: Escape string must be empty or one character.
2018-06-06 01:52:18.709 +05 [9491] STATEMENT: SELECT * FROM ps_aors WHERE id LIKE $1 ESCAPE ‘\’ ORDER BY id
it’s bag or my errors?