Sommaire >
Mise en place >
Installation >
How to setupHow to setup
(En français: Mise en place > Installation > Serveur)Santia version 2 is a web application, for browser. Chrome browser is recommended (Microsoft Internet Explorer works badly).
If you have a reliable Internet connection, the easiest way to use Santia is 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 Chrome remote desktop: see
Assistance.
After the setup, the users access to Santia in a browser at http://{server IP address}/santia/index.html, for example http://192.168.1.100/santia/index.html. From the server (or standalone computer), the address is http://localhost/santia/index.html, or http://127.0.0.1/santia/index.html if it does'nt work.
Which server? For 5 users and less than 5000 patient files, a server with a 4 cores CPU, 8 Gb of RAM, 200 Gb of storage is enough. But a second hard-drive is usefull to backup the database for safety. In case of frequent power shutdowns in some countries, the server should be powered by an UPS with battery, to reduce the unexpected stops which may corrupt the data. If the server is connected to Internet, it can periodically send a backup of the database, restorable even if the server becomes out of order.
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. Santia download
Download the file
santia2.zip on santia.org, and uncompress it.
3. Apache, PHP et MySQL
Download
XAMPP for Windows version 7.4.33 (around 147 Mb). Beware, if your server runs Windows XP, download
the prior version 1.8.2.
Run the downloaded file (ex xampp-windows-x64-7.4.33-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, replace localhost by the server IP address followed by :80 (or :8080 if modified above), ex: Servername 192.168.1.100:80, change LogLevel warn to LogLevel emerg, add # in front of ErrorLog "logs/error.log" and in front of CustomLog "logs/access.log" combined, save.
- select PHP (php.ini): at the line max_execution_time=..., type max_execution_time=300, change log_errors=On to log_errors=Off, 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:
-- click on Config, select my.ini, replace the content by copy/paste of the content of file my.ini located in the folder Santia (cf point 2), Save. (The extension .ini may be hidden by Windows).
-- 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 Stop if MySQL is running) click on Service (red cross) and confirm the setup of the service MySQL (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.
4. Santia setup
In c:\xampp\htdocs, create the folder santia and the subfolder santia/export.
Copy in santia folder the content of santia2.zip uncompressed (cf point 2).
Double-click on the file c:\xampp\htdocs\santia\install_database.bat, confirm the execution and follow the instructions.
Login to Santia in a browser (cf above) with the user administrator, go to Paramètres > Utilisateurs et droits, click on Enregistrer for each user, even with no modification (but a password must be entered for whose is missing).
5. 7zip
Download and install
7Zip, a free tool for compressing/uncompressing files having Zip format. The backup of Santia version 2 uses it.
6. Sheduled backup
We schedule a daily task in Windows which backups the last 30 days. Each backup file has the day number 1-31. The file is saved in several copies and it is also sent to the online free backup storage DriveHQ which is useful in case of breakdown, theft or ransomware on the server. Start by creating a free account on
http://drivehq.com.
Edit the file c:\xampp\htdocs\santia\sauvegarde_script.bat by a right click > Modify:
Replace {mot_de_passe_fichier} by the password you choose to protect the backup file. It must be different from the DriveHQ password. The password must be strong. If not, the data can be intercepted during the sending.
Replace {utilisateur_drivehq} by your DriveHQ username.
Replace {mot_de_passe_drivehq} by your DriveHQ password.
Replace {chemin_sauvegarde_1} by the main folder when the backup will be saved (ex c:\santia_backup_1\) et {chemin_sauvegarde_2} and {chemin_sauvegarde_2} by the other folders where it will be saved too (ex f:\santia_backup_2\).
If folder 3 is not used, we must copy there the same name than folder 2.
The folder path must end by \.
In the case of an old Windows version, replace program files (x86)\ by program files\, in the 2 lines, if it is the folder where 7-zip is installed.
In Windows Configuration panel > Scheduled tasks:
Create a daily task which executes c:\xampp\htdocs\santia\sauvegarde_script.bat, out of the working hours on Santia (ex at 3 am).
The online backup files can be accessed at
http://drivehq.com/file If Windows 10:
-- Modify the parameters of UAC: level 3 "Warn me only if applications try to..".
-- Windows Parameters > Security Parameters > Local strategies > Security options:
- User Account Control: Admin Approval Mode for the Built-in Administrator account: clic, Enabled, Apply, Ok
- User Account Control: Run all administrators in Admin Approval Mode: clic, Enabled, Apply, Ok
- User Account Control: Allow UIAccess applications to prompt for elevation without using the secure desktop: clic, Enabled, Apply, Ok
7. 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, disconnect 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/5.6/5.7 & PHP 7.2/7.3, under MS Windows XP/7/8/10/Server & Linux
- Windows XP supports only until the version 5 of PHP
