All posts by Martti Garden

Files Plugin for Lotus Notes does not upload documents

If you are using the Files Plugin Lotus Notes from the Greenhouse Solutions Catalog, you may be finding yourself being able to see and download all files in IBM Connections Files repository, but when trying to upload a file though, you might get an error message like that:

A problem with the server was encountered.

 

To solve that problem you need to add one line to Lotus Notes plugin-customization.ini:

com.ibm.documents.connector.service/ENABLE_SSL=true

Then save the ini-files, restart the Notes Client and the upload should be working now.

The plugins-customization.ini can be found in your Notes install directory/framework/rcp in Windows.  Mac user right click the Notes.app icon and choose “Show package content”. Then they go to Contents/MacOS/rpc/ .

iFix LO64399 for Mobile Support in Connections does not work on Windows 2008 R2 Enterprise Edition

Some may have noticed that even after installing the iFix LO64399 September Update for IBM Connections 3.0.1 the mobile Applications on iOS and Android don’t work, even though the iFix Installer says it has been sucessfully installed.  Sjaak Ursinus found the reason for it: This problem only occurs on Windows 2008 R2 Enterprise Edition and is due to a missing support line for this OS in the iFix.

There are two solutions to it:

1.  As found by Sjaak:  Add the line for Windows 2008 R2 Enterprise Edition (“Windows 2008 R2”) to the MANIFEST.FM text file in the iFix (located with the fix: LO64399\efixes\LO64399\components\mobile\update\META-INF\MANIFEST.MF) and install it again.

2.  As found by Brian Ocs:  Run the Update Installer you use to install the fix with in Windows 2003 compatibility mode.

 

Once you have done that you should be able to access IBM Connections using the free apps in the App Stores of iOS and Android.

Connections on iPad

Population of Connections Database Field DisplayName if this entry does not exist in LDAP

Today I noticed in a customer installation that nowhere in the LDAP a usable displayname (aka “Martti Garden”) was available.  My collegue Barbara Koch helped me out solving this:  The attributes surname (sn) as well as givenname (givenname) were available to I had to compute the display name.

 

So I edited the profiles_functions.js and added the following function:

 

// Function to compute the displayname from given name and surname

func_compute_dn(fieldname)

// Get the content of the “sn” field as a string

{
var surname = work.getString(“sn”);

// Get the content of the “givenname” field as a string

var vorname = work.getString(“givenname”);

// If both entries are not empty

if (vorname != null && nachname != null) {

// return first name and last name separated by a space

return vorname + ” ” + nachname;

// otherwise

}

else {

// return the content of the “cn” field as a string, if it is empty it will return NULL

return work.getAttribute(“cn”);

}
}

 

Now I had to edit the map_dbrepos_from_source.properties and mapped the function to the diplayname field:

displayname={func_compute_dn}


Now I ran the populate_from_dn_file script and had the Displayname showed correctly in IBM Connections.

Social File Sharing: IBM Connections vs. MS SharePoint

A collegue brought the following great comparison of Social File Sharing in IBM Connections and MS SharePoint to my attention.  While it is done cleary from IBMs point of view I still can’t believe that SharePoint could be that “unsocial” when it comes to it’s greatest strength: files and documents.  If you are using MS SharePoint feel free to comment and show me what the colleague is overseeing. 😉

Here the video in English:

Here the video in German:

 

 

Resetting WAS-Admin Password when the Browser Console does not work anymore

If you have to reset the WAS Admin password without using the web interface  (e.g. if you cannot log in anymore for various reasons) here is how you reset a forgotten WAS-Admin password:


1. Go to your WAS-Profile/bin directory using a command prompt (in IBM Connections case this would be ../(washome)/AppServer/profiles/DMGR/bin )
2.  Type the following command: wsadmin -conntype NONE and hit Enter
3.  Then you should be in the wsadmin prompt.  You now enter:  $AdminTask changeFileRegistryAccountPassword {-userId <wpsadmin-UserID> -password <new-password-for-wpsadmin>} Then hit Enter.
4.  Now the new password is stored temporarily.  So finalize the changes type $AdminConfig save followed by Enter. 

