thr3ads.net - asterisk users - [asterisk-users] Problems with queues realtime configuration [Oct 2016]

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

Marcelo Terres

2016-Oct-01 21:42 UTC

[asterisk-users] Problems with queues realtime configuration

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

Marcelo Terres

2016-Oct-02 18:51 UTC

head link

[asterisk-users] Problems with queues realtime configuration

Confirmed, I open an issue about it:

[JIRA] (ASTERISK-26431) Queues doesn't appear when using realtime
configuration


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


On Sat, Oct 1, 2016 at 2:42 PM, Marcelo Terres <mhterres at gmail.com>
wrote:> 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

asterisk users - Oct 2016 - Problems with queues realtime configuration

[asterisk-users] Problems with queues realtime configuration

[asterisk-users] Problems with queues realtime configuration