Not much done today - guess it's just the holiday thing. Still trying to get sonslinux to play nicely with the Windows environment. Helped James with his Linux setup. 2.2.1.5 was not built, perhaps when I get back from Vegas...
SAM 4 Linux is pretty slow. Not sure if that was because I was running through Cygwin and an X Server emulation. Had to run the client as root due to permissions problems.
Got tired of fighting with Samba 3.0 on Mandrake so I reinstalled 2.2. Still not completely right though.
Needed to uninstall MySQL 4.0 and download and install MySQL 3.23.58 from MySQL.com onto sonslinux as well as change the group named nogroup to nobody for the Apache server to start. SAM 4 Linux now works on sonslinux (with Mandrake Linux installed). The packaging for this is not at all that streamlined but I believe it was a first shot.
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.
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.
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:
java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@127.0.0.1' (Using password: NO)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:145)
at jdbc.CreateSchema.init(CreateSchema.java:83)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
at java.lang.Thread.run(Thread.java:484)
Exiting Web NMS
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:
# mysqladmin create WebNMSdb
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:
mysql> grant all privileges on WebNmsDB.* to root;and
mysql> grant all privileges on WebNmsDB.* to root@127.0.0.1;
but I keep getting the same error. I suspect I need to supply a password but I'm not sure how to do that.
Ah ha! The problem seems to be that I assigned a password to the user root for MySQL. Removing that caused more output...
Created table ObjectTypes
Created table ManagedObject
Created table MapContainer
Created table TopoObject
Created table Node
Created table Network
Created table IpAddress
Created table SnmpNode
Created table SnmpInterface
Created table TL1Node
Created table TL1Interface
Created table TOPOUSERPROPS
Created table ALERTUSERPROPS
Created table EVENTUSERPROPS
Created table USERTABLE
Created table HOSTS
Created table PORTS
Created table ENGINES
Created table USERS
Created table POLLUSERPROPS
Created table ANNOTATION
Created table Alert
Created table MapDB
Created table MapSymbol
Created table MapLink
Created table MAPUSERPROPS
Created table Event
Created table PolledData
Created table ALERTLOGGER
Created table EVENTLOGGER
Created table CUSTOMMAPS
Created table DBINTERFACES
Created table DEFAULTMAPS
Created table TrapDisabledMO
Created table CHILDRENSTATUS
Created table CUSTOMPROPS
Created table OBJECTSTOLINK
Created table TOPODBSPECIALKEY
Created table DBMAP
Created table DBEVENT
Created table DBALERT
Created table DBPOLL
Created table ObjectSchedulerRUNNABLE
Created table MapGroup
Created table ManagedGroupObject
Created table GroupTable
Created table TaskAudit
Created table DeviceAudit
Created table AttributeAudit
Created table ConfigTasks
Created table ConfigTaskDetails
Created table ConfigAttributes
Created table PendingTasks
Created table PendingDevices
Created table DeviceList
Created table DeviceListDetails
Created table DeviceUserProps
Created table TaskToDeviceListMap
Created table PollingObjects
Created table ConfigProvider
Created table PollingAttributes
Created table Providers
Created table StatsTables
Created table ThresholdObjects
Created table CustomView
Created table CustomViewProps
Created table CustomViewColumns
Created table PanelTree
Created table PanelProps
Created table PollFilters
Created table GenericFaultTable
Created table TrapFilter
Created table TrapEventParser
Created table EventAlertFilter
Created table Reports
Created table DataCollectionAttributes
Created table UserPasswordTable
Created table UserGroupTable
Created table ViewPropertiesTable
Created table ViewsToGroupTable
Created table ViewToOperationsTable
Created table OperationsTreeTable
Created table NamedViewToAuthorizedViewTable
Created table AuthAudit
Created table NotificationLog
Created table VarBindLog
Created table AgentDefValObject
Created table PolicyObject
Created table PolicyActionCondition
Created table POLICYUSERPROPS
Created table DBPOLICY
Created table PolicyScheduleTime
Created table AlertPolicyObject
Created table ENGINETABLE
Exception in creating table
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 ))
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
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
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
at org.gjt.mm.mysql.Statement.execute(Statement.java:595)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
at jdbc.CreateSchema.createTables(CreateSchema.java:352)
at jdbc.CreateSchema.init(CreateSchema.java:85)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:335)
at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:240)
at java.lang.Thread.run(Thread.java:484)
Created table SwitchObject
Created table PortObject
Created table Printer
Created table OperationsTable
Created table BEFailOver
Created table PollIDToKeyMap
Created table ProvisioningVariantProps
Created table ProvisioningVariant
Created table UserConfTable
Created table CORBANode
Created table NetworkInventory
Created table SonsAuditLogTable
Created table SonsHistoryAlert
Created table SonsTopologyObjectImpl
Created table SonsPort
Created table SonsDS1Port
Created table SonsDS3Port
Created table SonsEtherPort
Created table SonsONUModule
Created table SonsShelf
Created table SonsSlot
Created table SonsCrossConnect
Created table SonsOLT
Created table SonsONU
Created table SonsPonInfo
Created table SonsPonPort
Created table SonsSonetPath
Created table SonsSTM1Port
Created table SonsSonetVT
Created table SonsDs0Port
Created table SonsDs0Bundle
Created table SonsXConn
Created table SonsCard
Created table SonsVDSLPort
Created table SonsVDSLRateRefer
Created table SonsVDSLTermInfo
Created table SonsMaintCmdRecord
Created table SonsQosBy8021p
Created table SonsVLanSwitchPort
Created table SonsQosByDscp
Created table SonsQosByPhyPort
Created table SonsQosByTos
Created table SonsQosByVLan
Created table SonsService
Created table SonsVLan
Created table SonsVLanBridgeParam
Created table SonsVLanMemberShip
Created table SonsSubscriber
Created table SonsVLanFDB
Created table SonsServiceObject
Created table SonsSTPDomain
Created table SonsSTPPort
Created table SonsActiveACL
Created table SonsCommonACE
Created table SonsCommonACL
All The Tables were not created properly.
Exiting Web NMS
For the record I have:
mysqladmin -V mysqladmin Ver 8.40 Distrib 4.0.10-gamma, for mandrake-linux-gnu on i586
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.
Sam4linux is not all that operational yet. Initial problem is that the license is expired.
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.
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.
Built and release 2.2.1.2
Because of yesterdays rebuilding of 2.2.1.1 I had set the 2.2 official view to use the label 2.2.1.1 and forgot to put it back to rel_2.2_dev config spec. This caused problems in last night's merge
Regarding the Sun box, attempt to reinstall the OS but failed. Apparently we do not have the OS CDs. Unfortunately this has left us with an unusable system.
Asad says he checked the contracts and we are out of contract. So unless we renew the contract or find the OS CDs I'm not sure how we can use this machine.
Worked more on getting sonssun up and running.
Worked on problem with 2.2.1.1 and websam
Since Sonssun lacked man pages and it is unknown what exactly is installed or not installed on it I decided to wipe it clean and reinstall Solaris 8.0. Of course I've been having problems. May need to call Sun Support...
Since the testing involves expect and TCL I thought it would be good to find a good debugger. My stuff is getting complicated and a debugger would sure help. It would also help engineers writting tests. Unfortunately these debuggers work with TCL and get tripped up with expect functions.
SUT stands for System Under Test. If this environment variable is set then you no longer need to specify -m <IPAddress> to invoke a test or to run tester. Handy.
Attempted to gain access to sonsun today. Found out that it's powered off and not connected to the net. Sam lacks an IP drop in his cube.
Set up both 2.4 and china_2.4 and set up synchronization of branching for all of 2.2, 2.3, 2.4.
Worked on getting show system stuff into discovery