Brijesh at 11:59, 15 October 2015

2015-10-15T11:59:13Z

← Older revision		Revision as of 11:59, 15 October 2015
Line 1:		Line 1:
	[[category:Muthoot ~~Group~~]]		[[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		If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in

Brijesh at 11:58, 15 October 2015

2015-10-15T11:58:09Z

← Older revision		Revision as of 11:58, 15 October 2015
Line 1:		Line 1:
	[[category:Muthoot]]		[[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		If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in

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..."

2015-10-15T11:07:10Z

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..."

New page

[[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

Cluster issue Muthoot - Revision history

Brijesh at 11:59, 15 October 2015

Brijesh at 11:58, 15 October 2015

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..."