Possible MySQL 5.1 bug loading items

[totalcynic]

Originally Posted by mattmeck

This is an open source community, if you dont like it fix it.

If you want 5.x to work, get it working, im sure people other then you will use it.

That I agree with you, and is exactly what I did, see the original post. However, your reply was;

That version of MYSQL is not supported.

The officialy supported version is 4.0.23.

Now to me that reads, "we don't want to know that you have a problem, and we don't want your fix as its MySQL 5.x". From your follow up post this is obviously not what you ment, and I appologise for taking it that way.

[WildcardX]

As a developer myself, I can tell you that there is no reason the EMU server can't run on MySQL 5.0, as it is today. I know there is general resistance to the newer MySQL 5.0, but from a technical point of view, there isn't a single reason why you can't run with MySQL 5.0 today, if that is what you want. Just download the source code, compile it against the MySQL 5.0 libraries and you are now ready to load your server from a MySQL 5.0 database server. As for MySQL 5.1, that is still a beta product and i have not evaluated it, so I can not speak intelligently about it. As for MySQL 4.0, MySQL's website doesn't even allow you to download it any longer...

So, today, it is really your choice. Compile to use MySQL 5.0 or keep on using 4.0. I have been using MySQL 5.0 for my own server now for almost a year and it runs from a Windows server even. I can categorically deny the rumors about how MySQL doesn't work on Windows. It does. And it also works from linux if thats your cup of tea as well.

Frankly, this whole MySQL version debate drives me nuts. There is so much bad information on the forums surrounding this, it is silly. If you are interested in MySQL 5.0 but your not sure about if it will run or not, try it your self.. But you will have to know how to compile c++ code.

[Angelox]

I'm pretty sure MYSql 4.0 is totally unsupported by MySql now - what they support appears to be 4.1 and up (might as well get 5x for that matter).
But didn't they apply your fixes for 5.0 to the code already?

[tallerin]

I run Mysql 5.0.0.24 newer then that i ran into client authetication issues with the server.

I don't see why chase Mysql for each new version they put out. eqemu works fine with older versions that can still be downloaded off there sight.

[Angelox]

Originally Posted by tallerin

I run Mysql 5.0.0.24 newer then that i ran into client authetication issues with the server.

I don't see why chase Mysql for each new version they put out. eqemu works fine with older versions that can still be downloaded off there sight.

The solution to this is simple, and I have it posted at my web page - also MySql site does (is where I learned how to correct this).
Quoting myself;

-If you see this error (and you probably will) "Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Then you need to run this line in a MySQL shell;
SET PASSWORD FOR eq@localhost = OLD_PASSWORD('eq');
This enables a "backwards" compatibility for login from the EqEmu program.

-The only other thing I saw, was the new MySQL 5 default installs to c:\program files\mysql\ my old 4.0 was in c:\mysql\ . So , just incase anything was looking for Mysql there , I changed default install to c:\mysql\ .

That's what I use (5x) and have no problems - But I can't afford a big connection for a public server to tell you it works like that too.