You should use mysql-4.0.13 or better. Not sure that's causing you're
problem, but still it's required.
Christopher Faylor wrote:
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
