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

[Mitch Claborn]

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