Re: courier+mysql

[<radek@gate3.p-x.pl>]

> W jaki wiec sposob chcesz autoryzowac uzytkownikow? Ustaw
> POP3AUTH="LOGIN".
>
ustawilem tak.
teraz courier loguje swoje wejscia do mysql ale nadaj calosc nie funguje

logi z mysqld.log (dla couriera - reszta jest ok):

040928 10:55:36      19 Connect     courier@localhost on
       19 Init DB     MailServer
       19 Query       SELECT EmailAddress, "", Password, uid, gid,
'/var/spool/postfix/virtual', MailDirLocation, Quota, FullName, "" FROM
MailBox WHERE EmailAddress = "user-testowy@moja.domena"
       19 Quit
       20 Connect     courier@localhost on
       20 Init DB     MailServer
       20 Query       SELECT EmailAddress, "", Password, uid, gid,
'/var/spool/postfix/virtual', MailDirLocation, Quota, FullName, "" FROM
MailBox WHERE EmailAddress = user-testowy@moja.domena
       20 Quit

natomiast logi s syslog sa takie :

Sep 28 10:55:36 mail pop3d: Connection, ip=[::ffff:tu ip]
Sep 28 10:55:36 mail pop3d: LOGIN: DEBUG: ip=[::ffff:tu ip], command=USER
Sep 28 10:55:36 mail pop3d: LOGIN: DEBUG: ip=[::ffff:tu ip], command=PASS
Sep 28 10:55:36 mail pop3d: LOGIN: DEBUG: ip=[::ffff:tu ip],
username=nazwa_usera_testowy
Sep 28 10:55:36 mail pop3d: LOGIN: DEBUG: ip=[::ffff:tu ip],
password=jego_haslo #plain text (w bazie tez w plain text)
Sep 28 10:55:36 mail pop3d: authmysql: starting client module
Sep 28 10:55:36 mail pop3d: SQL query: SELECT EmailAddress, "", Password,
uid, gid, '/var/spool/postfix/virtual', MailDirLocation, Quota, FullName, ""
FROM MailBox WHERE EmailAddress = "user-testowy@moja.domena"
Sep 28 10:55:36 mail pop3d: mysql_query failed, reconnecting
Sep 28 10:55:36 mail pop3d: mysql_query failed second time, giving up
Sep 28 10:55:36 mail pop3d: authmysql: TEMPFAIL - no more modules will be
tried
Sep 28 10:55:41 mail pop3d: LOGIN FAILED, ip=[::ffff:tu ip]

moje wnioski:
courier do bazy sie zalogowal ale mial zle zapytanie i nie zutoryzowal
klienta
zapytanie "dostraja sie" w authmysqlrc ale tam mam wszystko ok (tak mi sie
zdaje)
ale przytocze jeszcze raz plik:

DEFAULT_DOMAIN moja.domena
MYSQL_SERVER 127.0.0.1
MYSQL_SOCKET /var/run/mysql/mysql.sock
MYSQL_DATABASE MailServer
MYSQL_USERNAME courier
MYSQL_PASSWORD haslo_usera_courier
#MYSQL_PORT 0
MYSQL_OPT 0
MYSQL_USER_TABLE MailBox
MYSQL_LOGIN_FIELD EmailAddress
MYSQL_NAME_FIELD FullName
#MYSQL_CRYPT_PWFIELD Password
MYSQL_CLEAR_PWFIELD Password
MYSQL_HOME_FIELD '/var/spool/postfix/virtual'
MYSQL_MAILDIR_FIELD MailDirLocation
MYSQL_GID '54321'
MYSQL_UID '12345'
MYSQL_QUOTA_FIELD Quota
MYSQL_QUERY_LASTREAD UPDATE MailBox SET LastLogin=now() WHERE
EmailAddress='%s'

pozdrawiam

radziu