[fpc-devel] MySQL Error 2026 HY000 when connection to MySQL docker container (WSL2)

[Pascal Riekenberg]

> Michael Van Canneyt <michael at freepascal.org> hat am 12. Juni 2020 um 10:26 geschrieben:
> 
> 
> 
> Hi,
> 
> First of all: FPC does not support MySQL 8. The headers must be reviewed.
Yes, i know. But there have not been any issues in the past.

> 
> The ErrorNo 2026 (HY000) points to a SSl error, I doubt that this is an
> error in FPC itself. Maybe extra params need to be set.
I suppose this has to do with DockerDesktop which now uses WSL2 (Windows 10 2004).
Previous HyperV version worked.

Any hints on extram parms to try?

> 
> Michael.
> 
> On Fri, 12 Jun 2020, Pascal Riekenberg wrote:
> 
> > Hi,
> >
> > does anyone experience similar problems
> > when connecting to a MySQL 8 docker container (WSL2)?
> >
> > I get ErrorNo 2026 (HY000) on connect. While mysql command and MySQL Workbench work as expected.
> >
> > fTransaction := TSQLTransaction.Create(Application);
> > fDatabase := TMySQL57Connection.Create(Application);
> > with fDatabase do begin
> > HostName := '127.0.0.1';
> > Port := 3311;
> > DatabaseName := 'sus';
> > UserName := 'sus';
> > Password := 'sus';
> > Transaction := fTransaction;
> > try
> > Connected := true;
> > except
> > on E:Exception do begin
> > fErrorMessage := E.Message;
> > end;
> > end;
> > end;
> >
> > Lazarus trunk, FPC trunk.
> >
> > Pascal
> >
> _______________________________________________
> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel