Category Archives: Wordpress

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.

Plugin Larsens Calender

Auf der Seite http://www.lts-prien.de habe ich das Plugin Larsens Calender eingebaut, da mir die Funktion sehr praktisch vorkam.

Da ich in meinem Webspace mehrere WordPress Instanzen installiert habe, die mit unterschiedlichen Tabellen Prefixes die gleiche MySQL Datenbank verwenden, fiel mir schnell auf, daß der Kalender dieses Prefix nicht ausliest, sondern immer die Tabelle wp_larsenscalender schreibt, bzw. liest.

Ich habe die vorhandenen Sourcen so geändert, daß der Prefix verwendet wird und ausserdem ein Beschreibungsfeld hinzugefügt, das in den Sourcen fast fertig programmiert war, aber in den Formularen nicht auftauchte.

Die Änderungen habe ich an Lars gemailt und ich hoffe er wird das in seine Version übernehmen, damit das in WordPress direkt installiert werden kann. Bis dahin findet ihr hier das geänderte Plugin:

larsen1.3.1

Zur Installation die Zipdatei in euer WordPress-Verzeichnis /wp-content/plugins entpacken.

Update: Die Version 1.3 hatte noch kleinere Probleme beim Ändern von Einträgen und Löschen, das ist jetzt behoben. Ausserdem habe ich den Link in eine Extra-Spalte gepackt.