TetraWiki - User contributions [en]

File:PHDCCI Migration to Microsoft 365.pdf

2024-03-04T07:40:57Z

Alok:

[[category:PHDCCI]]

== PHDCCI Migration to Microsoft 365 Document ==

File:PHDCCI Migration to Microsoft 365.pdf

2024-03-04T07:38:37Z

Alok: PHDCCI_Migration_to_Microsoft_365

PHDCCI_Migration_to_Microsoft_365

Adani

2024-02-20T09:07:27Z

Alok: Created page with "hello"

hello

ISON BPO Nagios XI

2022-12-03T04:08:25Z

Alok:

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine to check Network Devices (Routers, Switches and Firewall etc)==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some perl files will be missing you have to download those files'''
14.98.74.34 is a IP address of a Network device
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)
./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-03T04:07:58Z

Alok:

[[category:ISON BPO Nagios XI]]
[[category:Building Probe Machine Documentation]]

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine to check Network Devices (Routers, Switches and Firewall etc)==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some perl files will be missing you have to download those files'''
14.98.74.34 is a IP address of a Network device
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)
./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-03T04:06:27Z

Alok:

[[category:ISON BPO Nagios XI]]

[[category:Building Probe Machine Documentation]]

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine to check Network Devices (Routers, Switches and Firewall etc)==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some perl files will be missing you have to download those files'''
14.98.74.34 is a IP address of a Network device
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)
./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:11:31Z

Alok: /* Configuration on slave server */

[[Category:Radico-MySQL-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
vi /etc/my.cnf
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
default_authentication_plugin=mysql_native_password
Save the file :wq!
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
default_authentication_plugin=mysql_native_password
Save the file :wq!
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note:Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:11:10Z

Alok: /* Configuration on slave server */

[[Category:Radico-MySQL-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
vi /etc/my.cnf
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
default_authentication_plugin=mysql_native_password
Save the file :wq!
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
default_authentication_plugin=mysql_native_password
Save the file :wq!
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:10:32Z

Alok: /* Configuration on master server */

[[Category:Radico-MySQL-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
vi /etc/my.cnf
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
default_authentication_plugin=mysql_native_password
Save the file :wq!
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:05:35Z

Alok:

[[Category:Radico-MySQL-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:04:45Z

Alok: /* Configuration on master server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:02:06Z

Alok: /* Installation of MySQL community server on both the server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349
User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
******************************************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T12:01:18Z

Alok: /* Installation of MySQL community server on both the server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

VPN details
Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349

User : tetra
Pass : Tetra@2211

Server DetailsS
TNT Server1 : 172.18.40.211 (Master Server)
TNT Server2 : 172.18.40.212 (Slave Server)
Username:root
Pass:R@D!C)@a

Mysql login Details
username:root
Pass:Pass@12345

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
******************************************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:59:25Z

Alok: /* Configuration on master server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
******************************************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

==Configuration on slave server==
vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
##login into mysql and run the below commands
Stop slave;
mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;
start slave;
mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:57:30Z

Alok: /* Installation of MySQL community server on both the server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;

**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G

*************************** 1. row ***************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

'''configuration on slave server'''

vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

##login into mysql and run the below commands

Stop slave;

mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;

start slave;

mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:56:42Z

Alok: /* Installation of MySQL community server on both the server */

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica;
**********************************************************************************
'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345
**************************************************************************************************

==Configuration on master server==
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates
#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G

*************************** 1. row ***************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

'''configuration on slave server'''

vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

##login into mysql and run the below commands

Stop slave;

mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;

start slave;

mysql> show slave status\G
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
'''

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:55:18Z

Alok:

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==

'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica; \
**********************************************************************************
'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345
**************************************************************************************************

'''Configuration on master server'''

vi /etc/my.cnf
##master server
bind-address = 172.18.40.211
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
*************************** 1. row ***************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

'''configuration on slave server'''

vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

##login into mysql and run the below commands

Stop slave;

mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;

start slave;

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

#Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:54:36Z

Alok:

[[Category:Radico-Master-Slave-Replication ]]

'''==Installation of MySQL community server on both the server=='''
'''Note: Run this commands as a Root User'''
vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica; \
**********************************************************************************
'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345
**************************************************************************************************

