" /> Status for Andrew DeFaria: April 4, 2004 - April 10, 2004 Archives

« March 7, 2004 - March 13, 2004 | Main | April 11, 2004 - April 17, 2004 »

April 7, 2004

VIP Imports

Imported source into many vobs today with Subba. Had some problems with the vob server (db_VISTA error -922). Ended up stopping and restarting Clearcase on rtnlprod01.

Was assigned to set up both Clearcase web and Clearquest web. Luckily Clearcase web is already up on rtnlprod03. Need to set up Clearquest web...

Modified protect trigger to use current owner instead of original creator of the VOB to change the ownership of new elements.

April 6, 2004

Lockvobs

Re-wrote the lock vobs script in Perl to be much more flexible. It now locks or unlocks (-u) vobs. Also you can supply an -smtphost which defaults to notesmail01. Finally you can specify either -to or -errors-to as a list of email addresses that the report is send to. The later, -errors-to, are for people who only want to be notified if there is an error (i.e. me! :-).

Changed bat files accordingly and tested out adding these to the Clearcase Job Scheduler on my machine. Have not yet added this to "production" (rtnlprod01). Perhaps tomorrow...

Also worked with Subba to clean up and clear out some UCM vobs.

Spend some time trying to get MySQL running under Cygwin.

April 5, 2004

Lock Vobs jobs

Came in today and noticed that Notes was complaining that a network operation had failed. Also saw a couple of messages that Clearcase was having problems so I started investigating. Apparently the albd_server was not running on rtnlprod01. Scanning the logs I found:

albd_log: Error: Unable to connect to SMTP server "172.16.101.56[6400]": Bad file descriptor.

Well 172.16.101.56 happens to be notesadmin01:

C09-272-A:nslookup 172.16.101.56
Server:  dhcp01.ameriquest.net
Address:  172.16.101.100

Name:    notesadmin01.ameriquest.net
Address:  172.16.101.56

Why are we trying to email through notesadmin01 instead of notesmail01?

Meantime I unlocked the vobs...

Looking at the SMTP setting in Control Panel: Clearcase: Options I find the SMTP Host set to appsmtp.ameriquest.net which is an alias to notestadmin01.ameriquest.net:

C09-272-A:nslookup appsmtp
Server:  dhcp01.ameriquest.net
Address:  172.16.101.100

Name:    notesadmin01.ameriquest.net
Address:  172.16.101.56
Aliases:  appsmtp.ameriquest.net

I guess the questions are:

  • What is the official SMTP host that we can rely on?
  • Why does the [un]lock vobs job have problems and eventually kill the albd_server process simply because it cannot contact the SMTP host?

Further investigation yields the following: The lock and unlock vobs scripts apparently appear in .../Rational/Clearcase/var/scheduler/tasks. There are 4 files involved:

  • ccase_lock_vobs.bat: Simple bat file that fires off Perl on...
  • lock_vobs.pl: This locks the vobs and sends email
  • ccase_unlock_vobs.bat: Simple bat file that fires off Perl on...
  • unlock_vobs.pl: This unlocks the vob and sends email

Additionally these Perl scripts use C:/Winnt/System32/blat.exe to send mail.

Finally the task_registry file was modified to add these custom jobs.

I believe that this was done by perhaps Paul and/or Brian and it is fine work and does the job. However, seeing as we are about to reburn this system to Windows 2003 Server such work would be lost! And who would remember where this blat came from and that it needed to be reinstalled?

Suggestions:

I think we should use the Rational supplied tool, notify, instead of blat. This way we would not need to remember to find and reinstall this blat thing. I think Brian had problems getting notify to work and instead fell back on something he knew, blat, to get this working. Additionally IMHO blat should not be in the Windows directory! If we must use blat then perhaps we should install it into CM_TOOLS/bin.

Additionally I suggest that we relocate the .bat files and Perl scripts to CM_TOOLS/bin also and task_registry file should be pointed to CM_TOOLS/bin.

Finally I think there should be a script set up to reproduce/reinstall this environment.

IOW our stuff should also be version controlled and scripts written to automate it's installation and workings.