Installing VERDE (RPM) 8.3.4 and Above with Postgres Database and Centos7.x Server (Recommended DB Settings)

Installing VERDE (RPM) 8.3.4 and Above with Postgres Database and Centos7.x Server (Recommended DB Settings)

Produce Line:  VERDE

Install the Centos 7 server as previously performed:

  • Burn Centos 7 Minimal to a CD/DVD or USB
    • Install the OS
    • Select your time zone
    • Enable the Network Interface
    • Use the entire storage area on the server
    • Create a root password
    • Allow a reboot and remove the CD/DVD or USB
  • Modify Networking for Static or Manual IP
    • You can specify your Gateway IP
    • You can specify your DNS server IP
  • Create the following file via the vi command:
          vi /etc/security/limits.d/95-verde.conf
    Add the following lines of data:
    * - nproc -1
    * - nofile 65535


Run the following linux update.
    yum -y update

NOW, this is where the database is installed.
      Access this article's attachment entitled install-postgresql.sh. 
      SSH it to your VERDE server. 
      Once it copies, change it to an executable via the following command
            chmod a+x install-postgresql.sh 
     
      Run the install:
            ./install-postgresql.sh 

      The install will run and you'll see the following:
Running transaction
  Installing : pgdg-redhat-repo-42.0-32.noarch                                                                                                                                1/1
  Verifying  : pgdg-redhat-repo-42.0-32.noarch                                                                                                                                1/1

Installed:
  pgdg-redhat-repo.noarch 0:42.0-32

Complete!
Please enter the preferred posgresql version, or press Ctrl+C to exit
Supported versions [11|12|13|14|15]:

At this writing, our software is compatible with version 13.  Enter 13
 
The database installs then, you need to provide a password,  You'll see the following:


Enter a password... DON'T FORGET IT!  You'll need to enter it twice.
After entering the password twice, you'll see the following:
ALTER ROLE
Create a new DB that we will use for Verde:

Enter a database name.  I'm typing in verde2


Then you're asked the IP to listen on.  It's recommended that you enter the value:  localhost
Then your asked to set the IP range.  It's recommended that you enter your VERDE server IP/32
Mine is 192.168.1.0/32

That part's done!
Now with those setting, populate the following file:

vi /tmp/dbsettings

with the same values.  Here's my file:

host = localhost
port = 5432
dbname = verde2
dbuser = postgres
dbpass = pass

Now, export the file as follows:

export VERDE_DB_SETTINGS_FILE=/tmp/dbsettings

VERDE Install
Now, move your VERDE rpm's to the server and put them in the /root/ directory

And install the rpm's
      yum -y install VERDE-*



If the exported /tmp/dbsettings did not populate correctly, you will receive messages about needing to run:
      /usr/lib/verde/bin/verde-util --set-db-settings

[root@localhost logs]# /usr/lib/verde/bin/verde-util --set-db-settings
Aug-01 15:52:30:6745 N /usr/lib/verde/bin/verde-util rel.17238 (main built 08/01/23 15:40) on localhost pid 12633 log level NOTE
Please enter the DB end point (format IP:PORT, default 127.0.0.1:5432):

192.168.1.12:5432
Enter the DB name:
verde2
Enter the DB user name:
postgres
Enter the DB password:

Re-enter the DB password:

Now, run the VERDE configuration as usual.

      /usr/lib/verde/bin/verde-config -i

Now, login to the Management Console (https:/CM-IPAddress:8443/mc).