Cannot connect to server

wolvenbane · #1 09-13-2010, 09:56 PM

Hi guys. I've set up a server to play across my LAN with the ultimate goal of offline-only play. I used Vales Wiki guide and followed it to the letter. The server starts up but I can't get in to the game.

From the server computer, I can log in but the server list is empty. From the other two computers I can't even log in (cannot connect to server error). I'm sure it's a setting somewhere that I've missed and would like your help.

EQ version: Titanium (legit copies I had from when I played on Live)
OS: Win XP (all three comps)
Server: EQEmu-Rev1612-Bots
DB: PEQ Rev 1589 (both DB and Quests)
IPs of comps (192.168.x.x): Server - 0.198, clients 0.199 and 0.197

eqemu-config.xml

Code:

<server>
<world>
<shortname>timewaster</shortname>
<longname>The Time Waster</longname>

<!-- address has to be specified for minilogin to work -->
<address>192.168.0.198</address>
<localaddress>192.168.0.198</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>192.168.0.198</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are show -->
<tcp ip="192.168.0.198" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>longalphanumericstring</key>

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

<!-- Database configuration, replaces db.ini -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>mypass</password>
<db>peq</db>
</database>
</server>

eqemulogin.ini

Code:

Port=5998
DumpPacketsIn=true
DumpPacketsOut=true
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=peqlogindb
DatabaseUserName=root
DatabaseUserPassword=mypass
OPCodePathAndFileName=login_opcodes.conf

EQhost.txt on all three computers

Code:

[LoginServer]
Host=192.168.0.198:5998

Any help is appreciated. I've been pouring through the wiki and forums for two days now, changing settings trying various workarounds. Obviously nothing has worked yet so I'm asking for help.

Capheus · #2 09-14-2010, 03:36 AM

Everything up there looks ok. My best guess is you haven't added any accounts to tblserveraccounts. It won't let you login without them. I saw some code for automatic entries but I don't think its been implemented yet or its problably not in your version. The account names and passwords are case sensitive, so mind your caps.

wolvenbane · #3 09-14-2010, 03:50 AM

Thanks for the reply.

I have three entries in tblloginserveraccounts, the admin entry and two generic player entries. tblserveradminregistration has the full admin account. tblserverlisttype is filled out also. And the last one tblworldserverregistration looks correct as well.

On the server computer I can login with all three accounts. But when I get to the next screen (server list) it is blank. On the two client computers I cannot log in at all; they both get the 'cannot connect to server' error.

I made sure the router has the correct ports open (3306, 5998, 7000-7500, and 9000). I've tried port forwarding on the clients, port forwarding on the router, port forwarding on both clients and router, and no forwarding whatsoever. If the config files are correct I have to assume the problem is somewhere in the router then...but I'm at a loss what it could be.

Capheus · #4 09-14-2010, 05:04 AM

I see in your eqemu_config.xml you have the account and password left blank. Do you have something in there or is it blank?

A blank server select screen will result when your eqemu_config.xml account and password doesn't match the account and password in tblserveradministration. Putting in a password and account here will follow your entries in tblworldserverregistration.

If you leave the password and account with no entry in your eqemu_config.xml file like you are showing here, your server will default to using the eqemu_config.xml entries for server shortname and longname. The server will display as a normal server.

The following entry in your eqemu_config.xml is something I am not using and not familiar with.

Code:

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are show -->
<tcp ip="192.168.0.198" port="9000" telnet="disable"/>

wolvenbane · #5 09-15-2010, 07:19 PM

Okay I uninstalled/reinstalled everything and followed the guide again. I took out that line of code you had listed above; I thought it would help but obviously didn't.

I'm getting the same basic error. I have tried with and without the account/password filled in on the xml file. The world/zone/login servers report no trouble during the launch. When I run EQ I can login but no server shows up. I can even log in with an invalid uid/pw combo but it still 'logs in' and no server shows up. I changed all the IP info to localhost (am trying to get it running on the server computer only for now). I did this to ensure there wasn't anything weird on my router causing the trouble.

I'm guessing there's something wrong in the SQL tables maybe? Or perhaps the login server is connecting with the world but not connecting with the database correctly? Just seems strange that the server computer itself isn't working properly.

I've been staring at tutorials for emu and sql for the last couple days. My brain hurts now.

Capheus · #6 09-16-2010, 05:04 PM

If you can login with wrong password and stuff, then it sounds like you are using the minilogin and not using the eqemulogin. Do you have a start.bat to list or if not, what process/steps are you using to start your server?

wolvenbane · #7 09-17-2010, 04:02 AM

Here's the ServerStart.bat file:

Code:

@echo off
start EQEmuLoginServer.exe
start world
echo waiting for the world to finish before starting zone....
sleep 10
start eqlaunch zone

I've switched back to the LAN. I start the server on one computer, and when it's finished loading (it starts up zone: dynamic_5 and just sits there) I run EQ on a second computer. When I try to log in I can see the following:

Code:

