Installing Aion Rule Manager 11.0 on SQL Server Express Edition
Article ID: 22316
Updated On:
Products
Issue/Introduction
Aion Rule Manager 11.0 has a special installation procedure, in particular with using a non-standard database system like Microsoft SQL Server 2005 / 2008 Express Edition. This document will provide the steps needed to accomplish this installation.
Environment
Component:
Resolution
SQL server requirements
The SQL server Native Client must be installed on the machine where Aion is being installed. The Installation executes sqlcmd to create and/or configure the SQL server database
From the Machine where the SQL server database is installed you need the following:
Windows and Database Authentication
You must be able to log on using both windows authentication and database authentication From Microsoft SQL server Management Studio, right mouse click on the database and select properties. Select the Security page within the Server Properties. Make sure that SQL Server and Windows Authentication mode is selected. You will want to logon with the Aion Rule Manager database user id created during installation.
<Please see attached file for image>
Enable Remote Servers
Make sure that Remote server connects are enabled for this machine. From the Server Properties page click on connections. Make sure that the Allow remote connections to this server is checked.
<Please see attached file for image>
Port Number Defined
Make sure that the port number is defined to SQL server. From the start menu select the SQL Server Configuration Manager tool. Expand SQL Server 2005 Network Configuration. Select Protocols for SQL server Name (SQLEXPRESS in my case) Make sure that TCP/IP is enabled. Right mouse click on TCP/IP and select IP Addresses. Make sure that the TCP Port is filled in for IP1, IP2, IP3, IP4 and IPALL. 1433 is the default. Make sure the TCP Port is filled in with the default or another port number. You will specify this port number during the Aion installation.
<Please see attached file for image>
Single Node Host Name or Alias
The SQL server Host name must be a single node. Aion Rule Manager cannot accept a multimode name such as machine name\SQLEXPRESS. To find out what has been defined, click on SQL server 2005 Services in the SQL Server Configuration Manager tool. Right mouse click on the SQL Server service and select properties.You should see a named instance of Host name (MYCOMP in the example below). If you don't see this you can set up an alias.
<Please see attached file for image>
To set up an Alias Select Aliases under SQL Native Client Configuration in the SQL server Configuration tool Enter the Alias Name. The Alias name must be a single node name such as AionRM. This and the port number must be specified at Aion Rule Manager Installation time. The server name was set up when you installed SQL server 2005.
<Please see attached file for image>
Installing Aion Rule Manager for the first time
At the introduction page, Click Next
Scroll to the bottom of the License Agreement Select I accept the terms of the License agreement and Click Next
Leave the Install folder as C:\Program Files\CA. The product will be installed into a folder called AionRM here.
<Please see attached file for image>
Select Typical and Click next
Aion RM database installation
Select Create Ca Aion Rule Manager Database and Click Next
<Please see attached file for image>
Leave the Data base type as Microsoft SQL Server
Leave the Database name as Aion Rule Manager Database
Leave the Username as rmdba.
Scroll to enter password information
Enter the password for rmdba. If rmdba is being created here, select create user and confirm password. Enter the password again.
<Please see attached file for image>
Enter the Hostname for the database. This is the SQL server named instance or the alias name.
Enter the port number
Enter an existing admin user id and password. This user id will be used to create the rmdba user id. Most SQL server systems have an admin user id of sa.
<Please see attached file for image>
You will get a message that the installation is verifying the sql server information. You will not progress in the install unless the SQL server information is correct.
EEM Installation
Select Install EEM and click Next
<Please see attached file for image>
Specify the password twice for EiamAdmin
<Please see attached file for image>
Scroll to enter Certificate information
<Please see attached file for image>
Enter the path and certificate name. If you leave it blank it will be .p12
Specify C:\AIONRM1 The certificate file aionrm1.p12 will be created in the c:\ directory.
Enter the certificate password.
Confirm the certificate password if the certificate is being created new.
Click Next
<Please see attached file for image>
Enter JBOSS information. Enter the directory that contains the conf directory (configuration files) If you installed JBOSS with all the defaults the directory will be
C:\Program Files\jboss-4.0.3SP1\server\default
Leave the port number as 8080
Leave the https port as 8443
Leave the RMI port as 1098
Leave the JDK directory as is. The installation got this information from the Java_Home environment variable.
Click Next
<Please see attached file for image>
For this install leave the Instance ID as 1 as only one Portal is using the Aion Rule Manger database.
Leave the library location as is.
Click Next
<Please see attached file for image>
Enter a user id - rmadmin
Enter the password.
Select create user and confirm password
Enter the password again
<Please see attached file for image>
Click install to install CA Aion Rule Manager r11
Click Done to finish the install
Re-install and Re-configure Aion Rule Manager
There are pointers for Aion Rule Manager content in the database and in EEM. If you have to re-install Aion Rule Manager for any reason, you need to reestablish those pointers.
To de-install Aion Rule manger you need to use the Uninstall_AionRM application which can be found on the start menu under CA ?Aion Rule Manager
Re-install Aion Rule Manager r11
At the introduction page, Click Next
Scroll to the bottom of the License Agreement Select I accept the terms of the License agreement and Click Next
Leave the Install folder as C:\Program Files\CA The product will be installed into a folder called AionRM here.
Select Custom Installation and click Next
<Please see attached file for image>
Make sure the Aion Rule Manager database, EEM and Aion Rule Manager is selected.
Click Next
<Please see attached file for image>
Although you can configure the existing database, its easier and cleaner to create a new one.
Select Create Aion Rule Manager database
Click Next
<Please see attached file for image>
Select a new name for the database name such as Aion Rule Manager DB
You can keep the user id already created - rmdba
Scroll to enter the password
<Please see attached file for image>
Enter the password
Since this is not a new user id, do not click on create user and confirm password.
Leave the confirmation password blank.
Click Next
<Please see attached file for image>
Specify the SQL server Hostname
Specify the SQL server port
Enter the Admin username and password.
Click Next
The database information will be verified and the EEM configuration page will be displayed
<Please see attached file for image>
Enter the EEM host name
Enter the EiamAdmin password.
Scroll for more information
<Please see attached file for image>
Leave application instance alone
Select choose to find the existing certificate file. The file type is p12
Scroll for certificate password information
<Please see attached file for image>
Enter the certificate password.
As this is not a new certificate do not check the checkbox for create certificate and confirm password
Leave the confirm password blank
Click next
If the install passes EEM verification you will get the Application Server Information page
<Please see attached file for image>
Enter JBOSS information. Enter the directory that contains the conf directory (configuration files) If you installed JBOSS with all the defaults the directory will be
C:\Program Files\jboss-4.0.3SP1\server\default
Click next
<Please see attached file for image>
Since we created a new database the instance ID can be 1.
Leave the library location alone
Click Next<Please see attached file for image>
Specify the RM admin user. In this case rmadmin was created in EEM in the original install so it does not need to be installed again.
Specify the password.
Since this is not a new user id do not check the create user and confirm password check box.
Do not enter the password again.
Click Next
Review the Pre-Installation Summary
Click Install
Click Done
Installation Verification
SQL server verification
Log on to the Sql server database as rmdba. There should be approximately 88 tables in the Aion Rule Manager database
EEM verification
Log onto EEM From the Start menu select CA, Select Embedded Entitlements Management select EEM UI
<Please see attached file for image>
Select the Application Rule Manager
User Name is EiamAdmin
Enter password
Click Log In
<Please see attached file for image>
Select Manage Identities
<Please see attached file for image>
Select Go in search users
You should then see RMadmin in the Users section.
Rule Manager Verification
Make sure that the Rule Manger is started From the Start menu, select CA, Select Aion Rule Manager, Select Start RM Server
A Command window will be opened and JBOSS will be started. Once JBOSS is started the last lines in the command window should look something like
<Please see attached file for image>
Open the browser and go to the Rule Manager portal //localhost:8080/rmportal
The hostname and port numbers were specified in the install.
<Please see attached file for image>
Enter the Rule Manager Userid and password (specified at install time)
Click Login
If you get the Aion Rule Manager page you have successfully logged into Rule Manager
<Please see attached file for image>
Please refer to the documentation on how to enter create rules and vocabularies.
Un-installation
By uninstalling Rule Manager you are removing the Rule Manager executables and the content management system. You are not removing JBOSS, EEM, the Rule Manager database nor are we removing the rules already created in Rule Manager.
Removing EEM
To remove EEM you must first unregister all Applications.
Login to EEM using EiamAdmin
Go to the Configure tab and select Applications
Select the RuleManager application and click Unregister.
You must repeat this for all applications except CAELM and <Global>
Log out of EEM
Using the Add and Remove items Select Embedded Entitlements Manager click on Remove and follow the instructions to Uninstall EEM.
Removing the Rule Manager Database
Log on to Microsoft SQL Server Management Studio with a userid that has the authority to delete the Rule Manager database
Find the Aion Rule Manager database listed under Databases.
Right mouse click and select delete. The Delete Object window will be displayed.
Select OK to delete the database
<Please see attached file for image>
Removing Rules created by Rule Manager
Delete the AionRM directory. If you use the default directory at install time this will be at C:\program files\CA\AionRM
Removing JBOSS
You can delete the JBOSS directory, or run the JBOSS uninstall which can be found at C:\Program Files\jboss-4.0.3SP1\Uninstaller. Execute Uninstaller.jar
Attachments
Feedback
