Asterisk Is Not Seeing My Queues In Database

Home » Asterisk Users » Asterisk Is Not Seeing My Queues In Database
Asterisk Users 4 Comments

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?

4 thoughts on - Asterisk Is Not Seeing My Queues In Database

  • 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

    —

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

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