Hi. I'm a dovecot newbie. I've set my pop client to leave messages on the server for 7 days. I'm downloading the same messages over and over as dovecot appears to be overwriting X-UID's in the mbox's. I can't think of any other program on the system that might write to the mbox other than postfix (and that program doesn't appear to be writing X-UID). My setup has one user (system account: vmail) that owns all mbox's. The user_query always returns vmail's home, uid and gid (you can view the SELECT's in the log snippet below).I have a total of four pop3 virtual mbox's. The example below illustrates what happens to one of them (though this problem extends to the others as well).
Here's what happens:
Start with an empty mbox
Start dovecot
Download mail (received one email)
cat mbox | egrep "X-UID:" X-UID: 789
- Download mail again (received another email)
cat mbox | egrep "X-UID:"
X-UID: 789
X-UID: 790
- Download mail once more (received three spam emails)
cat mbox | egrep "X-UID:"
X-UID: 811
X-UID: 812
X-UID: 813
X-UID: 814
X-UID: 815
What the?!
- Check log
dovecot: Apr 04 13:51:42 Info: auth(default): new auth connection: pid=12843
dovecot: Apr 04 13:51:42 Info: auth(default): client in: AUTH 1 PLAIN service=POP3 lip=76.158.191.23 rip=44.156.77.13 resp=<hidden>
dovecot: Apr 04 13:51:42 Info: auth-worker(default): sql(imacrawler@searchingforaddressestospam.com,44.156.77.13): query: SELECT CONCAT(username, '@', domain) AS user, password FROM (SELECT vuser.username, vuser.password, vdomain.name AS domain FROM vuser LEFT JOIN vdomain ON vuser.vdomain_id=vdomain.id) a WHERE a.username='imacrawler' AND a.domain='searchingforaddressestospam.com'
dovecot: Apr 04 13:51:42 Info: auth(default): client out: OK 1 user=imacrawler@searchingforaddressestospam.com
dovecot: Apr 04 13:51:42 Info: auth(default): master in: REQUEST 7 12837 1
dovecot: Apr 04 13:51:42 Info: auth-worker(default): sql(imacrawler@searchingforaddressestospam.com,44.156.77.13): SELECT '/vmail' AS home, CONCAT('mbox:~/mail:INBOX=/var/spool/vmail/', TRIM('searchingforaddressestospam.com'), '/', TRIM('imacrawler')) AS mail, 103 AS uid, 104 AS gid
dovecot: Apr 04 13:51:42 Info: auth(default): master out: USER 7 imacrawler@searchingforaddressestospam.com home=/vmail mail=mbox:~/mail:INBOX=/var/spool/vmail/searchingforaddressestospam.com/imacrawler uid=103 gid=104
dovecot: Apr 04 13:51:42 Error: POP3(imacrawler@searchingforaddressestospam.com): mbox sync: Expunged message reappeared in mailbox /var/spool/vmail/searchingforaddressestospam.com/imacrawler (UID 789 < 796, seq=1, idx_msgs=0)
dovecot: Apr 04 13:51:42 Info: pop3-login: Login: user=imacrawler@searchingforaddressestospam.com, method=PLAIN, rip=44.156.77.13, lip=76.158.191.23
dovecot: Apr 04 13:51:42 Error: POP3(imacrawler@searchingforaddressestospam.com): mbox sync: UID inserted in the middle of mailbox /var/spool/vmail/searchingforaddressestospam.com/imacrawler (796 > 789, seq=1, idx_msgs=5)
dovecot: Apr 04 13:51:42 Error: POP3(imacrawler@searchingforaddressestospam.com): mbox sync: UID inserted in the middle of mailbox /var/spool/vmail/searchingforaddressestospam.com/imacrawler (801 > 789, seq=1, idx_msgs=5)
dovecot: Apr 04 13:51:43 Error: POP3(imacrawler@searchingforaddressestospam.com): mbox sync: UID inserted in the middle of mailbox /var/spool/vmail/searchingforaddressestospam.com/imacrawler (806 > 789, seq=1, idx_msgs=5)
dovecot: Apr 04 13:51:43 Info: POP3(imacrawler@searchingforaddressestospam.com): Disconnected: Logged out top=0/0, retr=5/9032, del=0/5, size=8947
I have no idea why it's complaining about 796 or where that number even came from. Much thanks for any help you can give.
Here's my dovecot -n: # 1.0.13: /usr/local/etc/dovecot.conf log_path: /var/log/dovecot protocols: pop3 ssl_disable: yes disable_plaintext_auth: no login_dir: /usr/local/var/run/dovecot/login login_executable: /usr/local/libexec/dovecot/pop3-login first_valid_uid: 103 last_valid_uid: 103 first_valid_gid: 104 last_valid_gid: 104 mail_privileged_group: vmail mail_executable: /usr/local/libexec/dovecot/pop3 mail_plugin_dir: /usr/local/lib/dovecot/pop3 pop3_uidl_format: %08Xu%08Xv auth default: verbose: yes debug: yes passdb: driver: sql args: /usr/local/etc/dovecot-sql.conf userdb: driver: sql args: /usr/local/etc/dovecot-sql.conf
____________________________________________________________________________________You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com