'''Configuration on master server'''

vi /etc/my.cnf
##master server
bind-address = 172.18.40.211
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
*************************** 1. row ***************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

'''configuration on slave server'''

vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

##login into mysql and run the below commands

Stop slave;

mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;

start slave;

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

#Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status

Radico-Sitapur-Master-Slave Replication

2022-12-02T11:54:02Z

Alok: Created page with "Category:Radico-Master-Slave-Replication ==Installation of MySQL community server on both the server== '''Note: Run this commands as a Root User''' vi /etc/yum.repos..."

[[Category:Radico-Master-Slave-Replication ]]

==Installation of MySQL community server on both the server==
'''Note: Run this commands as a Root User'''

vi /etc/yum.repos.d/mysql80-community.repo
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
yum repolist all
yum install mysql-community-server
setenforce 0
vi /etc/sysconfig/selinux (disabled selinux)
systemctl enable mysqld.service
systemctl start mysqld.service
grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation (set the password for root mysql)
mysql -pPass@1234
CREATE USER 'root'@'%' IDENTIFIED BY 'Pass@1234';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
##Run this command only on master server
create user 'repl_user'@'%' identified by 'Pass@1234';
Grant replication slave on *.* to 'repl_user'@'%';
ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
##To check the permission of the user run the below command
show grants for replica; \
**********************************************************************************
'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''
vi /etc/my.cnf
[mysqld]
skip-grant-tables
systemctl restart mysqld
mysql -u root -p
##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
FLUSH PRIVILEGES;
##Set a new password for the account:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
##Restart the MySQL server again.
##Log in to the root account again:
mysql -u root -pPAss@12345
**************************************************************************************************

'''Configuration on master server'''

vi /etc/my.cnf
##master server
bind-address = 172.18.40.211
server-id = 1
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

#Again login into mysql:
mysql -u root -pPAss@12345
##Check master status:
mysql> SHOW MASTER STATUS \G
*************************** 1. row ***************************
File: mysql-bin.000012
Position: 418
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
1 row in set (0.00 sec)

'''configuration on slave server'''

vi /etc/my.cnf
#slave server
bind-address = 172.18.40.212
server-id = 2
log_bin = mysql-bin
binlog_format = row
gtid-mode=ON
enforce-gtid-consistency
log-slave-updates

##login into mysql and run the below commands

Stop slave;

mysql -> CHANGE MASTER TO
-> MASTER_HOST='172.18.40.211' ,
-> MASTER_USER='repl_user' ,
-> MASTER_PASSWORD='Pass@1234' ,
-> MASTER_LOG_FILE='mysql-bin.000012' ,
-> MASTER_LOG_POS=418;

start slave;

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 172.18.40.211
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000012
Read_Master_Log_Pos: 418
Relay_Log_File: TNTSERVER2-relay-bin.000040
Relay_Log_Pos: 587
Relay_Master_Log_File: mysql-bin.000012
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

#Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status

ISON BPO Nagios XI

2022-12-02T11:45:19Z

Alok: /* Step 3: Install check_nwc_health Plugin in the Probe Machine */

ISON BPO Nagios XI

2022-12-02T11:42:39Z

Alok: /* Step 3: Install check_nwc_health Plugin in the Probe Machine */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:41:56Z

Alok: /* Step 2: Install Nagios XI in the Probe Machine to get the Plugins */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:41:29Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:40:52Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730

