Difference between revisions of "Database and Server Set Up"

Revision as of 14:28, 14 August 2012

Overview

There are 4 elements to the AquilaCRS application:

• Web Services
• Database
• Application Server
• Client (User) App

Please note that the only currently available download is for the demo version of iBID that runs standalone and does not include the server modules.

IMPORTANT note about automatic program updates

The AquilaCRS program is automatically updated on a regular basis based on user feedback, security patches and most importantly release of new field options. In order for the automatic updates to work the following must be adhered to:

• the AquilaCRS program files must be installed in a user-writeable folder.
• the URL of the automatic update web service must not be blocked. The domain name for the automatic update service is www.nbid.org.

Web Services URL

AquilaCRS uses some web services for accessing updated data items (e.g. drop down list contents), for registering iBID systems & for accessing automatic software updates. The following domains need adding to the whitelist on your firewall/proxy server in order to prevent system failures:

• www.BIBID.org.uk
• www.NBID.org

Database Installation

AquilaCRS supports any of the following database systems:

• MS SQL Server 2005 or later (preferred solution)
• MySQL 5.0 or later
• Interbase 6 or later
• Firebird 1.5 or later

Please contact us if you are intending on using any database server other than MS SQL Server.

Creation of the database is should be done by your database team who will create the database & populate it using the script or backup file provided by us as part of the installation files. If you need assistance with this please create a new support ticket on our helpdesk.

Once the database has been created, you will need to create a single database user so that the application server can access the database.

Application Server Installation

There are two choices of installation for the application server:

• Windows service (preferred)
• IIS web server using a WinCGI module

Both methods will operate successfully side-by-side, even on the same physical server. When to use which one depends on your requirements:

Windows service — AquilaServer.exe

for use in a LAN environment where clients will connect over TCP/IP and you can safely open a port on your servers firewall. This configuration provides the best performance. Installs via a wizard to "Program Files".

IIS web server module — AquilaWeb.exe

for use in WAN environments where clients need to access the database outside of the LAN. Installs to the cgi-bin (or scripts) folder of your IIS installation.

App Server Installation

1. Run the installer wizard to install the service.
   1. Open the correct port on your servers firewall. Defaults to 8099.
2. Edit the INI file to configure the database connection string
   1. The web server (aquilaweb.exe) settings filename is aquilaweb.ini.
   2. The lan server (aquilaserver.exe) settings filename is aquilaserver.ini.
   3. Both files are located in "Program Files" under a folder called "Evolution Healthcare Systems Ltd"

Client App Installation

The client application is installed per-user, so each user needs to install their own copy of the client software. The installation is a one-click installation. This is vital to allow standard user profiles the ability to receive automatic program updates.

1. Run the client app installation & start the app.
2. Click "Connection" and enter the address of your server.

If your server is located on a machine called SERVER01 and is running on port 8099, the Connection will be http://server01:8099/bin. (The client application uses the HTTP protocol to communicate with the server, hence the use of "http://" in the connection string).

To discuss any aspect of the installation please raise a ticket on our helpdesk system, or call 01964 503400.

1. Log in