logo santiaDocumentation 05/02/2019 (no full english version) En PDF (283Ko)
menu accueil

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

Mise en place
....How to setup
..Reprise de l'existant



..Menu général
....RDV manqués
....Education thérapeutique (ETP)
....Rapports prédéfinis.New
..Aspects spécifiques
....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
..Restauration d’une sauvegarde



..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.

If you have a reliable Internet connection, the easiest is to use Santia online: you have nothing to setup. Contact us to host your database: Généralités > Contact, information légale.

If you don't have a reliable Internet connection, Santia can be used offline, on a standalone computer or in a local network with a server.

We can do the setup on your computer or server, remotely with the software TeamViewer: contact us Généralités > Contact, information légale.

After the setup, the user accesses to Santia in a browser at http://{server IP address}/santia/index.html, for example From the server (or standalone computer), the address is http://localhost/santia/index.html, or if it does'nt work.

If you want to manually setup a server or standalone computer, follow the below instructions for Windows:

1. Backup and stop version 1
If Santia version 1 has been used on the server, backup the database and stop definitely to use Santia version 1:
do a backup of the database manually cf Maintenance, dépannage > Sauvegarde manuelle.
uninstall MySQL 4.1: Windows Start > All the programs > Control Panel > Programs: in the list, double-click on MySQL Server 4.1, confirm uninstall.

2. Apache, PHP et MySQL
Download XAMPP for Windows version 7.2.11 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.11-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
In case of warning message "Windows Firewall has blocked some features of Apache HTTP server", check Private networks, uncheck Public networks, click Allow access
Uncheck Do you want to start the Control panel now, Finish
In Windows Start > All the programs > Control Panel > Firewall:
Advanced settings > Inbound rules > New rule
Select Port, Next
Select TCP, enter 3306 in Specific local ports, Next
Select Allow the connection, Next
Check Domain & Private, uncheck Public, Next
Enter Name: "mysql santia", Finish
In Windows Start > All the programs > XAMPP > XAMPP Control Panel, right-click > Run as administrator > Yes:
Select English (the program restarts)
In case of red error message "Problem detected! Port 443..", click Config in the top right corner > Service and port settings > Apache: Main port: replace 80 by 8080, SSL port: replace 443 by 4433, Save.
In the Apache row:
-- click on Config:
- In case of network setup (not in case of standalone setup), select Apache (httpd.conf): at the line Servername, add the server IP address followed by :80 (or :8080 if modified above), ex: Servername, Save.
- select PHP (php.ini): at the line max_execution_time=..., type max_execution_time=300, save.
-- (click on Stop if Apache is running) click on Service (red cross) and confirm the setup of the service Apache (the red cross becomes a green check), then click on Start. If the Service box is grayed (no red cross), XAMPP must be run as administrator.
In the MySQL row:
-- if MySQL 4.1 or another old version has been uninstalled, the old MySQL service maybe still active. It is the case if the box Service has a green check. Click on it and confirm the uninstallation of the service. The green check becomes a red cross. (the uninstallation of the old service is required because it may points to an old execution path. An error message in red says "MySQL service detected with wrong path etc" when we click on Start). In the uninstallation of the old service fails, click Services > double-click on mysql in the list > click Stop & select Disabled for Type of start > Ok
-- click on Config:
- replace all the text by the content of the file c:\xampp\mysql\my-large.ini.
- at the line sql-mode=..., type sql-mode="NO_ENGINE_SUBSTITUTION". If this line is missing, add it under the line [mysqld].
- under the line [mysqld], add the line: log_bin_trust_function_creators=1
- add also the line: secure-file-priv="c:\\xampp\\htdocs\\santia\\export"
- delete the line skip-grant-tables if exists.
- save.
-- (click on Stop if MySQL is running) click on Service (red cross) and confirm the setup of the service Apache (the red cross becomes a green check), then click on Start. If the Service box is grayed (no red cross), XAMPP must be run as administrator.
-- after Start, if a red error message says "Problem detected! Port 3306 in use by..", check the rule of the port 3306 in the firewall, cf above.
In the top right corner, click on Config: Autostart of modules: Check Apache et MySQL, click on 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 folders c:\xampp\htdocs\santia and c:\xampp\htdocs\santia\export.
Download the file santia2.zip on santia.org, uncompress it and copy the content in c:\xampp\htdocs\santia.
In case of network setup (not in case of standalone setup), open the file c:\xampp\htdocs\santia\config_host.txt and type the server IP address. In case of a new modification of this file after the installation, deconnect from Santia on each computer, click on Reinitialize the session, then refresh/reload the page for the modification to take effect.
Double-click on the file c:\xampp\htdocs\santia\install_database.bat, confirm the execution and follow the instructions.

5. 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 by a right-click > Modify:
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\). Beware the folder path must end by \.
In case of an old Windows version, replace program files (x86)\ by program files\, in the 2 lines, if it's the folder where 7-zip is installed.
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

6. Multi-bases use
If you want to commute easily between several databases on a same serveur or standalone computer, for ex to centralize the databases of different sites:
Edit the file c:\xampp\htdocs\santia\config_database.txt replacing santia by the list of the databases names, separated by a space, in one same line. Ex: "Site1 Site2"
For each database, double-click on the file c:\xampp\htdocs\santia\install_database.bat, confirm the execution and follow the instructions, entering the name of the site's database (ex: Site1).
On each computer, deconnect from Santia, click on Reinitialize the session, then refresh/reload the page to see the modifications.

The setup is done.

More info:
- Santia version 2 has been tested with Chrome, with MySQL 5.5 et PHP 7.2, under MS Windows XP, 7 & 8, and under Linux
- Windows XP supports only until the version 5 of PHP