Server problems
 

I just recently started working with creating emulated servers. I have been trying to make a LAN based one just to play with friends and have been running into a few problems.

With a fresh installed 0.7.0 server files and having both cavedude and peq databases sourced I was able to log into the server and create a characater and join the server (I used the wiki guide to setting up a windows 0.7.0 guide). After I logged off and when I attempted to log back into the server the world.exe continually crashes right after selecting the server in the server select screen.

I decided to update the files to the newest build currently available on the downloads page I copied and pasted the files into the eqemu folder, I did not re-source the databases. I also added the following to the database because of what i had read on these forums:
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
After making these changes I was able to get past the server select screen and load the character select but when trying to enter the world at the character select screen I keep getting the message that the zone is unavailable. I have read all over these forums and wiki trying to find a possible resolution and haven't been able to. I made a new character and attempted to connect to world in these logs:

Excuse me for the quoted log if its too long, I am not sure exactly what information will be useful so I just want to encompass any possiblity. Thank you for help in advance and if anyone needs any more information or other logs I'll be glad to supply them.

Make sure you didn't copy over your "eqemu_config.xml"

I am not sure if this is what you are refeering to but when I first updated to the new build I found that when I tried to run the server it wouldnt show up in minilogin window so I naturally thought there was a problem with the eqemu_config so I tried again to update with the a fresh install of 0.7.0 and made a backup of that file copied and pasted the new build and then moved back in the backup verison of the eqemu_config

Check this out , maybe close to the same problem.

http://www.eqemulator.net/forums/showthread.php?t=20790

i did another fresh install of the server files and resourced the databases along with updating the build to most current available. I ran the following commands on the database after installing as outlined in the 0.7.0 windows server guide:
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

After doing this I am still having the same problem. I can connect to the server and create a character but when I go to enter world the screen turns black for a split second and goes directly back to character select with the message zone unavailable. If anyone else has any suggestions at possible fixs or logs/settings I can check to find possible problems/solutions. I appreciate the help suggestions so far and the work people have put into this project.

Try this out;

http://www.eqemulator.net/forums/showthread.php?t=20778

see if it helps
edit;
It won't help - this is another problem and it may be related with the source lines you are entering.
Read backwards through the changelogs, make sure you applied all the lines needed to the database. also, make sure you are on the same database you are using for the EQ emulator- "status" commad will tell you where you're at, and "use" command will change you. Example: USE peq will set you to peq database.

I went ahead and tried it before you edited that it won't work and as you said it didn't work =). I did notice a new error in the logs though when I tried to see if your possible fix worked.
I am going through the changelogs right now to make sure I didn't miss stuff, thanks a lot for your support.

I went back into the changelogs and after the changes I mentioned it seemed that all of them have already been done, I didn't go all the way down the changelog to check everyone after about 20 lines that had already been done. I am still having the same problem and now I just feel like I am missing something completely stupid and small =P. I am beginning to think I'll just wait until a new build is released and try to do a fresh install and resource the databases with it.

Ok, so actually none of the builds are working now? Did you try an install from here, http://www.eqemulator.net/wiki/wikka...indowsServer70 , following the step-by step directions? (just making sure)
If so, what OS do you have - WindowsXP?, and what CPU are you using - Intel P3 or higher?

I've only tried two builds, the 0.7.0 (I used the EQEmuServerPack-3.52 thats linked on the how to create a 0.7.0 windows server guide that you linked from wiki) and the latest build on the downloads page. With the fresh install of 0.7.0 I get the world.exe crashes when you select the server in the server select screen and when I updated to the newest build I get zone is unavaliable message all the time. What I am going to do is I am going to do a completely fresh install with just the outline of how you are suppose to do it using the http://www.eqemulator.net/wiki/wikka...indowsServer70 guide. After I do a completely fresh install with no changes to the database other than what the EQEmuServerPack-3.52 has it in and will try to work from there. The server I have up now I have changed numerous times over the last few days trying to get this worked out. As far as computer it is a Windows XP computer with SP2 with a P3 processor. I really appreciate the help you are giving me and hopefully I'll end up getting this thing working correctly =)

Sorry to ask more questions, but i'm trying to figure out an answer for you;
What speed is you P3 CPU and how much memory do you have installed? also, I take you have installed MySQL 4x and Perl first?

