Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] Problems with queues realtime configuration


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
mhterres at gmail.com
Guest





PostPosted: Sat Oct 01, 2016 4:42 pm    Post subject: [asterisk-users] Problems with queues realtime configuration Reply with quote

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@gmail.com>
IM: mhterres@jabber.mundoopensource.com.br
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
Back to top
mhterres at gmail.com
Guest





PostPosted: Sun Oct 02, 2016 1:51 pm    Post subject: [asterisk-users] Problems with queues realtime configuration Reply with quote

Confirmed, I open an issue about it:

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


Marcelo H. Terres <mhterres@gmail.com>
IM: mhterres@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@gmail.com> wrote:
Quote:
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@gmail.com>
IM: mhterres@jabber.mundoopensource.com.br
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services