Thank you all for your help
Mr. José Flores Galicia,
I already have the queue_member_table and it has 1 record in it. I m not sure
what interface I have to enter in the interface field.
mysql> explain queue_member_table;
++--+--+-+-+---
2013/4/18 Tommy Cooper :
>
>
> 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
> To: Tommy Cooper ; Asterisk Users Mailing List -
> Non-Commercial Discussion
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
To: Tommy Cooper ; Asterisk Users Mailing List -
Non-Commercial Discussion
Sent: Thursday, April 18, 2013 11:
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
> Thank you for your r
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
You need a "name" column. This is my queue table:
CREATE TABLE IF NOT EXISTS `queue` (
`name` varchar(128) NOT NULL,
`musiconhold` varchar(128) DEFAULT NULL,
`announce` varchar(128) DEFAULT NULL,
`context` varchar(128) DEFAULT NULL,
`timeout` int(11) DEFAULT NULL,
`monitor_join` tinyin
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
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
On 04/18/2013 07:41 AM, jg wrote:
> Hi Pat!
>
> The book "Asterisk: The Definitive Guide" contains an example
> implementation of exactly what you need (search for hotdesk). There used
> to be a free online access to the book (but the link seems to be dead now).
http://asteriskdocs.org/
Works f
A select that returns 0 rows does not always mean error.
If you make your SQL do a little more specific lookup, you can avoid the
loop entirely.
Instead of your:
readsql=SELECT pin from users WHERE confid='${SQL_ESC(${CONF_ID})}'
Something like:
readsql=select if(count(value)=0,0,1) from users wh
Perfect
THANK YOU!!
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bharat
Lalcheta
Sent: Thursday, April 18, 2013 8:27 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] ODBC dial
Hi Pat!
The book "Asterisk: The Definitive Guide" contains an example
implementation of exactly what you need (search for hotdesk). There used
to be a free online access to the book (but the link seems to be dead now).
The basis difference is, that the authors used the "Read" command
instea
Sorry for that.
I believe that, dialplan misbehave only when you didn't get the result
right?...then instead of below
exten=_XX,n,GotoIf($["${ODBC_FETCH}" = "FAILURE"]?cleanup,1)
try this...
exten=_XX,n,GotoIf($["${ODBC_FETCH_STATUS}" = "FAILURE"]?cleanup,1)
Hope it helps you out.
Reg
Thanks for the reply Doug!
How might I incorporate this into my dialplan?
Sorry, learning as I go
On a side note, any idea how to strip off the # at the end of a string?
${EXTEN:0:6} doesn't do the trick.
Is this even possible?
Pat...
From: asterisk-users-boun...@lists.digium.com
[m
Thank you Bharat.
Sadly, that made no difference.
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bharat
Lalcheta
Sent: Thursday, April 18, 2013 7:33 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asteris
I think there is no problem with asterisk.
exten=_XX,n,GotoIf($["${ODBC_FETCH}" = "FAILURE"]?cleanup,1)
exten=_XX,n,GotoIf($["${ROW_RESULT}" = "${CONF_PIN}"]?good_exten,1)
It should be,
exten=_XX,n,GotoIf($["${ODBC_FETCH}" = "FAILURE"]?getpin,cleanup,1)
exten=_XX,n,GotoIf($["${R
>> The problem is that if a user enters a PIN that is NOT in the table,
>> asterisk goes crazy and continues to loop forever.
Why don't you use read instead? This is what I have:
exten => s,n,Answer(500)
exten => s,n,Read(get-room-num,conf-getconfno)
; **
All,
Thank you in advance for any help.
I have a customer in need of a conferencing system. A requirement is for
users to each have their own PIN for the same bridge.
So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC
connector to parse the table.
Asterisk is connected
On 04/02/2013 05:42 PM, Matthew Jordan wrote:
On 04/02/2013 06:37 AM, Jonas Kellens wrote:
On 04/02/2013 12:50 PM, A J Stiles wrote:
(Message re-ordered for readability. The beginning is *not* the right place
for your response -- answers come *after* questions, or *between* points.)
On Tuesda
19 matches
Mail list logo