Difference between revisions of "Network installation"

From ECHSA Congenital Database
Jump to navigationJump to search
m (→‎PostgreSQL network installation: +version)
 
(27 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
{{manual-infobox}}
 
{{manual-infobox}}
 +
 +
''[[PostgreSQL network installation]] is recommended. See the [[PostgreSQL network installation|instructions]].''
  
 
[[Image:NetworkInstallationDeployment.png|thumb|160px|left|Network installation deployment diagram]]
 
[[Image:NetworkInstallationDeployment.png|thumb|160px|left|Network installation deployment diagram]]
  
−
==Overview==
+
If the application is to be used on many computers at the same time, additional tasks need to performed. Most importantly, the local database has to be installed separately. The application uses JDBC database connection, which allows it to use different database engines. The tested database engine is [[PostgreSQL]].
 +
 
 +
Both database engines are Open Source and can be used free of charge. If you want or need to run the database on different database engine, contact the [[software development team]] for more information.
  
−
The network installation is different from a single installation. In single installation, the database server and user interface are together. In network installation server and interface are separated.
+
The database server installation means, that one of the computers in the network is '''running all the time''' and it has the database engine (e.g. [[PostgreSQL]]) installed on it. When a user starts the [[ECHSA Database Software]], it connects to the database server and uses it to read and write data. The server does not have to be a special computer. Common PC with enough resources (RAM memory and disk space) can be used. It just has to be running when ECHSA Database Software is used.
  
−
You need probably a qualified personnel to install the database server. Currently, the PostgreSQL server is tested for use with DataCollectionSoftware. Once the server is installed, you can connect as many clients (user interfaces on different computers) as you wish. Please read on to learn about the installation.
+
The network installation is different from a single installation, where the database server and user interface are together. In a network installation, server and user's interface are separated.
  
 +
You will probably need a qualified personnel to install the database server. Currently, the [[PostgreSQL]] server is tested for use with [[ECHSA Database Software]]. Oracle and MS-SQL servers are not yet supported.
  
 +
Once the server is installed, you can connect as many clients (user interfaces on different computers) as you wish. Please read on to learn about the installation.
  
−
<div style="clear: both;">
 
 
==PostgreSQL network installation==
 
==PostgreSQL network installation==
  
−
#Install and run the PostgreSQL server. Installation instructions can be found at the [http://www.postgresql.org PostgreSQL website]. [[EACTS Database Software]] was tested with PostgreSQL 8.0.x.
+
''See the article [[PostgreSQL network installation]]''
−
#Download following SQL scripts:
 
−
#*[[media:pgsql_struct.sql|pgsql_struct.sql]]
 
−
#*[[media:pgsql_dict.sql|pgsql_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. Create a database user and give him privileges to read and write in all tables in the database.
 
−
#Download the [http://jdbc.postgresql.org/download/postgresql-8.0-310.jdbc3.jar JDBC driver]
 
−
#Copy the driver '''jar''' file into the <tt>lib/ext</tt> subdirectory of your Java JRE directory. For example: <pre>C:\Program Files\Java\jre1.5.0_02\lib\ext</pre>
 
−
#Download and run the latest version of the [[EACTS Database Software]]. When a dialog appears type in your hospital code 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==
 
  
−
*To configure another client, perform steps 6-8 from the instructions.
+
<!--
−
*As the server address give the IP adress (or a DNS name if appropiate) of the computer with running PostgreSQL server.
+
==Derby network installation==
−
*PostgreSQL server must be enabled to accept TCP/IP connections from network
+
Instructions are not yet available.
−
*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=...".
 
−
</div>
 
  
 
'''See also:'''
 
'''See also:'''
 
*[[Network installation/Older instructions]]
 
*[[Network installation/Older instructions]]
 +
 +
[[category:technical support]]

Latest revision as of 08:43, 21 July 2015

User's manual

Quickstart
Overview
Single user installation
Network installation
Database structure
Export to CSV

Data entry

Staff, Patients, Diagnoses, Non cardiac abnormalities, Admissions, Operations, Procedures

PostgreSQL network installation is recommended. See the instructions.

Network installation deployment diagram

If the application is to be used on many computers at the same time, additional tasks need to performed. Most importantly, the local database has to be installed separately. The application uses JDBC database connection, which allows it to use different database engines. The tested database engine is PostgreSQL.

Both database engines are Open Source and can be used free of charge. If you want or need to run the database on different database engine, contact the software development team for more information.

The database server installation means, that one of the computers in the network is running all the time and it has the database engine (e.g. PostgreSQL) installed on it. When a user starts the ECHSA Database Software, it connects to the database server and uses it to read and write data. The server does not have to be a special computer. Common PC with enough resources (RAM memory and disk space) can be used. It just has to be running when ECHSA Database Software is used.

The network installation is different from a single installation, where the database server and user interface are together. In a network installation, server and user's interface are separated.

You will probably need a qualified personnel to install the database server. Currently, the PostgreSQL server is tested for use with ECHSA Database Software. Oracle and MS-SQL servers are not yet supported.

Once the server is installed, you can connect as many clients (user interfaces on different computers) as you wish. Please read on to learn about the installation.

PostgreSQL network installation

See the article PostgreSQL network installation


See also:

Retrieved from "https://docs.echsacongenitaldb.org/index.php?title=Network_installation&oldid=2318"