Initial add of defaria.com
[clearscm.git] / defaria.com / blogs / Status / archives / 2004_09.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: September 2004 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/2004_08.html" title="August 2004" />
16    <link rel="next" href="http://defaria.com/blogs/Status/archives/2004_12.html" title="December 2004" />
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/2004_08.html">&laquo; August 2004</a> |
36                         <a href="http://defaria.com/blogs/Status/">Main</a>
37                         | <a href="http://defaria.com/blogs/Status/archives/2004_12.html">December 2004 &raquo;</a>
38                      </p>
39                      
40                      
41                      
42
43                      <h2 class="date-header">September 22, 2004</h2>
44                      <a id="a000251"></a>
45                      <div class="entry" id="entry-251">
46                         <h3 class="entry-header">gs.vbs/Backups</h3>
47                         <div class="entry-content">
48                            <div class="entry-body">
49                               <ul>
50
51 <li>Coded up gs.vbs, which will dump out the group heirarchy, whenever that arrives</li>
52
53 <li>Resolved the lockvobs.pl for backup issue - now working!</li>
54
55 <li>Spoke with server guy about new server's configuirations. Rtnlprod04 & 5 should be available by Monday!</li>
56
57 <li>Worked with Adam trying to get his login working</li>
58
59 </ul>
60                               
61                               <p class="entry-footer">
62                                  <span class="post-footers">Posted by  at  6:33 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000251.html">Permalink</a>
63                                  
64                                  
65                               </p>
66                            </div>
67                         </div>
68                      </div>
69                      
70                      
71
72                      <h2 class="date-header">September 21, 2004</h2>
73                      <a id="a000249"></a>
74                      <div class="entry" id="entry-249">
75                         <h3 class="entry-header">Group structure/View Server Problems</h3>
76                         <div class="entry-content">
77                            <div class="entry-body">
78                               <ul>
79
80 <li>Finished designing group structure - about to make AD requests</li>
81
82 <li><p>View server had a problem again. More and more it seems to be a problem with the NIC card on rtnlprod02. Managed to log into rtnlprod02 and look around. Couldn't see any processes at all in the TaskManager even though the 4 CPUs were 70-90% busy! Couldn't look at the Network tab - said there was no network adapter. Additionally the following appeared in the System event log:</p>
83
84 <pre>
85 Event Type:     Error
86 Event Source:   NIC Agents
87 Event Category: Service 
88 Event ID:       1285
89 Date:           9/21/2004
90 Time:           2:07:32 PM
91 User:           N/A
92 Computer:       RTNLPROD02
93 Description:
94 NIC Agent: Connectivity has been lost for the NIC in slot 0, port 1. [SNMP TRAP: 18006 in CPQNIC.MIB]
95 Data:
96 0000: 00 00 06 00 00 00 00 00   ........
97 0008: 01 00                     ..      
98 </pre>
99
100 </li>
101
102 </ul>
103                               
104                               <p class="entry-footer">
105                                  <span class="post-footers">Posted by  at  7:18 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000249.html">Permalink</a>
106                                  
107                                  
108                               </p>
109                            </div>
110                         </div>
111                      </div>
112                      
113                      
114
115                      <h2 class="date-header">September 20, 2004</h2>
116                      <a id="a000250"></a>
117                      <div class="entry" id="entry-250">
118                         <h3 class="entry-header">cmconfig.vbs</h3>
119                         <div class="entry-content">
120                            <div class="entry-body">
121                               <p>Held code review for cmconfig.vbs. Spent the rest of the day implementing changes. Some changes were minor while a few others were good catches of possible problems.</p>
122                               
123                               <p class="entry-footer">
124                                  <span class="post-footers">Posted by  at  7:19 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000250.html">Permalink</a>
125                                  
126                                  
127                               </p>
128                            </div>
129                         </div>
130                      </div>
131                      
132                      
133
134                      <h2 class="date-header">September 16, 2004</h2>
135                      <a id="a000248"></a>
136                      <div class="entry" id="entry-248">
137                         <h3 class="entry-header">Finished up populate_groups.vbs</h3>
138                         <div class="entry-content">
139                            <div class="entry-body">
140                               <ul>
141
142 <li>Investigated the group structure to document that is it not really heirarchical. We need to get it more tree like</li>
143
144 <li>Finished up coding populate_groups.vbs. Code now will walk the tree (that is when we get a tree!) and add users to the TOOLS database including their groups, gathered from walking the tree. If we do not have a tree to walk then the groups will be incomplete. Similarly if we tell populate_groups to populate from a node in the tree then only the groups in that node down will be gathered properly.</li>
145
146 </ul>
147                               
148                               <p class="entry-footer">
149                                  <span class="post-footers">Posted by  at  7:43 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000248.html">Permalink</a>
150                                  
151                                  
152                               </p>
153                            </div>
154                         </div>
155                      </div>
156                      
157                      
158
159                      <h2 class="date-header">September 15, 2004</h2>
160                      <a id="a000247"></a>
161                      <div class="entry" id="entry-247">
162                         <h3 class="entry-header">Populate users</h3>
163                         <div class="entry-content">
164                            <div class="entry-body">
165                               <ul>
166
167 <li>Worked mainly on a script to backfill and populate users into the TOOLS database</li>
168
169 <li>View server acted up again. Rebooted it but then it didn't come up!  Got the server guys involved and they booted it to the <i>Last Known Good Configuration</i>. This means that the Server Heap Size registry tweaks have been backed out. This also means that we'll probably have the view server having problems again soon. We need to schedule a maintainance period to reboot the view server with the proper registry tweaks. I can't imagine that that setting caused a problem with rebooting as it's the same setting as rtnlprod01 which is the same hardware. I looked at the event log a little bit and I think that rtnlprod02's problems may be a failing NIC card. I guess time will tell...</li>
170
171 </ul>
172                               
173                               <p class="entry-footer">
174                                  <span class="post-footers">Posted by  at  8:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000247.html">Permalink</a>
175                                  
176                                  
177                               </p>
178                            </div>
179                         </div>
180                      </div>
181                      
182                      
183
184                      <h2 class="date-header">September 14, 2004</h2>
185                      <a id="a000245"></a>
186                      <div class="entry" id="entry-245">
187                         <h3 class="entry-header">Code complete for cmconfig.vbs</h3>
188                         <div class="entry-content">
189                            <div class="entry-body">
190                               <p>Working mainly on cmconfig.vbs. Solution for the env problem was to set both the user environment and the process environment then call cmverfiy.cmd from cmconfig.vbs. The code now does the folowing:</p>
191
192 <ol>
193   <li>Configure Clearquest using installutil</li>
194
195   <li>Verify connection to Clearquest</li>
196
197   <li>Connect to the TOOLS database and verify that the user exists there</li>
198
199   <li>Verify the user is in the proper Clearcase Active Directory group</li>
200
201   <li>Set CLEARCASE_PRIMARY_GROUP and CLEARCASE_GROUPS properly for the user based on the users TOOLS record</li>
202
203   <li>Set the Clearcase region as per the user's TOOLS record</li>
204
205   <li>Configure user's Clearquest email settings</li>
206
207   <li>Add registry entry to execute PMO-CM.cmd</li>
208
209   <li>Add registry entry indicating the version of this script that was used</li>
210
211   <li>Update the following fields in the user's record in the TOOLS database:
212
213   <ul>
214      <li>machineName (set to hostname if machineName was blank or set to "My Computer" or "Unknown")</li>
215
216     <li>machineName2 (set to hostname if machineName was NOT blank or set to "My Computer" or "Unknown")</li>
217
218     <li>idAddedtoCC (if #4 succeeds)</li>
219
220     <li>isDeployed (if no other errors occur)</li>
221
222     <li>isAddedtoCQ (if #3 succeeds)</li>
223   </ul>
224
225   <li>Runs cmverify to verify that all is OK</li>
226 </ul>
227                               
228                               <p class="entry-footer">
229                                  <span class="post-footers">Posted by  at  6:01 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000245.html">Permalink</a>
230                                  
231                                  
232                               </p>
233                            </div>
234                         </div>
235                      </div>
236                      
237                      
238
239                      <h2 class="date-header">September 13, 2004</h2>
240                      <a id="a000246"></a>
241                      <div class="entry" id="entry-246">
242                         <h3 class="entry-header">Env var problems</h3>
243                         <div class="entry-content">
244                            <div class="entry-body">
245                               <p>There is a slight problem with the "set everything and verify it" script cmconfig.cmd. The idea was that that one script would perform 3 separate actions:</p>
246
247 <ol>
248   <li>Set up Clearquest configuration parameters (installutil)</li>
249
250   <li>Set up Clearcase configuration parameters (as per the logged in user) (setccconf.vbs)</li>
251
252   <li>Verify the installation (cmverify.cmd)</li>
253 </ol>
254
255 <p>The problem is with #2 being VBScript and #3 happening as a result of executing from the cmconfig.cmd script. While setccconf.vbs does indeed set the proper configuration environment variables as soon as it ends those settings are no longer set anymore by the evoking script only. All other (new) processes know about the change to the environment variables. To illustrate this odd phenomena:</p>
256
257 <div class="code">
258 <pre>
259 $ <u>type setenv_var.vbs</u>
260 Set sh  = WScript.CreateObject ("WScript.Shell")
261 Set env = sh.Environment ("USER")
262
263 env ("foo") = "bar"
264 $ <u>type senenv_var.cmd</u>
265 @echo off
266 set foo=bar
267 $ <u>echo foo = %foo%</u>
268 foo = %foo%
269 $ <u>cscript setenv_var.vbs</u>
270 $ <u>echo foo = %foo%</u>
271 foo = %foo%
272 $ <u>call setenv_var.cmd</u>
273 $ <u>echo foo = %foo%</u>
274 foo = bar
275 $ <u>cmd /c echo foo = %foo%</u>
276 foo = bar
277 </pre>
278 </div>
279
280 <p>Why it works for a .cmd script but not for a .vbs script I don't know.</p>
281
282 <p>So I will change cmconfig.cmd to do #1 and #2 above but skip #3. This means two things:</p>
283
284 <ol>
285   <li>Customers will have to run cmconfig.cmd first, then cmverify.cmd second</li>
286
287   <li>The running of cmverify.cmd must be done in a separate, new cmd session</li>
288 </ol>
289
290 <p>The reason for #2 is that even after cmconfig.cmd is run environment variables such as CLEARCASE_PRIMARY_GROUP and CLEARCASE_GROUPS will not have been "exported" into that cmd's environment (unless somebody can tell me how to set the parent's environment variables from VBScript...).</p>
291
292 <p>For the point and click crowd this should be OK. The email message you send the customer should have two links: one to cmconfig.cmd and one to cmverify.cmd. If the customer clicks the cmconfig.cmd link then cmconfig.cmd should run, in it's own process, and go away. Subsequently if the user clicks on cmverify.cmd that will run in it's own cmd process and it should pick up the appropriate environment variable settings.</p>
293
294 <p>There have been many requests for enhancements to the configuration scripts including updating the TOOLS database on successful verification and performing additional checks such as "is this user really in the AD group". I believe I will only be able to solve the above problem by having the setccconf.vbs script actually envoke the cmverify.cmd directly so that the environment variables that setccconf.vbs just set are exported into the cmverify.cmd's environment.</p>
295                               
296                               <p class="entry-footer">
297                                  <span class="post-footers">Posted by  at  6:07 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000246.html">Permalink</a>
298                                  
299                                  
300                               </p>
301                            </div>
302                         </div>
303                      </div>
304                      
305                      
306
307                      <h2 class="date-header">September  9, 2004</h2>
308                      <a id="a000244"></a>
309                      <div class="entry" id="entry-244">
310                         <h3 class="entry-header">Server Heap Size/Comment PINE code</h3>
311                         <div class="entry-content">
312                            <div class="entry-body">
313                               <ul>
314
315 <li>Investigated why the view server keeps needing a reboot. Found out that the server heap size was never increased. Fixed that.</li>
316
317 <li>Coded up a new trigger called COMMENT_PINE_CODE</li>
318
319 </ul>
320                               
321                               <p class="entry-footer">
322                                  <span class="post-footers">Posted by  at  5:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000244.html">Permalink</a>
323                                  
324                                  
325                               </p>
326                            </div>
327                         </div>
328                      </div>
329                      
330                      
331
332                      <h2 class="date-header">September  8, 2004</h2>
333                      <a id="a000243"></a>
334                      <div class="entry" id="entry-243">
335                         <h3 class="entry-header">Fixed corrupted SQL files for BUCS</h3>
336                         <div class="entry-content">
337                            <div class="entry-body">
338                               <ul>
339
340 <li>Fixed corrupted SQL files for BUCS</li>
341
342 </ul>
343                               
344                               <p class="entry-footer">
345                                  <span class="post-footers">Posted by  at  5:55 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000243.html">Permalink</a>
346                                  
347                                  
348                               </p>
349                            </div>
350                         </div>
351                      </div>
352                      
353                      
354
355                      <h2 class="date-header">September  2, 2004</h2>
356                      <a id="a000241"></a>
357                      <div class="entry" id="entry-241">
358                         <h3 class="entry-header">setccconf</h3>
359                         <div class="entry-content">
360                            <div class="entry-body">
361                               <p>Found that there are situations where one needs to have CLEARCASE_PRIMARY_GROUP set. Worked with Mike to implement groups in the TOOLS database. Spent a large part of today implementing setccconfig.vbs. This command will replace setregion and sets 3 things:</p>
362
363 <ul>
364
365 <li>Region</li>
366
367 <li>CLEARCASE_PRIMARY_GROUP</li>
368
369 <li>CLEARCASE_GROUPS (if required)</li>
370
371 </ul>
372
373 <p>In order to do this the username is used to retrieve information from the TOOLS database. If the username is found then we get the project record and obtain the region. Next we check CC Primary Group and CC Groups. These fields will not always be filled in (previous entries lacked them but future entries should have them filled in. We then set CLEARCASE_PRIMARY_GROUP and CLEARCASE_GROUPS if there are any.</p>
374
375 <p>CC Groups in the TOOLS database will contain all Clearcase groups that the user belongs to - including their Primary group.  In a lot of cases the user's CC Groups will be only one and equal to the Primary group. In that case CLEARCASE_GROUPS is not set. If the user is a member of more than one group then it will be their Primary group and additional groups in the CC Groups field. In that case Primary group is removed from that list and the rest are set into CLEARCASE_GROUPS.</p>
376                               
377                               <p class="entry-footer">
378                                  <span class="post-footers">Posted by  at  2:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000241.html">Permalink</a>
379                                  
380                                  
381                               </p>
382                            </div>
383                         </div>
384                      </div>
385                      
386                      
387
388                      <h2 class="date-header">September  1, 2004</h2>
389                      <a id="a000242"></a>
390                      <div class="entry" id="entry-242">
391                         <h3 class="entry-header">CLEARCASE_PRIMARY_GROUP</h3>
392                         <div class="entry-content">
393                            <div class="entry-body">
394                               <p>Worked on setccconf.vbs</p>
395                               
396                               <p class="entry-footer">
397                                  <span class="post-footers">Posted by  at  4:05 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000242.html">Permalink</a>
398                                  
399                                  
400                               </p>
401                            </div>
402                         </div>
403                      </div>
404                      
405                   </div>
406                </div>
407             </div>
408          </div>
409       </div>
410    </div>
411 </body>
412 </html>