Difference between revisions of "Network installation"
From ECHSA Congenital Database
Jump to navigationJump to searchLine 13: | Line 13: | ||
#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: | + | #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> |
#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 |
Revision as of 19:15, 23 September 2005
Network installation overview
See article Network installation overview
PostgreSQL network installation
- Install and run the PostgreSQL server. Installation instructions can be found at http://www.postgresql.org
- Download following SQL scripts:
- 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 JDBC driver
- 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
- 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
.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:
- 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=...".