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:
Problems with [Applescript] (1997)
[WebDNA] 6.2 Monitor (2012)
Generating unique SKU from [cart] - Still Stumped... (1997)
when is date system date or order date? (1997)
TCPconnect in a DB? (1999)
cookie length (1998)
color (1999)
'does not contain' operator needed ... (1997)
PIXO (1997)
Getting total number of items ordered (1997)
A sendmail warning (2005)
WebCat2 as a chat server? (1997)
database freeze (1997)
emailer w/F2 (1997)
Old $ commands and migration (2004)
New Command prefs ... (1997)
Exclamation point (1997)
Authenticate (1997)
carriage returns in data (1997)
Calculating multiple shipping... (1997)