That's most probably due to your Windows-MySQL not being able to do the encrypt() function as described in http://dev.mysql.com/doc/mysql/en/Encryption_functions.html (Scroll down to ENCRYPT()). When you use that function and it is not included, the field is set to NULL.
I posted in the General Discussion forum of this SF project to instead implement sha1() for example, cos it does not have the 8char restriction etc. But I got no answer yet.
To get a valid value for this field you would need to execute the encrypt() funtion on a unix system and copy/paste the result to the field.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
now I understand the problem you're writing in the other forum ;-)
"If crypt() is not available on your system, ENCRYPT() always returns NULL. Because of this, we recommend that you use MD5() or SHA1() instead, because those two functions exist on all platforms."
It is more likely a "problem" of MySql, but I will add this as a Feature Request to one of the next versions.
thomas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can now set the initial password using sha1 however it still leaves a problem that I then cannot change the password once I have made entries in the wallet. For obvious reasons I would need to change the password on a regular basis.
On a diferent tack, how about structuring the wallet so that diferent password types (web, network, software, etc) could be grouped together.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can anyone help me please?
The command to set the db password does not appear to work in Windows.
mysql -u <your_mysql_user> -p w3pw -e "UPDATE main set pw=ENCRYPT(\"<yourpassword>\",\"c7\")"
After entering the command the pw record in the db appears to be blank and I can no longer connect.
It works fine on my Linux server but unfortunately we have a Windows only policy at work.
If I leave the password set to the default 'secret' everything works ok.
Thanks
That's most probably due to your Windows-MySQL not being able to do the encrypt() function as described in http://dev.mysql.com/doc/mysql/en/Encryption_functions.html (Scroll down to ENCRYPT()). When you use that function and it is not included, the field is set to NULL.
I posted in the General Discussion forum of this SF project to instead implement sha1() for example, cos it does not have the 8char restriction etc. But I got no answer yet.
To get a valid value for this field you would need to execute the encrypt() funtion on a unix system and copy/paste the result to the field.
Hi Peter,
now I understand the problem you're writing in the other forum ;-)
"If crypt() is not available on your system, ENCRYPT() always returns NULL. Because of this, we recommend that you use MD5() or SHA1() instead, because those two functions exist on all platforms."
It is more likely a "problem" of MySql, but I will add this as a Feature Request to one of the next versions.
thomas
Hehe,
very cool, Thomas :)
Thanks guys
I can now set the initial password using sha1 however it still leaves a problem that I then cannot change the password once I have made entries in the wallet. For obvious reasons I would need to change the password on a regular basis.
On a diferent tack, how about structuring the wallet so that diferent password types (web, network, software, etc) could be grouped together.