Page 1 sur 1

Attachment folder / dossier pièces jointes

Publié : jeu. juil. 26, 2018 11:19 am
par Laton
Hi,
Releases notes of squashTM 1.8 states that attachments could be stored on drive:
- [PJ] Stockage des pièces jointes dans un répertoire extérieur à Squash

How to configure it? Where is the folder located?
I've parsed the various squashtest websites without being able to find this information..

Thank you for your support,

V.

Attachment folder / dossier pièces jointes

Publié : jeu. août 09, 2018 5:12 pm
par Yamina
Hello,

Here is how to proceed :
- Get the extract attachment tool on this [url=http://repo.squashtest.org/distribution ... ELEASE.zip]link[/url].

- Unzip the file and put it on squash-tm folder.

- Edit the extract-acttachment.bat
Example :
[color=#44bb00]REM DataBase parameters, should be the same that your squash tm db properties
REM DB_TYPE can be one of h2, mysql, postgresql[/color]
[color=#4400bb]set [/color]DB_TYPE=mysl
[color=#4400bb]set [/color]DB_URL=jdbc:mysql://localhost:3306/squashtm1180
[color=#4400bb]set [/color]DB_USERNAME=root
[color=#4400bb]set [/color]DB_PASSWORD=root

- Indicate the path to the folder where attachments will be extracted
Example :
[color=#44bb00]REM Path to the folder where attachments will be extracted[/color]
[color=#4400bb]set [/color]REPO_PATH=C:/squash-tm-1.18.0/squash-tm/Attachments

- Save et run the .bat file

- Your Attachment folder is in squash-tm folder

- Edit squash.tm.cfg.properties in conf folder :
[color=#44bb00]# Allow Squash Admin to activate the file repository, ie the storage of attachment directly in file system
# !!!! PLEASE READ THE DOCUMENTATION ABOUT THIS FEATURE BEFORE ACTIVATING IT !!![/color]
squashtm.feature.file.repository = [color=#4488ff]true[/color]
squash.path.file.repository = C:/squash-tm-1.18.0/squash-tm/Attachments

- Save and Open Squash. Here you are.

To finish, you can use vacuumlo or vaccumdb on your PostgreSQL Database or execute an « optimize table » if your squash is installed on MySQL.

Best Regards,
Yamina