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. Donovan On 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 > > > =97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97 >=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 = the > unixODBC setup with MySQL initially because I was following what I had = found > documentation wise at WebDNA and used ISQL just to verify I had a = working > DSN. Since, I couldn=92t 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]=20 >> 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=92s 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 = WebDNA, > your setup may have a problem with going via ISQL. I also use TSQL > successfully to connect with MS SQL databases, unfortunately working = 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 = with a > basic query. I think my is I am not able to make the connection to = MySQL > which is on the same server. I can connect with PHP locally and = remote just > fine. Is there anything I need to do tell WebDNA I am using MySQL = other than > the SQLCONNECT statement? >>=20 >> I am using the developer edition versions to see if this is the = route I > wish to go. =46rom what I read, it=92s supposed to support MySQL. Is = this > accurate? >>=20 >> Thanks for your time! >> Keith >>=20 >>=20 >> From: Keith Scarzafava [mailto:keith@scarzafava.com]=20 >> Sent: Saturday, April 04, 2015 8:21 PM >> To: talk@webdna.us >> Subject: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> I=92ve been trying to get my WebDNA to connect to MySQL and have not = 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. = Basically, I > started out on my 6.2 WebDNA server and followed the setup directions = for > the DSN setup which, I can connect to my MySQL via a DSN with isql and > perform queries and such. If I try to use 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=92t need = to use > the DSN method because WebDNA supports MySQL natively (though I tried = both > method). I then figured, I would give it a try on my version 8 WebDNA > server and, I still am getting the same exact messages. I=92ve been = sifting > through any postings I can find and I can=92t find any form of = resolution. >>=20 >> Any help is greatly appreciated. >>=20 >> KS >>=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 >> --------------------------------------------------------- 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 >>=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 >=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)
That looks like WebDNA FastCGI.. which some of those builds didn=92t = support MySQL. Donovan On 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 > > > =97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97 >=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 = the > unixODBC setup with MySQL initially because I was following what I had = found > documentation wise at WebDNA and used ISQL just to verify I had a = working > DSN. Since, I couldn=92t 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]=20 >> 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=92s 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 = WebDNA, > your setup may have a problem with going via ISQL. I also use TSQL > successfully to connect with MS SQL databases, unfortunately working = 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 = with a > basic query. I think my is I am not able to make the connection to = MySQL > which is on the same server. I can connect with PHP locally and = remote just > fine. Is there anything I need to do tell WebDNA I am using MySQL = other than > the SQLCONNECT statement? >>=20 >> I am using the developer edition versions to see if this is the = route I > wish to go. =46rom what I read, it=92s supposed to support MySQL. Is = this > accurate? >>=20 >> Thanks for your time! >> Keith >>=20 >>=20 >> From: Keith Scarzafava [mailto:keith@scarzafava.com]=20 >> Sent: Saturday, April 04, 2015 8:21 PM >> To: talk@webdna.us >> Subject: [WebDNA] Cannot get WebDNA and MySQL working. >>=20 >> I=92ve been trying to get my WebDNA to connect to MySQL and have not = 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. = Basically, I > started out on my 6.2 WebDNA server and followed the setup directions = for > the DSN setup which, I can connect to my MySQL via a DSN with isql and > perform queries and such. If I try to use 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=92t need = to use > the DSN method because WebDNA supports MySQL natively (though I tried = both > method). I then figured, I would give it a try on my version 8 WebDNA > server and, I still am getting the same exact messages. I=92ve been = sifting > through any postings I can find and I can=92t find any form of = resolution. >>=20 >> Any help is greatly appreciated. >>=20 >> KS >>=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 >> --------------------------------------------------------- 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 >>=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 >=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:

Line items in table cells (1997) list items (1998) PIXO support (1997) Webcat and SQL - General Comments (2006) lookups (2000) [math date] with non-US date format (2000) NT considerations (1997) NewCart+Search with one click ? (1997) Duplicate Cart ID (2001) OT: Flash developer needed (2007) BugNote#2 - debugwindow.db seems to be missing ... (2000) Almost a there but..bye bye NetCloak (1997) [encrypt] blues.... (2000) Emailer Problem (1998) Separate SSL Server (1997) carriage returns in data (1997) Cookies not setting on IE (2002) Search Question (2000) [fileinfo . . .] (2000) Generating Report Totals (1997)