Restart WAS and you should be able to login using the new password.


Sometime you just need to disable the WAS application security to disable the federated repositories.  This is done in a similar fashion:


1. Go to your WAS-bin directory using a command prompt (in IBM Connections case this would be ../(washome)/AppServer/profiles/DMGR/bin )
2.  Type the following command: wsadmin -conntype NONE and hit Enter
3.  Then you should be in the wsadmin prompt.  You now enter the simple command: securityoff Then hit Enter.
4.  To finalize the changes type $AdminConfig save followed by Enter.

Restart WAS and you can log into the console using any username without a password.


 

How to activate Spotlight-Search for Lotus Notes content

One of the greatest thing of Mac OS is the Spotlight-Search (CMD+Leertaste) that gives me instant access to data and information on my computer.  Spotlight can also be used to search and find mails in Lotus Notes – actually even fast than the Notes search itself.  This must be activated first, though.

 

To do so click on Actions => Desktop Search when you are in your mailbox-view.

 

Actions / Desktop Search

 

On the next screen you set the checknark on “Enable idexing of local Lotus Notes databases”:

EnableIndexing

 

Now you get a warning that data indexed by Spotlight will not be under Lotus Notes security control anymore (e.g. spotlight may give you a preview of a mails content).  That’s why I leave the checkmark at  “Index encrypted fields” unchecked so encrypted mails do not show up in spotlights index.

DesktopSearchWarning

 

Using “Add…” you can also add further databases such as archives to the spotlight search.  I found it harder to find the proper email when all my archives are included, since I usually need recent emails.  Therefore I went back to only adding my mail file.  Once you hit Apply the changes are saved and soon (or later 😉 ) the first results will show up in your spotlight window.

 

SpotlightNotesMails

 

 

 

 

Lotus Notes displays wrong calendar week

Under certain circumstances it is possible, that Lotus Notes will display the wrong calendar week.  This is due to different counting of calendar weeks in e.g. Europe and U.S. (in Europe weeks starting on Monday in the US on sundays).  In my case this happened, when I set my Mac OS Lion to English and thus to an American Environment.  For example the last week of this year is displayed as calendar week 53 as can be seen in the following screenshot:

CalWeek53

To fix this and have the correct week shown we must set the calendar week counting to ISO standard.  To do so go to the preference pane and open Calendar and To Do followed by Regional Settings.  Now you can switch the radio button on the bottom from “Use my operating system regional setting” to “always use ISO standard“.

isostandard

After clicking OK switching back to the calendar show that the week number has changed to week 52:

week52

 

Manually delete the Search- / Index- /CleanUp-Taks for Connections directly in the DB2

After I had to reinstall an IBM Connections 3.0.1 system (a HDD crash destroyed the installation and of course Murphy made sure the customer did not have a working backup) I realized, that certain tasks did not run correctly anymore.  The SystemOut.log from the WebSphere Application Server showed the following error message:

 

ASYN9999E: Unexpected Exception Occurred: com.ibm.websphere.asynchbeans.SerialDeserialException: Exception while deserializing a saved service. Service=security. Unable to deserialize the Subjects in this Context, cause: Validation of LTPA token failed due to invalid keys or token type.

 

According to this support document this means that either not all fixes are installed correctly or that the search tasks in the databases are either broken or saved with wrong or non-valid LTPA tokens.  The correct way to solve this ist deleting the tasks, which can usually be done easily using the wsadmin-console (here the description in the IBM Connections Wiki).  After a restart of the applications the tasks are then recreated automatically. This is how it’s done:

 

\DMGR01\bin\wsadmin -lang jython -user wasadmin – password password

execfile(“connectionsConfig.py”)

In a cluster select “1

Scheduler.listAllTasks() – this shows all available tasks

Scheduler.clearAllTasks() – this deletes all tasks

restart Cluster to recreate all tasks

 

