Cool, I've seen John's website before and it's helped before. Thanks for pointing it out.
Your scripts saved me. I was able to see that in all the domains, only MINE [the oldest] has this problem J . THOSE passwords I can reinsert using qmailadmin. All other domains on the server have the proper "1$1" type password. Thank you! Carl From: Eric Broch [mailto:[email protected]] Sent: Sunday, February 12, 2017 03:28 AM To: [email protected] Subject: Re: [qmailtoaster] Converting an old Qmail server with old short passwords to newer Qmail Hi Carl, I don't know if this will help but from John Simpson's web I found a tutorial on converting Sendmail to Qmail here <https://qmail.jms1.net/sendmail-migration.shtml> . On it he shows how to bring passwords over from Sendmail, and it seems Sendmail only has encrypted email passwords. John uses "./vadduser -e 'encrypted password' [email protected]" to add email accounts. Since your email addresses are already added could you not use the following command: ./vmoduser -e 'encrypted password' [email protected] To do something similar? John, used a bash script (redirected to create another script) to extract the usernames and passwords from Sendmail printing them in a formatted command (vadduser) string (see link above). You could extract password from your mysql account with the following commands: 1) Build a domain list: echo "show tables" | mysql -u vpopuser -ppassword vpopmail | grep -v valias | grep -v lastauth | grep -v dir_control | grep -v Tables_in_vpopmail 2) Dump the users in the domain echo "select pw_passwd, pw_name from $domain_tld where pw_clear_passwd='unknown'" | mysql -u vpopuser -ppassword vpopmail | grep -v pw_passwd Eric P.S. I hope this helps. On 2/11/2017 11:17 PM, CarlC Internet Services Service Desk wrote: I'm converting an older CentOS 5 server [which started life as a CentOS 4 server many years ago] to a new CentOS 7 server. I've moved everything over, and was doing rsyncs [and Database updates of vpopmail/valias]. I've hit an interesting problem, the new CentOS 7 server will not allow me to login/access an email account with the old style 12-14 length encrypted password. I even tried old_passwords=1 in my.cnf thinking that might enable the old MySQL V4 password format as it looks like that. Any of the newer accounts that have the longer encrypted password work fine. The other hint that an email address will work is if the pw_clear_password is not unknown, then it works. I can run vchangepw against the account, then it works... I then see the new longer format, but this does not help me in that many of these email accounts I do not have the original password. Is there any easy way to find all the older accounts with old passwords and convert them to the new format. Almost a "if pw_clear_password = unknown, then upgrade password to new password". I have around 200+ domains with plenty of email accounts that have the old format... Thanks, Carl --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] -- Eric Broch, IMSO, DAM, NGOO, DITH, URTS White Horse Technical Consulting (WHTC)
