[gollem] Gollem and SQL backend

[Marco Pirovano]

Quoting Jan Schneider <jan at horde.org>:

> Zitat von Marco Pirovano <marco.pirovano at unibocconi.it>:
>
>> Hello,
>>
>> i'm testing gollem (head-2005-01-31) with horde 3.0.2.
>>
>> I would like to use as backend the "SQL server with home".
>> I've created the horde_vfs table and all seems ok: I can create folder and
>> upgrade files, but, i can do this both in my home directory and in the root
>> directory, and if i look in the mysql table i see:
>>
>> | vfs_id | vfs_type | vfs_path                            | vfs_name |
>> vfs_modified | vfs_owner | vfs_data
>> |     16 |        2 | /home/mpirovano at uni-bocconi.it      | test     |
>> 1107263467 |           |NULL |
>> |     20 |        2 | /home                               | prova    |
>> 1107265580 |           |NULL |
>>
>>
>> the vfs_owner field is empthy. Is this correct ?
>
> IIRC, yes. How does the server configuration in backends.php look like?
>
> Jan.

Jan,

this is my backend.php conf:

// This backend specifies a home directory and root directory in a SQL vfs.
$backends['sqlhome'] = array(
     'name' => 'SQL Server with home',
     'driver' => 'sql',
     'preferred' => '',
     'params' => array(
         // The SQL connection parameters. See horde/config/conf.php for
         // descriptions of each parameter.
         'phptype' => 'mysql',
         'hostspec' => 'localhost',
         'database' => 'horde_uni',
         'username' => 'horde',
         'password' => '*****',

         // The SQL table containing the VFS. See the horde/scripts/db
         // directory for examples.
         'table' => 'horde_vfs'
     ),
     'attributes' => array('type', 'name', 'download', 'modified', 'size',
'permission', 'owner', 'gr
oup'),
     'root' => '/home',
     'home' => '/home/' . Auth::getAuth(),
);

Is it ok ?

Ciao,
Marco

* Marco Pirovano
* Universita' Bocconi, Area Sistemi Informatici e Telematici
* Piazza Sraffa 11 - 20136 Milano
* Tel. +39-025836.3173  Fax. +39-025836.3160