[root@pbx-new ~]# cat /etc/asterisk/extconfig.conf [settings] sipusers => odbc,asterisk,sip sippeers => odbc,asterisk,sip voicemail => odbc,asterisk,voicemail queues => odbc,asterisk,queues queue_members => odbc,asterisk,queuemembers extensions => odbc,asterisk,dlp_extensions iaxusers => odbc,asterisk,iax iaxpeers => odbc,asterisk,iax mysql> describe queues; +-----------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+--------------+------+-----+---------+-------+ | name | varchar(128) | NO | PRI | NULL | | | musiconhold | varchar(128) | YES | | NULL | | | announce | varchar(128) | YES | | NULL | | | context | varchar(128) | YES | | NULL | | | timeout | int(11) | YES | | NULL | | | monitor_join | tinyint(1) | YES | | NULL | | | monitor_format | varchar(128) | YES | | NULL | | | queue_youarenext | varchar(128) | YES | | NULL | | | queue_thereare | varchar(128) | YES | | NULL | | | queue_callswaiting | varchar(128) | YES | | NULL | | | queue_holdtime | varchar(128) | YES | | NULL | | | queue_minutes | varchar(128) | YES | | NULL | | | queue_seconds | varchar(128) | YES | | NULL | | | queue_lessthan | varchar(128) | YES | | NULL | | | queue_thankyou | varchar(128) | YES | | NULL | | | queue_reporthold | varchar(128) | YES | | NULL | | | announce_frequency | int(11) | YES | | NULL | | | announce_round_seconds | int(11) | YES | | NULL | | | announce_holdtime | varchar(128) | YES | | NULL | | | announce_position | varchar(128) | YES | | NULL | | | retry | int(11) | YES | | NULL | | | wrapuptime | int(11) | YES | | NULL | | | maxlen | int(11) | YES | | NULL | | | servicelevel | int(11) | YES | | NULL | | | strategy | varchar(128) | YES | | NULL | | | joinempty | varchar(128) | YES | | NULL | | | leavewhenempty | varchar(128) | YES | | NULL | | | eventmemberstatus | tinyint(1) | YES | | NULL | | | eventwhencalled | tinyint(1) | YES | | NULL | | | reportholdtime | tinyint(1) | YES | | NULL | | | memberdelay | int(11) | YES | | NULL | | | weight | int(11) | YES | | NULL | | | timeoutrestart | tinyint(1) | YES | | NULL | | | ringinuse | varchar(3) | YES | | NULL | | | periodic_announce | varchar(50) | YES | | NULL | | | periodic_announce_frequency | int(11) | YES | | NULL | | | setinterfacevar | tinyint(1) | YES | | NULL | | | autofill | varchar(80) | YES | | NULL | | +-----------------------------+--------------+------+-----+---------+-------+ 38 rows in set (0.00 sec) mysql> select * from queues; +------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------------------+-------+------------+--------+--------------+----------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-------------------+-----------------------------+-----------------+----------+ | name | musiconhold | announce | context | timeout | monitor_join | monitor_format | queue_youarenext | queue_thereare | queue_callswaiting | queue_holdtime | queue_minutes | queue_seconds | queue_lessthan | queue_thankyou | queue_reporthold | announce_frequency | announce_round_seconds | announce_holdtime | announce_position | retry | wrapuptime | maxlen | servicelevel | strategy | joinempty | leavewhenempty | eventmemberstatus | eventwhencalled | reportholdtime | memberdelay | weight | timeoutrestart | ringinuse | periodic_announce | periodic_announce_frequency | setinterfacevar | autofill | +------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------------------+-------+------------+--------+--------------+----------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-------------------+-----------------------------+-----------------+----------+ | 500 | default | NULL | queue-500 | 15 | 0 | wav | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | no | no | 5 | 1 | 0 | 20 | ringall | invalid | no | 0 | 0 | 0 | 0 | NULL | NULL | no | | 0 | NULL | 1 | +------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------------------+-------+------------+--------+--------------+----------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-------------------+-----------------------------+-----------------+----------+ 1 row in set (0.00 sec) mysql> select * from queuemembers; +----------+------------+------------+-----------+---------+--------+ | uniqueid | membername | queue_name | interface | penalty | paused | +----------+------------+------------+-----------+---------+--------+ | 1 | Sandra | 500 | SIP/2000 | NULL | 0 | +----------+------------+------------+-----------+---------+--------+ 1 row in set (0.00 sec) mysql> select * from sip where name = '2000'; +----------+------+----------+----------------------+------+--------+--------+-----------+--------------+-----------+---------+---------------------+--------+-------------+----------+----------------+----------+-----------+----------+----------+------------+----------+----------+---------+------------------+---------+----------+------------+----------------+--------+----------+-------+----------------------------------------------+----------------+------+-------------+------------------+-------------+-----------+----------+----------------+--------------+---------------+-------------+-----------+--------------+----------------+---------------+------------------+--------------+----------------+-------------------+----------------+-----------------+---------------+-------------------+--------------------+---------------+-------------------+----------------+---------+--------+-------------+---------------+-------------+--------+-----------+------------+--------------------+ | uniqueid | name | context | callingpres | deny | permit | secret | md5secret | remotesecret | transport | host | nat | type | accountcode | amaflags | namedcallgroup | callerid | defaultip | dtmfmode | fromuser | fromdomain | insecure | language | mailbox | namedpickupgroup | qualify | regexten | rtptimeout | rtpholdtimeout | setvar | disallow | allow | fullcontact | ipaddr | port | defaultuser | subscribecontext | directmedia | trustrpid | sendrpid | progressinband | promiscredir | useclientcode | callcounter | busylevel | allowoverlap | allowsubscribe | allowtransfer | ignoresdpversion | videosupport | maxcallbitrate | rfc2833compensate | session-timers | session-expires | session-minse | session-refresher | t38pt_usertpsource | outboundproxy | callbackextension | registertrying | timert1 | timerb | qualifyfreq | contactpermit | contactdeny | lastms | regserver | regseconds | useragent | +----------+------+----------+----------------------+------+--------+--------+-----------+--------------+-----------+---------+---------------------+--------+-------------+----------+----------------+----------+-----------+----------+----------+------------+----------+----------+---------+------------------+---------+----------+------------+----------------+--------+----------+-------+----------------------------------------------+----------------+------+-------------+------------------+-------------+-----------+----------+----------------+--------------+---------------+-------------+-----------+--------------+----------------+---------------+------------------+--------------+----------------+-------------------+----------------+-----------------+---------------+-------------------+--------------------+---------------+-------------------+----------------+---------+--------+-------------+---------------+-------------+--------+-----------+------------+--------------------+ | 1 | 2000 | internal | allowed_not_screened | NULL | NULL | 12345 | NULL | NULL | NULL | dynamic | force_rport,comedia | friend | no | NULL | support | Sandra | NULL | rfc2833 | NULL | NULL | NULL | NULL | NULL | support | yes | NULL | NULL | NULL | NULL | all | g729 | sip:2000@192.168.88.180:2204^3Bline=26e4p0wo | 192.168.88.180 | 2204 | 2000 | NULL | no | NULL | NULL | NULL | NULL | NULL | | NULL | yes | yes | yes | no | no | NULL | yes | accept | 1800 | 90 | uas | NULL | NULL | NULL | yes | 500 | NULL | 120 | NULL | NULL | 24 | | 1522824226 | snom300/8.7.3.25.9 | +----------+------+----------+----------------------+------+--------+--------+-----------+--------------+-----------+---------+---------------------+--------+-------------+----------+----------------+----------+-----------+----------+----------+------------+----------+----------+---------+------------------+---------+----------+------------+----------------+--------+----------+-------+----------------------------------------------+----------------+------+-------------+------------------+-------------+-----------+----------+----------------+--------------+---------------+-------------+-----------+--------------+----------------+---------------+------------------+--------------+----------------+-------------------+----------------+-----------------+---------------+-------------------+--------------------+---------------+-------------------+----------------+---------+--------+-------------+---------------+-------------+--------+-----------+------------+--------------------+