[asterisk-users] Problems with queues realtime configuration

[Marcelo Terres]

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
-------
     3
(1 row)

asterisk=# SELECT COUNT(queue_name) from queue_members;
 count
-------
     1
(1 row)


Any ideas? Anybody is facing the same problem?

I was thinking in opening an issue but first I'd like to have your
opinion on that.

Thanks.

Regards,

Marcelo H. Terres <mhterres at gmail.com>
IM: mhterres at jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres