MDI DHCP Server Implementation

2016-03-16T08:18:26Z

Brijesh:

[[category:MDI]]

'''MDI DHCP Server Implementation''':

OS Version RHEL 6.1 (x86_64)

ROOT Password : ghL@#W01GS

To access DHCP server logged in on MDI mail server with public IP (credential is on login sheet):

tetra@tetra004:~$ ssh root@14.141.218.163
root@14.141.218.163's password: "Type password"

Then access DHCP server from mail server:

[root@mailserver ~]# ssh root@192.168.1.10
root@192.168.1.10's password: "Type password"

---------------------------------------------------------------------------
'''Set the hostname'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network
---------------------------------------------------------------------------
NETWORKING=yes
HOSTNAME=mdidhcpserver
---------------------------------------------------------------------------

'''Set IP address'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
HWADDR=ec:b1:d7:3c:10:07
NM_CONTROLLED=no
ONBOOT=yes
IPADDR=192.168.1.10
NETMASK=255.255.0.0
GATEWAY=192.168.12.25
TYPE=Ethernet
BOOTPROTO=none
IPV6INIT=no
USERCTL=no

---------------------------------------------------------------------------

'''Restart network service:'''

[root@mdidhcpserver dhcp]# /etc/init.d/network restart
[root@mdidhcpserver dhcp]# chkconfig network on
[root@mdidhcpserver dhcp]# service NetworkManager stop
[root@mdidhcpserver dhcp]# chkconfig NetworkManager off

'''Flush the firewall rules:'''

[root@mdidhcpserver dhcp]# iptables -F
[root@mdidhcpserver dhcp]# service iptables stop
[root@mdidhcpserver dhcp]# chkconfig iptables off
---------------------------------------------------------------------------

'''Disable the selinux:'''

[root@mdidhcpserver dhcp]# setenforce 0

'''Disable selinux from file:'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/selinux

---------------------------------------------------------------------------

#This file controls the state of SELinux on the system.
#SELINUX= can take one of these three values:
#enforcing - SELinux security policy is enforced.
#permissive - SELinux prints warnings instead of enforcing.
#disabled - No SELinux policy is loaded.
SELINUX=disabled
#SELINUXTYPE= can take one of these two values:
#targeted - Targeted processes are protected,
#mls - Multi Level Security protection.
SELINUXTYPE=targeted

---------------------------------------------------------------------------
'''Install DHCP package'''

rpm -ivh dhcp-4.1.1-19.P1.el6.x86_64.rpm

'''Configuring DHCP Server'''

Edit configuration file and make below entries

[root@mdidhcpserver dhcp]# vim /etc/dhcp/dhcpd.conf

# DHCP Server Configuration file.
# see /usr/share/doc/dhcp*/dhcpd.conf.sample
# see 'man 5 dhcpd.conf'

log-facility local5;
authoritative;
subnet 192.168.0.0 netmask 255.255.0.0 {
range 192.168.13.1 192.168.24.254;
option domain-name-servers 192.168.10.83, 192.168.12.25;
option domain-name "mdi.ac.in";
option routers 192.168.12.25;
option broadcast-address 192.168.15.255;
default-lease-time 864000;
max-lease-time 1728000;
}
#host DESKTOP-NH1KCIO {
# hardware ethernet 44:8a:5b:72:53:b2;
# fixed-address 192.168.12.215;
#}
host DESKTOP-NH2KCIO { hardware ethernet B6:86:87:B2:FD:EC ; fixed-address 192.168.17.228;}
host DESKTOP-NH3KCIO { hardware ethernet B0:5A:DA:D6:9C:7D ; fixed-address 192.168.13.202;}
host DESKTOP-NH1KCIO {hardware ethernet 44:8a:5b:72:53:b2 ; fixed-address 192.168.12.215;}
host Tarun_mobile {hardware ethernet 98:0c:a5:18:bc:bd ;}
deny unknown-clients;
# Unknown clients get this pool.
subnet 169.254.0.0 netmask 255.255.0.0 {
option domain-name-servers ns1.example.com, ns2.example.com;
max-lease-time 300;
range 169.254.0.1 169.254.255.254;
allow unknown-clients;
}
include "/mac_address/NMP28_MAC_Responses.txt";
include "/mac_address/PGPM_2014.txt";
include "/mac_address/PGPM_2015.txt";
include "/mac_address/PGPIM_2014.txt";
include "/mac_address/PGPIM_2015.txt";
include "/mac_address/sap_2016.txt";
include "/mac_address/fpm_2015.txt";
include "/mac_address/Vendor.txt";
include "/mac_address/PGHR_2015.txt";
include "/mac_address/PGHR_2014.txt";
include "/mac_address/Faculty_Staff_Hostel_LH_LAB.txt";
include "/mac_address/PTPGPM.txt";

---------------------------------------------------------------------------
'''Assign the network interface:'''

[root@mdidhcpserver ~]# vim /etc/sysconfig/dhcpd

Make below entry:
DHCPDARGS=eth0

---------------------------------------------------------------------------
'''After configuration Restart DHCP Service'''

[root@mdidhcpserver ~]# /etc/init.d/dhcpd restart
[root@mdidhcpserver ~]# chkconfig dhcpd on

'''Disable dhcpd6 service'''

[root@mdidhcpserver dhcp]# /etc/init.d/dhcpd6 stop
[root@mdidhcpserver dhcp]# chkconfig dhcpd6 off
---------------------------------------------------------------------------
'''Enabling log'''

[root@mdidhcpserver ~]# vim /etc/rsyslog.conf

Make below entry in rsyslog.conf file

# Save DHCP log
local5.* /var/log/dhcpd.log
---------------------------------------------------------------------------
'''Restart rsyslog service'''

[root@mdidhcpserver ~]# /etc/init.d/rsyslog status
rsyslogd (pid 1349) is running...
[root@mdidhcpserver ~]# /etc/init.d/rsyslog restart

MDI DHCP Server Implementation

2016-03-16T08:16:12Z

Brijesh:

[[category:MDI]]

'''MDI DHCP Server Implementation''':

OS Version RHEL 6.1 (x86_64)

ROOT Password : ghL@#W01GS

To access DHCP server logged in on MDI mail server with public IP (credential is on login sheet):

tetra@tetra004:~$ ssh root@14.141.218.163
root@14.141.218.163's password: "Type password"

Then access DHCP server from mail server:

[root@mailserver ~]# ssh root@192.168.1.10
root@192.168.1.10's password: "Type password"

---------------------------------------------------------------------------
'''Set the hostname'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network
---------------------------------------------------------------------------
NETWORKING=yes
HOSTNAME=mdidhcpserver
---------------------------------------------------------------------------

'''Set IP address'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
HWADDR=ec:b1:d7:3c:10:07
NM_CONTROLLED=no
ONBOOT=yes
IPADDR=192.168.1.10
NETMASK=255.255.0.0
GATEWAY=192.168.12.25
TYPE=Ethernet
BOOTPROTO=none
IPV6INIT=no
USERCTL=no

---------------------------------------------------------------------------

'''Restart network service:'''

[root@mdidhcpserver dhcp]# /etc/init.d/network restart
[root@mdidhcpserver dhcp]# chkconfig network on
[root@mdidhcpserver dhcp]# service NetworkManager stop
[root@mdidhcpserver dhcp]# chkconfig NetworkManager off

'''Flush the firewall rules:'''

[root@mdidhcpserver dhcp]# iptables -F
[root@mdidhcpserver dhcp]# service iptables stop
[root@mdidhcpserver dhcp]# chkconfig iptables off
---------------------------------------------------------------------------

'''Disable the selinux:'''

[root@mdidhcpserver dhcp]# setenforce 0

'''Disable selinux from file:'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/selinux

---------------------------------------------------------------------------

