[imp] IMP 6.1.0 and big attachments

Anna Christina Naß acn at annachristina.eu
Wed Jun 5 09:18:13 UTC 2013


Hallo,

I just have upgraded to horde 5.1.0 and imp 6.1.0 using "pear upgrade  
-a -B -c horde".

I have updated my backends.local.php to the new settings for spam and  
autocreate_special.

Now I got an e-mail containing many images (it is about 8 MB in size)  
that I wanted to forward to someone.

But when clicking on "Send" in the compose window, I only got "unable  
to load SQL data".

Until now I used the "SQL" VFS driver.

The DEBUG output of my horde.log looks like:

----snip----
2013-06-05T10:56:44+02:00 DEBUG: HORDE Load config file (conf.php;  
app: horde) [pid 2172 on line 401 of "/usr/share/php/Horde.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE Horde_Registry: retrieved app  
with cache ID  
horde_registry|app|1370420262|7402c06b537ecfcc610bd563dfec4c6d [pid  
2172 on line 1987 of "/usr/share/php/Horde/Registry.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE [imp] Load config file  
(conf.php; app: imp) [pid 2172 on line 401 of  
"/usr/share/php/Horde.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE [imp] SQL  (0,0004s)
         SELECT vfs_data FROM horde_vfs WHERE vfs_path = '.horde/imp/compose'
           AND vfs_name = '51aefd3b-c3f0-43f1-9435-088058c66b48' [pid  
2172 on line 558 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE [imp] Unable to load SQL data.  
[pid 2172 on line 27 of  
"/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE [imp] SQL  (0,0004s)
         SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
           alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
           FROM horde_alarms WHERE alarm_dismissed = 0 AND  
((alarm_snooze IS NULL
           AND alarm_start <= '2013-06-05T08:56:44') OR alarm_snooze <=
           '2013-06-05T08:56:44') AND (alarm_end IS NULL OR alarm_end >=
           '2013-06-05T08:56:44') AND (alarm_uid IS NULL OR alarm_uid = '' OR
           alarm_uid = 'acn') ORDER BY alarm_start, alarm_end [pid  
2172 on line 558 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-06-05T10:56:44+02:00 DEBUG: HORDE [imp] Max memory usage: 4456448  
bytes [pid 2172 on line 559 of "/usr/share/php/Horde/Registry.php"]
----snip----

Then I changed the VFS settings to "file system" and created a directory
/var/spool/hordevfs
and chowned it to www-data:www-data.

Then I tried to forward this message again -- but without luck:

----snip----
2013-06-05T11:05:35+02:00 DEBUG: HORDE Load config file (conf.php;  
app: horde) [pid 2587 on line 401 of "/usr/share/php/Horde.php"]
2013-06-05T11:05:35+02:00 DEBUG: HORDE Horde_Registry: retrieved app  
with cache ID  
horde_registry|app|1370420262|8e4e05158ec2ccb99e0bc7c46fd311d9 [pid  
2587 on line 1987 of "/usr/share/php/Horde/Registry.php"]
2013-06-05T11:05:35+02:00 DEBUG: HORDE [imp] Load config file  
(conf.php; app: imp) [pid 2587 on line 401 of  
"/usr/share/php/Horde.php"]
2013-06-05T11:05:35+02:00 DEBUG: HORDE [imp] Unable to open VFS file.  
[pid 2587 on line 27 of  
"/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
2013-06-05T11:05:35+02:00 DEBUG: HORDE [imp] SQL  (0,0003s)
         SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
           alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
           FROM horde_alarms WHERE alarm_dismissed = 0 AND  
((alarm_snooze IS NULL
           AND alarm_start <= '2013-06-05T09:05:35') OR alarm_snooze <=
           '2013-06-05T09:05:35') AND (alarm_end IS NULL OR alarm_end >=
           '2013-06-05T09:05:35') AND (alarm_uid IS NULL OR alarm_uid = '' OR
           alarm_uid = 'acn') ORDER BY alarm_start, alarm_end [pid  
2587 on line 558 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
2013-06-05T11:05:35+02:00 DEBUG: HORDE [imp] Max memory usage: 3932160  
bytes [pid 2587 on line 559 of "/usr/share/php/Horde/Registry.php"]
----snip----

When I look into this folder using "ls -lRa", I find the following files:

----snip----
./.horde/imp/attachments/<username>:
total 16908
drwxr-xr-x 2 www-data www-data    4096 Jun  5 11:04 .
drwxr-xr-x 3 www-data www-data    4096 Jun  5 11:02 ..
-rw-r--r-- 1 www-data www-data 8647621 Jun  5 11:02  
51aefeb7-1488-4299-b2fb-095958c66b48
-rw-r--r-- 1 www-data www-data 8647621 Jun  5 11:04  
51aeff0f-e6c4-4245-8724-09c158c66b48
-rw-r--r-- 1 www-data www-data     221 Jun  5 11:04 metadata
----snip----

What am I doing wrong?

Thank you in advance!

Kind regards,
Anna Christina Naß


More information about the imp mailing list