Dynamic realtime + queues.conf

Hi,

I want to store queues.conf in a MySQL database using dynamic realtime. I am using Asterisk 11.2.1 and MySQL 5.1.67, the database is hosted on another server but I can access the database via ODBC.

I have created the following tables:

SQL> show tables;
±----------------------------------------------------------------+
| Tables_in_asterisk |
±----------------------------------------------------------------+
| QueueDialplanParameters |
| Queues |
| queue_log |
| queue_member_table |
±----------------------------------------------------------------+
SQLRowCount returns 4
4 rows fetched

Each table has all of the required fields.

I am getting the following errors from the asterisk console:

node1*CLI> queue show support
support has 0 calls (max unlimited) in ‘rrmemory’ strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 60s
No Members
No Callers
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]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 ‘’’ AND queue_name = ? ORDER BY interface’ at line 1 (226)
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]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 ‘’’ AND queue_name = ? ORDER BY interface’ at line 1 (226)
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]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 ‘’’ AND queue_name = ? ORDER BY interface’ at line 1 (226)
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]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 ‘’’ AND queue_name = ? ORDER BY interface’ at line 1 (226)
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]…
[Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk
[Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]

The following error suggests that my syntax is incorrect, that syntax seems to be part of an SQL query. I do not have any SQL queries anywhere within my configuration.
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 ‘’’ AND queue_name = ? ORDER BY interface’ at line 1 (226)

Most of the other errors are related to ODBC, it keeps on connecting and disconnecting, apparently this is normal but I would like to fix it.

I would greatly appreciate any help. Thank you.