VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
rizwanhasham at gmail.com
Guest
|
|
| Back to top |
|
 |
atis at iq-labs.net
Guest
|
 Posted: Mon Jun 02, 2008 5:48 am Post subject: [asterisk-users] Mysql and extensions.conf |
 |
|
Hi,
You can use func_realtime in dialplan, that will be much faster as it
doesn't create separate process (as AGI does), and uses internal
asterisk connection pool, so no extra code in dialplan.
http://www.voip-info.org/wiki/index.php?page=Asterisk+func+realtime
Regards,
Atis
On Mon, Jun 2, 2008 at 1:33 PM, michael_t Gazeta.pl <michael_t at gazeta.pl> wrote:
| Quote: | Thank you, I was able to do it with simple script with AGI and perl but will
reconsider doing it again with MYSQL command as it looks like even simpler
solution. Already with addons.
BTW. Perl scripting and LPT port gave me nice idea to connect my entry phone
to asterisk, just need to make entry phone sending DTMF codes.
2008/6/2, Rizwan Hisham <rizwanhasham at gmail.com>:
| Quote: |
You should take a look at this:
http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+MYSQL
I thin you will need asterisk addons package to be able to use MYSQL
command in extensions.conf.
On Sun, Jun 1, 2008 at 10:26 PM, michael_t Gazeta.pl <michael_t at gazeta.pl>
wrote:
| Quote: |
Hi,
I have MySql server with database and need to make extensions conf
letting calls through if database field equals 1 and not if it is 0.
Database is ready but I'm haveing problem with extensions.conf. Don't want
to involve any high tech scripts just simple solution. If someone can help
me with my problem it would be great.
Thankyou.
Michael.
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
--
Best Regards
Rizwan Hisham
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
--
Atis Lezdins,
VoIP Project Manager / Developer,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835 |
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Mon Jun 02, 2008 10:14 am Post subject: [asterisk-users] Mysql and extensions.conf |
|
|
On Monday 02 June 2008 05:48, Atis Lezdins wrote:
That assumes that he's using a realtime table. From the OP's description,
it sounded like he wanted to query a column of an arbitrary table. Another
solution, in addition to the MYSQL app, would be func_odbc:
func_odbc.conf:
[FOO]
dsn=mysql-asterisk
read=SELECT status FROM foo WHERE id='${ARG1}'
extensions.conf:
GotoIf($[0${ODBC_FOO(123)} > 0]?open:closed)
--
Tilghman |
|
| Back to top |
|
|
bwentdg at pipeline.com
Guest
|
| Posted: Wed Jun 04, 2008 2:07 am Post subject: [asterisk-users] Mysql and extensions.conf |
|
|
yes - but what would REALLY BE GOOD is if func_odbc
allowed Muli-stepped SQL. Since that is the ONLY way to execute a
TRANSACTION
How they thought it was a "Good Idea" to hamstring func_odbc like they
did is beyond me.
Tilghman Lesher wrote:
| Quote: | On Monday 02 June 2008 05:48, Atis Lezdins wrote:
That assumes that he's using a realtime table. From the OP's description,
it sounded like he wanted to query a column of an arbitrary table. Another
solution, in addition to the MYSQL app, would be func_odbc:
func_odbc.conf:
[FOO]
dsn=mysql-asterisk
read=SELECT status FROM foo WHERE id='${ARG1}'
extensions.conf:
GotoIf($[0${ODBC_FOO(123)} > 0]?open:closed)
|
|
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Wed Jun 04, 2008 8:02 am Post subject: [asterisk-users] Mysql and extensions.conf |
|
|
On Wednesday 04 June 2008 02:07:13 Al Baker wrote:
| Quote: | Tilghman Lesher wrote:
| Quote: | On Monday 02 June 2008 05:48, Atis Lezdins wrote:
That assumes that he's using a realtime table. From the OP's
description, it sounded like he wanted to query a column of an arbitrary
table. Another solution, in addition to the MYSQL app, would be
func_odbc:
func_odbc.conf:
[FOO]
dsn=mysql-asterisk
read=SELECT status FROM foo WHERE id='${ARG1}'
extensions.conf:
GotoIf($[0${ODBC_FOO(123)} > 0]?open:closed)
|
yes - but what would REALLY BE GOOD is if func_odbc
allowed Muli-stepped SQL. Since that is the ONLY way to execute a
TRANSACTION
How they thought it was a "Good Idea" to hamstring func_odbc like they
did is beyond me.
|
Not they -- me. And I'm working on transactional support. If this is really
something you're interested in, then I hope you will test the functionality
when it's ready for that stage of development.
--
Tilghman |
|
| Back to top |
|
|
|
|
|
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
|
Search