(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:40:08Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730

(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:39:55Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730

(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:39:33Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

(rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh)

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730
if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:38:53Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

(rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730
if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:38:20Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

'''Note: Run this command as a Root User'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:37:47Z

Alok: /* STEP 1: Install Mod-gearman in the Probe Machine and Configure */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh

./ModGearmanInstall.sh --type=worker

{ Set the Nagios XI Server IP address is 172.105.253.143 }

vi /etc/mod_gearman/worker.conf

{Add the hostgroups Location of probe machine}

systemctl restart mod-gearman-worker

{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}

vi /etc/mod_gearman/module.conf

systemctl restart gearmand

gearman_top {to see all the hostgroups}

telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:37:00Z

Alok: /* Step 2: Install Nagios XI in the Probe Machine to get the Plugins */

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

==Step 3: Install check_nwc_health Plugin in the Probe Machine==

wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/

'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:33:58Z

Alok:

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

==STEP 1: Install Mod-gearman in the Probe Machine and Configure==

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

==Step 2: Install Nagios XI in the Probe Machine to get the Plugins==

cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

'''Step 3: Install check_nwc_health Plugin in the Probe Machine'''
wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/
'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:31:05Z

Alok:

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

'''STEP 1: Install Mod-gearman in the Probe Machine and Configure'''

rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm

yum update

wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh

chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

'''Step 2: Install Nagios XI in the Probe Machine to get the Plugins'''
cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

'''Step 3: Install check_nwc_health Plugin in the Probe Machine'''
wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/
'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

ISON BPO Nagios XI

2022-12-02T11:29:27Z

Alok: Created page with "category:ISON BPO Nagios XI '''Building Probe Machine Documentation''' '''STEP 1: Install Mod-gearman in the Probe Machine and Configure''' rpm -Uvh https://repo.nagios...."

[[category:ISON BPO Nagios XI]]

'''Building Probe Machine Documentation'''

'''STEP 1: Install Mod-gearman in the Probe Machine and Configure'''
rpm -Uvh https://repo.nagios.com/nagios/7/nagios-repo-7-4.el7.noarch.rpm
yum update
wget https://assets.nagios.com/downloads/nagiosxi/scripts/ModGearmanInstall.sh
chmod +x ModGearmanInstall.sh
./ModGearmanInstall.sh --type=worker
{ Set the Nagios XI Server IP address is 172.105.253.143 }
vi /etc/mod_gearman/worker.conf
{Add the hostgroups Location of probe machine}
systemctl restart mod-gearman-worker
{Now go to the Nagios XI server and add the hostgroups of the probe machine which you created now}
vi /etc/mod_gearman/module.conf
systemctl restart gearmand
gearman_top {to see all the hostgroups}
telnet 172.105.253.143 4730
(if telnet status is connected means communication is established between the probe machine and Nagios XI server)

'''Step 2: Install Nagios XI in the Probe Machine to get the Plugins'''
cd /tmp
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.8.7.tar.gz
tar xzf xi-5.8.7.tar.gz
cd nagiosxi/
./fullinstall
cd /usr/local/nagios/libexec/
ls (to see all the plugins)

'''Step 3: Install check_nwc_health Plugin in the Probe Machine'''
wget https://labs.consol.de/assets/downloads/nagios/check_nwc_health-10.0.0.2.tar.gz
tar xvfz check_nwc_health-10.0.0.2.tar.gz
cd check_nwc_health-10.0.0.2
./configure
make
make install
cd /usr/local/nagios/libexec/
'''Note: while running the check_nwc_health plugin some files will be missing you have to download those files'''
./check_nwc_health --hostname 14.98.74.34 --community public --mode hardware-health
After running this command if error comes can’t locate and *.pm file download the file using
yum install perl-file name
Suppose error comes can’t locate JSON.pm file then I will run command like this
yum install perl-JSON
yum install perl-File-Slurp (if error comes can’t locate File/Slurp.pm file)
yum install perl-Module-Load (if error comes can’t locate Module/Load.pm file)

./check_nwc_health --hostname 14.98.74.34 --community public --mode cpu-load
yum install perl-JSON-XS (If error comes can’t locate JSON/XS.pm file)

Zimbar NE Demo Video made for Tender

2022-01-11T07:33:14Z

Alok:

[[category:Zimbra]]
== Zimbra NE Demo ==

<HTML5video type="youtube" width="640" height="480" autoplay="false">gXmAP2lbC8I</HTML5video>

Zimbar NE Demo Video made for Tender

2022-01-11T07:32:11Z

Alok: Created page with " == Zimbra NE Demo == <HTML5video type="youtube" width="640" height="480" autoplay="false">gXmAP2lbC8I</HTML5video>"

== Zimbra NE Demo ==

<HTML5video type="youtube" width="640" height="480" autoplay="false">gXmAP2lbC8I</HTML5video>