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:
Multiple security dbs (1997)
Help!!!! (1997)
[dos] command and [math] (1998)
webmerch and serials - almost there (1997)
problems with 2 tags (1997)
I'm new (2001)
Exclude by date - multiple (1997)
WebMerchant 3.0 for Mac shipping now (1998)
Webcat/Webmerchant part II (1998)
RE: MacFinder -- a new WebDNA web site (1998)
Ruby on Rails (was Looping Search) (2006)
Emailer Set Up (1997)
[WebDNA] Grep problem (2010)
listfiles, moving files (1998)
[Sum] function? (1997)
[Webcat 2]Next (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Default contains WEBDNA (1998)
Error Log Question (2003)
Paging a SQL result... (2003)