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

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
  11
  12    <title>Status for Andrew DeFaria: May 2007 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/2007_04.html" title="April 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/2007_06.html" title="June 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/2007_04.html">&laquo; April 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/2007_06.html">June 2007 &raquo;</a>
  38                      </p>
  39
  40
  41                      <!--
  42 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  43          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  44          xmlns:dc="http://purl.org/dc/elements/1.1/">
  45 <rdf:Description
  46     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000643"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/31"
  48     dc:title="GPDB 2.0"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000643"
  50     dc:subject="GPDB"
  51     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..."
  52     dc:creator=""
  53     dc:date="2007-05-22T15:52:32-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">May 22, 2007</h2>
  59                      <a id="a000643"></a>
  60                      <div class="entry" id="entry-643">
  61                         <h3 class="entry-header">GPDB 2.0</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Sent email to Donna describing how to work with GPDB 2.0</li>
  66
  67   <li>Implemented Aliases</li>
  68
  69   <li>Changed project search to go off of new view for project aliases</li>
  70
  71   <li>Fixed bug in displaying of DesignSync information for projects</li>
  72 </ul>
  73
  74                               <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>
  75
  76 <p>Also (attached) is your syncGPDBAddDSProj.pl script ported to use GPDB 2.0.</p>
  77
  78 <h3>Alternate Database</h3>
  79
  80 <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>
  81
  82 <blockquote>
  83   <p><i>gpdb_login (username, password, db)</i></p>
  84
  85   <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>
  86 </blockquote>
  87
  88 <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>
  89
  90 <div class=code><pre>
  91 $ export GPDB_ACTIVE_DB=OracleDevelopment
  92 $ ./myscript.pl
  93 </pre></div>
  94
  95 <h3>Where to pick up the GPDB API</h3>
  96
  97 <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>
  98
  99 <div class=code><pre>
 100 # Standard CDOE modules (Modules of the month!)
 101 use lib "/apps/perl/modules-0609/lib";
 102
 103 # Perl/Oracle libraries
 104 use lib "/apps/oracle/perl/10.2.0.1.0/lib";
 105
 106 #use lib "/apps/cmpackages/perl/lib/site_perl/5.8.0";
 107 use lib "/web/gpdb/cgi-bin";
 108
 109 use GPDB::gpdb;
 110 </pre></div>
 111
 112 <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>
 113
 114 <h3>GPDB now authenticates to the enterprise LDAP</h3>
 115
 116 <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>
 117
 118 <h3>Did somebody ask for aliases?</h3>
 119
 120 <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
 121 Project</a>). Additionally the Project: Search screen will search for projects based on name and alias.</p>
 122
 123 <h3>Oracle/Linux issues</h3>
 124
 125 <p>We are still kinda of working out how to access Oracle on Linux through Perl.</p>
 126
 127 <h3>syncGPDBAddDSProj.pl script</h3>
 128
 129 <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>
 130
 131 <div class=code><pre>
 132 $ ./syncGPDBAddDSProj.pl -f Dallas -p 10000 -a &lt;userid&gt; -w &lt;password&gt; \
 133 &gt; -n andrew_defaria -g ASIC -c /tmp -s drteeth.dal.design.ti.com
 134 </pre></div>
 135
 136 <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>
 137
 138                               <p class="entry-footer">
 139                                  <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>
 140
 141                                  | <a href="http://defaria.com/blogs/Status/archives/000643.html#trackback">TrackBacks (0)</a>
 142                               </p>
 143                            </div>
 144                         </div>
 145                      </div>
 146
 147                      <!--
 148 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 149          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 150          xmlns:dc="http://purl.org/dc/elements/1.1/">
 151 <rdf:Description
 152     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000642"
 153     trackback:ping="http://defaria.com/mt/mt-tb.cgi/30"
 154     dc:title="CC Defaults report"
 155     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000642"
 156     dc:subject="GPDB"
 157     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..."
 158     dc:creator=""
 159     dc:date="2007-05-10T17:29:56-06:00" />
 160 </rdf:RDF>
 161 -->
 162
 163
 164                      <h2 class="date-header">May 10, 2007</h2>
 165                      <a id="a000642"></a>
 166                      <div class="entry" id="entry-642">
 167                         <h3 class="entry-header">CC Defaults report</h3>
 168                         <div class="entry-content">
 169                            <div class="entry-body">
 170                               <ul>
 171   <li>Added CC Defaults Report</li>
 172
 173   <li>Changed export to export as per the tableName</li>
 174
 175   <li>Changed export to export some files not listed on the web page</li>
 176 </ul>
 177
 178                               <p class="entry-footer">
 179                                  <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>
 180
 181                                  | <a href="http://defaria.com/blogs/Status/archives/000642.html#trackback">TrackBacks (0)</a>
 182                               </p>
 183                            </div>
 184                         </div>
 185                      </div>
 186
 187                      <!--
 188 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 189          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 190          xmlns:dc="http://purl.org/dc/elements/1.1/">
 191 <rdf:Description
 192     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000641"
 193     trackback:ping="http://defaria.com/mt/mt-tb.cgi/29"
 194     dc:title="GPDB Enhancements"
 195     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000641"
 196     dc:subject="GPDB"
 197     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..."
 198     dc:creator=""
 199     dc:date="2007-05-08T15:27:42-06:00" />
 200 </rdf:RDF>
 201 -->
 202
 203
 204                      <h2 class="date-header">May  8, 2007</h2>
 205                      <a id="a000641"></a>
 206                      <div class="entry" id="entry-641">
 207                         <h3 class="entry-header">GPDB Enhancements</h3>
 208                         <div class="entry-content">
 209                            <div class="entry-body">
 210                               <ul>
 211   <li>Added export to CSV file to reports</li>
 212
 213   <li>Made DesignSync servers links to the server:port</li>
 214
 215   <li>Added links to Project names Site names on reports</li>
 216
 217   <li>Added edit link to screen after you update a Project or Site</li>
 218 </ul>
 219
 220                               Nelson, Bill wrote:
 221 <blockquote type="cite">
 222 <p>I took a look at GPDB - looking better each day.  Looks like you have some links done in the reports</p>
 223 </blockquote>
 224
 225 <p>Yes I have...</p>
 226
 227 <blockquote type="cite">
 228 <p>still need a .CSV dump button.</p>
 229 </blockquote>
 230
 231 <p>Done!</p>
 232
 233 <blockquote type="cite">
 234 <p>When you display a page like the project@site one, I like the edit link up next to the Logout link but after I change something on the page and select Update, the link goes away.  Can you have it so that after the page is re-displayed, the Edit link remains?</p>
 235 </blockquote>
 236
 237 <p>Done.</p>
 238
 239 <blockquote type="cite">
 240 <p> For the list of Users, when you select the user ID you go to the Directory Services look up but we also wanted to have a single User Display where you saw the ORG-SBE, Sites, and Projects the user was associated with.</p>
 241 </blockquote>
 242
 243 <p>I need to make the users display screen. All that's in the Users record is pretty much what you see on the user list (BTW: The user list needs to be paged too as it's growing lengthy). So, IOW, I need to make a display that displays the info in the Users table as well as bring in
 244 the Org/SBE mapping table. Of course I also need to do the Org/SBE stuff too. Since I have nowhere to link to yet I have not made this link/association.</p>
 245
 246 <blockquote type="cite">
 247 <p>Maybe we could do this link off of the user’s name.</p>
 248 </blockquote>
 249
 250 <p>I'm not sure that that will not be confusing, at least at first, to users. When the see the user list they only see that both AXID and User Name are linked. They would not immediately think "Oh one links to one place and the other links to another place". How best to present this is, of course, the question...</p>
 251
 252 <blockquote type="cite">
 253 <p>When we display the DesignSync info, we were going to link the Server name to go to the ProjectSync address using the following format -&gt;http://&lt;server&gt;:&lt;DS Port&gt; so for the following we would have a link on Server of http://sync9136.design.ti.com:9136</p>
 254   <table class="MsoNormalTable" style="width: 592.5pt;" border="0"
 255  cellpadding="0" cellspacing="0" width="790">
 256     <tbody>
 257       <tr>
 258         <td colspan="7"
 259  style="border: 1pt solid black; padding: 2.25pt; background: rgb(0, 64, 128) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 260         <p class="MsoNormal" style="text-align: center;" align="center"><b><span
 261  style="font-family: Arial; color: white;">DesignSync Vault<o:p></o:p></span></b></p>
 262         </td>
 263       </tr>
 264       <tr>
 265         <td
 266  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 267         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 268  style="font-size: 10.5pt; font-family: Arial; color: white;">Site:<o:p></o:p></span></b></p>
 269         </td>
 270         <td
 271  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 272         <p class="MsoNormal" style="text-align: center;" align="center"><span
 273  style="font-size: 9pt; font-family: Arial; color: black;"><a
 274  moz-do-not-send="true"
 275  href="http://gpdb.design.ti.com/cgi-bin/gpdb-devel.pl?db=OracleDevelopment&amp;operation=showSite&amp;siteName=Bangalore"><span
 276  style="font-family: &quot;Times New Roman&quot;;">Bangalore</span></a><o:p></o:p></span></p>
 277         </td>
 278         <td
 279  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 280         <p class="MsoNormal" style="text-align: center;" align="center"><b><span
 281  style="font-size: 10.5pt; font-family: Arial; color: white;">DS<o:p></o:p></span></b></p>
 282         </td>
 283         <td
 284  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 285         <p class="MsoNormal" style="text-align: center;" align="center"><b><span
 286  style="font-size: 10.5pt; font-family: Arial; color: white;">PGS<o:p></o:p></span></b></p>
 287         </td>
 288         <td
 289  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 290         <p class="MsoNormal" style="text-align: center;" align="center"><b><span
 291  style="font-size: 10.5pt; font-family: Arial; color: white;">Secure<o:p></o:p></span></b></p>
 292         </td>
 293         <td
 294  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 295         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 296  style="font-size: 10.5pt; font-family: Arial; color: white;">HCM:<o:p></o:p></span></b></p>
 297         </td>
 298         <td
 299  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 300         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 301  style="font-size: 10.5pt; font-family: Arial; color: white;">Status:<o:p></o:p></span></b></p>
 302         </td>
 303       </tr>
 304       <tr>
 305         <td
 306  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 307         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 308  style="font-size: 10.5pt; font-family: Arial; color: white;">Server:<o:p></o:p></span></b></p>
 309         </td>
 310         <td
 311  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 312         <p class="MsoNormal"><span
 313  style="font-size: 9pt; font-family: Arial; color: black;"><a
 314  moz-do-not-send="true" href="http://sync9136.design.ti.com:9136/">sync9136.design.ti.com</a><o:p></o:p></span></p>
 315         </td>
 316         <td
 317  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 318         <p class="MsoNormal" style="text-align: center;" align="center"><span
 319  style="font-size: 9pt; font-family: Arial; color: black;">9136<o:p></o:p></span></p>
 320         </td>
 321         <td
 322  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 323         <p class="MsoNormal" style="text-align: center;" align="center"><span
 324  style="font-size: 9pt; font-family: Arial; color: black;">9137<o:p></o:p></span></p>
 325         </td>
 326         <td
 327  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 328         <p class="MsoNormal" style="text-align: center;" align="center"><span
 329  style="font-size: 9pt; font-family: Arial; color: black;">9138<o:p></o:p></span></p>
 330         </td>
 331         <td
 332  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 333         <p class="MsoNormal" style="text-align: center;" align="center"><span
 334  style="font-size: 9pt; font-family: Arial; color: black;">N<o:p></o:p></span></p>
 335         </td>
 336         <td
 337  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 338         <p class="MsoNormal" style="text-align: center;" align="center"><span
 339  style="font-size: 9pt; font-family: Arial; color: black;">Active<o:p></o:p></span></p>
 340         </td>
 341       </tr>
 342       <tr>
 343         <td
 344  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 345         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 346  style="font-size: 10.5pt; font-family: Arial; color: white;">Path:<o:p></o:p></span></b></p>
 347         </td>
 348         <td colspan="6"
 349  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 350         <p class="MsoNormal"><b><span
 351  style="font-size: 9pt; font-family: Arial; color: black;">/data/sitd_vault/sync9136.design.ti.com/9136/server_vault</span></b><span
 352  style="font-size: 9pt; font-family: Arial; color: black;"><o:p></o:p></span></p>
 353         </td>
 354       </tr>
 355       <tr>
 356         <td
 357  style="border: 1pt solid black; padding: 2.25pt; background: rgb(32, 136, 221) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 358         <p class="MsoNormal" style="text-align: right;" align="right"><b><span
 359  style="font-size: 10.5pt; font-family: Arial; color: white;">Cache:<o:p></o:p></span></b></p>
 360         </td>
 361         <td colspan="6"
 362  style="border: 1pt solid rgb(153, 153, 153); padding: 2.25pt; background: rgb(255, 254, 238) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
 363         <p class="MsoNormal"><span
 364  style="font-size: 9pt; font-family: Arial; color: black;">/data/sitd_cache/sync9136.design.ti.com/9136/server_cache<o:p></o:p></span></p>
 365         </td>
 366       </tr>
 367     </tbody>
 368   </table>
 369   </div>
 370 </blockquote>
 371
 372 <p>Done, although I don't know how to log into such sites. I'm asked for my username and password. I use my normal username and enterprise password and I get access denied for this "projectsync" login. Now normally I'd ask one of the DesignSync guys around here but they all
 373 appear to be missing! <span class="moz-smiley-s3"><span> ;-) </span></span></p>
 374
 375 <p>Oh, BTW, I added this link to the <a href="http://gpdb.design.ti.com/cgi-bin/gpdb-devel.pl?db=OracleDevelopment&amp;operation=reportDesignSync">DesignSync
 376 Report</a>, though many of them seem to not be set up or responding.</p>
 377
 378                               <p class="entry-footer">
 379                                  <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>
 380
 381                                  | <a href="http://defaria.com/blogs/Status/archives/000641.html#trackback">TrackBacks (0)</a>
 382                               </p>
 383                            </div>
 384                         </div>
 385                      </div>
 386
 387                      <!--
 388 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 389          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 390          xmlns:dc="http://purl.org/dc/elements/1.1/">
 391 <rdf:Description
 392     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000640"
 393     trackback:ping="http://defaria.com/mt/mt-tb.cgi/28"
 394     dc:title="LDAP changes/Synonyms and Grants/Reports"
 395     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000640"
 396     dc:subject="GPDB"
 397     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..."
 398     dc:creator=""
 399     dc:date="2007-05-04T14:35:52-06:00" />
 400 </rdf:RDF>
 401 -->
 402
 403
 404                      <h2 class="date-header">May  4, 2007</h2>
 405                      <a id="a000640"></a>
 406                      <div class="entry" id="entry-640">
 407                         <h3 class="entry-header">LDAP changes/Synonyms and Grants/Reports</h3>
 408                         <div class="entry-content">
 409                            <div class="entry-body">
 410                               <ul>
 411   <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>
 412
 413   <li>Straightened out new views WRT Synonyms and Grants</li>
 414
 415   <li>Implemented Users, Clearcase and DesignSync reports</li>
 416 </ul>
 417
 418                               <h2>Synonyms and Grants</h2>
 419
 420 <p>When one creates a table or view in Oracle it appears to be "private" to the user who has created it. Others can get to the table but they need to specify a more qualified name. Additionally the need to have been granted access to it (at least select access).</p>
 421
 422 <p>So if we create a view, say foo, we also need to grant select access to those tables to the other users who might be using it. Additionally, in GPDB we have 3 DB level usernames: cm_gpdb, cm_gpdb_readonly and cm_gpdb_update. So if we create the view foo while logged in as cm_gpdb then login as say cm_gpdb_readonly, this new session will not be able to see foo.</p>
 423
 424 <p>So then the sequence is:</p>
 425
 426 <ol>
 427   <li>Create the table or view</li>
 428
 429 <div class=code><pre>
 430 create or replace view foo ...
 431 </pre></div>
 432
 433   <li>Grant select privileges to the table or view:</li>
 434
 435 <div class=code><pre>
 436 grant select to foo on cm_gpdb.foo for cm_gpdb_readonly
 437 </pre></div>
 438
 439   <li>Log into Oracle database as other user and create synonym:</li>
 440
 441 <div class=code><pre>
 442 create or replace synonym foo for cm_gpdb.foo
 443 </pre></div>
 444 </ol>
 445
 446 <h4>Notes</h4>
 447
 448 <ol>
 449   <li>The database's schema name for GPDB is cm_gpdb above</li>
 450
 451   <li>Grants need to be done whenever the table or view is recreated. Synonyms, being pointers, need to be created only when a new pointer is needed</li>
 452 </ol>
 453
 454                               <p class="entry-footer">
 455                                  <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>
 456
 457                                  | <a href="http://defaria.com/blogs/Status/archives/000640.html#trackback">TrackBacks (0)</a>
 458                               </p>
 459                            </div>
 460                         </div>
 461                      </div>
 462
 463                      <!--
 464 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 465          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 466          xmlns:dc="http://purl.org/dc/elements/1.1/">
 467 <rdf:Description
 468     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000639"
 469     trackback:ping="http://defaria.com/mt/mt-tb.cgi/27"
 470     dc:title="GPDB/LDAP/Org/SBE"
 471     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000639"
 472     dc:subject="GPDB"
 473     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..."
 474     dc:creator=""
 475     dc:date="2007-05-03T18:45:32-06:00" />
 476 </rdf:RDF>
 477 -->
 478
 479
 480                      <h2 class="date-header">May  3, 2007</h2>
 481                      <a id="a000639"></a>
 482                      <div class="entry" id="entry-639">
 483                         <h3 class="entry-header">GPDB/LDAP/Org/SBE</h3>
 484                         <div class="entry-content">
 485                            <div class="entry-body">
 486                               <ul>
 487   <li>Added Org/SBE drop down to edit Project</li>
 488
 489   <li>Integrated LDAP!</li>
 490
 491   <li>Changed primitive.pm to authenticate with LDAP!</p>
 492
 493   <li>Added description to Org/SBE and removed password</li>
 494
 495   <li>Added edit links to showProject and showSite</li>
 496 </ul>
 497
 498                               <p class="entry-footer">
 499                                  <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>
 500
 501                                  | <a href="http://defaria.com/blogs/Status/archives/000639.html#trackback">TrackBacks (0)</a>
 502                               </p>
 503                            </div>
 504                         </div>
 505                      </div>
 506
 507                      <!--
 508 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 509          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 510          xmlns:dc="http://purl.org/dc/elements/1.1/">
 511 <rdf:Description
 512     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000638"
 513     trackback:ping="http://defaria.com/mt/mt-tb.cgi/26"
 514     dc:title="GPDB (Org/SBE and others)"
 515     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000638"
 516     dc:subject="GPDB"
 517     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..."
 518     dc:creator=""
 519     dc:date="2007-05-03T09:46:24-06:00" />
 520 </rdf:RDF>
 521 -->
 522
 523
 524
 525                      <a id="a000638"></a>
 526                      <div class="entry" id="entry-638">
 527                         <h3 class="entry-header">GPDB (Org/SBE and others)</h3>
 528                         <div class="entry-content">
 529                            <div class="entry-body">
 530                               <ul>
 531   <li>Changed org_sbe.name to link up with parent_project</li>
 532
 533   <li>Created org_sbe.sql to add org_sbe entries</li>
 534
 535   <li>Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm</li>
 536
 537   <li>Added Org/SBE menu</li>
 538
 539   <li>Changed various new tables to to be uniform in width</li>
 540
 541   <li>Fixed a few bugs regarding adding of sites where no site domains are added</li>
 542
 543   <li>Added much of Update Project</li>
 544
 545   <li>Fixed bug with update CCDefaults for Projects</li>
 546
 547   <li>Added screen for adding CCDefaults when adding a project</li>
 548 </ul>
 549
 550                               <p class="entry-footer">
 551                                  <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>
 552
 553                                  | <a href="http://defaria.com/blogs/Status/archives/000638.html#trackback">TrackBacks (0)</a>
 554                               </p>
 555                            </div>
 556                         </div>
 557                      </div>
 558
 559                      <!--
 560 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 561          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 562          xmlns:dc="http://purl.org/dc/elements/1.1/">
 563 <rdf:Description
 564     rdf:about="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000637"
 565     trackback:ping="http://defaria.com/mt/mt-tb.cgi/25"
 566     dc:title="GPDB Enhancements/Fixes"
 567     dc:identifier="http://defaria.com/blogs/Status/archives/2007_05.html#entry-000637"
 568     dc:subject="GPDB"
 569     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,..."
 570     dc:creator=""
 571     dc:date="2007-05-01T19:25:50-06:00" />
 572 </rdf:RDF>
 573 -->
 574
 575
 576                      <h2 class="date-header">May  1, 2007</h2>
 577                      <a id="a000637"></a>
 578                      <div class="entry" id="entry-637">
 579                         <h3 class="entry-header">GPDB Enhancements/Fixes</h3>
 580                         <div class="entry-content">
 581                            <div class="entry-body">
 582                               <h3>GPDB Login</h3>
 583
 584 <ul>
 585   <li>Moved to the top.</li>
 586   <li>Changed wording to be more friendly</li>
 587   <li>Login with unknown username puts up a warning but grants read
 588 only access</li>
 589   <li>Login with known username but wrong password is properly denoted</li>
 590 </ul>
 591
 592 <h3>Other changes</h3>
 593
 594 <ul>
 595   <li>In Project display, site defaults are not listed on top of the
 596 Project defaults.</li>
 597
 598   <li>Change width of tables to line up with the menus across the top.</li>
 599
 600   <li>Updating of project CC defaults still not working correctly</li>
 601
 602   <li>Added Add Project</li>
 603 </ul>
 604
 605
 606                               <p class="entry-footer">
 607                                  <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>
 608
 609                                  | <a href="http://defaria.com/blogs/Status/archives/000637.html#trackback">TrackBacks (0)</a>
 610                               </p>
 611                            </div>
 612                         </div>
 613                      </div>
 614
 615                   </div>
 616                </div>
 617             </div>
 618          </div>
 619       </div>
 620    </div>
 621 </body>
 622 </html>