Re: courier+mysql

[Paweł Tęcza <ptecza@debianusers.pl>]

<radek@gate3.p-x.pl> writes:

[...]
> 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

Wyglada na to, ze zapytanie zawiera jakies bledy. A co sie dzieje,
gdy je wywolasz w kliencie mysql?

P.