Logging in to OpenVPMS Web App for first time

Submitted by Guest on Tue, 17/06/2008 - 06:22

General User's Discussion

Hi There:

I followed Tony's instructions to get the database setup for MySQL on FreeBSD. That went good. However, now that I'm trying to sign in to the app for the first time, it's not letting me in.

I get the logon dialog box, I put in "admin" (without quotes) for both username and password, but the prompt just keeps coming back to me.

Here's the ourput from my catalina.out file:

[WARN,LoggerListener,http-8180-Processor24] Authentication event AuthenticationFailureBadCredentialsEvent: admin; details: org.acegisecurity.ui.WebAuthenticationDetails@a415f2: RemoteIpAddress: 10.1.1.17; SessionId: 05CADF7F2572A0623FBB3F50DC5DB01A; exception: Bad credentials

Any help would be appreciated...

Fred

Logging in to OpenVPMS Web App for first time

Submitted by fschnittke (not verified) on Tue, 17/06/2008 - 07:27.

Hi:

I've noticed that the openvpms.war file ( at least the one that I have) appears to have been created in a dos environment.

When I copy it over to the tomcat webapp folder, the text files in the openvpms directory contain ^M line or carriage return characters.

I've changed some manually, but there are too many.

Is there an openvpms.war file for UNIX environments?

Regards,

Fred

RE: Logging in to OpenVPMS Web App for first time

Submitted by Tony De Keizer (not verified) on Tue, 17/06/2008 - 09:01.

Hi Fred,

The war file is platform independent so works equally well on windows, linux, Mac or Unix platforms.

Cheers Tony

RE: Logging in to OpenVPMS Web App for first time

Submitted by Tony De Keizer (not verified) on Tue, 17/06/2008 - 09:01.

Hi Fred,

I would gues you have not loaded the base data which includes the base users.

Did you complete the

./dataload.sh base

step. ?

Did it complete succesfully or get an error ?

Cheers Tony

Re: Logging in to OpenVPMS Web App for first time

Submitted by tanderson on Tue, 17/06/2008 - 12:01.

You need to load the base data in order to get the default users.
In the installation bin directory type:
> dataload.sh base

This really should occur automatically when you run:
> dataload.sh setup

I'll fix it for the 1.2 release.

-Tim

fschnittke[at]execulink[dot]com wrote:
> Hi There:
>
> I followed Tony's instructions to get the database setup for MySQL on
> FreeBSD. That went good. However, now that I'm trying to sign in to
> the app for the first time, it's not letting me in.
>
> I get the logon dialog box, I put in "admin" (without quotes) for both
> username and password, but the prompt just keeps coming back to me.
>
> Here's the ourput from my catalina.out file:
>
> [WARN,LoggerListener,http-8180-Processor24] Authentication event
> AuthenticationFailureBadCredentialsEvent: admin; details:
> org.acegisecurity.ui.WebAuthenticationDetails@a415f2: RemoteIpAddress:
> 10.1.1.17; SessionId: 05CADF7F2572A0623FBB3F50DC5DB01A; exception: Bad
> credentials
>
>
> Any help would be appreciated...
>
>
> Fred

_______________________________________________
OpenVPMS User Mailing List
users[at]lists.openvpms[dot]org
To unsubscribe or change your subscription visit:
http://lists.openvpms.org/mailman/listinfo/users

Re: Logging in to OpenVPMS Web App for first time

Submitted by tanderson on Tue, 17/06/2008 - 12:01.

Ignore that last post. The script is fine. If you run the dataload.sh script it will load an 'admin' and 'vet' user when either the 'base' or 'setup' arguments are specified.

-Tim

fschnittke@execulink.com wrote:

> Hi There: > > I followed Tony's instructions to get the database setup for MySQL on > FreeBSD. That went good. However, now that I'm trying to sign in to > the app for the first time, it's not letting me in. > > I get the logon dialog box, I put in "admin" (without quotes) for both > username and password, but the prompt just keeps coming back to me. > > Here's the ourput from my catalina.out file: > > [WARN,LoggerListener,http-8180-Processor24] Authentication event > AuthenticationFailureBadCredentialsEvent: admin; details: > org.acegisecurity.ui.WebAuthenticationDetails@a415f2: RemoteIpAddress: > 10.1.1.17; SessionId: 05CADF7F2572A0623FBB3F50DC5DB01A; exception: Bad > credentials > > > Any help would be appreciated... > > > Fred > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users >

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

