Strange behavior between Mysql, MariaDB and SSL.

[Heriberto Torrado]

Hi Panagiotis,

It makes sense, I'm going to try it.

Thank you very much for your recommendations.
I would like to say that this list is great.

Best,
Hery


-----Original Message-----
From: use-livecode <use-livecode-bounces at lists.runrev.com> On Behalf Of panagiotis merakos via use-livecode
Sent: Wednesday, August 26, 2020 10:09 AM
To: How to use LiveCode <use-livecode at lists.runrev.com>
Cc: panagiotis merakos <merakosp at gmail.com>
Subject: Re: Strange behavior between Mysql, MariaDB and SSL.

Hello all,

This is because MySQL 8 supports a stronger authentication method based on SHA256, and this method is used by default.

LiveCode (as well as some other MySQL connectors/clients) do not support this authentication method yet. In this case, you could configure your MySQL installation to use the legacy authentication (password encryption) method.

See the suggested answers in this link:
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server/50961428

Hope this helps.

Kind regards,
Panos
--

On Tue, 25 Aug 2020 at 18:41, Bob Sneidar via use-livecode < use-livecode at lists.runrev.com> wrote:

> mySQL for which platform? Last I checked, the build for Windows did 
> NOT support encryption. There is a special branch that does, but I 
> could never get it to work.
>
> What I came up with is an agent that resides on the SQL server, built 
> in Livecode that listens for connections. It then handles the queries 
> locally and returns the data.
>
> The client and Server encrypt the data before sending it using a 
> method only I know, so it’s very secure. The communications are done 
> but I haven’t done the actual query side yet. That will be a half day’s work at most.
>
> I think this client server approach is far better than native 
> encryption, because I control the method and use a technique where 
> even if someone tried brute force, or somehow discovered the key, they 
> still could not decrypt the data, and wouldn’t know why.
>
> Bob S
>
>
> On Aug 24, 2020, at 3:25 PM, Heriberto Torrado via use-livecode < 
> use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>>
> wrote:
>
> Dear livecode programmers,
>
> For a few years we ran an internal app that accessed a MariaDB 
> database (no PHP or LiveCode Server middleware, just a raw connection) using SSL.
> The server running the database is old, so we moved to a new one.
>
> The new one comes with a Mysql 8 Database instead of MariaDB and the 
> SSL encryption suddenly stopped working.
>
> The new MYSQL database has a working SSL encryption cert (Let's encrypt).
>
> There are the tests:
>
> *From the server:*
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode