Hi I am currently involved in upgrading wf and have to write up the process so I might as well post this online so as to be of use to others and also get some feedback for myself.

This is the implementation of the plan outlined in

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/1061082732

1. Create new website

In IIS right click and select create new website

IP address - leave all unassigned
TCP port - 76 (for obvious reasons)
Host header = none
home = inetpub/wwwroot
Access permissions = read

After wizard click on properties

Enable anonymous access
Click on advanced and Copy the host headers from old website
Set default webpage for home page otherwise you get not auth otherwise

2. Create new MRrealmdb (managed reporting database) in Sequel Server

In sequel server create new database MRrealmdb76 copying the items on existing properties tab and allowing double the size (roughly 10MB).

After creation compare new and existing and note there are wf_ tables that need to be copied, but will defer and see whether client install creates its own.
3. Create new Rcaster (Reportcaster database) in Sequel Server

In sequel server create new database Rcaster76 copying the items on existing properties tab and allowing double the size (roughly 200MB additional size being mainly down to the job logs that are stored there).

Client Install

1. Client install is wfinst762.exe.
2. Install all features (3 ticks).
3. Prefix all directories with wf76.
4. Program menu folders (more importantly windows service names) need 76 included in defaults.
5. Reporting server is on :9120 and the webserver is on :76.
6. w/s and application server (a/s)
7. rcaster repository
Server port :9200
Works out that MSSQL 2000 is running
Tick report library
8. JDBC Classpath - did browse and selected defaults - install process had picked correct directory.
9. Rcaster database and login
Used new database and default port :1433
Could not remember password so set up new user
security - logins - database access and permit in db_owner role.
10. Mail server - copied from previous release.
11. Web Application Server Options
x Config access
tick install 5.5 Apache Server
tick config Tomcat IIS plug in
Blue Message: This install has not detected valid JVM.
12. wf auto config option
ticked only:
Set wf directory permissions
Create caster repository tables
13. Prompt about to install.
Told dev users that they had to save work and disabled IIS service

Install Process Messages

1. wf file install went ok
2. install of java 5.09 prompted me to close the wf install procedure! Clicked ignore and it reported back a successful install.
3. After this the screen goes blank and puts up the odd message
Configing Tomcat...
Tomcat as IIS plugin...
Successfully created the Rcaster tables - lists the tables it created.
Configuring managed reporting (strange since nothing about this in the install questions)
Configuring WebFOCUS
Screen then goes agonisingly TOTALLY BLANK.
Then Successful install finish to exit.


Restarted IIS Checked that existing wf 71 installation was OK

Post installation inspection

1. wf76/ibi/Webfocus76/ files present.
2. Registry entries created
software/Apache Software Foundation
system/services/Tomcat5
3. Start menu options wf 76 client there but apache entries required a restart.
4. Check of IIS revealed that IS API filter, Jakarta, had been added to electra:80 website not electra:76 as specified. Technically this a bug in the install process. Wondered how the existing 7.1 system was still working - more on that later.

Configuring IIS to Use the Tomcat Connector (Plug-In) see 7.61 installation manual p128.

A. Checks out it's installed in:
C:\Program Files\Apache Software Foundation\Jakarta Isapi Redirector
HKEY_LOCAL_MACHINE\SOFTWARE\Apache Software Foundation\Jakarta Isapi R
edirector\1.0


B. Set up IIS aliases (virtual directories) need to be set up for IIS Web site electra:76

Directory containing Managed
Reporting and other front-end
components.
/ibi_html = drive:\wf76\ibi\WebFOCUS76\ibi_html
Read and execute permissions appears as wheel


Directory for accessing self-service
WebFOCUS applications.
/approot = drive:\ibi\apps
Read only permissions appears like a ball.

Directory of the Tomcat Connector.
This is needed when using Tomcat
with IIS.

/jakarta = C:\Program Files\Apache Software Foundation\Jakarta Isapi Redirector\bin NB no end \
Read, scripts and execute permissions appears as wheel


C. The following file is added to the electra:76 Web site as an ISAPI Filter:

jakarta = C:\Program Files\Apache Software Foundation\Jakarta Isapi Redirector\bin\isapi_redirect.dll

Click on Properties of web site (NOT of IIS) and look under ISAPI filters. NB when you add it, it does not appear with a green pointer. It requires a restart of the IIS service to sort this out.

D. Add the following lines so redirection works as in 7.1

to C:\Program Files\Apache Software Foundation\Jakarta Isapi Redirector\conf\uriworkermap.properties

/ibi_apps=ajp13w
/rcaster=ajp13w

E. On Windows 2003 Server, you must create a Web Services Extension for the Tomcat
Connector.

1. Open the Internet Services Manager. You can access this from the Start menu by
selecting Start, then Run, and entering the following:
inetmgr
The Internet Information Services window appears when you hit Enter.
2. Expand your hostname on the left, right-click Web Service Extensions, andselect Add a
new Web service extension.
3. In the Extension name field, enter:
jakarta
4. Check Set extension status to allow.
5. Click Add and browse to select the isapi_redirector.dll file. For example:
C:\Program Files\Apache Software Foundation\Jakarta Isapi
Redirector\bin\isapi_redirect.dll
6. Click Open and then OK to close windows and return to the main Internet Services
Manager window.
7. Ensure the Jakarta-Tomcat Web service extension's status is set to allow.
8. Restart IIS.
Reference:

F. The following filter is deleted from electra MACHINE as an ISAPI Filter:

ServletExec = c:\InetPUb\Scripts\ServletExec_ISAPI.dll

Click on Properties of web site (NOT of IIS) and look under ISAPI filters.

If the ISAPI filter is on the machine it will be applied before any filters on the Website. Thus all websites will redirect to the atlanta servlet! This is the key to running the atlanta servlet and apache together.

G. The following file is added to the electra:80 Web site (existing 71 install) as an ISAPI Filter:

ServletExec = c:\InetPUb\Scripts\ServletExec_ISAPI.dll

Click on Properties of web site (NOT of IIS) and look under ISAPI filters. NB when you add it, it does not appear with a green pointer. It requires a restart of the IIS service to sort this out.

H. The following file is added to the electra-ext:80 Web site (existing 71 install) as an ISAPI Filter:

ServletExec = c:\InetPUb\Scripts\ServletExec_ISAPI.dll

Click on Properties of web site (NOT of IIS) and look under ISAPI filters. NB when you add it, it does not appear with a green pointer. It requires a restart of the IIS service to sort this out.

I. Use test page of http://electra(:76)/ibi_apps/about.jsp to confirm everything is ok on both 71 and 76 sites.

Next copy of config files and configuration of MRE.

Configure Client
================

1. Note that 7.6 no longer creates a client "JSCOM3?" process unlike 7.1
strangely the 7.1 client ran a cut down version of the server edapsrv.exe
could find process tree was
edapsrv.exe
edaplog.exe - process log
edapth.exe - w/space mgr
edapgwy.exe - tcp + http + dfm

strangely could find no JSCOM3 even though I had node=JSS.

2. Started by trying to copy old configuration files starting with odin.cfg
The new version only contained an entry for the server whereas old version had loads of entries.
changed 81 to 91 throughout and the javaserver/JSCOM3 listener had to change classpath and delete entries
threed.jar;IBIGifGraphChart.jar;WFAppPass.jar
This now irrelevant see 1 above.

3. Copied ibiweb.cfg - this was a mistake since got message "unable to establish connection to WF Admin Console" and had to revert to installed version and restart IIS.

4. Decided to copy settings through comparing 7.1 and 7.6 admin consoles (this will let you in as admin with no password with installed default).
old: = only appeared in 7.1
new: = new for 7.6

A. Client Settings - General
new: IBIF_max_messages - 20k - useful to stop runaways but may affect batch jobs. Set back to 0 for time being
new: WF_prog_list_from_wfrs - might help with applock problems.

B. Client Settings - General
old: Display - only affects unix X windows
old:IBIF_graphHeadless - ditto
old:IBI_USE_JScOM3 - no longer required if you dont use CGI

c. Client Settings - Managed Reporting
new: Reporting Cache - switched off during testing
new: Domains Cache - ditto
new: Users Cache - ditto

D. Client Settings - Parameter Prompting
old:IBI_USE_JScOM3 - no longer required if you dont use CGI
new:IBIF_describe_xsl - default of autoprompt_top changed to autoprompt so this still works the same

E. Client Settings - Reportcaster
Change 8200 tO 9200

F. Startup Parameters.
old: EDACONF no longer required.
IBIWFC_Authentication = EDA + added admin user on Oracle database


G. Redirection settings - same display but no longer has translate column and content disposition is a check box.
Kept new version but noted the differences.

changed: .mht content(text/mht now message/rfc822)
new: .ppt .foc .acx .sqlout .swf .sql

Configure MR
============

1. Configure MR settings.

A. MR Security Settings - General
Authn - ORCL Authz - SQLS

B. MR Security Settings - External directories

DS tried and got wfc1003 userid or pw incorrect

Problem was authenication did not work because Oracle not in classpath of Apache
Authorization did not work because the default host for sqlserver had been left as hostname instead of being set to electra


C. MR Security Settings - Advanced
new: SYNC_CASTER_ON_MRSIGNON - left as default
update default: case to default
new: all caches disabled for testing via DISABLE_CACHE=true


2. Migrate MRE settings

Utility is MRMIGRATE.bat IN 7.6

Note this java applet a bit tedious -
Path structures start at 76 installation watch out - must have both items highlighted to extract directory name


tO locate existing dashboard enter c:\ibi\webfocus71 not c:\ibi
this will copy
c:\ibi\webfocus71\worp\worp_custom and worp (with backups)
and
c:\ibi\webfocus71\worp\conf\mpv.xml (holds list of public, groups and users)

and as a default repository - will prompt you for more which I did not need
c:\ibi\webfocus71\basedir (with backups)

to an install in c:\wf76\ibi\webFOCUS76\migrate.zip and then onto the new directories with backups.

It does not copy

bid.config.xml;bid_favorites.xml;bid_recents.xml;bid_user_preferences.xml;view_config_template.xml;view_config.dtd; worp_mre.mpd(public user and password file)

All of which are clearly configuration files since they have changed in 7.1. I decided not to risk copying any of these since it might be the formats have changed. I logged onto dashboard view builder and set the default public user.

3. Migrate mre Sql server repository. sql 2000

p.179 of the install manual details this process

A. Use SQL Data Transformation Services to copy the tables.
B. Increase the size of the domainname through default display.
C. Use SQL query analyser to insert the new library only role. However on testing this was found to cause problems in MRE Admin since the array size had not been increased. So dont bother until fixed.
D. Used default display of table to check that userids and loginnames are already in lowercase as now required.

4. Enable dual login facilities for logon.htm and WORP_Login.JSP.

Apply Customisations
====================

Look for system files modded since 7.1.3 install. Compare these against original using WinMERGE a very useful piece of freeware and then apply changes to new 7.6 set up. Be careful you reboot IIS since it tends to over cache stuff despite earlier setting all ibi cache settings off.

Finding the mods was very tedious in future propose the following for 7.6

Held in the Webfocus root directory eg c:\ibi\fslversion.txt shows patches etc applied.


If webfocus code is modified (not standard configuration files like edaserve.cfg etc) then the original should be given the file extension .original on the end

Eg execelredirect.jar is rename excelredirect.jar.original

If the code is a modification that applies to the ifs system only then use the extension .originalifs
If the code is a modification that applies to the external system only then use the extension .originalexternal

These extensions will be used by a utility that automatically propagates modifications to the webfocus environment.

These are Sample Comments to show where the customised code is located. 'FSL' start and end can be searched on; the rest is up to the coder.

1. html .HTM, .HTML

<!-- FSL Start - Single signon for dashboard -->
          <input type="hidden" name="WORP_DUAL_LOGIN" value="true">
          <input type="hidden" name="WF_USER" value="">
          <input type="hidden" name="WF_PASS" value="">
<!-- FSL End - Single signon for dashboard -->    

2. javascript .JS

// FSL Start
  String sbSubmit = WORP_VBFU.makeLoginButton(WORP_Utilities.getDBVar(language, "sLogon"), "javascript:doSubmit();");
// FSL End

3. java server pages .JSP

<%-- FSL Start - Single signon for dashboard --%>    
          <input type="hidden" name="WORP_DUAL_LOGIN" value="true">
          <input type="hidden" name="WF_USER" value="">
          <input type="hidden" name="WF_PASS" value="">
<%-- FSL End - Single signon for dashboard --%>    
 

Reportcaster

1. Start rcaster service and change to automatic. process is called schbkr.exe

2. Included Oracle jar in classpath.bat - this not really essential

3. Get in via admin and blank passwords.

4. Sync the 71 and 76 rcaster consoles

5. Cant get in on console now authentication = mr trusted login.
Have to login via the command line version under start menu - rcaster menu to look at parameters.
NB also the encrypted params file is auto backed up.
Checked that trusted keys for rcaster and mre were in line.

6. Could not get mr trusted login to work. went ahead with conversion of rcaster database.
Utility was in start menu - rcaster. Took about 1 minute does both the extract and load which is a bit surprising.

7. Checked to see if mr trusted worked - IT DOES NOW. YOU HAVE TO CONVERT RCASTER TABLES TO GET MR TRUSTED TO WORK. Why I dont know nor care...

Client install of external (OPSYS based) second instance of wf.
===============================================================

This was per the Oracle based install except the following.

11. Web Application Server Options - none were ticked because the website was entirely manually to be set up to use Tomcat as the application server.

When it came to setting up the web application server I figured that since the Tomcat was merely serving programs with parameters then it should not matter that ibi_apps pointed to the original instance I had installed since the programs were the same. I tried to get away with using the same application server for both websites and this certainly had worked with the Atlanta Servlet.

Certainly this proved to be true in that ibi_apps responded ok but when it came to modifying parameter files contained in the webfocus76/client/wfc/etc directory then it seemed that the files in the first instance were always served up. Also the first authenication method would always apply.

Refer to TM4595 "Installing Multiple Instances of WebFOCUS using Apache Tomcat on Windows"

This explains we have install an additional copy of Tomcat on port 9080 and then configure this new copy with the second website.

The stages are quite straightforward with the following snags.

1. The doc refers to Tomcat 5 and the install has given us 5.5 (Apache just regards these as a later release of 5 rather than something different)

2. Page 10 Step 4 - I could not get the delete and use server console to save new version of these files to work so I just edited ibi_apps.xml and rcaster.xml and changed the context directories.

3. Step 9 change count to set mind at rest.
8080 - 9080 2 comments and 1 file entry
8005 - 9005 1 file entry
8009 - 9009 1 comment and 1 file entry

4. Step 12. The installation done as part of wf 7.62 does not install service.bat

to get it go to:

http://tomcat.apache.org/download-55.cgi#5.5.23

downloaded the .zip version of files since I did not wish it to go into install dialogue. Copy service.bat from the directory outlined.

5. Page 28 Step 8 Typo in that Second entry is log not logs.

6. Configing IIS to accept the 2nd Tomcat it is happy to call both ISAPIs jakarta as the manual says but my instinct was that they should have been given different names, but I did what the book said and it worked fine.

Installed the client in the live system for parallel running yesterday.

Test: Client and Server on same machine
Live: Client and Server on different machines

The wf client installation process has a flaw in its design in that it assumes the client and server are on the same box and so it never even asks you where the server is located.

Much fun then ensues setting the server to point to the correct machine. Its a niggle I can live with but something that should be pointed out.

The WF client install has a pannel that asks you the host id, the tcp port number, and the service for z/OS. It uses that to build the default EDASERVE node in the odin.cfg file.
Did that not show up? (If not, please contact technical support and tell us the license code you are using and send in the screen shot ...).

Hi Brian

Yes my apologies - just done the opsys install and it DOES prompt for Server.

It actually prompts for Server and WebServer (not client - this is implied) and I didn't read all the writing!

Regards

John

I don't know if this is a good thread for comment but I thought I'd add it anyway.

I am testing reports written for v5.3.4 on v7.6.5 and have come across this code-tightening:

Someone incorrectly had a comment as

--*-- Testing

instead of

-*-- Testing

This was OK for v5.3.4 but caused a problem in v7.6.5 - the WebFOCUS error did not relate to the wrongly coded line so it took a while to notice the error.