#This file controls the state of SELinux on the system.
#SELINUX= can take one of these three values:
#enforcing - SELinux security policy is enforced.
#permissive - SELinux prints warnings instead of enforcing.
#disabled - No SELinux policy is loaded.
SELINUX=disabled
#SELINUXTYPE= can take one of these two values:
#targeted - Targeted processes are protected,
#mls - Multi Level Security protection.
SELINUXTYPE=targeted

---------------------------------------------------------------------------
'''Install DHCP package'''

rpm -ivh dhcp-4.1.1-19.P1.el6.x86_64.rpm

'''Configuring DHCP Server'''

Edit configuration file and make below entries

[root@mdidhcpserver dhcp]# vim /etc/dhcp/dhcpd.conf

# DHCP Server Configuration file.
# see /usr/share/doc/dhcp*/dhcpd.conf.sample
# see 'man 5 dhcpd.conf'

log-facility local5;
authoritative;
subnet 192.168.0.0 netmask 255.255.0.0 {
range 192.168.13.1 192.168.24.254;
option domain-name-servers 192.168.10.83, 192.168.12.25;
option domain-name "mdi.ac.in";
option routers 192.168.12.25;
option broadcast-address 192.168.15.255;
default-lease-time 864000;
max-lease-time 1728000;
}
#host DESKTOP-NH1KCIO {
# hardware ethernet 44:8a:5b:72:53:b2;
# fixed-address 192.168.12.215;
#}
host DESKTOP-NH2KCIO { hardware ethernet B6:86:87:B2:FD:EC ; fixed-address 192.168.17.228;}
host DESKTOP-NH3KCIO { hardware ethernet B0:5A:DA:D6:9C:7D ; fixed-address 192.168.13.202;}
host DESKTOP-NH1KCIO {hardware ethernet 44:8a:5b:72:53:b2 ; fixed-address 192.168.12.215;}
host Tarun_mobile {hardware ethernet 98:0c:a5:18:bc:bd ;}
deny unknown-clients;

# Unknown clients get this pool.
subnet 169.254.0.0 netmask 255.255.0.0 {
option domain-name-servers ns1.example.com, ns2.example.com;
max-lease-time 300;
range 169.254.0.1 169.254.255.254;
allow unknown-clients;
}
include "/mac_address/NMP28_MAC_Responses.txt";
include "/mac_address/PGPM_2014.txt";
include "/mac_address/PGPM_2015.txt";
include "/mac_address/PGPIM_2014.txt";
include "/mac_address/PGPIM_2015.txt";
include "/mac_address/sap_2016.txt";
include "/mac_address/fpm_2015.txt";
include "/mac_address/Vendor.txt";
include "/mac_address/PGHR_2015.txt";
include "/mac_address/PGHR_2014.txt";
include "/mac_address/Faculty_Staff_Hostel_LH_LAB.txt";
include "/mac_address/PTPGPM.txt";

---------------------------------------------------------------------------
'''Assign the network interface:'''

[root@mdidhcpserver ~]# vim /etc/sysconfig/dhcpd

Make below entry:
DHCPDARGS=eth0

---------------------------------------------------------------------------
'''After configuration Restart DHCP Service'''

[root@mdidhcpserver ~]# /etc/init.d/dhcpd restart
[root@mdidhcpserver ~]# chkconfig dhcpd on

'''Disable dhcpd6 service'''

[root@mdidhcpserver dhcp]# /etc/init.d/dhcpd6 stop
[root@mdidhcpserver dhcp]# chkconfig dhcpd6 off
---------------------------------------------------------------------------
'''Enabling log'''

[root@mdidhcpserver ~]# vim /etc/rsyslog.conf

Make below entry in rsyslog.conf file

# Save DHCP log
local5.* /var/log/dhcpd.log
---------------------------------------------------------------------------
'''Restart rsyslog service'''

[root@mdidhcpserver ~]# /etc/init.d/rsyslog status
rsyslogd (pid 1349) is running...
[root@mdidhcpserver ~]# /etc/init.d/rsyslog restart

MDI DHCP Server Implementation

2016-03-16T08:13:34Z

