[asterisk-users] asterisk is not seeing my queues in database

[Dominic]

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>