Re: Logging in to OpenVPMS Web App for first time - Resolved

Submitted by fschnittke (not verified) on Wed, 18/06/2008 - 00:09.

Hi Tim, Tony:

Initially I ran dataload.sh setup, and it ran without any problems, but as you pointed out it doesn't load the default users. So now when I try to run dataload.sh base (or setup for that matter), I'm getting the following error message:

Exception in thread "main" java.lang.NoClassDefFoundError: org/openvpms/tools/data/loader/StaxArchetypeDataLoader

If I run archload.sh I get:

Exception in thread "main" java.lang.NoClassDefFoundError: org/openvpms/tools/archetype/loader/ArchetypeLoader

I think I'll try it once more from the beginning.....

I've since found the reason I was getting NoClassDefFoundError: was because I like to use the ls commands with the -G option to enable color. Usually I turn this off in my .cshrc file. After the initial installation I had turned it back on. That's what was causing the problem running dataload the second time around.

As it stands now, I'm in.

Thanks for your help...

Fred

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Sun, 22/03/2009 - 05:46.

hi, I have the same problem. When I run dataload.sh base or dataload.sh setup I can see that:

gij: unrecognized option -- `-c' Try `gij --help' for more information.

???

Re: Re: Logging in to OpenVPMS Web

Submitted by tanderson on Sun, 22/03/2009 - 11:01.

The 'gij' is the GNU Interpreter for Java, which I have no experience in using. The dataload.sh script invokes 'java' so I'm guessing java is an alias or symlink to gij on your machine? In any case, it appears to be intercepting the command line arguments intended for the data load tool.

OpenVPMS requires Java 5 so your best bet is to try and install a Sun JVM for machine.

If there isn't one available, try editing the script and quoting the parameters e.g: Change: java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000

To: java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000;

And try doing the same for the setup line - although this will load australian postcodes which you probably don't want.

-Tim

dr.st.todorov@mail.bg wrote:

> > hi, I have the same problem. When I run dataload.sh base or > dataload.sh setup I can see that: > gij: unrecognized option -- `-c' > Try `gij --help' for more information. > > ??? > > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in > the OpenVPMS User's forum- http://tinyurl.com/openvfu >

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Re: Re: Logging in to OpenVPMS Web

Submitted by Ken Jacobs (not verified) on Mon, 23/03/2009 - 22:01.

Dear List

I have also had no success in installing Open VPMS. I have downloaded the java file and the VPMS file placed them into a single folder as directed but still no luck. When I install my sql there is an error indicating that the application is not supported by the processor type. I cant open the GZ file type

I am running Vista 64 bit system

Is there a simple set of installation instructions?

Thanks

Ken

Tim Anderson wrote:

