wiki:Update

Update

We try to keep the updates simple and most of the time updates only require running an update script, or rerunning the installation script. Below you'll find additional steps that need to be done if updating existing databases.

Running the update script

The update script tries to copy existing configuration files from the current Proteios version installed in Tomcat. It checks that configuration files with needed information exist, before an update is performed, otherwise you will be instructed to rerun the installation script. The only input always needed is the root password in Proteios. Under Windows, you may also need to enter the path for the Tomcat installation directory, if the latter could not be obtained from an environment variable.

  1. Unpack the binary archive or build Proteios SE from source code (see Build Proteios from Source Code). Under Linux/Unix?, the update script will deploy the new version into Tomcat by setting a link to this directory, so make sure that it is located in a place where it can remain until the next update.
  2. Move to the directory containing the update scripts update_proteios-linux.sh for Unix/Linux?, and update_proteios-win.bat for Windows. This is the directory you unpacked the binary archive in, or directory dist if Proteios SE was built from source code.
  3. Run the appropriate update script at a command prompt.
  4. Under Windows, you might be asked to enter the path for the Tomcat installation directory, normally referred to as "Catalina home". To find it, first search for a directory with "tomcat" in the name. The "Catalina home" directory is the one with a sub-directory named "webapps".
  5. If you are instructed to rerun the installation script, proceed to the next section, otherwise input the root password in proteios to perform the update.
  6. Start Tomcat if not already running. Proteios SE can now be accessed from a web browser at http://localhost:8080/proteios/.

Rerunning the installation script

Follow the procedure described for running the installation script in Proteios 2 Installation - Quick Install. Enter requested information (normally the same as during the original installation), and answer "y" to question "Do you want to update an existing 'proteios' database[y|N]?".

Beta 2 to 2.0

If you have a beta 2 installation and want to update to 2.0 you'll have to run the installation script and choose to update an existing database. This will take care of most database updates. Though the following changes must be done manually(Note the syntax is for MySQL databases)

ALTER TABLE News MODIFY COLUMN news_date datetime;
ALTER TABLE News MODIFY COLUMN start_date datetime;
ALTER TABLE News MODIFY COLUMN end_date datetime;
ALTER TABLE BioMaterialEvents MODIFY COLUMN entry_date datetime;
ALTER TABLE BioMaterialEvents MODIFY COLUMN event_date datetime;
ALTER TABLE PlateEvents MODIFY COLUMN entry_date datetime;
ALTER TABLE PlateEvents MODIFY COLUMN event_date datetime;
ALTER TABLE Experiments MODIFY COLUMN publication_date datetime;
Last modified 8 years ago Last modified on Feb 12, 2009, 4:24:05 PM