[imp] VFS attachments not working

[Son Truong]

Hello,

In my continuing search for documentation on how to use the VFS for
temporary storage of attachments I have shed some light and come
into some problems.

1 To use the SQL VFS you need a table within your horde database.
In horde/scripts/db, there is a vfs.sql script to create that table.

2 Edit the horde/config/horde.php making the appropriate changes:
$conf['vfs']['type'] = 'sql';
//$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['params'] = array();
$conf['vfs']['params']['phptype'] = 'mysql';
$conf['vfs']['params']['hostspec'] = 'mysql_server';
$conf['vfs']['params']['protocol'] = 'tcp';
$conf['vfs']['params']['username'] = 'horde';
$conf['vfs']['params']['password'] = '******';
$conf['vfs']['params']['database'] = 'horde';
$conf['vfs']['params']['table'] = 'horde_vfs';

3. Edit the horde/imp/config/conf.php making the change:
$conf['compose']['use_vfs'] = true;

Having reached this far and haven't found anything else to configure,
the attachments don't seem to work. When adding an attachment in a
compose window everything seems ok - a successful message is
displayed. But once the message gets sent - there is no attachment.
In IMP it never shows up and in another mail client the message shows
there is an attachment, but on opening (or saving) the attachment it is
empty.

Nothing ever gets stored in the horde_vfs table and a table called
horde_vfs_seq is created (with a single column called 'id' which is
filled with a number).

What else do I need to do to get this to work?

Can anyone help?

Thanks,
Son

PS. I am using HORDE 2.2.1, IMP 3.2.1 and PHP 4.3.1 on
Solaris 8 running MySQL 3.23.55.



Son Truong wrote:

> Hello,
>
> I have just installed Horde 2.2 and Imp 3.2 and wonder where I could
> find documentation with regards to the VFS, and in particular, how
> to set things up so that when sending attachments from a Webmail system
> set up with multiple front-ends, the temporary files are stored in a mysql
> database as suggested below.
>
> Any pointers would be greatfully appreciated.
>
> On 03/11/2002 Jan Schneider wrote:
>
> > Zitat von Steven Premeau <premeau at uwp.edu>:
> >
> > >     One gotcha that we haven't solved.  If a user attaches a file to a
> > > message composition and then "dawdles" before sending the message (by
> > > editing the composition or just delaying) we have had the system change
> > > "front-end" hosts during that delay -- because the attached files are
> > > placed in /tmp during composition, they are not shared between machines
> > > and you get lots of errors when the system goes looking for them.
> >
> > You should try out the VFS (virtual file system) that just was merged to the
> > RELENG_* branches in CVS. It let's you store attachments on a central DB server.
> >
> > Jan.
> >
> > --
> > http://www.horde.org - The Horde Project
> > http://www.ammma.de - discover your knowledge
> > http://www.tip4all.de - Deine private Tippgemeinschaft
> >
> > --
> > IMP mailing list
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>
> --
> Son V Truong * Systems Programmer
> IT Services * University of St Andrews
> svt at st-andrews.ac.uk * 01334 462373
>
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org

--
Son V Truong * Systems Programmer
IT Services * University of St Andrews
svt at st-andrews.ac.uk * 01334 462373