Issue MWS SSL certificate Mysql CE

alaaeddine.bounjoum · September 12, 2020, 4:01pm

Hello,

I have download and installed the free trial v10.5 from softwareag community.
I have installed the mysql community edition v8.0.18
All configurations db were made, but when i run mws_default i have this warning:

“”"
WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
“”“”

What is the location of the file contains the property ?

Thank you for your help !
Alaaeddine

wayne.leishman.20059 · September 12, 2020, 8:20pm

Hi.

Can you first clarify if you followed section “Configuring My webMethods Server to Use MySQL Community Edition“ in the My webMethods Admin guide?
The guide is here: https://documentation.softwareag.com/webmethods/mywebmethods_server/mws10-5/10-5_Administering_My_Webmethods_Server.pdf

Can you also let me know the DB info in the file mws.db.xml at this location: “Software AG_directory \MWS\server\serverName\config”

Your server name is likely default.

Regards
Wayne

alaaeddine.bounjoum · September 13, 2020, 4:10pm

Hi,

Yes the first issue is resolved thank you !

Howerver the database is reachable, i have tested the connection with IS, but still i have this error :

2020-09-13 16:27:11,799 INFO [Configuration ] - 010
2020-09-13 16:27:13,784 INFO [com.s.p.j.i.Activator ] - LoginModuleFactoryRegistry opened
2020-09-13 16:27:13,793 INFO [com.s.p.j.i.Activator ] - ManagedServiceFactory serice registered com.softwareag.platform.jaas.internal.ManagedConfiguration@48acc90b
2020-09-13 16:27:13,986 INFO [com.s.p.j.e.i.LoginModuleBundleTracker ] - Processing bundle com.softwareag.security.authz.store(10.5.0.0000-0229)
2020-09-13 16:27:14,073 INFO [com.s.s.s.i.e.ESAPIConfigurator ] - Using ‘file:/C:/SoftwareAG_ALL_withDesigner/profiles/MWS_default/configuration//ESAPI.properties’
2020-09-13 16:27:14,074 INFO [com.s.s.s.i.e.ESAPIConfigurator ] - Using internal ESAPI.properties
2020-09-13 16:27:14,117 INFO [com.s.p.j.e.i.LoginModuleBundleTracker ] - Processing bundle com.softwareag.security.sin.idp.saml.lm(10.5.0.0000-0229)
2020-09-13 16:27:14,125 INFO [com.s.p.j.e.i.LoginModuleBundleTracker ] - Processing bundle com.softwareag.security.sin.is.ldap(10.5.0.0000-0229)
2020-09-13 16:27:14,196 INFO [com.s.p.j.e.i.LoginModuleBundleTracker ] - Processing bundle com.softwareag.security.sin.misc(10.5.0.0000-0229)
2020-09-13 16:27:14,319 INFO [com.s.p.j.e.i.LoginModuleBundleTracker ] - Processing bundle com.softwareag.security.web.sso.saml2(10.5.0.0000-0229)
2020-09-13 16:27:14,370 INFO [org.e.j.u.log ] - Logging initialized @10993ms
2020-09-13 16:27:18,535 WARN [org.e.j.o.b.i.s.DefaultJettyAtJettyHomeHelper ] - No default jetty created.
2020-09-13 16:27:18,770 INFO [com.s.w.o.a.s.i.TransportListenerRegistryManager ] - WSSOGI0030: updated( null )
2020-09-13 16:27:21,297 ERROR [com.w.p.s.s.c.p.p.ConnectionPoolManager ] - Error creating database connection to: jdbc:mysql://localhost:3308/mws
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 608 milliseconds ago. The last packet sent successfully to the server was 588 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_222]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_222]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_222]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_222]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:202) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4869) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1656) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:768) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_222]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_222]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_222]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_222]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) ~[mysql-connector-java-5.1.49.jar:5.1.49]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_222]
at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_222]
at com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:111) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:28) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.pool.impl.LightweightObjectPool.createNewObject(LightweightObjectPool.java:410) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.pool.impl.LightweightObjectPool.checkOut(LightweightObjectPool.java:346) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.provider.pool.PooledConnectionProvider.getConnection(PooledConnectionProvider.java:193) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:124) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:732) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:355) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:277) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initDbConnection(ClusterPhaseProvider.java:321) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:309) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.preInit(ClusterPhaseProvider.java:73) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.impl.PortalSystemActivator.start(PortalSystemActivator.java:76) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:815) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_222]
at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:765) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1005) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:357) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.Module.doStart(Module.java:589) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.Module.start(Module.java:457) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1784) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1764) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1726) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1657) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1558) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:233) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:343) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_222]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) ~[?:1.8.0_222]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_222]
at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431) ~[?:1.8.0_222]
at sun.security.ssl.OutputRecord.write(OutputRecord.java:417) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:879) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:850) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:720) ~[?:1.8.0_222]
at sun.security.ssl.Handshaker.sendChangeCipherSpec(Handshaker.java:1144) ~[?:1.8.0_222]
at sun.security.ssl.ClientHandshaker.sendChangeCipherAndFinish(ClientHandshaker.java:1280) ~[?:1.8.0_222]
at sun.security.ssl.ClientHandshaker.serverHelloDone(ClientHandshaker.java:1190) ~[?:1.8.0_222]
at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:369) ~[?:1.8.0_222]
at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1037) ~[?:1.8.0_222]
at sun.security.ssl.Handshaker.process_record(Handshaker.java:965) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1064) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395) ~[?:1.8.0_222]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379) ~[?:1.8.0_222]
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:187) ~[mysql-connector-java-5.1.49.jar:5.1.49]
… 46 more
2020-09-13 16:27:21,321 INFO [com.w.p.PortalException ] - No registered exception delegate
2020-09-13 16:27:21,348 ERROR [com.w.p.s.i.PortalSystemActivator ] - Unable to create connection to jdbc:mysql://localhost:3308/mws
com.webMethods.portal.system.init.InitializationException: Unable to create connection to jdbc:mysql://localhost:3308/mws
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:742) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:355) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:277) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initDbConnection(ClusterPhaseProvider.java:321) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.initializeDatabaseConfigLocator(ClusterPhaseProvider.java:309) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.init.impl.ClusterPhaseProvider.preInit(ClusterPhaseProvider.java:73) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.system.impl.PortalSystemActivator.start(PortalSystemActivator.java:76) [com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:815) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_222]
at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:808) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:765) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1005) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:357) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.Module.doStart(Module.java:589) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.Module.start(Module.java:457) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1784) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1764) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1726) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1657) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1558) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:233) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:343) [org.eclipse.osgi_3.13.300.0000-0004.jar:3.13.300.0000-0004]
Caused by: java.sql.SQLException: Unable to create connection to jdbc:mysql://localhost:3308/mws
at com.webMethods.portal.service.sql.core.BaseSqlWorker.init(BaseSqlWorker.java:156) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
at com.webMethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:732) ~[com.webMethods.caf.server_10.5.0.0000-0232.jar:10.5.0.0000-0232]
… 22 more
2020-09-13 16:27:22,354 INFO [org.e.e.logger ][0] - Stopping OSGi framework.
2020-09-13 16:27:22,359 INFO [org.e.e.logger ][0] - Framework shutdown timeout set to 120 seconds. Please also check tanuki-wrapper shutdown property, if specified.

Best regards,
Alaaedine

wayne.leishman.20059 · September 13, 2020, 7:26pm

It looks like a DB connection issue. Are you sure the DB URL, user ID and password are valid?

alaaeddine.bounjoum · September 14, 2020, 1:57am

Yes i’m sure

Mike_Ng · September 14, 2020, 11:16am

Hi Aladdin,

Why not you download DBVisualiser and test configure a JDBC connection to the said DB using the same properties and also utilizing the same JDBC driver to see. If you’re also not able to connect, it’s most likely cause by something outside of webMethods/MWS.

It could be one or more following causes:

IP address or hostname in JDBC URL is wrong.
Hostname in JDBC URL is not recognized by local DNS server.
Port number is missing or wrong in JDBC URL.
DB server is down.
DB server doesn’t accept TCP/IP connections.
DB server has run out of connections.
Something in between Java and DB is blocking connections, e.g. a firewall or proxy.

alaaeddine.bounjoum · September 16, 2020, 4:43pm

Hi,

Thank you Mike_Ng
I will try your proposition.

Cordialement,
Alaaeddine