Versions Compared

Old Version 17

changes.mady.by.user Branden Maynes (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Alanna Connolly (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Server: the name of the instance of SQL Server installed on the service, will be pre-filled from the previous page
  • Database: the name of the database you want to create in SQL Server
  • Authentication: the Active Directory option can be chosen for those SQL installs that don’t have any explicit accounts, as long the account of the person installing has access to create databases within SQL Server
  • Username prefix: palCentre relies on 3 three SQL logins.  So that you can conform to your own naming standards, palCentre asks for a prefix to use for these logins.  The default is palCentre. This will create logins palCentre_dbo, palCentre_user and palCentre_reader.  You can use any prefix you like which would result in a valid SQL login.
  • Owner password, User password and Reader password:  you may use the same password for all 3 three logins or different passwords.  For higher security we recommend using a different password for each SQL login.  For each login, there is a password and confirm password textbox.  Note that these passwords are encrypted before being saved in the configuration file, ensuring your password security.  Make a note of these passwords because you will need to use them again in the ‘Client Configuration Wizard’.  Ordinary users will never need to use or know these passwords.
  • Database path: this is the path on the SQL Server (not on the client machine) where the database .MDF and .LDF files will be created.  The default is C:\ePPOCPCOC\ but you will probably have a specific folder where SQL Database files are kept. This path must already exist to correctly work.

...

Info

palCentre will use the built-in database create SQL scripts and the database administrator login details provided on the previous step to connect to the SQL Server and create the palCentre database. 

Steps palCentre uses to create and configure the database

The database is created and configured in 3 steps:

  1. Create database and SQL logins - This is the step that is most likely to have an issue (such as the ones described below).  If it fails, the most likely outcome is that the database won’t be created in SQL Server. However, you should check in SQL Server to see if any part of the database or logins were processed
  2. CREATE TABLE IF NOT EXISTSs and database users - Creates the data structures of the palCentre database.  If this first step succeeded it is highly unlikely there will be any problems with this step.  It also creates the users with database-level roles based on the logins created by the previous step
  3. Create records - Populates the tables created in the previous step with structural records (constants, status lookups, and PCOC/PACOP code sets)

Potential Errors when trying to create and configure the database

If there were any problems with the data you entered, or with executing the database create scripts, the items which caused the problem will be highlighted and/or an appropriate error message will be displayed.  A few errors you may encounter here:

  • Not entering matching passwords for dbo, user, and reader SQL logins - palCentre will catch this error, highlight the problem items and display an appropriate error

  • Entering a database path that does not exist - If the path you enter in ‘Database path’ doesn’t exist, the create database script will ‘fail’ cleanly and report an error message.  If it reports this error, correct the database path and try again

  • Entering a ‘user prefix’ that results in illegal login names - If your prefix contained an illegal character, the create database script will again ‘fail’ cleanly and report an error message.  If it reports this error, correct the user prefix and try again

If you successfully created the database

If the create and configure step was successful, a message will be displayed indicating success and you will be moved to the next step.  You should also check that the database and SQL logins were created in SQL Server and that the .MDF and .LDF files were written to the expected location. 


If you see any problems in SQL Server, you should manually delete the database and logins in SQL Server, click Previous on the Wizard, and try again.

...

STEP 4:    Database Connection

Image RemovedImage Added

When using the Database Configuration Wizard this step is very simple.  You have already told the system the server, database name and user prefix so palCentre has all the information it needs to connect to the database.  The only additional information you will need to provide is:

...

STEP 5:    Proxy Settings

PCOC does and PACOP do not require the proxy settings to be used so click Next on this screen.

...

STEP 6:    Administrator Account

Image RemovedImage Added

You now have created a working palCentre database, and configured the connection to that database. Now you need to create an account with Administrator privileges. Later you will be able to use this user account to create other user accounts. On this screen you are required to provide a name, username, email address and password/confirm password.

...

The following box will appear. Click on OK.



STEP 7:    Facility

Image RemovedImage Added

In palCentre, all patient data belongs to a Facility.  In most cases an palCentre database will only be used to manage one facility, however the system supports multiple Facilities being used by a single database. Consequently, it is essential to create the first facility before any patient data can be entered.  The facility record includes a facility name, a unique 4 digit facility identifier supplied by PCOC or PACOP.


As part of your installation email, you should have received an email with your site specific details below. If you did not receive this, please contact us at pcoc@uow.edu.au (for PCOC) or pacop-data@uow.edu.au (for PACOP).

Field

Value

Facility Name

Your Facility Name

Facility Identifier

XXXX

...

Tip

Congratulations, you have completed the Database Setup Wizard. 

An XML file called palcentre.config will be created in the folder you specified during the install procedure (the default is C:\palCentre\). That file is very important. It should be backed up and we ask services to send it to us so that we can also keep it on our secured server. Please send this configuration file to pcoc@uow.edu.au (for PCOC) or pacop-data@uow.edyu.au (for PACOP).  The Database Configure Wizard only needs to be run once to create and configure the palCentre database.  After this has been run, all palCentre clients can be configured pasting the palcentre.config file in the C:\palCentre\ folder.

...