Unfortunately in my case the wsadmin-console kept telling me, that the corresponding application is not running and therefore the task cannot be deleted (of course the newly reinstalled applications were running).  The only way out was deleting the tasks directly in the database. Using DB2 you need to start the DB2-Control Center and access the Connections database.  The above mentioned  Scheduler.listAllTasks() shows in which component / database which task resides: Communities, Activities, Forums, Profiles, Files, Wikis, News and Search (both in the Homepage DB).  So you need to open each database and click on the left on Tables. Now you can open the needed table by double clicking it. In the now opened windows you can select the task and then click on Delete Row followed by hitting the Commit button. This deletes the tasks.

 

Entries to delete in the db2

 

The tables with the entries to delete are:

Communities:

DB: SNCOMM – COMMUNITIESSCHEDULERTASK

Activities:

DB: OPNACT – OA_SCHEDULERTASK

Forum:

DB: FORUM – DF_SCHEDULERTASK

Profiles:

DB: PEOPLEDB – PROFILES_SCHEDULERTASK

Files:

DB: FILES – SCHEDULERTASK

Wikis:

DB: WIKIS – SCHEDULERTASK

News:

DB: HOMEPAGE – NR_SCHEDULER_TASK

Search:

DB: HOMEPAGE – LOTUSCONNECTIONSTASK

Once you’re done: Restart IBM Connections and all tasks are recreated and should be running fine.

The reason in my case for this problem was that the tasks were created using the old installation of Connections.  After I had to reinstall Connections including the WebSphere Application Server the LTPA tokens were newly created and not the same as the ones saved in the DB. Therefore the tasks complained about the LTPA validity.

 

TDI User Import – tampering with the collect.dns can be dangerous

Sometimes in a testinstallation of IBM Connections you may only want to import a few specific user.  This can be done by editing the collect.dns by hand, because only the users present in this file will be added to the Profiles database in the next step when running the populate_from_dn_file.

Unfortunately there is a little trap you can step in.  The collect.dns *MUST* be saved in the UTF8-format, otherwise you will encountered massive problems with names containing Umlaute or other special letter as in Sören Müller.  If you use Notepad for editing the file will be automatically saved in ANSI format, unfortunately. If the list than contains a special character the populate_from_dn_file will start though, but once it hits the user with it it hang and the log files will grow rapidly (easily a few 100 MB in 10, 20 seconds). If you notice that: CTRL-C the comandline running the populate_from_dn_file and reopen the collect.dns and this time when saving select UTF-8 in the “Save as type” field:

 

Beim Speichern UTF8 statt ANSI auswählen

 

Right after that you can restart the importing of userdata and it should run fine for all Müllers of this planet..

Backup / Restore of an IBM Connections environment on file basis

In todays time of virtual machines the easiest and simplest way of getting a backup is doing a snapshot. I usually recommend it everytime bigger changes such as upgrades are done.  But not always there is the option to get a timely snapshot and therefore other means of backups are necessary.  One “quick and dirty” way is copying all necessary files to a backup folder.

In a standard Connections environment (all Components in a /IBM directory) this usally means backing up two directories:

  • the database directory (/DB2) if DB2 is installed locally
  • the complete aforemeantioned /IBM directory (at least the /WebSphere and /LotusConnections directories under it)

Since IBM Connections 3 the IBM Installation Manager is used for installing the solution and its upgrades.  Now I ran into a problem during an upgrade to 3.0.1 (always check the the remote desktop is started using the /console setting 😉 ) and hat copy back the recovered folders.  Unfortunately the Installation Manager copies files some files in a separate directory no matter what you said when installing. And these files contain the information which upgrades have already been installed.  So the IBM Installation Manager was still believing 3.0.1 was installed even though it did not and I copied back the “old” 3.0.0 environment. Having not enough time to play around I went the way of deinstalling Connections completely and reinstalling it.

So when you do a backup, make sure to add the following folder, too:

  • C:\ProgamData\IBM\Installation Manager