RE: [WebDNA] Cannot get WebDNA and MySQL working.

This WebDNA talk-list message is from

2015

It keeps the original formatting. numero = 112268
interpreted = N
texte = Donovan, You were correct with where to look. I commented out the handler inhttpd.conf and I was able to connect to MySQL. Thanks for shove in theright direction!#AddHandler fcgid-script .dna .tpl .htmlAddHandler .dna .tpl .htmlKeith~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-----Original Message-----From: Donovan Brooke [mailto:dbrooke@euca.us] Sent: Tuesday, April 07, 2015 10:23 AMTo: talk@webdna.usSubject: Re: [WebDNA] Cannot get WebDNA and MySQL working.That looks like WebDNA FastCGI.. which some of those builds didn't supportMySQL.DonovanOn Apr 7, 2015, at 8:38 AM, Keith Scarzafava wrote:> Donovan,> > Thanks for the advice and assist! Here is the output of the code you> provided with some background. The OS is CentOS5.5. I've also made sure> SELINUX and the httpd server name was set per the README file. I've> attempted this on a CentOS6 64bit installation with WebDNA version 8 > and get the same results- so whatever I am missing I am missing it > twice. I was curious to see if a new version would address the issue. > Anyway, It appears I am not making the connection to the MySQL server, > just not sure why and there isn't anything in the logs if any use.> > I've verified I can connect to the MySQL server from the command line > via mysql and for kicks I set up a DSN. I was originally trying to > use the native SQL set up, and only went the ODBC avenue just to see > if I could get anything to work.> > Output from your code sample.> ----------------------------------------------------------------------> ------> ----------------------------------------------------------------------> ---> Info:> Platform: linux unix 32bits> Product: WebDNA> Version: 7.1.705> > INVALID VALUE (MySQL) FOR PARAMETER: type.> - Please refer to the SQLConnect documentation.> > If I remove the dbType, which according the documentation, will > default to MYSQL, I get a different error see below:> > Result with the connection string less the dbtype:> ----------------------------------------------------------------------> ------> ----------------------------------------------> ERROR: (null) DATABASE CONNECTION FAILED! - (NO IMPLEMENTATION ERROR > STRING> PROVIDED)> > SQLinfo reports: ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1".> - Subsequent SQL commands attempting to use that result ID will fail. > > > Best,> Keith> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> ~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> DISCLAIMER: Any views expressed in this message are those of the > individual sender. This email and any attachments to it may contain > confidential information and may be legally privileged. If you are > not the intended recipient, you must not review, transmit, convert to > hard copy, copy, use or disseminate this email or any attachment to > it. If you have received this email in error, please immediately > notify the originator by return email and delete this message. Please > note that if this email contains a forwarded message or is a reply to > a prior message, some or all of the contents of this message or anyattachments may not have been produced by this office.> > > -----Original Message-----> From: Donovan Brooke [mailto:dbrooke@euca.us]> Sent: Monday, April 06, 2015 3:27 PM> To: talk@webdna.us> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working.> > Keith,> It's always good to be verbose when posting to a technical forum. > posting code, mysql version, etc...> > Couple of things..> ODBC only works with the older (and confusing) [SQL] contexts... > (those tags should be changed to [ODBC], and also checked over to make > sure they are still robust.. anyway.)> > If you are testing locally.. plant this template on your server and > copy / past the results back to the list.> > *** CHANGE below to your actual password. *********> > ------START TEMPLATE----------> > > > />> MySQL test> > > Info:
> Platform: [platform]
> Product: [product]
> Version: [version]

> > > [SQLconnect> dbType=MySQL&host=localhost&database=gallery_inv_management&uid=root&p> wd= urpass>&conn_var=conn1]> Connected successfully

