logo santiaDocumentation 19/10/2018 (no full english version) En PDF (283Ko)
menu accueil
Avant-propos

Généralités
..En un mot
..Overview
..Configuration requise
..Questions courantes
..Visite guidée en suivant le circuit du patient
..Quelques fonctionnalités avancées
..Check-list
..Comparaison avec d'autres solutions
..Actualité, historique, déploiement
..Contact, information légale
..Participer au projet
..Acronymes

Mise en place
..Préparation
..Installation
....Serveur
....How to setup
..Paramétrage
....Listes
....Utilisateurs
..Reprise de l'existant

Formation

Démarrage

Utilisation
..Menu général
..Accueil
....RDV manqués
..Dossiers
....Fiche
....Social
....Médical
....PTME
....Education thérapeutique (ETP)
..Dispensation
..Laboratoire
..Pharmacie
..Dépistage
..Communauté
..Rapports.New
....Rapports prédéfinis.New
..Paramètres
....Listes
....Utilisateurs
....Application
....Maintenance
..Aspects spécifiques
....Observance
....Perdus de vue (PDV)
....File active
....Confidentialité des données, secret médical
....Copie/envoi de la base

Maintenance, dépannage
..Mises à jour
..Vérification de la sauvegarde
..Sauvegarde manuelle
..Sauvegarde automatique sous Linux.New
..Restauration d’une sauvegarde

Assistance

Suivi

Annexes
..Notes de version.New
..Stade CDC
..Indice Karnovsky
..Spécifications techniques
..Structure de la base de données
..Contrat de licence


Sommaire > Mise en place > Installation > How to setup


How to setup

(En français: Mise en place > Installation > Serveur)

Santia version 2 is a web application, for browser. There is nothing to setup on user’s side. In a browser, go to http://{server IP address}/santia/index.html, for exemple http://192.168.1.100/santia/index.html. All user must enter his name and password, filled in Settings > Users & grants.

On the server, the setup has several steps, described below for MS-Windows. A Linux server is fine too. This can be made by us, remotely, if you wish: contact us cf Généralités > Contact, information légale.

Santia version 2 has been tested for Chrome browser and MySQL version 5.5.

1. Backup and stop version 1
If Santia version 1 has been used on the server, do a backup of the database for safety, cf Maintenance, dépannage > Sauvegarde manuelle, and definitely stop using Santia version 1.

2. Apache, PHP et MySQL
Download XAMPP for Windows on the official website (around 120 Mb). Beware, if your server runs Windows XP, download the prior version 1.8.2.
Run the downloaded file (ex xampp-win32-7.2.8-0-VC15-installer.exe):
- "Select components": uncheck all except MySQL. Remain checked Apache, PHP et MySQL. Santia version 2 uses MySQL version 5.5 and up.
- "Installation folder": C:\xampp. Remain as is.
- Uncheck "Learn more about bitnami for xampp"
- Click "Finish"
- Run xampp-control.exe
In Windows Start > XAMPP > XAMPP Control Panel:
- In the Apache row:
- click the button Config:
- select Apache (httpd.conf): at the line Servername, add the server IP address followed by :80, ex: Servername 192.168.1.100:80, save.
- select PHP (php.ini): at the line max_execution_time=..., type max_execution_time=300, save.
- click the button Stop, click the button Service (red cross) and confirm the setup of the service Apache (the red cross becomes a green check), then click on Start
- In the MySQL row:
- click the button Config, at the line sql-mode=..., type sql-mode="NO_ENGINE_SUBSTITUTION", save. Delete the line skip-grant-tables if exists.
- click the button Stop, click the button Service (red cross) and confirm the setup of the service Apache (the red cross becomes a green check), then click on Start
- In the top right corner, click the button Config: Autostart of modules: Check Apache et MySQL, click Save.

3. 7zip
Download and install 7Zip, a free tool for compressing/uncompressing files having Zip format. The backup of Santia version 2 uses it.

4. Santia
Create the folder santia in C:\xampp\htdocs.
Download the file santia2.zip on santia.org and uncompress it in santia folder.
Open the file config_host.txt and type the server IP address.
Open the file config_database.txt and type the database name, santia by default.
Create the directory export in C:\xampp\htdocs\santia.

5. Database
- In Windows Search, type cmd: a black background window opens. Type the following commands, each line followed by [enter]
- If MySQL is installed in Program files, which is the case by default (contact us if several MySQL versions are installed):
cd program*
cd mysql*
cd mysql*
cd bin
- If, on the other hand, MySQL is installed in C:\MySQL:
cd mysql
cd bin
- If Santia version 1 has not been installed on the server:
mysql
create database santia;
quit
mysql santia < C:\xampp\htdocs\santia\base_defaut.sql
- Then (this command takes time if Santia version 1 has been used):
mysql santia < C:\xampp\htdocs\santia\update_sql
- In the following commands, replace {utilisateur} by the name of the user who manages Santia, and {mot_de_passe} by his/her password. Ex: grant all on santia.* to 'c_smith'@'%' identified by 'guKX37_w' with grant option;
mysql
grant all on santia.* to '{utilisateur}'@'%' identified by '{mot_de_passe}' with grant option;
grant all on mysql.user to '{utilisateur}'@'%' identified by '{mot_de_passe}' with grant option;
insert ignore santia.droi set desi='{utilisateur}',motp='{mot_de_passe}',accu=1,anal=1,deli=1,dossmedi=1,dossptme=1,dossobse=1,dossrens=1,dosssoci=1,droi=1,labo=1,para=1,phar=1,pharpara=1,comm=1,depi=1,oev_=1,dosspsy_=1;
quit
- NB: a firewall may block port 3306 used by MySQL. Add an exception in the firewall settings for this port, to allow the connection to MySQL.

6. Sheduled backup of version 2
The backup will be sheduled daily by Windows. Only the last 30 backups (ie days) are saved. A backup can be automatically sent to an email address, every week for instance.
Edit the file C:\xampp\htdocs\santia\sauvegarde_script.bat:
- Replace {mot_de_passe} by a password choosen to protect the backup when it is sent to an email address.
- Replace {chemin_sauvegarde_1} by the main folder where the backup must be saved (ex C:\santia_backup) and {chemin_sauvegarde_2} & {chemin_sauvegarde_2} by the secondary folders where a copy of the backup will be saved (ex F:\santia_backup).
Edit the file C:\xampp\htdocs\santia\sauvegarde_envoi.txt:
- Replace {email} by the email address recipient of the backup. The recipient will receive a link to download the file and will have to type the password set above. This service is free provided by dl.free.fr.
In Windows Configuration panel > Sheduled tasks:
- Create a daily task which executes C:\xampp\htdocs\santia\sauvegarde_script.bat
- Create a weekly task which executes C:\xampp\htdocs\santia\sauvegarde_envoi_script.bat

The setup is done.