Trouble getting Zones / World to startup
 

Hello, this is first time trying to run an EQEmu server so I'm sure mistakes were made. Now I followed the Complete Windows-based Public Server Setup Guide. Ran into some trouble when I came up to Step 4, which is "Downloading, installing and updating the PEQ database". Of coarse thats the old database linked in that section. So I sourced all of that stuff in like it said then downloaded the beta and sourced all that stuff in and was so confused I pulled my hair out. Searched around on forums and found two good posts about starting over and just using peqbeta source. So I went into mysql command prompt and drop database peq; and then created it again and resourced using just the new stuff.

The rest of the guide I followed to the T. Except for some reason I'm experiencing some troubles opening ports 7000-7100 on my router. How big a problem is this? Could I still test things locally at least? Followed all the steps on my routers config but it refuses to open them. 9000 opens just not that 7000-7100 range.

Anyway so I run the start up bat file and I can open up EQ and find my server on the list and log into it. I'm able to create a character as well. Here is what the 4 server windows look like. After reading posts and searching around I'm starting to think these windows should be saying more.

http://i.imgur.com/1YiJlN5.png

Now anytime I click to enter world it pops up a box saying "That zone is unavailable."

http://i.imgur.com/NBVqew1.png

My eqemu_config.xml looks like this.
eqemu_shared_memory.log
If I had to take a wild guess I'd go with your ports are not open thats the problem. I've racked my brain for 2 days on this and thats the only thing I can think of. Darn if my router will let me do it though :-( Any help would be greatly appreciated. Thanks in advanced.

Check you logs directory, if you dont have one, create one then re-start the server...

All the log files are super short. Examples:

eqemu_queryserv_2792.log
eqemu_ucs_5124.log
eqemu_world_6604.log
eqemu_shared_memory_4516.log
Now I did try loading an individual zone with the zone.exe. I did "zone nexus" just randomly tried that zone. Got this log file

eqemu_zone_6548.log
eqemu_debug_zone_6548.log
eqemu_error_zone_6548.log
Hope thats what you wanted?

Its possible your logs are short because you selected less than 5 when you ran cmake for log level, but that does not explain your issue..

The nexus zone looks good until:

---- Zone server nexus, listening on port:0 ----

It should then connect to your world and the world would have assigned it port 7005 assuming you use 5 dynamics zones...

In the launched window did it try to connect to world? Is the world window seeing the request from the zones?

Was world running? Try running world via command prompt as you did with zone.

World window looks like the picture above and the log file above. Just two lines.

Nothing every happens after that just stops.

Edit: Yeah if I have world window up and then run a zone window the world window stays the same nothing every happens in it.
Second Edit: Checked CMake and I just used the defaults like the guide said EQEMU_DEBUG_LEVEL is set to 5.

Looks fishy, dont want to send you on a wild goose chase, but it looks like none of the services are communicating with the world.

In a command prompt, with all eqemu services off run

And look for port :9000, if anything is using 9000 and eqemu service are off then something has taken over that port, blocking the world.

If there is nothing using it, launch your emu as normal(assume bat file) then try the netstat again and see if anything is atttaching to port :9000 typically on 127.0.0.1

Yeah looks like something is using it.

http://i.imgur.com/YFMUV9Q.png

Edit 1: Let me restart just to be sure nothing funny is happening and re run test.

Edit 2: Ah I figured it out with help from https://secure.dslreports.com/faq/9444 I found that my twonky server is using port 9000. Let me turn that off and try your next step!

Edit 3: OOOOOOHHH yeah I can log in to the game finally!! Thank you rencro so much that was making my head hurt, something so simple!

You can use the "Windows Task manager" to determine what program is using it by comparing the "pids" on the "Details" tab if using windows8

oops-- in before edit 2 above ;-), anyways for future reference...

You did it man, I'm up and running now. 2 days of frustration and it was my twonky media server messing things up it seems.

Cool, assumed you just reassinged twonky to use another port then?

Turned it off for the time being I'll figure that out later this evening. Got to go chill with the wife we finally got our kid to sleep :-) appreciate the help man.

'Process Explorer' by sysinternals will also show you the pid..for older windows versions.

So took the time today and fixed my Twonky Media Server conflict, can run both EQEmu and it at same time now. For those interested you have to turn off Twonky server first. Then find twonkyserver.ini file, I had 4 files on my C drive labeled this for some reason. The one that mattered was C:\ProgramData\twonkyserver.ini . Open that up and at the line:

Add a port number other then 9000, I used 8000. So mine looked like:

Save it and restart twonky. Now this also messes up the twonky web browser config page so you need to go into C:\Program Files (x86)\Twonky\TwonkyServer\ and edit 3 files.

twonky-config.html
twonky-config1.html
twonky-config2.html

Open up each of those files up and change the port to your new port setting. Below is what mine now looks like.

URL=http://192.168.0.193:8000/webconfig

After that you can access the web settings from the tray icon again. Hope this helps anyone else who gets this problem.

Im having this same issue, only difference is, I have nothing running on port 9000 and it simply will not connect to my database. It pops up 4 windows and hangs.

I tried using an older style eqemu_config.xml and it wont connect to mysql

Without seeing the config file a random guess is you used localhost rather than 127.0.0.1.

Tried 4 ways:

and
Also tried an older version:

my error:

Need to use -- "127.0.0.1" like lerxst said :)

I see you posted that.. but what errors do you get when using "127.0.0.1" ?

Actually, I just performed a clean install on a new VM and this exact thing is happening.
Trying to figure out if I missed something or not. I do not make new servers so often that I have the process down 100% everytime.

10061 means the connection was actively refused. It sounds like MySQL is not running or it is running on a different port. Does the command line MySQL client connect properly?

let me clarify, i am not having maceblade's problems. I am getting the same results the OP did. I can connect to mysql just fine.
Never had this happen before. usually i miss a rule or something.

I am getting the same errors as Sorv and the OP. MYSQL is running on port 3306 I used netstat -ano and seen that it was, nothing else is, firewall is turned off, nothing is using port 9000. Switching back to the original eqemu config xml I get the same errors as Sorv and OP.

It pops up 4 screens and just hangs.

here are my logs:

Ok I am a fucking idiot... Mine was all in my eqemu config xml file... I had the wrong account in ...

As an update to my issue, I installed MySQL 5.6 not 5.1. I never had a problem using 5.5 last time I built a server from scratch so I assumed that 5.6 would work. Bad idea.

They changed the installer in 5.6 and some of the settings that are generally set by the guides are no longer present. I installed 5.1 and it works fine now. I will have to do testing when I have more time to figure out what is up with 5.6

A related note is that the new CMAKE log disable setting is really killing too much by default. A little more information than two lines of log would be much better to let people know things are actually connecting. The defaults if you turn it off ARE too much, I agree. Maybe tweak it a bit more so thing slike zone show zone X booting. but not the other lines that come out with it disabled. Same for world. let the console show connection from account x and connections from zone x but not all the related lines that the regular debug spew gives.

I'm using MySQL 5.6.14 but I just compile with the 5.1 dependencies from the git.

I let it auto detect everything. I did not check what it compiled with.