Unable to run mysql on Standalone version

herbertsural · May 21, 2021, 4:20am

[MysqldResource] launching mysqld (driver_launched_mysqld_1) 210521 4:18:27 [ERROR] Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root!

210521 4:18:27 [ERROR] Aborting

210521 4:18:27 [Note] /opt/referenceapplication-standalone-2.11.0/database/bin/mysqld: Shutdown complete

herbert24 · May 21, 2021, 4:29am

make sure you start mysql as a root for example on ubuntu , sudo /usr/local/mysql/support-files/mysql.server start

herbertsural · May 21, 2021, 4:39am

@herbert24 thanks for the response.

Im just new on OpenMRS. Im trying to install the standalone version which compose of the following.

I think the standalone version has its own mysql and tomcat.

Trying to follow this documentation as ubuntu version. https://wiki.openmrs.org/display/docs/OpenMRS+Standalone

Do i still need to install MySQL?

adding @keithduddy

Thank You!

herbert24 · May 21, 2021, 4:44am

sorry, i hadnt considered this (standalone),standalone comes with an emebedded database, what happens if you log in to your pc as an admin and run the standalone jar file?

herbertsural · May 21, 2021, 4:48am

hi @herbert24

Please see image below after running

run-on-unix.sh (inside run-on-unix.sh)

#!/bin/bash

java -jar openmrs-standalone.jar -commandline -noninteractive

Thank You!

herbertsural · May 21, 2021, 4:51am

@herbert24

i also tried to connect on mysql

i tried this solution below but still getting the error.

If you try connecting to the MySQL server from commandline and get this error message: " ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ":
- Add this " &server.socket=/tmp/openmrs.sock " (without the double quotes) at the end of the value in the connection.url key of the runtime properties file, and then restart the standalone application. If after doing that, you still get the same error message, then on your command line, add this: --socket=/tmp/openmrs.sock
- Then you can connect with something like: ./mysql -u openmrs -p --socket=/tmp/openmrs.sock

Thank You!

dkayiwa · May 22, 2021, 9:47pm

Can you try to run the standalone again when not logged in as root? By the way, which operating system are you running?

herbertsural · May 26, 2021, 12:51am

hi @dkayiwa thanks for the response. I am using ubuntu 20.04 LTS.

herbertsural · May 26, 2021, 5:16am

Hi @herbert24 @dkayiwa

I manage to resolve this issue by doing this on scratch.

I have another when running this.

Can you help me to resolve this kind of issue.

Thank You!

herbert24 · May 26, 2021, 6:40am

add the full server logs here https://pastebin.com/

herbertsural · May 27, 2021, 12:15am

@herbert24

Please see above link for the logs.

Thank You!