Installation issues
Submitted by stevedenley on Mon, 16/06/2014 - 22:45
Hi
Just bought a subscription and am in the process of installing. Being only just computer literate I'm not having fun at present . I've had to start again a few times.
I'm following this link - http://www.openvpms.org/documentation/installing-openvpms-windows-7-computer -
I'm installing on to windows 8
Just double checking I'm at this stage of step 2: set Java environment variable - Under System Variables (lower box - upper box is for User Variables), click on New, then enter JAVA_HOME and c:\Program Files\Java\jre7 in the appropriate fields and press OK
I've downloaded the latest version of Java so I think from my reading I have to enter c:\ProgramFiles\Java\8u5 instead of 'jre7' - is this correct?
Cheers
Steve.
Re: Installation issues
Steve - I would advise against using Java 8 rather than 7 - see
http://www.openvpms.org/forum/jasperreports-and-java-8
As you will see from the post, there would appear to be problems with using Java 8.
If I were you, I would: a) uninstall Java 8; b) install Java 7 using the link https://www.java.com/en/download/ (note the https: not http:)
You may wish to wait for others to comment before proceeding.
Regards, Tim G
Re: Installation issues
Thanks
I've also installed -appache open office 4.1.0, apache tomcat 6.0.41, ireport 3.7.6, mysqlconnector-java-gpl-5.1.31, mysql essential 5.1.73 and mysql-gui-tools 5.0-r17
Are these all OK?
Steve.
Re: Installation issues
Steve - these loook OK to me. Regards, Tim G
Re: Installation issues
I would have probably installed tomcat7, and you can install ireports 5.1 but set the options to save as 3.7.5.
1. Install mysql - first check u can access it. it doesnt require java or anything esle working. you should be able to use "mysql -uroot -p" from the commandline to access it. Make sure u have created the openvpms user and given the correct permissions. you can run the createdb.sql found in the zip file to do this for you but you must have root admin access.
2. Install java7 -
3. Add java paths to you environment
3. Install Tomcat7 or 6
4. Navigate to http://localhost:8080 to Check u can access tomcat again - if you cant dont go any further work that out first
5. Copy the mysql-connector to tomcat libs directory ../tomcat/lib
6. Unzip the openvpms download navigate to /openvpms/conf and make sure the hibernate.properties file has the right settings for you (if you go with the instructions it should be right.
6. Navigate to ../openvpms/bin - run dataload setup, dataload base, archload - if they error out post the openvpms.log that is created in that directory here. so we can debug it for you.
7. copy openvpms.war to tomcat/webapps
8. navigate to localhost:8080/opemvpms check its working. IF it isnt navigate to ..tomcat/logs - upload openvpms-full.log catalina.log and other relevant logs here.
9. Add the path to soffice.exe to your environment path.
10. Login as the user running Tomcat - should be openvpms
11. Open office and get rid of the first start rubbish - signups etc
12. To check tomcat/openvpms can run office upload a .doc attachment. it should convert it to pdf in the patient history.
Post error logs if u get them.
I will say installing and running openvpms can be a little daunting which is why a number of people who you can pay a fee too to do it exist. Many can do it remotely even if you are not close by.
Getting the system running exactly right is the first and most important step....once its done the system is usually really smooth and very user friendly. But if it isnt setup properly you will get constant wierd errors.
If you get completely frustrated dont give up someone here will help!!
Re: Installation issues
Cheers- will give it a crack
Steve.
Re: Installation issues
Hi
I didn't get very far . I've uninstalled everything and started again (downloaded software versions as instructed by ben)
I'm stuck on first step of installing mysql. Got to the part where i have to enter the root password as 'openvpms' and the wizard setup goes to 'not responding' (which its done a few times previously).
It did ask me to enter current password which I left blank.
Any ideas?
If I'm getting desperate for someone to install it for me - do you have any suggestions who? Any idea of rough cost to do this? Or should I just ask my friendly local computer man?
Cheers
Steve.
Re: Installation issues
Steve,
MYSQL has its own root user, different from your system root user. From that root user, other users are created, eg youself or openvpms. For security, should never run as root, only for administration.
Simon
Simon Slater
Registered Linux User #463789 @ http://linuxcounter.net
Re: Installation issues
Make sure your running as an elevated user initially - that means you have UAC off or atleast on moderate. You should have administrator priveledges.
AS you might expect this is not really a openvpms issue as much as it is a mysql issue. Basically our instructions are just a modified version of the basic mysql installation instructions.
Also consider turning off antivirus software while installing.
http://dev.mysql.com/doc/refman/5.5/en/windows-installation.html
As far as help goes - what timezone are you in ? ie where are you?
If noone can help locally contact me at benjicharlton[at]gmail[dot]com.
Re: Installation issues
I'm in tamborine- just south of brisbane. ie EST
Steve.
Re: Installation issues
Steve,
I am located in Brisbane - contact me on the above email address and we'll see what we can do.
Ben
Re: Installation issue
double up sorry
Re: Installation issues
Hi
Sorted out the MySQL issue. I think I'd failed all MySQL files from previous installs.
Now- I'm stuck on your step 4 above - "4. Navigate to http://localhost:8080 to Check u can access tomcat again - if you cant dont go any further work that out first"
I get the message - Google Chrome could not connect to localhost:8080
Help!
Steve.
Re: Installation issues
Steve - my guess is that Tomcat is not running and my second guess is that there is a a 32/64 bit problem and my third guess is that it is my fault.
Step 1 - go to Control Panel then Administrative Tools then Services - you should find Apache Tomcat and look at the Status column - it should show Started as below
If it does say Started then I am wrong about what is the problem.
If it is not there then Tomcat has not installed.
If it says Stopped (or perhaps the status is blank) then it did not start and my Guess 1 was correct.
My cockup was to install the 32 bit version of java, and the 64 bit version of Tomcat (and Tomcat would not start because of the wrong java version). I managed to do this by not following the instructions in the readme.txt file about using the the 32-bit/64-bit Windows Service Installer and instead direnting installing the 64 bit version.
In your case, I suspect what happened was that you initially installed Java 8 - and this comes only in a 64 bit version. You then installed Tomcat (using the 32/64 bit installer) and it saw the 64-bit Java and installed the 64 bit Tomcat.
You then (following what I suggested) uninstalled java 8 and installed java 7 - but happened to get the 32 bit version because the java 7 installer matches the browser you use to install it and that will be 32 bit.
However, you did not uninstall Tomcat, and then reinstall it so you ended up with 32 bit Java and 64 bit Tomcat.
As you probably know, 32 bit stuff is installed in C:\Program Files (x86) and 64 bit stuff in C:\Program Files. So if your Tomcat is in the latter and your java in the former then the problem is as I suspected.
Fix: uninstall Apache Tomcat, and reinstall from where it says in the readme.txt, ie
http://tomcat.apache.org/download-60.cgi, selecting the 32-bit/64-bit Windows Service Installer
and your Tomcat should then match your java.
Regards, Tim G
Re: Installation issues
Hi
Not your fault- my fault - I just had to check 'run' on final install screen of tomcat (although it was unchecked on the the screen instructions I was following)
Now to the next step......
Cheers - Steve.
Re: Installation issues
Hi
Now having difficulty configuring open office.
I've installed open office 4.1.0 - so what do I put for the variable value for the path?
When i type swriter into the command prompt it comes back with ' swriter is not recognised as an internal or external command
Ta
Steve.
Re: Installation issues
Steve - mine as you can see below is sitting in C:\Program Files (x86)\OpenOffice 4\program so that is what gets added to the path. So have a look around there and check where yours is - I suspect the same place. Regards, Tim G
Re: Installation issues
That did the trick- onwards and upwards.
Re: Installation issues
Hi
Now having a problem with step 13 - open vpms database setup
getting the message :'mysql' is not recognised.................
Also I couldn't follow ben's instructions above "6. Unzip the openvpms download navigate to /openvpms/conf and make sure the hibernate.properties file has the right settings for you (if you go with the instructions it should be right."
Have I made a fundamental error?
Steve
Re: Installation issues
Courage my boy - I bet its just another path issue (one I hit about 10 days ago installing an early test version of 1.8 on a new machine). [I just checked Uri's instructions and as far as I can see in step 4 where he is installing MySQL he did not explicitly set the path.]
When I did my MySql install, go the your step 13 where you do "mysql -u admin -p < createdb.sql" and it said "'mysql' is not recognized as an operable program or batch file.".
The fix is as follows: first find where MySql was installed - in my case it went into C:\Program Files\MySQL\MySQL Server 5.5 - and all its programs live in the bin folder - so we need to add C:\Program Files\MySQL\MySQL Server 5.5\bin into the path.
"mysql -u admin -p < createdb.sql"
When I used the MySQL installer, it didn't ask me anything about the mysql config, so I needed to fix this. It says in the OpenVPMS readme.txt file at the bottom of section 1.1
- include the following lines in my.ini
max_allowed_packet=16M
innodb_file_per_table
So where is the my.ini file? In my case it is in C:\ProgramData\MySQL\MySQL Server 5.5\my.ini
This is a plain text file, so you can edit it with Notepad - so start Notepad and open the my.ini file. [In the open fiile diaglog you have to change the file type selection (bottom right) from Test Documents (*.txt) to All Files (*.*) to see the my.ini file.
You will find that it contains lots of stuff. Ignore it all and go to the bottom and add the two lines above. [It wont matter if you did in fact set these during the install and they are set elsewhere in the file - but if you want you can check by searching for (with Edit|Find) 'innodb_file_per_table'. Save the file and restart MySQL. [Either simply restart the machine or use Control Panel|Administrative Tool|Services, click on the MySql line and then the Restart link.]
Re your note: Also I couldn't follow ben's instructions above "6. Unzip the openvpms download navigate to /openvpms/conf and make sure the hibernate.properties file has the right settings for you (if you go with the instructions it should be right."
I think that you can probably ignore this (for some background see http://www.openvpms.org/documentation/csh/1.7/reference/setup/multiple-s... ). That is by default the name of the MySQL database is 'openvpms', the name and password of the mysql user that the OpenVPMS application used to talk to the database are also both 'openvpms. It is possible to change these by adjusting the <OPENVPMS_HOME>/conf/hibernate.properties file.
The readme.txt file says:
so when you run the "mysql -u admin -p < createdb.sql" it will create the mysql user as required.
[Ben runs a tight ship and hence runs his system with a different setup so that the mysql user on his system is different to the standard openvpms/openvpms.]
Regards, Tim G
Re: Installation issues
I did as asked I think but still no cigar.
I edited the ini file OK.
I entered mysql -u admin -p < createdb.sql into the command prompt and got the same mysql is not recognised message.
I also entered it into the MySQL command line and got just another prompt "->"
Where now?
Steve.
Re: Installation issues
Also - 'MySQL' was in program files as you mentioned.
Re: Installation issues
Steve - this has GOT to be a path problem.
In the command window type in 'set path' (and then press Enter). You should see something like
I have highlighted the MySQL path entry [different here from the discussions above - this is taken from my development laptop]
I suspect that this is becoming a real PITA to you - send me an email at tim dot gething at bigpond dot com and we should be able to do things faster and get you up quicker.
Regards, Tim G
Re: Installation issues
Email sent. Coming from balancevet[at]yahoo.com[dot]au
Cheers
Steve