[imp] Problem with attachments and VFS

[Didi Rieder]

Quoting Didi Rieder <adrieder at sbox.tugraz.at>:

> 1.
> when I try to send a message with an attachment > 1Mb the recepient gets the
> message but the attachment is 0 Bytes in size.
> 
> I noticed that after uploading the file it doesn't get inserted in to the
> horde_vfs table, but horde debug tells me:
> 
> Feb 05 18:54:45 HORDE [debug] [imp] SQL Query by Horde_SQL::insertBlob():
> query
> = "INSERT INTO horde_vfs (vfs_id, vfs_type, vfs_path, vfs_name, vfs_modified,
> vfs_owner, vfs_data) VALUES (?, ?, ?, ?, ?, ?, ?)" [on line 129 of
> "/usr/local/apache/htdocs/cvs_dev/horde/lib/SQL.php"]
> 
> No message in apaches error_log.
> 
> from my php.ini
> memory_limit = 16M
> post_max_size = 8M
> pload_max_filesize = 8M
> 
> I'm using mysql-3.23.55-max with InnoDB

Ok, I found the solution!!

The maximum size of a BLOB or TEXT object is determined by its type, but the
largest value you can actually transmit between the client and server is
determined by the amount of available memory and the size of the communications
buffers.
Queries need to fit into one packet, and MySQL has a max packet limit that is
lower than the allowed length of some fields.

Therefore set max_allowed_packet in my.cnf to a value that fits for your
requirements, like:

set-variable    = max_allowed_packet=8M

Mayby that is something that should go into the FAQs.

Didi

p.s:

> 2.
> Even though I'm using vfs there are some impatt* files in my /tmp where do
> they
> come from?

Any idea here?


-- 
-------------------------
Didi Rieder
adrieder at sbox.tugraz.at
PGPKey ID: 3431D0B0
-------------------------