On Thu, 2013-03-14 at 11:32 +0100, Robert Schetterer wrote:

Am 14.03.2013 09:28, schrieb Cesar:

...

dovecot: auth: Error: mysql: Query failed, retrying: MySQL server has gone away: 125 Time(s)(125 Times Wow)For example part of maillog show me:About MySQL auth failed:Mar 10 03:55:05 gateway dovecot: auth: Error: mysql: Query

looks like your mysql server was not reachable

I've seen this before with people who play silly buggers with the timeout values with mysql, if the OP has not done so, enable logging on mysql and see what it is doing, else, undo the changes and leave the mysql timeout values at default.

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.