2013/4/18 Tommy Cooper <[email protected]>: > > > Thanks again for replying, I got a wireshark capture with that command you > provided. Please find attached the wireshark capture > > ----- Forwarded Message ----- > From: Leandro Dardini <[email protected]> > To: Tommy Cooper <[email protected]>; Asterisk Users Mailing List - > Non-Commercial Discussion <[email protected]> > Sent: Thursday, April 18, 2013 11:32 PM > Subject: Re: [asterisk-users] Dynamic realtime + queues > > Uhm ... I see the easy way will be to tcpdump the connection between the > asterisk and the mysql database server and to dump the exact SQL syntax > used. It will be something wrong... > > Leandro > > PS > tcpdump -i any -n -s 1500 -w /tmp/data.pcap port 3306 > > > > > 2013/4/18 Tommy Cooper <[email protected]> > > Thank you for your response > > I already have a name column but my primary key is 'QueueID' instead of name > > +-----------------------------+-----------------------+------+-----+------------+----------------+ > | Field | Type | Null | Key | Default > | Extra | > +-----------------------------+-----------------------+------+-----+------------+----------------+ > | QueueID | mediumint(8) unsigned | NO | PRI | NULL > | auto_increment | > | name | varchar(128) | NO | UNI | NULL > | | > | description | varchar(128) | YES | | NULL > | | > | maxlen | tinyint(4) | YES | | NULL > | | > | reportholdtime | varchar(3) | YES | | no > | | > | periodic_announce_frequency | varchar(4) | YES | | NULL > | | > | periodic_announce | varchar(128) | YES | | NULL > | | > | strategy | varchar(20) | NO | | > rrmemory | | > | joinempty | varchar(35) | YES | | no > | | > | leavewhenempty | varchar(35) | YES | | no > | | > | autopause | varchar(3) | YES | | no > | | > | announce_round_seconds | varchar(4) | YES | | NULL > | | > | retry | varchar(4) | YES | | NULL > | | > | wrapuptime | varchar(4) | YES | | NULL > | | > | announce_holdtime | varchar(3) | YES | | no > | | > | announce_frequency | varchar(4) | YES | | 0 > | | > | timeout | varchar(4) | YES | | 60 > | | > | context | varchar(128) | NO | | NULL > | | > | musicclass | varchar(128) | YES | | default > | | > | autofill | varchar(3) | YES | | yes > | | > | ringinuse | varchar(45) | YES | | no > | | > | musiconhold | varchar(128) | YES | | yes > | | > | monitor_type | varchar(128) | YES | | > MixMonitor | | > | monitor_format | varchar(128) | YES | | wav > | | > | servicelevel | varchar(4) | YES | | 60 > | | > | queue_thankyou | varchar(128) | YES | | > | | > | queue_youarenext | varchar(128) | YES | | > | | > | queue_thereare | varchar(128) | YES | | > | | > | queue_callswaiting | varchar(128) | YES | | > | | > | queue_holdtime | varchar(128) | YES | | > | | > | queue_minutes | varchar(128) | YES | | > | | > | queue_seconds | varchar(128) | YES | | > | | > | queue_lessthan | varchar(128) | YES | | > | | > | queue_reporthold | varchar(128) | YES | | > | | > | relative_periodic_announce | varchar(4) | YES | | yes > | | > +-----------------------------+-----------------------+------+-----+------------+----------------+ > 35 rows in set (0.00 sec) > > > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
TCP shows you have no queue_member_table on your database. http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue You must create one with command: CREATE TABLE queue_member_table ( uniqueid INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT, membername varchar(40), queue_name varchar(128), interface varchar(128), penalty INT(11), paused INT(11), UNIQUE KEY queue_interface (queue_name, interface) ); Regards José Flores Galicia -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
