Hello.

I’m using Asterisk 14.0.2 and I’m not sure exactly when this problem starts to happen, but maybe somebody here can help me with it.

I’m using queues with realtime configuration but the system is not loading the queues.

Let me show you what happens when I’m trying to load the module app_queue.so (core set debug 100):

[Oct 1 18:33:15] DEBUG[18028] loader.c: Registering module app_queue
[Oct 1 18:33:15] DEBUG[18028] config.c: Parsing /etc/asterisk/queuerules.conf
[Oct 1 18:33:15] VERBOSE[18028] config.c: Parsing
‘/etc/asterisk/queuerules.conf’: Found
[Oct 1 18:33:15] DEBUG[18028] config.c: Parsing /etc/asterisk/queues.conf
[Oct 1 18:33:15] VERBOSE[18028] config.c: Parsing
‘/etc/asterisk/queues.conf’: Found
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Reusing ODBC handle
0x1f1a3d0 from class ‘asterisk’
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found queue_name column with type 12 with len 80, octetlen 255, and numlen (0,0)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found interface column with type 12 with len 80, octetlen 255, and numlen (0,0)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found membername column with type 12 with len 80, octetlen 255, and numlen (0,0)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found state_interface column with type 12 with len 80, octetlen 255, and numlen (0,0)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found penalty column with type 4 with len 10, octetlen -1, and numlen (0,10)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found paused column with type 4 with len 10, octetlen -1, and numlen (0,10)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Found uniqueid column with type 4 with len 10, octetlen -1, and numlen (0,10)
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Releasing ODBC handle
0x1f1a3d0 into pool
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Reusing ODBC handle
0x1f1a3d0 from class ‘asterisk’
[Oct 1 18:33:15] DEBUG[18028] res_config_odbc.c: Skip: 0; SQL: SELECT
* FROM queue_members WHERE interface LIKE ? AND queue_name LIKE ?
ORDER
BY interface
[Oct 1 18:33:15] DEBUG[18028] res_config_odbc.c: Parameter 1
(‘interface LIKE’) = ‘%’
[Oct 1 18:33:15] DEBUG[18028] res_config_odbc.c: Parameter 2
(‘queue_name LIKE’) = ‘%’
[Oct 1 18:33:15] DEBUG[18028] res_odbc.c: Releasing ODBC handle
0x1f1a3d0 into pool
[Oct 1 18:33:15] NOTICE[18028] app_queue.c: No entries were found for ringinuse/ignorebusy in queue_members table. Using ‘ringinuse’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application ‘Queue’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application
‘AddQueueMember’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application
‘RemoveQueueMember’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application
‘PauseQueueMember’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application
‘UnpauseQueueMember’
[Oct 1 18:33:15] VERBOSE[18028] pbx_app.c: Registered application ‘QueueLog’
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action Queues
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueStatus
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueSummary
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueAdd
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueRemove
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueuePause
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueLog
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueuePenalty
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueMemberRingInUse
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueRule
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueReload
[Oct 1 18:33:15] VERBOSE[18028] manager.c: Manager registered action QueueReset
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_VARIABLES’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_EXISTS’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_MEMBER’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_MEMBER_COUNT’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_MEMBER_LIST’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_GET_CHANNEL’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_WAITING_COUNT’
[Oct 1 18:33:15] VERBOSE[18028] pbx_functions.c: Registered custom function ‘QUEUE_MEMBER_PENALTY’
[Oct 1 18:33:15] VERBOSE[18028] loader.c: Loaded app_queue.so =>
(True Call Queueing)

As you can see, there is no mention of table queues, just of table queue_members and probably this is the problem, but I don’t know why it is happening.

My extconfig.conf:

queues => odbc,asterisk queue_members => odbc,asterisk

And my tables:

asterisk=# SELECT COUNT(name) from queues;
count
—–