Examples for user/group role mapping for Lotus Connections

A customer recently had the requirement to grant only a specific group of users access to Lotus Connections. As you probably know this can be achieved by configuring the user/group role mapping in WAS. Since a screenshot makes it more clear than following the Info Center, I’m providing the configuration I implemented:

Bildschirmfoto2010-04-27um11.07.53.V7JRoijKq2fH.jpg
Bildschirmfoto2010-04-27um11.09.23.rurawAVOIuEm.jpg
Bildschirmfoto2010-04-27um11.10.00.hlp5xjaae8PL.jpg
Bildschirmfoto2010-04-27um11.10.24.muO5M5GiBtDp.jpg
Bildschirmfoto2010-04-27um11.11.08.A2cQpQQLIlHB.jpg
Bildschirmfoto2010-04-27um11.12.51.TzIzlAEckZdt.jpg
Bildschirmfoto2010-04-27um11.13.29.yppTc3S04Dj9.jpg
Bildschirmfoto2010-04-27um11.15.18.bS2WHxJCrlgz.jpg
Bildschirmfoto2010-04-27um11.15.42.lXi4RoamMqAk.jpg
Bildschirmfoto2010-04-27um11.16.58.mMPnW5AZLvjY.jpg
Bildschirmfoto2010-04-27um11.17.42.GOzsycFZkaav.jpg

You also need to modify LotusConnections-config.xml to set service_extension_auth for Communities and Profiles to “DSX-Admin”:

Bildschirmfoto2010-04-27um11.19.48.Su9l7SqWUKg4.jpg

Using WASService

I keep getting asked how to automatically start WebSphere Application Server (WAS) server instances upon restart of the Windows Server.

To do so there is a nice little tool provided with WAS called WASService which adds the server instance as a Windows service:
Bildschirmfoto2010-03-10um09.25.12.png

So for example, to add a service called “lcMisc“ based on a server definition “lcMisc” you would add it like this:
Bildschirmfoto2010-03-10um09.25.40.png

The credentials specified with -userid define the local or domain user account who will be used to start the service.

NOTE: When WAS admin security is enabled you need to provide that information with -stopArgs. Otherwise you won’t be able to stop the server through Services.msc.

When looking at Services.msc you should see the service you have just created:
Bildschirmfoto2010-03-10um09.13.58.png

You can also use WASService to remove the service:
Bildschirmfoto2010-03-10um09.25.55.png

NOTE: When you need to update the configuration of the service (e.g. changed credentials), just re-use the -add command as shown above with the changed information.

The configuration of the service is stored in Windows registry in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\, for example:
Bildschirmfoto2010-03-10um09.36.42.png

Bildschirmfoto2010-03-10um09.35.35.png

OPTIONAL: Sometimes you need to start services in a specific order, let’s say database first and WAS server second. To do so, please follow the instructions on How to delay loading of specific services in the Microsoft Knowledge Base.

Basically, you need to add a value called “DependOnService” with a data type of REG_MULTI_SZ to the service definition and add the name of the service it depends on as the data of that value. For example:
Bildschirmfoto2010-03-10um09.35.56.png

NOTE: As this value is of type REG_MULTI_SZ you can provide more than one service name (each on a separate line).

In the following example, “nodeagent” needs DB2 and Lotus Domino to be started while itself is a pre-condition for “lcApps” and “lcMisc” services.

Bildschirmfoto2010-03-10um11.09.31.png

NOTE: You can’t modify these dependencies in Services.msc, you have to modify the Windows registry instead.

Active users in Lotus Connections

A customer asked how the number of active users (not only logged in but actually added content somewhere like created an activity, made a comment etc.) could be retrieved from Lotus Connections.

As you probably know from the Info Center Lotus Connections provides statistics for each component but not consolidated for all of them on one page.

When I looked at the database it became clear that a simple SQL UNION would not work as by default different databases are created during installation.

As I personally love the functionality of IBM Mashup Center I came up with the idea to combine the results from each database script and provide the output as an ATOM feed for further processing.

Here’s what I did:

  1. First I created 5 SQL scripts for Profiles, Communities, Blogs, Dogear, and Activities to retrieve the GUIDs of all active users.
  2. Then I used those SQL scripts as feeds in InfoSphere MashupHub. Here some screenshots:

PastedGraphic2.gxwtDvwy5cKj.jpg
PastedGraphic3.LgApj7R0yIbn.jpg
PastedGraphic4.lqtOOEZrTcUt.jpg

3. After I defined 5 feeds, I created a feed mashup using simple operators and published the result as an ATOM feed:

PastedGraphic5.Jc87J9jd7EWM.jpg

4. In Lotus Mashups I made a sample page to verify everything worked as expected. On the left hand side you can see the feeds I created in 2. and as you may notice different users were active in Activities and Communities. On the right hand side you can see the feed mashup and how it combines the active users into one consolidated result…

PastedGraphic6.f2B8t8NZJv63.jpg

I’m loving it! :-)

Forcing applications to a different language on Mac OS X

Even though I’m a native German speaker I prefer to use English as my primary language for any IT.

When a specific application doesn’t provide a setting to switch the language of the UI, you can still “force” the application to use another language.

Here’s how:

