Re: WebDNA v6 & MySQL
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 70004
interpreted = N
texte = 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.
------------------------CheersPaulOn 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/
Associated Messages, from the most recent to the oldest:
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.------------------------CheersPaulOn 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/
Paul Willis
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:
Separate SSL Server (1997)
.hdr files (2004)
[WebDNA] MD5 Hash issue (2009)
emailer (1997)
Alais Shopping Cart Directory (1998)
Why does this not work? (2002)
Frames and WebCat (1997)
Denying access by IP address (2000)
[WebDNA] test (2010)
database size? (1997)
How reliable is WebDNA? (2004)
For those of you not on the WebCatalog Beta... (1997)
OT: Raid Software on OSX (2003)
DataBaseHelper Flawed (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WCS Newbie question (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
New public beta available (1997)
Robert Minor duplicate mail (1997)
List Address Changed! (1998)