> The 'gij' is the GNU Interpreter for Java, which I have no experience > in using. > The dataload.sh script invokes 'java' so I'm guessing java is an alias > or symlink to gij on your machine? > In any case, it appears to be intercepting the command line arguments > intended for the data load tool. > > OpenVPMS requires Java 5 so your best bet is to try and install a Sun > JVM for machine. > > If there isn't one available, try editing the script and quoting the > parameters e.g: > Change: > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000 > > To: > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c > ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; > > And try doing the same for the setup line - although this will load > australian postcodes which you probably don't want. > > -Tim > > > dr.st.todorov@mail.bg wrote: >> >> hi, I have the same problem. When I run dataload.sh base or >> dataload.sh setup I can see that: >> gij: unrecognized option -- `-c' >> Try `gij --help' for more information. >> >> ??? >> >> >> >> _______________________________________________ >> OpenVPMS User Mailing List >> users@lists.openvpms.org >> To unsubscribe or change your subscription visit: >> http://lists.openvpms.org/mailman/listinfo/users >> Posts from this mailing list can be viewed online and replied to in >> the OpenVPMS User's forum- http://tinyurl.com/openvfu >> > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in > the OpenVPMS User's forum- http://tinyurl.com/openvfu >

Re: Re: Logging in to OpenVPMS Web

Submitted by tanderson on Mon, 23/03/2009 - 23:01.

Need some more information: You say: "When I install my sql there is an error indicating that the application is not supported by the processor type." Try downloading and installing the MySQL server for Windows x64. http://dev.mysql.com/downloads/mysql/5.0.html#winx64

You say: "I cant open the GZ file type" What file are you referring to? A gz file is a file that has been compressed by the GNU zip program. I think WinZip will decompress it for you.

-Tim

Ken Jacobs wrote:

Re: Re: Logging in to OpenVPMS Web

Submitted by Tony De Keizer (not verified) on Mon, 23/03/2009 - 23:01.

Hi Ken,

Agree may need some more information in order to help you. Can you tell us what steps of the install instructions found at

http://www.openvpms.org/openvpms-installation-windows

have you managed to complete successfully ?

Cheers Tony

On 23/03/09 7:14 PM, "Ken Jacobs" :

> Dear List > > I have also had no success in installing Open VPMS. I have downloaded > the java file and the VPMS file placed them into a single folder as > directed but still no luck. When I install my sql there is an error > indicating that the application is not supported by the processor type. > I cant open the GZ file type > > I am running Vista 64 bit system > > Is there a simple set of installation instructions? > > Thanks > > Ken > > Tim Anderson wrote: >> The 'gij' is the GNU Interpreter for Java, which I have no experience >> in using. >> The dataload.sh script invokes 'java' so I'm guessing java is an alias >> or symlink to gij on your machine? >> In any case, it appears to be intercepting the command line arguments >> intended for the data load tool. >> >> OpenVPMS requires Java 5 so your best bet is to try and install a Sun >> JVM for machine. >> >> If there isn't one available, try editing the script and quoting the >> parameters e.g: >> Change: >> java -classpath $CLASSPATH >> org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c >> ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000 >> >> To: >> java -classpath $CLASSPATH >> org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c >> ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; >> >> And try doing the same for the setup line - although this will load >> australian postcodes which you probably don't want. >> >> -Tim >> >> >> dr.st.todorov@mail.bg wrote: >>> >>> hi, I have the same problem. When I run dataload.sh base or >>> dataload.sh setup I can see that: >>> gij: unrecognized option -- `-c' >>> Try `gij --help' for more information. >>> >>> ??? >>> >>> >>> >>> _______________________________________________ >>> OpenVPMS User Mailing List >>> users@lists.openvpms.org >>> To unsubscribe or change your subscription visit: >>> http://lists.openvpms.org/mailman/listinfo/users >>> Posts from this mailing list can be viewed online and replied to in >>> the OpenVPMS User's forum- http://tinyurl.com/openvfu >>> >> >> _______________________________________________ >> OpenVPMS User Mailing List >> users@lists.openvpms.org >> To unsubscribe or change your subscription visit: >> http://lists.openvpms.org/mailman/listinfo/users >> Posts from this mailing list can be viewed online and replied to in >> the OpenVPMS User's forum- http://tinyurl.com/openvfu >> > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

Re: Re: Logging in to OpenVPMS Web

Submitted by Ken Jacobs (not verified) on Wed, 25/03/2009 - 08:01.

I have downloaded as belew but can't open the open VPMS

Ken

Tony De Keizer wrote:

> Hi Ken, > > Agree may need some more information in order to help you. Can you tell us > what steps of the install instructions found at > > http://www.openvpms.org/openvpms-installation-windows > > have you managed to complete successfully ? > > Cheers > Tony > > > > On 23/03/09 7:14 PM, "Ken Jacobs" : > > >> Dear List >> >> I have also had no success in installing Open VPMS. I have downloaded >> the java file and the VPMS file placed them into a single folder as >> directed but still no luck. When I install my sql there is an error >> indicating that the application is not supported by the processor type. >> I cant open the GZ file type >> >> I am running Vista 64 bit system >> >> Is there a simple set of installation instructions? >> >> Thanks >> >> Ken >> >> Tim Anderson wrote: >> >>> The 'gij' is the GNU Interpreter for Java, which I have no experience >>> in using. >>> The dataload.sh script invokes 'java' so I'm guessing java is an alias >>> or symlink to gij on your machine? >>> In any case, it appears to be intercepting the command line arguments >>> intended for the data load tool. >>> >>> OpenVPMS requires Java 5 so your best bet is to try and install a Sun >>> JVM for machine. >>> >>> If there isn't one available, try editing the script and quoting the >>> parameters e.g: >>> Change: >>> java -classpath $CLASSPATH >>> org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c >>> ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000 >>> >>> To: >>> java -classpath $CLASSPATH >>> org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c >>> ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; >>> >>> And try doing the same for the setup line - although this will load >>> australian postcodes which you probably don't want. >>> >>> -Tim >>> >>> >>> dr.st.todorov@mail.bg wrote: >>> >>>> >>>> hi, I have the same problem. When I run dataload.sh base or >>>> dataload.sh setup I can see that: >>>> gij: unrecognized option -- `-c' >>>> Try `gij --help' for more information. >>>> >>>> ??? >>>> >>>> >>>> >>>> _______________________________________________ >>>> OpenVPMS User Mailing List >>>> users@lists.openvpms.org >>>> To unsubscribe or change your subscription visit: >>>> http://lists.openvpms.org/mailman/listinfo/users >>>> Posts from this mailing list can be viewed online and replied to in >>>> the OpenVPMS User's forum- http://tinyurl.com/openvfu >>>> >>>> >>> _______________________________________________ >>> OpenVPMS User Mailing List >>> users@lists.openvpms.org >>> To unsubscribe or change your subscription visit: >>> http://lists.openvpms.org/mailman/listinfo/users >>> Posts from this mailing list can be viewed online and replied to in >>> the OpenVPMS User's forum- http://tinyurl.com/openvfu >>> >>> >> _______________________________________________ >> OpenVPMS User Mailing List >> users@lists.openvpms.org >> To unsubscribe or change your subscription visit: >> http://lists.openvpms.org/mailman/listinfo/users >> Posts from this mailing list can be viewed online and replied to in the >> OpenVPMS User's forum- http://tinyurl.com/openvfu >> > > > >

Re: Re: Logging in to OpenVPMS Web

Submitted by Tony De Keizer (not verified) on Sun, 22/03/2009 - 11:01.

Hi,

Looks like you are using the GNU interpreter for Java rather than a standard java 1.5 or 1/6 JRE install. Have not tried this before and I would say the command line parameters being passed in the dataload.sh script are being mixed up between gij and the invoked java class.

I would suggest using a standard java JRE installation on the box if possible ?

Cheers Tony

On 22/03/09 5:46 AM, "dr.st.todorov@mail.bg" :

> > hi, I have the same problem. When I run dataload.sh base or dataload.sh > setup I can see that: > gij: unrecognized option -- `-c' > Try `gij --help' for more information. > > ??? > > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Mon, 23/03/2009 - 09:19.

tenks !

I have Java instaling in usr/local/java/jre1.5.0_17 but I can not set environment variable and the systems don't now there is java.

I set

export PATH=/usr/share/java/jdk1.5.0/bin:$PATH
export JRE_HOME=/usr/local/java/jre1.5.0_17

in my .bash_profile but that not work!

Any ideas! I'm new in Linux and English - Sorry!!!

Re: Re: Logging in to OpenVPMS Web

Submitted by tanderson on Mon, 23/03/2009 - 12:01.

You have two different paths there: /usr/share/java/jdk1.5.0/ and /usr/local/java/jre1.5.0_17

Set JAVA_HOME to point to /usr/share/java/jdk1.5.0/ and add $JAVA_HOME/bin to your path.

E.g: export JAVA_HOME=/usr/share/java/jdk1.5.0/ export PATH=$JAVA_HOME/bin:$PATH

