Confirmed, I open an issue about it: [JIRA] (ASTERISK-26431) Queues doesn't appear when using realtime configuration
Marcelo H. Terres <[email protected]> IM: [email protected] 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 <[email protected]> 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 <[email protected]> > IM: [email protected] > https://www.mundoopensource.com.br > https://twitter.com/mhterres > https://linkedin.com/in/marceloterres -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016 http://www.asterisk.org/community/astricon-user-conference New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
