[asterisk-users] asterisk is not seeing my queues in database
Dominic
wallnut.monkeys at gmail.com
Tue Dec 4 11:33:01 CST 2018
yep here is the result:
mysql> SELECT * FROM queues WHERE name = 'cou0002-test'\G
*************************** 1. row ***************************
name: cou0002-test
musicclass: NULL
announce: NULL
context: NULL
exitcontext: NULL
membermacro: NULL
membergosub: NULL
defaultrule: NULL
timeout: NULL
ringinuse: 0
monitor_type: mixmonitor
monitor_format:
queue_youarenext: NULL
queue_thereare: NULL
queue_callswaiting: NULL
queue_quantity1: NULL
queue_quantity2: NULL
queue_holdtime: NULL
queue_minutes: NULL
queue_minute: NULL
queue_seconds: NULL
queue_thankyou: NULL
queue_callerannounce: NULL
queue_reporthold: NULL
announce_frequency: NULL
min_announce_frequency: NULL
announce_round_seconds: NULL
announce_holdtime: no
announce_position: no
announce_position_limit: NULL
periodic_announce: NULL
periodic_announce_frequency: NULL
random_periodic_announce: NULL
relative_periodic_announce: NULL
retry: NULL
wrapuptime: NULL
extrawrapuptime: NULL
autofill: 0
autopause: no
maxlen: NULL
servicelevel: NULL
strategy: ringall
joinempty: no
leavewhenempty: no
eventmemberstatus: NULL
eventwhencalled: NULL
reportholdtime: NULL
memberdelay: NULL
weight: NULL
timeoutrestart: NULL
timeoutpriority: NULL
setinterfacevar: 1
setqueuevar: 1
setqueueentryvar: 1
accountcode: cou0002
description: test
archived: 0
hide_callerid: 0
autoanswer: 0
restroomtime: NULL
lunchtime: NULL
trainingtime: NULL
meetingtime: NULL
customtime: NULL
max_waiting_time: NULL
pauses_time: {"training": {"active": false, "time": 1800},
"coffee": {"active": false, "time": 900}, "restroom": {"active": false,
"time": 300}, "other4": {"active": false, "time": 900}, "lunch": {"active":
false, "time": 1800}, "other1": {"active": false, "time": 900}, "other2":
{"active": false, "time": 900}, "other3": {"active": false, "time": 900},
"custom": {"active": false, "time": 900}, "meeting": {"active": false,
"time": 1800}, "extrawrapup": {"active": false, "time": 30}}
1 row in set (0.00 sec)
On Tue, Dec 4, 2018 at 12:22 PM Mitch Claborn <mitch_ml at claborn.net> wrote:
> 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
> >
> >
>
> --
> _____________________________________________________________________
> -- 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/35f868f4/attachment.html>
More information about the asterisk-users
mailing list