asterisk users - Dec 2018 - 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>

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?
>

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>