HOWTO: Setup an EQEmu server as of 06/01/2004

[lewster32]

Getting same problem as above, with either of the two files. :/

[Loosenut]

i just exited, i cant wait for 12 hours to source a file =\

[nilar]

Originally Posted by Shawn319

I'm not sure this is needed at all.. no-one has access to the (working) 'chat channel' servers. If you get an error saying something about this, ignore it.

When 0.5.5 DR1 first came out, this error was causing world.exe to not connect to Login Server. Not sure if we still have this problem but thats why its in there.

[sephiroth]

So does anyone know what i am doing wrong here? why my server is locked? any help would be greatly apreciated. =)

For loosenut, i am not sure if this is why it is taking so long but try running that the doing the "source db.sql" and all the other ones without mysql running. It seemed to help when i did it, but i am not positive on that, just worth a shot.

[lewster32]

I see the two world databases you need to source have been removed from the guide, I assume they're incompatible with 5.5 or something?

[Jezebell]

No, they are just not necessary to get a server running and people are complaining to much about having to wait for them to source.

[lewster32]

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

[Loosenut]

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

when i slept last night.. i wasnt sourcing any files.. but i still heard the beeping terror lol

[lewster32]

This is annoying, I've set up EQEmu in the past many times, having taken a break from it, I come back and I'm getting all the problems I've read about.

Re-following your guide and making the necessary adjustments for Minilogin, World.exe crashes as soon as I create a character, on subsequent re-login World.exe finds my 'bogus' character and deletes it. Also, I'm getting the "Error: Could not load item data. But ignoring." stuff which, having searched the forums, is apparently because the db.sql is incompatible.

I can paste in a full World.exe output if necessary. Any ideas?

BTW I'm posting here and not making a new thread because it seems pertinent to the topic.

[lewster32]

Answering my own question: Sourcing db.sql is the problem, if you skip that step and source MW055_alpha_02.sql directly after use eq; it works fine, takes a couple of minutes but everything works perfectly. Something must be wrong with the db.sql included with 5.5

[Jezebell]

Actually if you only source in Alpha_02 then you will be missing the Doors table update, thats the only reason I said to source the db.sql, but I see your point, i will try to find the Doors update and post it in the Tutorial. Btw, if you source the files in MySQL-Front it only takes 2.5 hours and there is no beeping I have done it uncountable times.

[DrizztBanrae]

Download lootdrop update by govtcheeze v0.2

This link seems to be broken..can we get a new one please?

[mikenune]

Originally Posted by lewster32

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

I wasn't there when it stopped (I was at work), but on my system which has a fast processor (AMD XP 3000), lotsa RAM (1GB), and fast a Hard Drive (a pair of 10,000RPM ATA100 8MB cache drives in RAID 0), and it took me more than 14 hours. My guess is somewhere around 16 hours or so. And yes, it continues beeping ALL THROUGH THE NIGHT!!! All for only about 5k new records. . .

Also, Since I have access to web space, I'm gonna go ahead and upload my MySQL DB dump and post a link to it when it's done.

I'm updating my DB with the "npc_types_update.sql" file right now. I'll have the dump out as soon as it's done!

[mikenune]

Here it is! Careful though, it's a little over 5 MB.

You'll need to right-click on the link and choose "save as. . ." since this web server knows how to read GZipped files!

http://www.raskii.net/eqemu/eqemu055.sql.gz

The only thing NOT in here (that I'm aware of at least) are usernames and the like.

[m0oni9]

I posted this in another thread, but if you run mysql with the -b switch, it will not beep on errer. ie:

mysql -b -u root