Let’s say Aperture opens in German because the language of Mac OS X is set to German.

PastedGraphic8.KOXE391hRxaP.jpg

Now ctrl-click (right click) on the Aperture icon in Applications and choose “Get Info”:

PastedGraphic30.sYIzeZ1wXnof.jpg

When Aperture info opens, you’ll find a section labeled “Languages”. This were you can deselect any unwanted languages (in my case all except English):

PastedGraphic31.LcTqP5VaCFiy.jpg

The next time you start Aperture, it’ll run in English:

PastedGraphic7.ugKUVM1bHhfS.jpg

I love Mac OS X! :-)

BTW, the open beta of Lotus Notes 8.5 doesn’t yet provide any other language but English.

Confluence wiki integration in Lotus Connections – Part 2 (Usage)

Did you ever wonder how the integration of Confluence wikis in Lotus Connections looks like? Well, here some screenshots of basic operations:

After the installation of the Communities Connector for Confluence, you’re ready to use it within your communities.

When starting a new community you can also create a new wiki for that community automatically:

PastedGraphic9.qd3jZMkPphTW.jpg

The wiki is accessible from Lotus Connections as from Confluence directly:

PastedGraphic10.Cl2IAaY5DLdO.jpg
PastedGraphic11.qXDkfMfelubr.jpg
PastedGraphic22.fgDJDDPWGLXB.jpg

On the backend, a new user group will be created in the Confluence wiki database. This helps to keep group memberships in Lotus Connections Communities and Confluence wiki in sync. Both are connected to the same LDAP.

PastedGraphic12.hMlCVKPVdqQI.jpg
PastedGraphic13.d0feJ1Xf9xVN.jpg

When adding a new user to the community, he will also be added to the wiki’s user group automatically:

PastedGraphic14.rz5y0TFEvy7f.jpg
PastedGraphic15.PUu3XEchu2YK.jpg

When the community is deleted in Lotus Connections, it’ll be also removed from Confluence:

PastedGraphic16.f7g9idMrZt1N.jpg
PastedGraphic28.5645YCR4UEEf.jpg

So much for basic operations with the Communities Connector for Confluence. Let me know if you need further information.

Confluence wiki integration in Lotus Connections – Part 1 (Installation)

I tested the integration of Confluence wiki in Lotus Connections using the Communities Connector for Confluence. In case, someone else is interested I’m posting here some screenshots.

First you need to install and configure Confluence (LDAP/SSL) and define authenication aliases on WAS: one as an LDAP bind user and another one to manage the Confluence wiki.

PastedGraphic12.566kQ6ihT46J.jpg
PastedGraphic13.WcW7E94oFoMy.jpg

Then, you are ready to start the installation of the Communities Connector for Confluence:

PastedGraphic17.tzdEK9KTxZiv.jpg
PastedGraphic18.TYcaSwZz6Vrq.jpg
PastedGraphic19.nc024m4r8E6G.jpg
PastedGraphic20.riBAPyfIYucs.jpg
PastedGraphic21.xlnohl4ygsAI.jpg

Interested in more information about the Communites Connector for Confluence? Continue reading here…

Taking activities offline in Notes

The ability to work with Activities offline is not enabled by default. If you want to see a technical preview of the offline feature, edit plugin.properties in Lotus\Notes\framework\shared\eclipse\plugins\com.ibm.openactivities.client.common.service_<...> and set activities.enable.offline=yes (at the end of the file).

Restart Notes client.

Mac OS X “Leopard”: Using NAS with Time Machine

Though, Tony already posted the magic command to make non-local volumes (connected through smb, nfs or afp) visible to Time Machine, I want to give a brief description on how I configured Time Machine on my MacBook Pro to use a Windows share.

1. First let’s make sure the volume isn’t already mounted:

PastedGraphic.VvVD111POnCG.jpg

2. Now mount the Windows share in Finder (Command (Apple) – K):

PastedGraphic1.aEzT9eP1Xo5H.jpg
PastedGraphic2.2Dke91Q3ykoQ.jpg

3. The Windows share will appear in the ‘Shared” section in Finder:

PastedGraphic3.VN731eQWM81V.jpg

4. To verify, open Terminal and check the mounts:

PastedGraphic4.eO4eFVdNUjlc.jpg

5. Enter “defaults write com.apple.systempreferences TMShowUnsupportedNetworkVolumes 1″ in the Terminal window to make unsupported network volumes visible to Time Machine:

PastedGraphic5.lHvOtqvoTpMz.jpg

6. Now you can configure Time Machine (System Preferences -> System -> Time Machine):

PastedGraphic6.DTwFca3w9i5t.jpg
PastedGraphic7.sm9U6npPisTv.jpg
PastedGraphic8.aUy5R5DCUP0L.jpg

7. Done. Time Machine is now ready to backup your data…

PastedGraphic9.yCCBFMcw4DzG.jpg

8. …unfortunately there is not enough space on the Windows share ;-)

PastedGraphic10.SbeyT1bfXBSa.jpg

9. But at least you can see that Time Machine tried its best:

PastedGraphic11.FNQ85gb3ZRoV.jpg

BTW, with “defaults write com.apple.systempreferences TMShowUnsupportedNetworkVolumes 0” you can revert the setting.