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.254384Z 229 Prepare SELECT * FROM queues WHERE name = ? 2018-12-04T16:29:27.254902Z 229 Execute SELECT * FROM queues WHERE name = 'cou0002-test' 2018-12-04T16:29:27.255606Z 229 Close stmt I also ran the query (SELECT * FROM queues WHERE name = 'cou0002-test') on the db and I do get a result. On Tue, Dec 4, 2018 at 9:08 AM Mitch Claborn <mitch...@claborn.net> wrote: > 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, Dominic wrote: > > 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 load sippeers name > > > > Then I get a result. Since my queues table is in the same database as my > > sippeers table, I was expecting consistent result between the two. > > > > I am a bit stuck here on where to look for errors or how I can debug > > this issue, I can't see any error messages when I call the Queue > > application besides "queue_exec: Unable to join queue". Also, this is an > > almost exact copy of an existing Asterisk, so I'm confident the table > > structure is correct but I'm obviously missing something. > > > > Any suggestions? > > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: > https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users