Difference between revisions of "Database and Server Set Up"

Revision as of 11:56, 25 April 2012

Overview

There are 4 elements to the AquilaCRS application:

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

Web Services URL

AquilaCRS uses some web services for accessing updated data items (e.g. drop down list contents) & for registering iBID systems. These services are hosted on www.BIBID.org.uk which needs allowing on your firewall/proxy server in order to prevent system failures.

Database Installation

AquilaCRS supports any of the following database systems:

• MS SQL Server 2005 or later
• MySQL 5.0 or later
• Interbase 6 or later
• Firebird 1.5 or later
• Oracle 10 or later

Installation of the database is essentially down to your database team creating the database using the script or backup file available for us as part of your contract. If you need assistance please create a new support ticket on our helpdesk.

Once the database has been created, you need to create a user for the application server to access the database.

Application Server Installation

There are two choices of installation for the application server:

• Windows service
• IIS web server

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 appropriate 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 their respective program folders.

Client App Installation

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