Home » Support » Documentation » Installation » Advanced Installation

Advanced Installation

1. MySQL Database setup

Note: there are scripts in [tomcat]/webapps/asset-bank/WEB-INF/manager-config/database to run the steps below: database-setup.cmd (Windows) and database-setup.sh (Linux).

1. 1.1) Create a new database. By default call it assetbank.
2. 1.2) Create a database user. By default call this application.
3. 1.3) Give the user ALL privileges on the database.
4. 1.4) Connect as root, and run the install-mysql.sql script from the installation database folder (it is also in [tomcat]/webapps/asset-bank/WEB-INF/manager-config/database).

2. SQLServer Database setup

1. 2.1) Create a new database login, with SQL Server Authentication. By default call this application. The following should all be UNchecked: Enforce password policy, Enforce password expiration, User must change password at next login.
2. 2.2) Create a new database, with Name=assetbank, and Owner=application. The application user should be owner since the Asset Bank updater function will run under this user to create and update tables. The database needs to use a case insensitive collation.
3. 2.3) Now connect to SQL Server using the application login, and run the install-sqlserver.sql script from the installation database folder.
4. 2.4) Note for SQL Server 2005, the following configuration steps should be done in SQL Server Configuration Manager to allow JDBC access:
   • SQL Server 2005 Services: Enable and start Sql Server Browser
   • Protocols: Enable TCP/IP protocol

3. Oracle Database setup

1. 3.1) Create a database user and schema. By default call this ASSETBANK
2. 3.2) Grant the user all system privileges including: select, insert, update, delete, create, drop.
3. 3.3) Run the install-oracle.sql script from the installation database folder.
4. Remember to commit!
5. For some Oracle client tools, errors may be generated due to the script comments, these can be ignored.

4. Database connection settings

Note: You should only attempt this step if you are familiar with editing XML, as incorrect commenting/uncommenting can cause the system to stop working.

1. 4.1) In the file [Tomcat]\webapps\asset-bank\WEB-INF\components.xconf, database configuration is towards the top of the file. Locate the <component> element relevant to the database you are using and ensure it is uncommented.
   Make sure that the other component elements are either commented out or removed from the file completely.
   For example if you are using MySQL the component preceeded by the comment <!-- MySQL Data Source --> should be uncommented.
   
   
2. 4.2) Inside the <component> element, update the following elements if necessary for access to your database:
   <dburl>, <user> and <password>.
   
   
3. 4.3) In the file [Tomcat]\webapps\asset-bank\WEB-INF\classes\ApplicationSettings.properties search for the property sql-generator-class and update its property to suit the database you installed (potential values for this property are detailed in a comment above the property itself).