error after losing the connection to the MS SQL SB
Hi,
Since last night I have an error and the OP-Manager doesn't work anymore. I found these in the wrapper.log file. I have checked
SQLException while getting database connection. Check if database daemon is running
java.sql.SQLException: Login failed for user 'opmanager'. The user is not associated with a trusted SQL Server connection.
This is what really happened: as you can see the conenction with the MS SQL was lost and after that everything is blocked. The SQL is there and looks fine. I have restarted the OPManager server without any luck.
What should I check more?
Thanks for you fast reply,
Best Regards,
Razvan Despa
INFO | jvm 1 | 2009/09/11 03:02:25 | ##########################################################
INFO | jvm 1 | 2009/09/11 03:02:25 | Connection to the Database is lost. Trying to reconnect to the Database
INFO | jvm 1 | 2009/09/11 03:02:25 | Please Wait ...
INFO | jvm 1 | 2009/09/11 03:02:47 | Could not reconnect to database. Server is being Shut Down
INFO | jvm 1 | 2009/09/11 03:02:47 |
INFO | jvm 1 | 2009/09/11 03:02:47 |
INFO | jvm 1 | 2009/09/11 03:02:47 | Trying to Shutdown OpManager
INFO | jvm 1 | 2009/09/11 03:02:49 |
INFO | jvm 1 | 2009/09/11 03:02:49 | Schedulers Stopped successfully
INFO | jvm 1 | 2009/09/11 03:02:49 |
INFO | jvm 1 | 2009/09/11 03:02:49 | All Shut Down Observers Notified
INFO | jvm 1 | 2009/09/11 03:02:49 |
INFO | jvm 1 | 2009/09/11 03:02:49 | Process : NmsSAServerFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:49 | Process : StartTelnetClientFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:49 | Process : ExampleFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:49 | Process : UserConfigProcessFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : PolicyFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : TopoFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : PollFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : AlertFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : EventFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : MapFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : AuthorizationManagerFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : AuthenticationManagerFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : MServerFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : SAServerFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : NCMProcess [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : DataMgmtRPI [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : NetFlowProcess [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : UserConfigProcess [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : StartTelnetClient [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : CLIFactoryBinder [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : AuthMgr [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : NmsMainFE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : OpManagerStatusProcess [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:50 | Process : OpManagerProcess [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:51 | Process : NmsPolicyMgr [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:51 | Process : EventMgr
INFO | jvm 1 | 2009/09/11 03:02:54 | [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:54 | Process : Collector [ Failed ]
INFO | jvm 1 | 2009/09/11 03:02:54 | Process : MapServerBE [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:54 | Process : NmsAuthenticationManager [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:54 | Process : NmsAuthManager [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:54 | Process : NMSMServer
INFO | jvm 1 | 2009/09/11 03:02:55 | [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 | Process : NMSSAServer [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 | Process : DBServer [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 | Process : RunJSPModule [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 | Process : OpManagerRunApacheExeModule [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 | Process : SetSecurityProperty [ Stopped ]
INFO | jvm 1 | 2009/09/11 03:02:55 |
INFO | jvm 1 | 2009/09/11 03:02:56 | OpManager Successfully Shut Down
STATUS | wrapper | 2009/09/11 03:03:08 | <-- Wrapper Stopped
STATUS | wrapper | 2009/09/11 09:07:57 | --> Wrapper Started as Service
STATUS | wrapper | 2009/09/11 09:07:57 | Launching a JVM...
INFO | jvm 1 | 2009/09/11 09:07:58 | Wrapper (Version 3.1.1) http://wrapper.tanukisoftware.org
INFO | jvm 1 | 2009/09/11 09:07:58 |
INFO | jvm 1 | 2009/09/11 09:07:58 | inside addon check
INFO | jvm 1 | 2009/09/11 09:08:09 | taryIconProps {DefaultMenuItem=Status, ApplicationName=OpManager, Menu=[{Id=Status, DisplayName=&OpManager Status, RunProcess=ShowOpManagerStatus}, {Id=StartClient, DisplayName=Start &Client, RunProcess=StartOpManagerWebClient}, {Id=ShutDownServer, DisplayName=Sh&ut Down Server, RunProcess=ShutdownOpManager}], EnableIcon=images/logo16x16_green.png, DisableIcon=images/logo16x16_gray.png, ToolTipText=ProductName, MainProcess=StartOpManager}
INFO | jvm 1 | 2009/09/11 09:08:09 | application_name OpManager
INFO | jvm 1 | 2009/09/11 09:08:09 | Windows 2003
INFO | jvm 1 | 2009/09/11 09:08:09 | startAndRun
INFO | jvm 1 | 2009/09/11 09:08:09 | menuName &OpManager Status RunProcess ShowOpManagerStatus
INFO | jvm 1 | 2009/09/11 09:08:09 | menuName Start &Client RunProcess StartOpManagerWebClient
INFO | jvm 1 | 2009/09/11 09:08:09 | menuName Sh&ut Down Server RunProcess ShutdownOpManager
INFO | jvm 1 | 2009/09/11 09:08:09 | setProcessInProgress true
INFO | jvm 1 | 2009/09/11 09:08:11 | SQLException while getting database connection. Check if database daemon is running
INFO | jvm 1 | 2009/09/11 09:08:11 | java.sql.SQLException: Login failed for user 'opmanager'. The user is not associated with a trusted SQL Server connection.
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:569)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:336)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
INFO | jvm 1 | 2009/09/11 09:08:11 | at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:183)
INFO | jvm 1 | 2009/09/11 09:08:11 | at java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2009/09/11 09:08:11 | at java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2009/09/11 09:08:11 | at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:146)
INFO | jvm 1 | 2009/09/11 09:08:11 | at jdbc.CreateSchema.init(CreateSchema.java:84)
INFO | jvm 1 | 2009/09/11 09:08:11 | at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:388)
INFO | jvm 1 | 2009/09/11 09:08:11 | at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:262)
INFO | jvm 1 | 2009/09/11 09:08:11 | at java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2009/09/11 09:08:11 | Exiting OpManager
STATUS | wrapper | 2009/09/11 09:08:13 | <-- Wrapper Stopped