IntoTheUnknown -varanawesomenow - Install midserver on Rhel linux and discover postgresql

[VaranAwesomenow]

sudo yum install wget

---> Package wget.x86_64 0:1.14-18.el7_6.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================
Installing:
wget x86_64 1.14-18.el7_6.1 rhui-rhel-7-server-rhui-rpms 547 k

Transaction Summary
====================================================================================================================================================================
Install 1 Package

Total download size: 547 k
Installed size: 2.0 M
Is this ok [y/d/N]: y
Downloading packages:
wget-1.14-18.el7_6.1.x86_64.rpm | 547 kB 00:00:04
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : wget-1.14-18.el7_6.1.x86_64 1/1
Verifying : wget-1.14-18.el7_6.1.x86_64 1/1

Installed:
wget.x86_64 0:1.14-18.el7_6.1

wget https://install.service-now.com/glide/distribution/builds/package/app-signed/mid-linux-installer/2021/07/15/mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.rpm

Resolving install.service-now.com (install.service-now.com)... 149.96.5.98
Connecting to install.service-now.com (install.service-now.com)|149.96.5.98|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 350191500 (334M) [application/x-rpm]
Saving to: ‘mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.rpm’

100%[==========================================================================================================================>] 350,191,500 1.56MB/s in 3m 42s

2021-10-17 03:34:06 (1.51 MB/s) - ‘mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.rpm’ saved [350191500/350191500]

wget https://install.service-now.com/glide/distribution/builds/package/app-signed/mid-linux-installer/2021/07/15/mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64-rpm.zip

Resolving install.service-now.com (install.service-now.com)... 149.96.5.98
Connecting to install.service-now.com (install.service-now.com)|149.96.5.98|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1129 (1.1K) [application/zip]
Saving to: ‘mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64-rpm.zip’

100%[==========================================================================================================================>] 1,129 --.-K/s in 0s

2021-10-17 03:43:58 (223 MB/s) - ‘mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64-rpm.zip’ saved [1129/1129]

sudo yum install unzip

Resolving Dependencies
--> Running transaction check
---> Package unzip.x86_64 0:6.0-22.el7_9 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================
Installing:
unzip x86_64 6.0-22.el7_9 rhui-rhel-7-server-rhui-rpms 171 k

Transaction Summary
====================================================================================================================================================================
Install 1 Package

Total download size: 171 k
Installed size: 365 k
Is this ok [y/d/N]: y
Downloading packages:
unzip-6.0-22.el7_9.x86_64.rpm | 171 kB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : unzip-6.0-22.el7_9.x86_64 1/1
Verifying : unzip-6.0-22.el7_9.x86_64 1/1

Installed:
unzip.x86_64 0:6.0-22.el7_9

Complete!

unzip mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64-rpm.zip

Archive: mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64-rpm.zip
inflating: ServiceNow_Digicert_DGST.pem
extracting: mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.bin

sudo yum install openssl

openssl dgst -sha256 -verify ServiceNow_Digicert_DGST.pem -signature mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.bin mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.rpm

Verified OK

mkdir mid

[varanconsulting3@instance-1 mid]$ pwd /home/varanconsulting3

sudo rpm -ivh --nodeps mid-linux-installer.rome-06-23-2021__patch0-07-07-2021_07-15-2021_1403.linux.x86-64.rpm --prefix=/home/varanconsulting3/mid

Preparing... ################################# [100%] Updating / installing... 1:agent-20.z.0.5-2284.el7 ################################# [100%] MID Server has been installed at /home/varanconsulting3/mid MID Server can be configured using /home/varanconsulting3/mid/agent/installer.sh script Please refer README file for more details

/home/varanconsulting3/mid/agent/installer.sh