Brijesh:

[[category:MDI]]

'''MDI DHCP Server Implementation''':

OS Version RHEL 6.1 (x86_64)

ROOT Password : ghL@#W01GS

To access DHCP server logged in on MDI mail server with public IP (credential is on login sheet):

tetra@tetra004:~$ ssh root@14.141.218.163
root@14.141.218.163's password: "Type password"

Then access DHCP server from mail server:

[root@mailserver ~]# ssh root@192.168.1.10
root@192.168.1.10's password: "Type password"

---------------------------------------------------------------------------
'''Set the hostname'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network
---------------------------------------------------------------------------
NETWORKING=yes
HOSTNAME=mdidhcpserver
---------------------------------------------------------------------------

'''Set IP address'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
HWADDR=ec:b1:d7:3c:10:07
NM_CONTROLLED=no
ONBOOT=yes
IPADDR=192.168.1.10
NETMASK=255.255.0.0
GATEWAY=192.168.12.25
TYPE=Ethernet
BOOTPROTO=none
IPV6INIT=no
USERCTL=no

---------------------------------------------------------------------------

'''Restart network service:'''

[root@mdidhcpserver dhcp]# /etc/init.d/network restart
[root@mdidhcpserver dhcp]# chkconfig network on
[root@mdidhcpserver dhcp]# service NetworkManager stop
[root@mdidhcpserver dhcp]# chkconfig NetworkManager off

'''Flush the firewall rules:'''

[root@mdidhcpserver dhcp]# iptables -F
[root@mdidhcpserver dhcp]# service iptables stop
[root@mdidhcpserver dhcp]# chkconfig iptables off
---------------------------------------------------------------------------

'''Disable the selinux:'''

[root@mdidhcpserver dhcp]# setenforce 0

'''Disable selinux from file:'''

[root@mdidhcpserver dhcp]# vim /etc/sysconfig/selinux

---------------------------------------------------------------------------

#This file controls the state of SELinux on the system.
#SELINUX= can take one of these three values:
#enforcing - SELinux security policy is enforced.
#permissive - SELinux prints warnings instead of enforcing.
#disabled - No SELinux policy is loaded.
SELINUX=disabled
#SELINUXTYPE= can take one of these two values:
#targeted - Targeted processes are protected,
#mls - Multi Level Security protection.
SELINUXTYPE=targeted

---------------------------------------------------------------------------
'''Install DHCP package'''

rpm -ivh dhcp-4.1.1-19.P1.el6.x86_64.rpm

'''Configuring DHCP Server'''

Edit configuration file and make below entries

[root@mdidhcpserver dhcp]# vim /etc/dhcp/dhcpd.conf

# DHCP Server Configuration file.
# see /usr/share/doc/dhcp*/dhcpd.conf.sample
# see 'man 5 dhcpd.conf'

log-facility local5;
authoritative;
subnet 192.168.0.0 netmask 255.255.0.0 {
range 192.168.13.1 192.168.24.254;
option domain-name-servers 192.168.10.83, 192.168.12.25;
option domain-name "mdi.ac.in";
option routers 192.168.12.25;
option broadcast-address 192.168.15.255;
default-lease-time 864000;
max-lease-time 1728000;
}

#host DESKTOP-NH1KCIO {
# hardware ethernet 44:8a:5b:72:53:b2;
# fixed-address 192.168.12.215;
#}
host DESKTOP-NH2KCIO { hardware ethernet B6:86:87:B2:FD:EC ; fixed-address 192.168.17.228;}
host DESKTOP-NH3KCIO { hardware ethernet B0:5A:DA:D6:9C:7D ; fixed-address 192.168.13.202;}
host DESKTOP-NH1KCIO {hardware ethernet 44:8a:5b:72:53:b2 ; fixed-address 192.168.12.215;}
host Tarun_mobile {hardware ethernet 98:0c:a5:18:bc:bd ;}

deny unknown-clients;

