Category Archives: Lotus Connections

IBM Connections Directory Search breaks when User have quotes in a profile field

On one of my IBM Connections Site i had a problem with directory search (better the typeahead search). When we searched single characters no business cards are displayed.

I use Firebug for Chrome here and you see, that the search gets an result back from Connections, but no business cards are displayed.

When i open this get statement i get a list of profile documents in JSON format:

In this case i a got a list of about 20 User profiles. When i search a little bit more detailed i get an error of a Javascript, which should interpret the JSON list. Thanks to the developer (I think it is a dojo script)! “There was an error!” is a great response for troubleshooting and searching the error on Google or Bing!

The list has following format:

{"name":"John Doe","userid":"70026A2C-BE77-8491-C125-XXXXXX","uid":"john.doe@stoeps.tld","member":"john.doe@stoeps.tld","type":"0","ext":
{"first":"","groupwareEmail":"john.doe@stoeps.tld","guid":"70026A2C-BE77-8491-C125-XXXXX","mobileNumber":"+49 (123) 12 34 567","floor":"2nd","email":"john.doe@stoeps.tld","countryCode":"DE","givenName":"John","jobResp":"Assistant","faxNumber":"+49 (123) 456789","bldgId":"Member of "Android Lovers"","uid":"john.doe@stoeps.tld","sourceUrl":"ldap://ldapserver:389/(undefined=_search_base_)?(&(ObjectClass=*)(Attribute=1))","surname":"Doe","key":"00009asdkfjakf","displayName":"John Doe","telephoneNumber":"+49 (1234) 56789","distinguishedName":"CN=John Doe,OU=Admin,OU=DE,O=STOEPS","workLocationCode":"Munich","timezone":"Etc/GMT+12","lastUpdate":"2012-03-05 14:23:34.504"}

Problem here is the field bldgId: "Member of "Android Lovers"".

You can see double ” which are not masked. Our IBM Connections User can fill nearly everything in the fields in Profiles, but get no warning if he uses quotes and quotes are not masked, when they are stored in the database.

So when you have on user who uses quotes in one of his Profile fields, the typeahead search displays no results for character searches which contains this user (and no error message).

Finding such fields with regular expressions

I tested the typeahead search on all characters and copied the result of the GET statement out of Firebug and developed a regexp to find double quoted strings:

:\"[a-zA-Z0-9\.\/\,\+\-\:\s äöüÄÖÜ]*\"[a-zA-Z0-9\.\/\+\-\:\s äöüÄÖÜ]*\"

On Mac OS X you can use RegExRX or Notepad++ on Windows to test this regexp and you will get the wrong field values.

TDI and Typeahead

You can see in the result list, that TDI Search Urls are saved in each profile document too! "sourceUrl":"ldap://ldapserver:389/(undefined=_search_base_)?(&(ObjectClass=*)(Attribute=1))", so please be careful, when you configure your search strings, because a double quoted attribute breaks typeahead search too!

IBM Connections: File download with IE 9 without [1] on extension

File download with Internet Explorer 9 modifies the file extension and so files can’t open with any installed application. Problem occurs with IBM Connections 3.0.1 and 3.0.1 with installed CR3.
IE 9 isn’t supported in the moment, but with a little tweak on IHS side, it is possible, that IE 9 download files without modifying the extension.
Biggest problem here is, that opening attachments will open the “Open with” dialog, because no application is linked to a file extension .pdf[1].

Normal file download with IE9 and IBM Connections:

The http header shows following line for the download file and the name:

Content-Disposition: attachment; filename*=UTF-8'en'%42%6f%6e%75%73%20%53%79%73%74%65%6d%20%76%32%2e%70%70%74%78; size=2563575; creation-date="Fri, 2 Mar 2012 13:37:39 +0100"; modification-date="Fri, 2 Mar 2012 13:37:39 +0100";

Sjaak Ursinus shows modifying http headers to solve issues with Chrome and IBM Connections Files. I made some tests with his explanation and added some lines in http.conf (you have to enable mod_headers and mod_setenvif):

<IfModule mod_setenvif.c>
SetEnvIf User-Agent "MSIE 9\." IE9
<IfModule mod_headers.c>
Header edit Content-Disposition "^(.*)filename\*=UTF-8['a-z]{4}(.*)$" "$1filename*=$2" env=IE9

What does this part of the http.conf?

I set an environment variable IE9, if the user agent contains “MSIE 9”.

The Header edit removes UTF-8’de’ from filename, if the environment variable is IE9 (env=IE9). I modified the regexp, that all languages after UTF-8 were removed. So the http header looks like this:

Content-Disposition: attachment; filename*=%43%41%54%20%53%63%68%6c%c3%bc%73%73%65%6c%2e%65%6d%6c; size=7637; creation-date="Fri, 30 Dec 2011 10:44:20 +0100"; modification-date="Fri, 30 Dec 2011 10:44:20 +0100";

So you can open the file and it will be opened with the linked application for this extension.

Changing interface language in DB2 Control Center

I often install IBM Connections on localised operating systems, so normally DB2 control center get started with a non-english language.

Interface language in DB2 control center can be changed through environment variable DB2LANG. After setting DB2LANG=EN and restart db2cc i get a english interface.

Problems with Mobile Fix and IBM Connections 3.0.1

The last two weeks i installed two IBM Connections 3.0.1.

After installing i went to IBM Fix Central and look for the latest fixes. There are 7 Fixes available and for Multi Mobile Patch it shows a superseded fix. So i decided to download patch one to seven and ignored july mobile update.

Available Connections Fixes on 2nd of march 2012

I installed the fixes as ever.

  • Updating updateinstaller
  • Disabled node synchronisation
  • Disabled Application Server automatic starting
  • shut down the Clusters
  • synchronize nodes
  • and so on.

After the installation i can’t use the mobile apps for iOS, android or Blackberry. The error messages shows “You have to install the July 2011 mobile patch to use this app.”

I made a download on Fix Central again, because i thought i made an error to ignore the july patch (LO61851), so i mark LO64399 (October Patch) to download and activated “Include requisites: Yes” and got following download options:

No other patch is shown as prerequist for this mobile patch! But i downloaded july fix (LO61851) to test this one.

I uninstalled LO64399 and startet again with LO61851. No success! After restarting i installed LO64399, but no mobile App works.

Shazza Bellamy gave me the hint to install the august mobile fix (LO63049). I searched on Fix Central, but no download was available. One of my colleagues stored the patch on our NAS and she sent it to me too. After uninstalling the other two mobile fixes i installed august fix (LO63049) and restartet again and what should i say? On both Connections Installations the mobile Apps are working.

I don’t know why LO63049 isn’t available on Fix Central and i have no idea why LO61851 is not enough for mobile Apps on my new installations. I have older systems which are updated from 2.5 or 3.0 where only LO61851 is installed and mobile apps are working.

Perhaps i can save you time with this post, because i invested some days on discovering the error and installing fixes again and again.


Today i read a post on IBM Developerworks, which describes the error and a solution. Sjaak Ursinus found the reason of the failing update: ifix LO64399 and Windows 2008 R2

First steps with blogsy on iPad

Last week a new blog editor for offline blogging has announced IBM Connections blogs support.

Blogsy is a nice tool and costs about 4€ in apple app store.

My first tests are not very good, because Blogsy 3.3 has problems with multiple Blogs in IBM Connections. Only one day later, after some comments in Blogsy Blog, a new version can be downloaded from Appstore. Blogsy 3.3.1 can handle multiple Connections blogs, but the App crashes right after uploading a new post. I hope they will make a updated version soon.

I enjoy offline blog editors very much, because i can prepare articles on train and upload them later after i found a free WLAN. This is my first non-test post with Blogsy. Integration is very good and you have quick access to web content, Youtube and Flickr.