|
|
| Line 15: |
Line 15: |
| | ==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 (right-click and choose "Save target as"):
| |
| − | #*[[media:postgresql_struct.sql|postgresql_struct.sql]]
| |
| − | #*[[media:postgresql_dict.sql|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.
| |
| − | #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.
| |
| − | #Download the JDBC driver, pick JDBC3 for your version of PostgreSQL. For PostgreSQL 8.0 you can pick this: [http://jdbc.postgresql.org/download/postgresql-8.0-313.jdbc3.jar PostgreSQL 8.0 JDBC3 driver]. For other drivers, go to [http://jdbc.postgresql.org/download.html JDBC PostgreSQL drivers download] page.
| |
| − | #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'''
| |
| − | | |
| − | *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.
| |
| − | *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=...".
| |
| | | | |
| | ==Derby network installation== | | ==Derby network installation== |
| Line 44: |
Line 25: |
| | '''See also:''' | | '''See also:''' |
| | *[[Network installation/Older instructions]] | | *[[Network installation/Older instructions]] |
| | + | |
| | + | [[category:technical support]] |
Network installation deployment diagram
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 and Derby servers are tested for use with EACTS 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
Derby network installation
It is possible to perform a Derby database server network installation. Detailed instructions are not yet available.
See also:
