RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread Heriberto Torrado via use-livecode
Sent: Wednesday, August 26, 2020 10:42 AM To: How to use LiveCode mailto:use-livecode@lists.runrev.com> > Cc: matthias_livecode_150...@m-r-d.de <mailto:matthias_livecode_150...@m-r-d.de> Subject: Re: Strange behavior between Mysql, MariaDB and SSL. There are also free MySQL Conn

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread Heriberto Torrado via use-livecode
Subject: Re: Strange behavior between Mysql, MariaDB and SSL. You are correct. But as Heriberto wort, it is an inhouse app, i thought using ODBC connector from Oracle might be better than lowering the security level of the database. - Matthias Rebbe Life Is Too Short For Boring Code > Am 27.08.2

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread Heriberto Torrado via use-livecode
:41 AM To: How to use LiveCode Cc: Bob Sneidar Subject: Re: Strange behavior between Mysql, MariaDB and SSL. Just a heads up, ODBC is a local service, not a network protocol. You have to create a DSN on the client OS which handles the network communications for you. So every client that connects

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread matthias rebbe via use-livecode
L using ODBC instead of the built-in LiveCode > MySQL client? > > Best, > Hery > > -Original Message- > From: use-livecode On Behalf Of > matthias rebbe via use-livecode > Sent: Wednesday, August 26, 2020 10:42 AM > To: How to use LiveCode > Cc: matthias_l

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread matthias rebbe via use-livecode
Of course it was meant to be "But as Heriberto wrote,.." - Matthias Rebbe Life Is Too Short For Boring Code > Am 27.08.2020 um 17:55 schrieb matthias_livecode_150...@m-r-d.de: > > You are correct. > But as Heriberto wort, it is an inhouse app, i thought using ODBC connector > from Oracle

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread matthias rebbe via use-livecode
You are correct. But as Heriberto wort, it is an inhouse app, i thought using ODBC connector from Oracle might be better than lowering the security level of the database. - Matthias Rebbe Life Is Too Short For Boring Code > Am 27.08.2020 um 17:40 schrieb Bob Sneidar via use-livecode > : > >

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread Bob Sneidar via use-livecode
Just a heads up, ODBC is a local service, not a network protocol. You have to create a DSN on the client OS which handles the network communications for you. So every client that connects will need to have this DSN set up first. For the experienced, this is no big deal, but for the first time

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread Heriberto Torrado via use-livecode
: matthias_livecode_150...@m-r-d.de Subject: Re: Strange behavior between Mysql, MariaDB and SSL. There are also free MySQL Connectors/ODBC available for different operating systems. The current ones are for Server 8.0,5.7 and 5.6. https://dev.mysql.com/downloads/connector/odbc/ They connectors can be downloaded

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread Heriberto Torrado via use-livecode
To: How to use LiveCode Cc: panagiotis merakos 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

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread Heriberto Torrado via use-livecode
: use-livecode On Behalf Of Bob Sneidar via use-livecode Sent: Tuesday, August 25, 2020 11:40 AM To: How to use LiveCode Cc: Bob Sneidar Subject: Re: Strange behavior between Mysql, MariaDB and SSL. mySQL for which platform? Last I checked, the build for Windows did NOT support encryption

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread matthias rebbe via use-livecode
There are also free MySQL Connectors/ODBC available for different operating systems. The current ones are for Server 8.0,5.7 and 5.6. https://dev.mysql.com/downloads/connector/odbc/ They connectors can be downloaded without the need to be logged in. So no need for an account registration at

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread panagiotis merakos via use-livecode
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

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-25 Thread Bob Sneidar via use-livecode
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