From owner-freebsd-hackers@freebsd.org  Tue Oct 29 12:49:42 2019
Return-Path: <owner-freebsd-hackers@freebsd.org>
Delivered-To: freebsd-hackers@mailman.nyi.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1])
 by mailman.nyi.freebsd.org (Postfix) with ESMTP id 023341A6088
 for <freebsd-hackers@mailman.nyi.freebsd.org>;
 Tue, 29 Oct 2019 12:49:42 +0000 (UTC)
 (envelope-from janm@transactionware.com)
Received: from mail3.transactionware.com (mail.transactionware.com
 [203.14.245.7])
 by mx1.freebsd.org (Postfix) with SMTP id 472Wcz0spFz4Tkg
 for <freebsd-hackers@freebsd.org>; Tue, 29 Oct 2019 12:49:38 +0000 (UTC)
 (envelope-from janm@transactionware.com)
Received: (qmail 55254 invoked by uid 907); 29 Oct 2019 12:49:30 -0000
Received: from p5DD14C1D.dip0.t-ipconnect.de (HELO [192.168.7.2])
 (93.209.76.29) (smtp-auth username janm, mechanism plain)
 by mail3.transactionware.com (qpsmtpd/0.84) with (ECDHE-RSA-AES256-GCM-SHA384
 encrypted) ESMTPSA; Tue, 29 Oct 2019 23:49:30 +1100
Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\))
Subject: Re: converting password hashes
From: Jan Martin Mikkelsen <janm@transactionware.com>
In-Reply-To: <alpine.BSF.2.20.1910291310310.72617@puchar.net>
Date: Tue, 29 Oct 2019 13:49:20 +0100
Cc: freebsd-hackers@freebsd.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <1A7D3067-D5D6-47A0-9F42-FCBF8A1A856D@transactionware.com>
References: <alpine.BSF.2.20.1910291310310.72617@puchar.net>
To: Wojciech Puchar <wojtek@puchar.net>
X-Mailer: Apple Mail (2.3445.9.1)
X-Rspamd-Queue-Id: 472Wcz0spFz4Tkg
X-Spamd-Bar: /
Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none;
 spf=none (mx1.freebsd.org: domain of janm@transactionware.com has no SPF
 policy when checking 203.14.245.7) smtp.mailfrom=janm@transactionware.com
X-Spamd-Result: default: False [-0.09 / 15.00]; ARC_NA(0.00)[];
 RCVD_VIA_SMTP_AUTH(0.00)[]; NEURAL_HAM_MEDIUM(-0.79)[-0.787,0];
 FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[];
 NEURAL_HAM_LONG(-0.81)[-0.807,0]; MIME_GOOD(-0.10)[text/plain];
 DMARC_NA(0.00)[transactionware.com]; AUTH_NA(1.00)[];
 TO_MATCH_ENVRCPT_SOME(0.00)[]; RCPT_COUNT_TWO(0.00)[2];
 R_SPF_NA(0.00)[]; RCVD_NO_TLS_LAST(0.10)[];
 FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[];
 MIME_TRACE(0.00)[0:+];
 ASN(0.00)[asn:17559, ipnet:203.14.245.0/24, country:AU];
 MID_RHS_MATCH_FROM(0.00)[]; IP_SCORE(0.00)[country: AU(0.01)];
 RCVD_COUNT_TWO(0.00)[2]
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
 <freebsd-hackers.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-hackers>, 
 <mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers/>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
 <mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 29 Oct 2019 12:49:42 -0000

> On 29 Oct 2019, at 13:13, Wojciech Puchar <wojtek@puchar.net> wrote:
>=20
> i want to convert accouts from one system where there was mail-only =
accounts using dovecot/postfix based system and SQL tables to my system, =
where accounts are real unix accounts - that do mail and other things.
>=20
> I don't know all people's plaintext passwords, and i don't need to and =
want to, but i want new accounts to work with the same passwords
>=20
> in SQL tables there are entries like this:
>=20
> $1$aab7638c$Cn7BA/oU4mzr0QltXzV7Z0
>=20
> and these works by simple cut and paste to /etc/master.passwd file
>=20
>=20
> but there are entries like:
>=20
> {PLAIN-MD5}c575f55800a549930b9063b43af04f47
>=20
> that doesn't
>=20
>=20
> is there a way to make it work without contacting over hundred people =
and telling them what new password they have?

If it is just MD5 with no salt, I suspect substituting =E2=80=9C$1$$=E2=80=
=9D for the =E2=80=9C{PLAIN_MD5}=E2=80=9D would be sufficient.


Regards,

Jan M.