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.
OSCAR 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.listA 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.
Uncomment the following line in /etc/apt/sources.list by removing its preceding #
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).
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.
A 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.):
B.) Whereas users who wish to use British Columbia’s billing subsystem should run this command (replace ****** with the MySQL password you set earlier.):
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!)
BC users will probably want to adjust the following to match their environment
We 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.
and adjust some tables (replace ****** with the MySQL password you set earlier.)
Download the binary and copy the WAR file to $CATALINA_BASE
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
For simplicity MySQL will be used here. Create an empty drugref database with the following (replace ****** with the MySQL password you set earlier.):
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.
Time spent on importing data: 14 minutes
Time spent on new generic import: 8 minutes
At 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.