OpenVPMS password not working

Submitted by Guest on Wed, 28/07/2010 - 23:36

Implementation discussion

Hello OpenVPMS community,

Longtime admirer, short term user here!

I'm dabbling with OpenVPMS, and finding it very satisfactory. I have installed version 1.4 onto a Ubuntu 10.04 AMD64 system using your installation guides. Everything went eerily smoothly up until I reached the login stage at http://localhost:8080/openvpms/ . Here I am presented with the green
OpenVPMS User/Password screen.

I understand the default username and password is admin and admin, however this doesn't work for me. I have tried my root mysql password, tomcat6 password and various combinations of admin/passwords.

Is there any way to reset the password to default or new values? I have PHPMyadmin and the mysql-client command line package available.

Regards,

Damien

Re: New Implementation discussion Forum topic: OpenVPMS password

Submitted by Matt Young on Thu, 29/07/2010 - 00:00.

Hi Damien,

It sounds like you haven't run the dataload script in the bin
directory of the 1.4 download package or it didn't work.

You will need to have the mysql connector in the library in the
downloaded package first- I use a symlink to do this. See the document
loader setup for ubuntu documentation for how to do it.

The scripts in the bin aren't executable when you download them. Cd to
the bin and then do chmod +x *.sh

Then do ./dataload.sh setup (you need to be in the directory to do this)

Hope that helps,
Matt Young

Re: New Implementation discussion Forum topic: OpenVPMS password

Submitted by dsolley (not verified) on Thu, 29/07/2010 - 01:33.

Hi guys,

Thanks for the fast reply!

I have double checked the mysql-connector softlinks, and dropped and re-added the openvpms database.

Now, I ran "./dataload.sh setup", it gave me a lot of error output. Output is attached, I can't make much of it!

Thanks in advance,

Damien

Attachment	Size
error.log_.txt	8.09 KB

Re: New or updated comment for Implementation discussion Forum t

Submitted by Matt Young on Thu, 29/07/2010 - 08:00.

You haven't set up the mysql connector properly, either it's not in
the right location or doesn't have correct permissions. Can you show
me the output of ls -l the library folder of the downloaded 1.4
package?

Matt Young

Re: New or updated comment for Implementation discussion Forum t

Submitted by dsolley (not verified) on Thu, 29/07/2010 - 11:09.

Hi Matt,

You have set me on the right track. I've sorted out the mysql-connector softlinks and all is working normally.

I think I may have stumbled in the OpenVPMS Ubuntu install page, as it doesn't mention softlinking the connector into $JRE_HOME, ie:

# ln -s /usr/share/java/mysql-connector-java-5.1.10.jar /usr/lib/jvm/java-6-openjdk/jre/lib/ext/mysql-connector-java.jar

I will continue exploring the system. Thanks again!

Damien

Re: New or updated comment for Implementation discussion Forum t

Submitted by davidwu (not verified) on Mon, 18/04/2011 - 04:16.

I encountered similar problem installing onto Ubuntu server following the relevant guide.

Problem fixed after reading this thread. I wrote a simple script to make it easier for newbies and for future mysql-connector upgrade. I call the script mysql_connector_softlink.sh

Thanks for the excellent openvpms work.

*****

#!/bin/sh

# OS specific support

case "`uname`" in

Linux)

case "`uname -v`" in

*Ubuntu*)

DEST_DIRS="/usr/share/tomcat6/lib /usr/lib/jvm/java-6-openjdk/jre/lib/ext"

for CONNECTOR in `ls /usr/share/java/mysql-connector*.jar`

if ! test -L $CONNECTOR; then

for DEST in $DEST_DIRS

ln -s -f -v $CONNECTOR $DEST/mysql-connector-java.jar

done

;;

esac

;;

esac