Migrating from courier imap+mysql to cyrus-imapd + pam_mysql

Uno Engborg uno at webworks.se
Wed Jun 24 12:19:29 UTC 2009


Hi,
I'm trying to migrate a mail system from Courier-imap to a Cyrus imapd
using saslauthd backed by pam with users and passwords stored in a MySQL
database. Naturally I don't want to force
my users to change password, so I want to reuse the password in
saslauthd ( I use sasl_pwcheck_method: saslauthd ) in cyrus.

My problem is that I don't know what password algorithm they have used
in the mysql database where the Courier users are stored. The users and
passwords are probably created by joomla and the password field in MySQL
look something like the four examples below:

$1$b729006d$c0QA4.h1DcdPU.ruT.t9G.  
$1$1a821c41$4bgG6zHlIiqQGVu1FObv90
$1$cc7768ea$J5GJRo6.Q9kG99amXm9K21 
$1$6f7f4578$3QMWFH/bvFzQbq8FbVDz1/

Anybody that have any clue what algorithm might be used for the Courier
authdaemond passwords? or if there are any suitable pam_module that can
make use of them?













Some more information:

The /etc/authlib/authdaemonrc looks like this:

authmodulelist="authmysql"
authmodulelistorig="authuserdb authpam authpgsql authldap authmysql
authcustom authpipe"
daemons=5
authdaemonvar=/var/spool/authdaemon
DEBUG_LOGIN=0
DEFAULTOPTIONS=""
LOGGEROPTS=""



The etc/authlib/authmysqlrc looks like this:

MYSQL_SERVER		localhost
MYSQL_USERNAME		postfixdb
MYSQL_PASSWORD		secret
MYSQL_PORT		0
MYSQL_OPT		0
MYSQL_DATABASE		postfix
MYSQL_USER_TABLE        mailbox
MYSQL_CRYPT_PWFIELD     password
DEFAULT_DOMAIN		mydomain.com
MYSQL_UID_FIELD		100
MYSQL_GID_FIELD		102
MYSQL_LOGIN_FIELD       username
MYSQL_HOME_FIELD	'/usr/local/virtual'
MYSQL_NAME_FIELD         name
MYSQL_MAILDIR_FIELD      maildir
MYSQL_QUOTA_FIELD        quota
MYSQL_WHERE_CLAUSE       active='1'



Thanks
Uno Engborg








More information about the fedora-list mailing list