Prepare JOIN Database for Migration to Suite
Introduction
If you are upgrading from legacy JOIN 5.0 to the new Synergy SKY Management Suite you will want to migrate your database. This eases installation and setup by bringing over your previously configured rooms, rules, etc. By default JOIN database is not open to external connection. This page explains how to resolve that.
Synergy SKY Management Suite utilizes a PostgreSQL database structure. Not only does it improve the performance and reliability of the Synergy SKY products, but it improves the detection & processing of meetings. This database type stores historic meeting information that allows for better post-sales support as well as the ability for the family of products from Synergy SKY to communicate together in unison.
By default, PostgreSQL is installed with the following database connection details:
Port: 5432
Username: postgres
password: postgres
Database name: synergyskydb
The database username or password can be changed through the PostgreSQL administration console or any other preferred database management tool.
Prerequisites
| Previous JOIN 5.0 Installation |
Ensure your Windows server is running JOIN Version 5.x. If you are currently running an older version of JOIN(3.2, 4.0, 4.1), you must upgrade to JOIN 5.0. Current CONTROL/ANALYZE version does not matter.
This is typically located at http://localhost:555
Ensure that your Synergy SKY Suite server can reach port 5432 on your Windows server
|
Configuration Reference
Step-by-Step Guide
Opening connection to external networks
- Uncomment and Change the following lines to the value indicated below:
Note: To uncomment a line, you have to remove the '#' at the beginning of that line
- Browse to the folder: C:\SynergySKY\SynergySKYEnterpriseScheduling\pqsqldb
- Open the file ‘postgresql.conf’
- Line 59 uncomment & change to: listen_addresses = '*'
Note: Default is #listen_addresses = 'localhost'
- Save and close
- Open the file ‘pg_hba.conf‘
- Find Line 80
- Replace 127.0.0.1/32 with the IP Address and IP Address range that your servers reside in.
e.g. 192.168.10.0/24.
This will allow the PostgreSQL database to accept connections from addresses within the specified range.
Jump to...
