Re: Sharing pws between UNIX and MySQL?
But wouldn't it be possible to let MySQL use MD5-hashed pw like UNIX? Why isn't that implemented? Then it would be easy to transfer the hash... Yes it definitly would be nice and would have been easier to impliment than the current Password() implimentation (just call crypt()!!). I found that Postgresql uses the built in system crypt() while Mysql uses its own hash which causes some problems when porting a database between the systems. 1. Have you find a way of porting the pw-database from UNIX to MySQL? As I see it it is impossible due to the one-way-hash of MD5. The only way I've found out is to give all users a new password. :( 2. Is it possible to let the users by them self change their password? Then they could change it to their UNIX-password. As far as I know only the MySQL admin can change the users passwords. :( /jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sharing pws between UNIX and MySQL?
2. Is it possible to let the users by them self change their password? Then they could change it to their UNIX-password. As far as I know only the MySQL admin can change the users passwords. :( Yes, that's possible. The user connects and issues this command: SET PASSWORD = PASSWORD('new password') Thanks it worked! The only way I can think of how to manage the transfer of the UNIX accounts into MySQL is to give all users a temporary password (unique for each user) and then ask them to change it to their UNIX account password imediately. To avoid sending the temporary passwords by mail one could put it in a file, e.g. mysql_temp_pw.txt (with perms 600) in their homedir. Then one could delete that file after they have changed the pw. I know there is security problems if you have the fs over NFS, but I think it is better than sending the pws by mail. /jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sharing pws between UNIX and MySQL?
Hi, By looking in the documentation and the FAQ I can't find out how one should do to share passwords (in e.g. MD5 format) between UNIX (e.g. Linux) and MySQL. I like to setup a MySQL database for 20 of my users on a Linux box and it would be nice if they could retain their UNIX passwords. Is there a tool to transfer the passwords from the UNIX accounts to MySQL? Best regards, Jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php