Connect database server setup

Install PostgreSQL on a server

Your server needs PostgreSQL installed to host a Connect data repository.

Download and install PostgreSQL on your server. Make sure to allow network connections to the database installation.

To download PostgreSQL, visit postgresql.org/download.
We also have a direct link to the PostgreSQL Windows installer.

Create a Connect configuration database

Before you can start setting things up, you’ll need to have the PostgreSQL server up and running. You also need to know the user name (most likely “postgres”) and the password of the administrator user for this server.

When that’s done, you’ll need to set up a local database configuration file. This is only needed one time per computer. The database configuration setup tool is invoked the first time you start Connect Admin.

No config database error dialog

End users will also see this dialog the first time they start Connect Browser, and they need to be provided the hostname or IP address for the database server, as well as the password needed to access the configuration database that you are now going to create.

Enter config database dialog

The picture above is what you should see when pressing “Setup”. Click “File” and “New” to create a configuration database. You will then see the dialog shown below:

Create a new Connect configuration database

Enter the hostname or IP address for the PostgreSQL server, and passwords.
We recommend a strong password for the administrator and one that is easier to remember for the reader password.

Then click “Create” and enter the PostgreSQL server admin user name and password, and hit “Continue”. You will see a log window showing you the progress, while the database setup tool is creating a configuration database named “connectconfig”. It should end by stating “Completed, with no errors.” Close the log window when the process is complete.

Now select “Edit” and “Copy to local setup”. This will save you some typing as the needed values are copied to the window dealing with the local configuration file. Select “File” and “Close”. Now click “Save and exit”. If that went well, you are now ready to start the Connect Admin application.

Create a Connect data repository

Start MUST Connect Admin. Granted that you completed the “Create a Connect configuration database” part of this documentation you will be greeted with the following window (without content):

Connect database and user administration window

To create a Connect data repository, enter appropriate information in each column, and select “File” and “Save”. Then right-click on the same row and select “Create”. The database authentication window shown below will then appear. Again, enter you administrator user name and password for the PostgreSQL server.

After doing that, click “Create”. A new log window will appear and show you the progress.

Resave the setup by selecting “File” and “Save”.

Create user accounts

You’ll now need to create end user logins for the Connect Browser application: You create users by right clicking on the row associated with the database you wish to create that user for. Right-click on the first row in the first table, and select “Add user”. The below is what you’ll see then:

Add/modify user dialog

Learn more about commit access levels in Connect.

Now click “Save”, repeat if wanted and save changes before you exit the Connect Admin application.

Import a license

You should now import your Connect site license provided to you by your reseller. To do this, select “Help” and “View license” from the menu and press “Load new license”. Locate and open your license file. The license file name usually ends with “.connectlicense”.

Success

You are now ready to start using the Connect Browser application.


Watch the screencasts for this section.