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...@claborn.net
<mailto:mitch...@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
--
_____________________________________________________________________
-- 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