# Unknown clients get this pool.
subnet 169.254.0.0 netmask 255.255.0.0 {
option domain-name-servers ns1.example.com, ns2.example.com;
max-lease-time 300;
range 169.254.0.1 169.254.255.254;
allow unknown-clients;
}

include "/mac_address/NMP28_MAC_Responses.txt";
include "/mac_address/PGPM_2014.txt";
include "/mac_address/PGPM_2015.txt";
include "/mac_address/PGPIM_2014.txt";
include "/mac_address/PGPIM_2015.txt";
include "/mac_address/sap_2016.txt";
include "/mac_address/fpm_2015.txt";
include "/mac_address/Vendor.txt";
include "/mac_address/PGHR_2015.txt";
include "/mac_address/PGHR_2014.txt";
include "/mac_address/Faculty_Staff_Hostel_LH_LAB.txt";
include "/mac_address/PTPGPM.txt";

---------------------------------------------------------------------------
'''Assign the network interface:'''

[root@mdidhcpserver ~]# vim /etc/sysconfig/dhcpd

Make below entry:
DHCPDARGS=eth0

---------------------------------------------------------------------------
'''After configuration Restart DHCP Service'''

[root@mdidhcpserver ~]# /etc/init.d/dhcpd restart
[root@mdidhcpserver ~]# chkconfig dhcpd on

'''Disable dhcpd6 service'''

[root@mdidhcpserver dhcp]# /etc/init.d/dhcpd6 stop
[root@mdidhcpserver dhcp]# chkconfig dhcpd6 off
---------------------------------------------------------------------------
'''Enabling log'''

[root@mdidhcpserver ~]# vim /etc/rsyslog.conf

Make below entry in rsyslog.conf file

# Save DHCP log
local5.* /var/log/dhcpd.log
---------------------------------------------------------------------------
'''Restart rsyslog service'''

[root@mdidhcpserver ~]# /etc/init.d/rsyslog status
rsyslogd (pid 1349) is running...
[root@mdidhcpserver ~]# /etc/init.d/rsyslog restart

Zimbra Enabling Subject Line In logs

2016-02-22T15:05:43Z

Brijesh: Created page with "Category:Zimbra category:Triburg '''Adding Subject Information on the log''' If we want to see subject information in zimbra.logs then we can follow below steps: L..."

[[Category:Zimbra]]
[[category:Triburg]]

'''Adding Subject Information on the log'''

If we want to see subject information in zimbra.logs then we can follow below steps:

Logged in with zimbra user:
[root@mail ~]# su - zimbra

Run below commands to check current staus you will get below output:
[zimbra@mail ~]$ zmlocalconfig | grep header_checks
postfix_header_checks = pcre:${zimbra_home}/conf/postfix_header_checks

[zimbra@mail ~]$ postconf | grep header_checks
header_checks =
lmtp_header_checks =
lmtp_mime_header_checks =
lmtp_nested_header_checks =
mime_header_checks = $header_checks
nested_header_checks = $header_checks
smtp_header_checks =
smtp_mime_header_checks =
smtp_nested_header_checks =

Now create a file:
[zimbra@mail ~]$ vim /opt/zimbra/conf/custom_header_checks
Add below line in this file:
/^subject:/ WARN
'''Note:''' We can add our own header_checks in this file.

Then run below commands:

[zimbra@mail ~]$ zmlocalconfig -e postfix_header_checks="pcre:/opt/zimbra/conf/postfix_header_checks, pcre:/opt/zimbra/conf/custom_header_checks"
[zimbra@mail ~]$ zmmtactl restart
Rewriting configuration files...done.
Stopping zmmtaconfig...done.
Starting zmmtaconfig...done.
postfix/postfix-script: refreshing the Postfix mail system
Stopping saslauthd...done.
Starting saslauthd...done.

Now run again below commands to check configuration:

[zimbra@mail ~]$ zmlocalconfig | grep postfix_header_checks
postfix_header_checks = pcre:/opt/zimbra/conf/postfix_header_checks, pcre:/opt/zimbra/conf/custom_header_checks
[zimbra@mail ~]$ postconf | grep header_checks
header_checks = pcre:/opt/zimbra/conf/postfix_header_checks, pcre:/opt/zimbra/conf/custom_header_checks
lmtp_header_checks =
lmtp_mime_header_checks =
lmtp_nested_header_checks =
mime_header_checks = $header_checks
nested_header_checks = $header_checks
smtp_header_checks =
smtp_mime_header_checks =
smtp_nested_header_checks =

Run below command and restart the mta service:
[zimbra@mail ~]$ zmprov mcf zimbraMtaBlockedExtensionWarnRecipient FALSE
[zimbra@mail ~]$ zmmtactl restart
Rewriting configuration files...done.
Stopping zmmtaconfig...done.
Starting zmmtaconfig...done.
postfix/postfix-script: refreshing the Postfix mail system
Stopping saslauthd...done.
Starting saslauthd...done.

Ref_Link : [https://wiki.zimbra.com/wiki/King0770-Notes-Header-Checks]

2015-10-15T11:59:13Z

Brijesh:

[[category:Muthoot group]]

If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in

DB .If not able to login if postgre then frist check cluster service by below command:

Login on Database server(Local ip 192.168.1.133 node1)

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:36:08 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) failed'''

If State is failed then run below command to disable the cluster service:

clusvcadm -d Cluster-Service

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:38:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) Disabled'''

After that enable cluster service on node1 by below command:

clusvcadm -e Cluster-Service -m node1

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:45:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service node1 started'''

Now please run below commands to ensure if every thing is OK:

[root@liveserver ~]# ip addr

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: usb0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 36:40:b5:ad:d4:73 brd ff:ff:ff:ff:ff:ff
3: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:a8 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.133/24 brd 192.168.1.255 scope global eth0
inet '''192.168.1.140'''/24 scope global secondary eth0
inet6 fe80::3640:b5ff:feaa:e5a8/64 scope link
valid_lft forever preferred_lft forever
4: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:aa brd ff:ff:ff:ff:ff:ff
inet 10.0.0.1/24 brd 10.0.0.255 scope global eth1
inet6 fe80::3640:b5ff:feaa:e5aa/64 scope link
valid_lft forever preferred_lft forever

[root@liveserver ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-LogVol01 99G 68G 26G 73% /

tmpfs 16G 26M 16G 1% /dev/shm

/dev/sdd1 1008M 62M 895M 7% /boot

/dev/mapper/VolGroup-LogVol02 197G 150G 38G 80% /home

'''/dev/mapper/DB-test''' 97G 17G 75G 19% /Database

'''/dev/mapper/LogsSpace-LogSystem''' 195G 111G 75G 60% /var/lib/pgsql

[root@liveserver ~]# ps -ef | grep postgres

postgres 1725 32729 46 15:27 ? 00:17:29 postgres: postgres muthoot_test 192.168.1.130(47221) idle

postgres 6572 32729 0 16:04 ? 00:00:00 postgres: postgres muthoot_test 192.168.1.130(49492) idle

root 7407 6573 0 16:04 pts/0 00:00:00 grep postgres

postgres 9772 32729 41 14:38 ? 00:35:40 postgres: postgres muthoot_test 192.168.1.130(44132) SELECT

postgres 11070 32729 52 15:32 ? 00:17:05 postgres: postgres muthoot_test 192.168.1.130(47473) idle

postgres 11539 32729 24 15:32 ? 00:07:57 postgres: postgres muthoot_test 192.168.1.130(47475) idle

postgres 11542 32729 46 15:32 ? 00:15:11 postgres: postgres muthoot_test 192.168.1.130(47476) SELECT

postgres 11543 32729 47 15:32 ? 00:15:22 postgres: postgres muthoot_test 192.168.1.130(47477) SELECT

postgres 12137 32729 37 12:51 ? 01:12:30 postgres: postgres muthoot_test 192.168.1.130(37016) SELECT

postgres 13553 32729 53 13:28 ? 01:23:08 postgres: postgres muthoot_test 192.168.1.130(39619) SELECT

postgres 13578 32729 43 12:52 ? 01:23:07 postgres: postgres muthoot_test 192.168.1.130(37087) SELECT

postgres 15933 32729 37 14:41 ? 00:31:32 postgres: postgres muthoot_test 192.168.1.130(44303) idle

postgres 16240 32729 38 13:47 ? 00:52:21 postgres: postgres muthoot_test 192.168.1.130(40982) SELECT

Cluster issue Muthoot

2015-10-15T11:58:09Z

Brijesh:

[[category:Muthoot Group]]

If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in

DB .If not able to login if postgre then frist check cluster service by below command:

Login on Database server(Local ip 192.168.1.133 node1)

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:36:08 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) failed'''