> [/SQLConnect]> > SQLinfo reports:> [SQLinfo conn_ref=conn1]> Host: [SQL_HOST]
> Server Version: [SQL_SERVERVER]
> Client Version: [SQL_CLIENTVER]
> [/SQLinfo]> > > > --------------------> > > > > > On Apr 6, 2015, at 7:01 AM, Keith Scarzafava wrote:> >> Thanks for trying Stewart.>> >> I am just trying to connect directly, not with iSQL. I installed >> the> unixODBC setup with MySQL initially because I was following what I had > found documentation wise at WebDNA and used ISQL just to verify I had aworking> DSN. Since, I couldn't get it to work, I posted on the WebDNA forums and> Chris said to try here and pointed me back to the same documentation I was> already reading. I suspect it must be something to do with WeDNA and> CentOS then. >> >> >> >> Thanks for the assist.>> >> Keith>> >> From: Stuart Tremain [mailto:webdna@idfk.com.au]>> Sent: Sunday, April 05, 2015 7:15 PM>> To: WebDNA Talk List>> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working.>> >> Keith>> >> What I sent was all that I do.>> >> Maybe Chris can confirm a few things about WedBNA's connection to MySQL.>> >> Other things to look at:>> >> Does WebDNA return anything about MYCONNECTION not being found ?>> >> Are you using a standard port (3306)?>> >> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from >> WebDNA,> your setup may have a problem with going via ISQL. I also use TSQL > successfully to connect with MS SQL databases, unfortunately working > with MS SQL is not the same as working with MySQL via WebDNA.>> >> >> Kind regards>> >> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>> >> >> >> >> >> On 6 Apr 2015, at 00:03, Keith Scarzafava wrote:>> >> Thanks Stewart! >> >> I gave your example a try. I was doing pretty much the same thing >> with a> basic query. I think my is I am not able to make the connection to > MySQL which is on the same server. I can connect with PHP locally and > remote just fine. Is there anything I need to do tell WebDNA I am > using MySQL other than the SQLCONNECT statement?>> >> I am using the developer edition versions to see if this is the >> route I> wish to go. From what I read, it's supposed to support MySQL. Is > this accurate?>> >> Thanks for your time!>> Keith>> >> >> From: Keith Scarzafava [mailto:keith@scarzafava.com]>> Sent: Saturday, April 04, 2015 8:21 PM>> To: talk@webdna.us>> Subject: [WebDNA] Cannot get WebDNA and MySQL working.>> >> I've been trying to get my WebDNA to connect to MySQL and have not >> been> able to do so with version (6.2 with Centos5) or version (8.0 withCentos6).> I posted in the regular forums and was advised to try here. > Basically, I started out on my 6.2 WebDNA server and followed the > setup directions for the DSN setup which, I can connect to my MySQL > via a DSN with isql and perform queries and such. If I try to use > WebDNA, I get the error: MySQL not supported. If I tried to use theSQLCONNECT method I get the error:> INVALID VALUE (MySQL) FOR PARAMETER: type.>> >> After a couple of postings in the forums, I was told I don't need to >> use> the DSN method because WebDNA supports MySQL natively (though I tried > both method). I then figured, I would give it a try on my version 8 > WebDNA server and, I still am getting the same exact messages. I've > been sifting through any postings I can find and I can't find any form ofresolution.>> >> Any help is greatly appreciated.>> >> KS>> >> >> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us>> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us>> >> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us> > > > ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)

Donovan, You were correct with where to look. I commented out the handler inhttpd.conf and I was able to connect to MySQL. Thanks for shove in theright direction!#AddHandler fcgid-script .dna .tpl .htmlAddHandler .dna .tpl .htmlKeith~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-----Original Message-----From: Donovan Brooke [mailto:dbrooke@euca.us] Sent: Tuesday, April 07, 2015 10:23 AMTo: talk@webdna.usSubject: Re: [WebDNA] Cannot get WebDNA and MySQL working.That looks like WebDNA FastCGI.. which some of those builds didn't supportMySQL.DonovanOn Apr 7, 2015, at 8:38 AM, Keith Scarzafava wrote:> Donovan,> > Thanks for the advice and assist! Here is the output of the code you> provided with some background. The OS is CentOS5.5. I've also made sure> SELINUX and the httpd server name was set per the README file. I've> attempted this on a CentOS6 64bit installation with WebDNA version 8 > and get the same results- so whatever I am missing I am missing it > twice. I was curious to see if a new version would address the issue. > Anyway, It appears I am not making the connection to the MySQL server, > just not sure why and there isn't anything in the logs if any use.> > I've verified I can connect to the MySQL server from the command line > via mysql and for kicks I set up a DSN. I was originally trying to > use the native SQL set up, and only went the ODBC avenue just to see > if I could get anything to work.> > Output from your code sample.> ----------------------------------------------------------------------> ------> ----------------------------------------------------------------------> ---> Info:> Platform: linux unix 32bits> Product: WebDNA> Version: 7.1.705> > INVALID VALUE (MySQL) FOR PARAMETER: type.> - Please refer to the SQLConnect documentation.> > If I remove the dbType, which according the documentation, will > default to MYSQL, I get a different error see below:> > Result with the connection string less the dbtype:> ----------------------------------------------------------------------> ------> ----------------------------------------------> ERROR: (null) DATABASE CONNECTION FAILED! - (NO IMPLEMENTATION ERROR > STRING> PROVIDED)> > SQLinfo reports: ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1".> - Subsequent SQL commands attempting to use that result ID will fail. > > > Best,> Keith> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> ~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> DISCLAIMER: Any views expressed in this message are those of the > individual sender. This email and any attachments to it may contain > confidential information and may be legally privileged. If you are > not the intended recipient, you must not review, transmit, convert to > hard copy, copy, use or disseminate this email or any attachment to > it. If you have received this email in error, please immediately > notify the originator by return email and delete this message. Please > note that if this email contains a forwarded message or is a reply to > a prior message, some or all of the contents of this message or anyattachments may not have been produced by this office.> > > -----Original Message-----> From: Donovan Brooke [mailto:dbrooke@euca.us]> Sent: Monday, April 06, 2015 3:27 PM> To: talk@webdna.us> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working.> > Keith,> It's always good to be verbose when posting to a technical forum. > posting code, mysql version, etc...> > Couple of things..> ODBC only works with the older (and confusing) [SQL] contexts... > (those tags should be changed to [ODBC], and also checked over to make > sure they are still robust.. anyway.)> > If you are testing locally.. plant this template on your server and > copy / past the results back to the list.> > *** CHANGE below to your actual password. *********> > ------START TEMPLATE----------> > > > />> MySQL test> > > Info:
> Platform: [platform]
> Product: [product]
> Version: [version]

