defaria.com/blogs/Status/archives/2007_01.html

   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">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   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"$>" />
  11
  12    <title>Status for Andrew DeFaria: January 2007 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/2006_12.html" title="December 2006" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/2007_03.html" title="March 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  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>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/2006_12.html">&laquo; December 2006</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/2007_03.html">March 2007 &raquo;</a>
  38                      </p>
  39
  40
  41
  42
  43                      <h2 class="date-header">January 18, 2007</h2>
  44                      <a id="a000612"></a>
  45                      <div class="entry" id="entry-612">
  46                         <h3 class="entry-header">VOB UUIDs</h3>
  47                         <div class="entry-content">
  48                            <div class="entry-body">
  49                               <ul>
  50   <li>Decided we need to change the Clearcase ID field from a sequential number to one that better represented an instance of a vob tag uniquely. As such we've now made the VOB Replica UUID the key for both the Clearcase record and it's assorted other tables.</li>
  51 </ul>
  52
  53                               <p class="entry-footer">
  54                                  <span class="post-footers">Posted by  at  1:27 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000612.html">Permalink</a>
  55
  56
  57                               </p>
  58                            </div>
  59                         </div>
  60                      </div>
  61
  62
  63
  64                      <h2 class="date-header">January 16, 2007</h2>
  65                      <a id="a000613"></a>
  66                      <div class="entry" id="entry-613">
  67                         <h3 class="entry-header">CC 7.0 Upgrades</h3>
  68                         <div class="entry-content">
  69                            <div class="entry-body">
  70                               <ul>
  71   <li>Installed CC 7.0 on dslabcc03. This was done by first removing CC 6.0. The result was a loss of all registry entries. Brought back the registry from the saved area. Now all better</li>
  72
  73   <li>Did an install-over of CC 7.0 on top of CC 6.0 for dslabcc01. This worked even better</li>
  74
  75   <li>Performed install-over for dslabcc05</li>
  76 </ul>
  77
  78                               <p class="entry-footer">
  79                                  <span class="post-footers">Posted by  at  1:31 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000613.html">Permalink</a>
  80
  81
  82                               </p>
  83                            </div>
  84                         </div>
  85                      </div>
  86
  87
  88
  89                      <h2 class="date-header">January 12, 2007</h2>
  90                      <a id="a000611"></a>
  91                      <div class="entry" id="entry-611">
  92                         <h3 class="entry-header">Clearcase 7.0</h3>
  93                         <div class="entry-content">
  94                            <div class="entry-body">
  95                               <ul>
  96   <li>Set up vob server on dslabcc05</li>
  97
  98   <li>Set up Multisite synchronization between 1, 3 and 5</li>
  99
 100   <li>Installed MSHD on 1, 3 and 5</li>
 101 </ul>
 102
 103                               <p class="entry-footer">
 104                                  <span class="post-footers">Posted by  at  6:07 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000611.html">Permalink</a>
 105
 106
 107                               </p>
 108                            </div>
 109                         </div>
 110                      </div>
 111
 112
 113
 114                      <h2 class="date-header">January 11, 2007</h2>
 115                      <a id="a000610"></a>
 116                      <div class="entry" id="entry-610">
 117                         <h3 class="entry-header">Clearcase 7.0</h3>
 118                         <div class="entry-content">
 119                            <div class="entry-body">
 120                               <ul>
 121   <li>Set up lab servers to CC 6.0</li>
 122
 123   <li>Created some vobs and views in the 6.0 environment</li>
 124
 125   <li>Populated a vob using clearfsimport</li>
 126
 127   <li>Replicated vobs amongst the 6.0 servers</li>
 128 <ul>
 129
 130                               <p class="entry-footer">
 131                                  <span class="post-footers">Posted by  at  3:28 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000610.html">Permalink</a>
 132
 133
 134                               </p>
 135                            </div>
 136                         </div>
 137                      </div>
 138
 139
 140
 141                      <h2 class="date-header">January  8, 2007</h2>
 142                      <a id="a000608"></a>
 143                      <div class="entry" id="entry-608">
 144                         <h3 class="entry-header">cclic_report year boundary problem</h3>
 145                         <div class="entry-content">
 146                            <div class="entry-body">
 147                               <ul>
 148   <li>Documented problem with cclic_report and crossing of the new year's boundary</li>
 149 </ul>
 150
 151                               <h3>Year boundary problem</h3>
 152
 153 <p>I have been working resolving problems with the cclic_report for this month. The script to do this has been failing due to a subtle bug in the algorithm used for obtaining the necessary files to translate the various user IDs and map them to Org 9 numbers and the like.</p>
 154
 155 <p>The script looks in a series of files out on the file system in order to obtain information to build mapping tables it needs to do the translation. These files are of the form:</p>
 156
 157 <div class=code><pre>
 158 /data/cmetrics/recv/&lt;<i>site</i>&gt;/&lt;<i>type&gt;.&lt;year</i>&gt;/&lt;<i>date</i>&gt;<br>
 159 </pre></div>
 160
 161 <p>Where:</p>
 162
 163 <dl>
 164   <dt>site</dt>
 165   <dd>A site designator. This is one of: dal-design (Dallas), nice-design (Nice), tii-shared (Bangalore) or vorlagenkontoliste (Vorlagenkontoliste)</dd>
 166   <dt>type</dt>
 167   <dd>The type of map. This is one of: passwd, aids or sbes</dd>
 168   <dt>year</dt>
 169   <dd>The current year</dd>
 170   <dt>date</dt>
 171   <dd>The current date in YYYY-MM-DD format</dd>
 172 </dl>
 173
 174 <p>These files are automatically generated by dsmetrics however they are not guaranteed to be up to the minute. The script attempts to workaround this by first starting with the current day then working backward one day at a time for up to 30 days. Thus if say /data/cmetrics/dal-design/passwd.2006/2006-12-31 has not yet be generated 2006-12-30 will be checked, then 2006-12-29 and so on.</p>
 175
 176 <p>Problem is that that algorithm <i>assumes</i> that the data store (e.g. /data/cmetrics/&lt;<i>site</i>&gt;/&lt;<i>type</i>&gt;.&lt;<i>year</i>&gt;) has at least 30 days of information. This assumption breaks when the year changes since the year is contained in the parent directory. So, for example, given today is 1/8/2007, if .../passwd.2007/2007-01-08 has not be generated we can only check for 07, 06, .., 01. Checking for .../paswd.<font color="#ff0000"><b>2007</b></font>/<font  color="#3333ff"><b>2006</b></font>-12-31 makes no sense and will never work.</p>
 177
 178 <p>Updating of the various files under /data/cmetrics seems sporadic. Currently the script is still not runnable as there is no /data/cmetrics/recv/tii-shared/password.2007 entries at all! The script is failing with:</p>
 179
 180 <div class=code><pre>
 181 $ ./cclic_report.pl -v
 182 cclic_report.pl (v{VERSION}) starting
 183 Getting full path to data files
 184 Unable to find /data/cmetrics/recv/tii-shared/passwd.2007/2006-12-10 at ./cclic_report.pl line 137
 185         main::findFile('/data/cmetrics/recv/tii-shared/passwd.2007') called at ./cclic_report.pl line 249
 186 </pre></div>
 187
 188 <p>I can see no real quick or easy solution for this except to wait for tii-shared's 2007 files to be generated...</p>
 189
 190                               <p class="entry-footer">
 191                                  <span class="post-footers">Posted by  at  8:34 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000608.html">Permalink</a>
 192
 193
 194                               </p>
 195                            </div>
 196                         </div>
 197                      </div>
 198
 199
 200
 201                      <h2 class="date-header">January  5, 2007</h2>
 202                      <a id="a000609"></a>
 203                      <div class="entry" id="entry-609">
 204                         <h3 class="entry-header">Checkpoint</h3>
 205                         <div class="entry-content">
 206                            <div class="entry-body">
 207                               <ul>
 208   <li>Checked in recent changes to GPDB and its associated scripts</li>
 209 </ul>
 210
 211                               <ul>
 212   <li>gpdb_add_project:</li>
 213
 214   <ul>
 215     <li>Added interrupt handling</li>
 216
 217     <li>Moved logic that determines what site a machine is in from here to gpdb.pm</li>
 218
 219     <li>Fixed but in checking "no such map" from NIS</li>
 220   </ul>
 221
 222   <li>gpdb_add_vob:</li>
 223
 224   <ul>
 225     <li>Added function prototypes</li>
 226
 227     <li>Changed to put together list of vobs from all regions</li>
 228
 229     <li>Added getting of Vob Family UUID and Vob UUID</li>
 230
 231     <li>Now using gpdb_currentSite</li>
 232   </ul>
 233
 234   <li>gpdb_convertuk:</p>
 235
 236   <ul>
 237     <li>Added function prototypes</li>
 238   </ul>
 239
 240   <li>gpdb.pm:</li>
 241
 242   <ul>
 243     <li>Reorganized export list</li>
 244
 245     <li>Added gpdb_mklink_user_to_site,  gpdb_mklink_user_to_project, gpdb_unlink_user_from_project, gpdb_unlink_user_from_site<li>
 246
 247     <li>Implement gpdb_siteForHostname. This routine returns the site name for the passed in hostname (default localhost)</li>
 248
 249     <li>Implemented gpdb_getuserByID</li>
 250
 251     <li>Changed handling of retunred %ccdefaults</li>
 252
 253     <li>Changed gpdb_getProject to properly return the retired flag</li>
 254
 255     <li>Change gpdb_putProject to call gpdb_mklink_user_to_project</li>
 256
 257     <li>Renamed siteName and projectName to gpdb_siteName and gpdb_projectName respctively</li>
 258
 259     <li>Implemented gpdb_siteAdmins. This returns an array of AXIDs who are site admins</li>
 260   </ul>
 261
 262   <li>tables.sql:</li>
 263
 264   <ul>
 265     <li>Added family_uuid and vob_uuid</li>
 266   </ul>
 267 </ul>
 268
 269                               <p class="entry-footer">
 270                                  <span class="post-footers">Posted by  at 10:30 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000609.html">Permalink</a>
 271
 272
 273                               </p>
 274                            </div>
 275                         </div>
 276                      </div>
 277
 278
 279
 280
 281                      <a id="a000607"></a>
 282                      <div class="entry" id="entry-607">
 283                         <h3 class="entry-header">Nice is not so "nice"</h3>
 284                         <div class="entry-content">
 285                            <div class="entry-body">
 286                               <ul>
 287   <li>Changed gpdb_add_vob.pl to use Rexec.pm in order that it may be able to collect information about vobs from other sites</li>
 288 </ul>
 289
 290                               <h3>gpdb_add_vob.pl and other sites</h3>
 291
 292 <p>It was hoped that we cout point things to "login servers" instead of machines specifically designated as DesignSync servers as had been the case for gpdb_add_project.pl. These script really only require cleartool and access, through the automount map, to the sync_custom area in order to pick up the SiteRegistry.reg file.</p>
 293
 294 <p>However gpdb_add_vob.pl uses a heuristic in an attempt to determine what project a particular vob is associated with. The heuristic states that the vob storage path will have as part of it's path, a project directory. While this is often, but not always, the case here in Dallas, it is not the case at all in Nice! Thus, even though gpdb_add_vob.pl can log into remote sites to gather information about vobs, when logging into Nice it finds that no vob in Nice adheres to this convention and thus it cannot add vob records for any vob in Nice. Nice had been using vob attributes for things like the AID of the owner of the vob but there is no attribute for the project that a vob is associated with!</p>
 295
 296
 297                               <p class="entry-footer">
 298                                  <span class="post-footers">Posted by  at  8:27 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000607.html">Permalink</a>
 299
 300
 301                               </p>
 302                            </div>
 303                         </div>
 304                      </div>
 305
 306
 307
 308                      <h2 class="date-header">January  4, 2007</h2>
 309                      <a id="a000605"></a>
 310                      <div class="entry" id="entry-605">
 311                         <h3 class="entry-header">gpdb_add_vob.pl</h3>
 312                         <div class="entry-content">
 313                            <div class="entry-body">
 314                               <ul>
 315   <li>Changed gpdb_getProjectsAtSite to be able to separately return all Clearcase projects, Designsync projects, Clearcase & Designsync projects, projects without Clearcase or Designsync associated with them</li>
 316
 317   <li>Modified gpdb_add_vob.pl to traverse through all regions of current registry server to collect all vob tags</li>
 318
 319   <li>Modified clearcase record to include fields for VOB Family uuid and VOB uuid. Also modified gpdb_add_vob.pl to get these uuids</li>
 320
 321   <li>Investigated Victor's CC Metrics database</li>
 322
 323   <li>Fixed bug in gpdb_add_vob.pl that was adding clearcase records assigned to the wrong site.</li>
 324 </ul>
 325
 326                               <p class="entry-footer">
 327                                  <span class="post-footers">Posted by  at 11:20 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000605.html">Permalink</a>
 328
 329
 330                               </p>
 331                            </div>
 332                         </div>
 333                      </div>
 334
 335
 336
 337                      <h2 class="date-header">January  3, 2007</h2>
 338                      <a id="a000606"></a>
 339                      <div class="entry" id="entry-606">
 340                         <h3 class="entry-header">Site Admins</h3>
 341                         <div class="entry-content">
 342                            <div class="entry-body">
 343                               <ul>
 344   <li>Changed gpdb_convertuk.pl to properly add mapping records for <i>Site Admins</i></li>
 345
 346   <li>Changed Single Site Display to display <i>Site Admins</i></li>
 347
 348   <li>Change Single Site Display to include all information from Excel design spreadsheet from Bill. Also tightened up display of cc_defaults</li>
 349
 350   <li>Added new gpdb_siteForHostname that returns the site for a given hostname. Default is current host. Uses nslookup to retrieve the CNAME for the host</li>
 351 </ul>
 352
 353                               <p class="entry-footer">
 354                                  <span class="post-footers">Posted by  at 11:27 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000606.html">Permalink</a>
 355
 356
 357                               </p>
 358                            </div>
 359                         </div>
 360                      </div>
 361
 362                   </div>
 363                </div>
 364             </div>
 365          </div>
 366       </div>
 367    </div>
 368 </body>
 369 </html>