----
'''It is of the HIGHEST IMPORTANCE that you make a copy of your data before having installed the new version of the software for your data safety reasons. Please, use the data collection software menu: ECHSA Database tools -> Export data to CSV or XML (use compressed XML, which is a default) and save the exported file on another hard drive, pen drive, burn a CD etc.
'''
----
There are two different distribution packages:
* client software for cardiac surgery centers: [https://www-m2.magnum2.pl/cloud/index.php/s/sxnsgBbXgPPDaK6 ecdbc-cs-7.5.0.msi]
* client software for interventional cardiology centers: [https://www-m2.magnum2.pl/cloud/index.php/s/w4eBgHSsS4ezYdA ecdbc-ic-7.4.9.msi]

Quick User's Guide for interventional cardiology centers: [https://www-m2.magnum2.pl/cloud/index.php/s/7HeHJW36Pj9os2X quick_users_guide.pdf]

Download

2023-08-10T02:19:23Z

HubertCzobodzinski:

Download

2023-08-10T02:17:54Z

HubertCzobodzinski:

Download

2023-08-10T02:12:20Z

HubertCzobodzinski:

2017-03-19T22:31:58Z

HubertCzobodzinski:

#'''Server installation and configuration'''
##Go to the the [http://www.postgresql.org PostgreSQL website], install and run the PostgreSQL server. Installation instructions can be found there. ECHSA Database Software should work flawlessly with any 8.x or 9.x PostgreSQL version, but we reccomend to use latest available release.
##Download following SQL scripts (right-click and choose "Save target as"):
##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_struct.sql?root=ecbdc postgresql_struct.sql]
##*[http://www.eactscongenitaldb.org/viewcvs/*checkout*/ecdbc/trunk/pl/magnum2/ecdbc/database/sql/postgresql_dict.sql?root=ecbdc postgresql_dict.sql]
##Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.
##Configure your PostgreSQL server so it accepts connections from network. <br> The configuration file is named: <pre>postgresql.conf</pre>You need to add following line: <pre>listen_addresses = '*'</pre> Second file that needs to be modified is: <pre>pg_hba.conf</pre>You need to add a line: <pre>host all all 192.168.3.0/24 md5</pre> Change 192.168.3.0/24 into your own network block, in format of X.X.X.X/Y where X.X.X.X is address of your network and Y is the number of bits in your netmask. In this example, the network is 192.168.3.0 - 192.168.3.255.
##Ensure that your PostgreSQL server accepts connections from the network. Check your firewall settings. Stop and start the service if needed.
##Create a database user and give him privileges to read and write in all tables in the database.
#'''Client installation and configuration'''
##[[Download]] and run the latest version of the [[EACTS Database Software]]. When a dialog appears type in your hospital code (three capital letters) and choose the default database path.
##Go to the software preferences directory <pre>.EactsCongenitalDatabase</pre> located in the user home directory (please note the '''dot''' character at the beginning of the directory name). Edit the '''ecdbc.properties''' file and set two variables: '''dbdriver''' and '''dburl'''. The user name and the '''password''' are to be set inside the '''dburl''' variable. <pre>dbdriver=org.postgresql.Driver</pre> <pre>dburl=jdbc:postgresql://srv_addr/eacts?user=your_user&password=your_users_password</pre> Change '''srv_addr''' into your server's address (like 192.168.0.12 or server.myhospital.org), and give your user's name and password.

'''Notes'''

*You can perform more client installations and configure them in the same was as the first client.
*As the server address give the IP adress (or a DNS name if appropiate) of the computer with running PostgreSQL server.
*Proper TCP port (PostgreSQL's default is 5432) must be opened if the server is protected by a firewall
*'''dburl''' must be in one (perhaps very long) line, together with "?user=...&password=...".

[[category:technical support]]
[[Category:Instructions]]