MySQL service doesnt start when Openmrs starts

Software Bahmni
1

Hello Team, I have successfully installed Bahmni on CentOS 6 any time i start openmrs MySQL goes dead. Please i need help ASAP

below is the service status

[root@doc ~]# sudo service --status-all acpid (pid 1199) is running… atomfeed-console is running with pid: 1344 Service bahmni-erp-connect is running with pid: 1362 Service bahmni-lab is running with pid: 1380 Service bahmni-reports is running with pid: 1401 crond (pid 2048) is running… htcacheclean is stopped httpd (pid 2021) is running… Table: filter Chain INPUT (policy ACCEPT) num target prot opt source destination 1 ACCEPT all ::/0 ::/0 state RELATED,ESTABLISHED 2 ACCEPT icmpv6 ::/0 ::/0 3 ACCEPT all ::/0 ::/0 4 ACCEPT udp ::/0 fe80::/64 state NEW udp dpt:546 5 ACCEPT tcp ::/0 ::/0 state NEW tcp dpt:22 6 REJECT all ::/0 ::/0 reject-with icmp6-adm-prohibited

Chain FORWARD (policy ACCEPT) num target prot opt source destination 1 REJECT all ::/0 ::/0 reject-with icmp6-adm-prohibited

Chain OUTPUT (policy ACCEPT) num target prot opt source destination

Table: filter Chain INPUT (policy DROP) num target prot opt source destination 1 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:8059 /* ATOMFEED_CONSOLE / 2 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:8069 / BAHMNIERP / 3 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:5432 / POSTGRES / 4 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:8052 / BAHMNILAB / 5 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:8051 / BAHMNIREPORTS / 6 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:3306 / MYSQL / 7 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:8050 / OPENMRS / 8 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:443 / https / 9 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:80 / WEB SERVER / 10 ACCEPT all – 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED 11 ACCEPT icmp – 0.0.0.0/0 0.0.0.0/0 12 ACCEPT all – 0.0.0.0/0 0.0.0.0/0 13 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:22 14 REJECT all – 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited 15 ACCEPT all – 0.0.0.0/0 0.0.0.0/0 / lo / 16 ACCEPT tcp – 0.0.0.0/0 0.0.0.0/0 tcp dpt:22 / SSH */

Chain FORWARD (policy DROP) num target prot opt source destination 1 REJECT all – 0.0.0.0/0 0.0.0.0/0 reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT) num target prot opt source destination

Checking jexec statusKdump is operational mdmonitor is stopped messagebus (pid 1161) is running… mysqld dead but subsys locked netconsole module not loaded Configured devices: lo eth0 Currently active devices: lo eth0 grep: /proc/fs/nfsd/portlist: No such file or directory ntpd (pid 1329) is running… openerp-server is running… Service openmrs is running with pid: 1866 master (pid 2006) is running… postgresql-9.2 (pid 1909) is running… rdisc is stopped Low level hardware support loaded: none found

Upper layer protocol modules: ib_ipoib

User space access modules: rdma_ucm ib_ucm ib_uverbs ib_umad

Connection management modules: rdma_cm ib_cm iw_cm

Configured IPoIB interfaces: none Currently active IPoIB interfaces: none rsyslogd (pid 1139) is running… sandbox is stopped saslauthd is stopped openssh-daemon (pid 1318) is running…

2

Moved to #software:bahmni category

3

Hi @anetey, Does the CentOS machine has minimum 4GB of RAM ?? I could see only few of the services are up and running from you logs.

4

My memory is not up to 4GB below is the memory info MemTotal: 1922076 kB MemFree: 76096 kB Buffers: 29348 kB Cached: 356316 kB SwapCached: 0 kB Active: 1559856 kB Inactive: 198988 kB Active(anon): 1384220 kB Inactive(anon): 22060 kB Active(file): 175636 kB Inactive(file): 176928 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 0 kB SwapFree: 0 kB Dirty: 332 kB Writeback: 0 kB AnonPages: 1373156 kB Mapped: 51812 kB Shmem: 33100 kB Slab: 44020 kB SReclaimable: 19952 kB SUnreclaim: 24068 kB KernelStack: 3584 kB PageTables: 15624 kB NFS_Unstable: 0 kB Bounce: 0 kB WritebackTmp: 0 kB CommitLimit: 961036 kB Committed_AS: 2346536 kB VmallocTotal: 34359738367 kB VmallocUsed: 10952 kB VmallocChunk: 34359721392 kB HardwareCorrupted: 0 kB AnonHugePages: 761856 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB DirectMap4k: 8048 kB DirectMap2M: 2088960 kB

5

I have increased the memory on the machine but openmrs fails after login The service stops… However when i start the service and open Bahmni EMR it works. but fails if i connect to openmrs directly. does it have to do with my java version running on my machine?

Please help…

6

I doubt that (Java Version)! How do you know Bahmni works? Have you logged in and checked if you can create a patient for example?

Also the first message said that mysql is dead. Can you try restarting mysql?