How to login with Authentication protocol

Forum related to version 6.1.5 of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

klchin
Senior Boarder
Senior Boarder
Posts: 65
Joined: 02.09.2005, 06:27

How to login with Authentication protocol

Postby klchin » 29.05.2007, 02:29

Hi everyone,

SQL Error : Client does not support authentication
protocol request by server; consider upgrading MySQL client.

Any sample code to resolve above problem.

Regards,
KL Chin

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 29.05.2007, 22:33

This problem is caused by the new authentication protocol used by mysql. So it's not really zeoslib related. As far as I know it can be solved in 2 ways:
- Start your server with the old authentication enabled (see mysql docs)-> if you're not the dba this probably will not be allowed.
- Use a newer dll. Problem here is the zeoslib 6.1.5 version you're using. I'm afraid the interface with a mysql 4.1 dll isn't working. You could try to rename an early 4.1 dll, but it's not very likely to work. -> Upgrading to zeoslib 6.6 will probably be unavoidable.

Mark

klchin
Senior Boarder
Senior Boarder
Posts: 65
Joined: 02.09.2005, 06:27

Postby klchin » 30.05.2007, 02:22

Hi Mark,

Thx for your suggestions.

You are right, renaming the dll does not worked.
I yet to test old authentication, but current I just delete the password.

How stable ver 6.6 as compare to 6.1.5?
Any major coding changes, i.e. the name.

Regards,
KL Chin

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 30.05.2007, 11:33

Should be more stable, is what I hear on the forum. I can't compare as I only entered when 6.5.1 alpha was available.

Mark

klchin
Senior Boarder
Senior Boarder
Posts: 65
Joined: 02.09.2005, 06:27

Postby klchin » 31.05.2007, 03:01

Hi Mark.

Again, thx for your reply.

It should be better, but I'm most worried about the memory
leakages, (mainly I only used the basic feature and query), other
bugs no so impoartant. Beside, I do followed the forum threads daily,
I understand still many bugs not resolve, that the reason I still
used 6.1.5. But will change when time come.

Some bugs occur on 6.1.5 I don't know it still in 6.6, which I post
on the different thread, i.e. why the TZQuery cannot change the
RequestLive at runtime.

http://zeos.firmos.at/viewtopic.php?t=1184

Regards,
KL Chin


Return to “6.1.5”

Who is online

Users browsing this forum: No registered users and 1 guest