Difference between revisions of "Database and Server Set Up"
m (→App Server Installation) |
(Updated with change of instructions for BIBID Transfer) |
||
| Line 7: | Line 7: | ||
*Application Server | *Application Server | ||
*Client (User) App | *Client (User) App | ||
| − | |||
| − | |||
==IMPORTANT: Automatic Program Updates== | ==IMPORTANT: Automatic Program Updates== | ||
| Line 20: | Line 18: | ||
==Web Services URL== | ==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: | 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: | ||
*[http://www.bibid.org.uk www.BIBID.org.uk] | *[http://www.bibid.org.uk www.BIBID.org.uk] | ||
| Line 26: | Line 25: | ||
==Database Installation== | ==Database Installation== | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | ''' | + | '''Pre-requisite''': MS SQL Server 2005 or above. |
| + | |||
| + | Download the '''IBID Server MSSQL Script''' zip file from [http://www.ibidb.org 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== | + | ==Application Server Installation== |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | Download the '''IBID Server Application Setup''' from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section. | |
| − | ; | + | #Unzip the file. |
| − | + | #Run the installer wizard. | |
| − | + | #Edit the '''Connection String''' parameter during the installation. Replace the items in italics with your own settings | |
| − | + | ## AnyDAC?AuxDriver=MSSQL;Server=''SERVERNAME'';Database=''DATABASENAME'';UserID=''USERID'';Password=''PASSWORD''; | |
| + | #Continue the installation wizard until complete. | ||
| + | #Open the port 8099 on your servers firewall. (The port number is changeable if necessary) | ||
| + | ##The settings filename is aquilaserver.ini. | ||
| + | #Check ''services.msc'' to ensure that the AquilaServer service has been started and is set to Automatic. | ||
| − | == | + | ==IBID Installation And Setup== |
| − | + | Download and install '''IBID User Application Setup''' from [http://www.ibidb.org www.ibidb.org] in the ''IBID Software Downloads'' section. | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | Run the client application and log on using the following settings: | |
| − | + | *Username: admin | |
| − | * | + | *Password: adminabc123 (you will be required to change this during login) |
| − | + | ||
| − | + | Press F2 or click Connection and set server url as follows: | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | '' | + | *Server URL: http://''SERVERNAME'':8099/bin |
| − | + | Replacing SERVERNAME with the name of your application server. | |
| − | + | ||
| − | + | ||
| − | '' | + | Go to the '''IBID Installation and Setup''' page and follow instructions to: |
| − | + | ||
| − | + | ||
| − | + | #Register your Unit ID & database | |
| + | #Transfer your BIBID database | ||
| + | #Export your database | ||
| + | #Upload the exported file to the National Database | ||
==Client App Installation== | ==Client App Installation== | ||
Revision as of 16:02, 24 September 2012
This is a Technical Instructions topic
Contents
Overview
There are 4 elements to the AquilaCRS application:
- Web Services
- Database
- Application Server
- Client (User) App
IMPORTANT: 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.
For more information on writeable folders that are shared between users, please read the Shared writeable folders.
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:
Database Installation
Pre-requisite: MS SQL Server 2005 or above.
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.
- Unzip the file.
- Run the installer wizard.
- Edit the Connection String parameter during the installation. Replace the items in italics with your own settings
- AnyDAC?AuxDriver=MSSQL;Server=SERVERNAME;Database=DATABASENAME;UserID=USERID;Password=PASSWORD;
- Continue the installation wizard until complete.
- Open the port 8099 on your servers firewall. (The port number is changeable if necessary)
- The settings filename is aquilaserver.ini.
- Check services.msc to ensure that the AquilaServer service has been started and is set to Automatic.
IBID Installation And Setup
Download and install IBID User Application Setup from www.ibidb.org in the IBID Software Downloads section.
Run the client application and log on using the following settings:
- Username: admin
- Password: adminabc123 (you will be required to change this during login)
Press F2 or click Connection and set server url as follows:
- Server URL: http://SERVERNAME:8099/bin
Replacing SERVERNAME with the name of your application server.
Go to the IBID Installation and Setup page and follow instructions to:
- Register your Unit ID & database
- Transfer your BIBID database
- Export your database
- Upload the exported file to the National Database
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.
- Run the client app installation & start the app.
- 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.
