Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-devel / 2020-06

MySQL Error 2026 HY000 when connection to MySQL docker container (WSL2)

4 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Pascal Riekenberg

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

Reply by email

Michael Van Canneyt
to Pascal Riekenberg

Hi,

First of all: FPC does not support MySQL 8. The headers must be reviewed.

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.

Michael.

Pascal Riekenberg wrote 29 lines
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

Reply by email

Pascal Riekenberg
to Michael Van Canneyt
Show quoted text 7 lines
Michael Van Canneyt 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?

Show quoted text 37 lines
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 - https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel

Reply by email

Pascal Riekenberg
to Pascal Riekenberg

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

Pascal

Show quoted text 60 lines
Pascal Riekenberg hat am 12. Juni 2020 um 10:35 geschrieben: > Michael Van Canneyt 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 - > https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel _______________________________________________ fpc-devel maillist - https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel

Reply by email