Re: [WebDNA] Cannot get WebDNA and MySQL working.
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112260
interpreted = N
texte = That looks like WebDNA FastCGI.. which some of those builds didn=92t =support MySQL.DonovanOn Apr 7, 2015, at 8:38 AM, Keith Scarzafava =wrote:> 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> >