Since the IBM Connect pages does not show all presentation, i uploaded mine to slideshare.
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.
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.
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.
Create the script in $WAS_HOME/profiles/Dmgr01/bin and make it executable.
Create batch in %WAS_HOME%\profiles\Dmgr01\bin
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.
Thanks to Victor Toal for your script testing and bug reporting!
I added some scripts for special j2ee roles to the github repository:
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
I plan a session for SocCon VI too, hope i will get a slot there.