Re: [WebDNA] Cannot get WebDNA and MySQL working.
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112261
interpreted = N
texte = If you have the FastCGI app installed as well, on the same server as you =have WebDNA Server installed,the results could be coming from the FastCGI engine.. which would =explain things.=20DonovanOn Apr 7, 2015, at 9:23 AM, Donovan Brooke wrote:> That looks like WebDNA FastCGI.. which some of those builds didn=92t =support MySQL.>=20> Donovan>=20>=20> On Apr 7, 2015, at 8:38 AM, Keith Scarzafava =wrote:>=20>> Donovan,>>=20>> 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.>>=20>> 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.>>=20>> Output from your code sample.>> =--------------------------------------------------------------------------=-->> =------------------------------------------------------------------------->> Info:>> Platform: linux unix 32bits =20>> Product: WebDNA>> Version: 7.1.705>>=20>> INVALID VALUE (MySQL) FOR PARAMETER: type.>> - Please refer to the SQLConnect documentation.>>=20>> If I remove the dbType, which according the documentation, will =default to>> MYSQL, I get a different error see below:>>=20>> Result with the connection string less the dbtype:>> =--------------------------------------------------------------------------=-->> ---------------------------------------------->> ERROR: (null) DATABASE CONNECTION FAILED! - (NO IMPLEMENTATION ERROR =STRING>> PROVIDED)=20>>=20>> SQLinfo reports: ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1".>> - Subsequent SQL commands attempting to use that result ID will fail.=20=>>=20>>=20>> Best,>> Keith>>=20>>=20>>=20>> =~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=~~>> =~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~>> 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 any attachments may not have been produced by this =office.>>=20>>=20>> -----Original Message----->> From: Donovan Brooke [mailto:dbrooke@euca.us]=20>> Sent: Monday, April 06, 2015 3:27 PM>> To: talk@webdna.us>> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working.>>=20>> Keith,=20>> It=92s always good to be verbose when posting to a technical forum=85 =posting>> code, mysql version, etc...>>=20>> 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=85)>>=20>> If you are testing locally.. plant this template on your server and =copy />> past the results back to the list.>>=20>> *** CHANGE below to your actual password. *********>>=20>> =97=97=97=97=97=97START TEMPLATE=97=97=97=97=97=97=97=97=97=97>> >> >> >> > />>> MySQL test>> >> >> Info:
>> Platform: [platform]
>> Product: [product]
>> Version: [version]
>>=20>>=20>> [SQLconnect>> =dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dro=ot&pwd=3D> urpass>&conn_var=3Dconn1]>> Connected successfully
>> [/SQLConnect]>>=20>> SQLinfo reports:>> [SQLinfo conn_ref=3Dconn1]>> Host: [SQL_HOST]
>> Server Version: [SQL_SERVERVER]
>> Client Version: [SQL_CLIENTVER]
>> [/SQLinfo]>>=20>> >>