Upgrading Your Web Server from ClientBase Browser Version 2.2 or Above to Version 2.6.1

smuthhomelyServers

Nov 17, 2013 (3 years and 8 months ago)

130 views

11/12/13 1
Upgrading Your Web Server from
ClientBase Browser Version 2.2
or Above to Version 2.6.1
Introduction
Successful ClientBase Browser usage depends on proper hardware, setup and installation. This
section walks you through the steps necessary to successfully upgrade from ClientBase Browser
Version 2.2 or above to ClientBase Browser Version 2.6.1.
Recommended Server Requirements
* Windows 2003 Standard Edition
* Pentium Dual Core, 2 GHz
*1 GB RAM
Minimum Server Requirements
* Windows 2003 or higher, 64-bit version
* CPU: 2 GHz
* 4GB Physical RAM
* Static IP Address
* 1 MB Internet Uplink Throughput
Upgrade Process
Before beginning the upgrade steps below please verify the following software versions have
already been installed:
- Sun Java Software Development Kit Development Kit 6.0 - Update 29
- Install Apache Tomcat 7.0.23
- ClientBase Version 3.07 or higher (and TBO version 3.03 or higher)
- Install CBB 2.6.1
Important Note: If you are running an older version of Tomcat that is relied upon by other

CBB Upgrade
11/12/13 2
applications, or has been previously configured for custom settings like SSL, we only recommend
you upgrade to a newer version of Tomcat at your own discretion. Our recommended steps for
upgrading from an older version of Tomcat or Sun Java includes uninstalling the older
version/s (see section to uninstall/reinstall below) first, and then installing the newer
versions.
Have Correct Version of Apache Tomcat 7.0.23 and Sun Java
Software 6.0 (Update 29)? Here’s How to Upgrade to CBB
2.6.1
1. Log into the server as an Administrator.
2. Click Start|Run and type the URL (or right-mouse click on link and save or open in Web
Browser).
http://static.trams.com/tramslibrary/Releaseandupdatefiles/fullcd/cbb_26p1_setup.zip
3. If prompted, add to the list of "Trusted Sites."
4. Click Open and wait for download to complete.
5. Extract the zip file. Copy InvoicePrint.exe and DLL files to C:\Program Files\TRAMS\CBB (you
may need to create this location or overwrite old files if present).
CBB Upgrade
11/12/13 3
6. Copy cbb.war to C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps.
7. Browse to (or right-mouse click on link and save or open in Web browser):
http://localhost:8080/cbb/setup/
8. Enter "dontpanic" (without quotes) for the pass phrase.
CBB Upgrade
11/12/13 4
9. Click Edit Configuration.
10. Click Build URL.
11. Enter the name of the InterBase Server (or leave localhost if the CBB server and InterBase
server are one in the same), and click OK.
12. Enter the path to the database, and click OK.
13. Enter the JDBC User (default SYSDBA).
14. Enter the JDBC Password (default masterkey).
15. Click Save.
16. Click Main Menu.
CBB Upgrade
11/12/13 5
17. Click Done.
Congratulations! You have successfully upgraded to ClientBase Browser Version 2.6.1.
DO NOT HAVE Correct Version of Apache Tomcat 7.0.23 and
Sun Java Software 6.0 (Update 29)? Here’s How to Install
CBB 2.6.1
FOR THOSE WHO HAVE OLDER VERSIONS OF TOMCAT and/or SUN JAVA
If you have an older version of Tomcat or Sun Java, you need to uninstall them first, and then
proceed to CBB setup steps below to reinstall Tomcat, Sun Java, and reinstall ClientBase
Browser. This section explains the uninstall of ClientBase Browser (any version). It is assumed that
this server is solely used for ClientBase Browser. If other versions of Java and/or Tomcat are
used by other applications, use these steps at your own discretion.
Things to consider prior to uninstalling and older version of Tomcat or Sun Java:
If you are already on Tomcat 7.0.23 and/or Sun Java Development Kit 6.0 (update 29), you can skip
the Uninstall and go back to the section entitled Have Correct Version of Apache Tomcat 7.0.23
and Sun Java Software 6.0 (update 29)? Here’s How to Upgrade to CBB 2.6.1.
• If your SSL Certificate was installed directly into Tomcat, you must backup your certificate prior
to the uninstall and restore to the newly installed version.
• If you have made any custom settings to your Tomcat/Sun Java configuration, these settings will
be lost, and need to be reconfigured upon uninstalling/reinstalling.
• Backup your Tomcat and Sun Java Directory prior to beginning the following steps.
OVERVIEW:
I. Uninstall Apache Tomcat
II. Uninstall Sun Java Software Development Kit
III. Reinstall Sun Java Software Development Kit 6.0 (Update 29)
IV. Reinstall Apache Tomcat 7.0.23
V. Install CBB Version 2.6.1
I. Uninstall Apache Tomcat
1. While logged into the server as an administrator, click Start|Control Panel/Add or Remove
Programs.
2. Select Apache Tomcat, and click "Change/Remove."
3. Confirm Uninstall, and click "Yes."
4. Confirm Uninstall, and click "Uninstall."
5. In the "Remove all..." dialog, click "Yes."
6. Click "Close."
CBB Upgrade
11/12/13 6
7. Repeat for all versions of Tomcat.
II. Uninstall Sun Java Software Development Kit
1. While logged into the server as an administrator, click Start|Control PanelAdd or Remove
Programs.
2. Select "J2SE Development Kit", and click "Remove."
3. Confirm Uninstall, and click "Yes."
4. Repeat for all version of "J2SE," or "Java 2 SDK" (including "Java 2 Runtime Environments").
III. Install Sun Java Software Development Kit 6.0 (Update 29)
1. Log into the server as an Administrator.
2. Click Start|Run, and type the URL (or right-mouse click on link & save or open in Web browser):
http://static.trams.com/tramslibrary/Releaseandupdatefiles/fullcd/cbb/jdk-6u29-windows-
x64.exe
3. If prompted, add to the list of "Trusted Sites."
4. Click Open, and wait for download to complete.
5. If prompted, click Run to the "Security Warning."
CBB Upgrade
11/12/13 7
6. Click Next on the Welcome Wizard.
7. Confirm Install location and click Next.
CBB Upgrade
11/12/13 8
8. Confirm JRE install location and click Next.
9. Confirm Product Registration Information and click Finish.
IV. Install Apache Tomcat 7.0.23
1. Log onto the server as an Administrator.
2. Click Start|Run and type the URL (or right-mouse click on link & save or open in Web browser):
http://static.trams.com/tramslibrary/Releaseandupdatefiles/fullcd/cbb/apache-tomcat-
7.0.23.exe
CBB Upgrade
11/12/13 9
3. If prompted, add to the list of "Trusted Sites."
4. Click Open and wait for download to complete.
5. If prompted, click Run to the "Security Warning."
6. Confirm the welcome and click Next.
7. Accept License Agreement by clicking I Agree.
8. Select the type of install from the drop-down menu: Full (make sure you select Full), and click
Next.
CBB Upgrade
11/12/13 10
9. Confirm Tomcat 7.0 install location, and click Next.
10. Set desired Connector Port, username, and password (required) and click Next.
11. On JVM Selection, click on the "…" button, select the jdk1.6.0_29 folder and click okay. Then
CBB Upgrade
11/12/13 11
click Next.
12. Confirm Run Apache Tomcat is checked, and click Finish.
Setting the PermGen Settings for Use with ClientBase Browser
The Apache Tomcat Properties (e.g. tomcat6w.exe) is usually found as a systray icon on typical
installations:
Memory settings in Apache Tomcat are relative to the maximum physical memory. They are set in
the Java tab of the Apache Tomcat Properties. If the server has 2GB of physical RAM, the Java
Maximum memory pool should be under 2GB, so that the server has free memory to deal with other
OS tasks. For example, the Maximum memory pool should be ~1.5GB or less on a server with 2GB
of physical RAM. The Initial memory pool should be equal to or less than the maximum setting.
Depending on your server configuration, it is typically better to set the maximum and initial pool
setting to be equal. Note the screen examples show them unequal.
CBB also requires additional memory settings beyond the Maximum and Initial memory pool. These
settings can be expressed in the Java Options:
-Xrs
-XX:PermSize=512M
-XX:MaxPermSize=512M
-XX:+CMSClassUnloadingEnabled
-XX:+CMSPermGenSweepingEnabled
CBB Upgrade
11/12/13 12
The PermSize and MaxPermSize values should be higher than 256MB. In this example, where there
are 2GB of physical RAM, we have set the option to 512MB. Append the above options to the
existing options in the textfield of the Apache Tomcat Properties:
Example
Example
CBB Upgrade
11/12/13 13
Once these options are set, Tomcat needs to restart in order to pick up the changes.
Troubleshooting the PermGen Settings
If these changes are set, but operation of CBB yields “java heap” error screens, this indicates that
PermSize and MaxPermSize are too large. Set these values to a lower value and restart Tomcat.
If these changes are set, but operation of CBB yields “permgen” error screens, this indicates that
PermSize and MaxPermSize are too small. Set these values to a higher value and restart Tomcat.
Tomcat Configuration to Allow Larger POST Request Processing
In order to allow CBB communication to the OCX component, it is recommended to increase the limit
of the POST request that Tomcat handles. Normally this limit is set to 2MB, but may not be enough
to support certain requests CBB needs to provide full functionality.
To allow processing of such POST requests, change the Tomcat container configuration to the
appropriate limit. It is recommended to change the limit to 10MB or to void the limit completely. To
do this set the parameter maxPostSize within the Connector element. This element is found within
the server.xml file that resides in the Tomcat installation folder. Depending on the installation, this
file may be found under C:\Program Files\Apache Software Foundation\Tomcat 6.0 within the conf
directory.
There may be several Connector elements within the server.xml file depending on its configuration.
The POST size parameter is to be set on every Connector that is used to communicate with CBB.
This includes all HTTP, HTTPS or ajp connectors. If Tomcat is serving CBB only, then this parameter
can be securely set for all the Connector elements.
Setting the Parameter:
This parameter is set by adding to Connector element attribute maxPostSize="byte size" where byte
size is the maximum size of the POST request that Tomcat will handle in bytes.
Below is the example of the HTTP connector running on port 80 with the parameter set to void the
limit of POST request size (value is set to 0).
<Connector executor="tomcatThreadPool" port="80" protocol="HTTP/1.1"
connectionTimeout="20000" redirectPort="8443" maxPostSize="0" />
V. Install CBB 2.6.1
Note: Have you installed or updated ClientBase to ver 3.07.00 or above? Do this before
installing CBB version 2.6.1.
1. Reboot to ensure all services have started.
2. Log into the server as an Administrator.
3. Click Start|Run and type the URL (or right-mouse click on link and save or open in Web
Browser).
http://static.trams.com/tramslibrary/Releaseandupdatefiles/fullcd/cbb/cbb_26p1_setup.zip
4. If prompted, add To the list of "Trusted Sites."
5. Click Open and wait for download to complete.
6. Extract the zip file. Copy InvoicePrint.exe and DLL files to C:\Program Files\TRAMS\CBB (you
CBB Upgrade
11/12/13 14
may need to create this location or overwrite old files if present).
7. Copy cbb.war to C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps.
8. Browse to (or right-mouse click on link and save or open in Web browser):
http://localhost:8080/cbb/setup/
9. Enter "dontpanic" (without quotes) for the pass phrase.
CBB Upgrade
11/12/13 15
10. Click Edit Configuration.
11. Click Build URL.
12. Enter the name of the InterBase Server (or leave localhost if the CBB server and InterBase
server are one in the same), and click OK.
13. Enter the path to the database, and click OK.
14. Enter the JDBC User (default SYSDBA).
15. Enter the JDBC Password (default masterkey).
16. Click Save.
17. Click Main Menu.
CBB Upgrade
11/12/13 16
18. Click Done.
Congratulations! You have successfully upgraded to ClientBase Browser Version 2.6.1.