Hi, I just installed dbmail and am excited to try it but I'm having a (probaby stupid) problem with dbmail-lmtpd:
I believe that I have everything plugged into postfix nicely. I added myself as a user, with every alias I could think of but I'm getting this message in my maillog on attempts to send myself email: dbmysql.c,db_query: query [INSERT INTO messages (mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT '1', physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, '365477ce9c4bbd5b8576e7b1818e5298', status FROM messages WHERE message_idnr = '6'] failed dbmysql.c,db_query: mysql_real_query failed: Not unique table/alias: 'messages' and mail is never getting delivered. I tried this with both the most recent cvs version and 2.0rc4. I'm using a Fedora-based version of linux and MySQL: mysql-3.23.58-9. I configured the database with innoDB but I get the same problem without it. I'm pretty new to MySQL configuration. Do I possibly have something set up inappropriately? Can anyone give me a hint as to what's going wrong? cgf
