Backing up a Database and upgrading Noodle should be a quick and painless experience. This page shows you how! It is recommended to take a note of Version of Noodle that is currently running. This can be found on the login screen underneath the Login button.

• Database Back-up
• Microsoft SQL Server 2000
• Microsoft SQL Server 2005
• PostgreSQL
• Upgrading Noodle on a Windows server
• Upgrading Noodle on a Linux server
• Useful Links

---

Download all necessary files and make sure all other necessary software is updated

If Noodle is going to be down for an upgrade why not use this opportunity to upgrade everything! Check things like Java and Operating System updates to ensure the server is as up-to-date as possible.

Inform Users and prepare for any potential training that may be required.

Seen something in the latest version of Noodle that will be an amazing addition to the company intranet? Make sure those that can benefit from an application have the access and the knowledge to get the most out of it!

Download all necessary files

Always available from our Customer Support Noodle, use the link on the Upgrade portlet on the Upgrade Instructions page to download the latest .JAR file that will be used for the upgrade. If you are upgrading from a recent version (6.x.x or higher) there will be no need for any further files.

Database Back-up

Before any upgrade is performed, the database holding the Noodle data should be backed-up. This can be separate from any other scheduled backups that should also be done to provide a fresh copy of all data in case of disaster.

Microsoft SQL Server 2000/2005

MSSQL database backups are extremely simple and are all done using the included Enterprise Manager. The Enterprise Manager is accessed from the Start Menu, under the Microsoft SQL Server folder.

Microsoft SQL Server 2000

Once the Enterprise Manager has been opened, use the explorer to navigate to the database being used for Noodle. Expand the database, select All Tasks and then Backup Database...

A new window will appear with various options for the backup. Just click OK to create a .BAK file with a complete backup of all data:

Microsoft SQL Server 2005

As with MSSQL 2000, a new window will appear with various options for the backup. Just click OK to create a .BAK file with a complete backup of all data:

PostgreSQL (Windows)

PostgreSQL is the easiest of the database systems to backup. Simply shut down the enhydra multiserver and the database connections using the following script. This should be copied and pasted into Command Prompt, accessed in Start -> Run -> 'cmd':

@echo off
rem stop the server and db
net stop intranet
SET PATH_TOOLS=C:\Program Files\Noodle\tools
SET PATH_PG=C:\Program Files\Noodle\postgresql
"%PATH_TOOLS%\pv.exe" java.exe > NUL: 2>&1
IF %ERRORLEVEL%==0 ("%PATH_TOOLS%\pv.exe" -k -f java.exe > NUL: 2>&1)
"%PATH_TOOLS%\pv.exe" postgres.exe > NUL: 2>&1
IF %ERRORLEVEL%==0 ("%PATH_TOOLS%\pv.exe" -k -f postgres.exe > NUL: 2>&1)
"%PATH_TOOLS%\pv.exe" ipc-daemon.exe > NUL: 2>&1
IF %ERRORLEVEL%==0 ("%PATH_TOOLS%\pv.exe" -k -f ipc-daemon.exe > NUL: 2>&1)
IF EXIST "%PATH_PG%\data\postmaster.pid" (DEL "%PATH_PG%\data\postmaster.pid")
DEL /F/Q "%PATH_PG%\tmp\*"

Once this command has run, this will enable the PostgreSQL database to be backed up. An easy way to do this is to right-click on the postgresql directory, and use compression software to create a compressed database that can be stored safely.

Upgrading Noodle on a Windows server

Following are the steps for upgrading Noodle on a Windows-based server. These instructions are assuming the newest .JAR file has been downloaded (in this example to the Desktop).

1. Open a browser and navigate to the Enhydra console on port 8001 as shown to be asked for the multiserver password that was set when the application was installed. The username is always admin:

2. Once the console opens, click on the Stop button as shown. You will now be prompted for confirmation - click OK to confirm:

3. Open up an Explorer and navigate to the installation directory, usually "C:/Program Files/Noodle", or "C:/Program Files/intraNETV5". From here, open up the enhydra directory and then the lib directory. Inside this directory are various files used for Noodle, one of which is intranet.jar. It is generally recommended to make a backup of this file in case of disaster during the upgrade. Rename this file to include the version and date. This will allow multiple files to be easily differentiated. Once this file has been renamed, place the latest jar obtained from Customer Support inside this folder and rename it to intranet.jar

4. Now that the intranet.jar file has been replaced, the service can now be restarted to start the upgrade process. Click Start -> (Settings) -> Control Panel -> Administrative Tools. In the new window, select Services. Scroll down the list until you see intraNET and start this service.

5. Once the service has been started, the upgrade process will begin. If the multiserver.log file within the enhydra/logs folder has been either deleted or renamed, Noodle will automatically recreate a new multiserver.log file. The log file will show whether the upgrade has been successful.

Upgrading Noodle on a Linux server

Upgrading Noodle can all be done from one console session on a Linux server. As always, ensure the database is backed-up and make a backup of the intranet.jar file, as well as noting the version number currently running.

1. Open a browser and navigate to the Enhydra console on port 8001 as shown to be asked for the multiserver password that was set when the application was installed. The username is always admin:

2. Once the console opens, click on the Stop button as shown. You will now be prompted for confirmation - click OK to confirm:

If there are no other applications running, the command killall -9 java can be used.

3. Next, the intranet.jar link must be re-attached to the new .JAR file. Delete the symbolic link intranet.jar and re-assign it as follows:

Syntax: ln -s FILE_NAME LINK_NAME

Example: ln -s Noodle.6.7.13.2009.07.10.jar intranet.jar

4. The final step is to restart the multiserver to begin the upgrade process. from the enhydra directory, enter the following command:

Syntax: ./ multiserver &

5. check the multiserver.log file to ensure the upgrade has been successful.

Useful Links

Click on a link below to obtain backup information for your database:

Microsoft SQL Server

Microsoft SQL Server 2000
Microsoft SQL Server 2005

Oracle

Oracle Database Backup FAQ

Linux

PostgreSQL Backup and Restore Documentation