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>
Mitch Claborn
2018-Dec-04 17:21 UTC
[asterisk-users] asterisk is not seeing my queues in database
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 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 > <mailto: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 > >
Dominic
2018-Dec-04 17:33 UTC
[asterisk-users] asterisk is not seeing my queues in database
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 exitcontext: NULL membermacro: NULL membergosub: NULL defaultrule: NULL timeout: NULL ringinuse: 0 monitor_type: mixmonitor monitor_format: queue_youarenext: NULL queue_thereare: NULL queue_callswaiting: NULL queue_quantity1: NULL queue_quantity2: NULL queue_holdtime: NULL queue_minutes: NULL queue_minute: NULL queue_seconds: NULL queue_thankyou: NULL queue_callerannounce: NULL queue_reporthold: NULL announce_frequency: NULL min_announce_frequency: NULL announce_round_seconds: NULL announce_holdtime: no announce_position: no announce_position_limit: NULL periodic_announce: NULL periodic_announce_frequency: NULL random_periodic_announce: NULL relative_periodic_announce: NULL retry: NULL wrapuptime: NULL extrawrapuptime: NULL autofill: 0 autopause: no maxlen: NULL servicelevel: NULL strategy: ringall joinempty: no leavewhenempty: no eventmemberstatus: NULL eventwhencalled: NULL reportholdtime: NULL memberdelay: NULL weight: NULL timeoutrestart: NULL timeoutpriority: NULL setinterfacevar: 1 setqueuevar: 1 setqueueentryvar: 1 accountcode: cou0002 description: test archived: 0 hide_callerid: 0 autoanswer: 0 restroomtime: NULL lunchtime: NULL trainingtime: NULL meetingtime: NULL customtime: NULL max_waiting_time: NULL pauses_time: {"training": {"active": false, "time": 1800}, "coffee": {"active": false, "time": 900}, "restroom": {"active": false, "time": 300}, "other4": {"active": false, "time": 900}, "lunch": {"active": false, "time": 1800}, "other1": {"active": false, "time": 900}, "other2": {"active": false, "time": 900}, "other3": {"active": false, "time": 900}, "custom": {"active": false, "time": 900}, "meeting": {"active": false, "time": 1800}, "extrawrapup": {"active": false, "time": 30}} 1 row in set (0.00 sec) On Tue, Dec 4, 2018 at 12:22 PM Mitch Claborn <mitch_ml at claborn.net> wrote:> 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 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 > > <mailto: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 > > > > > > -- > _____________________________________________________________________ > -- 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/35f868f4/attachment.html>