OpenMRS standalone - MySQL binaries

lluismf · May 11, 2015, 10:09pm

I just downloaded the openmrs-standalone zip and uncompressed it, but I can’t see where the MySQL binaries are (I have to replace them by the MariaDB counterparts).

However if I run it the folder database magically appears. But this prevents me to check if the installation works with the MariaDB binaries. It’s a Catch-22 situation

So the answer is: how can I replace those binaries without installing it?

darius · May 12, 2015, 5:52pm

@lluismf, didn’t you say that you had already installed mariadb locally? Can’t you just change the runtime properties file to point to your local db, instead of the standalone one?

The standalone uses some magical (no longer supported) “mxj” connector that you don’t want to muck with if you can avoid it.

lluismf · May 12, 2015, 10:43pm

Yes, I have MariaDB installed (I dropped the openmrs schema created via the legacy webapp a few days ago).

I changed the standalone runtime properties like this:

 connection.url=jdbc:mysql://localhost:3306/openmrs?...

But when running the standalone it throws an exception:

Opening MySQL connection to create openmrs/test users
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

After that I created the user openmrs password test with the HeidiSQL interpreter but no success, same exception.

Even if I put connection user root and pwd in the properties file, it keeps using openmrs/test … apparently.

gwasilwa · June 8, 2015, 10:47am

From:

… the default database name was changed to be the same as the web application name. Unless you are running openmrs standalone in Expert Mode the database will default to openmrs-standalone.

raff · June 8, 2015, 1:36pm

@lluismf, looking at

github.com

openmrs/openmrs-standalone/blob/master/src/main/java/org/openmrs/standalone/ApplicationController.java

/**
 * The contents of this file are subject to the OpenMRS Public License
 * Version 1.0 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://license.openmrs.org
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 *
 * Copyright (C) OpenMRS, LLC.  All Rights Reserved.
 */
package org.openmrs.standalone;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileWriter;

This file has been truncated. show original

… it seems that the standalone is not prepared to simply use a different database. Some changes in that code may be required.

lluismf · June 8, 2015, 10:44pm

Thanks Geoffrey and Rafal, I ended up updating the MySQL binaries as pointed out by Daniel (instead of modifying the source code). It was kind of a hack but it worked.