Difference between revisions of "Network installation"

From ECHSA Congenital Database
Jump to navigationJump to search
m
Line 1: Line 1:
 
{{manual-infobox}}
 
{{manual-infobox}}
 +
 +
[[Image:NetworkInstallationDeployment.png|thumb|320px|left|Network installation deployment diagram]]
  
 
==Overview==
 
==Overview==
Line 5: Line 7:
 
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 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.
  
−
[[Image:NetworkInstallationDeployment.png|thumb|Network installation deployment diagram]]
+
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.
 +
 
  
−
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.
 
  
 +
<div style="clear: both;">
 
==PostgreSQL network installation==
 
==PostgreSQL network installation==
  
Line 18: Line 21:
 
#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.
 
#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]
 
#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: <tt>C:\Program Files\Java\jre1.5.0_02\lib\ext</tt>
+
#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 DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.
 
#Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.
−
#Go to the software preferences directory
+
#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://server address/eacts?user=your_user&password=your_users_password</pre>
−
.EactsCongenitalDatabase
+
 
−
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.  
 
−
dbdriver=org.postgresql.Driver
 
−
dburl=jdbc:postgresql://server address/eacts?user=your_user&password=your_users_password
 
  
−
When you configure another client, you perform steps 5-8 from the instructions. In the server address give the IP adress (or a DNS name if appropiate) of computer with PostgreSQL server. Please note, that:
+
==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.
 
*PostgreSQL server must be enabled to accept TCP/IP connections from network
 
*PostgreSQL server must be enabled to accept TCP/IP connections from network
 
*Proper TCP port (PostgreSQL's default is 5432) must be opened if the server is protected by a firewall
 
*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=...".
 
*'''dburl''' must be in one (perhaps very long) line, together with "?user=...&password=...".
 +
</div>

Revision as of 19:48, 23 September 2005

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

Network installation deployment diagram

Overview

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.

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.


PostgreSQL network installation

  1. Install and run the PostgreSQL server. Installation instructions can be found at http://www.postgresql.org
  2. Download following SQL scripts:
  3. Create a database (for example with name "eacts") and connect to it. Run those two SQL scripts on this database.
  4. 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.
  5. Download the JDBC driver
  6. Copy the driver jar file into the lib/ext subdirectory of your Java JRE directory. For example: 
    C:\Program Files\Java\jre1.5.0_02\lib\ext
  7. Download and run the latest version of the DataCollectionSoftware. When a dialog appears type in your hospital code and choose the default database path.
  8. Go to the software preferences directory 
    .EactsCongenitalDatabase
    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. 
    dbdriver=org.postgresql.Driver
    dburl=jdbc:postgresql://server address/eacts?user=your_user&password=your_users_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.
  • PostgreSQL server must be enabled to accept TCP/IP connections from network
  • 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=...".
Retrieved from "https://docs.echsacongenitaldb.org/index.php?title=Network_installation&oldid=1357"