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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112274
interpreted = N
texte = no prob. D On Apr 9, 2015, at 8:39 AM, Keith Scarzafava = wrote: > Donovan, >=20 > You were correct with where to look. I commented out the handler = in > httpd.conf and I was able to connect to MySQL. Thanks for shove in = the > right direction! >=20 >=20 >=20 > #AddHandler fcgid-script .dna .tpl .html > AddHandler .dna .tpl .html >=20 > Keith >=20 > = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~= ~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >=20 > -----Original Message----- > From: Donovan Brooke [mailto:dbrooke@euca.us]=20 > Sent: Tuesday, April 07, 2015 10:23 AM > To: talk@webdna.us > Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >=20 > That looks like WebDNA FastCGI.. which some of those builds didn't = 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=20= >> and get the same results- so whatever I am missing I am missing it=20 >> twice. I was curious to see if a new version would address the = issue.=20 >> Anyway, It appears I am not making the connection to the MySQL = server,=20 >> 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=20= >> via mysql and for kicks I set up a DSN. I was originally trying to=20= >> use the native SQL set up, and only went the ODBC avenue just to see=20= >> if I could get anything to work. >>=20 >> Output from your code sample. >> = ---------------------------------------------------------------------- >> ------ >> = ---------------------------------------------------------------------- >> --- >> Info: >> Platform: linux unix 32bits >> 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=20 >> 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=20= >> STRING >> PROVIDED) >>=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 >> = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> ~~~~~~=20 >> = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> DISCLAIMER: Any views expressed in this message are those of the=20 >> individual sender. This email and any attachments to it may contain=20= >> confidential information and may be legally privileged. If you are=20= >> not the intended recipient, you must not review, transmit, convert to=20= >> hard copy, copy, use or disseminate this email or any attachment to=20= >> it. If you have received this email in error, please immediately=20 >> notify the originator by return email and delete this message. Please=20= >> note that if this email contains a forwarded message or is a reply to=20= >> 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] >> Sent: Monday, April 06, 2015 3:27 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> Keith, >> It's always good to be verbose when posting to a technical forum.=20 >> posting code, mysql version, etc... >>=20 >> Couple of things.. >> ODBC only works with the older (and confusing) [SQL] contexts...=20 >> (those tags should be changed to [ODBC], and also checked over to = make=20 >> sure they are still robust.. anyway.) >>=20 >> If you are testing locally.. plant this template on your server and=20= >> copy / past the results back to the list. >>=20 >> *** CHANGE below to your actual password. ********* >>=20 >> ------START TEMPLATE---------- >> >> >> >> > /> >> MySQL test >> >> >> Info:
>> Platform: [platform]
>> Product: [product]
>> Version: [version]

