[Postfixbuch-users] Courier-Imap mit Authentifikation über MYSQL

[Roger Grosswiler]

..hat das schon jemand gemacht? Suchte ein Readme oder eine Howto...funktioniert aber irgendwie nicht:

Postfix liefert ein nach : /home/{user}/var/mail/...

Ich würde jetzt gerne eine Authentifizierung über Mysql durchführen, dabei hätte ich folgende angaben:
id = entspricht linux-user-id
uid = entsprocht linux-uid
gid = entspricht-linux-gid
home = /home/{user}/var/mail
passwort: irgendeinanderes passwort-nur nicht linux

die authdaemonrc ruft vi authmodulelist:0 die authmysql auf:
##NAME: authmodulelist:0
#
# The authentication modules that are linked into authdaemond.  The
# default list is installed.  You may selectively disable modules simply
# by removing them from the following list.  The available modules you
# can use are: authcustom authcram authuserdb authldap authmysql

#authmodulelist="authcustom authcram authuserdb authldap authmysql"
authmodulelist="authmysql"

die authmysql sieht so aus...:

MYSQL_SERVER            trinity
MYSQL_USERNAME          postfix
MYSQL_PASSWORD          supergeheim

##NAME: MYSQL_SOCKET:0
#
# MYSQL_SOCKET can be used with MySQL version 3.22 or later, it specifies the
# filesystem pipe used for the connection
#
# MYSQL_SOCKET          /var/mysql/mysql.sock

##NAME: MYSQL_PORT:0
#
# MYSQL_PORT can be used with MySQL version 3.22 or later to specify a port to
# connect to.

MYSQL_PORT              3306

##NAME: MYSQL_OPT:0
# Leave MYSQL_OPT as 0, unless you know what you're doing.

MYSQL_OPT               0

##NAME: MYSQL_DATABASE:0
#
# The name of the MySQL database we will open:

MYSQL_DATABASE          mailbase

##NAME: MYSQL_USER_TABLE:0
#
# The name of the table containing your user data.  See README.authmysqlrc
# for the required fields in this table.

MYSQL_USER_TABLE        mailbase

##NAME: MYSQL_CRYPT_PWFIELD:0
#
# Either MYSQL_CRYPT_PWFIELD or MYSQL_CLEAR_PWFIELD must be defined.  Both
# are OK too. crypted passwords go into MYSQL_CRYPT_PWFIELD, cleartext
# passwords go into MYSQL_CLEAR_PWFIELD.  Cleartext passwords allow
# CRAM-MD5 authentication to be implemented.

#MYSQL_CRYPT_PWFIELD    crypt

##NAME: MYSQL_CLEAR_PWFIELD:0
#
#
MYSQL_CLEAR_PWFIELD     password

##NAME: MYSQL_DEFAULT_DOMAIN:0
#
# If DEFAULT_DOMAIN is defined, and someone tries to log in as 'user',
# we will look up 'user at DEFAULT_DOMAIN' instead.
#
#
# DEFAULT_DOMAIN                gwch.ath.cx

##NAME: MYSQL_UID_FIELD:0
# Other fields in the mysql table:
#
# MYSQL_UID_FIELD - contains the numerical userid of the account
#
MYSQL_UID_FIELD         uid

##NAME: MYSQL_GID_FIELD:0
#
# Numerical groupid of the account

MYSQL_GID_FIELD         gid

##NAME: MYSQL_LOGIN_FIELD:0
#
# The login id, default is id.  Basically the query is:
#
#  SELECT MYSQL_UID_FIELD, MYSQL_GID_FIELD, ... WHERE id='loginid'
#

MYSQL_LOGIN_FIELD       id

##NAME: MYSQL_HOME_FIELD:0
#

MYSQL_HOME_FIELD        home

##NAME: MYSQL_NAME_FIELD:0
#
# The user's name (optional)

MYSQL_NAME_FIELD        name

##NAME: MYSQL_MAILDIR_FIELD:0
#
# This is an optional field, and can be used to specify an arbitrary
# location of the maildir for the account, which normally defaults to
# $HOME/Maildir (where $HOME is read from MYSQL_HOME_FIELD).
#
# You still need to provide a MYSQL_HOME_FIELD, even if you uncomment this
# out.
#
MYSQL_MAILDIR_FIELD     maildir
##NAME: MYSQL_QUOTA_FIELD:0
#
# Define MYSQL_QUOTA_FIELD to be the name of the field that can optionally
# specify a maildir quota.  See README.maildirquota for more information
#
# MYSQL_QUOTA_FIELD     quota

##NAME: MYSQL_WHERE_CLAUSE:0
#
# This is optional, MYSQL_WHERE_CLAUSE can be basically set to an arbitrary
# fixed string that is appended to the WHERE clause of our query
#
# MYSQL_WHERE_CLAUSE    server='mailhost.example.com'


Ein Telnet auf den Port mit dieser Konfiguration wird quittiert mit "NO login failed - punkt!" langsam kenne ich die fehlermeldung mehr als auswendig....wer kann mir da helfen, dass ich in meine mailboxen komme? ist evtl. der ort /home/{user}/var/mail/... falsch gewählt....? Besten Dank für die aktive Mithilfe an meiner Wochenendgestaltung....


Mit freundlichen Grüssen

Roger Grosswiler

-----------------------------------------------------------
Cablecom GmbH, Winterthur
Geschäftsstelle Zürich
Zollstrasse 42
8021 Zürich

Phone +41 1 277 97 57
Fax. +41 1 277 94 42
mail: roger.grosswiler at cablecom.ch
homepage: www.cablecom.ch