Monthly Archives: February 2011

Example of adding the Formal Process Template to the Scrum in Team Concert 3.0

Posted by on 02-Feb-11 No comments

The process is documented in the CLM Help Information Center well enough for someone familar with the process ;)

http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0/topic/com.ibm.team.platform.doc/topics/t_customize_template_formal_features.html

For those of you who have not dabbled with the process configuration source directly this is a new experience so I took some time preparing this for a particular client of mine and thought it would be useful to share.

Following the Information Center I have gone through Step 8, I am holding off on Step 9 because that is really a cop-out, I’ll continue the implementation to completely add the other work item types from the Formal Process Template directly rather than make them anew.

Here is the current zip files, Scrum Process Configuration Source XMLs v1.0, more to come…

Update: 4-Apr-2011

Posted the current template to github, watch it there if you are interested.

https://github.com/sgwilbur/rtc-process-templates

Connecting to my Soekris 5501

Posted by on 02-Feb-11 No comments

First I would recommend snuggling up with your Soekris manual [1] by the fire and getting out your corn cob pipe.

Setting up console access:
The Soekris wiki provides some guidance [2] to get you started, but it does assume that you have an idea how to do this. I was a bit ignorant to the whole serial cable [4] vs null modem [3] cable. Picked up a usb to serial cable off eBay for $3, it has USB and DB9 male connections, so it is the wrong type of cable and the wrong connector, go figure. Turns out that is not so bad after some searching the internet, decided I would take a crack at creating a Null Modem adapter. Went down to my neighborhood Radio Shack and picked up two female DB9 connectors and used some useful wiring diagrams online to create a simple null modem with no handshaking [5].

With a cable we are ready to validate that we can connect, being that my only experience with console access was RS232 programming in college, I was looking for some quick starts to get me going and found a useful article on connecting to Soekris from minicom [6] on UnixCraft. Once I plugin the cable I can tail the dmesg output for where my device is located, in this case ttyUBS0

[code]
[14635.254804] usb 1-1.5.1.3: new full speed USB device using ehci_hcd and address 15
[14635.427194] usbcore: registered new interface driver usbserial
[14635.427214] USB Serial support registered for generic
[14635.427283] usbcore: registered new interface driver usbserial_generic
[14635.427285] usbserial: USB Serial Driver core
[14635.434341] USB Serial support registered for ch341-uart
[14635.434385] ch341 1-1.5.1.3:1.0: ch341-uart converter detected
[14635.436030] usb 1-1.5.1.3: ch341-uart converter now attached to ttyUSB0
[14635.436048] usbcore: registered new interface driver ch341
[/code]

Start up minicom and configure your console before you turn on your Soekris device, I am working from Ubuntu so I need to sudo to get access to the ttys sudo minicom -s then navigate to the Serial Port setup screen.

Showing setup and some samples of it working.

Now I just need to install an OS and do something useful with this box ;)

Update: I also tried via cu to see if that was any easier to use, but they both get you to the same place, only thing I found was that I needed to add permissions to /dev/ttyUSB0 before I could connect.

[code]

sgw@geb:~$ sudo cu -e -o -s 19200 -l /dev/ttyUSB0

cu: open (/dev/ttyUSB0): Permission denied

cu: ttyUSB0: Line in use

sgw@geb:~$ sudo chmod 666 /dev/ttyUSB0

[sudo] password for sgw:

sgw@geb:~$ sudo cu -e -o -s 19200 -l /dev/ttyUSB0

...

[/code]

Installing DB2 9.5 x64 on Ubuntu 9.10… um on second thought 9.04

Posted by on 02-Feb-11 No comments

Ok so I posted some steps to get DB2 installed and working on 8.10 a few years ago now… so I am trying to migrate to the current milenium and bring my Ubuntu and DB2 versions up to speed to boot.

This one is making me pull my hair out though…. namely because of some confusion on how dynamic load libraries work in Linux and my inability to figure it out on my own. <insert sad face> So the rub is that libstdc++5 has been removed from Karmic because the community no longer wants to support it, it breaks some new stuff they want to add but some old stuff breaks without it. It’s a trade off, these are made with lots of packages in every release, but like every other winey baby on the Ubuntu forums I don’t care until I care, and you can read the list of complaints here if you want to, although at some level I know these are the same people yelling at their son/daughters volunteer peewee soccer ref, needless to say I don’t think too highly of some of these complainers.

Here are the v8.1 instructions I am working off of. :)

http://blog.chinaunix.net/u/7282/showart_473461.html

Install

sgw@db02:/opt/ibm/db2/V9.5/adm$ sudo ./db2licm -a /home/sgw/db2ese_u.lic
[sudo] password for sgw:

LIC1402I  License added successfully.

LIC1426I   This product is now licensed for use as outlined in your License Agreement.  USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: “/opt/ibm/db2/V9.5/license/en_US.iso88591″
sgw@db02:/opt/ibm/db2/V9.5/adm$

Create Users

sgw@db02:~$ sudo useradd -m db2inst1
[sudo] password for sgw:
sgw@db02:~$ sudo passwd db2inst1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
sgw@db02:~$ sudo useradd -m db2fenc1
sgw@db02:~$ sudo passwd db2fenc1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
sgw@db02:~$ sudo passwd db2das1
passwd: unknown user db2das1
sgw@db02:~$ sudo useradd -m db2das1
sgw@db02:~$ sudo passwd db2das1
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully

Create Instance

sgw@db02:/opt/ibm/db2/V9.5$ sudo ./instance/dascrt -u db2das1
SQL4406W  The DB2 Administration Server was started successfully.
DBI1070I  Program dascrt completed successfully.
sgw@db02:/opt/ibm/db2/V9.5$ ls /home/db2das1/
das

sgw@db02:/opt/ibm/db2/V9.5$ ls /home/db2das1/
das

sgw@db02:/opt/ibm/db2/V9.5$ sudo ./instance/db2icrt -a server -u db2fenc1 db2inst1

Reference/Related:

  • http://www.redbooks.ibm.com/abstracts/sg246899.html
  • http://blog.chinaunix.net/u/7282/showart_473461.html
  • http://ubuntuforums.org/showthread.php?t=1282957
  • https://bugs.launchpad.net/ubuntu/+source/ia32-libs/+bug/431091
  • http://blog.dalejefferson.com/2009/09/gwt-on-64bit-ubuntu-karmic-910.html

Check-out my first article on jazz.net w00t!

Posted by on 02-Feb-11 No comments

Spent lots of time working on this for a few different customers, finally got it live.

Advanced configuration of WebSphere with Federated Realm

http://jazz.net/library/article/604

Forwarding all ClearQuest Web HTTP to HTTPS by default

Posted by on 02-Feb-11 No comments

This question comes up all the time in the forums and used to be in the documentation but looks like we may have pulled it for whatever reason.

If you don’t want or don’t allow users to access CQ via http only then you don’t want to shut off http as that will cause way more confusion and will not end up helping you as the admin, trust me.

The better solution is to still listen for http on 80 as normal business but blindly forward all traffic to 443 so it goes over https. Of course this requires that you have setup https which I am not going to get into here. So enable the mod_rewrite module and I have included the relevant *80 and *443 virtual hosts.

[code]

...

LoadModule rewrite_module modules/mod_rewrite.so

...

<VirtualHost *:80>
ServerName server.ratl.swg.usma.ibm.com
RewriteEngine on

# rewrite http => https, respond with a 301 response to signify permanently
# moved to new address.
RewriteCond %{SERVER_PORT} !^443$ [OR,NC]
RewriteRule ^(.*)$ https://server.ratl.swg.usma.ibm.com$1 [R=301,L]

RewriteLogLevel 0
RewriteLog "C:/Program Files/IBM/RationalSDLC/common/IHS/logs/rewrite.log"

</VirtualHost>

LoadModule was_ap20_module modules/mod_was_ap20_http.dll
WebSpherePluginConfig "C:/PROGRA~1/IBM/RATION~1/common/eWAS/profiles/plugin-cfg.xml"

#
# Enable SSL for IHS
#

LoadModule ibm_ssl_module modules/mod_ibm_ssl.so
Listen 0.0.0.0:443

<VirtualHost  _default_:443>
ServerName server.ratl.swg.usma.ibm.com
SSLEnable
SSLClientAuth None
</VirtualHost>

SSLDisable
KeyFile "C:/Program Files/IBM/RationalSDLC/common/IHS/key.kdb"
SSLV2Timeout 100
SSLV3Timeout 1000

[/code]

So basically defer anything that you want to do until the *443 virtual host and you will be serving https only!!

Update: 7-Feb-2011

Looks like there is an example of this in the CQ Infomation Center after all, and I prefer their solution, so I have updated the suggestion above.

https://publib.boulder.ibm.com/infocenter/cqhelp/v7r1m0/topic/com.ibm.rational.clearquest.webadmin.doc/topics/cm_server/t_cmsvr_ihs_conf_nonssl_ssl.htm

RewriteEngine on
RewriteCond %{SERVER_PORT} !^443$
RewriteRule ^(.*)$ https://CMServerHost$1 [R]