New Client UDP connection from 192.168.0.199:4895
 0: 02 00 00 00 00 00 00 00 - 00 00 08 00                    | ............
 0: 02 00 00 00 00 00 00 00 - 00 01 65 00 00 00 00 43   | ..........e....C
16: 68 61 74 4D 65 73 73 61 - 67 65 00                       | hatMessage.
 0: 03 00 00 00 00 00 00 00 - 00 00                            | ..........
 0: 04 00 00 00 00 00 00 00 - 00 00 65 01 00 00 00 00   | ..........e.....
16: 01 00 00 00 31 39 32 2E - 31 36 38 2E 30 2E 31 39  | ....192.168.0.19
32: 38 00 30 00 00 00 01 00 - 00 00 54 68 65 20 54 69  | 8.0.......The Ti
48: 6D 65 20 57 61 73 74 65 - 72 20 28 4A 75 73 74 20  | me Waster (Just
64: 66 6F 72 20 66 75 6E 29 - 00 45 4E 00 55 53 00 02  | for fun).EN.US..
80: 00 00 00 00 00 00 00                                           | .......

So the server computer recognizes the incoming connection but doesn't do anything about it. The client computer shows no server in the list. Eventually it will just time out.

Capheus · #8 09-17-2010, 08:52 AM

It looks like the eqemulogin and the client aren't talking to one another. Double check to make sure that you have the login_opcodes.conf and EQEmuAuthCrypto.dll files are in the same directory as world.exe. And as always, make sure you have the correct ports opened up. I don't remember the exact numbers off the top of my head. I believe Trevius has them in his FAQ section.

This is what I see when I login

Code:

New Client UDP connection from 192.168.1.101:52309
   0: 02 00 00 00 00 00 00 00 - 00 00 08 00              | ............
Client OPCode:      184 Received
OP_Session_Ready
   0: 02 00 00 00 00 00 00 00 - 00 01 65 00 00 00 00 43  | ..........e....C
  16: 68 61 74 4D 65 73 73 61 - 67 65 00                 | hatMessage.
   0: 03 00 00 00 00 02 00 00 - 00 00 04 F2 F3 F0 C0 5D  | ...............]
  16: 11 55 48 FD F4 2B 63 A8 - 53 14 83 99 73 FE B1 32  | .UH..+c.S...s..2
  32: 7E FC                                              | ~.
Client OPCode:      185 Received
OP_Login
   0: 03 00 00 00 00 02 00 00 - 00 00 04 F2 F3 F0 C0 5D  | ...............]
  16: 11 55 48 FD F4 2B 63 A8 - 53 14 83 99 73 FE B1 32  | .UH..+c.S...s..2
  32: 7E FC                                              | ~.
