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! :-)

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…