defaria.com/blogs/Status/archives/000040.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: More sam4linux and 2.2.1.4</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/000039.html" title="2.2.1.3/sam4linux/2.2-&gt;2.3" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000041.html" title="SAM 4 Linux up" />
  17
  18
  19
  20
  21
  22    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  23 </head>
  24 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  25    <div id="container">
  26       <div id="container-inner" class="pkg">
  27
  28          <div id="banner">
  29             <div id="banner-inner" class="pkg">
  30                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  31                <h2 id="banner-description">Searchable status reports and work log</h2>
  32             </div>
  33          </div>
  34
  35          <div id="pagebody">
  36             <div id="pagebody-inner" class="pkg">
  37                <div id="alpha">
  38                   <div id="alpha-inner" class="pkg">
  39
  40                      <p class="content-nav">
  41                         <a href="http://defaria.com/blogs/Status/archives/000039.html">&laquo; 2.2.1.3/sam4linux/2.2->2.3</a> |
  42                         <a href="http://defaria.com/blogs/Status/">Main</a>
  43                         | <a href="http://defaria.com/blogs/Status/archives/000041.html">SAM 4 Linux up &raquo;</a>
  44                      </p>
  45
  46                      <a id="a000040"></a>
  47                      <div class="entry" id="entry-40">
  48                         <h3 class="entry-header">More sam4linux and 2.2.1.4</h3>
  49                         <div class="entry-content">
  50                            <div class="entry-body">
  51                               <ol>
  52 <li>Set up and built 2.2.1.4</li>
  53 <li>Got a little further on sam4linux (see extended entry)</li>
  54 <li>Still battling with Samba 3.0</li>
  55 </ol>
  56                            </div>
  57                            <div id="more" class="entry-more">
  58                               <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.
  59
  60 <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.
  61
  62 <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:
  63
  64 <pre>java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@127.0.0.1' (Using password: NO)
  65         at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
  66         at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
  67         at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
  68         at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
  69         at java.sql.DriverManager.getConnection(DriverManager.java:517)
  70         at java.sql.DriverManager.getConnection(DriverManager.java:177)
  71         at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:145)
  72         at jdbc.CreateSchema.init(CreateSchema.java:83)
  73         at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
  74         at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
  75         at java.lang.Thread.run(Thread.java:484)
  76 Exiting Web NMS
  77 </pre>
  78 <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:
  79
  80 <pre>
  81 # mysqladmin create WebNMSdb
  82 </pre>
  83
  84 <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:
  85
  86 <pre>
  87 mysql> grant all privileges on WebNmsDB.* to root;
  88 </pre>
  89
  90 and
  91 <pre>
  92 mysql> grant all privileges on WebNmsDB.* to root@127.0.0.1;
  93 </pre>
  94
  95 <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.
  96
  97 <p>Ah ha! The problem seems to be that I assigned a password to the user root for MySQL. Removing that caused more output...
  98 <pre>
  99 Created table ObjectTypes
 100 Created table ManagedObject
 101 Created table MapContainer
 102 Created table TopoObject
 103 Created table Node
 104 Created table Network
 105 Created table IpAddress
 106 Created table SnmpNode
 107 Created table SnmpInterface
 108 Created table TL1Node
 109 Created table TL1Interface
 110 Created table TOPOUSERPROPS
 111 Created table ALERTUSERPROPS
 112 Created table EVENTUSERPROPS
 113 Created table USERTABLE
 114 Created table HOSTS
 115 Created table PORTS
 116 Created table ENGINES
 117 Created table USERS
 118 Created table POLLUSERPROPS
 119 Created table ANNOTATION
 120 Created table Alert
 121 Created table MapDB
 122 Created table MapSymbol
 123 Created table MapLink
 124 Created table MAPUSERPROPS
 125 Created table Event
 126 Created table PolledData
 127 Created table ALERTLOGGER
 128 Created table EVENTLOGGER
 129 Created table CUSTOMMAPS
 130 Created table DBINTERFACES
 131 Created table DEFAULTMAPS
 132 Created table TrapDisabledMO
 133 Created table CHILDRENSTATUS
 134 Created table CUSTOMPROPS
 135 Created table OBJECTSTOLINK
 136 Created table TOPODBSPECIALKEY
 137 Created table DBMAP
 138 Created table DBEVENT
 139 Created table DBALERT
 140 Created table DBPOLL
 141 Created table ObjectSchedulerRUNNABLE
 142 Created table MapGroup
 143 Created table ManagedGroupObject
 144 Created table GroupTable
 145 Created table TaskAudit
 146 Created table DeviceAudit
 147 Created table AttributeAudit
 148 Created table ConfigTasks
 149 Created table ConfigTaskDetails
 150 Created table ConfigAttributes
 151 Created table PendingTasks
 152 Created table PendingDevices
 153 Created table DeviceList
 154 Created table DeviceListDetails
 155 Created table DeviceUserProps
 156 Created table TaskToDeviceListMap
 157 Created table PollingObjects
 158 Created table ConfigProvider
 159 Created table PollingAttributes
 160 Created table Providers
 161 Created table StatsTables
 162 Created table ThresholdObjects
 163 Created table CustomView
 164 Created table CustomViewProps
 165 Created table CustomViewColumns
 166 Created table PanelTree
 167 Created table PanelProps
 168 Created table PollFilters
 169 Created table GenericFaultTable
 170 Created table TrapFilter
 171 Created table TrapEventParser
 172 Created table EventAlertFilter
 173 Created table Reports
 174 Created table DataCollectionAttributes
 175 Created table UserPasswordTable
 176 Created table UserGroupTable
 177 Created table ViewPropertiesTable
 178 Created table ViewsToGroupTable
 179 Created table ViewToOperationsTable
 180 Created table OperationsTreeTable
 181 Created table NamedViewToAuthorizedViewTable
 182 Created table AuthAudit
 183 Created table NotificationLog
 184 Created table VarBindLog
 185 Created table AgentDefValObject
 186 Created table PolicyObject
 187 Created table PolicyActionCondition
 188 Created table POLICYUSERPROPS
 189 Created table DBPOLICY
 190 Created table PolicyScheduleTime
 191 Created table AlertPolicyObject
 192 Created table ENGINETABLE
 193 Exception in creating table
 194 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 ))
 195 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
 196 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
 197         at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
 198         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
 199         at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
 200         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
 201         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
 202         at org.gjt.mm.mysql.Statement.execute(Statement.java:595)
 203         at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
 204         at jdbc.CreateSchema.createTables(CreateSchema.java:352)
 205         at jdbc.CreateSchema.init(CreateSchema.java:85)
 206         at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
 207         at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
 208         at java.lang.Thread.run(Thread.java:484)
 209 Created table SwitchObject
 210 Created table PortObject
 211 Created table Printer
 212 Created table OperationsTable
 213 Created table BEFailOver
 214 Created table PollIDToKeyMap
 215 Created table ProvisioningVariantProps
 216 Created table ProvisioningVariant
 217 Created table UserConfTable
 218 Created table CORBANode
 219 Created table NetworkInventory
 220 Created table SonsAuditLogTable
 221 Created table SonsHistoryAlert
 222 Created table SonsTopologyObjectImpl
 223 Created table SonsPort
 224 Created table SonsDS1Port
 225 Created table SonsDS3Port
 226 Created table SonsEtherPort
 227 Created table SonsONUModule
 228 Created table SonsShelf
 229 Created table SonsSlot
 230 Created table SonsCrossConnect
 231 Created table SonsOLT
 232 Created table SonsONU
 233 Created table SonsPonInfo
 234 Created table SonsPonPort
 235 Created table SonsSonetPath
 236 Created table SonsSTM1Port
 237 Created table SonsSonetVT
 238 Created table SonsDs0Port
 239 Created table SonsDs0Bundle
 240 Created table SonsXConn
 241 Created table SonsCard
 242 Created table SonsVDSLPort
 243 Created table SonsVDSLRateRefer
 244 Created table SonsVDSLTermInfo
 245 Created table SonsMaintCmdRecord
 246 Created table SonsQosBy8021p
 247 Created table SonsVLanSwitchPort
 248 Created table SonsQosByDscp
 249 Created table SonsQosByPhyPort
 250 Created table SonsQosByTos
 251 Created table SonsQosByVLan
 252 Created table SonsService
 253 Created table SonsVLan
 254 Created table SonsVLanBridgeParam
 255 Created table SonsVLanMemberShip
 256 Created table SonsSubscriber
 257 Created table SonsVLanFDB
 258 Created table SonsServiceObject
 259 Created table SonsSTPDomain
 260 Created table SonsSTPPort
 261 Created table SonsActiveACL
 262 Created table SonsCommonACE
 263 Created table SonsCommonACL
 264 All The Tables were not created properly.
 265 Exiting Web NMS
 266 </pre>
 267
 268 <p>For the record I have:
 269 <pre>
 270 mysqladmin -V
 271 mysqladmin  Ver 8.40 Distrib 4.0.10-gamma, for mandrake-linux-gnu on i586
 272 </pre>
 273                            </div>
 274                         </div>
 275                         <p class="entry-footer">
 276                            <span class="post-footers">Posted by  on November 21, 2003  5:30 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000040.html">Permalink</a>
 277                         </p>
 278                      </div>
 279
 280
 281
 282
 283                   </div>
 284                </div>
 285             </div>
 286          </div>
 287       </div>
 288    </div>
 289 </body>
 290 </html>