Lost connection to mysql database

[celling]

I have CRM integration based on mysql driver. This integration has been working well for v16 for a long time. After updating 3CX to v18, the connection to the database is lost.
At the same time, voice applications that use this database stop working.
MYSQL database not supported in v18?
(sorry for my language, it's google translate)

 

[md5]

Look, I spent a lot of money integrating this into my system, and after your update it stopped working.
When I bought a license, it worked and everything suited me. And your update broke it all.
I don't have anything secret in my database to use TLS.
Either fix it or I'll have to revoke my license and switch to another product

 

[Evolute IT]

Look, I spent a lot of money integrating this into my system, and after your update it stopped working.
When I bought a license, it worked and everything suited me. And your update broke it all.
I don't have anything secret in my database to use TLS.
Either fix it or I'll have to revoke my license and switch to another product

Two things:
1. I don't work for 3CX. It's not "my update".
2. I gave you 3 options: update MySQL, use a proxy script or switch system. Sounds like the latter will be your only way out.

 

[md5]

Great, I'll be glad to let the others know what great support you have
Will have to say goodbye to 3cx

 

[celling]

Gentlemen, you are now really wrong. I have recommended 3CX to several of my clients as a brilliant platform for integrating into their information processing systems. Everything worked wonderfully until you broke it with the v18 update.
Manufacturers that respect their customers cannot do this. There is no problem to put a switch that would solve the problem faster than reading this entire page.

 

[md5]

This is not respect for customers in the first place

 

[celling]

Installed and configured SSL support in MYSQL
I connect mysql client from 3cx to mysql server - the connection is made and it is encrypted:
status -- > SSL: Cipher in use is DHE-RSA-AES256-SHA
For this I had to register the paths to the certificate and key in the settings of mysql-client on 3cx
But!
Test connection via interface 3CX returns an error:


How can I guess what else is required for 3СX and this integration?

 

[edossantos]

SSL is deprecated. You need to use TLS 1.2.
https://en.wikipedia.org/wiki/Transport_Layer_Security#Secure_Data_Network_System

 

[celling]

Ок,

mysql> SHOW VARIABLES LIKE '%version%';                                                                                                                                                                           +-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.7.23                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| tls_version             | TLSv1.1,TLSv1.2              |
| version                 | 5.7.23-log                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+
8 rows in set (0,01 sec)

Is it good enough for connection?
Can anyone please take a look at me and help with a broken integration in MySQL database?

 

[celling]

Guys, integration with MySQL does not work! Can someone check it?

 

[edossantos]

Please try a test lookup from the 3CX Console > Settings > CRM > Test button, and check if you're still getting the same error. If you enabled TLS 1.2, maybe now you're getting a different error message.....

 

[celling]

I did it first!
Unfortunately the error message has not changed. ;(
Maybe someone can repeat my situation and check that I'm right? I will be grateful for it!