Preface
This basic install is adequate for a local install of Oscar. Many users prefer to install Oscar as a server and run it on a browser from another computer and this will require setting up tomcat for https:// connections and other basic security hardening. Document Version History
PrerequisitesIt is assumed that
Installing The Infrastructure PackagesOSCAR is predominately written in the Java programming language
and thus requires the Java SDK to be built from source. The Java SDK
also supports the Tomcat web framework. The following installs Java First enable the ubuntu lucid partner repository (it's not enabled by default) by editing sources.list A note about the following command – ‘vi’ (for visual editor) is a classic unix editor. First time users usually find other Linux editors easier to use particularly ‘nano’, if you are running in a terminal environment, and ‘gedit’, if you are running with a GUI. If you elect to use an alternative editor, replace ‘vi’ in the commands that follow with your editor of choice.sudo vi /etc/apt/sources.list Uncomment the following line in /etc/apt/sources.list by removing its preceding #
#deb http://archive.canonical.com/ubuntu lucid partner This gives you access to certain software from companies (the partners) that have entered into an agreement with Canonical (which develops Ubuntu) such as Oracle (Sun) that provides the type of java that we want.
Mouse or tab to highlight the <yes> acceptance of the liscence agreement and click or enter to accept it. The source code compilation process for OSCAR is managed by the Ant package.
Your specific CMS data, profiles, and information will all be
stored in the MySQL database. This installation sequence will ask you
for a secure password for the database server – remember this
password as you will need it again later in the installation whenever ****** is referenced. If you use symbols "#,!, &,*, (, ), / , \ and $" in this password (eg pass&word), be sure to escape them when replacing the ***** (eg pass\&word). sudo apt-get install mysql-server libmysql-java To support OSCAR’s web based user interface, the system leverages the extensive resources of the Apache Tomcat web application framework.
Concurrent Versions System (CVS) is used for source code control on the OSCAR Project. You will need this package to grab the OSCAR source code.
These are all of the base packages that need to be installed. Now, we will reboot the server.
After the server restarts, log in once again, and proceed to the next section. Configuring The Base PackagesA few environment variables need to be set to support OSCAR.
If you are configuring OSCAR on a freshly installed Ubuntu server, then you should be safe to add these lines to end of the file.
To load the new environment variables into your existing terminal, run the following command. Please note that the sudo command is not required in this case.
The infrastructure is now in place and it is time to get the OSCAR source code. The first cvs command below will ask you for a password – please respond by hitting the Enter key, without adding a password (ie a null password). By specifying a specific date/time on the checkout command, you ensure that you get a specific, dated version that you can track from. The command, run without the datestamp verb -D "2010-05-05 23:59:59" will retrieve the most recent version that works for both BC and ON. By specifying a particular release, you will get the code from that branch of the code. The command, run without the release flags, will get you the code from the development branch. If the development stream code is what you want, run the command without -r and also without -r RELEASE_9_12. This tutorial is specific to the commands in the following section.
It will take a few minutes for the source code to download. Afterward, Compile OSCAR.
You may ignore the warnings from the compiler, however you should expect to receive the message: BUILD SUCCESSFUL. Copy the resulting WAR files to the web server.
OSCAR includes scripts to populate the MySQL database. Change to the database script directory.
Only run one of the following two database creation commands (either A or B) ! A.) Users that wish to use Ontario’s billing subsystem should run the following command (replace ****** with the MySQL password you set earlier.): ./createdatabase_on.sh root ****** oscar_mcmaster B.) Whereas users who wish to use British Columbia’s billing subsystem should run this command (replace ****** with the MySQL password you set earlier.): ./createdatabase_bc.sh root ****** oscar_mcmaster OSCAR users that are from neither Ontario nor BC can run either of the above commands (you must run one of them), then you will need to adjust the billing system according to your own location. You will need to move the oscar_*.properties files to $CATALINA_HOME as described below.
The oscar.properties file needs to be localized for your specific configuration.
Ontario users will probably want to adjust the following (Warning do not put any blank spaces at the end of any line!) db_password= ******* ### change to your mysql database passwordisNewONbilling=true billregion=ON billcenter=R ### change to your local OHIP office codephoneprefix=705- BC users will probably want to adjust the following to match their environment
db_password= ******* ### change to your mysql database passwordvisitlocation = P1|PEMBERTON dataCenterId = 00000 msp_error_codes = # supply the file location of msp error codesbillregion=BC NEW_BC_TELEPLAN=yes CDM_ALERTS=250,428,4280 COUNSELING_CODES=18220,18120,17220,17120,16220,16120,13220,12220,12120,00120 phoneprefix = 613- pathnet_url= # supply the Location of Pathnet DLLpathnet_username= # supply User to access the systempathnet_password= # supply Users PasswordWe will now configure Tomcat. First, adjust the configuration file
to allocate more resources to OSCAR otherwise Drugref 2/3 will not run or will not run properly.
Find the following sections and configure the variables to match what is below. I am assuming that you have at least 1Gb RAM. Now we’ll enable the new echart interface. cd $HOME/src/oscar_source/oscar_mcmaster/database/mysql java -cp .:$CATALINA_BASE/webapps/oscar/WEB-INF/lib/mysql-connector-java-3.0.11-stable-bin.jar importCasemgmt $CATALINA_HOME/oscar.properties
and adjust some tables (replace ****** with the MySQL password you set earlier.) mysql -uroot -p ****** oscar_mcmaster ### will bring you to the mysql database promptmysql> insert into issue (code,description,role,update_date) select icd9.icd9, icd9.description, "doctor", now() from icd9; mysql> quit; ### gets you out of mysqlDrugref2/3Download the binary and copy the WAR file to $CATALINA_BASE wget
http://drugref2.googlecode.com/files/drugref.war sudo mv drugref.war $CATALINA_BASE/webapps /drugref.war
Either MySQL or Postgres can be used for database. Launch your text editor to form drugref.properties
Enter the following lines into drugref.properties (replace ****** with the MySQL password you set earlier.) and save db_user=root db_password= ****** db_url=jdbc:mysql://127.0.0.1:3306/drugref db_driver=com.mysql.jdbc.Driver For simplicity MySQL will be used here. Create an empty drugref database with the following (replace ****** with the MySQL password you set earlier.): mysql -uroot -p ******* mysql> create database drugref; mysql> quit;
Restart tomcat sudo /etc/init.d/tomcat6 restart
To populate the database with drug data open your browser and navigate to the server. If you installed on a local desktop version of Ubuntu it is as shown below. http://localhost:8080/drugref/Update.jsp (If you installed via a SSH tunnel open firewall access for port 8080 on the server and change localhost to its URL) NOTHING will seem to happen (except for the page loading symbol) for half an hour so get a coffee. When you get back to the screen you will get a page like. Update Drugref Database!
Time spent on importing data: 14 minutes Time spent on new generic import: 8 minutes
Trying It OutAt this point you can test the fairly plain install. To test the connection, open your web browser and go to your the web address of your server. If you installed on a local desktop version of Ubuntu it is as shown below. You should see the OSCAR login page.
The default login parameters for OSCAR is as follows: User Name: oscardocActivate Rx3 when logged into Oscar navigate Pref > Set To Use Rx3 and click the check box If you can login then you have successfully installed a plain OSCAR and you can start playing with it. This is enough for now, however for production use you will need to secure your installation further and apply basic security hardening. |
I. OSCAR EMR > 6.0 Installing OSCAR >