Configure the ArcSight Database Instance

Once the ArcSight Database instance has been created, execute the following configuration steps:

  1. Establish an SSH connection to the instance.

  2. Become root and change your root password.

  3. Create a folder for ArcSight Database by running the command:

    mkdir /opt/vertica
  4. ArcSight Database requires a minimum 2 GB swap partition, irrespective of the amount of RAM installed. In this example, we will set up a 4 GB swap partition by running the following commands:

    dd if=/dev/zero of=/swapfile bs=1K count=4M
    chmod 600 /swapfile
    mkswap /swapfile
    swapon /swapfile
    echo "/swapfile swap swap defaults 0 0" | sudo tee -a /etc/fstab
  5. To verify that the swap partition was created properly, execute the following command:

    sudo swapon --show

    Example Output:

    NAME      TYPE SIZE USED PRIO
    /swapfile file   4G   0B   -2
  6. Next, the secondary drive needs to be partitioned and formatted. Run the lsblk command to list all the drives on the instance.

    Example command and output:

    # lsblk
    NAME   MAJ:MIN     RM  SIZE     RO TYPE     MOUNTPOINT
    sda	      8:0            0    20G      0    disk
    ├─sda1       8:1            0    200M   0    part      /boot/efi
    └─sda2        8:2           0    19.8G   0    part /
    sdb              8:16          0     256G    0    disk		
  7. Create partitions on the datadisk using the fdisk command and the 256 GB attached drive:

    # fdisk  /dev/sdb
  8. This command will request several inputs, the answers should be:

    • Command (m for help): n for new

    • Partition type: p for primary

    • Partition number: 1 (default)

    • First sector: enter a value, or accept the default value

    • Last sector: enter a value, or accept the default value

    The result of this creation command should be a message announcing that a partition was created with a size of 256 (in this example).

    Created a new partition 1 of type 'Linux' and of size 256 GiB.

    A final command must be entered to save the changes and exit fdisk:

    • Command (m for help): w for write

  9. Once the process above has finished, run the lsblk command again to verify the creation of a new partition under sdb.

    Example output:

    NAME   MAJ:MIN     RM  SIZE     RO TYPE     MOUNTPOINT
    sda	      8:0            0    20G      0    disk
    ├─sda1       8:1            0    200M   0    part      /boot/efi
    └─sda2        8:2           0    19.8G   0    part /
    sdb              8:16          0     256G    0    disk
    └─sdb1       8:17          0      256G    0    part
    
  10. Format the new partition with the following command:

    mkfs.ext4 /dev/sdb1
  11. Obtain the last created disk's UUID by running this command:

    blkid

    Take note of the sdb1 partition UUID value.

  12. Use the value from the previous step to modify the /etc/fstab file, by adding the following line:

    UUID=<UUID sdb1>    /opt/vertica  ext4	 defaults  0 0

    Where:

    <UUID sdb1> is the value obtained for the sdb1 partition UUID.

  13. Mount all by running the following command:

    mount -a
  14. Run the lsblk command one last time to verify that the sdb1 partition now contains the /opt/vertica under MOUNTPOINT.

    Example output:

    NAME   MAJ:MIN     RM  SIZE     RO TYPE           MOUNTPOINT
    sda	      8:0            0    20G      0    disk
    ├─sda1       8:1            0    200M   0    part      /boot/efi
    └─sda2        8:2           0    19.8G   0    part /
    sdb              8:16          0     256G    0    disk
    └─sdb1       8:17          0      256G    0    part  /opt/vertica