SQL Error: Authentication Outdated (MySQL 4.1)

[daemonreaver]

Alright, I had this problem with PHP once, ages ago, and EQemu is so far the only program I've found that can't suffice with just dropping a new MySQL connector lib (libmysql.dll) in the folder with the offending .exe.

world error log:
[04.09. - 02:59:26] Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

debug error log:
[04.09. - 02:59:26] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.6.6
[04.09. - 02:59:26] [WORLD__INIT] Connecting to MySQL...
[04.09. - 02:59:26] [WORLD__INIT_ERR] Cannot continue without a database connection.


MySQL Version string: "MySQL 4.1.18-nt-max running on localhost" - a standard install that works for about 16 other apps without any dll updating (except PHP5, which was stubborn).

XML config *is* set properly for the correct DB.

Note: This error occurs even if the XML is set to log in as root.

Is there and easy way to update the connector (without installing VisStudio and compiling)? Or should I try and find an older version that will use an external library (dll)?

---

I am going to try to co-exist 4.0 and 4.1 on the same machine (easy, just change the 4.0 server port to 3307 as per docs) and see if it'll connect. THis might fix it for now, however, support for 4.1 would be nice, since the folks at MySQL are slowly phasing out 4.0 and support for it.

[fathernitwit]

4.1 works fine, you just have to re-build eqemu yourself. 5.0 has problems however.

[daemonreaver]

Bleg.. MySQL 5x has issues with everything lately, I run it for test only.

As far as building the binaries.. Would VC++ 6.0 be capable (haven't had it installed for a while lol).. Or should i pick up VS 2005?

I think I have the C libs for 4.1 somewhere in my MySQL dirs (too many SQL's installed!) lol.

So far, 0.6.6 runs nicely (once I added the missing guild tables by hand), just have an issue with the loginserver (another thread lol)

[Belfedia]

I update mysql 4.0 to 4.1 and i have same problems before use this help guide :
http://www.webyog.com/faq/23_58_en.html
Now That work

[daemonreaver]

whoah...

Wouldn't you know, OLD_PASSWORD() wasn't in the docs for 4.1!

Thanks a ton.. I'll reset the PW for the game admin SQL hehe.

-editio-

FYI: Worked perfectly. Funny how it's the simple things (that are undocumented) that are at fault.

[Halamafx]

can someone explain this in dumbed down terms for me plz? im having this problem and would really like to fix it

[Bakersman]

well this is the wiki setup, and it has the command lines you need to put into the setup of your mysql database, if this helps any


MySQL Setup

http://www.eqemulator.net/wiki/wikka...kka=MySQLSetup



EQEmulator Database Schema

http://www.eqemulator.net/wiki/wikka...DatabaseSchema

[techguy84]

04-15-2006, 06:33 PM

Holy necro threads Batman!!!

But yea, as Bakersman said, you need to run a sql query to make MySQL 5 work with authencation from MySQL 4 apps, which of course is the emulator.

So you understand fully, open up your MySQL Command Line Interface, and type in the following,

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');

Substitute newpwd with the password you used when running the MySQL Server Instance Config Wizard.

[Halamafx]

ya i know old thread lol.. anyhow.. shows im using the search feature ^_^ now its saying my pw incorrect lol.. damn :(

[Halamafx]

ok heres whats going on.. when i do that old pw line on mysql.. it tells me Access denied for user 'eq'@'localhost' (PW wrong).. I try to figure out what it is manually.. and no idea.. keeps saying PW wrong.. when i go to Mysql admin to change the PW.. it says alrighty then! But.. Authentication protocol not supported.. back to square 1.. any clue?

[Halamafx]

les2212


--------------------------------------------------------------------------------

okay figured out problem. there is 2 eqemu_config files
1. eqemu_config --- wich is a xml document
2. eqemu_config.xml ---wich is a full file it says
i was only rewriting the full file before. rewrote the other file and server has apperantly started

fixed the problem!! thx guys ^_^