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
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
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)
;
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($[${ROW_RESULT} =
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:
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
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.
Regards,
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
instead
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
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
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 for me
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
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
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`
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
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 tomcoope...@yahoo.com
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 ldard...@gmail.com
To: Tommy Cooper tomcoope...@yahoo.com; Asterisk Users Mailing List -
Non-Commercial
2013/4/18 Tommy Cooper tomcoope...@yahoo.com:
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 ldard...@gmail.com
To: Tommy Cooper tomcoope...@yahoo.com;
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;
19 matches
Mail list logo