Вот и у меня ошибка лезет, была у же тут такая, было и решение, но ко мне не подошло ((
что не так?
Код: Выделить всё
mail# cat /var/log/maillog
Dec 17 16:21:18 mail authdaemond: modules="authmysql", daemons=5
Dec 17 16:21:18 mail authdaemond: Installing libauthmysql
Dec 17 16:21:18 mail authdaemond: Installation complete: authmysql
это при попытке зайти в roundcube
Вот лог БД
Код: Выделить всё
mail# cat /var/log/mysql.log
101217 16:32:21 8 Connect roundcube@localhost on
8 Init DB roundcube
8 Query SET NAMES utf8
8 Query PREPARE mdb2_statement_mysql_110540b03cf689b696a591fe329ddaa97c3bfc490 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?'
8 Prepare SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?
8 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
8 Query EXECUTE mdb2_statement_mysql_110540b03cf689b696a591fe329ddaa97c3bfc490 USING @0
8 Execute SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = '918584cfa63dac3271e52dac54453ecc'
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_110540b03cf689b696a591fe329ddaa97c3bfc490
8 Query PREPARE mdb2_statement_mysql_2a09e55f7363ba8f5edea05cc9939318ef55cb959 FROM 'DELETE FROM session WHERE sess_id = ?'
8 Prepare DELETE FROM session WHERE sess_id = ?
8 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
8 Query EXECUTE mdb2_statement_mysql_2a09e55f7363ba8f5edea05cc9939318ef55cb959 USING @0
8 Execute DELETE FROM session WHERE sess_id = '918584cfa63dac3271e52dac54453ecc'
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_2a09e55f7363ba8f5edea05cc9939318ef55cb959
8 Query PREPARE mdb2_statement_mysql_3839eb9dec262967e2eae09c576766981830688a0 FROM 'SELECT * FROM users WHERE mail_host = ? AND username = ?'
8 Prepare SELECT * FROM users WHERE mail_host = ? AND username = ?
8 Query SET @0 = 'localhost'
8 Query SET @1 = 'root@domain.ru'
8 Query EXECUTE mdb2_statement_mysql_3839eb9dec262967e2eae09c576766981830688a0 USING @0, @1
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_3839eb9dec262967e2eae09c576766981830688a0
8 Query PREPARE mdb2_statement_mysql_420928e082d7cd78ae5087ef117f211dee93a6f84 FROM 'SELECT * FROM users WHERE mail_host = ? AND alias = ?'
8 Prepare SELECT * FROM users WHERE mail_host = ? AND alias = ?
8 Query SET @0 = 'localhost'
8 Query SET @1 = 'root@domain.ru'
8 Query EXECUTE mdb2_statement_mysql_420928e082d7cd78ae5087ef117f211dee93a6f84 USING @0, @1
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_420928e082d7cd78ae5087ef117f211dee93a6f84
9 Connect postfix@localhost on
9 Init DB postfix
9 Query SET NAMES utf8
9 Query SELECT username, password, "", 1983, 1983, ('/var/spool/mail/domain.ru', 'Maildir'), maildir, quota, name, active='1' FROM mailbox WHERE username = 'root@domain.ru'
9 Quit
10 Connect postfix@localhost on
10 Init DB postfix
10 Query SET NAMES utf8
10 Query SELECT username, password, "", 1983, 1983, ('/var/spool/mail/domain.ru', 'Maildir'), maildir, quota, name, active='1' FROM mailbox WHERE username = 'root@domain.ru'
10 Quit
8 Query PREPARE mdb2_statement_mysql_51b8bd551124c07d9cd8eb0086192590b926e4c22 FROM 'DELETE FROM session WHERE sess_id = ?'
8 Prepare DELETE FROM session WHERE sess_id = ?
8 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
8 Query EXECUTE mdb2_statement_mysql_51b8bd551124c07d9cd8eb0086192590b926e4c22 USING @0
8 Execute DELETE FROM session WHERE sess_id = '918584cfa63dac3271e52dac54453ecc'
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_51b8bd551124c07d9cd8eb0086192590b926e4c22
8 Query PREPARE mdb2_statement_mysql_637de74a30415610b2fcef7fa12acc9f6c1506065 FROM 'UPDATE session SET vars = ?, changed = FROM_UNIXTIME(1292603541) WHERE sess_id = ?'
8 Prepare UPDATE session SET vars = ?, changed = FROM_UNIXTIME(1292603541) WHERE sess_id = ?
8 Query SET @0 = 'language|s:5:\"ru_RU\";auth_time|i:1292603541;temp|b:1;request_tokens|a:1:{s:5:\"login\";s:32:\"3d3fca48a67dc84554617fded90a64c9\";}'
8 Query SET @1 = '918584cfa63dac3271e52dac54453ecc'
8 Query EXECUTE mdb2_statement_mysql_637de74a30415610b2fcef7fa12acc9f6c1506065 USING @0, @1
8 Execute UPDATE session SET vars = 'language|s:5:\"ru_RU\";auth_time|i:1292603541;temp|b:1;request_tokens|a:1:{s:5:\"login\";s:32:\"3d3fca48a67dc84554617fded90a64c9\";}', changed = FROM_UNIXTIME(1292603541) WHERE sess_id = '918584cfa63dac3271e52dac54453ecc'
8 Query DEALLOCATE PREPARE mdb2_statement_mysql_637de74a30415610b2fcef7fa12acc9f6c1506065
8 Quit
101217 16:32:24 11 Connect roundcube@localhost on
11 Init DB roundcube
11 Query SET NAMES utf8
11 Query PREPARE mdb2_statement_mysql_1eb29eb1339062fb325b15f8a8112dfaba06808b2 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?'
11 Prepare SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?
11 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
11 Query EXECUTE mdb2_statement_mysql_1eb29eb1339062fb325b15f8a8112dfaba06808b2 USING @0
11 Execute SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = '918584cfa63dac3271e52dac54453ecc'
11 Query DEALLOCATE PREPARE mdb2_statement_mysql_1eb29eb1339062fb325b15f8a8112dfaba06808b2
11 Query PREPARE mdb2_statement_mysql_2a9b29b50bb5055b6d2118afcb8163a41ea461a30 FROM 'SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?'
11 Prepare SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id = ?
11 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
11 Query EXECUTE mdb2_statement_mysql_2a9b29b50bb5055b6d2118afcb8163a41ea461a30 USING @0
11 Query DEALLOCATE PREPARE mdb2_statement_mysql_2a9b29b50bb5055b6d2118afcb8163a41ea461a30
11 Query PREPARE mdb2_statement_mysql_3bfbf86d96c3c8350aa282a152777517174f723ed FROM 'INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, FROM_UNIXTIME(1292603544), FROM_UNIXTIME(1292603544))'
11 Prepare INSERT INTO session (sess_id, vars, ip, created, changed) VALUES (?, ?, ?, FROM_UNIXTIME(1292603544), FROM_UNIXTIME(1292603544))
11 Query SET @0 = '918584cfa63dac3271e52dac54453ecc'
11 Query SET @1 = 'auth_time|i:1292603544;temp|b:1;language|s:5:\"ru_RU\";task|s:5:\"login\";request_tokens|a:1:{s:5:\"login\";s:32:\"99b4e04e5bcf779ad4496757a262745c\";}'
11 Query SET @2 = '192.168.2.40'
11 Query EXECUTE mdb2_statement_mysql_3bfbf86d96c3c8350aa282a152777517174f723ed USING @0, @1, @2
11 Execute INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('918584cfa63dac3271e52dac54453ecc', 'auth_time|i:1292603544;temp|b:1;language|s:5:\"ru_RU\";task|s:5:\"login\";request_tokens|a:1:{s:5:\"login\";s:32:\"99b4e04e5bcf779ad4496757a262745c\";}', '192.168.2.40', FROM_UNIXTIME(1292603544), FROM_UNIXTIME(1292603544))
11 Query DEALLOCATE PREPARE mdb2_statement_mysql_3bfbf86d96c3c8350aa282a152777517174f723ed
11 Quit
Код: Выделить всё
mail# cat /usr/local/etc/authlib/authdaemonrc | grep -v ^# | grep -v ^$
authmodulelist="authmysql"
authmodulelistorig="authmysql"
daemons=5
authdaemonvar=/var/run/authdaemond
subsystem=mail
DEBUG_LOGIN=2
DEFAULTOPTIONS="wbnodsn=1"
LOGGEROPTS=""
Код: Выделить всё
mail# cat /usr/local/etc/authlib/authmysqlrc | grep -v ^# | grep -v ^$
MYSQL_SERVER localhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE postfix
MYSQL_CHARACTER_SET utf8
MYSQL_USER_TABLE mailbox
MYSQL_CRYPT_PWFIELD password
DEFAULT_DOMAIN domain.ru
MYSQL_UID_FIELD 1983
MYSQL_GID_FIELD 1983
MYSQL_LOGIN_FIELD username
MYSQL_HOME_FIELD ('/var/spool/mail.domain.ru', 'maildir')
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
MYSQL_AUXOPTIONS_FIELD active='1'
Менял MYSQL_HOME_FIELD на ('/var/spool/mail', 'maildir') изменений нет(((
Код: Выделить всё
mail# cat /var/log/maillog | grep authdaemond
Dec 17 16:21:18 mail authdaemond: modules="authmysql", daemons=5
Dec 17 16:21:18 mail authdaemond: Installing libauthmysql
Dec 17 16:21:18 mail authdaemond: Installation complete: authmysql
Код: Выделить всё
mail# cat /usr/local/etc/courier-imap/pop3d | grep -v ^# | grep -v ^$
PIDFILE=/var/run/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
POP3AUTH="PLAIN LOGIN CRAM-MD5"
POP3AUTH_ORIG="PLAIN LOGIN CRAM-MD5"
POP3AUTH_TLS="PLAIN LOGIN CRAM-MD5"
POP3AUTH_TLS_ORIG="PLAIN LOGIN CRAM-MD5"
POP3_PROXY=0
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
LOGGEROPTS="-name=courier-imap"
POP3DSTART=YES
MAILDIRPATH=Maildir
Код: Выделить всё
mail# sockstat | grep :110
root couriertcp 1927 3 tcp4 192.168.2.111:110 *:*
mail# sockstat | grep :143
root couriertcp 1941 3 tcp4 192.168.2.111:143 *:*
Код: Выделить всё
mail# cat /usr/local/etc/postfix/main.cf | grep -v ^# | grep -v ^$
command_directory = /usr/local/sbin
daemon_directory = /usr/local/libexec/postfix
base = /usr/local/etc/postfix
data_directory = /var/db/postfix
myhostname = domain.ru
mydomain = domain.ru
myorigin = $mydomain
inet_interfaces = all
mydestination = $mydomain, $myhostname, localhost.$mydomain, localhost
local_recipient_maps = unix:passwd.byname $alias_maps
unknown_local_recipient_reject_code = 550
mynetworks_style = host
mynetworks = 127.0.0.0/8
smtpd_delay_reject = yes
alias_database = hash:/etc/aliases
mail_spool_directory = /var/spool/mail
smtpd_banner = $myhostname ESMTP
debug_peer_level = 2
debug_peer_list = 127.0.0.1, domain.ru
debugger_command =
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
ddd $daemon_directory/$process_name $process_id & sleep 5
sendmail_path = /usr/local/sbin/sendmail
newaliases_path = /usr/local/bin/newaliases
mailq_path = /usr/local/bin/mailq
setgid_group = maildrop
html_directory = /usr/local/share/doc/postfix
manpage_directory = /usr/local/man
sample_directory = /usr/local/etc/postfix
readme_directory = /usr/local/share/doc/postfix
smtpd_client_restrictions = permit_mynetworks,
permit_sasl_authenticated,
check_client_access hash:$base/client_access,
reject_unknown_address,
reject_unknown_recipient_domain,
reject_unknown_sender_domain,
reject_unauth_destination,
reject_unauth_pipelining
smtd_hello_restrictions = permit_mynetworks,
check_sender_access hash:$base/sender_access,
reject_authenticated_sender_login_mismatch,
reject_unknown_sender_domain,
reject_unlisted_sender,
reject_unverified_sender
smtd_recipient_restrictions = permit_mynetworks,
permit_sasl_authenticated,
check_sender_access hash:$base/recipient_access,
check_policy_service inet:127.0.0.1:10023,
reject_unauth_destination,
reject_unlisted_recipient,
reject_unknown_domain,
reject_unverified_recipient
check_police_service inet:127.0.0.1:10023
Otklonat komandu ETRN
smtpd_etrn_rectrictions=reject
smtpd_reject_unlisted_sender=yes
disable_vrfy_command=yes
strict_rfc821_envelopes=yes
show_user_unknown_table_name=no
address_verify_sender=admin@domain.ru
unverified_sender_reject_code=550
smtpd_aleays_send_ehlo=yes
smtpd_hard_error_limit=8
smtps_sasl_application_name = smtpd
broken_sasl_auth_clients=yes
smtpd_sasl_security_options=noanonymmous
smtpd_sender_login_maps=mysql:$base/mysqlLookupMaps/sender.conf
virtual_alias_maps = mysql:$base/mysqlLookupMaps/alias.conf
virtual_mailbox_domains = mysql:$base/mysqlLookupMaps/domain.conf
virtual_mailbox_maps=mysql:$base/mysqlLookupMaps/mailbox.conf
virtual_mailbox_base=/var/spool/mail
virtual_mailbox_limit_maps = mysql:$base/mysqlLookupMaps/quota.conf
virtual_maildir_extended=yes
virtual_mailbox_limit_override=yes
virtual_create_maildirsize = yes
virtual_overquota_bounce = yes
virtual_maildir_limit_message = "Sorry, the user`s maildir has overdraw his diskspase quota"
mbmessage_size_limit =47185920
virtual_gid_maps = static:1983
virtual_uid_maps = static:1983
virtual_minimum_uid = 1000
virtual_transport = virtual
mailbox_transport = virtual
Код: Выделить всё
mail# cat /usr/local/lib/sasl2/smtpd.conf
pwcheck_method: auxprop
mech_list: PLAIN LOGIN CRAM-MD5
auxprop_plugin: sql
sql_usessl: yes
sql_engine: mysql
sql_hostnames: localhost
sql_user: postfix
sql_passwd: postfix
sql_database: postfix
sql_select: select password from mailbox where username = '%u@%r'
log_level: 3