>>=20 >>=20 >> [SQLconnect >> = dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dro= ot&p >> wd=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 >> >> >> -------------------- >>=20 >>=20 >>=20 >>=20 >>=20 >> On Apr 6, 2015, at 7:01 AM, Keith Scarzafava = wrote: >>=20 >>> Thanks for trying Stewart. >>>=20 >>> I am just trying to connect directly, not with iSQL. I installed=20= >>> the >> unixODBC setup with MySQL initially because I was following what I = had=20 >> found documentation wise at WebDNA and used ISQL just to verify I had = a > working >> 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. =20 >>>=20 >>>=20 >>>=20 >>> Thanks for the assist. >>>=20 >>> Keith >>>=20 >>> 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. >>>=20 >>> Keith >>>=20 >>> What I sent was all that I do. >>>=20 >>> Maybe Chris can confirm a few things about WedBNA's connection to = MySQL. >>>=20 >>> Other things to look at: >>>=20 >>> Does WebDNA return anything about MYCONNECTION not being found ? >>>=20 >>> Are you using a standard port (3306)? >>>=20 >>> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from=20= >>> WebDNA, >> your setup may have a problem with going via ISQL. I also use TSQL=20 >> successfully to connect with MS SQL databases, unfortunately working=20= >> with MS SQL is not the same as working with MySQL via WebDNA. >>>=20 >>>=20 >>> Kind regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >>>=20 >>> Thanks Stewart!=20 >>>=20 >>> I gave your example a try. I was doing pretty much the same thing=20 >>> with a >> basic query. I think my is I am not able to make the connection = to=20 >> MySQL which is on the same server. I can connect with PHP locally = and=20 >> remote just fine. Is there anything I need to do tell WebDNA I am=20 >> using MySQL other than the SQLCONNECT statement? >>>=20 >>> I am using the developer edition versions to see if this is the=20 >>> route I >> wish to go. =46rom what I read, it's supposed to support MySQL. Is=20= >> this accurate? >>>=20 >>> Thanks for your time! >>> Keith >>>=20 >>>=20 >>> 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. >>>=20 >>> I've been trying to get my WebDNA to connect to MySQL and have not=20= >>> been >> able to do so with version (6.2 with Centos5) or version (8.0 with > Centos6). >> I posted in the regular forums and was advised to try here. =20 >> Basically, I started out on my 6.2 WebDNA server and followed the=20 >> setup directions for the DSN setup which, I can connect to my MySQL=20= >> via a DSN with isql and perform queries and such. If I try to use=20 >> WebDNA, I get the error: MySQL not supported. If I tried to use the > SQLCONNECT method I get the error: >> INVALID VALUE (MySQL) FOR PARAMETER: type. >>>=20 >>> After a couple of postings in the forums, I was told I don't need to=20= >>> use >> the DSN method because WebDNA supports MySQL natively (though I tried=20= >> both method). I then figured, I would give it a try on my version 8=20= >> WebDNA server and, I still am getting the same exact messages. I've=20= >> been sifting through any postings I can find and I can't find any = form of > resolution. >>>=20 >>> Any help is greatly appreciated. >>>=20 >>> KS >>>=20 >>>=20 >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 >=20 >=20 > --------------------------------------------------------- > 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:

    
  1. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  2. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  3. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  4. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  5. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  6. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  7. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Donovan Brooke 2015)
  8. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  9. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  10. RE: [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
  11. Re: [WebDNA] Cannot get WebDNA and MySQL working. (Stuart Tremain 2015)
  12. [WebDNA] Cannot get WebDNA and MySQL working. ("Keith Scarzafava" 2015)
no prob. D On Apr 9, 2015, at 8:39 AM, Keith Scarzafava = wrote: > Donovan, >=20 > You were correct with where to look. I commented out the handler = in > httpd.conf and I was able to connect to MySQL. Thanks for shove in = the > right direction! >=20 >=20 >=20 > #AddHandler fcgid-script .dna .tpl .html > AddHandler .dna .tpl .html >=20 > Keith >=20 > = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~= ~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >=20 > -----Original Message----- > From: Donovan Brooke [mailto:dbrooke@euca.us]=20 > Sent: Tuesday, April 07, 2015 10:23 AM > To: talk@webdna.us > Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >=20 > That looks like WebDNA FastCGI.. which some of those builds didn't = 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=20= >> and get the same results- so whatever I am missing I am missing it=20 >> twice. I was curious to see if a new version would address the = issue.=20 >> Anyway, It appears I am not making the connection to the MySQL = server,=20 >> 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=20= >> via mysql and for kicks I set up a DSN. I was originally trying to=20= >> use the native SQL set up, and only went the ODBC avenue just to see=20= >> if I could get anything to work. >>=20 >> Output from your code sample. >> = ---------------------------------------------------------------------- >> ------ >> = ---------------------------------------------------------------------- >> --- >> Info: >> Platform: linux unix 32bits >> 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=20 >> 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=20= >> STRING >> PROVIDED) >>=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 >> = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> ~~~~~~=20 >> = ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> DISCLAIMER: Any views expressed in this message are those of the=20 >> individual sender. This email and any attachments to it may contain=20= >> confidential information and may be legally privileged. If you are=20= >> not the intended recipient, you must not review, transmit, convert to=20= >> hard copy, copy, use or disseminate this email or any attachment to=20= >> it. If you have received this email in error, please immediately=20 >> notify the originator by return email and delete this message. Please=20= >> note that if this email contains a forwarded message or is a reply to=20= >> 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] >> Sent: Monday, April 06, 2015 3:27 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> Keith, >> It's always good to be verbose when posting to a technical forum.=20 >> posting code, mysql version, etc... >>=20 >> Couple of things.. >> ODBC only works with the older (and confusing) [SQL] contexts...=20 >> (those tags should be changed to [ODBC], and also checked over to = make=20 >> sure they are still robust.. anyway.) >>=20 >> If you are testing locally.. plant this template on your server and=20= >> copy / past the results back to the list. >>=20 >> *** CHANGE below to your actual password. ********* >>=20 >> ------START TEMPLATE---------- >> >> >> >> > /> >> MySQL test >> >> >> Info:
>> Platform: [platform]
>> Product: [product]
>> Version: [version]

>>=20 >>=20 >> [SQLconnect >> = dbType=3DMySQL&host=3Dlocalhost&database=3Dgallery_inv_management&uid=3Dro= ot&p >> wd=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 >> >> >> -------------------- >>=20 >>=20 >>=20 >>=20 >>=20 >> On Apr 6, 2015, at 7:01 AM, Keith Scarzafava = wrote: >>=20 >>> Thanks for trying Stewart. >>>=20 >>> I am just trying to connect directly, not with iSQL. I installed=20= >>> the >> unixODBC setup with MySQL initially because I was following what I = had=20 >> found documentation wise at WebDNA and used ISQL just to verify I had = a > working >> 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. =20 >>>=20 >>>=20 >>>=20 >>> Thanks for the assist. >>>=20 >>> Keith >>>=20 >>> 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. >>>=20 >>> Keith >>>=20 >>> What I sent was all that I do. >>>=20 >>> Maybe Chris can confirm a few things about WedBNA's connection to = MySQL. >>>=20 >>> Other things to look at: >>>=20 >>> Does WebDNA return anything about MYCONNECTION not being found ? >>>=20 >>> Are you using a standard port (3306)? >>>=20 >>> My work is on Ubuntu 12.x & 14.x, I connect directly to MySQL from=20= >>> WebDNA, >> your setup may have a problem with going via ISQL. I also use TSQL=20 >> successfully to connect with MS SQL databases, unfortunately working=20= >> with MS SQL is not the same as working with MySQL via WebDNA. >>>=20 >>>=20 >>> Kind regards >>>=20 >>> Stuart Tremain >>> IDFK Web Developments >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> On 6 Apr 2015, at 00:03, Keith Scarzafava = wrote: >>>=20 >>> Thanks Stewart!=20 >>>=20 >>> I gave your example a try. I was doing pretty much the same thing=20 >>> with a >> basic query. I think my is I am not able to make the connection = to=20 >> MySQL which is on the same server. I can connect with PHP locally = and=20 >> remote just fine. Is there anything I need to do tell WebDNA I am=20 >> using MySQL other than the SQLCONNECT statement? >>>=20 >>> I am using the developer edition versions to see if this is the=20 >>> route I >> wish to go. =46rom what I read, it's supposed to support MySQL. Is=20= >> this accurate? >>>=20 >>> Thanks for your time! >>> Keith >>>=20 >>>=20 >>> 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. >>>=20 >>> I've been trying to get my WebDNA to connect to MySQL and have not=20= >>> been >> able to do so with version (6.2 with Centos5) or version (8.0 with > Centos6). >> I posted in the regular forums and was advised to try here. =20 >> Basically, I started out on my 6.2 WebDNA server and followed the=20 >> setup directions for the DSN setup which, I can connect to my MySQL=20= >> via a DSN with isql and perform queries and such. If I try to use=20 >> WebDNA, I get the error: MySQL not supported. If I tried to use the > SQLCONNECT method I get the error: >> INVALID VALUE (MySQL) FOR PARAMETER: type. >>>=20 >>> After a couple of postings in the forums, I was told I don't need to=20= >>> use >> the DSN method because WebDNA supports MySQL natively (though I tried=20= >> both method). I then figured, I would give it a try on my version 8=20= >> WebDNA server and, I still am getting the same exact messages. I've=20= >> been sifting through any postings I can find and I can't find any = form of > resolution. >>>=20 >>> Any help is greatly appreciated. >>>=20 >>> KS >>>=20 >>>=20 >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>>=20 >>> --------------------------------------------------------- This=20 >>> message is >> sent to you because you are subscribed to the mailing list . To=20 >> unsubscribe, E-mail to: archives:=20 >> http://mail.webdna.us/list/talk@webdna.us Bug >> Reporting: support@webdna.us >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 >=20 >=20 > --------------------------------------------------------- > 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 Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Access Denied! But why? (1997) Emailer (1997) [OT] ODBC between IIS and remote Access problem (2000) REDIRECT MULTIPLE RESULTS (2000) my price won't move (1997) can WC render sites out? (1997) [subtotal] problems -- help? (1998) [WebDNA] [announce] CICADA Gold Products (2009) Wierd display error.... (2004) RAM variables (1997) creator code (1997) [WebDNA] [middle] (2015) Reserved Words (2003) lookup and two records? (1997) Strange error (2000) Grouping search fields, etc. (1997) greater than or equal to (1997) Multiple prices (1997) syntax question, not in online refernce (1997) Function basic question (2006)