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:

Need some Java Script Code (2003) Nested [SEARCH] and [REPLACE] problem. (1997) Checkboxes (1998) Price problem (1997) Multiple Ad databases? (1997) Re1000001: Setting up shop (1997) Thanks Grant (1997) I'm having trouble using [url][interpret][math] together in lookup (1997) [group] ? (1997) Tcp Connect and IPaddress (2000) How to Sort Summ data ? (1997) [WebDNA] REPLACE INCLUDE FILE (2019) [WebDNA] Mass email using WebDNA (2008) Search results templates (1996) WebCat2 - Getting to the browser's username/password data (1997) Bug? (1997) Suffix Mapping (1997) [WebDNA] [announce] WebDNA Site and Store (2008) Tracking System? (1997) Associative lookup style? + bit more (1997)