Database error(s)

[johane]

Originally Posted by fathernitwit

might help
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

if you find the solution, please post it on the wiki, this has been run into several times, but I cannot recall the solution

Worth reminding people that if you have logging turned on in mysql, and have set to log hostnames (not just ip addresses), then unless you have good name resolution (i.e. right entries in /etc/hosts or equivalent, or a local nameserver with in-addr.arpa zones properly set up) you can get DB timeouts very very easily.

[sdabbs65]

Originally Posted by johane

Worth reminding people that if you have logging turned on in mysql, and have set to log hostnames (not just ip addresses), then unless you have good name resolution (i.e. right entries in /etc/hosts or equivalent, or a local nameserver with in-addr.arpa zones properly set up) you can get DB timeouts very very easily.

I think this is a bug with max packets in mysql 4.0 , I have never seen this happen with 3.0

[johane]

Originally Posted by sdabbs65

I think this is a bug with max packets in mysql 4.0 , I have never seen this happen with 3.0

I've seen it happen with windows clients and Linux based MySQL v 3.x, when the server was protected by tcpwrappers, and the windows machine had that "update the DNS" setting turned on. I can't recall the exact number of times I've walked Users through turning off that checkmark, or have talked to clueless ISP people ( I can't call them admins and still preserve my self-respect. How can you "admin" an ISP and not have a clue about basic DNS and Bind?) about how to setup their DNS so that the Dyn-IP update works.

But little of this is relevant to the OP. Still, checking the hosts file is a good idea - if it's the problem, then it's easy to fix.

[stinkbeer]

I have checked the host file and didn't find any problems with it.
Can reach my host with the Windows ping command without any problem.

Cause im not a database expert, I gona install Mysql 3.23, run the DB part of the tutorial again.

[stinkbeer]

Ok guy's,

With Mysql 3.23 no databasedrops anymore. (dont know why. But the latest version of Mysql is not gona work for me)

Now im gona try to get connected with the client.

[Cringe]

I recieve the same ./opcodes.conf error, does anyone have a link to a version that might work for this version? Thanks.

[Belfedia]

Opcode error aren't a problem, don't need fix for that. In this post we speak about mysql error (2006). All eqemu version have this opcode error and working