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
[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