Привет ВСЕМ!
В логах mysql никакой авторизацией и не пахнет :(- в самом низу#uname -a
Linux debian 2.6.15-1-686
courier -0.47
# mysql --version
mysql Ver 14.12 Distrib 5.0.18,
Вот что в логах:
Sep 28 01:31:14 debian authdaemond.mysql: restarting authdaemond children
Sep 28 01:31:14 debian authdaemond.mysql: modules="authmysql", daemons=5
Sep 28 01:31:14 debian authdaemond.mysql: modules="authmysql", daemons=5
Sep 28 02:09:17 debian courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.100.1], command=USER
Sep 28 02:09:21 debian courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.100.1], command=PASS
Sep 28 02:09:21 debian courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.100.1], username=weldpua
Sep 28 02:09:21 debian courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.100.1], password=wel
Sep 28 02:09:26 debian courierpop3login: LOGIN FAILED, ip=[::ffff:192.168.100.1]
Sep 28 02:09:29 debian courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.100.1], command=QUIT
# exim4 -bV
Exim version 4.60 #1 built 22-Feb-2006 10:49:24
Support for: crypteq iconv() IPv6 PAM Perl GnuTLS move_frozen_messages Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb dsearch ldap ldapdn ldapm mysql nis nis0 passwd pgsqlAuthenticators: cram_md5 cyrus_sasl plaintext spa
Routers: accept dnslookup ipliteral iplookup manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
# cat /etc/courier/authdaemonrc|grep -v '#'
authmodulelist="authmysql"
authmodulelistorig="authmysql authuserdb authpam authpgsql authldap authcustom authpipe"
daemons=5
authdaemonvar=/var/spool/authdaemon
DEFAULTOPTIONS=""
DEBUG_LOGIN=2
# cat /etc/courier/authmysqlrc|grep -v '#'
MYSQL_SERVER localhost
MYSQL_USERNAME exim
MYSQL_PASSWORD cnhfdfeljvf
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_OPT 0
MYSQL_DATABASE exim
MYSQL_SELECT_CLAUSE SELECT CONCAT(id,'@',mbox_host), crypt, "", 1001, 6, home, CONCAT(home,'/Maildir'), "", id, "" FROM users WHERE CONCAT(id,'@',mbox_host) ="$(local_part)@$(domain)"
MYSQL_USER_TABLE `users`
MYSQL_CLEAR_PWFIELD `passwd`
MYSQL_UID_FIELD `uid`
MYSQL_GID_FIELD `gid`
MYSQL_LOGIN_FIELD `id`
MYSQL_MAILDIR_FIELD CONCAT(`home`, `id`)
MYSQL_HOME_FIELD "/home/vmail/domains/"
# cat /etc/courier/pop3d|grep -v '#'
PIDFILE=/var/run/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
POP3AUTH="LOGIN"
POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1 CRAM-SHA256"
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
POP3_PROXY=0
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=YES
MAILDIRPATH=Maildir
LOGGEROPTS="-name=pop3d"
DEBUG_LOGIN=2
# cat /var/log/mysql/mysql.log|grep -v '#'
/usr/sbin/mysqld, Version: 5.0.18-Debian_9-log. started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
060928 1:40:38 2 Connect exim@localhost on exim
2 Query SELECT domain FROM domains WHERE domain='skyhome' AND (type='LOCAL' OR type='VIRTUAL')
2 Query SELECT recipients FROM aliases WHERE local_part='weldpua2008' AND domain='skyhome'
2 Query SELECT recipients FROM userforward WHERE local_part='weldpua2008' AND domain='skyhome'
2 Query SELECT home FROM users WHERE id='weldpua2008' AND mbox_host='skyhome' AND active='Y'
2 Quit
060928 1:49:13 3 Connect exim@localhost on exim
3 Query SELECT address FROM blacklists WHERE address='192.168.100.1' AND type='HOSTREJ'
060928 1:49:14 3 Query SELECT domain FROM domains WHERE domain='' AND (type='LOCAL' OR type='VIRTUAL')
060928 1:49:31 3 Quit
060928 1:49:40 4 Connect exim@localhost on exim
4 Query SELECT address FROM blacklists WHERE address='192.168.100.1' AND type='HOSTREJ'
4 Query SELECT domain FROM domains WHERE domain='' AND (type='LOCAL' OR type='VIRTUAL')
060928 1:49:53 4 Query SELECT domain FROM domains WHERE domain='' AND type='RELAY'
060928 1:50:57 4 Quit