Dear All,
When I try to login in Bahmni EMR then the locations are not populated so I am unable to login… I tried to restart the mysql service but no luck… Any inputs on this on what to do like should I upgrade the MySQL or so? Kindly help.
MySQL version :
[root@localhost-localdomain ~]# mysql --version mysql Ver 14.14 Distrib 5.7.38, for Linux (x86_64) using EditLine wrapper
When I try to start mysql service →
[root@localhost-localdomain ~]# systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: activating (start) since Mon 2022-06-06 15:20:36 IST; 947ms ago Docs: man:mysqld(8) MySQL :: MySQL 8.0 Reference Manual :: 2.5.9 Managing MySQL Server with systemd Process: 7154 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Control: 7177 (mysqld) Tasks: 14 CGroup: /system.slice/mysqld.service ├─7177 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid └─7180 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Jun 06 15:20:36 localhost-localdomain systemd[1]: Starting MySQL Server… [root@localhost-localdomain ~]# journalctl -xe Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: background-color: #E9E4CC; Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: -moz-border-radius: 5px; Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: -webkit-border-radius: 5px; Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: \u0009\u0009\u0009\u0009} Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: .y"[truncated 7139 chars]; line: 1, column: 2] Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:2391) ~[jackson-core-2.13.1.jar:2.13.1] Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:735) ~[jackson-core-2.1 Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.core.base.ParserMinimalBase._reportUnexpectedChar(ParserMinimalBase.java:659) ~[jackson Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._handleOddValue(ReaderBasedJsonParser.java:2005) ~[jack Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.nextToken(ReaderBasedJsonParser.java:802) ~[jackson-cor Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:4761) ~[jackson-databind-2.13.1 Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4667) ~[jackson-databind-2.13. Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3629) ~[jackson-databind-2.13.1.jar:2 Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:3597) ~[jackson-databind-2.13.1.jar:2 Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: at org.bahmni.webclients.openmrs.OpenMRSLoginAuthenticator.refreshRequestDetails(OpenMRSLoginAuthenticator.java: Jun 06 15:21:30 localhost-localdomain bahmni-erp-connect[1083]: … 16 more Jun 06 15:21:31 localhost-localdomain systemd[1]: Failed to start MySQL Server. – Subject: Unit mysqld.service has failed – Defined-By: systemd – Support: systemd-devel Info Page
– Unit mysqld.service has failed.
– The result is failed. Jun 06 15:21:31 localhost-localdomain systemd[1]: Unit mysqld.service entered failed state. Jun 06 15:21:31 localhost-localdomain systemd[1]: mysqld.service failed. Jun 06 15:21:31 localhost-localdomain systemd[1]: mysqld.service holdoff time over, scheduling restart. Jun 06 15:21:31 localhost-localdomain systemd[1]: Stopped MySQL Server. – Subject: Unit mysqld.service has finished shutting down – Defined-By: systemd – Support: systemd-devel Info Page
– Unit mysqld.service has finished shutting down. Jun 06 15:21:31 localhost-localdomain systemd[1]: Starting MySQL Server… – Subject: Unit mysqld.service has begun start-up – Defined-By: systemd – Support: systemd-devel Info Page
– Unit mysqld.service has begun starting up. Jun 06 15:21:32 localhost-localdomain mysqld[8206]: Initialization of mysqld failed: 0 Jun 06 15:21:32 localhost-localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1