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@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 =
<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.... Sent from the Dovecot mailing list archive at Nabble.com.