RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread Heriberto Torrado via use-livecode
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

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
20 11: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 con

Re: Strange behavior between Mysql, MariaDB and SSL.

2020-08-27 Thread matthias rebbe via use-livecode
necting to MySQL 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:

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 m

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 in

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
09 AM 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 conne

RE: Strange behavior between Mysql, MariaDB and SSL.

2020-08-26 Thread Heriberto Torrado via use-livecode
- From: 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

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 dev

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 u

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

Strange behavior between Mysql, MariaDB and SSL.

2020-08-24 Thread Heriberto Torrado via use-livecode
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 Mar