Configure the Connections IBM HTTP Server as a reverse Proxy

Open the httpd.conf.

Uncomment the following lines

LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_http_module modules/mod_proxy_http.so

Add a new Virtual Host entry.

<IfModule mod_ibm_ssl.c>
 NameVirtualHost *:443
 Listen *:443
 #Virtual Host for the Connections Server
 <VirtualHost *:443>
  ServerName connect5.belsoft.ch
  SSLEnable
  RewriteEngine On
  RewriteRule ^/$ https://connect5.belsoft.ch/homepage [R,L]
 </VirtualHost>

 #VirtualHost for the proxied Domino
 <VirtualHost *:443>
  ProxyPreserveHost On
  ProxyPass / http://ldap.lab/
  ProxyPassReverse / http://ldap.lab/
  ServerName tools.belsoft.ch
</VirtualHost></pre>
<pre></IfModule></pre>
<pre>

 

Keep an X-Page in Memory

Evreybody knows that starting an XPage for the first time takes some time. Using the Notes.ini parameter for preloading the xpages can become slightly difficult if you have a lot of apps.

My solution is quite simple

 
#!/bin/bash 
USERNAME="UserName" 
PASSWORD="Password" 
BASEPATH=/opt/ibm/apps 
LOGIN_URL="https://[SERVER_NAME]/names.nsf?login" 
XPAGES_URL="https://[SERVER_NAME]/[PATH_TO_NSF]/myXpages.xsp"
if [ -f $BASEPATH/last.run ]; then
rm $BASEPATH/last.run
fi
wget --save-cookies cookies.txt --keep-session-cookies --post-data "Username=$USERNAME&Password=$PASSWORD" --delete-after $LOGIN_URL 
wget --load-cookies cookies.txt --delete-after $XPAGES_URL
if [ -f $BASEPATH/cookies.txt ] ; then 
 rm $BASEPATH/cookies.txt 
fi 
touch $BASEPATH/last.run 

Place this file on the server and call it through cron on a regular schedule and your xpages should be always loaded.

As always, use on your own risk.

IBM Connections – Wiki RichText editor missing

After installing Connections 5.5 and migrating the content, the wikis would no longer be editable. The richtext editor would not load.
The newly created lab environment without any customizations/data worked.
After digging around the system, I found that we had the some additional ckeditor widgets activated in the wikis.
Removing the file from /ConnectionsData/shared/customization/javascript/lconn/wikis/ckeditor.js and restarting common and wikis app resolved the issue.

 

Some blog pictures not shown after Migration

After I migrated our Connections from 5 CR3 to 5.5 some of the blog images were missing.

Resolving the issue:

Step 1: compare the [ConnectionsData]shared/blogs directory on both servers.
Compare a single blog you could just need to know the ID. for example 4b399954-c36a-4b8e-b281-0ad62937a83c. Then you would go to
[ConnectionsData]/shared/blogs/upload/4/b/3/4b399954-c36a-4b8e-b281-0ad62937a83c directory and compare the number of files
ls -l |wc -l
Source and migrated directory contained the same files.

Step 2: check if the missing pictures have umlaute or special characters.
if this is the case, then there might be the following line missing in .bashrc
export LANG=en_US.UTF-8

 

 

Connections Data side by side Migration 5.0 CR3 to 5.5 – Files issues

Today I did a test migration of our productive Connections 5.0 CR3 environment using the instructions in the IBM Knowledge Center for a side by side migration.
Using rsync to copy all the shared files to the new Connections server worked ok.
Createing the 5.0CR3 database and migrate all the DB2 data to the new server went well.
Then I created the missing PushNotification database using the 5.5 Day 1 DBWizard and afterwards updated the existing db’s. The wizard reported an error upgrading the files db. Running the wizard again showed that the files db was already on 5.5.
Starting connections and testing the deployment showed that I was not able to open the files. And some errors in the files servers systemOut.log. So I decided to redo the db2 migration from scratch.
This time I updated all the databases except the files. Running the wizard to update only the files db failed again. This time I went through the log.
The error  “DB21034E The command was processed as an SQL statement…..” while dropping some triggers appeared several times and exit value was 4.
Fortunatly I stored the SQL commands for the update when I ran the dbWizard. I ran the appGrants.sql, reorg.sql, updateStats.sql and pns-dropDb.sql from connections.sql/files/db2 directory.

The result is that the files are now available in connections.

 

 

 

 

 

IBM Docs 2.0

If you have the following errors in your docs SystemOut.log

error when executing SQL:SELECT * FROM “CONCORDDB”.”DOC_HISTORY” WHERE “REPO_ID” = ? and “URI” = ?
com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][3.65.110] Invalid parameter: Unknown column name DOC_ID. ERRORCODE=-4460, SQLSTATE=null

or if sometimes the docs displays a “Conversion server not available” error although the viewer displays the file.

Then maybe you have forgotten to upgrade the DB Schema while updateing Docs. Running the upgradeSchema.sh / upgradeSchema.bat is your friend.