1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
5 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
6 <meta name="generator" content="Movable Type 5.2.3" />
8 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
9 <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
10 <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
12 <title>Status for Andrew DeFaria: August 1, 2004 - August 7, 2004 Archives</title>
14 <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
15 <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2004_07_25.html" title="July 25, 2004 - July 31, 2004" />
16 <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2004_08_08.html" title="August 8, 2004 - August 14, 2004" />
18 <body class="layout-one-column">
20 <div id="container-inner" class="pkg">
23 <div id="banner-inner" class="pkg">
24 <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
25 <h2 id="banner-description">Searchable status reports and work log</h2>
30 <div id="pagebody-inner" class="pkg">
32 <div id="alpha-inner" class="pkg">
34 <p class="content-nav">
35 <a href="http://defaria.com/blogs/Status/archives/week_2004_07_25.html">« July 25, 2004 - July 31, 2004</a> |
36 <a href="http://defaria.com/blogs/Status/">Main</a>
37 | <a href="http://defaria.com/blogs/Status/archives/week_2004_08_08.html">August 8, 2004 - August 14, 2004 »</a>
43 <h2 class="date-header">August 5, 2004</h2>
45 <div class="entry" id="entry-226">
46 <h3 class="entry-header">CC-TTE/CommentSQLCode/whosin</h3>
47 <div class="entry-content">
48 <div class="entry-body">
51 <li>Had problems with the Permissions trigger. Something we forgot or didn't think about. If the user attempts to add elements to source control they should be permitted in folders that have .perms. However part of adding to source control checks out the parent directory first. At the parent directory level there is no .perms to permit the user to check out the parent directory! This causes Add to Source Control to fail. Solution was to change the algorithm to account for this</li>
53 <li>Finished up CommentSQLCode trigger. Added stuff to triggers.dat and documented things in CM_DOCS. Waiting for code review.</li>
55 <li>Got this bright idea to take GetCCGroups.vbs and make another script that will simply dump the users for the given groups. Useful command line tool called whois</li>
57 <li>Worked on trying to get PC to install the new Rational Web Server for John</li>
61 <p class="entry-footer">
62 <span class="post-footers">Posted by at 4:38 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000226.html">Permalink</a>
72 <h2 class="date-header">August 4, 2004</h2>
74 <div class="entry" id="entry-225">
75 <h3 class="entry-header">CommentSQLCode Trigger</h3>
76 <div class="entry-content">
77 <div class="entry-body">
80 <p><li>Implemented CommentSQLCode Trigger - need to do code review, triggers.dat, and documentation</li></p>
82 <p><li>Assisted Loren, Padma and William in getting the Permisisons working</li></p>
86 <p class="entry-footer">
87 <span class="post-footers">Posted by at 6:35 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000225.html">Permalink</a>
97 <h2 class="date-header">August 3, 2004</h2>
99 <div class="entry" id="entry-224">
100 <h3 class="entry-header">New Trigger</h3>
101 <div class="entry-content">
102 <div class="entry-body">
103 <p>Here are the requirements as I understand them for the trigger that Steve Lipson wants for the SQL checkins. Basically he desires a trigger that will capture the checkin comment and other information and insert that information in the form of a comment at the top of the checked in element. This trigger will:</p>
106 <li>Be a postop trigger for the checkin action</li>
107 <li><b>Not</b> be an all element trigger rather it will be attached to certain file elements in the vob</li>
108 <li>Be made for the <<i>fill in vob name here</i>> vob</li>
109 <li>Only work on file elements - directory elements are to be skipped</li>
110 <li>Only work on file elements that have an extension of .sql - other elements will be skipped</li>
113 <p>Roughly the psuedo code for this trigger will be:</p>
115 <div class="code"><pre>
116 # Get name of element and its type
117 $pname = $ENV{CLEARCASE_PN};
118 $element_type = $ENV{CLEARCASE_ELTYPE};
120 # Skip directories and elements that aren't .sql
121 exit if $element_type =~ /directory/i || $pname !~ /\.sql$/i;
123 # Get comment and user
124 $comment = $ENV{CLEARCASE_COMMENT};
125 $userid = $ENV{CLEARCASE_USER};
128 $timestamp = getCurrentTime;
130 # Parse output of lsactivity -cact -long
131 ($activity_id, $activity_title, $activity_owner) = parseLSActivity;
133 # Open up $pname for reading and $pname.trig for writting
134 open PNAME_IN, $pname
135 or die "Unable to open $pname for reading - $!\n";
137 open PNAME_OUT, ">$pname.trig"
138 or dir "Unable to open $pname.trig for writing - $!\n";
140 # Add comment to top of file
141 print $PNAME_OUT <<END;
143 -- Activity: $activity_id: $activity_title
144 -- Owner: $activity_owner ($userid)
156 # Switch $pname.trig -> $pname
158 rename "$pname.trig", $pname;
160 # Allow checkin to proceed
164 <p class="entry-footer">
165 <span class="post-footers">Posted by at 6:54 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000224.html">Permalink</a>
175 <h2 class="date-header">August 2, 2004</h2>
177 <div class="entry" id="entry-223">
178 <h3 class="entry-header">Server move (cont)</h3>
179 <div class="entry-content">
180 <div class="entry-body">
181 <p>OK, licenses are all OK now. BTW hostid is not a combination of IP address and MAC address - it's simply MAC address of the NIC card. Problem appears to be that during the server move the NIC card changed! I verified this with the Rational rep this morning. The current MAC address of the NIC card as shown by ipconfig /all (it's the Physical Address) is 00-0f-20-6d-09-97. I gave the old license strings to the rep and she determined our old MAC address of the NIC card was 00-0b-cd-9b-f4-27.</p>
183 <p>Looking at the Device Manager on the servers I notice that we have two Network Adapters listed:</p>
186 <li>HP NC7781 Gigabit Server Adapter</li>
187 <li>HP NC7781 Gigabit Server Adapter #2</li>
190 <p>Why we have 2 NIC cards I don't know (perhaps merely for the ability to be multihomed). Normally I see #1 being disabled and #2 being enabled. Rtnlprod01 is like this. Rtnlprod02 has #1 enabled and #2 disabled. For the vob and view servers this does not matter. Either card will work. For rtnlprod03 however, since licenses are tied to the NIC card's MAC address, switching from #1 -> #2 (or #2 -> #1 as I suspect has happened here) will invalidate all licenses. We need to insure that the network adapter for rtnlprod03 remains nailed at either #1 or #2.</p>
192 <p>Since it appears that the network adapter has changed and since I have obtained a new set of licenses for this new network adapter and still have the old set, I have installed both sets so that in the event that the network adapter switches again we'll be covered. However, if we order additional licenses for say card #1 and somehow we get switched to card #2, those additional licenses will not be represented, hence the desire to nail the NIC card to either one or the other.</p>
194 <p class="entry-footer">
195 <span class="post-footers">Posted by at 6:47 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000223.html">Permalink</a>