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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112261
interpreted = N
texte = If you have the FastCGI app installed as well, on the same server as you = have WebDNA Server installed, the results could be coming from the FastCGI engine.. which would = explain things.=20 Donovan On Apr 7, 2015, at 9:23 AM, Donovan Brooke wrote: > That looks like WebDNA FastCGI.. which some of those builds didn=92t = 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 = 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 >=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)
If you have the FastCGI app installed as well, on the same server as you = have WebDNA Server installed, the results could be coming from the FastCGI engine.. which would = explain things.=20 Donovan On Apr 7, 2015, at 9:23 AM, Donovan Brooke wrote: > That looks like WebDNA FastCGI.. which some of those builds didn=92t = 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 = 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 >=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:

gateway application timeouts (1998) Tags in the header (2000) Help name our technology! (1997) attn: smitmicro - cart limitation (2002) Payments -> Bank Accounts (2005) Location of Browser Info.txt file (1997) For those of you not on the WebCatalog Beta... (1997) Search with Special Chars (1997) Using Plug-In while running 1.6.1 (1997) TCP Connect (1999) WebDNA Developer Resource Center (2002) fieldType=num (1997) Multiple Passwords (1997) No luck with taxes (1997) PDF Writefile problem (2005) RE: Webcatalog and CyberSTUD (1998) HELP WITH DATES (1997) POST Datamissing? (1998) Robert Minor duplicate mail (1997) Formating found categories (1997)