[Dovecot] Dovecot error wuth MySQL

[Cesar]

Thanls for your answers (about pf my problem with Dovecot and MySQL)

*This is the answers:
postconf -n:*
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
data_directory = /var/lib/postfix
debug_peer_level = 2
header_checks = regexp:/etc/postfix/header_checks
html_directory = no
inet_interfaces = all
inet_protocols = ipv4
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = localhost
mydomain = raho.com.py
myhostname = mail.raho.com.py
mynetworks_style = host
myorigin = $mydomain
newaliases_path = /usr/bin/newaliases.postfix
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps
$virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains
$relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps
$recipient_canonical_maps $relocated_maps $transport_maps $mynetworks
$virtual_mailbox_limit_maps
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES
sample_directory = /usr/share/doc/postfix-2.6.6/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks,
reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_path = private/auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_tls_cert_file = /etc/pki/tls/certs/mail.raho.com.py.crt
smtpd_tls_key_file = /etc/pki/tls/private/mail.raho.com.py.key
smtpd_tls_loglevel = 1
smtpd_tls_security_level = may
smtpd_tls_session_cache_database = btree:/var/lib/postfix/smtpd_tls_cache.db
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
transport_maps = hash:/etc/postfix/transport
unknown_local_recipient_reject_code = 550
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf,   
proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_maps.cf,   
proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_catchall_maps.cf
virtual_gid_maps = static:5000
virtual_mailbox_domains =
proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps =
proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf,   
proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_mailbox_maps.cf
virtual_transport = dovecot
virtual_uid_maps = static:5000

*dovecot -n:*
# 2.0.9: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-279.el6.x86_64 x86_64 CentOS release 6.3 (Final)
auth_mechanisms = plain login cram-md5
dict {
  quotadict = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
disable_plaintext_auth = no
first_valid_gid = 5000
first_valid_uid = 5000
last_valid_gid = 5000
last_valid_uid = 5000
mail_gid = 5000
mail_location = maildir:%hMaildir
mail_plugins = quota
mail_uid = 5000
mbox_write_locks = fcntl
namespace {
  inbox = yes
  location =
  prefix = INBOX.
  separator =
  type = private
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
plugin {
  quota = dict:user::proxy::quotadict
  quota_warning = storage=95%% quota-warning 95 %u
  quota_warning2 = storage=80%% quota-warning 80 %u
}
postmaster_address = postmaster at raho.com.py
service auth-worker {
  user = $default_internal_user
}
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0660
    user = postfix
  }
  unix_listener auth-userdb {
    group = vmail
    mode = 0600
    user = vmail
  }
}
service dict {
  unix_listener dict {
    user = vmail
  }
}
service quota-warning {
  executable = script /etc/dovecot/quota-warning.sh
  unix_listener quota-warning {
    user = vmail
  }
  user = vmail
}
ssl_cert = </etc/pki/tls/certs/mail.raho.com.py.crt
ssl_cipher_list = ALL:!LOW:!SSLv2
ssl_key = </etc/pki/tls/private/mail.raho.com.py.key
userdb {
  driver = prefetch
}
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
protocol lda {
  mail_plugins = quota
}
protocol imap {
  mail_plugins = quota imap_quota
}
protocol pop3 {
  mail_plugins = quota
  pop3_uidl_format = %08Xu%08Xv
}

<b>May be the configuration of Mysql?,
Note: I don't want to use write cache, read cache is welcome,
this is my my.cnf file*
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
user = mysql

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

default-storage-engine = InnoDB
innodb_flush_log_at_trx_commit=1
sync_binlog=1
skip-external-locking
#max_delayed_threads = 0
connect_timeout = 15
wait_timeout = 60
interactive_timeout = 60
bind-address = 127.0.0.1

log_error = /var/log/mysqld.log
log_warnings = 0
local_infile = 0
skip-symbolic-links
max_connections = 200
max_user_connections = 170
back_log = 50
max_join_size = 256M
max_allowed_packet = 16M

key_buffer_size = 64M
myisam-recover = BACKUP,FORCE
query_cache_size = 64M
query_cache_type = 1
query_cache_limit = 1M
delay_key_write = OFF

table_open_cache = 4096
thread_cache_size = 64
tmp_table_size = 64M
max_tmp_tables = 64
max_heap_table_size = 64M
open_files_limit = 8192
thread_stack = 256K


innodb_thread_concurrency = 8
innodb_log_file_size = 5M
innodb_file_per_table = 1
innodb_buffer_pool_size = 128M
innodb_flush_method = O_DIRECT

long_query_time = 10
slow_query_log= 1
slow_query_log_file=/var/log/mysqld-slow.log
log-queries-not-using-indexes
log-short-format= 1

[myisamchk]
key_buffer                     = 512M
sort_buffer_size               = 512M
read_buffer                    = 16M
write_buffer                   = 16M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid




-----
Best Regards
Cesar
--
View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-error-with-MySQL-tp40765p40781.html
Sent from the Dovecot mailing list archive at Nabble.com.