I have no problems with questions =) ask away. The ram on the computer is 256mb, the procressor is only 1ghz. I decided to use the computer in question because it isn't very useful to me gaming anymore so I just let it sit around =P. And I did install mysql and perl first just as instructed in the guide.

The speed is ok, I'm running it with a P3 870 MhZ - but I think you may have too little ram. Somebody correct me if I'm wrong, but I inderstood the zones load up into memory, and need a lot of it. I have 1.25 GB of Ram in mine. Probably your 256mb is getting mostly ate up by your XP OS.

Email me when you can, I have more help for you, but this freaking forum is not letting me make long post

I know I already emailed you this, but now I'm testing to see if I can post again,
and this might be of interest to someone else

You could try this but like I said, 256 mb is probably way to little ram
Run MSCONFIG, go to startup and services tabs, disable as much as you can there. I do this anyways, as it helps speed up my system and hopefully free up more ram. here's a starting point for this,
http://www.onecomputerguy.com/window...rvices_disable
Also, for example, if you have a router, then you don't really need the windows firewall, router has it's own firewall, disable it in MSCONFIG.
Everquest recomends you use at least 500 mb of ram to run the client, so you know if you run the client on your EQEMU server machine, it's going to hog up you memory also. You should try login from another machine in the LAN .

edit;
I got rid of all my parenthesis, and it finally posted.

Toldya them parenthesis were the problem. Anywho, I have 256 SDRAM on my server, and it runs peachy, even if I'm doing Java programming (which, as we all know, chews through memory with a compiler) while waiting to regen. Yeah, my RAM sucks; it's not even DDR, and now they've got DDR2 and whatnot...accepting RAM donations, no live animals please =P...but seriously, my computer has a faster processor than that, but it is pretty crappy when it comes to RAM. Try the hilted version of the server out if you haven't. My server failed to work until I used it.

Just an update but Angelox and I have been exchanging emails and my server is on up and running. Many thanks to him =)

how did you fix it? im having this problem now. i was fine until i updated it tonight. had my server up for 6 days straight no problems, and now i cant get any zones -(

Have you updated before? What version EQEMU did you have before you updated? did you read the changelogs and add sourced the lines mentioned in them?

I was using 3.52 that comes with the EQEmuServerPack. i have not updated before. I did try adding the Sourced line and that did not work, they were accepted just didnt help my problem. i just did a clean instal and its running fine. Im kinda hesitant to update it again incase i cant get it working again. but if you have any help i will definatly try it.
thanks

I think there's two changelogs that require lines sourced into the SQL database. It might have been that you need to re-boot the machine for changes from the database to take effect.
You should keep trying, the newest binaries have many improvements. The new stuff should work fine. before you do this, don't forget to back up your "eqemu_config_xml" file, as the new binarie package will over write what you have.
Also, if you are editing loots, npc's and such, you should download "MySQL Administrator" from the MySQL site and have a "back-up plan" for your database. It's already saved me from my "blunders" many times.

Hey thanks for the quick replies. i will look into this tomorrow night and keep you updated. I never rebooted my machine before trying to log on so that might be it.
as for my database i started working on it this week and forgot to back it up..oh well. i only had a few ornate and epic merchants. so i didnt lose much that i cant redo quickly.

If you are updating from Server Pack 3.52 to the latest build you must follow the changelogs: http://www.eqemulator.net/releases/l...-0.7.0-804.txt
and make the appropriate adjustments to your database.

So to update to the newest release: 0.7.0-804 (which is the newest as of this post) you must run these lines into your database:

I'm using the PEQ database (works with Cavedude's as well) and it works great. If I didn't do exactly as I stated above it would not work properly and say the zone is unavailable. Trust me I've already found out :)

I also find that using MySQL Control Center is easiest for making database modifications. Load the control center, select your database, select the SQL/Query button, copy and paste the code and then execute the query.

Yep that fixed it, was a little slow loading in the first time but it works, thanks guys!

Everytime I enter the:
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0';

I get this error that says I'm not using the right MYSQL syntax. I currently have 4.0.0.23.

Do I need MYSQL 5.0? And if I do how can I replace it without running into problems? I am trying to upgrade from the 3.52 Cavedude pack to the most recent binary. Thank you for the help in advance.

EDIT: I think I see the problem. lol. NM this post. (`) looks a lot like (')