Installing ARIS Publisher Server using a Microsoft SQL Server
Before installing an ARIS server on a Linux operating system, you must provide ARIS Agent to your Linux Red Hat or SUSE system. To allow customizing activities additionally provide the command-line tools ARIS Server Administrator, ARIS Cloud Controller (ACC), and ARIS Scriptrunner. Use the *.rpm files for Red Hat or SUSE systems. After you have copied and installed the files start the remote installation from a Windows system.
In RedHat and SUSE systems *.rpm files will perform these actions automatically:
/etc/sysctl.conf
kernel.shmmax:
if "kernel.shmmax < 629145600" then "kernel.shmmax = 629145600"
max_file_max:
if "max_file_max < 200000” then "fs.file-max = 200000"
/etc/security/limits.d/40-aris.conf
$max_file_max = "ulimit –n"
If "$max_file_max > 2^20" then max_file_max = 2^20
aris10 soft nofile $max_file_max
aris10 hard nofile $max_file_max
aris10 soft nproc 12204
aris10 hard nproc 12204
/etc/pam.d/su
session required pam_limits.so
This setup will install ARIS Agent and ARIS Publisher Server. The standard setup installs ARIS Publisher Server including Apache TomcatTM Web Application Server. As the used Web Application Serverversion cannot be the most recent version a denial of service (DoS) vulnerability can occur. This vulnerability is not critical for intranet use. For Internet use please make sure to use the most recent web application server version that matches your security requirements.
For a productive ARIS Publisher system you must select the small or large installation option. For these installation options an external database system is required. The external database system is not included in the package. Depending on the ARIS Publisher Server license purchased, the system enables all users to simultaneously work on exports.
The file create_db.sql (<installation media\Add-ons\DatabaseScripts\PublisherServer\mssql) is copied to a directory of your choice. This script can be modified according to your security guide lines.
You have installed Microsoft SQL Server under Microsoft Windows. Microsoft SQL Server is not included in the package. If you install or configure a database yourself, always follow the instructions provided by the respective manufacturer, or contact your local Software AG sales organization.
You have downloaded the latest version of the Microsoft SQL Server JDBC driver, for example, jTDS.jar or sqljdbc4-4.0.2206.100.jar from the Microsoft Download Center to a directory of your choice.
To encrypt passwords use the ARIS Server Administrator command encrypt.
Procedure
Copy the file aris10-cloud-agent-<number>-1.x86_64.rpm or aris10-cloud-agent-SLES-<number>-1.x86_64.rpm from the installation media to the hard drive of your Linux system.
This file provides ARIS Agent. ARIS Agent is needed to perform a remote server installation.
Optionally copy the file aris10-acc_<number>-1.x86_64.rpm from the installation media (Linux) to the hard drive of your Linux system.
This file provides ARIS Cloud Controller (ACC).
Optionally copy the files for installing ARIS Server Administrator and ARIS Scriptrunner. These files are not mandatory for ARIS Server to be installed.
Depending on the files you have copied and the type of the Linux system enter the relevant command to install the files. By default, these installations will create an unprivileged and locked user ARIS which uses /home/ARIS10 to install ARIS itself. If you want to use different settings make sure to change them before installing the first rpm file.
rpm –i aris10-acc-<number>-1.x86_64.rpm
This command installs ARIS Cloud Controller (ACC) (/bin/acc10.sh) to your Red Hat and SUSE system.
rpm –i aris10-cloud-agent-<number>-1.x86_64.rpm
This command installs ARIS Agent to your Red Hat system.
This command installs ARIS Agent to your SUSE system.
rpm –i aris10adm-<number>-1.x86_64 and rpm –i aris10-scriptrunner-<number>-1.x86_64
These commands optionally install the administrator tools ARIS Server Administrator and ARIS Scriptrunner.
Adjust the system as required to manage ARIS Publisher Server in combination with a Microsoft SQL Server database. For additional information about Microsoft SQL Server, visit the Microsoft SQL Server site.
Open the Microsoft SQL Console.
Open the Server properties dialog.
On the Security tab, select the SQL Server and Windows authentication mode option (mixed mode).
Create a database using the create_db.sql script.
Note the database name, user name, and password. You must enter these values later during the setup process.
Ensure that Latin1_General_CI_AI sorting is selected for the COLLATE statement.
The script creates the specified data groups. Note these values. You must enter the values later during the setup process.
ARISBPDATA: contains all database objects
ARISBPINDEX: contains all index data
Close the Microsoft SQL Console.
Start the ARIS Publisher Server installation from a machine running a Microsoft Windows operating system as an administrator (DVD 2 folder Setups\Windows\ARIS_Publisher_Server).
Select the Perform installation on a remote server option and enter the name of your Linux system.
To import the ARIS license file right now, click Select file... and navigate to the license archive file. Otherwise licenses must be imported after the installation.
Select the ARIS Publisher Server to be installed. A Report Server can only be installed on another machine. This is to optimize system performance when running reports.
If you retain the settings of the installation program, the context path and the default port 14500 to the web server are entered automatically. Either make sure that the default port is not used by other programs, or enter another free port number.
If you use Process Governance specify the IP address or fully-qualified ARIS Server name. Enter the port number only if it is another than the standard port.
The Process Governance module and the Start governance process pop-up menu are only available in the Publisher exports if a Process Governance license is available for the connected ARIS Server and all Process Governance integration parameters have been entered during the ARIS Publisher Server setup process.
To use the user and license management of another ARIS server, select Use the ARIS Administration of an existing ARIS server.
Enter the URL to that ARIS Server ARIS Administration:
http://<IP address or fully-qualified host name>:<load balancer port>/umc
You must enter the port number only if you have changed or redirected (Redirect ports, Redirect ports) the standard port.
Enter the ARIS Administration user's name superuser and the corresponding password.
Select the Medium or Large installation option. You need to take the memory requirement into account to ensure optimum load distribution and better protection against failure.
Select the Microsoft SQL Server as database system.
Select the required JDBC driver for the Microsoft SQL database management system.
Enter the connection parameters used in the create_db.sql file and exactly the values used by the Microsoft SQL server.
The values shown are the default values used in the create_db.sql file and the default parameters used when setting up the Microsoft SQL server.
Server: Fully qualified name or IP address of the Microsoft SQL server.
Port: Port addressing the SQL server instance running over TCP. The default port number is 1433.
Instance name: When setting up a Microsoft SQL server, the default instance name is MSSQLSERVER. If you use named instances, append a backslash and enter the used instance name instead.
Database name: Name of the database that was created by the create_db.sql script. The default value is ARISBP10.
Application user: Login user name that is used by the application. The default value used in the from create_db.sql file is ARISBP10.
Password: The application user's password. The default value used in the create_db.sql file is *ARISBP!1dm95n#. This password is automatically encrypted during the setup process. You can also enter encrypted passwords.
Data file group: Name of the tablespace for table data that had been created earlier. The default value used in the create_db.sql file is ARISBPDATA.
Index file group: Name of the tablespace for index data that had been created earlier. The default value used in the create_db.sql file is ARISBPINDEX.
After the installation, reports are run by ARIS Publisher Server. You can additionally install a Report Server to optimize system performance when running reports. To install ARIS Publisher Report Server, start this setup again and select the ARIS Publisher Report Server to be installed. After you have installed ARIS Publisher Report Server, exports are managed by ARIS Publisher Server and reports are run by ARIS Publisher Report Server.
To uninstall ARIS from a Red Hat or a SUSE system enter, for example, rpm –e aris10-cloud-agent and rpm –e aris10-acc.
Update installations are available. Components will be stopped. After the system has been updated all components will be started automatically.