Category Archives: Lotus Connections

SocCnx: more scripts added

Because of a delay of some hours on my flight back from Social Connections V on saturday, i had time to rewrite the jython script for backing up and restore security roles in WebSphere Application Server.

I updated the master branch on GitHub, which now contains a db2 initscript and the two new scripts securityrolebackup.py and securityrolerestore.py!

You can call the scripts through wsadmin.sh|bat and they do following.

securityrolebackup.sh

cd $WAS_HOME/profiles/Dmgr01/bin
./wsadmin.sh -lang jython -username admin -password password -f "path/securityrolebackup.sh" "../temp"

This will save the security roles for each installed application to $WAS_HOME/profiles/Dmgr01/temp to single files named: Application.txt.

securityrolerestore.sh

cd $WAS_HOME/profiles/Dmgr01/bin
./wsadmin.sh -lang jython -username admin -password password -f "path/securityrolerestore.sh" "../temp"

This will take the backups from $WAS_HOME/profiles/Dmgr01/temp and restore all access rights in the single applications. All applications will be restored, but you can change the script for one or some of the applications, when you change from line 49:

49 apps = AdminApp.list()
50 appsList = apps.split(lineSeparator)
51 # Test with some Apps:
52 # appsList = ['Blogs','Activities','Wikis']
53 # or Single App:
54 # appsList = ['Blogs']

Comment out line 49 and 50, and remove # from line 52 to restore only some Application security roles, or remove # from 54 to restore only one!

Tipp

I had several updates and cr installations with IBM Connections the last years and on some of these the updateinstaller removes my configured security roles. Now you can backup before and restore after installing a fix.

Disclaimer

These scripts are provided as is, with no warranties, and confers no rights! Please test them before using in production environments.

IBM Connections Mail 1.3 is available (works with Connections 4.5)

You can download the version 1.3 of IBM Connections Mail in Greenhouse Catalog (Login required)!

2013-04-10_20-35-42

Requirements:

IBM Connections 4.5 (+ mandatory iFixes – see IBM Connections support site) + IBM Connections 4.5 interim fix LO74571

One or more of the following:

  • IBM Lotus Domino 8.5.3 FP3 or later
  • IBM Domino 9.0 Social Edition
  • Microsoft Exchange 2007 SP3
  • Microsoft Exchange 2010 SP1

Setting dataSource/JDBC parameters with wsadmin

Setting the performance tuning parameters for all datasources in WebSphere Application Server (for IBM Connections 4) is a really annoying job with lots of mouse clicks.

I searched a way to make these through wsadmin with a jython script and after some testing i wrote one, which set all parameters for the Connections DataSources as described in IBM Connections 4 Performance Tuning Guide.

I set StatementCacheSize, minConnections and maxConnections with this script.

Download:

changeDataSourceParameters

Using this script

Copy this script to your server and copy & paste it to a wsadmin-Session, or start wsadmin with wsadmin.(sh|bat) -lang jython -username youruser -password password -f path/changeDataSourceParameter.py

I didn’t include error handling. When a DataSource is not configured, then the script will terminate!

Disclaimer

I use this script in several installations without problem, but i’m not responsible, when you break your systems or loose data!

If you find errors, you can comment or send me a mail, but i will not provide support for this script.