After having turned on logging of sent mail in IMP recently I started
seeing these errors on horde.log
Mar 04 15:41:01 HORDE [error] [imp] DB Error: insufficient
permissions: INSERT INTO imp_sentmail (sentmail_id, sentmail_who,
sentmail_ts, sentmail_messageid, sentmail_action, sentmail_recipient,
sentmail_success) VALUES ('7', 'user', 1204663261,
'<[EMAIL PROTECTED]>', 'reply',
'[EMAIL PROTECTED]', 1) [nativecode=ERROR: permission denied for
relation imp_sentmail] [pid 77622 on line 85 of
"/path/to/horde/imp/lib/Sentmail/sql.php"]
Adding the necessary privileges to the horde DB user (in my case 'horde')
solved this.
I've attached a simple diff to imp/scripts/sql/imp.sql to fix this.
# diff -u imp.sql imp_fix.sql
--- imp.sql 2007-12-20 15:00:36.000000000 +0100
+++ imp_fix.sql 2008-03-06 16:56:39.000000000 +0100
@@ -15,3 +15,5 @@
CREATE INDEX sentmail_ts_idx ON imp_sentmail (sentmail_ts);
CREATE INDEX sentmail_who_idx ON imp_sentmail (sentmail_who);
CREATE INDEX sentmail_success_idx ON imp_sentmail (sentmail_success);
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON imp_sentmail TO horde;
.jh
--
IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [EMAIL PROTECTED]
