yep here is the result:
mysql> SELECT * FROM queues WHERE name = 'cou0002-test'\G
*** 1. row ***
name: cou0002-test
musicclass: NULL
announce: NULL
context: NULL
Maybe post the result from that query here?
Mitch
On 12/4/18 10:46 AM, Dominic wrote:
I enabled the logs on the mysql database and ran :
realtime load queues name cou0002-test
in the mysql log I can see that the proper select statement is being
executed:
2018-12-04T16:29:27.253094Z 22
I enabled the logs on the mysql database and ran :
realtime load queues name cou0002-test
in the mysql log I can see that the proper select statement is being
executed:
2018-12-04T16:29:27.253094Z 229 Query SET SESSION TRANSACTION
ISOLATION LEVEL READ COMMITTED
2018-12-04T16:29:27.25438
Maybe try capturing the queries that are executed on the mysql server?
That might point you in the right direction.
-- show the log file name
SHOW VARIABLES LIKE 'general_log%';
-- turn logging on and off
SET GLOBAL general_log='ON';
SET GLOBAL general_log='OFF';
Mitch
On 12/4/18 7:50 AM, Do
Hi I am facing an issue where asterisk cannot see the queues that exist in
my database through realtime. I am using res_odbc and a local mysql
database.
If I run:
realtime load queues name myqueue
I get "No rows found matching search criteria.", however if I do the same
for a peer:
realtime loa