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

[Pascal Riekenberg]

Just updated my libmysql.dll from 5.7.17 to 5.7.30 and everything is fine again.

Pascal

> Pascal Riekenberg <pascal at riekenberg.eu> hat am 12. Juni 2020 um 10:35 geschrieben:
> 
> 
> > 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
> _______________________________________________
> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
> https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel