I haven’t touched the Connections scripts for a long time, but I recently made some minor updates to fix compatibility issues with newer versions and added small scripts to speed up configuration. I also got the documentation script running from the menu.

Today i read a question in the IBM Connections Forum about setting the EMPLOYEE_EXTENDED role to all users in a Connections deployment.

As preparation for Social Connections VI in Prague next week i redesigned the Administration Scripts for IBM Websphere .

Some highlights:

• all scripts are moved to a subfolder with DMGR/bin (folder name: ibmcnx)

• tested in multinode environments

• added some classes everybody can use for his own scripts

• adding policies to libraries (personal and communities) are using search now

New scripts:

• documentation of all jvm settings of each application server

• create a file with all documentation in one step

• create cluster members for additional nodes

Sharon created a document with the content of all of our presentations and collected several tipps all around connections and community scripts. She will share this next time. We started to share parts of this document and more documentations (installation, usage) for scripts and IBM Connections on:

It was little bit quiet here after Connect 2014. I had lots of projects and no time to add new scripts or even do bug fixing.

I promised at Connect, that i will fix the JDBC drivers, that they will load on Windows too. See cnxMemberCheckExIDByEmail.py as an example.

Loading JDBC Drivers within jython scripts

Jan Riedel sent me a solution for SLES and i tested his proposal today within Windows. He points me in the right direction, i mustn’t load the path or jar within the script, it is better to load on starting wsadmin. You have to add the JDBC Driver path to WAS_EXT_DIRS.

I started a new project on OpenNTF for the collection of scripts we created to speed up and simplify WebSphere and Connections Administration.

Link to this project: Administration Scripts for WebSphere

In the moment most of documentation is only as comment in these scripts. Descriptions can be found in Github and Scripting101 .

Highlights

• J2EE Security Role Backup and Restore

• Set initial Security Roles for Connections Applications (Author: Klaus Bild )

Documentation

When you want to start with this collection, copy the jython script to your Deployment Manager bin-folder ($WAS_HOME/profiles/Dmgr01/bin) and call the scripts with wsadmin.sh -f scriptname

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.

Today i spoke at Social Connections V User Group Meeting in Zurich. What should i say. It was a pleasure and i enjoyed it very much. Hope we can discuss more scripts the next weeks.

Session Slides

Here you can watch the session slides:

Saving my time using scripts #soccnx #soccnxv

Scripts Download

You can download all scripts without warranty and on your own risk on:

http://www.github.com/stoeps13/ibmcnxscripting

Please download the master branch, develop and bugfix can contain not ready scripts.

Slidedownload soccnx

More Slides on http://www.slideshare.net/soccnx

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

Klaus Bild provided two scripts for setting Connections Admins through jython and wsadmin.

I want to add one detail, when you want to add multiple Admins, then you can use pipe | as delimiter.

First line would be

connwasadmin='wasadmin|conadmin'

Thanks Klaus, i like to set the admins through a script, because fixpack installations often set the j2ee roles to default.