6 Replies Latest reply on Sep 16, 2015 12:14 PM by jvdavis456

    NSM won't start - I can't find the package config - v7.1.3.5

    adrian.coles

      Hi all,

       

      I'm hoping someone can help me.

      We need to gain access to our NSM and found that no one currently in the organisation has the password to get in.

      Support gave me some instructions of how to reset both the MySQL root password and reset the NSM admin password.

      I followed these instructions, but now when I try to get on to the NSM console, all I get is:

       

      Network Security Manager is currently loading, and its user interface will be available shortly. Please wait several minutes and try again.

      It stays at this.

      I discovered that when the McAfee Network Security Manager service tries to start, it s doing something in the background and then just seems to fail and stops the service.

       

      The EMS.log file shows this:

       

       

      And the EMSOUT.log file shows this:

       

      2015-09-16 15:56:41,073 Starting EMS Application

      2015-09-16 15:56:41,073 Setting Checks Level to STRICT

      2015-09-16 15:56:41,136 DatabaseURL: jdbc:mysql://localhost:3306/lf

      2015-09-16 15:56:41,151 EMS Checks complete, starting Tomcat...

      2015-09-16 15:57:47,826  at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

      2015-09-16 15:57:47,826  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0 PooledConnectionPool.java:529)

      2015-09-16 15:57:47,826  at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoo lBackedDataSource.java:128)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.C3POConnectionFactory.getConnection(C3POConnectionFac tory.java:218)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.GenConnFactory.getConnection(GenConnFactory.java:23)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.AbstractDAO$1.exec(AbstractDAO.java:110)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.AbstractDAO.retrySQLBlock(AbstractDAO.java:1310)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.AbstractDAO.getConn(AbstractDAO.java:108)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:494)

      2015-09-16 15:57:47,826  at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:641)

      2015-09-16 15:57:47,826  at com.intruvert.utility.misc.PropertiesDAO.getProperty(PropertiesDAO.java:34)

      2015-09-16 15:57:47,826  at com.intruvert.utility.misc.EMSProperties.getDBProperty(EMSProperties.java:777)

      2015-09-16 15:57:47,826  at com.intruvert.utility.misc.EMSProperties.getStringProperty(EMSProperties.java:2 16)

      2015-09-16 15:57:47,826  at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 374)

      2015-09-16 15:57:47,826  at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 355)

      2015-09-16 15:57:47,826  at com.intruvert.ui.util.coreui.AccessControlCache.<init>(AccessControlCache.java: 41)

      2015-09-16 15:57:47,826  at com.intruvert.ui.util.coreui.AccessControlCache.getOnlyInstance(AccessControlCa che.java:63)

      2015-09-16 15:57:47,826  at com.intruvert.ui.util.coreui.AccessControlFilter.<init>(AccessControlFilter.jav a:23)

      2015-09-16 15:57:47,826  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      2015-09-16 15:57:47,826  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

      2015-09-16 15:57:47,826  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

      2015-09-16 15:57:47,826  at java.lang.reflect.Constructor.newInstance(Unknown Source)

      2015-09-16 15:57:47,826  at java.lang.Class.newInstance0(Unknown Source)

      2015-09-16 15:57:47,826  at java.lang.Class.newInstance(Unknown Source)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterCon fig.java:275)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilter Config.java:422)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig .java:115)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

      2015-09-16 15:57:47,826  at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:142)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardService.start(StandardService.java:525)

      2015-09-16 15:57:47,826  at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

      2015-09-16 15:57:47,826  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      2015-09-16 15:57:47,826  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      2015-09-16 15:57:47,826  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      2015-09-16 15:57:47,826  at java.lang.reflect.Method.invoke(Unknown Source)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

      2015-09-16 15:57:47,826  at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

      2015-09-16 15:57:47,826  at com.intruvert.common.utility.startup.StartupChecks.main(StartupChecks.java:121)

      2015-09-16 15:57:47,826 Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

      2015-09-16 15:57:47,826  at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool. java:1319)

      2015-09-16 15:57:47,826  at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResou rcePool.java:557)

      2015-09-16 15:57:47,826  at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePoo l.java:477)

      2015-09-16 15:57:47,826  at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0 PooledConnectionPool.java:525)

      2015-09-16 15:57:47,826  ... 50 more

      2015-09-16 15:57:54,409 I can't find the package config

      2015-09-16 15:57:54,425 I need it so that I can get license manager information from netcooltn.properties.

      2015-09-16 15:57:55,595 Shutting down EMS Application...

       

      Can anyone help???

        • 1. Re: NSM won't start - I can't find the package config - v7.1.3.5
          jvdavis456

          Are all 3 NSM services running on the manager server, including Watchdog?

          • 2. Re: NSM won't start - I can't find the package config - v7.1.3.5
            adrian.coles

            Database and User Interface seem fine.

            Its the other one that doesn't stay running.

            • 3. Re: NSM won't start - I can't find the package config - v7.1.3.5
              adrian.coles

              EMS log:

               

              2015-09-16 15:56:47,594 INFO  [main] com.mchange.v2.log.MLog - MLog clients using log4j logging.
              2015-09-16 15:56:47,688 INFO  [main] com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po configuration values:
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.maxStatements = 0
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.initialPoolSize = 10
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.minPoolSize = 10
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.maxPoolSize = 40
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.idleConnectionTestPeriod = 300
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.maxIdleTime = 300
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.maxRetryAttempts = 60
              2015-09-16 15:56:47,860 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - bind C3P0 data source to JNDI name: java:PooledDS
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - utf8 c3po configuration values:
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.maxStatements = 0
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.initialPoolSize = 10
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.minPoolSize = 10
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.maxPoolSize = 20
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.idleConnectionTestPeriod = 300
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.maxIdleTime = 300
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.utf8.maxRetryAttempts = 60
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - bind UTF8 C3P0 data source to JNDI name: java:UTFPooledDS
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.maxCreateStmtAttempts = 3
              2015-09-16 15:56:47,875 INFO  [main] com.intruvert.utility.dao.C3POConnectionFactory - c3po.connection.threadSleepMilliSecs = 2000
              2015-09-16 15:56:47,969 INFO  [main] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 60, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1bqp82h9b1nk5puh123tqhf|2b347d33, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.gjt.mm.mysql.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1bqp82h9b1nk5puh123tqhf|2b347d33, idleConnectionTestPeriod -> 300, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/lf?zeroDateTimeBehavior=convertToNull, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 40, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
              2015-09-16 15:57:07,952 WARN  [Timer-0] com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@9ad5d46 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
              2015-09-16 15:57:07,968 WARN  [Timer-0] com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@9ad5d46 -- APPARENT DEADLOCK!!! Complete Status:
              Managed Threads: 3
              Active Threads: 3
              Active Tasks:
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3d2088db (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@22f90137 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@9bed3d1 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
              Pending Tasks:
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4f444356
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@aa0ebc2
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@4ad61301
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2c79cd09
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@708420ae
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@727db937
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c0b049a
              Pool thread stack traces:
              Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1805)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)
              Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1805)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)
              Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
                java.lang.Thread.sleep(Native Method)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1805)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)


              2015-09-16 15:57:47,826 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@22f90137 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (60). Last acquisition attempt exception:
              java.sql.SQLException: Access denied for user 'opmcafee'@'localhost' (using password: YES)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
              at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
              at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
              at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
              at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
              at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
              at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
              at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
              at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
              at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
              at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSour ce.java:134)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:182)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:171)
              at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePool Manager.acquireResource(C3P0PooledConnectionPool.java:137)
              at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java: 1014)
              at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java :32)
              at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1810)
              at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)
              2015-09-16 15:57:47,826 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Error in creating db connection. Number of attempts : 3
              2015-09-16 15:57:47,842 ERROR [main] com.intruvert.utility.dao.AbstractDAO -  --- Error executing SQL --- retryCount: 0
              java.lang.NullPointerException
              at com.intruvert.utility.dao.AbstractDAO$6.exec(AbstractDAO.java:1340)
              at com.intruvert.utility.dao.AbstractDAO.retrySQLBlock(AbstractDAO.java:1310)
              at com.intruvert.utility.dao.AbstractDAO.createStatement(AbstractDAO.java:1338)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:346)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:495)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:641)
              at com.intruvert.utility.misc.PropertiesDAO.getProperty(PropertiesDAO.java:34)
              at com.intruvert.utility.misc.EMSProperties.getDBProperty(EMSProperties.java:777)
              at com.intruvert.utility.misc.EMSProperties.getStringProperty(EMSProperties.java:2 16)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 374)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 355)
              at com.intruvert.ui.util.coreui.AccessControlCache.<init>(AccessControlCache.java: 41)
              at com.intruvert.ui.util.coreui.AccessControlCache.getOnlyInstance(AccessControlCa che.java:63)
              at com.intruvert.ui.util.coreui.AccessControlFilter.<init>(AccessControlFilter.jav a:23)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at java.lang.Class.newInstance0(Unknown Source)
              at java.lang.Class.newInstance(Unknown Source)
              at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterCon fig.java:275)
              at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilter Config.java:422)
              at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig .java:115)
              at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
              at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
              at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
              at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:142)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
              at org.apache.catalina.core.StandardService.start(StandardService.java:525)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
              at com.intruvert.common.utility.startup.StartupChecks.main(StartupChecks.java:121)
              2015-09-16 15:57:47,842 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Retrying SQL after 2000 milli secs
              2015-09-16 15:57:47,857 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3d2088db -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (60). Last acquisition attempt exception:
              java.sql.SQLException: Access denied for user 'opmcafee'@'localhost' (using password: YES)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
              at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
              at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
              at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
              at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
              at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
              at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
              at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
              at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
              at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
              at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSour ce.java:134)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:182)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:171)
              at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePool Manager.acquireResource(C3P0PooledConnectionPool.java:137)
              at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java: 1014)
              at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java :32)
              at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1810)
              at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)
              2015-09-16 15:57:47,888 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@9bed3d1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (60). Last acquisition attempt exception:
              java.sql.SQLException: Access denied for user 'opmcafee'@'localhost' (using password: YES)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
              at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
              at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
              at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
              at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
              at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
              at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
              at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
              at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
              at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
              at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
              at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSour ce.java:134)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:182)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrapper ConnectionPoolDataSource.java:171)
              at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePool Manager.acquireResource(C3P0PooledConnectionPool.java:137)
              at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java: 1014)
              at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java :32)
              at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool .java:1810)
              at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsyn chronousRunner.java:547)
              2015-09-16 15:57:49,854 ERROR [main] com.intruvert.utility.dao.AbstractDAO -  --- Error executing SQL --- retryCount: 1
              java.lang.NullPointerException
              at com.intruvert.utility.dao.AbstractDAO$6.exec(AbstractDAO.java:1340)
              at com.intruvert.utility.dao.AbstractDAO.retrySQLBlock(AbstractDAO.java:1310)
              at com.intruvert.utility.dao.AbstractDAO.createStatement(AbstractDAO.java:1338)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:346)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:495)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:641)
              at com.intruvert.utility.misc.PropertiesDAO.getProperty(PropertiesDAO.java:34)
              at com.intruvert.utility.misc.EMSProperties.getDBProperty(EMSProperties.java:777)
              at com.intruvert.utility.misc.EMSProperties.getStringProperty(EMSProperties.java:2 16)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 374)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 355)
              at com.intruvert.ui.util.coreui.AccessControlCache.<init>(AccessControlCache.java: 41)
              at com.intruvert.ui.util.coreui.AccessControlCache.getOnlyInstance(AccessControlCa che.java:63)
              at com.intruvert.ui.util.coreui.AccessControlFilter.<init>(AccessControlFilter.jav a:23)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at java.lang.Class.newInstance0(Unknown Source)
              at java.lang.Class.newInstance(Unknown Source)
              at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterCon fig.java:275)
              at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilter Config.java:422)
              at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig .java:115)
              at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
              at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
              at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
              at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:142)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
              at org.apache.catalina.core.StandardService.start(StandardService.java:525)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
              at com.intruvert.common.utility.startup.StartupChecks.main(StartupChecks.java:121)
              2015-09-16 15:57:49,854 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Retrying SQL after 2000 milli secs
              2015-09-16 15:57:51,866 ERROR [main] com.intruvert.utility.dao.AbstractDAO -  --- Error executing SQL --- retryCount: 2
              java.lang.NullPointerException
              at com.intruvert.utility.dao.AbstractDAO$6.exec(AbstractDAO.java:1340)
              at com.intruvert.utility.dao.AbstractDAO.retrySQLBlock(AbstractDAO.java:1310)
              at com.intruvert.utility.dao.AbstractDAO.createStatement(AbstractDAO.java:1338)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:346)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:495)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:641)
              at com.intruvert.utility.misc.PropertiesDAO.getProperty(PropertiesDAO.java:34)
              at com.intruvert.utility.misc.EMSProperties.getDBProperty(EMSProperties.java:777)
              at com.intruvert.utility.misc.EMSProperties.getStringProperty(EMSProperties.java:2 16)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 374)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 355)
              at com.intruvert.ui.util.coreui.AccessControlCache.<init>(AccessControlCache.java: 41)
              at com.intruvert.ui.util.coreui.AccessControlCache.getOnlyInstance(AccessControlCa che.java:63)
              at com.intruvert.ui.util.coreui.AccessControlFilter.<init>(AccessControlFilter.jav a:23)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at java.lang.Class.newInstance0(Unknown Source)
              at java.lang.Class.newInstance(Unknown Source)
              at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterCon fig.java:275)
              at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilter Config.java:422)
              at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig .java:115)
              at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
              at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
              at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
              at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:142)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
              at org.apache.catalina.core.StandardService.start(StandardService.java:525)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
              at com.intruvert.common.utility.startup.StartupChecks.main(StartupChecks.java:121)
              2015-09-16 15:57:51,866 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Retrying SQL after 2000 milli secs
              2015-09-16 15:57:53,879 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Error in creating statement. Number of attempts : 3
              2015-09-16 15:57:53,879 ERROR [main] com.intruvert.utility.dao.AbstractDAO - Q_SELECT_EMS_PROPERTIES_BY_NAME query failed. [SELECT value FROM iv_emsproperties WHERE name=?]
              iv.access.control.enabled
              java.sql.SQLException: Error in creating statement. Number of attempts : 3
              at com.intruvert.utility.dao.AbstractDAO.createStatement(AbstractDAO.java:1347)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:346)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:495)
              at com.intruvert.utility.dao.AbstractDAO.executeSQL(AbstractDAO.java:641)
              at com.intruvert.utility.misc.PropertiesDAO.getProperty(PropertiesDAO.java:34)
              at com.intruvert.utility.misc.EMSProperties.getDBProperty(EMSProperties.java:777)
              at com.intruvert.utility.misc.EMSProperties.getStringProperty(EMSProperties.java:2 16)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 374)
              at com.intruvert.utility.misc.EMSProperties.getBooleanProperty(EMSProperties.java: 355)
              at com.intruvert.ui.util.coreui.AccessControlCache.<init>(AccessControlCache.java: 41)
              at com.intruvert.ui.util.coreui.AccessControlCache.getOnlyInstance(AccessControlCa che.java:63)
              at com.intruvert.ui.util.coreui.AccessControlFilter.<init>(AccessControlFilter.jav a:23)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
              at java.lang.reflect.Constructor.newInstance(Unknown Source)
              at java.lang.Class.newInstance0(Unknown Source)
              at java.lang.Class.newInstance(Unknown Source)
              at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterCon fig.java:275)
              at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilter Config.java:422)
              at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig .java:115)
              at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4072)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4726)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
              at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
              at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
              at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
              at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:142)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
              at org.apache.catalina.core.StandardService.start(StandardService.java:525)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
              at com.intruvert.common.utility.startup.StartupChecks.main(StartupChecks.java:121)

              • 4. Re: NSM won't start - I can't find the package config - v7.1.3.5
                adrian.coles

                Just seen this:

                 

                Access denied for user 'opmcafee'@'localhost'

                 

                Does this mean the password I just reset for this user needs to be stored somewhere?

                • 5. Re: NSM won't start - I can't find the package config - v7.1.3.5
                  peter.mason

                  Hi Adrian,

                   

                  Have a look at this KB article, Check step 6.

                   

                  This will tell you if the user name above is your NSM DB user. You can try changing the password using the instruction in this KB.

                   

                  https://kc.mcafee.com/agent/index?page=content&id=KB53391

                   

                  Peter

                  • 6. Re: NSM won't start - I can't find the package config - v7.1.3.5
                    jvdavis456

                    Is there anything in the MySQL DB that you need to keep? If so it would be a good idea to run the dbadmin tool at this point if you haven't already. I'd also verify that you followed the all the PW reset instructions to the letter...I've learned that the hard way myself and had to retrace my steps to get things working again.