Re: Changing Password Schemes

29 Apr 2016 · _what_

      Thanks for insight Bill, will look at that and report back.

You have a good day now, en mag jou môre ook so wees,
Carl A Jeptha
On 2016-04-29 21:20, Bill Shirley wrote:
...
Looks like an SQL update would do this:
UPDATE users
SET passwd_SHA512 = SHA2(passwd_clear, 512);
Bill
On 4/29/2016 9:07 AM, Carl A Jeptha wrote:
...
converting the passwords in the database from clear/plain text to
SHA512-CRYPT

You have a good day now, en mag jou môre ook so wees,
Carl A Jeptha
On 2016-04-29 15:02, Steffen Kaiser wrote:
...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 29 Apr 2016, Carl A Jeptha wrote:
...
Good Day,
I have been following this tutorial without much luck -
http://wiki2.dovecot.org/HowTo/ConvertPasswordSchemes#CA-26af2b83a43b8100522...
It is obvious to me that I am not following the instructions
correctly and need to be shown what I am misunderstanding.
I have an old postfix + dovecot + Roundcube mailserver
(mail.domain.Tld). Server clock is loosing time and adjusting it
causes dovecot to kill itself, we cannot install more memory,
bigger hard-drives, etc.
I have built a new server box (mail2.domain.Tld) With Postfix +
dovecot + Roundcube. This server is functioning, with a client's
new domain, and my personal domain. it's password system is
SHA512-CRYPT.
I have imported the users from the old server over to the new
server. I have created a new column "plain_pass" for the plain
passwords.
I will be using imapsync to transfer the mail folders from the one
server to the other, but will not proceed until I fix this issue.
Actually, _what_ issue?
...
# 2.2.18: /etc/dovecot/dovecot.conf
# Pigeonhole version 0.4.8 (0c4ae064f307+)
# OS: Linux 4.2.0-35-generic x86_64 Ubuntu 15.10 ext4
auth_mechanisms = plain login
first_valid_gid = 8
first_valid_uid = 150
last_valid_gid = 8
last_valid_uid = 150
listen = *
mail_gid = mail
mail_location = maildir:/var/vmail/%d/%n
mail_uid = vmail
namespace inbox {
inbox = yes
location =
mailbox Drafts {
special_use = \Drafts
}
mailbox Junk {
special_use = \Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
prefix =
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
quota_grace = 10%%
quota_rule = *:storage=1G
quota_rule2 = Trash:storage=+100M
quota_warning = storage=95%% quota-warning 95 %u
quota_warning2 = storage=80%% quota-warning 80 %u
}
postmaster_address = postmaster@airnet.ca
protocols = imap pop3 lmtp lmtp pop3
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0666
user = postfix
}
unix_listener auth-userdb {
group = mail
mode = 0666
user = vmail
}
}
service imap-login {
inet_listener imap {
port = 143
}
inet_listener imaps {
port = 993
ssl = yes
}
}
service imap-postlogin {
executable = script-login /usr/local/etc/popafter.sh
user = $default_internal_user
}
service imap {
executable = imap imap-postlogin
}
service pop3-login {
inet_listener pop3 {
port = 110
}
inet_listener pop3s {
port = 995
ssl = yes
}
}
service pop3-postlogin {
executable = script-login /usr/local/etc/popafter.sh
user = $default_internal_user
}
service pop3 {
executable = pop3 pop3-postlogin
}
ssl_cert = 
-- ------------ You have a good day now, en mag jou môre ook so
wees, Carl A Jeptha

-- Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQEVAwUBVyNbaXz1H7kL/d9rAQIbnQgAyiX9368WmhyTfTY38YfNWTXW/UW/b/0t
PqyEPx/DLLLW60aSkA0NqJa0nKzsoHip8GQfO/ZY3fqdTdep2rW4NbZW6o8/rFwW
dmNTarux25w7dNvRGWrGZiXTnGAlwQtnJTr8wuwqi2JILqPoh1dL1Ubo90ABTERv
G8q2NXgtD4m0a2aJqmyMXRmep8ocMy3IEIg8JZ/xJtmL86d4bP7kagI2yP7viIUx
EY9JSazl/u6iVIrI6jFDuFUfzAs4dr+wcQHhAM0sY8mFUVYFsdjqxCbytLy39q4O
zyj66UNAGR5yAnXAlADJ7G1fIghskFBa82p/t8QCX9VNSvOnuklqGQ==
=Q4iK
-----END PGP SIGNATURE-----