User: Nightworker8
Hash: 8be3c943b1609fffbfc51aad666d0a04adf83c9d
Creating credential for account 2.
There are 1 credential record(s).
Output packet size is 90
   0: 03 00 00 00 00 02 00 00 - 00 00 0D 9F 27 9B A5 D8  | ............'...
  16: 72 60 86 45 0F C4 CB 6D - 44 90 0C 1A FF B8 B2 88  | r`.E...mD.......
  32: A5 A6 46 13 96 95 68 AC - DF 38 2B 02 BB DE 05 67  | ..F...h..8+....g
  48: 1C D0 E5 72 80 F3 DE F8 - F4 B2 A4 03 4C A6 4B B1  | ...r........L.K.
  64: 54 D8 96 D0 0E 16 50 11 - F2 A1 A4 03 4C C5 4B B1  | T.....P.....L.K.
  80: 54 D9 A2 E1 B7 DD 66 19 - 58 F7                    | T.....f.X.
   0: 04 00 00 00 00 00 00 00 - 00 00                    | ..........
Client OPCode:      186 Received
SERVER LIST Request

Packet Size is 74
   0: 04 00 00 00 00 00 00 00 - 00 00 65 01 00 00 00 00  | ..........e.....
  16: 01 00 00 00 31 39 32 2E - 31 36 38 2E 31 2E 31 30  | ....192.168.1.10
  32: 31 00 01 00 00 00 01 00 - 00 00 6D 79 77 6F 72 6C  | 1.........myworl
  48: 64 20 6C 6F 6E 67 20 6E - 61 6D 65 00 45 4E 00 55  | d long name.EN.U
  64: 53 00 02 00 00 00 00 00 - 00 00                    | S.........
Received server Opcode:     1001, Size: 12
   0: 00 00 00 00 00 00 00 00 - 05 00 00 00              | ............

wolvenbane · #9 09-18-2010, 02:43 AM

Yes, I got both of those files with the EMU server zip. They are in the same folder as the server exes. While I'm at it I'll just list all the files I have there.

C:\EQEMU\*
\Maps\* (folder)
\Quests \*(folder)
Chatserver.exe
EMuShareMem.dll
eqemu_config.xml
EQEmuAuthCrypto.dll
eqemulogin.ini
EQEmuLoginServer.exe
eqlaunch.exe
login_opcodes.conf
opcodes.conf
patch_6.2.conf
patch_Anniversary.conf
patch_Live.conf
patch_SoD.conf
patch_SoF.conf
patch_Titanium.conf
SeverStart.bat
spells_en.txt (from client)
spells_us.txt (from client)
World.exe
Zone.exe

Does it look like I'm missing any files? That would be a problem solver right there.

The login_opcodes.conf file looks like this:

Code:

#EQEmu Public Login Server OPCodes
OP_SessionReady=0x0001
OP_Login=0x0002
OP_ServerListRequest=0x0004
OP_PlayEverquestRequest=0x000d
OP_PlayEverquestResponse=0x0022
OP_ChatMessage=0x0017
OP_LoginAccepted=0x0018
OP_ServerListResponse=0x0019
OP_Poll=0x0029
OP_EnterChat=0x000f
OP_PollResponse=0x0011

I appreciate all your responses. Eventually I'm going to figure this out...and my head will stop throbbing...

Capheus · #10 09-18-2010, 12:27 PM

I've got a few more in mine listed below. You are going to want to go into your \quests folder and copy/paste \plugings to C:\EQEMU\plugins.

I'm running titanium and SoD out of the same directory so I'm not 100% sure the following files are needed or how and why they got there, its been a long time since I setup this directory.

Make a C:\EQEMU\logs directory. This will log everything and might help to identify your problem.

worldui.pl
commands.pl
plugin.pl
mime.types
mail_opcodes.conf
login_opcodes_sod.conf

Capheus · #11 09-18-2010, 03:56 PM

First thing would be to focus on the mime.types file. If you are missing it, that could be your problem

Code:

<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>

Go to the link and grab the files listed there. You can skip the eqemuconfigs if you want.

http://code.google.com/p/projecteqem...utils/defaults

EDIT: Updated better URL

Capheus · #12 09-18-2010, 04:34 PM

Code:

09/18/2010  03:28 PM    <DIR>          templates
09/04/2010  05:32 AM    <DIR>          quests
09/04/2010  05:30 AM    <DIR>          plugins
09/04/2010  07:13 AM    <DIR>          Maps
09/18/2010  03:19 PM    <DIR>          logs
09/04/2010  05:24 AM    <DIR>          worldui
07/14/2009  04:29 PM         1,453,056 EQEmuLoginServer.exe
09/14/2010  03:03 AM               865 eqemu_config.xml
06/15/2010  07:55 AM             2,337 eqemu_config.xml.full
09/04/2010  04:47 AM           138,240 eqlaunch.exe
06/15/2010  07:55 AM                 0 log.ini
06/15/2010  07:53 AM               298 login_opcodes.conf
06/15/2010  07:53 AM               298 login_opcodes_sod.conf
06/15/2010  07:52 AM         2,208,768 EQEmuAuthCrypto.dll
06/15/2010  07:56 AM               300 mail_opcodes.conf
09/04/2010  08:56 AM           187,904 EMuShareMem.dll
06/15/2010  07:55 AM             1,077 mime.types
06/15/2010  07:55 AM            16,690 opcodes.conf
06/15/2010  07:56 AM            17,669 patch_6.2.conf
06/15/2010  07:56 AM            16,596 patch_Anniversary.conf
08/23/2010  04:40 AM            17,664 patch_Live.conf
08/23/2010  04:40 AM            17,486 patch_SoD.conf
08/23/2010  04:40 AM            21,919 patch_SoF.conf
08/23/2010  04:40 AM            18,406 patch_Titanium.conf
06/15/2010  07:55 AM                 0 plugin.pl
06/15/2010  07:55 AM                 0 commands.pl
09/04/2010  08:57 AM         1,852,416 Chatserver.exe
09/17/2010  06:58 AM               274 ServerStart.bat
03/26/2010  04:46 PM         2,149,759 spells_en.txt
03/26/2010  04:30 PM        13,877,326 spells_us.txt
09/04/2010  07:30 AM           311,735 changelog.txt
09/04/2010  08:11 AM         2,793,472 World.exe
09/14/2010  03:01 AM               220 eqemulogin.ini
06/15/2010  07:55 AM                 0 worldui.pl
09/04/2010  08:14 AM         5,452,800 Zone.exe

Visner · #13 09-19-2010, 02:48 PM

I was having this same problem. I got the opcodes from:
http://projecteqemu.googlecode.com/svn
and that fixed my problem. they should be in this folder:

\trunk\EQEmuServer\EQEmuLoginServer\login_util

wolvenbane · #14 09-22-2010, 05:43 AM

Quote:

Originally Posted by Visner

I was having this same problem. I got the opcodes from:
http://projecteqemu.googlecode.com/svn
and that fixed my problem. they should be in this folder:

\trunk\EQEmuServer\EQEmuLoginServer\login_util

PERFECT!

After downloading the independent opcodes and inspecting them, I found the one I got in the emu zip to be missing several lines. This totally fixed my problem. I am able to get into the game now.

Thank you SO MUCH guys for all the help. It was driving me crazy... Now, onto further craziness.