Scripting

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.

This week i attended Engage in Breda . I had a session with famous Sharon Bellamy , we covered an update of our Connect 2014 session about BP307 – Practical Solutions for Connections Administrators – Tips and Scripts for Your Daily Busines . I enjoyed it very much to be with lovely community guys, old and new friends. I want to thank Theo Heselman , he and his crew did and does a really great job to get us all together (350 attendees, 30 IBM Champions, 65 speakers). Kitty and Warren Elsmore were with us again and made lovely copies of ourself in lego.

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 added several plugins to my Eclipse, so i can access the scripts on GitHub and edit through an IDE: Jython and Python Development PyDev: http://pydev.org/updates Markdown (Documentation within Github) Markdown: http://winterwell.com/software/updatesite/ Access GitHub: EGIT: http://download.eclipse.org/egit/updates Shellscript Editor EasyShell: http://pluginbox.sourceforge.net ShellEd: http://sourceforge.net/projects/shelled/files/shelled/update/ SQL Scripts SQL Explorer: http://eclipsesql.sourceforge.net/

The IBM Connections Product Documentation is only available as a set of Wiki Documents and in a accessible version (5 single html documents) . I don’t like both versions. Searching is hard and printing only single documents (to paper or pdf) is a torture. The format is only for a complete display, no mobile version and using only half of a display do not wrap the text. So i want to have a converted document which is searchable, has numbered headlines and can be converted to mobi or kindle format. You want this too? How? Requirements Linux VM (e.g. Knoppix or other Live Linux)

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.