Re: WebDNA v6 & MySQL
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70005
interpreted = N
texte = Paul I was trying what you suggested but there was a problem with not finding the user or something ??? Anyway I have sorted the problem out now :) Thanks for your input. On 03/04/2008, at 9:47 PM, Paul Willis wrote: > Glad to see you got it sorted. > > The message I tried to post yesterday was regarding passwords too. > We had a related but slightly different problem to do with the > password length. > > Here is my post again (assuming it gets through this time) in case > it might help others in the future... > > ------------------------ > > Make sure the password is the short type. WebDNA doesn't work with > the long more secure passwords that MySQL uses now (from version 4.1 > onwards). > > Use... > > SET PASSWORD FOR 'someuser'@'somehost' = OLD_PASSWORD('new_password'); > > ...to set old type password. > >
> > ------------------------ > > Cheers > > Paul > > > On 2 Apr 2008, at 23:19, Stuart Tremain wrote: >> Thanks to Nitai for the pointers >> >> I finally found the way to make it work. >> >> On windows: >> >> Using mysql command-line utility >> >> mysql> show variables like 'old%'; >> >> Returns this, notice old_passwords is off. >> >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | old | OFF | >> | old_alter_table | OFF | >> | old_passwords | OFF | >> +-----------------+-------+ >> >> >> Now >> >> mysql> set old_passwords = 1; >> >> >> Then test again >> >> mysql> show variables like 'old%'; >> >> The return should now indicate on >> >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | old | OFF | >> | old_alter_table | OFF | >> | old_passwords | ON | >> +-----------------+-------+ >> >> Now when I test my code I get a positive response from my WebDNA. >> >> Host: www.idfk.com.au >> Server Version: 5.1.23-rc-community >> Client Version: 3.23.32 >> >> >> Nitai, once agin thanks for pointing me in the right direction :) >> >> >> >> >> On 02/04/2008, at 11:07 PM, Stuart Tremain wrote: >>> MySQL v5.1.23 if that makes any difference. >>> >>> >>> On 02/04/2008, at 11:02 PM, Stuart Tremain wrote: >>>> Windoze2003 server >>>> >>>> I have installed MySQL and can connect to it remotely using >>>> MySQL Administrator & MySQL Query Browser >>>> >>>> Queries are returned OK >>>> >>>> When I try using WebDNA I get >>>> >>>> "ERROR: MySQL DATABASE CONNECTION FAILED!" >>>> >>>> Here is my code: >>>> >>>> [SQLConnect >>>> dbType >>>> = >>>> MySQL >>>> &host >>>> = >>>> www >>>> .idfk >>>> .com.au&database=test&uid=myuserid&pwd=mypassword&conn_var=conn1] >>>> >>>> | Host: | [SQL_HOST] |
>>>> | Server Version: | [SQL_SERVERVER] |
>>>> | Client Version: | [SQL_CLIENTVER] |
>>>>
>>>> [/SQLConnect] >>>> >>>> These are the same userid & password that I am using with the >>>> admin & query browser. >>>> >>>> What am I doing wrong? >>>> >>>> Thanks ! >>>> >>>> Stuart Tremain > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Paul I was trying what you suggested but there was a problem with not finding the user or something ??? Anyway I have sorted the problem out now :) Thanks for your input. On 03/04/2008, at 9:47 PM, Paul Willis wrote: > Glad to see you got it sorted. > > The message I tried to post yesterday was regarding passwords too. > We had a related but slightly different problem to do with the > password length. > > Here is my post again (assuming it gets through this time) in case > it might help others in the future... > > ------------------------ > > Make sure the password is the short type. WebDNA doesn't work with > the long more secure passwords that MySQL uses now (from version 4.1 > onwards). > > Use... > > SET PASSWORD FOR 'someuser'@'somehost' = OLD_PASSWORD('new_password'); > > ...to set old type password. > > > > ------------------------ > > Cheers > > Paul > > > On 2 Apr 2008, at 23:19, Stuart Tremain wrote: >> Thanks to Nitai for the pointers >> >> I finally found the way to make it work. >> >> On windows: >> >> Using mysql command-line utility >> >> mysql> show variables like 'old%'; >> >> Returns this, notice old_passwords is off. >> >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | old | OFF | >> | old_alter_table | OFF | >> | old_passwords | OFF | >> +-----------------+-------+ >> >> >> Now >> >> mysql> set old_passwords = 1; >> >> >> Then test again >> >> mysql> show variables like 'old%'; >> >> The return should now indicate on >> >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | old | OFF | >> | old_alter_table | OFF | >> | old_passwords | ON | >> +-----------------+-------+ >> >> Now when I test my code I get a positive response from my WebDNA. >> >> Host: www.idfk.com.au >> Server Version: 5.1.23-rc-community >> Client Version: 3.23.32 >> >> >> Nitai, once agin thanks for pointing me in the right direction :) >> >> >> >> >> On 02/04/2008, at 11:07 PM, Stuart Tremain wrote: >>> MySQL v5.1.23 if that makes any difference. >>> >>> >>> On 02/04/2008, at 11:02 PM, Stuart Tremain wrote: >>>> Windoze2003 server >>>> >>>> I have installed MySQL and can connect to it remotely using >>>> MySQL Administrator & MySQL Query Browser >>>> >>>> Queries are returned OK >>>> >>>> When I try using WebDNA I get >>>> >>>> "ERROR: MySQL DATABASE CONNECTION FAILED!" >>>> >>>> Here is my code: >>>> >>>> [SQLConnect >>>> dbType >>>> = >>>> MySQL >>>> &host >>>> = >>>> www >>>> .idfk >>>> .com.au&database=test&uid=myuserid&pwd=mypassword&conn_var=conn1] >>>> >>>> | Host: | [SQL_HOST] |
>>>> | Server Version: | [SQL_SERVERVER] |
>>>> | Client Version: | [SQL_CLIENTVER] |
>>>>
>>>> [/SQLConnect] >>>> >>>> These are the same userid & password that I am using with the >>>> admin & query browser. >>>> >>>> What am I doing wrong? >>>> >>>> Thanks ! >>>> >>>> Stuart Tremain > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
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:
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
dos performance (1998)
Errant Email. (1998)
[WebDNA] Two different mail servers? (2011)
Date Time Oddness (1999)
WebCatalog 4.0.2b5 available (2000)
Date search - yes or no (1997)
[ShowIf] and empty fields (1997)
Sendmail truncation in Eudora Clients (1998)
Date Formats (1997)
Close-to Comparison Code (1998)
Help name our technology! I found it (1997)
NetSplat and WebCat2 (1997)
weird text problem (2001)
emailer don't work (1998)
Hiding HTML and breaking the page (1997)
PIXO Support (1997)
Initiating NewCart (1997)
Help name our technology! (1997)
[foundItems] context problem (2000)