RE: [WebDNA] Cannot get WebDNA and MySQL working.
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112259
interpreted = N
texte = 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. 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 =20 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)=20 SQLinfo reports: ERROR: COULD NOT FIND SQLCONNECT VARIABLE "conn1". - Subsequent SQL commands attempting to use that result ID will fail.=20 Best, Keith ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~= ~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DISCLAIMER:=A0 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.=A0 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. -----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. Keith,=20 It=92s always good to be verbose when posting to a technical forum=85 = 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=85) 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. ********* =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]
[SQLconnect dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dr= oot&pwd=3D&conn_var=3Dconn1] Connected successfully
[/SQLConnect] SQLinfo reports: [SQLinfo conn_ref=3Dconn1] Host: [SQL_HOST]
Server Version: [SQL_SERVERVER]
Client Version: [SQL_CLIENTVER]
[/SQLinfo]