If State is failed then run below command to disable the cluster service:

clusvcadm -d Cluster-Service

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:38:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) Disabled'''

After that enable cluster service on node1 by below command:

clusvcadm -e Cluster-Service -m node1

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:45:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service node1 started'''

Now please run below commands to ensure if every thing is OK:

[root@liveserver ~]# ip addr

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: usb0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 36:40:b5:ad:d4:73 brd ff:ff:ff:ff:ff:ff
3: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:a8 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.133/24 brd 192.168.1.255 scope global eth0
inet '''192.168.1.140'''/24 scope global secondary eth0
inet6 fe80::3640:b5ff:feaa:e5a8/64 scope link
valid_lft forever preferred_lft forever
4: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:aa brd ff:ff:ff:ff:ff:ff
inet 10.0.0.1/24 brd 10.0.0.255 scope global eth1
inet6 fe80::3640:b5ff:feaa:e5aa/64 scope link
valid_lft forever preferred_lft forever

[root@liveserver ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-LogVol01 99G 68G 26G 73% /

tmpfs 16G 26M 16G 1% /dev/shm

/dev/sdd1 1008M 62M 895M 7% /boot

/dev/mapper/VolGroup-LogVol02 197G 150G 38G 80% /home

'''/dev/mapper/DB-test''' 97G 17G 75G 19% /Database

'''/dev/mapper/LogsSpace-LogSystem''' 195G 111G 75G 60% /var/lib/pgsql

[root@liveserver ~]# ps -ef | grep postgres

postgres 1725 32729 46 15:27 ? 00:17:29 postgres: postgres muthoot_test 192.168.1.130(47221) idle

postgres 6572 32729 0 16:04 ? 00:00:00 postgres: postgres muthoot_test 192.168.1.130(49492) idle

root 7407 6573 0 16:04 pts/0 00:00:00 grep postgres

postgres 9772 32729 41 14:38 ? 00:35:40 postgres: postgres muthoot_test 192.168.1.130(44132) SELECT

postgres 11070 32729 52 15:32 ? 00:17:05 postgres: postgres muthoot_test 192.168.1.130(47473) idle

postgres 11539 32729 24 15:32 ? 00:07:57 postgres: postgres muthoot_test 192.168.1.130(47475) idle

postgres 11542 32729 46 15:32 ? 00:15:11 postgres: postgres muthoot_test 192.168.1.130(47476) SELECT

postgres 11543 32729 47 15:32 ? 00:15:22 postgres: postgres muthoot_test 192.168.1.130(47477) SELECT

postgres 12137 32729 37 12:51 ? 01:12:30 postgres: postgres muthoot_test 192.168.1.130(37016) SELECT

postgres 13553 32729 53 13:28 ? 01:23:08 postgres: postgres muthoot_test 192.168.1.130(39619) SELECT

postgres 13578 32729 43 12:52 ? 01:23:07 postgres: postgres muthoot_test 192.168.1.130(37087) SELECT

postgres 15933 32729 37 14:41 ? 00:31:32 postgres: postgres muthoot_test 192.168.1.130(44303) idle

postgres 16240 32729 38 13:47 ? 00:52:21 postgres: postgres muthoot_test 192.168.1.130(40982) SELECT

Cluster issue Muthoot

2015-10-15T11:07:10Z

Brijesh: Created page with "category:Muthoot If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in DB .If not abl..."

[[category:Muthoot]]

If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in

DB .If not able to login if postgre then frist check cluster service by below command:

Login on Database server(Local ip 192.168.1.133 node1)

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:36:08 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) failed'''

If State is failed then run below command to disable the cluster service:

clusvcadm -d Cluster-Service

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:38:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service (node2) Disabled'''

