[asterisk-users] asterisk is not seeing my queues in database
mitch_ml at claborn.net
Tue Dec 4 11:21:22 CST 2018
Maybe post the result from that query here?
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
> 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';
> On 12/4/18 7:50 AM, Dominic wrote:
> > Hi I am facing an issue where asterisk cannot see the queues that
> > in my database through realtime. I am using res_odbc and a local
> > 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
> > 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:
> New to Asterisk? Start here:
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
More information about the asterisk-users