[imp] imp.sql

[Johan Huldtgren]

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,  
'<20080304154101.15661fnztdxxxslc at domain.com>', 'reply',  
'user.name at domain.com', 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