After that enable cluster service on node1 by below command:

clusvcadm -e Cluster-Service -m node1

Again run below command to check cluster status:

[root@liveserver ~]# clustat

Cluster Status for Muthoot_cluster @ Thu Oct 15 12:45:12 2015
Member Status: Quorate

Member Name ID Status
------ ---- ---- ------
node1 1 Online, Local, rgmanager
node2 2 Online, rgmanager
Service Name Owner (Last) State
------- ---- ----- ------ -----
'''service:Cluster-Service node1 started'''

Now please run below commands to ensure if every thing is OK:

[root@liveserver ~]# ip addr

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: usb0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 36:40:b5:ad:d4:73 brd ff:ff:ff:ff:ff:ff
3: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:a8 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.133/24 brd 192.168.1.255 scope global eth0
inet '''192.168.1.140'''/24 scope global secondary eth0
inet6 fe80::3640:b5ff:feaa:e5a8/64 scope link
valid_lft forever preferred_lft forever
4: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:aa brd ff:ff:ff:ff:ff:ff
inet 10.0.0.1/24 brd 10.0.0.255 scope global eth1
inet6 fe80::3640:b5ff:feaa:e5aa/64 scope link
valid_lft forever preferred_lft forever

[root@liveserver ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/VolGroup-LogVol01 99G 68G 26G 73% /

tmpfs 16G 26M 16G 1% /dev/shm

/dev/sdd1 1008M 62M 895M 7% /boot

/dev/mapper/VolGroup-LogVol02 197G 150G 38G 80% /home

'''/dev/mapper/DB-test''' 97G 17G 75G 19% /Database

'''/dev/mapper/LogsSpace-LogSystem''' 195G 111G 75G 60% /var/lib/pgsql

[root@liveserver ~]# ps -ef | grep postgres

postgres 1725 32729 46 15:27 ? 00:17:29 postgres: postgres muthoot_test 192.168.1.130(47221) idle

postgres 6572 32729 0 16:04 ? 00:00:00 postgres: postgres muthoot_test 192.168.1.130(49492) idle

root 7407 6573 0 16:04 pts/0 00:00:00 grep postgres

postgres 9772 32729 41 14:38 ? 00:35:40 postgres: postgres muthoot_test 192.168.1.130(44132) SELECT

postgres 11070 32729 52 15:32 ? 00:17:05 postgres: postgres muthoot_test 192.168.1.130(47473) idle

postgres 11539 32729 24 15:32 ? 00:07:57 postgres: postgres muthoot_test 192.168.1.130(47475) idle

postgres 11542 32729 46 15:32 ? 00:15:11 postgres: postgres muthoot_test 192.168.1.130(47476) SELECT

postgres 11543 32729 47 15:32 ? 00:15:22 postgres: postgres muthoot_test 192.168.1.130(47477) SELECT

postgres 12137 32729 37 12:51 ? 01:12:30 postgres: postgres muthoot_test 192.168.1.130(37016) SELECT

postgres 13553 32729 53 13:28 ? 01:23:08 postgres: postgres muthoot_test 192.168.1.130(39619) SELECT

postgres 13578 32729 43 12:52 ? 01:23:07 postgres: postgres muthoot_test 192.168.1.130(37087) SELECT

postgres 15933 32729 37 14:41 ? 00:31:32 postgres: postgres muthoot_test 192.168.1.130(44303) idle

postgres 16240 32729 38 13:47 ? 00:52:21 postgres: postgres muthoot_test 192.168.1.130(40982) SELECT