thr3ads.net - asterisk users - [asterisk-users] asterisk is not seeing my queues in database [Dec 2018]

If this information is useful, please help other people find it:
Share via:

Dominic

2018-Dec-04 16:46 UTC

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

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>

Mitch Claborn

2018-Dec-04 17:21 UTC

head link

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

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

Dominic

2018-Dec-04 17:33 UTC

head link

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

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>

asterisk users - Dec 2018 - asterisk is not seeing my queues in database

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

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

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