2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" Set up and built 2.2.1.4 Got a little further on sam4linux (see extended entry) Still battling with Samba 3.0...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>More sam4linux and 2.2.1.4 - Status</title>
8 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
9 <link rel="canonical" href="http://defaria.com/blogs/Status/2003/11/more-sam4linux.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
13 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
14 <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2003/11/2213sam4linux22.html" title="2.2.1.3/sam4linux/2.2->2.3">
20 <link rel="next" href="http://defaria.com/blogs/Status/2003/11/sam-4-linux-up.html" title="SAM 4 Linux up">
21 <!-- Open Graph Protocol -->
22 <meta property="og:type" content="article">
23 <meta property="og:locale" content="en-us">
24 <meta property="og:title" content="More sam4linux and 2.2.1.4">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2003/11/more-sam4linux.html">
26 <meta property="og:description" content=" Set up and built 2.2.1.4 Got a little further on sam4linux (see extended entry) Still battling with Samba 3.0...">
27 <meta property="og:site_name" content="Status">
28 <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
30 <meta itemprop="description" content=" Set up and built 2.2.1.4 Got a little further on sam4linux (see extended entry) Still battling with Samba 3.0...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2003/11/more-sam4linux.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
62 <div id="content-inner">
63 <ul class="breadcrumb breadcrumb-list">
64 <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
65 <li class="breadcrumb-list-item">More sam4linux and 2.2.1.4</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1380" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">More sam4linux and 2.2.1.4</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2003-11-21T17:30:48-08:00" itemprop="datePublished">November 21, 2003</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/salira/">Salira</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
85 <li>Set up and built 2.2.1.4</li>
86 <li>Got a little further on sam4linux (see extended entry)</li>
87 <li>Still battling with Samba 3.0</li>
89 <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.
91 <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.
93 <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:
95 <pre>java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@127.0.0.1' (Using password: NO)
96 at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
97 at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
98 at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
99 at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
100 at java.sql.DriverManager.getConnection(DriverManager.java:517)
101 at java.sql.DriverManager.getConnection(DriverManager.java:177)
102 at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:145)
103 at jdbc.CreateSchema.init(CreateSchema.java:83)
104 at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
105 at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
106 at java.lang.Thread.run(Thread.java:484)
109 <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:
112 # mysqladmin create WebNMSdb
115 <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:
118 mysql> grant all privileges on WebNmsDB.* to root;
123 mysql> grant all privileges on WebNmsDB.* to root@127.0.0.1;
126 <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.
128 <p>Ah ha! The problem seems to be that I assigned a password to the user root for MySQL. Removing that caused more output...
130 Created table ObjectTypes
131 Created table ManagedObject
132 Created table MapContainer
133 Created table TopoObject
135 Created table Network
136 Created table IpAddress
137 Created table SnmpNode
138 Created table SnmpInterface
139 Created table TL1Node
140 Created table TL1Interface
141 Created table TOPOUSERPROPS
142 Created table ALERTUSERPROPS
143 Created table EVENTUSERPROPS
144 Created table USERTABLE
147 Created table ENGINES
149 Created table POLLUSERPROPS
150 Created table ANNOTATION
153 Created table MapSymbol
154 Created table MapLink
155 Created table MAPUSERPROPS
157 Created table PolledData
158 Created table ALERTLOGGER
159 Created table EVENTLOGGER
160 Created table CUSTOMMAPS
161 Created table DBINTERFACES
162 Created table DEFAULTMAPS
163 Created table TrapDisabledMO
164 Created table CHILDRENSTATUS
165 Created table CUSTOMPROPS
166 Created table OBJECTSTOLINK
167 Created table TOPODBSPECIALKEY
169 Created table DBEVENT
170 Created table DBALERT
172 Created table ObjectSchedulerRUNNABLE
173 Created table MapGroup
174 Created table ManagedGroupObject
175 Created table GroupTable
176 Created table TaskAudit
177 Created table DeviceAudit
178 Created table AttributeAudit
179 Created table ConfigTasks
180 Created table ConfigTaskDetails
181 Created table ConfigAttributes
182 Created table PendingTasks
183 Created table PendingDevices
184 Created table DeviceList
185 Created table DeviceListDetails
186 Created table DeviceUserProps
187 Created table TaskToDeviceListMap
188 Created table PollingObjects
189 Created table ConfigProvider
190 Created table PollingAttributes
191 Created table Providers
192 Created table StatsTables
193 Created table ThresholdObjects
194 Created table CustomView
195 Created table CustomViewProps
196 Created table CustomViewColumns
197 Created table PanelTree
198 Created table PanelProps
199 Created table PollFilters
200 Created table GenericFaultTable
201 Created table TrapFilter
202 Created table TrapEventParser
203 Created table EventAlertFilter
204 Created table Reports
205 Created table DataCollectionAttributes
206 Created table UserPasswordTable
207 Created table UserGroupTable
208 Created table ViewPropertiesTable
209 Created table ViewsToGroupTable
210 Created table ViewToOperationsTable
211 Created table OperationsTreeTable
212 Created table NamedViewToAuthorizedViewTable
213 Created table AuthAudit
214 Created table NotificationLog
215 Created table VarBindLog
216 Created table AgentDefValObject
217 Created table PolicyObject
218 Created table PolicyActionCondition
219 Created table POLICYUSERPROPS
220 Created table DBPOLICY
221 Created table PolicyScheduleTime
222 Created table AlertPolicyObject
223 Created table ENGINETABLE
224 Exception in creating table
225 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 ))
226 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
227 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
228 at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
229 at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
230 at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
231 at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
232 at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
233 at org.gjt.mm.mysql.Statement.execute(Statement.java:595)
234 at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
235 at jdbc.CreateSchema.createTables(CreateSchema.java:352)
236 at jdbc.CreateSchema.init(CreateSchema.java:85)
237 at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
238 at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
239 at java.lang.Thread.run(Thread.java:484)
240 Created table SwitchObject
241 Created table PortObject
242 Created table Printer
243 Created table OperationsTable
244 Created table BEFailOver
245 Created table PollIDToKeyMap
246 Created table ProvisioningVariantProps
247 Created table ProvisioningVariant
248 Created table UserConfTable
249 Created table CORBANode
250 Created table NetworkInventory
251 Created table SonsAuditLogTable
252 Created table SonsHistoryAlert
253 Created table SonsTopologyObjectImpl
254 Created table SonsPort
255 Created table SonsDS1Port
256 Created table SonsDS3Port
257 Created table SonsEtherPort
258 Created table SonsONUModule
259 Created table SonsShelf
260 Created table SonsSlot
261 Created table SonsCrossConnect
262 Created table SonsOLT
263 Created table SonsONU
264 Created table SonsPonInfo
265 Created table SonsPonPort
266 Created table SonsSonetPath
267 Created table SonsSTM1Port
268 Created table SonsSonetVT
269 Created table SonsDs0Port
270 Created table SonsDs0Bundle
271 Created table SonsXConn
272 Created table SonsCard
273 Created table SonsVDSLPort
274 Created table SonsVDSLRateRefer
275 Created table SonsVDSLTermInfo
276 Created table SonsMaintCmdRecord
277 Created table SonsQosBy8021p
278 Created table SonsVLanSwitchPort
279 Created table SonsQosByDscp
280 Created table SonsQosByPhyPort
281 Created table SonsQosByTos
282 Created table SonsQosByVLan
283 Created table SonsService
284 Created table SonsVLan
285 Created table SonsVLanBridgeParam
286 Created table SonsVLanMemberShip
287 Created table SonsSubscriber
288 Created table SonsVLanFDB
289 Created table SonsServiceObject
290 Created table SonsSTPDomain
291 Created table SonsSTPPort
292 Created table SonsActiveACL
293 Created table SonsCommonACE
294 Created table SonsCommonACL
295 All The Tables were not created properly.
299 <p>For the record I have:
302 mysqladmin Ver 8.40 Distrib 4.0.10-gamma, for mandrake-linux-gnu on i586
305 <nav class="page-navigation entry-navigation pagination content-nav">
306 <ul class="page-navigation-list">
308 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2003/11/2213sam4linux22.html" title="2.2.1.3/sam4linux/2.2->2.3">Previous entry</a></li>
311 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2003/11/sam-4-linux-up.html" title="SAM 4 Linux up">Next entry</a></li>
316 <aside id="zenback" class="zenback feedback">
317 Please paste Zenback script code here.
324 <aside class="widgets related" role="complementary">
325 <nav class="widget-search widget">
326 <div class="widget-content">
327 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
329 <input type="text" name="search" value="" placeholder="Search...">
331 <input type="hidden" name="IncludeBlogs" value="8">
333 <input type="hidden" name="limit" value="20">
334 <button type="submit" name="button">
335 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
341 <nav class="widget-archive-category widget">
342 <h3 class="widget-header">Categories</h3>
343 <div class="widget-content">
346 <ul class="widget-list">
349 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
357 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
365 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
373 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
381 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
389 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
397 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
405 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
413 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
421 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
429 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
437 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
449 <nav class="widget-archive-dropdown widget">
450 <h3 class="widget-header">Archives</h3>
451 <div class="widget-content">
453 <option>Select a Month...</option>
455 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
459 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
463 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
467 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
471 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
475 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
479 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
483 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
487 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
491 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
495 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
499 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
503 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
507 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
511 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
515 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
519 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
523 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
527 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
531 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
535 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
539 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
543 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
547 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
551 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
555 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
559 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
563 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
567 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
571 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
575 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
579 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
583 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
587 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
591 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
595 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
599 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
603 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
607 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
611 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
615 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
619 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
623 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
627 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
631 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
635 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
639 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
643 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
647 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
651 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
655 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
659 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
663 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
667 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
671 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
675 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
679 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
683 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
687 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
691 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
695 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
699 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
703 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
707 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
711 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
715 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
719 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
723 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
727 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
731 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
735 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
739 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
747 <div class="widget-syndication widget section">
748 <div class="widget-content">
749 <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
757 <footer id="footer" role="contentinfo">
758 <div id="footer-inner">
759 <div id="footer-content">
760 <nav role="navigation">
762 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
768 <p class="license">© Copyright 2016.</p>
769 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
775 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
776 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>