<div dir="ltr"><div dir="ltr"><div>yep here is the result:</div><div><span style="font-family:monospace,monospace">mysql> SELECT * FROM queues WHERE name = 'cou0002-test'\G<br>*************************** 1. row ***************************<br>                       name: cou0002-test<br>                 musicclass: NULL<br>                   announce: NULL<br>                    context: NULL<br>                exitcontext: NULL<br>                membermacro: NULL<br>                membergosub: NULL<br>                defaultrule: NULL<br>                    timeout: NULL<br>                  ringinuse: 0<br>               monitor_type: mixmonitor<br>             monitor_format:<br>           queue_youarenext: NULL<br>             queue_thereare: NULL<br>         queue_callswaiting: NULL<br>            queue_quantity1: NULL<br>            queue_quantity2: NULL<br>             queue_holdtime: NULL<br>              queue_minutes: NULL<br>               queue_minute: NULL<br>              queue_seconds: NULL<br>             queue_thankyou: NULL<br>       queue_callerannounce: NULL<br>           queue_reporthold: NULL<br>         announce_frequency: NULL<br>     min_announce_frequency: NULL<br>     announce_round_seconds: NULL<br>          announce_holdtime: no<br>          announce_position: no<br>    announce_position_limit: NULL<br>          periodic_announce: NULL<br>periodic_announce_frequency: NULL<br>   random_periodic_announce: NULL<br> relative_periodic_announce: NULL<br>                      retry: NULL<br>                 wrapuptime: NULL<br>            extrawrapuptime: NULL<br>                   autofill: 0<br>                  autopause: no<br>                     maxlen: NULL<br>               servicelevel: NULL<br>                   strategy: ringall<br>                  joinempty: no<br>             leavewhenempty: no<br>          eventmemberstatus: NULL<br>            eventwhencalled: NULL<br>             reportholdtime: NULL<br>                memberdelay: NULL<br>                     weight: NULL<br>             timeoutrestart: NULL<br>            timeoutpriority: NULL<br>            setinterfacevar: 1<br>                setqueuevar: 1<br>           setqueueentryvar: 1<br>                accountcode: cou0002<br>                description: test<br>                   archived: 0<br>              hide_callerid: 0<br>                 autoanswer: 0<br>               restroomtime: NULL<br>                  lunchtime: NULL<br>               trainingtime: NULL<br>                meetingtime: NULL<br>                 customtime: NULL<br>           max_waiting_time: NULL<br>                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}}<br>1 row in set (0.00 sec)<br></span><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Dec 4, 2018 at 12:22 PM Mitch Claborn <<a href="mailto:mitch_ml@claborn.net">mitch_ml@claborn.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Maybe post the result from that query here?<br>
<br>
<br>
Mitch<br>
<br>
On 12/4/18 10:46 AM, Dominic wrote:<br>
> I enabled the logs on the mysql database and ran :<br>
> <br>
> realtime load queues name cou0002-test<br>
> <br>
> in the mysql log I can see that the proper select statement is being <br>
> executed:<br>
> 2018-12-04T16:29:27.253094Z       229 Query     SET SESSION TRANSACTION <br>
> ISOLATION LEVEL READ COMMITTED<br>
> 2018-12-04T16:29:27.254384Z       229 Prepare   SELECT * FROM queues <br>
> WHERE name = ?<br>
> 2018-12-04T16:29:27.254902Z       229 Execute   SELECT * FROM queues <br>
> WHERE name = 'cou0002-test'<br>
> 2018-12-04T16:29:27.255606Z       229 Close stmt<br>
> <br>
> I also ran the query (SELECT * FROM queues WHERE name = 'cou0002-test') <br>
> on the db and I do get a result.<br>
> <br>
> <br>
> On Tue, Dec 4, 2018 at 9:08 AM Mitch Claborn <<a href="mailto:mitch_ml@claborn.net" target="_blank">mitch_ml@claborn.net</a> <br>
> <mailto:<a href="mailto:mitch_ml@claborn.net" target="_blank">mitch_ml@claborn.net</a>>> wrote:<br>
> <br>
>     Maybe try capturing the queries that are executed on the mysql server?<br>
>     That might point you in the right direction.<br>
> <br>
>     -- show the log file name<br>
>     SHOW VARIABLES LIKE 'general_log%';<br>
>     -- turn logging on and off<br>
>     SET GLOBAL general_log='ON';<br>
>     SET GLOBAL general_log='OFF';<br>
> <br>
> <br>
> <br>
>     Mitch<br>
> <br>
>     On 12/4/18 7:50 AM, Dominic wrote:<br>
>      > Hi I am facing an issue where asterisk cannot see the queues that<br>
>     exist<br>
>      > in my database through realtime. I am using res_odbc and a local<br>
>     mysql<br>
>      > database.<br>
>      ><br>
>      > If I run:<br>
>      ><br>
>      > realtime load queues name myqueue<br>
>      ><br>
>      > I get "No rows found matching search criteria.", however if I do the<br>
>      > same for a peer:<br>
>      ><br>
>      > realtime load sippeers name<br>
>      ><br>
>      > Then I get a result. Since my queues table is in the same<br>
>     database as my<br>
>      > sippeers table, I was expecting consistent result between the two.<br>
>      ><br>
>      > I am a bit stuck here on where to look for errors or how I can debug<br>
>      > this issue, I can't see any error messages when I call the Queue<br>
>      > application besides "queue_exec: Unable to join queue". Also,<br>
>     this is an<br>
>      > almost exact copy of an existing Asterisk, so I'm confident the<br>
>     table<br>
>      > structure is correct but I'm obviously missing something.<br>
>      ><br>
>      > Any suggestions?<br>
>      ><br>
> <br>
>     -- <br>
>     _____________________________________________________________________<br>
>     -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
> <br>
>     Check out the new Asterisk community forum at:<br>
>     <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.org/</a><br>
> <br>
>     New to Asterisk? Start here:<br>
>     <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wiki/display/AST/Getting+Started</a><br>
> <br>
>     asterisk-users mailing list<br>
>     To UNSUBSCRIBE or update options visit:<br>
>     <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
> <br>
> <br>
<br>
-- <br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
      <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wiki/display/AST/Getting+Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
   <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></blockquote></div>