Mac (OSX)
Quick guide to using openVPMS in OSX with mamp
Requirements:
- openvpms installation files
- MAMP (for mysql database)
- apache tomcat6
- Connector/J
- libreoffice
Download OpenVPMS Installation Files
Download the latest OpenVPMS Installation files. Create a folder within your home folder to unzip the release into.
The following assumes a user named user: Move the package to ~/user/openvpms and unzip the Installation Pack. This should create a ~/user/openvpmsopenvpms-release-x.x.x folder with the necessary files to install OpenVPMS.
Download and install MAMP
Installing MAMP provides a really easy way to configure and run MySQL. Download from http://www.mamp.info/en/downloads/
The free MAMP is fine, you don't need the paid pro version.
Download tomcat6
Download tar.gz core binary distribution of Apache Tomcat version 6 from http://tomcat.apache.org/download-60.cgi
Unpack it and then move it to your home directory so it will be in ~/user/apache-tomcat-6.x.x/lib/
Connector/J
Download the connector/J which is needed to connect openvpms to the database. You then extract it and copy the mysql-connector-java-x.x.x-bin.jar to:
- ~/user/openvpmsopenvpms-release-x.x.x/lib/
- ~/user/apache-tomcat-6.x.x/lib/
Libreoffice
Download libreoffice and install it
Setting the variables and paths
open a terminal window and edit your .profile file eg. type:
nano .profile
add the following to your .profile file
export JAVA_HOME=/Library/Java/Home export CATALINA_HOME=/users/user/apache-tomcat-6.0.35 export PATH=/Applications/LibreOffice.app/Contents/MacOS:$PATH
Installing a fresh installation
Start the mysql database using mamp. Using phpmyadmin (installed with mamp) go the import tab and navigate to ~/user/openvpmsopenvpms-release-x.x.x/db/createdb.sql
Import it and then navigate to ~/user/openvpmsopenvpms-release-x.x.x/db/db.sql and import it as well.
Now in a terminal window cd to ~/user/openvpmsopenvpms-release-x.x.x/bin
run the setup by typing
./dataload.sh setup
Copy the openvpms.war from ~/user/openvpmsopenvpms-release-x.x.x/webapps/ to ~/user/apache-tomcat-6.x.x/webapps/
Starting and stopping tomcat
Hopefully now you are ready to go. I installed this a long time ago so to the best of my knowledge I haven't missed any necessary configuration. To start and stop tomcat cd to ~/user/apache-tomcat-6.x.x/bin and then run
./startup.sh
or
./shutdown.sh
using the terminal
Once it starts up you should be able to access openvpms at http://localhost:8080/openvpms/app
- Printer-friendly version
- Login or register to post comments
Comments
Lorna Johnston :)
The createdb.sql script sets up a clean database, and creates the openvpms user required by OpenVPMS. If it ran successfully, you should be able to log into the database using the following entered on the command line:
It will prompt for a password. Enter:
If you can log in, you will get a mysql prompt. Type:
and press enter.
If not, you will get an error like:
ERROR 1045 (28000): Access denied for user 'openvpms'@'localhost' (using password: YES)
See http://www.openvpms.org/documentation/csh/1.8/topics/installing-openvpms... for more information.
Lorna Johnston :)
The mysql binary isn't in your path and nor is the current working directory so you need to run it via /Applications/MAMP/Library/bin/mysql or by cd'ing into that directory as you've described above.
If you can run:
and it accepts openvpms as the password, the dataload tool should work.
The dataload tool uses the configuration from <OPENVPMS_HOME>/conf/hibernate.properties to determine the username and password to connect to the database. This should have the following entries:
If the password is different, or contains trailing spaces, connection will fail.
If the above is OK, you could try running mysql as the administrator and enter:
If dataload doesn't work with the above, try the insecure version below (it allows connections from all hosts):
Failing all of the above, post your question to the implementers forum where it is more likely to be seen.