> > > [SQLconnect> dbType=MySQL&host=localhost&database=gallery_inv_management&uid=root&p> wd= urpass>&conn_var=conn1]> Connected successfully

> [/SQLConnect]> > SQLinfo reports:> [SQLinfo conn_ref=conn1]> Host: [SQL_HOST]
> Server Version: [SQL_SERVERVER]
> Client Version: [SQL_CLIENTVER]
> [/SQLinfo]> > > > --------------------> > > > > > On Apr 6, 2015, at 7:01 AM, Keith Scarzafava wrote:> >> Thanks for trying Stewart.>> >> I am just trying to connect directly, not with iSQL. I installed >> the> unixODBC setup with MySQL initially because I was following what I had > found documentation wise at WebDNA and used ISQL just to verify I had aworking> DSN. Since, I couldn't get it to work, I posted on the WebDNA forums and> Chris said to try here and pointed me back to the same documentation I was> already reading. I suspect it must be something to do with WeDNA and> CentOS then. >> >> >> >> Thanks for the assist.>> >> Keith>> >> From: Stuart Tremain [mailto:webdna@idfk.com.au]>> Sent: Sunday, April 05, 2015 7:15 PM>> To: WebDNA Talk List>> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working.>> >> Keith>> >> What I sent was all that I do.>> >> Maybe Chris can confirm a few things about WedBNA's connection to MySQL.>> >> Other things to look at:>> >> Does WebDNA return anything about MYCONNECTION not being found ?>> >> Are you using a standard port (3306)?>> >> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from >> WebDNA,> your setup may have a problem with going via ISQL. I also use TSQL > successfully to connect with MS SQL databases, unfortunately working > with MS SQL is not the same as working with MySQL via WebDNA.>> >> >> Kind regards>> >> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>> >> >> >> >> >> On 6 Apr 2015, at 00:03, Keith Scarzafava wrote:>> >> Thanks Stewart! >> >> I gave your example a try. I was doing pretty much the same thing >> with a> basic query. I think my is I am not able to make the connection to > MySQL which is on the same server. I can connect with PHP locally and > remote just fine. Is there anything I need to do tell WebDNA I am > using MySQL other than the SQLCONNECT statement?>> >> I am using the developer edition versions to see if this is the >> route I> wish to go. From what I read, it's supposed to support MySQL. Is > this accurate?>> >> Thanks for your time!>> Keith>> >> >> From: Keith Scarzafava [mailto:keith@scarzafava.com]>> Sent: Saturday, April 04, 2015 8:21 PM>> To: talk@webdna.us>> Subject: [WebDNA] Cannot get WebDNA and MySQL working.>> >> I've been trying to get my WebDNA to connect to MySQL and have not >> been> able to do so with version (6.2 with Centos5) or version (8.0 withCentos6).> I posted in the regular forums and was advised to try here. > Basically, I started out on my 6.2 WebDNA server and followed the > setup directions for the DSN setup which, I can connect to my MySQL > via a DSN with isql and perform queries and such. If I try to use > WebDNA, I get the error: MySQL not supported. If I tried to use theSQLCONNECT method I get the error:> INVALID VALUE (MySQL) FOR PARAMETER: type.>> >> After a couple of postings in the forums, I was told I don't need to >> use> the DSN method because WebDNA supports MySQL natively (though I tried > both method). I then figured, I would give it a try on my version 8 > WebDNA server and, I still am getting the same exact messages. I've > been sifting through any postings I can find and I can't find any form ofresolution.>> >> Any help is greatly appreciated.>> >> KS>> >> >> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us>> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us>> >> --------------------------------------------------------- This >> message is> sent to you because you are subscribed to the mailing list . To > unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug> Reporting: support@webdna.us> > > > ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us "Keith Scarzafava"

DOWNLOAD WEBDNA NOW!

RE: [WebDNA] Cannot get WebDNA and MySQL working.

2015

Top Articles:

Related Readings: