Difference between revisions of "Database and Server Set Up"

Revision as of 19:56, 24 September 2012

Overview

There are 3 steps to installing and setting up your iBID software:

• Create the Database
• Install the Application Server
• Run the BIBID Data Transfer and upload to the National Database

IMPORTANT PRE-REQUISITES

Automatic Program Updates

The AquilaCRS program is automatically updated on a regular basis for

• release of new field options
• security patches
• user requests
• bug fixes

In order for the automatic updates to work the following must be adhered to:

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

For more information on writeable folders that are shared between users, please read the Shared writeable folders.

Web Services

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:

1. www.NBID.org
2. www.BIBID.org.uk 

Database Installation

Download the IBID Server MSSQL Script zip file from www.ibidb.org in the IBID Software Downloads section. Unzip to access the database creation scripts

Create an empty SQL Server Database and ensure that there is a database user with which to access the database. For installation of the application server you will need to know the server name of your SQL server, database name, user name and password.

Using your tool of choice (usually MS SQL Server Management Studio) run the downloaded SQL scripts against the empty database to create the tables, views and to pre-populate the data.

Application Server Installation

Download the IBID Server Application Setup from www.ibidb.org in the IBID Software Downloads section.

1. Unzip the AquilaServer_setup file
2. Run the installer wizard.
3. Edit the Connection String parameter during the installation. Replace the items in italics with your own settings
   1. AnyDAC?AuxDriver=MSSQL;Server=SERVERNAME;Database=DATABASENAME;UserID=USERID;Password=PASSWORD;
4. Continue the installation wizard until complete.
5. Open the port 8099 on your servers firewall. (The port number is changeable if necessary)
   1. The settings filename is aquilaserver.ini.
6. Check services.msc to ensure that the AquilaServer service has been started and is set to Automatic.

Client Application Server URL

The Server URL is needed by all users of the IBID application on their first login, and is made up as follows:

http://SERVERNAME:PORTNUMBER/bin.

If the application server is installed on a server called TRUSTSRV01 and is listening on the default port, then your Server URL is http://trustsrv01:8099/bin

IBID Installation And Setup

1. Download the IBID User Application Setup from www.ibidb.org in the IBID Software Downloads section.
2. Run the installation program selecting Custom installation and ensure that you select the BIBID Import component.
3. Run the client application and log on with the username Admin and the password Adminabc123 (case sensitive) and the Server URL previously mentioned.
4. Go to the IBID Installation and Setup page.
5. Register your IBID System:
   1. Enter your IBID Unit ID and click Register. This will open IBID features in the software and also test connectivity to the National Database.
6. Perform the BIBID Import and transfer it to the National Database:
   1. Run the Step 1 of the BIBID Data Transfer which will Import from BIBID v1 (this may take several hours)
   2. When the BIBID Data Transfer is fully completed, run Step 2, Export database... (this should only take a few minutes)
   3. Zip the exported file and upload to the National Database via the upload facility at nww.mdsas.com/ibidupload (Maximum upload size 23Mb)

Note: the export and data transfer is a one-time requirement. All future updates will be transmitted in real-time from within the client application)

Client App Installation

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

1. Download the client application installation from www.ibidb.org/ibid
2. Unzip and run the ibid_install installation program.
3. Double click the IBID icon on your desktop to run the application
4. Click the Connection link and enter the Server URL previously mentioned.

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

See Also Log in