Verbindung zur Event Datenbank

SFriede · ‎10-11-2011

Einen schön guten Tag wünsch ich!

Ich habe seit einiger Zeit das Problem, dass ich nicht die Eventdatenbank erstellen kann bzw. die Verbindung zur Eventdatenbank aufbauen kann.

Ich habe schon diverse Anleitungen und Fehlerbeschreibung im Internet gefunden, aber keine konnte mir weiterhelfen…

Ich habe auf dem VCenter einen SQL Express Server. Dort liegt die Eventdatenbank.

Die Ports wurden entsprechend freigegeben. Bei der Datenbank wurde als Eigentümer der ViewAdministrator eingestellt, mit dem auch drauf zugegriffen werden soll.

Die Authentifizierung vom Server wurde auf Windows und SQL Server umgestellt.

Der dynamische Port wurde auf 1433 eingestellt.

Es wurde folgende Fehlermeldung zurückgegeben.

Protokollname: Application
Quelle:        VMware View
Datum:         11.10.2011 11:28:26
Ereignis-ID:   104
Aufgabenkategorie:(9)
Ebene:         Warnung
Schlüsselwörter:Klassisch
Benutzer:      SYSTEM
Computer:      SVVCM002.hannover.local
Beschreibung:
ADAM Error code: 2.128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:173)
com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: Invalid database configuration
    at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1148)
    at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1055)
    at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:169)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.vmware.vdi.admin.ui.common.ViewFlexFactory$ViewProxy.invoke(SourceFile:76)
    at $Proxy9.updateDatabaseConfiguration(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
    at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
    at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)
    at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)
    at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
    at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
    at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
    at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
    at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
    at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)
    at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
    at com.vmware.vdi.admin.ui.servlet.AMFServlet.a(SourceFile:70)
    at com.vmware.vdi.admin.ui.servlet.AMFServlet.doPost(SourceFile:56)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at com.vmware.vdi.support.ViewAdminFilter.doFilter(SourceFile:70)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at com.vmware.vdi.admin.be.filters.DisableUrlSessionFilter.doFilter(SourceFile:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.vmware.vdi.dbwrapper.exceptions.DBConnectionException: SQL exception when connecting to database: Es konnte keine TCP/IP-Verbindung mit dem Host hergestellt werden. java.net.UnknownHostException:
    at com.vmware.vdi.ob.lib.j.getConnection(SourceFile:73)
    at com.vmware.vdi.ob.lib.x.d(SourceFile:30)
    at com.vmware.vdi.dbwrapper.b.r(SourceFile:316)
    at com.vmware.vdi.dbwrapper.b.connect(SourceFile:196)
    at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1140)
    ... 55 more
Ereignis-XML:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="VMware View" />
    <EventID Qualifiers="32768">104</EventID>
    <Level>3</Level>
    <Task>9</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2011-10-11T09:28:26.000000000Z" />
    <EventRecordID>12232</EventRecordID>
    <Channel>Application</Channel>
    <Computer>SVVCM002.hannover.local</Computer>
    <Security UserID="S-1-5-18" />
</System>
<EventData>
    <Data>ADAM Error code: 2.128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:173)
com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: Invalid database configuration
    at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1148)
    at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1055)
    at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:169)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.vmware.vdi.admin.ui.common.ViewFlexFactory$ViewProxy.invoke(SourceFile:76)
    at $Proxy9.updateDatabaseConfiguration(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
    at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
    at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)
    at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)
    at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
    at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
    at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
    at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
    at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
    at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)
    at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
    at com.vmware.vdi.admin.ui.servlet.AMFServlet.a(SourceFile:70)
    at com.vmware.vdi.admin.ui.servlet.AMFServlet.doPost(SourceFile:56)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at com.vmware.vdi.support.ViewAdminFilter.doFilter(SourceFile:70)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at com.vmware.vdi.admin.be.filters.DisableUrlSessionFilter.doFilter(SourceFile:60)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
    at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
    at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
    at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
    at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.vmware.vdi.dbwrapper.exceptions.DBConnectionException: SQL exception when connecting to database: Es konnte keine TCP/IP-Verbindung mit dem Host hergestellt werden. java.net.UnknownHostException:
    at com.vmware.vdi.ob.lib.j.getConnection(SourceFile:73)
    at com.vmware.vdi.ob.lib.x.d(SourceFile:30)
    at com.vmware.vdi.dbwrapper.b.r(SourceFile:316)
    at com.vmware.vdi.dbwrapper.b.connect(SourceFile:196)
    at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1140)
    ... 55 more</Data>
</EventData>
</Event>

Falls noch irgendwelche Daten fehlen, kann ich diese gern nachreichen.

Ich hoffe doch, ihr könnt mir da weiter helfen.

Vielen Dank schonmal

mittim12 · ‎10-11-2011

Just wanted to add the translated version for everyone

I wish a pretty good day!

I have for some time the problem is that I can not create the event database and can establish the connection to the event database.

I've already found several instructions and error conditions on the Internet, but none could help me ...

I'm on the vCenter a SQL Server Express. There lies the event database.

The ports were released accordingly. The database administrator as the owner of view was set to be also accessed by it.

Authentication from the server was upgraded to Windows and SQL Server.

The dynamic port was set to 1433rd

It was returned the following error message.

Log Name: Application

