| Line 1: |
| |
|
+ |
Process for Hooking Up AHP to Customer Databases
|
| |
|
+ |
by Brad Galla â last modified Jul 25, 2011 10:29 AM
|
| |
|
|
|
| |
|
+ |
This is a short guide that instructs how to take a database received from a customer and have anthillpro connect to it so that it can be used.
|
| |
|
+ |
RETRIEVE DATABASE
|
| |
|
|
|
| |
|
+ |
Have customer send fresh dump of database via FTP or Supportal Ticket
|
| |
|
+ |
Set up instance of Database's application with Database and prepare for usage (open any ports needed to connect; etc.)
|
| |
|
|
|
| |
|
+ |
|
| |
|
+ |
ASSEMBLE CONNECTION
|
| |
|
|
|
| |
|
+ |
Install the version of anthillpro server that matches the version they were using with their database
|
| |
|
+ |
One method for finding this is analyzing the DB_VERSION table in the database.
|
| |
|
+ |
Use derby as the installation database; we will change this afterwards
|
| |
|
+ |
Install an agent that matches that version of the server (if necessary).
|
| |
|
+ |
Download/obtain the driver for the database type that was being used and copy it to the %SERVER_HOME%\lib\ext directory
|
| |
|
+ |
For example, if using Oracle, you could be using http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html (ojdbc5.jar)
|
| |
|
+ |
Modify the %SERVER_HOME%\conf\server\installed.properties file with the following values:
|
| |
|
+ |
install.db.schema=null
|
| |
|
+ |
install.db.url=[[database's url connection string]]
|
| |
|
+ |
install.db.password=[[database user's password]]
|
| |
|
+ |
install.db.driver=[[database driver's terminology name]]
|
| |
|
+ |
Example for oracle: oracle.jdbc.driver.OracleDriver
|
| |
|
+ |
install.db.user=[[database user's username]]
|
| |
|
+ |
install.db.type=[[type of database installed]]
|
| |
|
+ |
Example for oracle: oracle
|
| |
|
+ |
Modify %SERVER_HOME%\conf\spring-server\base.xml file and change any occurrences of:
|
| |
|
+ |
url to [[database's url connection string]]
|
| |
|
+ |
username to [[database user's username]]
|
| |
|
+ |
password to [[database user's password]]
|
| |
|
+ |
Modify %SERVER_HOME%\conf\server\spy.properties file by changing line 42:
|
| |
|
+ |
realdriver=[[database driver's terminology name]]
|
| |
|
+ |
After making the modifications above, navigate to the anthill installer that you downloaded and extract the conf.zip archive somewhere where you can access the files contained inside it. Grab any *.xml files that pertain to the database type (subdirectory would be the database type...for example 'oracle' for Oracle) and place them in the %SERVER_HOME%\conf\sql directory.
|
| |
|
|
|
| |
|
+ |
|
| |
|
+ |
UPGRADE PROCEDURE
|
| |
|
|
|
| |
|
+ |
Place the database driver in the new anthill installer's lib\ext directory (create it if it doesn't exist) prior to running installation.
|
| |
|
+ |
Run the upgrade on the %SERVER_HOME% directory so that the old server gets upgraded.
|
| |
|
+ |
Start the upgraded server and proceed with the auto-agent upgrade through the UI to continue using anthillpro.
|
| |
|
|
|
| |
|
+ |
|
| |
|
|
|
| |
|
+ |
|
| |
|
+ |
CHANGES TO PROCEDURE
|
| |
|
+ |
If you should notice any errors listed in this procedure please immediately report them to bmg@urbancode.com citing a link to this page. Thanks.
|
