defaria.com/blogs/Status/2007/05/gpdb-20.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=" Sent email to Donna describing how to work with GPDB 2.0 Implemented Aliases Changed project search to go off of new view for project aliases Fixed bug in displaying of DesignSync information for projects...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>GPDB 2.0 - 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/2007/05/gpdb-20.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/2007/05/cc-defaults-rep.html" title="CC Defaults report">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2007/06/first-productiv.html" title="First productive day">
  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="GPDB 2.0">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2007/05/gpdb-20.html">
  26     <meta property="og:description" content=" Sent email to Donna describing how to work with GPDB 2.0 Implemented Aliases Changed project search to go off of new view for project aliases Fixed bug in displaying of DesignSync information for projects...">
  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=" Sent email to Donna describing how to work with GPDB 2.0 Implemented Aliases Changed project search to go off of new view for project aliases Fixed bug in displaying of DesignSync information for projects...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2007/05/gpdb-20.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">GPDB 2.0</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1891" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">GPDB 2.0</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2007-05-22T15:52:32-08:00" itemprop="datePublished">May 22, 2007</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/gpdb/">GPDB</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Sent email to Donna describing how to work with GPDB 2.0</li>
  86
  87   <li>Implemented Aliases</li>
  88
  89   <li>Changed project search to go off of new view for project aliases</li>
  90
  91   <li>Fixed bug in displaying of DesignSync information for projects</li>
  92 </ul>
  93                   <p>This email is to describe to you how to use the new GPDB API. For the most part, for the functions you had been calling, the interface should be identical. Sometimes you'll need to change the hash that you pass in as the Perl module uses Perl hash's name/value pairs as a direct relationship to the field names and values in the database. So if you use a hash key that doesn't correspond to a database field name then it won't work.</p>
  94
  95 <p>Also (attached) is your syncGPDBAddDSProj.pl script ported to use GPDB 2.0.</p>
  96
  97 <h3>Alternate Database</h3>
  98
  99 <p>Note that until GPDB 2.0 is released we have GPDB 1.0 in production. The GPDB API has been augmented to allow you to specify an alternate database. The gpdb_login call supports an additional parameter to specify which database to open:</p>
 100
 101 <blockquote>
 102   <p><i>gpdb_login (username, password, db)</i></p>
 103
 104   <p>The gpdb_login() method takes a username and non-encrypted password as parameters and returns a user authentication string. Additionally an optional db parameter can be passed in. Default is "Oracle" and represents the production database. Use "OracleDevelopment" to access the test database. The authentication string make look like "::browse" or "readonly::browse" if (1) the username is not found in the gpdb user table or (2) the password does not match the user's enterprise password. This could be the desired effect as often the tool may be run by individuals that only need "browse" access for reference.</p>
 105 </blockquote>
 106
 107 <p>While gpdb_login supports this extra parameter I don't think you'll often use it. Instead you can specify which database to use in an environment variable GPDB_ACTIVE_DB:</p>
 108
 109 <div class=code><pre>
 110 $ export GPDB_ACTIVE_DB=OracleDevelopment
 111 $ ./myscript.pl
 112 </pre></div>
 113
 114 <h3>Where to pick up the GPDB API</h3>
 115
 116 <p>Again, because we have GPDB 1.0 in production we cannot push out the GPDB 2.0 API (Perl Modules) to the same locations as GPDB 1.0 API. As such you will need to temporarily point to them at an alternate location. Here's a full set of Perl use statements needed:</p>
 117
 118 <div class=code><pre>
 119 # Standard CDOE modules (Modules of the month!)
 120 use lib "/apps/perl/modules-0609/lib";
 121
 122 # Perl/Oracle libraries
 123 use lib "/apps/oracle/perl/10.2.0.1.0/lib";
 124
 125 #use lib "/apps/cmpackages/perl/lib/site_perl/5.8.0";
 126 use lib "/web/gpdb/cgi-bin";
 127
 128 use GPDB::gpdb;
 129 </pre></div>
 130
 131 <p>When the GPDB API 2.0 gets released we can use the /apps/cmpackages/perl/lib/site_perl/5.8.0 and remove the /web/gpdb/cgi-bin use statement.</p>
 132
 133 <h3>GPDB now authenticates to the enterprise LDAP</h3>
 134
 135 <p>GPDB logins now use your AXID and your enterprise password! If this is incorrect then you will only be granted read access. If you specify a proper AXID and enterprise password you will authenticate. GPDB then checks with its users table to see if you have been granted administrative, thus read/write, access. There is also a GPDB administrative user that can be used for long running, cron like scripts.</p>
 136
 137 <h3>Did somebody ask for aliases?</h3>
 138
 139 <p>I've implemented a rudimentary form of aliases since you were so interested in them. Aliases are global (and alias of "foo" related to a project "bar" at all sites). You can add or delete aliases on the Update Project screen (e.g. <a href="http://gpdb.design.ti.com/cgi-bin/gpdb-devel.pl?db=OracleDevelopment&amp;operation=showProject&amp;projectName=faraday&amp;siteName=Dallas">faraday
 140 Project</a>). Additionally the Project: Search screen will search for projects based on name and alias.</p>
 141
 142 <h3>Oracle/Linux issues</h3>
 143
 144 <p>We are still kinda of working out how to access Oracle on Linux through Perl.</p>
 145
 146 <h3>syncGPDBAddDSProj.pl script</h3>
 147
 148 <p>I've ported this script (attached) to GPDB 2.0. Note the comments in the code about changed required for GPDB 2.0. Here is a command line execution:</p>
 149
 150 <div class=code><pre>
 151 $ ./syncGPDBAddDSProj.pl -f Dallas -p 10000 -a &lt;userid&gt; -w &lt;password&gt; \
 152 &gt; -n andrew_defaria -g ASIC -c /tmp -s drteeth.dal.design.ti.com
 153 </pre></div>
 154
 155 <p>And you can see the project added <a href="http://gpdb.design.ti.com/cgi-bin/gpdb-devel.pl?db=OracleDevelopment&amp;operation=showProject&amp;projectName=andrew_defaria&amp;siteName=Dallas">here</a>.</p>
 156                 </div>
 157                 <nav class="page-navigation entry-navigation pagination content-nav">
 158                   <ul class="page-navigation-list">
 159
 160                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/05/cc-defaults-rep.html" title="CC Defaults report">Previous entry</a></li>
 161
 162
 163                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/06/first-productiv.html" title="First productive day">Next entry</a></li>
 164
 165                   </ul>
 166                 </nav>
 167                 <!--
 168 <aside id="zenback" class="zenback feedback">
 169   Please paste Zenback script code here.
 170 </aside>
 171 -->
 172
 173
 174               </article>
 175             </div>
 176             <aside class="widgets related" role="complementary">
 177               <nav class="widget-search widget">
 178   <div class="widget-content">
 179     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 180       <div>
 181         <input type="text" name="search" value="" placeholder="Search...">
 182
 183         <input type="hidden" name="IncludeBlogs" value="8">
 184
 185         <input type="hidden" name="limit" value="20">
 186         <button type="submit" name="button">
 187           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 188         </button>
 189       </div>
 190     </form>
 191   </div>
 192 </nav>
 193 <nav class="widget-archive-category widget">
 194   <h3 class="widget-header">Categories</h3>
 195   <div class="widget-content">
 196
 197
 198     <ul class="widget-list">
 199
 200
 201       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 202
 203
 204       </li>
 205
 206
 207
 208
 209       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 210
 211
 212       </li>
 213
 214
 215
 216
 217       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 218
 219
 220       </li>
 221
 222
 223
 224
 225       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 226
 227
 228       </li>
 229
 230
 231
 232
 233       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 234
 235
 236       </li>
 237
 238
 239
 240
 241       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 242
 243
 244       </li>
 245
 246
 247
 248
 249       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 250
 251
 252       </li>
 253
 254
 255
 256
 257       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 258
 259
 260       </li>
 261
 262
 263
 264
 265       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 266
 267
 268       </li>
 269
 270
 271
 272
 273       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 274
 275
 276       </li>
 277
 278
 279
 280
 281       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 282
 283
 284       </li>
 285
 286
 287
 288
 289       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 290
 291
 292       </li>
 293
 294     </ul>
 295
 296
 297   </div>
 298 </nav>
 299
 300
 301 <nav class="widget-archive-dropdown widget">
 302   <h3 class="widget-header">Archives</h3>
 303   <div class="widget-content">
 304     <select>
 305       <option>Select a Month...</option>
 306
 307       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 308
 309
 310
 311       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 312
 313
 314
 315       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 316
 317
 318
 319       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 320
 321
 322
 323       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 324
 325
 326
 327       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 328
 329
 330
 331       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 332
 333
 334
 335       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 336
 337
 338
 339       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 340
 341
 342
 343       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 344
 345
 346
 347       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 348
 349
 350
 351       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 352
 353
 354
 355       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 356
 357
 358
 359       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 360
 361
 362
 363       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 364
 365
 366
 367       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 368
 369
 370
 371       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 372
 373
 374
 375       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 376
 377
 378
 379       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 380
 381
 382
 383       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 384
 385
 386
 387       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 388
 389
 390
 391       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 392
 393
 394
 395       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 396
 397
 398
 399       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 400
 401
 402
 403       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 404
 405
 406
 407       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 408
 409
 410
 411       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 412
 413
 414
 415       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 416
 417
 418
 419       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 420
 421
 422
 423       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 424
 425
 426
 427       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 428
 429
 430
 431       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 432
 433
 434
 435       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 436
 437
 438
 439       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 440
 441
 442
 443       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 444
 445
 446
 447       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 448
 449
 450
 451       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 452
 453
 454
 455       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 456
 457
 458
 459       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 460
 461
 462
 463       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 464
 465
 466
 467       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 468
 469
 470
 471       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 472
 473
 474
 475       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 476
 477
 478
 479       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 480
 481
 482
 483       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 484
 485
 486
 487       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 488
 489
 490
 491       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 492
 493
 494
 495       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 496
 497
 498
 499       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 500
 501
 502
 503       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 504
 505
 506
 507       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 508
 509
 510
 511       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 512
 513
 514
 515       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 516
 517
 518
 519       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 520
 521
 522
 523       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 524
 525
 526
 527       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 528
 529
 530
 531       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 532
 533
 534
 535       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 536
 537
 538
 539       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 540
 541
 542
 543       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 544
 545
 546
 547       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 548
 549
 550
 551       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 552
 553
 554
 555       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 556
 557
 558
 559       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 560
 561
 562
 563       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 564
 565
 566
 567       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 568
 569
 570
 571       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 572
 573
 574
 575       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 576
 577
 578
 579       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 580
 581
 582
 583       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 584
 585
 586
 587       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 588
 589
 590
 591       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 592
 593     </select>
 594   </div>
 595 </nav>
 596
 597
 598
 599 <div class="widget-syndication widget section">
 600   <div class="widget-content">
 601     <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>
 602
 603   </div>
 604 </div>
 605
 606             </aside>
 607           </div>
 608         </div>
 609         <footer id="footer" role="contentinfo">
 610           <div id="footer-inner">
 611             <div id="footer-content">
 612   <nav role="navigation">
 613           <ul>
 614             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 615
 616
 617           </ul>
 618         </nav>
 619
 620   <p class="license">&copy; Copyright 2016.</p>
 621   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 622 </div>
 623           </div>
 624         </footer>
 625       </div>
 626     </div>
 627     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 628     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 629   </body>
 630 </html>