[asterisk-users] Problems with queues realtime configuration

[Marcelo Terres]

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