VoIP Mailing List Archives

[dk at donkelly.biz]

I’m making changes to an Asterisk IVR designed by someone else.
The application uses both func_odbc.conf and php agi to access an external MySQL database.

In the php routines, I would like to use the persistent connection that is established in the dialplan, rather than creating a new connection each time they run. How can I do this?

In res_odbc.conf, the context “asterisk” is established, successfully referencing “asterisk-connector” in odbc.ini.

pre-connect => yes resulting in a persistent connection at startup.

Opening a connection in the php routines takes about 5 seconds, which is unacceptable.

--Don

[jcolp at digium.com]

Don Kelly wrote:

[dk at donkelly.biz]

[EWieling at nyigc.com]

Yes. Use func_odbc in your PHP AGI. In Asterisk dialplan functions are treated like dialplan variables so you can get and set them just like you would other dialplan variables.

If it takes 5 seconds to open a PDO DB connection inside PHP you have some OTHER problem.

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Don Kelly
Sent: Tuesday, December 03, 2013 9:50 AM
To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
Subject: Re: [asterisk-users] link to MySQL connection

[webaccounts at jgoettg...]

Then you should analyze why it takes 5s. Opening and closing a mysql connection should take at
most a fraction of a second on a local net.

BTW, classical web sites (plain PHP and HTML) do not maintain state, so keeping the mysql
connection open may not be at all possible. I forgot whether open db connections get closed
automatically after the web page has been rendered, but I think so. You could test this.

For data processing you do not want to got through Asterisk. You could actually write your own
db proxy, but I still think it makes more sense to find out why opening the db connection takes
so much time.

jg

--
_____________________________________________________________________
-- 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

[dk at donkelly.biz]

Then you should analyze why it takes 5s. Opening and closing a mysql
connection should take at most a fraction of a second on a local net.

BTW, classical web sites (plain PHP and HTML) do not maintain state, so
keeping the mysql connection open may not be at all possible. I forgot
whether open db connections get closed automatically after the web page has
been rendered, but I think so. You could test this.

For data processing you do not want to got through Asterisk. You could
actually write your own db proxy, but I still think it makes more sense to
find out why opening the db connection takes so much time.

jg

I'll look into why the connection takes so long.

I'm looking for a quick fix for the problem

Long term, I think a web service would be better for what this routine is
doing. It doesn't do any telephony stuff and only requires one variable from
the dialplan.

--Don

_____________________________________________________________________
-- 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


--
_____________________________________________________________________
-- 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

[dk at donkelly.biz]

[asterisk.org at sedwar...]

On Tue, 3 Dec 2013, Don Kelly wrote:

[james at fivecats.org]

On 12/3/2013 10:11 AM, Don Kelly wrote: