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.
#Virtual Host for the Connections Server
RewriteRule ^/$ https://connect5.belsoft.ch/homepage [R,L]
#VirtualHost for the proxied Domino
ProxyPass / http://ldap.lab/
ProxyPassReverse / http://ldap.lab/
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
if [ -f $BASEPATH/last.run ]; then
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
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.
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.
I’m not able to remember the syntax for the updateSilent.sh command to show which iFixes are installed.
So I just wrote this showiFix.sh just adjust the variables in it to your own environment.
Use at your own risk.
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
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.
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][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.