defaria.com/blogs/Status/archives/week_2003_11_16.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: November 16, 2003 - November 22, 2003 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/week_2003_11_09.html" title="November  9, 2003 - November 15, 2003" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2003_11_23.html" title="November 23, 2003 - November 29, 2003" />
  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/week_2003_11_09.html">&laquo; November  9, 2003 - November 15, 2003</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2003_11_23.html">November 23, 2003 - November 29, 2003 &raquo;</a>
  38                      </p>
  39
  40
  41
  42
  43                      <h2 class="date-header">November 21, 2003</h2>
  44                      <a id="a000040"></a>
  45                      <div class="entry" id="entry-40">
  46                         <h3 class="entry-header">More sam4linux and 2.2.1.4</h3>
  47                         <div class="entry-content">
  48                            <div class="entry-body">
  49                               <ol>
  50 <li>Set up and built 2.2.1.4</li>
  51 <li>Got a little further on sam4linux (see extended entry)</li>
  52 <li>Still battling with Samba 3.0</li>
  53 </ol>
  54
  55                               <p>I have downloaded the sam4linux tarbar and have been attempting to get it running on sonslinux (running Mandrake 9.1). I unpacked the tgz file into /opt and tried running sam-startnms.sh. I was prompted for the license file and attempted to use the license file but it didn't work. The licenses have expired.
  56
  57 <p>Slight note here: I was not at all apparent to me that the sam-startnms.sh, sam-setEnv.sh, sam-startAppicationClient.sh scripts that were sitting along side the sam_linux.tgz file are useless. It was only later that I figured out that those scripts also appear under /opt/AdventNet/WebNMS/bin and that those scripts were the ones I should be using.
  58
  59 <p>Next I downloaded AdventNet_WebNMS again and applied for a evaluation license. This time when running NMS I entered the new license file and it accepted it. But, unfortunately it quickly died with:
  60
  61 <pre>java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@127.0.0.1' (Using password: NO)
  62         at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
  63         at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
  64         at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
  65         at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
  66         at java.sql.DriverManager.getConnection(DriverManager.java:517)
  67         at java.sql.DriverManager.getConnection(DriverManager.java:177)
  68         at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:145)
  69         at jdbc.CreateSchema.init(CreateSchema.java:83)
  70         at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
  71         at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
  72         at java.lang.Thread.run(Thread.java:484)
  73 Exiting Web NMS
  74 </pre>
  75 <p>Analyzing... I have had MySQL installed and up and running for quite some time. The installation instructions said to create a database for WebNMS by:
  76
  77 <pre>
  78 # mysqladmin create WebNMSdb
  79 </pre>
  80
  81 <p>which I did. However after reinstalling AdventNet_WebNMS I noticed that it created a database of WebNmsDB (note capitalization is generally important in the Linux world). So I had dropped WebNMSdb in favor of the DB that AdventNet_WebNMS created. Still above it seems that it was unable to connect to the database. I tried:
  82
  83 <pre>
  84 mysql> grant all privileges on WebNmsDB.* to root;
  85 </pre>
  86
  87 and
  88 <pre>
  89 mysql> grant all privileges on WebNmsDB.* to root@127.0.0.1;
  90 </pre>
  91
  92 <p>but I keep getting the same error. I suspect I need to supply a password but I'm not sure how to do that.
  93
  94 <p>Ah ha! The problem seems to be that I assigned a password to the user root for MySQL. Removing that caused more output...
  95 <pre>
  96 Created table ObjectTypes
  97 Created table ManagedObject
  98 Created table MapContainer
  99 Created table TopoObject
 100 Created table Node
 101 Created table Network
 102 Created table IpAddress
 103 Created table SnmpNode
 104 Created table SnmpInterface
 105 Created table TL1Node
 106 Created table TL1Interface
 107 Created table TOPOUSERPROPS
 108 Created table ALERTUSERPROPS
 109 Created table EVENTUSERPROPS
 110 Created table USERTABLE
 111 Created table HOSTS
 112 Created table PORTS
 113 Created table ENGINES
 114 Created table USERS
 115 Created table POLLUSERPROPS
 116 Created table ANNOTATION
 117 Created table Alert
 118 Created table MapDB
 119 Created table MapSymbol
 120 Created table MapLink
 121 Created table MAPUSERPROPS
 122 Created table Event
 123 Created table PolledData
 124 Created table ALERTLOGGER
 125 Created table EVENTLOGGER
 126 Created table CUSTOMMAPS
 127 Created table DBINTERFACES
 128 Created table DEFAULTMAPS
 129 Created table TrapDisabledMO
 130 Created table CHILDRENSTATUS
 131 Created table CUSTOMPROPS
 132 Created table OBJECTSTOLINK
 133 Created table TOPODBSPECIALKEY
 134 Created table DBMAP
 135 Created table DBEVENT
 136 Created table DBALERT
 137 Created table DBPOLL
 138 Created table ObjectSchedulerRUNNABLE
 139 Created table MapGroup
 140 Created table ManagedGroupObject
 141 Created table GroupTable
 142 Created table TaskAudit
 143 Created table DeviceAudit
 144 Created table AttributeAudit
 145 Created table ConfigTasks
 146 Created table ConfigTaskDetails
 147 Created table ConfigAttributes
 148 Created table PendingTasks
 149 Created table PendingDevices
 150 Created table DeviceList
 151 Created table DeviceListDetails
 152 Created table DeviceUserProps
 153 Created table TaskToDeviceListMap
 154 Created table PollingObjects
 155 Created table ConfigProvider
 156 Created table PollingAttributes
 157 Created table Providers
 158 Created table StatsTables
 159 Created table ThresholdObjects
 160 Created table CustomView
 161 Created table CustomViewProps
 162 Created table CustomViewColumns
 163 Created table PanelTree
 164 Created table PanelProps
 165 Created table PollFilters
 166 Created table GenericFaultTable
 167 Created table TrapFilter
 168 Created table TrapEventParser
 169 Created table EventAlertFilter
 170 Created table Reports
 171 Created table DataCollectionAttributes
 172 Created table UserPasswordTable
 173 Created table UserGroupTable
 174 Created table ViewPropertiesTable
 175 Created table ViewsToGroupTable
 176 Created table ViewToOperationsTable
 177 Created table OperationsTreeTable
 178 Created table NamedViewToAuthorizedViewTable
 179 Created table AuthAudit
 180 Created table NotificationLog
 181 Created table VarBindLog
 182 Created table AgentDefValObject
 183 Created table PolicyObject
 184 Created table PolicyActionCondition
 185 Created table POLICYUSERPROPS
 186 Created table DBPOLICY
 187 Created table PolicyScheduleTime
 188 Created table AlertPolicyObject
 189 Created table ENGINETABLE
 190 Exception in creating table
 191 Statement being executed was :create table USMTABLE(  DBKEY  varchar(116) NOT NULL,  HOST  varchar(50),  PORT  varchar(5),  ENGINENAME  varchar(50),  ENGINEID  varchar(64),  USERNAME  varchar(50),  SECURITYLEVEL  varchar(5),  SECURITYNAME  varchar(50),  AUTHPROTOCOL  varchar(10),  AUTHPASSWORD  varchar(50),  AUTHKEY  varchar(40),  PRIVPROTOCOL  varchar(10),  PRIVPASSWORD  varchar(50),  PRIVKEY  varchar(32),  ENGINETIME  varchar(10),  ENGINEBOOTS  varchar(10),  LATESTRCVDENGTIME  varchar(10),  LOCALTIME  varchar(30), PRIMARY KEY ( DBKEY ))
 192 syntax error or access violation: you have an error in your sql syntax.  check the manual that corresponds to your mysql server version for the right syntax to use near 'localtime  varchar(30), primary key ( dbkey ))' at line 1
 193 java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCALTIME  varchar(30), PRIMARY KEY ( DBKEY ))' at line 1
 194         at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
 195         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
 196         at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
 197         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
 198         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
 199         at org.gjt.mm.mysql.Statement.execute(Statement.java:595)
 200         at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
 201         at jdbc.CreateSchema.createTables(CreateSchema.java:352)
 202         at jdbc.CreateSchema.init(CreateSchema.java:85)
 203         at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
 204         at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
 205         at java.lang.Thread.run(Thread.java:484)
 206 Created table SwitchObject
 207 Created table PortObject
 208 Created table Printer
 209 Created table OperationsTable
 210 Created table BEFailOver
 211 Created table PollIDToKeyMap
 212 Created table ProvisioningVariantProps
 213 Created table ProvisioningVariant
 214 Created table UserConfTable
 215 Created table CORBANode
 216 Created table NetworkInventory
 217 Created table SonsAuditLogTable
 218 Created table SonsHistoryAlert
 219 Created table SonsTopologyObjectImpl
 220 Created table SonsPort
 221 Created table SonsDS1Port
 222 Created table SonsDS3Port
 223 Created table SonsEtherPort
 224 Created table SonsONUModule
 225 Created table SonsShelf
 226 Created table SonsSlot
 227 Created table SonsCrossConnect
 228 Created table SonsOLT
 229 Created table SonsONU
 230 Created table SonsPonInfo
 231 Created table SonsPonPort
 232 Created table SonsSonetPath
 233 Created table SonsSTM1Port
 234 Created table SonsSonetVT
 235 Created table SonsDs0Port
 236 Created table SonsDs0Bundle
 237 Created table SonsXConn
 238 Created table SonsCard
 239 Created table SonsVDSLPort
 240 Created table SonsVDSLRateRefer
 241 Created table SonsVDSLTermInfo
 242 Created table SonsMaintCmdRecord
 243 Created table SonsQosBy8021p
 244 Created table SonsVLanSwitchPort
 245 Created table SonsQosByDscp
 246 Created table SonsQosByPhyPort
 247 Created table SonsQosByTos
 248 Created table SonsQosByVLan
 249 Created table SonsService
 250 Created table SonsVLan
 251 Created table SonsVLanBridgeParam
 252 Created table SonsVLanMemberShip
 253 Created table SonsSubscriber
 254 Created table SonsVLanFDB
 255 Created table SonsServiceObject
 256 Created table SonsSTPDomain
 257 Created table SonsSTPPort
 258 Created table SonsActiveACL
 259 Created table SonsCommonACE
 260 Created table SonsCommonACL
 261 All The Tables were not created properly.
 262 Exiting Web NMS
 263 </pre>
 264
 265 <p>For the record I have:
 266 <pre>
 267 mysqladmin -V
 268 mysqladmin  Ver 8.40 Distrib 4.0.10-gamma, for mandrake-linux-gnu on i586
 269 </pre>
 270
 271                               <p class="entry-footer">
 272                                  <span class="post-footers">Posted by  at  5:30 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000040.html">Permalink</a>
 273
 274
 275                               </p>
 276                            </div>
 277                         </div>
 278                      </div>
 279
 280
 281
 282                      <h2 class="date-header">November 20, 2003</h2>
 283                      <a id="a000039"></a>
 284                      <div class="entry" id="entry-39">
 285                         <h3 class="entry-header">2.2.1.3/sam4linux/2.2->2.3</h3>
 286                         <div class="entry-content">
 287                            <div class="entry-body">
 288                               <ol>
 289 <li>Resolved Dylan's problem</li>
 290 <li>Built 2.2.1.3</li>
 291 <li>Resolved 2.3 merge issue</li>
 292 <li>Merged 2.2 -> 2.3</li>
 293 <li>Downloaded sam4linux</li>
 294 </ol>
 295
 296                               <p>Our code is not case sensistive. This problem exhibits it's ugly head a lot in sam4linux BTW. In Dylan's case an include of cli_enumStruct.c was being done but the file is named cli_enumstruct.c. Now on most Windows Clearcase installations I had set MVFS to be case insensitive but on Dylan's machine he had it set case sensitive.
 297
 298 <p>Sam4linux is not all that operational yet. Initial problem is that the license is expired.
 299
 300                               <p class="entry-footer">
 301                                  <span class="post-footers">Posted by  at  4:55 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000039.html">Permalink</a>
 302
 303
 304                               </p>
 305                            </div>
 306                         </div>
 307                      </div>
 308
 309
 310
 311                      <h2 class="date-header">November 19, 2003</h2>
 312                      <a id="a000037"></a>
 313                      <div class="entry" id="entry-37">
 314                         <h3 class="entry-header">Merging 2.2 -> 2.3 & 2.4</h3>
 315                         <div class="entry-content">
 316                            <div class="entry-body">
 317                               <ol>
 318 <li>Added automatic merging for 2.2 -> 2.3 & 2.4</li>
 319 <li>Performed initial 2.2 -> 2.3 merge. Had some problems</li>
 320 <li>Banged my head trying to get Samba 3 to work on sonlinux</li>
 321 <li>Assisted James installing some packages on sonslinux</li>
 322 </li>
 323
 324                               <p>Dylan discussed with me that we should be merging fixes forward from 2.2 -> 2.3 and from 2.2 -> 2.4. Eventually we will need to merge 2.2 -> 2.3 -> 2.4 but doing so now might cause problems with the 2.3 -> 2.4 merge. I guess 2.3 is in a little bit of flux right now.
 325
 326 <p>Discussed this with Jeff and he agreed. The merging schedule for this is set to weekly. 2.2 -> 2.3 merging happens on Sunday (at 5:30 Am in Santa Clara and 9:30 Pm (Sunday night) in Shanghai - roughly the same time given the timezone difference). The 2.2 ->2 4 merge happens on Tuesdays @ 5:30 Am Santa Clara and 9:30 Pm Shanghai time.
 327
 328                               <p class="entry-footer">
 329                                  <span class="post-footers">Posted by  at  6:12 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000037.html">Permalink</a>
 330
 331
 332                               </p>
 333                            </div>
 334                         </div>
 335                      </div>
 336
 337
 338
 339                      <h2 class="date-header">November 18, 2003</h2>
 340                      <a id="a000035"></a>
 341                      <div class="entry" id="entry-35">
 342                         <h3 class="entry-header">Coordinating merging</h3>
 343                         <div class="entry-content">
 344                            <div class="entry-body">
 345                               <ol>
 346 <li>At the advice of Ying I have changed the ctmerge times so that they occur after China has left the office. This will better coordinate work on 2.3</li>
 347 <li>Set up 2.2.1.3 bug list</li>
 348 </ol>
 349
 350                               <p class="entry-footer">
 351                                  <span class="post-footers">Posted by  at  1:00 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000035.html">Permalink</a>
 352
 353
 354                               </p>
 355                            </div>
 356                         </div>
 357                      </div>
 358
 359
 360
 361                      <h2 class="date-header">November 17, 2003</h2>
 362                      <a id="a000033"></a>
 363                      <div class="entry" id="entry-33">
 364                         <h3 class="entry-header">Test plans</h3>
 365                         <div class="entry-content">
 366                            <div class="entry-body">
 367                               <ol>
 368 <li>Looked at some of the test plans</li>
 369 <li>Helped Dylan and Ying on some Clearcase issues</li>
 370 </ol>
 371
 372                               <p class="entry-footer">
 373                                  <span class="post-footers">Posted by  at  4:34 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000033.html">Permalink</a>
 374
 375
 376                               </p>
 377                            </div>
 378                         </div>
 379                      </div>
 380
 381                   </div>
 382                </div>
 383             </div>
 384          </div>
 385       </div>
 386    </div>
 387 </body>
 388 </html>