* Eric Toczek, 2008-08-06 11:39
Thomas Zajic wrote:
Hi,
Same problem here - dovecot never adds any records to the expire
table, although the database connection is fine. All it ever does
is query for existing records when a message gets moved to Trash
or Junk, so at least that part is working.
Do you use namespaces? Since Timo just discovered they may not be
working with expire properly. "Looking at the code it looks like the
expire plugin ignores the namespace prefix but expire-tool requires it,
so it probably won't work.."
No, I'm not using namespaces, or at least not intentionally. Here's
the output of 'dovecot -n' and other possibly relevant stuff:
[EMAIL PROTECTED]:~# dovecot -n
# 1.1.2: /usr/local/etc/dovecot.conf
login_dir: /usr/local/var/run/dovecot/login
login_executable: /usr/local/libexec/dovecot/imap-login
login_greeting_capability: yes
mail_max_userip_connections: 20
verbose_proctitle: yes
mail_location: maildir:/home/%u/Maildir:INBOX=/home/%u/Maildir/.INBOX
fsync_disable: yes
mail_plugins: expire fts fts_squat
auth default:
mechanisms: plain digest-md5 cram-md5
passdb:
driver: passwd-file
args: /usr/local/etc/dovecot-passwd
userdb:
driver: passwd
socket:
type: listen
master:
path: /usr/local/var/run/dovecot/auth-master
mode: 384
plugin:
expire: Trash 30 Junk 60
expire_dict: proxy::expire
fts: squat
fts_squat: partial=4 full=6
dict:
expire: mysql:/usr/local/etc/dovecot-sql-expire.conf
[EMAIL PROTECTED]:~# cat /usr/local/etc/dovecot-sql-expire.conf
driver = mysql
connect = host=/var/run/mysql/mysql.sock user=XXX password=YYY dbname=dovecot
table = expire
select_field = when
where_field = path
username_field = username
[EMAIL PROTECTED]:~# mysql -p dovecot
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 900
Server version: 5.0.51 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> describe expire;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| username | varchar(64) | NO | PRI | NULL | |
| path | varchar(255) | NO | PRI | NULL | |
| when | varchar(64) | NO | | NULL | |
+----------+--------------+------+-----+---------+-------+
[EMAIL PROTECTED]:~#
Do you see any obvious errors and/or problems?
Thanks,
Thomas
