Tag Archives: session

My next ICS events

So my vacation is finished, i enjoyed 13 lovely rainy days in bavaria and see forward to my next travels. Hope to get some sun at ICON UK in London next week.

I will speak with Sharon about Tips and Scripts for your daily business our session we made for Connect 2014 and which is updated for IBM Connections 5 now.

Admincamp will be at 29th september to 1st october in Gelsenkirchen. Admincamp is a great event with lots of technical content and no advertises, organized by Rudi Knegt and some more. I enjoy it very much to be again part of it, this year i will prepare three sessions with Klaus Bild.

41st DNUG will be at 11. and 12. November in Leipzig. I made some session proposals and will see if i can speak there and meet the german ICS community.

Last but not least Social Connections VII will be in Stockholm at 13th and 14th november. Agenda is still open, but i made a session proposal and see forward to meet the Connections User group there.

Last weeks, new scripts and next weeks

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 see two ways here:

Change setupCmdLine.sh|bat (Update)

I don’t like to change setupCmdLine directly, because i don’t want to load the driver everytime i start wsadmin or WebSphere, but you can add your JDBC path to the line

set WAS_EXT_DIRS=….;c:\ibm\jdbc (Windows)
export WAS_EXT_DIRS=….:/opt/IBM/JDBC (Linux)

Please do not change your setupCmdLine in this way. I had errors on using Connections updateInstaller, when i use it! Use WAS_USER_SCRIPT!

Add a WAS_USER_SCRIPT

I create a batch|shell script with following content.

wasuserscript.sh

Create the script in $WAS_HOME/profiles/Dmgr01/bin and make it executable.

export WAS_EXT_DIRS=$WAS_EXT_DIRS:/opt/IBM/JDBC

wasuserscript.bat

Create batch in %WAS_HOME%\profiles\Dmgr01\bin

set WAS_EXT_DIRS=%WAS_EXT_DIRS;c:\IBM\JDBC

Now it is enough to set the environment variable WAS_USER_SCRIPT, then the jdbc driver will be loaded on wsadmin start. So when you want to load cnxmenu.py or one of the scripts using JDBC ( cnxMemberCheckExIDByEmail.py, cnxMemberDeactAndActByEmail.py) simply set the WAS_USER_SCRIPT variable in your operating system, terminal or console.

export WAS_USER_SCRIPT=/opt/IBM/.../wasuserscript.sh

or

set WAS_USER_SCRIPT=C:\....\wasuserscript.bat

Thanks to Victor Toal for your script testing and bug reporting!

New scripts

I added some scripts for special j2ee roles to the github repository:

  • cfgJ2EERoleGlobalModerator.py
  • cfgJ2EERoleMetricsReader.py
  • cfgJ2EERoleMetricsReportRun.py
  • cfgJ2EERoleSocialMail.py

These scripts set consistent the roles mentioned in the file name. So you can enable or disable Socialmail integration, Metrics or Moderation.

Next weeks, next events

Next events i will attend are: Engage in Breda, BCCON in Hamburg and Social Connections VI in Prag.

At Engage i will speak with my friend Sharon Bellamy about Scripting.

At BCCON i will be with my swiss friend and scripting colleague Klaus Bild, we will do the Script show in german.

I plan a session for SocCon VI too, hope i will get a slot there.