similar to: Realtime queues with Firebird SQL through unixodbc

I have configured my mysql database by following this link http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue The only difference is that I am using ODBC instead of MySQL with Realtime. Within extensions.conf I have the following for my queue exten => 9**2**1611,1,Answer exten => 9**2**1611,2,Queue(irock.com,tT,,,300) exten => *50,1,Answer exten =>

Hello, I'm using MySQL realtime Call Queues (table /queues/ and table /queue_members/). I would like to ring the members of the call queue in a certain order. Therefore I use ring strategy /lineair /and I put the members into the table /queue_members/ in the order in which they have to be rang. So I have the queue : | name | musicclass | announce | context | timeout |

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk

Does anybody have realtime queue members working? Not the queues themselves, just the members. I have realtime working for voicemail and sippeers, but I can't get queue members to work. Here is what I have: res_mysql.conf: [general] dbhost = 127.0.0.1 dbname = ASTERISK dbuser = myuser dbpass = mypass dbport = 3306 dbsock = /tmp/mysql.sock queues.conf: [general]

Hi, ? I want queues.conf to be stored on a MySQL database using dynamic realtime. I am using asterisk 11.2.1 and?MySQL 5.1.67, the?MySQL database is hosted on?another server but?I can access the?database via ODBC. ? I have created the following tables: ? SQL> show tables; +-----------------------------------------------------------------+ |

I have queue set up in realtime on Asterisk 1.4.2. Below is the senario that is happenening :: I have created a test queue with only one agent. Once I call the test queue the agents phone rings if the aagent is logged on. everything till here is fine. Now if the agent does not pick up the call, the call automaticaly disconnects after 15 secs as set for the queue, till here also it is fine. But

Hi, Sorry to resend the same question. This mail is just to add a few bits of details: When I tried to join the "support" queue, I get L RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'Support' ORDER BY interface [Mar 29 10:01:52] WARNING[6203]: app_queue.c:3939 queue_exec: Unable to join queue 'Support' In

I have only this platform to try it on, but observe the following inconsistencies: (from the manpage for 'net'): RAP PRINTQ RAP PRINTQ LIST QUEUE_NAME Lists the specified print queue and print jobs on the server. If the QUEUE_NAME is omitted, all queues are listed. ...OK, so: [novosirj@njmsa ~]> /products/samba/bin/net rap printq list ljndemo No command: list

hi all : mysql mailbox below : CREATE TABLE `mailbox` ( `username` varchar(255) NOT NULL DEFAULT '', `uid` varchar(255) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL DEFAULT '', `clearpwd` varchar(128) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `mailhost` varchar(255) NOT NULL DEFAULT '', `maildir`

hi, all i try to confiture realtime queue, but not work, details as below: Insert into queue_table(name)value('95040654321'); INSERT INTO queue_member_table VALUES ('', 'Zhang Shukun', '95040654321', 'SIP/1001', 2, 1); INSERT INTO queue_member_table VALUES ('', 'Li Aiwei', '95040654321', 'SIP/1002', 2, 1); INSERT INTO

Hi We're using 1.8.23.1 on CentOS 5 and are trying to get accurate stats for queues. For a particular customer, when I run queue show <queue_name> I get the following numbers: <queue_name> has 0 calls (max unlimited) in 'ringall' strategy (17s holdtime, 94s talktime), W:0, C:175, A:44, SL:48.6% within 45s So from that data we look at 17s holdtime And assume that is the

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik <ish at pack-net.co.uk> wrote: > Hi > > We're using 1.8.23.1 on CentOS 5 and are trying to get accurate stats for > queues. > > For a particular customer, when I run queue show <queue_name> I get the > following numbers: > > <queue_name> has 0 calls (max unlimited) in 'ringall' strategy (17s

Hi, im new to RoR so sorry if the questions sounds stupid to you. Im trying to build a tool for a browsergame. The game allows access to its database and the db looks like this: table villages: `id` int(9) unsigned NOT NULL default ''0'', `x` smallint(3) NOT NULL default ''0'', `y` smallint(3) NOT NULL default ''0'', `tid` tinyint(1)

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

Hi! I'd like to encode from a 22050 Hz source wav file (only in that case), but i get the following error message: "Invalid floating point operation" I use delphi: vorbis_encode_init_vbr(vi,2,22050,0.5) . . . While (i < readCount div 4) Do Begin buffer[0][i] := smallInt((pArray(@readbuffer)[i shl 2 + 1] shl 8) or pArray(@readbuffer)[i shl 2 + 0]) / 32768;

I am running the following migration with PostgreSQL 8.2.5. It works fine on my Windows machine, but gives me the below error on Linux CentOS 4.3. Any ideas? Thanks, Chirag class CreateUsers < ActiveRecord::Migration def self.up create_table :uers do |t| t.column :timestamp, :timestamp_with_time_zone t.column :userval, :integer, :limit => 1, :null=> false #will use

Hi friends, I am migrating imap-courier to dovecot, I use openbsd+postfix+imap-courier, and now I'm trying to run openbsd+opensmtpd+dovecot. In the beginning it was a little traumante but it works OpenSMTPD correctly. Now I have configured dovecot, and I hope that your backend authorization is the same database that was used imap-courier. In /var/log/maillog receipt the following error

It's my understanding that the backport is available now in 1.4. However, seem to be having some issues with it. Just wondering if I have everything setup right. I'm running 1.4.26.2 realtime. queue_members: `uniqueid` int(10) unsigned NOT NULL auto_increment, `membername` varchar(40) default NULL, `queue_name` varchar(128) default NULL, `interface` varchar(128) default NULL,

I am using a smallint database column to store several boolean flags. The flags are accessible thru facade column accessors. I''d like to hide the database column so all access is thru the facade accessors. How do I do it? TIA, Jeffrey