At your shell prompt, type the following to determine if the path is set correctly: which java

This should display: /usr/share/java/jdk1.5.0/bin/java

-Tim

dr.st.todorov@mail.bg wrote:

> tenks ! > I have Java instaling in usr/local/java/jre1.5.0_17 but I can not > set environment variable and the systems don't now there is java. > I set export PATH=/usr/share/java/jdk1.5.0/bin:$PATH > export JRE_HOME=/usr/local/java/jre1.5.0_17 > in my .bash_profile but that not work! > > Any ideas! I'm new in Linux and English - Sorry!!! > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in > the OpenVPMS User's forum- http://tinyurl.com/openvfu >

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Tue, 24/03/2009 - 07:56.

OK! Now I have JAVA:

stan@stan-laptop:~$ which java /usr/local/java/jre1.5.0_17/bin/java

with this version of dataload.sh

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

#!/bin/sh ./setenv.sh if [ "$1" = "base" ] ; then java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c ../conf/applicationContext.xml -f ../import/data/base.xml elif [ "$1" = "setup" ] ; then java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c ../conf/applicationContext.xml -d ../import/data else echo "Usage: dataload.sh ( commands ... )" echo "commands:" echo " base Load base data" echo " setup Load setup data" exit 1 fi

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

I have that:

stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base Unrecognized option: -c Could not create the Java virtual machine.

and the same with ./dataload.sh setup

When I change the dataload.sh :

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

#!/bin/sh ./setenv.sh if [ "$1" = "base" ] ; then java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; elif [ "$1" = "setup" ] ; then java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c ../conf/applicationContext.xml -d ../import/data -b 1000; else echo "Usage: dataload.sh ( commands ... )" echo "commands:" echo " base Load base data" echo " setup Load setup data" exit 1 fi ''''''''''''''''''''''''''''''''''''''''''''''''''

and :

stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base Unrecognized option: -c ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; elif [ "$1" = "setup" ] ; then java -classpath $CLASSPATH org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c Could not create the Java virtual machine.

and :

stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh setup Usage: dataload.sh ( commands ... ) commands: base Load base data setup Load setup data

I dont now what can I do !

Re: Re: Logging in to OpenVPMS Web

Submitted by Tony De Keizer (not verified) on Tue, 24/03/2009 - 09:01.

Hi Stan,

I think the dataload script has now been modified incorrectly.

You should remove the single quote before the -c and make sure both java commands are on a single line i.e no line break after the -c (bit hard to tell if this is the case of course due to email formatting)

Cheers Tony

On 24/03/09 7:56 AM, "dr.st.todorov@mail.bg" :

> OK! Now I have JAVA: > stan@stan-laptop:~$ which java > /usr/local/java/jre1.5.0_17/bin/java > with this version of dataload.sh > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > #!/bin/sh > ./setenv.sh > if [ "$1" = "base" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > ../conf/applicationContext.xml -f ../import/data/base.xml > elif [ "$1" = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > ../conf/applicationContext.xml -d ../import/data > else > echo "Usage: dataload.sh ( commands ... )" > echo "commands:" > echo " base Load base data" > echo " setup Load setup data" > exit 1 > fi > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > '' > I have that: > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base > Unrecognized option: -c > Could not create the Java virtual machine. > > and the same with ./dataload.sh setup > When I change the dataload.sh : > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > #!/bin/sh > ./setenv.sh > if [ "$1" = "base" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c > ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; > elif [ "$1" = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c > ../conf/applicationContext.xml -d ../import/data -b 1000; > else > echo "Usage: dataload.sh ( commands ... )" > echo "commands:" > echo " base Load base data" > echo " setup Load setup data" > exit 1 > fi > '''''''''''''''''''''''''''''''''''''''''''''''''' > and : > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base > Unrecognized option: -c ../conf/applicationContext.xml -f > ../import/data/base.xml -b 1000; > elif [ "$1" = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > Could not create the Java virtual machine. > and : > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh setup > Usage: dataload.sh ( commands ... ) > commands: > base Load base data > setup Load setup data > > I dont now what can I do ! > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

