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: GPDB Archives</title>
14 <body class="layout-one-column">
16 <div id="container-inner" class="pkg">
19 <div id="banner-inner" class="pkg">
20 <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
21 <h2 id="banner-description">Searchable status reports and work log</h2>
26 <div id="pagebody-inner" class="pkg">
28 <div id="alpha-inner" class="pkg">
30 <p class="content-nav">
31 <a href="http://defaria.com/blogs/Status/">Main</a>
36 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
37 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
38 xmlns:dc="http://purl.org/dc/elements/1.1/">
40 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000643"
41 trackback:ping="http://defaria.com/mt/mt-tb.cgi/31"
43 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000643"
45 dc:description=" 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..."
47 dc:date="2007-05-22T15:52:32-06:00" />
52 <h2 class="date-header">May 22, 2007</h2>
54 <div class="entry" id="entry-643">
55 <h3 class="entry-header">GPDB 2.0</h3>
56 <div class="entry-content">
57 <div class="entry-body">
59 <li>Sent email to Donna describing how to work with GPDB 2.0</li>
61 <li>Implemented Aliases</li>
63 <li>Changed project search to go off of new view for project aliases</li>
65 <li>Fixed bug in displaying of DesignSync information for projects</li>
68 <p class="entry-more-link">
69 <a href="http://defaria.com/blogs/Status/archives/000643.html#more">Continue reading "GPDB 2.0" »</a>
72 <p class="entry-footer">
73 <span class="post-footers">Posted by at 3:52 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000643.html">Permalink</a>
75 | <a href="http://defaria.com/blogs/Status/archives/000643.html#trackback">TrackBacks (0)</a>
82 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
83 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
84 xmlns:dc="http://purl.org/dc/elements/1.1/">
86 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000642"
87 trackback:ping="http://defaria.com/mt/mt-tb.cgi/30"
88 dc:title="CC Defaults report"
89 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000642"
91 dc:description=" Added CC Defaults Report Changed export to export as per the tableName Changed export to export some files not listed on the web page..."
93 dc:date="2007-05-10T17:29:56-06:00" />
98 <h2 class="date-header">May 10, 2007</h2>
100 <div class="entry" id="entry-642">
101 <h3 class="entry-header">CC Defaults report</h3>
102 <div class="entry-content">
103 <div class="entry-body">
105 <li>Added CC Defaults Report</li>
107 <li>Changed export to export as per the tableName</li>
109 <li>Changed export to export some files not listed on the web page</li>
112 <p class="entry-footer">
113 <span class="post-footers">Posted by at 5:29 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000642.html">Permalink</a>
115 | <a href="http://defaria.com/blogs/Status/archives/000642.html#trackback">TrackBacks (0)</a>
122 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
123 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
124 xmlns:dc="http://purl.org/dc/elements/1.1/">
126 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000641"
127 trackback:ping="http://defaria.com/mt/mt-tb.cgi/29"
128 dc:title="GPDB Enhancements"
129 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000641"
131 dc:description=" Added export to CSV file to reports Made DesignSync servers links to the server:port Added links to Project names Site names on reports Added edit link to screen after you update a Project or Site..."
133 dc:date="2007-05-08T15:27:42-06:00" />
138 <h2 class="date-header">May 8, 2007</h2>
140 <div class="entry" id="entry-641">
141 <h3 class="entry-header">GPDB Enhancements</h3>
142 <div class="entry-content">
143 <div class="entry-body">
145 <li>Added export to CSV file to reports</li>
147 <li>Made DesignSync servers links to the server:port</li>
149 <li>Added links to Project names Site names on reports</li>
151 <li>Added edit link to screen after you update a Project or Site</li>
154 <p class="entry-more-link">
155 <a href="http://defaria.com/blogs/Status/archives/000641.html#more">Continue reading "GPDB Enhancements" »</a>
158 <p class="entry-footer">
159 <span class="post-footers">Posted by at 3:27 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000641.html">Permalink</a>
161 | <a href="http://defaria.com/blogs/Status/archives/000641.html#trackback">TrackBacks (0)</a>
168 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
169 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
170 xmlns:dc="http://purl.org/dc/elements/1.1/">
172 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000640"
173 trackback:ping="http://defaria.com/mt/mt-tb.cgi/28"
174 dc:title="LDAP changes/Synonyms and Grants/Reports"
175 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000640"
177 dc:description=" Change primitives::login and ldap_authenticate to return a user record of user information if we can find it in LDAP, even if we could not authenticate the password, and pass back proper status Straightened out new views WRT Synonyms and..."
179 dc:date="2007-05-04T14:35:52-06:00" />
184 <h2 class="date-header">May 4, 2007</h2>
186 <div class="entry" id="entry-640">
187 <h3 class="entry-header">LDAP changes/Synonyms and Grants/Reports</h3>
188 <div class="entry-content">
189 <div class="entry-body">
191 <li>Change primitives::login and ldap_authenticate to return a user record of user information if we can find it in LDAP, even if we could not authenticate the password, and pass back proper status</li>
193 <li>Straightened out new views WRT Synonyms and Grants</li>
195 <li>Implemented Users, Clearcase and DesignSync reports</li>
198 <p class="entry-more-link">
199 <a href="http://defaria.com/blogs/Status/archives/000640.html#more">Continue reading "LDAP changes/Synonyms and Grants/Reports" »</a>
202 <p class="entry-footer">
203 <span class="post-footers">Posted by at 2:35 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000640.html">Permalink</a>
205 | <a href="http://defaria.com/blogs/Status/archives/000640.html#trackback">TrackBacks (0)</a>
212 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
213 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
214 xmlns:dc="http://purl.org/dc/elements/1.1/">
216 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000639"
217 trackback:ping="http://defaria.com/mt/mt-tb.cgi/27"
218 dc:title="GPDB/LDAP/Org/SBE"
219 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000639"
221 dc:description=" Added Org/SBE drop down to edit Project Integrated LDAP! Changed primitive.pm to authenticate with LDAP! Added description to Org/SBE and removed password Added edit links to showProject and showSite..."
223 dc:date="2007-05-03T18:45:32-06:00" />
228 <h2 class="date-header">May 3, 2007</h2>
230 <div class="entry" id="entry-639">
231 <h3 class="entry-header">GPDB/LDAP/Org/SBE</h3>
232 <div class="entry-content">
233 <div class="entry-body">
235 <li>Added Org/SBE drop down to edit Project</li>
237 <li>Integrated LDAP!</li>
239 <li>Changed primitive.pm to authenticate with LDAP!</p>
241 <li>Added description to Org/SBE and removed password</li>
243 <li>Added edit links to showProject and showSite</li>
246 <p class="entry-footer">
247 <span class="post-footers">Posted by at 6:45 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000639.html">Permalink</a>
249 | <a href="http://defaria.com/blogs/Status/archives/000639.html#trackback">TrackBacks (0)</a>
256 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
257 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
258 xmlns:dc="http://purl.org/dc/elements/1.1/">
260 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000638"
261 trackback:ping="http://defaria.com/mt/mt-tb.cgi/26"
262 dc:title="GPDB (Org/SBE and others)"
263 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000638"
265 dc:description=" Changed org_sbe.name to link up with parent_project Created org_sbe.sql to add org_sbe entries Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm Added Org/SBE menu Changed various new tables to to be uniform in width Fixed a few bugs regarding adding of..."
267 dc:date="2007-05-03T09:46:24-06:00" />
274 <div class="entry" id="entry-638">
275 <h3 class="entry-header">GPDB (Org/SBE and others)</h3>
276 <div class="entry-content">
277 <div class="entry-body">
279 <li>Changed org_sbe.name to link up with parent_project</li>
281 <li>Created org_sbe.sql to add org_sbe entries</li>
283 <li>Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm</li>
285 <li>Added Org/SBE menu</li>
287 <li>Changed various new tables to to be uniform in width</li>
289 <li>Fixed a few bugs regarding adding of sites where no site domains are added</li>
291 <li>Added much of Update Project</li>
293 <li>Fixed bug with update CCDefaults for Projects</li>
295 <li>Added screen for adding CCDefaults when adding a project</li>
298 <p class="entry-footer">
299 <span class="post-footers">Posted by at 9:46 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000638.html">Permalink</a>
301 | <a href="http://defaria.com/blogs/Status/archives/000638.html#trackback">TrackBacks (0)</a>
308 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
309 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
310 xmlns:dc="http://purl.org/dc/elements/1.1/">
312 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000637"
313 trackback:ping="http://defaria.com/mt/mt-tb.cgi/25"
314 dc:title="GPDB Enhancements/Fixes"
315 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000637"
317 dc:description="GPDB Login Moved to the top. Changed wording to be more friendly Login with unknown username puts up a warning but grants read only access Login with known username but wrong password is properly denoted Other changes In Project display,..."
319 dc:date="2007-05-01T19:25:50-06:00" />
324 <h2 class="date-header">May 1, 2007</h2>
326 <div class="entry" id="entry-637">
327 <h3 class="entry-header">GPDB Enhancements/Fixes</h3>
328 <div class="entry-content">
329 <div class="entry-body">
333 <li>Moved to the top.</li>
334 <li>Changed wording to be more friendly</li>
335 <li>Login with unknown username puts up a warning but grants read
337 <li>Login with known username but wrong password is properly denoted</li>
340 <h3>Other changes</h3>
343 <li>In Project display, site defaults are not listed on top of the
344 Project defaults.</li>
346 <li>Change width of tables to line up with the menus across the top.</li>
348 <li>Updating of project CC defaults still not working correctly</li>
350 <li>Added Add Project</li>
354 <p class="entry-footer">
355 <span class="post-footers">Posted by at 7:25 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000637.html">Permalink</a>
357 | <a href="http://defaria.com/blogs/Status/archives/000637.html#trackback">TrackBacks (0)</a>
364 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
365 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
366 xmlns:dc="http://purl.org/dc/elements/1.1/">
368 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000636"
369 trackback:ping="http://defaria.com/mt/mt-tb.cgi/24"
370 dc:title="GPDB Enhancements/Fixes"
371 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000636"
373 dc:description=" Implemented gpdb_deleteSiteDomain Modify site almost functionally complete Looking into how to do what MySQL does with it's limit clause in Oracle Changed List Projects at Site to be paged Changed how Projects are displayed Added most of the Project..."
375 dc:date="2007-04-30T14:58:37-06:00" />
380 <h2 class="date-header">April 30, 2007</h2>
382 <div class="entry" id="entry-636">
383 <h3 class="entry-header">GPDB Enhancements/Fixes</h3>
384 <div class="entry-content">
385 <div class="entry-body">
387 <li>Implemented gpdb_deleteSiteDomain</li>
388 <li>Modify site almost functionally complete</li>
389 <li>Looking into how to do what MySQL does with it's limit clause in
391 <li>Changed List Projects at Site to be paged</li>
392 <li>Changed how Projects are displayed </li>
393 <li>Added most of the Project update page</li>
394 <li>Change some of the logic on login/logout</li>
395 <li>Change gpdb_putClearcase to set a global as to whether the record
396 was added/updated or nothing changed.</li>
397 <li>Changed gpdb_add_vob.pl to:</li>
399 <li>Report better the number of Clearcase vob records added or not.</li>
402 <li>Add an UNKNOWN project for the site it's running at (if needed)</li>
403 <li>Properly select the appropriate UNKNOWN project</li>
407 <p class="entry-footer">
408 <span class="post-footers">Posted by at 2:58 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000636.html">Permalink</a>
410 | <a href="http://defaria.com/blogs/Status/archives/000636.html#trackback">TrackBacks (0)</a>
417 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
418 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
419 xmlns:dc="http://purl.org/dc/elements/1.1/">
421 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000632"
422 trackback:ping="http://defaria.com/mt/mt-tb.cgi/21"
423 dc:title="Oracle limit clause"
424 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000632"
426 dc:description=" Modify site almost functionally complete Looking into how to do what MySQL does with it's limit clause in Oracle..."
428 dc:date="2007-04-18T19:04:09-06:00" />
433 <h2 class="date-header">April 18, 2007</h2>
435 <div class="entry" id="entry-632">
436 <h3 class="entry-header">Oracle limit clause</h3>
437 <div class="entry-content">
438 <div class="entry-body">
440 <li>Modify site almost functionally complete</li>
442 <li>Looking into how to do what MySQL does with it's limit clause in Oracle</li>
445 <p class="entry-more-link">
446 <a href="http://defaria.com/blogs/Status/archives/000632.html#more">Continue reading "Oracle limit clause" »</a>
449 <p class="entry-footer">
450 <span class="post-footers">Posted by at 7:04 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000632.html">Permalink</a>
452 | <a href="http://defaria.com/blogs/Status/archives/000632.html#trackback">TrackBacks (0)</a>
459 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
460 xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
461 xmlns:dc="http://purl.org/dc/elements/1.1/">
463 rdf:about="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000626"
464 trackback:ping="http://defaria.com/mt/mt-tb.cgi/15"
465 dc:title="GPDB Login"
466 dc:identifier="http://defaria.com/blogs/Status/archives/cat_gpdb.html#entry-000626"
468 dc:description=" Started implementing a login facility for GPDB..."
470 dc:date="2007-03-26T16:57:06-06:00" />
475 <h2 class="date-header">March 26, 2007</h2>
477 <div class="entry" id="entry-626">
478 <h3 class="entry-header">GPDB Login</h3>
479 <div class="entry-content">
480 <div class="entry-body">
482 <li>Started implementing a login facility for GPDB</li>
485 <p class="entry-more-link">
486 <a href="http://defaria.com/blogs/Status/archives/000626.html#more">Continue reading "GPDB Login" »</a>
489 <p class="entry-footer">
490 <span class="post-footers">Posted by at 4:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000626.html">Permalink</a>
492 | <a href="http://defaria.com/blogs/Status/archives/000626.html#trackback">TrackBacks (0)</a>
500 <h2 class="date-header">January 18, 2007</h2>
502 <div class="entry" id="entry-612">
503 <h3 class="entry-header">VOB UUIDs</h3>
504 <div class="entry-content">
505 <div class="entry-body">
507 <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>
510 <p class="entry-footer">
511 <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>
521 <h2 class="date-header">January 5, 2007</h2>
523 <div class="entry" id="entry-609">
524 <h3 class="entry-header">Checkpoint</h3>
525 <div class="entry-content">
526 <div class="entry-body">
528 <li>Checked in recent changes to GPDB and its associated scripts</li>
531 <p class="entry-more-link">
532 <a href="http://defaria.com/blogs/Status/archives/000609.html#more">Continue reading "Checkpoint" »</a>
535 <p class="entry-footer">
536 <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>
548 <div class="entry" id="entry-607">
549 <h3 class="entry-header">Nice is not so "nice"</h3>
550 <div class="entry-content">
551 <div class="entry-body">
553 <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>
556 <p class="entry-more-link">
557 <a href="http://defaria.com/blogs/Status/archives/000607.html#more">Continue reading "Nice is not so "nice"" »</a>
560 <p class="entry-footer">
561 <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>
571 <h2 class="date-header">January 4, 2007</h2>
573 <div class="entry" id="entry-605">
574 <h3 class="entry-header">gpdb_add_vob.pl</h3>
575 <div class="entry-content">
576 <div class="entry-body">
578 <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>
580 <li>Modified gpdb_add_vob.pl to traverse through all regions of current registry server to collect all vob tags</li>
582 <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>
584 <li>Investigated Victor's CC Metrics database</li>
586 <li>Fixed bug in gpdb_add_vob.pl that was adding clearcase records assigned to the wrong site.</li>
589 <p class="entry-footer">
590 <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>
600 <h2 class="date-header">January 3, 2007</h2>
602 <div class="entry" id="entry-606">
603 <h3 class="entry-header">Site Admins</h3>
604 <div class="entry-content">
605 <div class="entry-body">
607 <li>Changed gpdb_convertuk.pl to properly add mapping records for <i>Site Admins</i></li>
609 <li>Changed Single Site Display to display <i>Site Admins</i></li>
611 <li>Change Single Site Display to include all information from Excel design spreadsheet from Bill. Also tightened up display of cc_defaults</li>
613 <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>
616 <p class="entry-footer">
617 <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>
627 <h2 class="date-header">December 28, 2006</h2>
629 <div class="entry" id="entry-604">
630 <h3 class="entry-header">Mkcc.pm and mkvob</h3>
631 <div class="entry-content">
632 <div class="entry-body">
634 <li>Pulled out common code from mkview that will be needed for mkvob into Mkcc.pm Perl module</li>
636 <li>Re-engineered mkview to use Mkcc.pm</li>
638 <li>Started recoding mkvob to use GPDB and the new Mkcc.pm</li>
640 <li>Code complete on mkvob - need to test</li>
642 <li><b>Issue</b>: It seems that we have multiple versions of mkview_linked and that UK has continued development of their version of mkview_linked while we've been developing on mkview_linked here in Dallas. IOW there are two versions in separate vobs!</li>
645 <p class="entry-more-link">
646 <a href="http://defaria.com/blogs/Status/archives/000604.html#more">Continue reading "Mkcc.pm and mkvob" »</a>
649 <p class="entry-footer">
650 <span class="post-footers">Posted by at 4:50 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000604.html">Permalink</a>
660 <h2 class="date-header">December 27, 2006</h2>
662 <div class="entry" id="entry-603">
663 <h3 class="entry-header">Reworking GPDB tables, mkview</h3>
664 <div class="entry-content">
665 <div class="entry-body">
667 <li>Finished gpdb_add_project.pl with new table layout</li>
669 <li>With gpdb_getProjectsAtSite I can now return to mkview. Implemented new paging usage listing projects at the site</li>
671 <li>Finished coding of mkview such that it is now functional with GPDB and can make views</li>
674 <p class="entry-footer">
675 <span class="post-footers">Posted by at 4:46 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000603.html">Permalink</a>
685 <h2 class="date-header">December 19, 2006</h2>
687 <div class="entry" id="entry-602">
688 <h3 class="entry-header">GPDB Database performance</h3>
689 <div class="entry-content">
690 <div class="entry-body">
692 <li>Moved convertdb and gpdb_add_vob into Clearcase</li>
694 <li>Attempting to standardize which Perl to use, which Oracle.pm to pickup and how to insure that other sites have the proper prerequisites for GPDB</li>
696 <li>Discovered that Oracle is not supported on Linux here at TI. This will be a problem for GPDB</li>
698 <li>Still working on issues of the new GPDB design and attempting to get gpdb_add_project.pl to work with it</li>
700 <li>Got definition of performance problem that Donna is experiencing. She is attempting to populate a pull down with just the project names for a site. Doing so causes lots of transfer of data as the current GPDB API gpdb_getProject effectively transfers all kinds of project information where Donna needs only the project names.</li>
702 <li>Developed a new API, gpdb_getProjectsAtSite that returns only the project names in a more efficient manner</li>
705 <p class="entry-more-link">
706 <a href="http://defaria.com/blogs/Status/archives/000602.html#more">Continue reading "GPDB Database performance" »</a>
709 <p class="entry-footer">
710 <span class="post-footers">Posted by at 5:32 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000602.html">Permalink</a>
720 <h2 class="date-header">December 14, 2006</h2>
722 <div class="entry" id="entry-601">
723 <h3 class="entry-header">Users/Sites and Projects</h3>
724 <div class="entry-content">
725 <div class="entry-body">
727 <li>Implemented schema changes for GPDB based on previous meetings</li>
729 <li>Dropped PDB_ from table names to make them shorter and more understandable</li>
731 <li>Created all new tables and mapping tables. Adjusted sequencing</li>
733 <li>Changed users table to use AXID for key. Associated changes to other tables</li>
735 <li>Added synonyms where required</li>
737 <li>Updated drop_all.sql to reflected all new tables, views and sequences</li>
739 <li>Reorienting gpdb.pm for new database layout</li>
741 <li>Initially dropped the projects_by_site view as the new data structures handle this in a different way. Later added the view back this time gathering information from 3 different tables.</li>
743 <li>Got convertdb to be able to add users, sites and projects.</li>
745 <li>Got gpdb_add_vobs.pl working again in new structure</li>
747 <li>Started getting web pages to reveal data in new structures</li>
749 <li>Working on gpdb_add_project.pl to accommodate new schema layout</li>
751 <li>Changed gpdb_add_project.pl to use sites table instead of a sites file</li>
753 <li>Changed -s parm for gpdb_add_project.pl to instead specify a site to process - default being all sites</li>
756 <p class="entry-footer">
757 <span class="post-footers">Posted by at 3:48 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000601.html">Permalink</a>
767 <h2 class="date-header">December 1, 2006</h2>
769 <div class="entry" id="entry-600">
770 <h3 class="entry-header">GPDB Bug Fixed</h3>
771 <div class="entry-content">
772 <div class="entry-body">
774 <li>Fixed bug in domain_ranges.sql script</li>
776 <li>Finished Create site</li>
778 <li>Added replica_name field</li>
780 <li>Fixed naming error with snapto_dir and owning_group</li>
782 <li>Expanded size of snap_notify to 1024 bytes</li>
785 <p class="entry-footer">
786 <span class="post-footers">Posted by at 11:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000600.html">Permalink</a>
796 <h2 class="date-header">November 28, 2006</h2>
798 <div class="entry" id="entry-598">
799 <h3 class="entry-header">More GPDB fixes</h3>
800 <div class="entry-content">
801 <div class="entry-body">
803 <li>Added CSS class for input fields</li>
805 <li>Changed Project names to be drill down links</li>
807 <li>Fixed some bugs in add project. Now checking that project name and owning group are not blank</li>
809 <li>Added Port Ranges to Sites. As implemented it's just a text field with no real enforcement. I think the plan is to eventually augment the DesignSync creation script to check the port ranges from the GPDB Site table</li>
811 <li>Augmented Create Site to accommodate newly added fields. Still need to implement the handling of multiple domains per site. Should a check be implemented to insure that a domain name is not duplicated at any other site?</li>
813 <li>Implemented checking of IP Ranges to insure they are valid IP addresses and that the lower range is lower than the upper range. Still need to check that these ranges do not overlap any other IP ranges.</li>
815 <li>Changed several drop downs to properly sort the items. For example, user names are not sorted by at least first name, sites are sorted by site name, etc.</li>
818 <p class="entry-footer">
819 <span class="post-footers">Posted by at 8:44 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000598.html">Permalink</a>
829 <h2 class="date-header">November 27, 2006</h2>
831 <div class="entry" id="entry-594">
832 <h3 class="entry-header">More tables, fields and bug fixes</h3>
833 <div class="entry-content">
834 <div class="entry-body">
836 <li>Added PDB_ALIASES and PDB_MIRRORS to GPDB</li>
838 <li>Expanded VOB_TAG to accommodate larger VOB_TAGS</lI>
840 <li>Added more fields to PDB_SITES to hold login information that used to be kept in the gpdb_site_list.txt</li>
842 <li>Fixed bug with not displaying/updating phone number<li>
845 <p class="entry-footer">
846 <span class="post-footers">Posted by at 8:11 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000594.html">Permalink</a>
856 <h2 class="date-header">November 24, 2006</h2>
858 <div class="entry" id="entry-595">
859 <h3 class="entry-header">Added CSS to GPDB</h3>
860 <div class="entry-content">
861 <div class="entry-body">
863 <li>Added CSS to GPDB and re-oriented the web page to use them. This will allow us to control this much better</li>
865 <li>Changed sites page to handle <i>multiple domains per site</i></li>
868 <p class="entry-footer">
869 <span class="post-footers">Posted by at 8:16 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000595.html">Permalink</a>
879 <h2 class="date-header">November 21, 2006</h2>
881 <div class="entry" id="entry-597">
882 <h3 class="entry-header">gpdb_add_vob.pl/gpdb_add_project.pl</h3>
883 <div class="entry-content">
884 <div class="entry-body">
886 <li>Created gpdb_add_vob.pl. This script combs through the Clearcase registry and then adds the information to GPDB. It uses a heuristic to attempt to determine what project this vob is associated with. There are outstanding issues regarding ownership of DesignSync, Clearcase and Project objects.</li>
888 <li>Changed gpdb_add_project.pl to handle <i>multiple domains per site</i></li>
891 <p class="entry-footer">
892 <span class="post-footers">Posted by at 8:26 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000597.html">Permalink</a>
902 <h2 class="date-header">November 20, 2006</h2>
904 <div class="entry" id="entry-596">
905 <h3 class="entry-header">Multiple Domain's per site</h3>
906 <div class="entry-content">
907 <div class="entry-body">
909 <li>Added PDB_SITE_DOMAINS_MAP to GPDB. This is needed as a mapping table to allow multiple domains per site</li>
912 <p class="entry-footer">
913 <span class="post-footers">Posted by at 8:25 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000596.html">Permalink</a>
923 <h2 class="date-header">November 16, 2006</h2>
925 <div class="entry" id="entry-593">
926 <h3 class="entry-header">Sites again/Cron problems</h3>
927 <div class="entry-content">
928 <div class="entry-body">
930 <li>Met with Bill and Michael regarding changes to GPDB database. Michael believes we should stick with site codes and change convertdb to do the translation from UK site names to site codes</li>
932 <li>Spoke with Larry regarding site codes and he brought up the point that this would not work with the Embassy model and other external partnerships. As such we are back to site names...</li>
934 <li>Found that cron has a very limited PATH causing gpdb_add_project.pl to fail under cron</li>
937 <p class="entry-footer">
938 <span class="post-footers">Posted by at 8:58 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000593.html">Permalink</a>
948 <h2 class="date-header">November 14, 2006</h2>
950 <div class="entry" id="entry-592">
951 <h3 class="entry-header">gpdb_add_project cronned</h3>
952 <div class="entry-content">
953 <div class="entry-body">
955 <li>Looked into sites, site codes and differences between UK projects/domains and the current implementation of GPDB</li>
957 <li>Cronned gpdb_add_project</li>
960 <p class="entry-more-link">
961 <a href="http://defaria.com/blogs/Status/archives/000592.html#more">Continue reading "gpdb_add_project cronned" »</a>
964 <p class="entry-footer">
965 <span class="post-footers">Posted by at 10:58 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000592.html">Permalink</a>
975 <h2 class="date-header">November 7, 2006</h2>
977 <div class="entry" id="entry-590">
978 <h3 class="entry-header">UK -> GPDB</h3>
979 <div class="entry-content">
980 <div class="entry-body">
982 <li>Working on convertdb, a Perl script to read the UK database and convert it into GPDB</li>
984 <li>Finished code to convert users. Using de to get info about a user to populate the GPDB fields</li>
986 <li>Worked out problems with sites and got sites being added to GPDB from the UK database</li>
988 <li>Got adding of PDB_CLEARCASE records preliminarily done</li>
991 <p class="entry-more-link">
992 <a href="http://defaria.com/blogs/Status/archives/000590.html#more">Continue reading "UK -> GPDB" »</a>
995 <p class="entry-footer">
996 <span class="post-footers">Posted by at 12:29 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000590.html">Permalink</a>
1006 <h2 class="date-header">November 3, 2006</h2>
1007 <a id="a000589"></a>
1008 <div class="entry" id="entry-589">
1009 <h3 class="entry-header">Convertdb</h3>
1010 <div class="entry-content">
1011 <div class="entry-body">
1013 <li>Converted UK Users -> GPDB</li>
1015 <li>Converted UK Sites -> GPDB</li>
1018 <p class="entry-footer">
1019 <span class="post-footers">Posted by at 9:37 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000589.html">Permalink</a>
1029 <h2 class="date-header">October 25, 2006</h2>
1030 <a id="a000586"></a>
1031 <div class="entry" id="entry-586">
1032 <h3 class="entry-header">gpdb_add_projects.pl v1.1</h3>
1033 <div class="entry-content">
1034 <div class="entry-body">
1036 <li>Checked in new gpdb_add_project.pl</li>
1038 <li>Created cclic_report.pl and checked it into Clearcase</li>
1041 <p class="entry-more-link">
1042 <a href="http://defaria.com/blogs/Status/archives/000586.html#more">Continue reading "gpdb_add_projects.pl v1.1" »</a>
1045 <p class="entry-footer">
1046 <span class="post-footers">Posted by at 12:33 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000586.html">Permalink</a>
1056 <h2 class="date-header">October 24, 2006</h2>
1057 <a id="a000585"></a>
1058 <div class="entry" id="entry-585">
1059 <h3 class="entry-header">gpdb_add_project</h3>
1060 <div class="entry-content">
1061 <div class="entry-body">
1063 <li>Lots of re-writing of gpdb_add_project.pl to better handle error conditions</li>
1065 <li>Investigated DB structures some more</li>
1067 <li>Created cleardb.sql script to clear out the test db</li>
1070 <p class="entry-footer">
1071 <span class="post-footers">Posted by at 4:22 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000585.html">Permalink</a>
1081 <h2 class="date-header">October 19, 2006</h2>
1082 <a id="a000584"></a>
1083 <div class="entry" id="entry-584">
1084 <h3 class="entry-header">GPDB login</h3>
1085 <div class="entry-content">
1086 <div class="entry-body">
1088 <li>Changed several gpdb modules to support a db parameter for logging into an alternate database</li>
1090 <li>Changed gpdb-devel.pl to use new interface</li>
1093 <p class="entry-footer">
1094 <span class="post-footers">Posted by at 12:29 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000584.html">Permalink</a>
1104 <h2 class="date-header">October 18, 2006</h2>
1105 <a id="a000583"></a>
1106 <div class="entry" id="entry-583">
1107 <h3 class="entry-header">The Oracle speaks...</h3>
1108 <div class="entry-content">
1109 <div class="entry-body">
1111 <li>Learned about sqlplus and how to speak to Oracle databases from Victor</li>
1113 <li>Re-wrote the section about getting NIS data and managed to get gpdb_add_project to talk to Nice properly</li>
1115 <li>Checked in working version of gpdb_add_project and the Rexec.pm module</li>
1117 <li>Discovered that gpdb_add_project stumbles over some no longer existing machines in some DesignSync registries. Need to change this to send email</li>
1119 <li>Updated my rc scripts to include support for Oracle</li>
1121 <li>Working with Bill and Mike we determined that there is a test database for gpdb</li>
1123 <li>Determined how gpdb.pm opens the database in an effort to teach it how to connect to a test database. It's currently an all or nothing thing. This needs to change.</li>
1126 <p class="entry-footer">
1127 <span class="post-footers">Posted by at 7:31 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000583.html">Permalink</a>
1137 <h2 class="date-header">October 13, 2006</h2>
1138 <a id="a000581"></a>
1139 <div class="entry" id="entry-581">
1140 <h3 class="entry-header">gpdb_add_project.pl using gpdb user and Nice</h3>
1141 <div class="entry-content">
1142 <div class="entry-body">
1144 <li>Attempted to integrate Rexec into gpdb_add_project.pl and have it talk to Nice</li>
1146 <li>Looked into problem with Cygwin, Samba and ssh</li>
1149 <p class="entry-more-link">
1150 <a href="http://defaria.com/blogs/Status/archives/000581.html#more">Continue reading "gpdb_add_project.pl using gpdb user and Nice" »</a>
1153 <p class="entry-footer">
1154 <span class="post-footers">Posted by at 5:31 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000581.html">Permalink</a>
1164 <h2 class="date-header">October 10, 2006</h2>
1165 <a id="a000579"></a>
1166 <div class="entry" id="entry-579">
1167 <h3 class="entry-header">Improved gpdp_add_project</h3>
1168 <div class="entry-content">
1169 <div class="entry-body">
1171 <li>Checked in improved gpdb_add_project.pl script</li>
1173 <li> Started investigating Dave Smith's <i>Monthly Matrix</i></li>
1176 <p class="entry-more-link">
1177 <a href="http://defaria.com/blogs/Status/archives/000579.html#more">Continue reading "Improved gpdp_add_project" »</a>
1180 <p class="entry-footer">
1181 <span class="post-footers">Posted by at 3:50 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000579.html">Permalink</a>