LabLynx KB:System upgrade
| This is an article specific to the Category:LabLynx knowledge base. Its context outside of LabLynx, Inc may not be apparent, thus why it appears inside the LabLynx KB namespace.
Making a system upgrade
System requirements and settings
- Before proceeding with the LabLynx upgrade please validate the following system requirements:
a. Windows 2000 (Service Pack 4 or higher) or Windows 2003
b. MDAC 2.6 or higher
Oracle (For Oracle versions of the product)
Oracle requirements on the Web server (where iServer is installed)
- Oracle9i Client 9.2 or higher
- Oracle Provider for OLE DB 184.108.40.206.0 or higher
- Oracle ODBC Driver 220.127.116.11.4 or higher
Oracle requirements on the database server
- Oracle9i Database 18.104.22.168.0 or higher
SQL Server (For SQL Server versions of the product)
- SQL Server 2000
Client Web Browser
- a. Microsoft Internet Explorer 5.5 or higher
- b. Add the application's web site to Trusted Sites (On the menu go to Tools/Internet Options…
- Click the Security tab. Click the Sites… button next to Trusted Sites).
- c. See the following link for more detailed Client settings. http://22.214.171.124/lablynxkb/Default.asp?ToDo=view&questId=28&catId=6
- a. Windows 2000 (Service Pack 4 or higher) or WindowsXP/Windows 2003
Before the upgrade
Before performing the upgrade please get all users off the current LIMS application and reset IIS before proceeding. (From the web server hit Start/Run/iisreset). Make sure you backup the web files and folders and the database of your existing system before proceeding with the system upgrade. It is always best to run the upgrade process on a test version of the application before applying to your production application. The upgrade replaces all COTS web files, database objects and meta data used to run the application.
If the iServer Setup exe was not provided you will first need to download the latest version of it. This file can be retrieved from the LabLynx FTP site ftp.lablynx.net under the llx/iserver directory. To set up iServer properly you must be logged into the web server as an administrator. If you have previously installed iServer, please run the uninstall exe from the Start/All Programs/LABLynx iServer/Uninstall menu item. Then run the latest version of the iServer setup on your Web server.
You will also need to download the latest version of IServerManager.exe if it was not provided in the install package. This file can be retrieved from the LabLynx FTP site ftp.lablynx.net under the llx/iServer Manager directory. This file needs no install.
Making the upgrade
***Note for SQL Server: If the web application user is not in the db_owner role, the application user will need to be in the db_dataread, db_datawrite roles and granted execute permissions on all non-system stored procedures and user-defined functions. Your DBA will need to make sure these permissions are granted.
- a. Place the iServerManager.exe and the .aip file included in the upgrade package on the Web server.
- b. Double click the iServerManager.exe.
- c. From the menu choose File / Run AIP.
- d. Assign the application folder. Using the ... button browse to the location of the web directory. This is the directory that contains the ELab folder. It usually is named "LIMS".
- e. Assign the .aip file. Using the Next ... button browse to the .aip file that was included in the upgrade package.
- f. When both the application folder and .aip file have been assigned you can click the Execute button. The iServerManager will create log files in the directory where it is located. These log files will document the upgrade processes as they are preformed. If errors occur, they will be documented in the error log file.
- g. The iServerManager will now run through and replace all the COTS Web files. When the Web portion of the upgrade has completed, the iServerManager will prompt you for the database login information. (For SQL Server users please use a database login that is part of the db_owner role. This will ensure that all the database objects go into the database with the .dbo prefix.) Once the database login information is set, hit the OK button.
- h. The iServerManager will now upgrade or replace all the COTS database objects and meta data.
- i. The iServerManager will read "Finished" when the upgrade process has completed.
Set File Folder Permissions:
We now need to set permissions on two folders on the web server. Depending upon your security procedures you will need to give the Internet guest user account (IUSR) and or the Authenticated User account Full Control (or at least read, write, modify, read & execute and list folder contents) to the folders listed below and their children. If you are using IIS 6.0 or higher you will need to do the same for the IIS_WPG User account. To change permissions on child folders and files right click on the parent folder. Hit the advanced button on the security tab. Choose the "reset permissions on all child objects and enable propagation of inheritable permissions" option, then hit ok.
- C:\iServer (Or the alternate location you chose of your iServer folder)
- C:\inetpub\wwwroot\LIMS (Or the alternate location you chose of your web folder)
Create Printer on Web Server:
Create a new Printer (Note, this is used by the reporting engine to format reports. It does not have to be an actual physical printer, just a setup of a printer so the reporting engine can use the drivers.) You might have one setup and can use it but if it does not work, follow these steps.
- a. Go to Start/Settings/Printers.
- b. Click Add Printer.
- c. Click Next, select Local Printer and uncheck "Automatically detect and install my plug and play printer."
- d. Click Next, select "Use the following port," and then select File: for the port.
- e. Click Next, select HP for the manufacturer and HP LaserJet 8000 Series PCL for the printer.
- f. Use the default settings, but you do not have to print a test page.
- g. Right click the new printer, which should be named "HP LaserJet 8000 Series PCL." Be sure to name it or update the default setting for the printer name. Make sure everyone has access to this printer. Important note: share the printer as the same name (HP LaserJet 8000 Series PCL). If you are using a different printer, make sure to share it as the same name.
- a. Go to Start/Settings/Printers.
- b. Click Add Printer.
- c. Click Next, Select Local Printer and uncheck Automatically detect and install my plug and play printer.
- d. Click Next, Select Use the following port. Then select File: for the port.
- e. Click Next, Select HP for the manufacturer and HP LaserJet 8000 Series PCL for the printer.
- f. Follow the default settings but you do not have to print a test page.
- g. Right click the new printer which should be named HP LaserJet 8000 Series PCL. Be sure to name it or update the default setting for the printer name described below. Make sure Everyone has access to this printer. Also, (this is important), share the printer as the same name (HP LaserJet 8000 Series PCL). If you are using a different printer, make sure to share it as the same name.
Set LIMS connection to the database
- From the Web server open the iServerManager.exe.
- From the menu choose File / Open.
- Browse for the setting.isv file stored under the LIMS Web directory. Select it and hit Open. (If no setting.isv file is available, skip to step seven.)
- You will need to modify the server entry. (This is the database server name for SQL server systems and the TNS name for Oracle systems.) You will also need to modify the database password entry.
- You will also need to set the Current App value to a value provided by LabLynx. See your readme file for this value.
- Once those settings have been changed you should hit the Save Encrypted button.
- If the setting.isv file is not available the global.asa file can be edited manually. To do this open the global.asa file in Notepad. Scroll down the file until you see the following text:
'*************** Setup of Database Connection ************* strDatabase = "????" 'Name of database strServer = "????" 'Blank string if database is on the webserver, IF NOT IP address of database server strUser = "????" 'Database user strPwd = "????" 'Database user password '**********************************************************
- Replace the ???? with the applicable values:
- strDatabase = This is the name of the database. It is not used in Oracle systems.
- strServer = This is the name or IP of the server for SQL Server systems. It is the TNS name for oracle systems.
- strUser = This is usually sa for SQL Server systems and lablynuser for Oracle systems.
- strPwd = This is the database password.
- Afterwards, save the global.asa file.
- 8. Reset iis. (From the Web server hit Start/Run/iisreset.)
If you are currently using the Active Reports functionality it will be necessary to modify the template location of all the new active reports included in the upgraded application. If a script was provided to do this operation you can run it now. If no script was provided you can log into the application and do this manually (the login information is below under the install complete heading). In the application under the LabLynx Menu go to System / Reporting Tools / Reports Management. Click on each report that has a Report Type of Active. For each report resave the record and it will automatically update the report template location to match the new directory. You will need to trigger the save button by modifying the record.
If any additional scripts or directions were included you can proceed with them now.
The system should now be functional. You can login to the application with the sysadmin / lablynx user password combination.