Dominic
2018-Dec-04 13:50 UTC
[asterisk-users] asterisk is not seeing my queues in database
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? -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181204/d2aa5c0f/attachment.html>
Mitch Claborn
2018-Dec-04 14:07 UTC
[asterisk-users] asterisk is not seeing my queues in database
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? >
Dominic
2018-Dec-04 16:46 UTC
[asterisk-users] asterisk is not seeing my queues in database
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_ml at 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-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181204/b86338f0/attachment.html>