Installation issues

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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!!

 

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

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.

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

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

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: Installation issue

double up sorry

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

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:

1.4 Database setup

  To create the OpenVPMS MySQL database, run the following in a shell prompt
  > cd <OPENVPMS_HOME>/db
  > mysql -u admin -p < createdb.sql
  > mysql -u admin -p openvpms < db.sql

  NOTES:
  * replace 'admin' with a user that has administrator privileges in MySQL.
  * the createdb.sql script creates an 'openvpms' user that only has
    privileges to connect from localhost.

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 

Syndicate content