defaria.com/blogs/Status/2005/10/pqa-merge-audit.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" Documented remaining PQA Conversion Issues Audit_Log is not handled properly currently. Querying Vinh Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>PQA Merge Issues/Pong - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-audit.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-4.html" title="PQA Clearquest:: Spacing out">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-user.html" title="PQA Merge: User Issues">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="PQA Merge Issues/Pong">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/10/pqa-merge-audit.html">
  26     <meta property="og:description" content=" Documented remaining PQA Conversion Issues Audit_Log is not handled properly currently. Querying Vinh Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" Documented remaining PQA Conversion Issues Audit_Log is not handled properly currently. Querying Vinh Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-audit.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">PQA Merge Issues/Pong</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1719" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">PQA Merge Issues/Pong</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2005-10-17T20:00:32-08:00" itemprop="datePublished">October 17, 2005</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/pqa/">PQA</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Documented remaining <a href="http://intranet.broadcom.com/~adefaria/Clearquest/">PQA Conversion Issues</a></li>
  86
  87   <li>Audit_Log is not handled properly currently. Querying Vinh</li>
  88
  89   <li>Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks</li>
  90
  91   <li>Investigated using LDAP authentication with Clearquest</li>
  92
  93   <li>Wrote a simple expect script (pong) and bash script to verify that a machine is up and send email if it isn't. Problem is ccase-rmna-1 lacks expect!</li>
  94 </ul>
  95                   <h2>Audit_Log</h2>
  96
  97 <p>As it stands <b>Audit_Log</b> is probably not being handled the way you think it should be. My investigation seems to indicate that <b>Audit_Log</b> is, as its name suggest, an auditing of what changes were made. In transferring from the old databases to the new one, the new <b>Audit_Log</b> is essentially a blank slate. It is the responsbility of the Action Script <tt>RecordHistory</tt> to update the <b>Audit_Log</b>. Thus the only recording in <b>Audit_Log</b> for the transfer is that the record was added! In    other words all history is lost! I don't think that's what you want. We will need to similarly change <b>Audit_Log</b> to be a simple <i>OPTIONAL</i> field with no Action Scripts in order for <tt>pqamerge</tt> to transfer the Audit_Log</b>.</p>
  98
  99 <h2>LDAP Authentication</h2>
 100
 101 <p>Regarding LDAP authentication: There is a whole new chapter in the Clearquest Admin Guide about this and we'll need to coordinate this with an <i>LDAP Administrator</i> (Ray, who's our LDAP Administrator?). On the plus side users would no longer have to remember separate  usernames/passwords for Clearquest. In fact, new users would not even need to be added because if they are in the ActiveDirectory then they have a login from Clearquest. Of course I suspect that security is then achieved by Clearquest groupings, which, as far as I can tell, are still manually created in Clearquest Designer's User Administration screen. Additionally, LDAP permitting, other fields will be instantaneously mapped properly like Full Name, Phone Number and the ever popular Email Address! In other words, LDAP authentication is doable but a little complicated, requires coordination with the LDAP administrator and requires a number of carefully executed commands.</p>
 102
 103 <p>One issue or thing to test would be if older Clearquest clients can
 104 still authenticate with LDAP. If not then the user community would need
 105 to update their Clearquest.</p>
 106
 107 <h2>Pong</h2>
 108
 109 <p>I now have a script called pong.sh (and a corresponding expect script called pong.tcl) that will "pong" a system and send email if it does not respond. By "pong" I mean it will telnet to the machine, attempt to login as vobadm and check for a "proper" prompt. If it fails then email is sent to the members of our project (Ray is working on a bona fide email alias...).</p>
 110
 111 <p>I planned on running this from ccase-rmna-1 in vobadm's crontab (BTW: There was a blank line in the crontab, which causes Solaris to complain (Other OSes are this picky. I removed that blank line).</p>
 112
 113 <p>The problem now is that ccase-rmna-1 lacks expect! :-( </p>
 114                 </div>
 115                 <nav class="page-navigation entry-navigation pagination content-nav">
 116                   <ul class="page-navigation-list">
 117
 118                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-4.html" title="PQA Clearquest:: Spacing out">Previous entry</a></li>
 119
 120
 121                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-user.html" title="PQA Merge: User Issues">Next entry</a></li>
 122
 123                   </ul>
 124                 </nav>
 125                 <!--
 126 <aside id="zenback" class="zenback feedback">
 127   Please paste Zenback script code here.
 128 </aside>
 129 -->
 130
 131
 132               </article>
 133             </div>
 134             <aside class="widgets related" role="complementary">
 135               <nav class="widget-search widget">
 136   <div class="widget-content">
 137     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 138       <div>
 139         <input type="text" name="search" value="" placeholder="Search...">
 140
 141         <input type="hidden" name="IncludeBlogs" value="8">
 142
 143         <input type="hidden" name="limit" value="20">
 144         <button type="submit" name="button">
 145           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 146         </button>
 147       </div>
 148     </form>
 149   </div>
 150 </nav>
 151 <nav class="widget-archive-category widget">
 152   <h3 class="widget-header">Categories</h3>
 153   <div class="widget-content">
 154
 155
 156     <ul class="widget-list">
 157
 158
 159       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 160
 161
 162       </li>
 163
 164
 165
 166
 167       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 168
 169
 170       </li>
 171
 172
 173
 174
 175       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 176
 177
 178       </li>
 179
 180
 181
 182
 183       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 184
 185
 186       </li>
 187
 188
 189
 190
 191       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 192
 193
 194       </li>
 195
 196
 197
 198
 199       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 200
 201
 202       </li>
 203
 204
 205
 206
 207       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 208
 209
 210       </li>
 211
 212
 213
 214
 215       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 216
 217
 218       </li>
 219
 220
 221
 222
 223       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 224
 225
 226       </li>
 227
 228
 229
 230
 231       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 232
 233
 234       </li>
 235
 236
 237
 238
 239       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 240
 241
 242       </li>
 243
 244
 245
 246
 247       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 248
 249
 250       </li>
 251
 252     </ul>
 253
 254
 255   </div>
 256 </nav>
 257
 258
 259 <nav class="widget-archive-dropdown widget">
 260   <h3 class="widget-header">Archives</h3>
 261   <div class="widget-content">
 262     <select>
 263       <option>Select a Month...</option>
 264
 265       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 266
 267
 268
 269       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 270
 271
 272
 273       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 274
 275
 276
 277       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 278
 279
 280
 281       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 282
 283
 284
 285       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 286
 287
 288
 289       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 290
 291
 292
 293       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 294
 295
 296
 297       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 298
 299
 300
 301       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 302
 303
 304
 305       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 306
 307
 308
 309       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 310
 311
 312
 313       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 314
 315
 316
 317       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 318
 319
 320
 321       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 322
 323
 324
 325       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 326
 327
 328
 329       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 330
 331
 332
 333       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 334
 335
 336
 337       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 338
 339
 340
 341       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 342
 343
 344
 345       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 346
 347
 348
 349       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 350
 351
 352
 353       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 354
 355
 356
 357       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 358
 359
 360
 361       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 362
 363
 364
 365       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 366
 367
 368
 369       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 370
 371
 372
 373       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 374
 375
 376
 377       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 378
 379
 380
 381       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 382
 383
 384
 385       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 386
 387
 388
 389       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 390
 391
 392
 393       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 394
 395
 396
 397       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 398
 399
 400
 401       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 402
 403
 404
 405       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 406
 407
 408
 409       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 410
 411
 412
 413       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 414
 415
 416
 417       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 418
 419
 420
 421       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 422
 423
 424
 425       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 426
 427
 428
 429       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 430
 431
 432
 433       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 434
 435
 436
 437       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 438
 439
 440
 441       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 442
 443
 444
 445       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 446
 447
 448
 449       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 450
 451
 452
 453       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 454
 455
 456
 457       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 458
 459
 460
 461       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 462
 463
 464
 465       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 466
 467
 468
 469       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 470
 471
 472
 473       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 474
 475
 476
 477       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 478
 479
 480
 481       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 482
 483
 484
 485       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 486
 487
 488
 489       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 490
 491
 492
 493       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 494
 495
 496
 497       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 498
 499
 500
 501       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 502
 503
 504
 505       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 506
 507
 508
 509       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 510
 511
 512
 513       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 514
 515
 516
 517       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 518
 519
 520
 521       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 522
 523
 524
 525       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 526
 527
 528
 529       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 530
 531
 532
 533       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 534
 535
 536
 537       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 538
 539
 540
 541       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 542
 543
 544
 545       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 546
 547
 548
 549       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 550
 551     </select>
 552   </div>
 553 </nav>
 554
 555
 556
 557 <div class="widget-syndication widget section">
 558   <div class="widget-content">
 559     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 560
 561   </div>
 562 </div>
 563
 564             </aside>
 565           </div>
 566         </div>
 567         <footer id="footer" role="contentinfo">
 568           <div id="footer-inner">
 569             <div id="footer-content">
 570   <nav role="navigation">
 571           <ul>
 572             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 573
 574
 575           </ul>
 576         </nav>
 577
 578   <p class="license">&copy; Copyright 2016.</p>
 579   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 580 </div>
 581           </div>
 582         </footer>
 583       </div>
 584     </div>
 585     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 586     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 587   </body>
 588 </html>