physical new subfolder

[dhaoui.walid]

Where Open-xcheange created the physical folder? ( for example when I create sub infostore where open-xchange create this folder in hard disk )?

thank you

[Martin Heiland]

Hi,

folders are created in the database. All "meta-data" is stored there and referenced to the physical filestore which is configured. For example:

select * from infostore WHERE cid=1 AND id=138 \G;
          cid: 1
           id: 138
    folder_id: 28
      version: 1
 locked_until: NULL
  color_label: 0
creating_date: 1181060708441
last_modified: 1181060708441
   created_by: 3
   changed_by: 3
1 row in set (0.00 sec)

                 
select * from infostore_document WHERE cid=1 AND infostore_id=138 \G;
		 cid: 1
        infostore_id: 138
      version_number: 0
       creating_date: 1181060708441
       last_modified: 1181060708441
          created_by: 3
          changed_by: 3
               title: geek_holidays_unescaped.ics
                 url: 
         description: 
          categories: 
            filename: NULL
 file_store_location: NULL
           file_size: 0
       file_mimetype: NULL
         file_md5sum: NULL
file_version_comment: 
1 row in set (0.00 sec)

The files are placed to the filestore e.g. at /var/opt/filestore/

ls -laR /var/opt/filestore/
/var/opt/filestore/1_ctx_store/:
total 18
drwx--x--x 3 open-xchange open-xchange 4096 2007-06-28 17:50 .
drwx------ 1 open-xchange open-xchange  512 2007-06-28 17:18 ..
drwx--x--x 7 open-xchange open-xchange 4096 2007-06-05 18:52 00
-rw------- 1 open-xchange open-xchange 9681 2007-06-28 17:24 state

/var/opt/filestore/1_ctx_store/00:
total 28
drwx--x--x 7 open-xchange open-xchange 4096 2007-06-05 18:52 .
drwx--x--x 3 open-xchange open-xchange 4096 2007-06-28 17:50 ..
drwx--x--x 2 open-xchange open-xchange 4096 2007-06-28 17:24 00
drwxr-xr-x 2 open-xchange open-xchange 4096 2007-06-25 08:45 01
drwxr-xr-x 2 open-xchange open-xchange 4096 2007-06-25 16:03 02
drwxr-xr-x 2 open-xchange open-xchange 4096 2007-06-25 14:43 03
drwxr-xr-x 2 open-xchange open-xchange 4096 2007-06-25 16:40 04

/var/opt/filestore/1_ctx_store/00/00:
total 39725
drwx--x--x 2 open-xchange open-xchange    4096 2007-06-28 17:24 .
drwx--x--x 7 open-xchange open-xchange    4096 2007-06-05 18:52 ..
-rw------- 1 open-xchange open-xchange 1482879 2007-05-03 13:56 00
-rw------- 1 open-xchange open-xchange  288578 2007-05-03 14:31 01
-rw------- 1 open-xchange open-xchange 3891712 2007-05-07 10:39 02
-rw------- 1 open-xchange open-xchange   90819 2007-05-07 13:41 03
-rw------- 1 open-xchange open-xchange   92443 2007-05-07 13:42 04

Where the last listed directory shows the "real" files.

[dhaoui.walid]

ok Thank you very much