Re: Re: Logging in to OpenVPMS Web

Submitted by tanderson on Tue, 24/03/2009 - 12:01.

OK. You have run into a bug in the shell scripts, which has been fixed for 1.3. The setenv.sh script isn't being sourced correctly. Replace the line: ./setenv.sh With: . ./setenv.sh

See https://openvpms.atlassian.net/browse/REL-5 for more details.

Sorry I missed this earlier.

-Tim

dr.st.todorov@mail.bg wrote:

> OK! Now I have JAVA: > stan@stan-laptop:~$ which java > /usr/local/java/jre1.5.0_17/bin/java > with this version of dataload.sh > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > #!/bin/sh > ./setenv.sh > if [ "$1" = "base" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > ../conf/applicationContext.xml -f ../import/data/base.xml elif [ "$1" > = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > ../conf/applicationContext.xml -d ../import/data else > echo "Usage: dataload.sh ( commands ... )" > echo "commands:" > echo " base Load base data" > echo " setup Load setup data" > exit 1 > fi > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > > I have that: > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base > Unrecognized option: -c > Could not create the Java virtual machine. > > and the same with ./dataload.sh setup > When I change the dataload.sh : > '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' > #!/bin/sh > ./setenv.sh > if [ "$1" = "base" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c > ../conf/applicationContext.xml -f ../import/data/base.xml -b 1000; > elif [ "$1" = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader '-c > ../conf/applicationContext.xml -d ../import/data -b 1000; > else > echo "Usage: dataload.sh ( commands ... )" > echo "commands:" > echo " base Load base data" > echo " setup Load setup data" > exit 1 > fi > '''''''''''''''''''''''''''''''''''''''''''''''''' > and : > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base > Unrecognized option: -c ../conf/applicationContext.xml -f > ../import/data/base.xml -b 1000; > elif [ "$1" = "setup" ] ; > then > java -classpath $CLASSPATH > org.openvpms.tools.data.loader.StaxArchetypeDataLoader -c > Could not create the Java virtual machine. > and : > stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh setup > Usage: dataload.sh ( commands ... ) > commands: > base Load base data > setup Load setup data > > I dont now what can I do ! > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in > the OpenVPMS User's forum- http://tinyurl.com/openvfu >

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Tue, 24/03/2009 - 18:43.

ok! I will try!

what is the differents between base end setup options!

In reality, can I load base and import database from Windows MSDB to MYSQL?

Re: Re: Logging in to OpenVPMS Web

Submitted by Tony De Keizer (not verified) on Wed, 25/03/2009 - 12:01.

Hi,

The base load loads a small number of standard lookups and users and would be used if you are intending to migrate data from an existing database.

The setup load loads some base organisational structures (practice, clinic, schedules, appointment types etc), as well as unit of measures, species and breeds. This would typically be used for a new installation where no data is being migrated.

As far as importing data from MSDB (Access or MSSQL I assume ? ) we have developed a import tool but you would still need to develop the necessary data transforms in the Kettle tool to import the data. This requires some understanding of the OpenVPMS internal structure so I would say needs some implementation and database experience.

I would definitely council against importing directly into the MYSQL database as the internal structures and relationships in the OpenVPMS database are different to your traditional database in order for us to support archetyping ( dynamic data) etc.

Cheers Tony

On 24/03/09 6:43 PM, "dr.st.todorov@mail.bg" :

> ok! I will try! > what is the differents between base end setup options! > In reality, can I load base and import database from Windows MSDB to MYSQL? > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Tue, 24/03/2009 - 19:12.

I change ../setenv.sh and now:

stan@stan-laptop:~/openvpms-release-1.2/bin$ ./dataload.sh base
./dataload.sh: 3: ../setenv.sh: not found
Unrecognized option: -c
Could not create the Java virtual machine.

!!!

Logging in to OpenVPMS Web

Submitted by stanislav (not verified) on Tue, 24/03/2009 - 19:22.

oooooh!!!

the true is '. ./setenv.sh' not '../setenv.h'

!!!

Logging in to OpenVPMS Web App for first time

Comment viewing options