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)