Source: VMware View

Date: 11/10/2011 11:28:26

Event ID: 104

Task Category: (9)

Level: warning

Keywords: Classic

User: SYSTEM

Computer: SVVCM002.hannover.local

Description:

ADAM Error code: 2128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration (SourceFile: 173)

com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: Invalid database configuration

at com.vmware.vdi.admin.be.ConfigurationManager.a (SourceFile: 1148)

at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration (SourceFile: 1055)

at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration (SourceFile: 169)

at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 25)

at java.lang.reflect.Method.invoke (Method.java: 597)

com.vmware.vdi.admin.ui.common.ViewFlexFactory at $ ViewProxy.invoke (SourceFile: 76)

Proxy9.updateDatabaseConfiguration at $ (Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 25)

at java.lang.reflect.Method.invoke (Method.java: 597)

at flex.messaging.services.remoting.adapters.JavaAdapter.invoke (JavaAdapter.java: 421)

at flex.messaging.services.RemotingService.serviceMessage (RemotingService.java: 183)

at flex.messaging.MessageBroker.routeMessageToService (MessageBroker.java: 1503)

at flex.messaging.endpoints.AbstractEndpoint.serviceMessage (AbstractEndpoint.java: 884)

at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke (MessageBrokerFilter.java: 121)

at flex.messaging.endpoints.amf.LegacyFilter.invoke (LegacyFilter.java: 158)

at flex.messaging.endpoints.amf.SessionFilter.invoke (SessionFilter.java: 44)

at flex.messaging.endpoints.amf.BatchProcessFilter.invoke (BatchProcessFilter.java: 67)

at flex.messaging.endpoints.amf.SerializationFilter.invoke (SerializationFilter.java: 146)

at flex.messaging.endpoints.BaseHTTPEndpoint.service (BaseHTTPEndpoint.java: 278)

at flex.messaging.MessageBrokerServlet.service (MessageBrokerServlet.java: 322)

at javax.servlet.http.HttpServlet.service (HttpServlet.java: 729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 188)

at org.apache.catalina.core.ApplicationDispatcher.invoke (ApplicationDispatcher.java: 659)

at org.apache.catalina.core.ApplicationDispatcher.processRequest (ApplicationDispatcher.java: 457)

at org.apache.catalina.core.ApplicationDispatcher.doForward (ApplicationDispatcher.java: 395)

at org.apache.catalina.core.ApplicationDispatcher.forward (ApplicationDispatcher.java: 311)

at com.vmware.vdi.admin.ui.servlet.AMFServlet.a (SourceFile: 70)

at com.vmware.vdi.admin.ui.servlet.AMFServlet.doPost (SourceFile: 56)

at javax.servlet.http.HttpServlet.service (HttpServlet.java: 647)

at javax.servlet.http.HttpServlet.service (HttpServlet.java: 729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 188)

at com.vmware.vdi.support.ViewAdminFilter.doFilter (SourceFile: 70)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 188)

at com.vmware.vdi.admin.be.filters.DisableUrlSessionFilter.doFilter (SourceFile: 60)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java: 215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java: 188)

at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java: 213)

at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java: 172)

at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java: 127)

at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java: 117)

at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java: 108)

at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java: 174)

at org.apache.jk.server.JkCoyoteHandler.invoke (JkCoyoteHandler.java: 200)

at org.apache.jk.common.HandlerRequest.invoke (HandlerRequest.java: 291)

at org.apache.jk.common.ChannelSocket.invoke (ChannelSocket.java: 775)

at org.apache.jk.common.ChannelSocket.processConnection (ChannelSocket.java: 704)

at org.apache.jk.common.ChannelSocket $ SocketConnection.runIt (ChannelSocket.java: 897)

at org.apache.tomcat.util.threads.ThreadPool $ ControlRunnable.run (ThreadPool.java: 689)

at java.lang.Thread.run (Thread.java: 619)

Caused by: com.vmware.vdi.dbwrapper.exceptions.DBConnectionException: SQL exception when connecting to database: Could not create a TCP / IP connection to the host. java.net.UnknownHostException:

at com.vmware.vdi.ob.lib.j.getConnection (SourceFile: 73)

at com.vmware.vdi.ob.lib.x.d (SourceFile: 30)

at com.vmware.vdi.dbwrapper.b.r (SourceFile: 316)

at com.vmware.vdi.dbwrapper.b.connect (SourceFile: 196)

at com.vmware.vdi.admin.be.ConfigurationManager.a (SourceFile: 1140)

... 55 more

Event Xml:

'><event Xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

"><System>

'><Provider Name="VMware View" />

104'><EventID Qualifiers="32768"> 104 </ EventID>

3"><Level> 3 </ Level>

9"><task> 9 </ Task>

0x80000000000000"><Keywords> 0x80000000000000 </ Keywords>

'><TimeCreated SystemTime="2011-10-11T09:28:26.000000000Z" />

12232"><EventRecordID> 12 232 </ EventRecordID>

Application"><Channel> Application </ Channel>

SVVCM002.hannover.local"><Computer> SVVCM002.hannover.local </ Computer>

'><Security UserID="S-1-5-18" />

"></ System>

"><EventData>

ADAM Error code: 2.128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:173)"><Data> ADAM Error code: 2128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration (SourceFile: 173)