[HowTo] Replace courier with dovecot

[dexter1983]

This appear on /var/log/mail.log

Feb 18 02:22:26 web postfix/trivial-rewrite[2885]: warning: do not list domain domain.tld in BOTH mydestination and virtual_mailbox_domains

Feb 18 03:10:34 web postfix/smtpd[2489]: SSL_accept:before/accept initialization
Feb 18 03:10:34 web postfix/smtpd[2489]: SSL_accept error from srv.domain.tld[xxx.xxx.xxx.xxx]: -1
Feb 18 03:10:34 web postfix/smtpd[2489]: lost connection after CONNECT from srv.domain.tld[xxx.xxx.xxx.xxx]
Feb 18 03:10:34 web postfix/smtpd[2489]: disconnect from srv.domain.tld[xxx.xxx.xxx.xxx]
Feb 18 03:10:34 web postfix/smtpd[2488]: connect from srv.domain.tld[xxx.xxx.xxx.xxx]
Feb 18 03:10:34 web postfix/smtpd[2488]: lost connection after CONNECT from srv.domain.tld[xxx.xxx.xxx.xxx]
Feb 18 03:10:34 web postfix/smtpd[2488]: disconnect from srv.domain.tld[xxx.xxx.xxx.xxx]
Feb 18 03:11:11 web dovecot: auth-worker(default): sql(office@domain.tld,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(mail_type='normal_mail' OR mail_type='normal_mail,normal_forward')' at line 1
Feb 18 03:11:11 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Feb 18 03:11:11 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Feb 18 03:11:11 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Feb 18 03:11:11 web dovecot: imap-login: Internal login failure: user=<office@hitech-it.ro>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Feb 18 03:15:26 web dovecot: imap-login: Disconnected: rip=xxx.xxxx.xxx.xxx, lip=xxx.xxx.xxx.xxx, TLS handshake
Feb 18 03:17:22 web dovecot: pop3-login: Disconnected: rip=xxx.xxx.xxx.xxx, lip=xxx.xxx.xxx.xxx, TLS handshake
Feb 18 03:18:28 web postgrey[2183]: 2010/02/18-03:18:28 Server closing!
Feb 18 03:18:28 web postgrey[2183]: Couldn't unlink "/var/run/postgrey.pid" [Permission denied]
Feb 18 03:18:28 web postfix/master[2245]: terminating on signal 15
Feb 18 03:18:32 web postfix/policyd-weight[2149]: cache killed
Feb 18 03:18:32 web postfix/policyd-weight[2148]: master: child 2149 exited
Feb 18 03:18:32 web postfix/policyd-weight[2487]: warning: Got SIGPIPE. Child 2487 terminated.
Feb 18 03:18:32 web postfix/policyd-weight[2487]: warning: child: err: Died at /usr/sbin/policyd-weight line 1311.#012
Feb 18 03:18:32 web postfix/policyd-weight[2487]: warning: Got SIGPIPE. Child 2487 terminated.
Feb 18 03:18:32 web dovecot: Killed with signal 15
Feb 18 10:32:32 web postfix/policyd-weight[2153]: policyd-weight 0.1.14 beta-17 started and daemonized. conf:default settings; GID:109 109 EGID:109 109 UID:107 EUID:107; taint mode: 0
Feb 18 10:32:32 web postfix/policyd-weight[2153]: warning: cache_query: $csock couln't be created: connect: No such file or directory, calling spawn_cache()
Feb 18 10:32:32 web postfix/policyd-weight[2154]: cache spawned
Feb 18 10:32:33 web postgrey[2188]: Process Backgrounded
Feb 18 10:32:33 web postgrey[2188]: 2010/02/18-10:32:33 postgrey (type Net::Server::Multiplex) starting! pid(2188)
Feb 18 10:32:33 web postgrey[2188]: Binding to TCP port 60000 on host 127.0.0.1#012
Feb 18 10:32:33 web postgrey[2188]: Setting gid to "110 110"
Feb 18 10:32:33 web postgrey[2188]: Setting uid to "108"
Feb 18 10:32:34 web postfix/master[2250]: daemon started -- version 2.5.5, configuration /etc/postfix
Feb 18 10:32:35 web dovecot: Dovecot v1.0.15 starting up
Feb 18 10:32:35 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Feb 18 10:32:35 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)
Feb 18 10:32:35 web dovecot: auth-worker(default): mysql: Connected to localhost (ispcp)

Of corse domain.tld replace with my real domain

---

This is in .var.log/mail.err

Feb 18 02:29:14 web dovecot: imap-login: No authentication sockets found
Feb 18 02:29:14 web dovecot: child 2840 (login) returned error 89
Feb 18 02:32:59 web dovecot: auth-worker(default): sql(admin@domain.tld,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(mail_type='normal_mail' OR mail_type='normal_mail,normal_forward')' at line 1
Feb 18 03:03:05 web dovecot: auth-worker(default): sql(admin@domain.tld,127.0.0.1): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(mail_type='normal_mail' OR mail_type='normal_mail,normal_forward')' at line 1