defaria.com/blogs/Status/2007/03/gpdb-web-update.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=" Added menus to GPDB web Tested and documented access of Oracle databases, such as GPDB, using standard Perl and standard Oracle libraries from various architectures...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>GPDB Web Update/Oracle testing - 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/03/gpdb-web-update.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/03/mysql-client-li.html" title="MySQL Client Libraries">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2007/03/gpdb-login-1.html" title="GPDB Login">
  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 Web Update/Oracle testing">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2007/03/gpdb-web-update.html">
  26     <meta property="og:description" content=" Added menus to GPDB web Tested and documented access of Oracle databases, such as GPDB, using standard Perl and standard Oracle libraries from various architectures...">
  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=" Added menus to GPDB web Tested and documented access of Oracle databases, such as GPDB, using standard Perl and standard Oracle libraries from various architectures...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2007/03/gpdb-web-update.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 Web Update/Oracle testing</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1874" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">GPDB Web Update/Oracle testing</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2007-03-21T16:52:37-08:00" itemprop="datePublished">March 21, 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/texas-instruments/">Texas Instruments</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Added menus to GPDB web</li>
  86
  87   <li>Tested and documented access of Oracle databases, such as GPDB, using standard Perl and standard Oracle libraries from various architectures</li>
  88 </ul>
  89                   <p>Joe Ramey had worked on getting the Oracle Linux client API library to work with Perl. I am trying to validate that this works on all supported architectures where <i>all supported architectures</i> is considered the subset of:</p>
  90 <ol>
  91   <li>Solaris (e.g. Stashu)</li>
  92   <li>Linux 32-bit (e.g. Fad01)</li>
  93   <li>Linux 64-bit AMD Opteron processor (e.g. DrTeeth)</li>
  94   <li>Linux 64-bit Intel processor (e.g. Fad11)</li>
  95 </ol>
  96
  97 <h3>How to properly code Perl to access an Oracle DB</h3>
  98
  99 <p>Normal access to SQL databases in Perl usually consists of use'ing two different Perl modules. First a DBI.pm module which is the<i> <b>D</b>ata<b>B</b>ase <b>I</b>ndependent</i> interface and the DBD or <b><i>D</i></b><i>ata<b>B</b>ase <b>D</b>river</i> module for the particular SQL database involved. We are interested in Oracle here but others include mSQL, MySQL, etc.</p>
 100
 101 <p>Couple this with the fact that we wish to use the standard Perl (e.g. /apps/perl/5.8.3/bin/perl) and standard Perl modules (/apps/perl/modules-&lt;<i>datecode</i>&gt; where <i>datecode</i> is some combination of a year/month date code whose apparent LCD seems to be modules-0412).</p>
 102
 103 <p>So first our Perl script should start with:</p>
 104
 105 <div class=code><pre>
 106 <font color="#3333ff">#!/apps/perl/5.8.3/bin/perl</font>
 107 <font color="#ff0000">use strict</font>;
 108 <font color="#ff0000">use warnings</font>;
 109
 110 <font color="#3333ff"># Standard CDOE modules (Modules of the month!) - need this to pick up DBI.pm</font>
 111 <font color="#ff0000">use lib</font> "<font color="#009900">/apps/perl/modules-0412/lib</font>";
 112 </pre></div>
 113
 114 <p>So as the comment indicates we are picking up the DBI.pm module from here. Next, normally, we'd simply include the lib path for the Oracle DBD.pm (or in the special case of Oracle, the Oracle.pm file) as well as the supporting shared library Oracle.so (which is architecturally dependent) by coding the following:</p>
 115
 116 <div class=code><pre>
 117 <font color="#3333ff"># Perl/Oracle libraries</font>
 118 <font color="#ff0000">use lib</font> "<font color="#009900">/apps/oracle/perl/10.2.0.1.0/lib</font>";
 119 </pre></div>
 120
 121 <p>However, since Linux client support is not included in /apps/oracle/perl/10.2.0.1.0/lib (yet) we need to pick up Joe's stuff:</p>
 122
 123 <div class=code><pre>
 124 <font color="#3333ff"># Linux API is in Ramey's home dir...</font>
 125 <font color="#ff0000">use lib</font> "<font color="#009900">/home/ramey/oracle/perl/10.2.0.1.0/lib</font>";
 126 </pre></div>
 127
 128 <p>The next excerpt from my code, shown in it's entirety later, shows a lib path I used to use that allows Solaris clients to work correctly, however we wish to move away from this special cased library thus it's commented out here:</p>
 129
 130 <div class=code><pre>
 131 <font color="#3333ff"># This is a non standard Oracle</font>
 132 <font color="#3333ff">#use lib "/apps/perl/5.8.0/lib/perl5/site_perl/5.8.0";</font>
 133 </pre></div>
 134
 135 <p>As the full code listing that follows shows I then use my current development libraries and attempt to log into the development version of GPDB, and Oracle database, and retrieve and display some rudimentary data:</p>
 136
 137 <p><font color="#999999">Entire code listing of ~x0062320/testgpdb.pl</font></p>
 138
 139 <div class=code><pre>
 140 <font color="#3333ff">#!/apps/perl/5.8.3/bin/perl</font>
 141 <font color="#ff0000">use strict</font>;
 142 <font color="#ff0000">use warnings</font>;
 143
 144 <font color="#3333ff"># Standard CDOE modules (Modules of the month!) - need this to pick up DBI.pm</font>
 145 <font color="#ff0000">use lib</font> "<font color="#009900">/apps/perl/modules-0412/lib</font>";
 146
 147 <font color="#3333ff"># Perl/Oracle libraries</font>
 148 <font color="#ff0000">use lib</font> "<font color="#009900">/apps/oracle/perl/10.2.0.1.0/lib</font>";
 149
 150 <font color="#3333ff"># Linux API is in Ramey's home dir...</font>
 151 <font color="#ff0000">use lib</font> "<font color="#009900">/home/ramey/oracle/perl/10.2.0.1.0/lib</font>";
 152
 153 <font color="#3333ff"># This is a non standard Oracle</font>
 154 <font color="#3333ff">#use lib "/apps/perl/5.8.0/lib/perl5/site_perl/5.8.0";
 155
 156 # Current development GPDB modules</font>
 157 <font color="#ff0000">use lib</font> "<font color="#009900">/web/gpdb/cgi-bin</font>";
 158
 159 <font color="#ff0000">use GPDB::gpdb</font>;
 160
 161 <font color="#3333ff"># Log into GPDB - read only</font>
 162 gpdb_login (<font color="#33cc00">undef</font>, <font color="#33cc00">undef</font>, "<font color="#009900">OracleDevelopment</font>");
 163
 164 <font color="#3333ff"># Get a project</font>
 165 <font color="#ff0000">my</font> <font color="#3333ff"><b>@projects</b></font> = gpdb_getProject ("<font color="#009900">uma</font>");
 166
 167 <font color="#3333ff"># Play with it a little bit...</font>
 168 <font color="#ff0000">my</font> <i><font color="#ff0000">%project</font></i> = %{<font color="#3333ff"><b>$projects</b></font> [0][0]};
 169
 170 <font color="#33cc00">print</font> "<font color="#009900">Project: ${project {PROJECT}{NAME}}\n</font>";
 171 <font color="#33cc00">print</font> "<font color="#009900">Site: ${project {PROJECT}{SITE_NAME}}\n</font>";
 172
 173 <font color="#33cc00">print</font> "<font color="#009900">Vobs:\n</font>";
 174
 175 <font color="#ff0000">foreach</font> (@{<font color="#ff0000">$project</font> {CLEARCASE}}) {
 176 <font color="#ff0000">my</font> <i><font color="#ff0000">%cc</font></i> = %{$_};
 177
 178 <font color="#33cc00">print</font> "<font color="#009900">\t${cc {VOB_TAG}}\n</font>";
 179 } <font color="#3333ff"># foreach</font>
 180
 181 <font color="#33cc00">print</font> "<font color="#009900">done\n</font>";
 182 </pre></div>
 183
 184 <h3>Results</h3>
 185
 186 <p>Here's the results running on the target architectures:</p>
 187
 188 <div class=code><pre>
 189 $ ssh stashu testgpdb.pl
 190 DBI connect('host=dflorad01.itg.ti.com;sid=flddsync;port=1521','cm_gpdb_readonly',...) failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. at /web/gpdb/cgi-bin/GPDB/DBHelper.pm line 136
 191 Could not connect to database. Check $ORACLE_HOME. at /web/gpdb/cgi-bin/GPDB/primitive.pm line 81
 192 $ ssh fad01 testgpdb.pl
 193 Project: uma
 194 Site: Dallas
 195 Vobs:
 196         /cdb/dspumatdl
 197         /cdb/uma
 198         /cdb/uma_2.2
 199         /cdb/uma_2.6a
 200 done
 201 $ ssh drteeth testgpdb.pl
 202 Project: uma
 203 Site: Dallas
 204 Vobs:
 205         /cdb/dspumatdl
 206         /cdb/uma
 207         /cdb/uma_2.2
 208         /cdb/uma_2.6a
 209 done
 210 $ ssh fad11 testgpdb.pl
 211 Can't load
 212 '/home/ramey/oracle/perl/10.2.0.1.0/lib/i686-linux-thread-multi/auto/DBI/DBI.so' for module DBI: /lib/libc.so.6: version `GLIBC_2.3' not found (required by
 213 /home/ramey/oracle/perl/10.2.0.1.0/lib/i686-linux-thread-multi/auto/DBI/DBI.so) at /apps/perl/5.8.3/lib/5.8.3/i686-linux-thread-multi/DynaLoader.pm line 229.
 214 at /home/ramey/oracle/perl/10.2.0.1.0/lib/i686-linux-thread-multi/DBI.pm line 259
 215 BEGIN failed--compilation aborted at /home/ramey/oracle/perl/10.2.0.1.0/lib/i686-linux-thread-multi/DBI.pm line 259.
 216 Compilation failed in require at /web/gpdb/cgi-bin/GPDB/primitive.pm line 24.
 217 BEGIN failed--compilation aborted at /web/gpdb/cgi-bin/GPDB/primitive.pm line 24.
 218 Compilation failed in require at /web/gpdb/cgi-bin/GPDB/gpdb.pm line 38.
 219 BEGIN failed--compilation aborted at /web/gpdb/cgi-bin/GPDB/gpdb.pm line 38.
 220 Compilation failed in require at ./testgpdb.pl line 20.
 221 BEGIN failed--compilation aborted at ./testgpdb.pl line 20.
 222 </pre></div>
 223
 224 <p>So as we can see this is <b>not</b> working for Solaris or Linux 64-bit Intel.</p>
 225                 </div>
 226                 <nav class="page-navigation entry-navigation pagination content-nav">
 227                   <ul class="page-navigation-list">
 228
 229                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/03/mysql-client-li.html" title="MySQL Client Libraries">Previous entry</a></li>
 230
 231
 232                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/03/gpdb-login-1.html" title="GPDB Login">Next entry</a></li>
 233
 234                   </ul>
 235                 </nav>
 236                 <!--
 237 <aside id="zenback" class="zenback feedback">
 238   Please paste Zenback script code here.
 239 </aside>
 240 -->
 241
 242
 243               </article>
 244             </div>
 245             <aside class="widgets related" role="complementary">
 246               <nav class="widget-search widget">
 247   <div class="widget-content">
 248     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 249       <div>
 250         <input type="text" name="search" value="" placeholder="Search...">
 251
 252         <input type="hidden" name="IncludeBlogs" value="8">
 253
 254         <input type="hidden" name="limit" value="20">
 255         <button type="submit" name="button">
 256           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 257         </button>
 258       </div>
 259     </form>
 260   </div>
 261 </nav>
 262 <nav class="widget-archive-category widget">
 263   <h3 class="widget-header">Categories</h3>
 264   <div class="widget-content">
 265
 266
 267     <ul class="widget-list">
 268
 269
 270       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 271
 272
 273       </li>
 274
 275
 276
 277
 278       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 279
 280
 281       </li>
 282
 283
 284
 285
 286       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 287
 288
 289       </li>
 290
 291
 292
 293
 294       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 295
 296
 297       </li>
 298
 299
 300
 301
 302       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 303
 304
 305       </li>
 306
 307
 308
 309
 310       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 311
 312
 313       </li>
 314
 315
 316
 317
 318       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 319
 320
 321       </li>
 322
 323
 324
 325
 326       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 327
 328
 329       </li>
 330
 331
 332
 333
 334       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 335
 336
 337       </li>
 338
 339
 340
 341
 342       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 343
 344
 345       </li>
 346
 347
 348
 349
 350       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 351
 352
 353       </li>
 354
 355
 356
 357
 358       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 359
 360
 361       </li>
 362
 363     </ul>
 364
 365
 366   </div>
 367 </nav>
 368
 369
 370 <nav class="widget-archive-dropdown widget">
 371   <h3 class="widget-header">Archives</h3>
 372   <div class="widget-content">
 373     <select>
 374       <option>Select a Month...</option>
 375
 376       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 561
 562
 563
 564       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 565
 566
 567
 568       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 569
 570
 571
 572       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 573
 574
 575
 576       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 577
 578
 579
 580       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 581
 582
 583
 584       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 585
 586
 587
 588       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 589
 590
 591
 592       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 593
 594
 595
 596       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 597
 598
 599
 600       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 601
 602
 603
 604       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 605
 606
 607
 608       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 609
 610
 611
 612       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 613
 614
 615
 616       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 617
 618
 619
 620       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 621
 622
 623
 624       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 625
 626
 627
 628       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 629
 630
 631
 632       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 633
 634
 635
 636       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 637
 638
 639
 640       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 641
 642
 643
 644       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 645
 646
 647
 648       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 649
 650
 651
 652       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 653
 654
 655
 656       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 657
 658
 659
 660       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 661
 662     </select>
 663   </div>
 664 </nav>
 665
 666
 667
 668 <div class="widget-syndication widget section">
 669   <div class="widget-content">
 670     <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>
 671
 672   </div>
 673 </div>
 674
 675             </aside>
 676           </div>
 677         </div>
 678         <footer id="footer" role="contentinfo">
 679           <div id="footer-inner">
 680             <div id="footer-content">
 681   <nav role="navigation">
 682           <ul>
 683             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 684
 685
 686           </ul>
 687         </nav>
 688
 689   <p class="license">&copy; Copyright 2016.</p>
 690   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 691 </div>
 692           </div>
 693         </footer>
 694       </div>
 695     </div>
 696     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 697     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 698   </body>
 699 </html>