Installation Guide › Server Installation › Report Server › High Availability Report Server on PostgreSQL › Prerequisites for SQL Anywhere Database

Prerequisites for SQL Anywhere Database

Follow these steps:

1. Ensure that the minimum patch requirements for RHEL 6 exists.
2. Execute the following command for all the below patches:

   rpm -qa | grep package_name
   compat-libstdc++-33-3.2.3-69.el6.i686 (compatibility standard C++ library from GCC 3.3.4); glibc-2.12-1 (RedHat advisory RHBA-2007:0619-3); libXext.i386; libncurses.so.5, libXext-devel-1.1-3.el6.i686, libXext-devel-1.1-3.el6.x86_64.
   

3. Download and install missing patches by using the following command:

   yum install package_name
   

4. Set the locale for database installation:

   export LC_ALL=en_US.utf8 
   export LANG=en_US.utf8 
   

5. Verify that the locale is set to UTF8:

   locale
   

6. Create a UNIX group to be used as CA Business Intelligence User. For example:

   groupadd -g 400 bobje
   

7. Create a UNIX user to be used by the CA Business Intelligence installer for administrators. For example:

   useradd -d /home/bobje -g bobje bobje
   

8. Set the password for the user you just created.

   passwd bobje
   

9. Edit /etc/hosts file and confirm that you have the following line:

   127.0.0.1       localhost
   

10. Obtain the CABI installation program as follows:
    1. Download and copy the CABI 3.3 installer to the /home/bobje directory.
    2. Go to /home/bobje directory and extract the GZ installer file:

       gunzip cabi_installer.gz
       

    3. Extract the TAR installer file:

       tar -xvf cabi_installer.tar
       

    4. Assign sufficient permissions to the CABI install folder and installer media:

       # chmod 777 /home/bobje/