I am new to Asterisk, and I am having trouble connecting to the MySQL database located on the same machine as my Asterisk box. When the dialplan tried to connect to MySQL database, I get the following error message on the Asterisk console. Nov 15 09:29:41 WARNING[111139760]: pbx.c:1279 pbx_extension_helper: No application 'MYSQL' for extension (default, s, 5) Here is the corresponding line in my dialplan. exten => s,5,MYSQL(Connect connid localhost admin abc123 asteriskdb) I am able to connect to the database with the same username and password using the MySQL console. Am I missing something in my installation or configuration that would cause this? Thanks, Shaun
On Mon, 2004-11-15 at 10:04 -0600, Shaun Tierney wrote:> I am new to Asterisk, and I am having trouble connecting to the MySQL > database located on the same machine as my Asterisk box. When the dialplan > tried to connect to MySQL database, I get the following error message on the > Asterisk console. > > Nov 15 09:29:41 WARNING[111139760]: pbx.c:1279 pbx_extension_helper: No > application 'MYSQL' for extension (default, s, 5) > > Here is the corresponding line in my dialplan. > > exten => s,5,MYSQL(Connect connid localhost admin abc123 asteriskdb) > > I am able to connect to the database with the same username and password > using the MySQL console. Am I missing something in my installation or > configuration that would cause this?Yes you are missing something in your installation. From reading the error message I can see you did not build the mysql application. My guess would be that it is not enabled in the makefile. Go edit it, compile, install, and try again. -- Steven Critchfield <critch@basesys.com>
Right, sorry I figured that was what you ultimately wanted to do. ---------------------------------------- Michael Shuler, C.E.O. BitWise Communications, Inc. (CLEC) And BitWise Systems, Inc. (ISP) 682 High Point Lane East Peoria, IL 61611 Office: (217) 585-0357 Cell: (309) 657-6365 Fax: (309) 213-3500 E-Mail: mike@bwsys.net Customer Service: (877) 976-0711> -----Original Message----- > From: asterisk-users-bounces@lists.digium.com > [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of > Chris A. Icide > Sent: Monday, November 15, 2004 12:32 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: RE: [Asterisk-Users] MYSQL Dialplan Question > > > On 10:19 AM 11/15/2004, Michael Shuler wrote: > >If you want good mysql/postgres/odbc/etc. support use > >http://svn.asteriskdocs.org/res_data/ > > > > I may be incorrect, but I believe that res_data only lets you move > configuration information into a database, however, what if > you want to > access databases and tables that have nothing at all to do with > configuration data? > > The MYSQL application allows you to access any MySQL > host.database.table. > > -Chris > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
asterisk-users-bounces@lists.digium.com wrote:> Could it be that the MYSQL application is set up for read only? > Did I miss a compile option or something?The MYSQL Application as it is is not suited for updates and / or inserts. See http://lists.digium.com/pipermail/asterisk-users/2004-August/060279.html for my patch to help this. -- Andreas Sikkema Rits tele.com Scheepmakersstraat 11 3011 VH Rotterdam t: +31 (0)10 2245544 f: +31 (0)10 2245540
Thank you very much. That fixed my update problem. Regards, Shaun -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com]On Behalf Of Andreas Sikkema Sent: Wednesday, November 17, 2004 9:07 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: RE: [Asterisk-Users] MYSQL Dialplan Question asterisk-users-bounces@lists.digium.com wrote:> Could it be that the MYSQL application is set up for read only? > Did I miss a compile option or something?The MYSQL Application as it is is not suited for updates and / or inserts. See http://lists.digium.com/pipermail/asterisk-users/2004-August/060279.html for my patch to help this. -- Andreas Sikkema Rits tele.com Scheepmakersstraat 11 3011 VH Rotterdam t: +31 (0)10 2245544 f: +31 (0)10 2245540 _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users