Local test or demo system setup
Submitted by marty on Wed, 27/08/2008 - 08:49
Hi,
I have an existing OpenVPMS site that would like to run a test or demo system alongside the live one for testing of templates and for new staff to practice on.
What are the steps required to restore a copy of the real data (with customers and all in it) to another new database on that same server?
What would then be the web address of the new site.
Finally, how can the background colour of the demo system be changed to clearly differentiate it from the live system?
thanks very much
Marty Oliver, The Soho Box
Melbourne, Australia
- Printer-friendly version
- Login or register to post comments
RE: Local test or demo system setup
Hi Martin, This is a common request and although the response is quite technical I think it is worthwhile documenting it here for others to use if it applies.
I assume you have an existing, working OpenVPMS installation and have some technical understanding of Mysql, editing files etc.
In this folder navigate to the WEB-INF folder and edit the file web.xml. You will notice a section near the top that looks like:
change to
and save the file.
and change to
the end section should equate to the schema name you restored to above.
To change the basic colour scheme you will need to edit the stylesheet file in the openvpms-demo folder. It can be found in WEB-INF\classes\org\openvpms\web\resource\style folder and is called default.stylesheet.
There are heaps of other changes you can make in the stylesheet but that information is for another day :-)
I hope this helps.
Cheers Tony
Schema Privileges
Thanks for that Tony.
One additional step was for me to use MySQL Administrator, User Administration, selecting the openvpms user account and clicking the Schema Privileges tab and setting the assigned privileges of the new openvpms-demo database to be the same as the existing openvpms one.
I then stopped and started both mysql and tomcat services all was good. After closing and reopening Firefox, http://localhost:8080/openvpms-demo worked and we logged in and the colour scheme was the new colour too.
Excellent
thanks for your help.
Marty