Comments (7)
I didn't read deep enough into the stack trace, the key is here:
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate) at sun.security.ssl.HandshakeContext.(HandshakeContext.java:171) ~[?:1.8.0_372] at sun.security.ssl.ClientHandshakeContext.(ClientHandshakeContext.java:103) ~[?:1.8.0_372]
The driver and the MySQL server don't agree on what version of TLS to use or don't agree on a set of ciphers.
from connect.
What version of MySQL are you using? Per the release notes for Connector/J 8.0.16:
Version 8.0.16 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
The release notes for version Connector/J 5.1.32 included with Mirth 3.5.X states:
Version 5.1.32 is a maintenance release of the production 5.1 branch. It is suitable for use with MySQL
Server versions 5.5, and 5.6.
from connect.
I'd also add that direct upgrades from versions that far apart haven't been officially supported from what I recall, and certainly not without out reading all releases notes from your current version to the latest version to identify any update that might affect your upgrade.
from connect.
from connect.
English please.
from connect.
Using MySQL 5.7
Why does the mirth.properties file automatically add content when starting the service?
# In version 3.7.0 the default protocols / cipher suites were updated to reflect the latest security best practices. The old value for https.client.protocols, in case you need it, is below.
# If you no longer need it, you can delete this property.
https.client.protocols.old = TLSv1.3,TLSv1.2
# In version 3.7.0 the default protocols / cipher suites were updated to reflect the latest security best practices. The old value for https.server.protocols, in case you need it, is below.
# If you no longer need it, you can delete this property.
https.server.protocols.old = TLSv1.3,TLSv1.2,SSLv2Hello
# In version 3.7.0 the default protocols / cipher suites were updated to reflect the latest security best practices. The old value for https.ciphersuites, in case you need it, is below.
# If you no longer need it, you can delete this property.
https.ciphersuites.old = TLS_CHACHA20_POLY1305_SHA256,TLS_ECDHE_ECDSA_WITH_CHACHA20_POLY1305_SHA256,TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256,TLS_DHE_RSA_WITH_CHACHA20_POLY1305_SHA256,TLS_AES_256_GCM_SHA384,TLS_AES_128_GCM_SHA256,TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384,TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384,TLS_RSA_WITH_AES_256_GCM_SHA384,TLS_ECDH_ECDSA_WITH_AES_256_GCM_SHA384,TLS_ECDH_RSA_WITH_AES_256_GCM_SHA384,TLS_DHE_RSA_WITH_AES_256_GCM_SHA384,TLS_DHE_DSS_WITH_AES_256_GCM_SHA384,TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256,TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256,TLS_RSA_WITH_AES_128_GCM_SHA256,TLS_ECDH_ECDSA_WITH_AES_128_GCM_SHA256,TLS_ECDH_RSA_WITH_AES_128_GCM_SHA256,TLS_DHE_RSA_WITH_AES_128_GCM_SHA256,TLS_DHE_DSS_WITH_AES_128_GCM_SHA256,TLS_EMPTY_RENEGOTIATION_INFO_SCSV
# The following properties were automatically added on startup for version 3.7.0
# If true, various read-only statements are separated into their own connection pool.
# By default the read-only pool will use the same connection information as the master pool,
# but you can change this with the "database-readonly" options. For example, to point the
# read-only pool to a different JDBC URL:
# database-readonly.url = jdbc:...
database.enable-read-write-split = true
# Maximum number of connections allowed for the read-only connection pool
database-readonly.max-connections = 20
# The language version for the Rhino JavaScript engine.
rhino.languageversion = default
# The following properties were automatically added on startup for version 3.11.0
# On startup, Maximum number of retries to establish database connections in case of failure
database.connection.maxretry = 2
# On startup, Maximum wait time in millseconds for retry to establish database connections in case of failure
database.connection.retrywaitinmilliseconds = 10000
# The following properties were automatically added on startup for version 3.12.0
# If set to true, the Connect REST API will require all incoming requests to contain an "X-Requested-With" header.
# This protects against Cross-Site Request Forgery (CSRF) security vulnerabilities.
server.api.require-requested-with = true
# The algorithm to use when decrypting old message content.
encryption.fallback.algorithm = AES
# The character set encoding to use when decrypting old message content
encryption.fallback.charset = windows-1252
# Allows old digest values to be verified
digest.fallback.algorithm = SHA256
digest.fallback.iterations = 1000
digest.fallback.usepbe = 0
# Only used for migration purposes, do not modify
version = 4.4.2
from connect.
Converting to Discussion, this is not a bug.
from connect.
Related Issues (20)
- [BUG] Channel map variable not assigning to script variable in post processor script. HOT 1
- [BUG] Webservice Listner not work. Error while searching for service [javax.xml.ws.spi.Provider] HOT 7
- [IDEA] Roll up the Rev(ision) column count to the Group level
- [BUG] Security Scans "X-Content-Type-Options HTTP Header is not detected"
- [BUG] Path traversal for HTTP Static Resource directories is allowed on Windows machines
- org.mozilla.javascript.MemberBox accesses internal sun class which fails on higher java versions HOT 1
- [IDEA] Granular Message Storage Settings HOT 5
- [IDEA] Ability to set the "font color" on tags.
- Add serverName and environmentName to the alert template variables list HOT 1
- Unable to retrieve payload from HTTP request url:https://localhost:8443
- [IDEA] Response Processor and Global Response Processor Scripts HOT 8
- [IDEA] Reminder for global data pruner setting HOT 5
- [BUG] Query Parameters on an HTTP Sender Connector are not sent in order
- [IDEA] Add a mechanism for unlocking user accounts
- [BUG] Mirth 4.5.0 - Transformer steps are overwriten (code is lost and overwritten by other step's code) when moved around HOT 1
- [IDEA] Add Event Log Entries for Exporting Channel Messages
- [BUG] Attachment Viewer Does Not Display Non-base64 Encoded Attachments
- [BUG] Mirth 4.5.0 is not working properly.
- [IDEA] Include ESCAPE clause in LIKE SQL statements used by Advanced Message Filter Operators
- [IDEA] webstart.jnlp Url from RequestUrl HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from connect.