[root@instance-1 varanconsulting3]# /home/varanconsulting3/mid/agent/installer.sh \nServiceNow MID Server (not installed) is not running. ******* WARNING : Proceeding further will destroy the old configuration ******* Do you want to proceed ? [Enter Y or N] : Y Detected RHEL or Fedora: The ServiceNow MID Server daemon is not currently installed. Enter the ServiceNow Instance URL [https://YOUR_INSTANCE.service-now.com/] : https://dev102031.service-now.com/ Do you want to use proxy? [Enter Y or N] : Y Enter the proxy host name : ^C [root@instance-1 varanconsulting3]# /home/varanconsulting3/mid/agent/installer.sh \nServiceNow MID Server (not installed) is not running. ******* WARNING : Proceeding further will destroy the old configuration ******* Do you want to proceed ? [Enter Y or N] : Y Detected RHEL or Fedora: The ServiceNow MID Server daemon is not currently installed. Enter the ServiceNow Instance URL [https://YOUR_INSTANCE.service-now.com/] : https://dev102031.service-now.com/ Do you want to use proxy? [Enter Y or N] : N Do you want to use Mutual Authentication? [Enter Y or N] : N Validating the Instance URL... Enter the username for mid user : admin Enter the password for mid user: Validating the Mid-user details... Username and password are valid. Enter the Mid Server Name [My_Linux_Mid_Server] : varanmid1710 Enter the unique name for the service to be created [mid] : varanmid1710 Checking for the uniqueness of the service name... Enter the long name for the service [ServiceNow_MID_Server] : varanmid1710long Enter the Non-Root User Name to run this service : varanconsulting3 ******************************************************************************************* NOTE: A non-root user can manage a service only when the user has required privileges. For more information, refer https://hi.service-now.com/kb_view.do?sysparm_article=KB0815542 ******************************************************************************************* Enter yes for the below displayed prompt if you want to start the daemon with out any errors... The agent directory is /home/varanconsulting3/mid/agent Do you want to block all other user access and change the ownership of the entire agent directory at /home/varanconsulting3/mid/agent based on the mid.shconf_override settings (Enter yes or YES to confirm) ? YES Block all other user access... Change user ownership to varanconsulting3 ... Change group ownership to varanconsulting3 ... Detected RHEL or Fedora: Installing the varanmid1710long daemon using systemd... creating default service file... Created symlink from /etc/systemd/system/multi-user.target.wants/varanmid1710.service to /etc/systemd/system/varanmid1710.service. Starting varanmid1710long with systemd... Waiting for varanmid1710long... running: PID:2268 Mid is running as a service successfully..

Install postgresql

sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgresql14-server
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14

Total download size: 7.3 M
Installed size: 31 M
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/pgdg14/packages/postgresql14-14.0-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY 00:00:18 ETA
Public key for postgresql14-14.0-1PGDG.rhel7.x86_64.rpm is not installed
(1/3): postgresql14-14.0-1PGDG.rhel7.x86_64.rpm | 1.5 MB 00:00:02
(2/3): postgresql14-libs-14.0-1PGDG.rhel7.x86_64.rpm | 265 kB 00:00:02
(3/3): postgresql14-server-14.0-1PGDG.rhel7.x86_64.rpm | 5.5 MB 00:00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.6 MB/s | 7.3 MB 00:00:02
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Importing GPG key 0x442DF0F8:
Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
Package : pgdg-redhat-repo-42.0-20.noarch (@/pgdg-redhat-repo-latest.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : postgresql14-libs-14.0-1PGDG.rhel7.x86_64 1/3
Installing : postgresql14-14.0-1PGDG.rhel7.x86_64 2/3
Installing : postgresql14-server-14.0-1PGDG.rhel7.x86_64 3/3
Verifying : postgresql14-server-14.0-1PGDG.rhel7.x86_64 1/3
Verifying : postgresql14-14.0-1PGDG.rhel7.x86_64 2/3
Verifying : postgresql14-libs-14.0-1PGDG.rhel7.x86_64 3/3

Installed:
postgresql14-server.x86_64 0:14.0-1PGDG.rhel7

Dependency Installed:
postgresql14.x86_64 0:14.0-1PGDG.rhel7 postgresql14-libs.x86_64 0:14.0-1PGDG.rhel7

Complete!
[root@instance-1 varanconsulting3]# sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
Initializing database ... OK

[root@instance-1 varanconsulting3]# sudo systemctl enable postgresql-14
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-14.service to /usr/lib/systemd/system/postgresql-14.service.

Validate midserver on the platform

 Install mysql

yum install mariadb-server mariadb-libs mariadb 

References

https://www.cyberciti.biz/faq/how-to-install-wget-on-rhel-8-redhat-enterprise-linux/y

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/mid-server/task/t_InstallAMIDServerOnLinux.html#t_InstallAMIDServerOnLinux

https://www.postgresql.org/download/linux/redhat/

https://www.thegeekdiary.com/using-the-ssh-keygen-command-in-linux/