• Can't connect to minilogin server

Posted: **Thu Jan 17, 2013 2:11 pm**

Hi all, looking for some help here....

I've been looking through the forums all day, and haven't found an answer yet so here I am asking....

I haven't logged in or ran an EQ2 server in quite some time, so it took me a while to get things going, but I finally got (almost) everything ironed out.
I pulled all three SVN's today (code, content, tools), Jan 17th 2013 and created a new eq2 folder. (I don't have my old one to refer to anymore)

After setting up the db.ini's and the loginserver.ini, I ran EQ2World_x64 several times successfully, until it stopped updating.
I have 2 separate databases, eq2 (from the world.exe) and eq2_login2 from the eq2logindb.sql.

Running the mini-LS, it seems to be fine and sits waiting a connection.
Ran EQ2World_x64 and I get an error connecting to the login server... "E World: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'"

I've been searching the forums and can't find anything relating to my situation ... I tried to change the login server port from 9100 to 9200 and viola! world connects to the mini-LS. (after adding the new login_versions entry)

However the client can't as far as i can tell.

I ran netstat to see if there was already something using port 9100.... nope. In fact, port 9100 isn't being listened on at all - even when both the LS and WS are running.... which was the weirdest thing I found.

Changing the port to 9200 and running LS and WS, port 9200 shows up in the netstat list....

Any thoughts?

Win7 x64 Ultimate, mysql, server and client are all on same machine.

Below are logs, loginserver.ini and contents of EQ2 folder. Let me know if i missed anything.

LoginServer.ini

Code: Select all

[LoginServer]
loginserver=localhost
loginport=9100

worldname=Minilogin
worldaddress=70.xxx.xxx.218
internalworldaddress=localhost
worldport=9000

locked=false

account=xxxxxx
password=xxxxxx

autotableupdates=never
autotableverbose=false
autotabledata=false

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9103

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

EQ2World_x64 log

Code: Select all

15:53:17 I Init: Starting EQ2Emulator WorldServer...
15:53:17 I DB: Using database 'eq2' at localhost
15:53:17 I World: Loading System Data...
15:53:18 I World: Loaded System Data (took 1 seconds)
15:53:18 I Spawn: Initializing Spawn Subsystem...
15:53:18 I Spawn: Initialize Spawn Subsystem complete (took 0 seconds)
15:53:18 W Reformat: JA: This is as far as I got, don't panic!
15:53:18 I Items: Loading Items...
15:53:18 I Items: Loaded 2 Total Items (took 0 seconds)
15:53:18 I Spells: Loading Spells...
15:53:18 I Spells: Loaded 124 Spells (took 0 seconds)
15:53:18 I Traits: Loading Traits...
15:53:18 I Traits: --Loaded 147 Trait(s)
15:53:18 I Quests: Loading Quests...
15:53:18 I Collect: Loading Collections...
15:53:18 I Guilds: Loading Guilds...
15:53:18 I Guilds: 	Loaded 0 Guild(s)
15:53:18 I Recipes: Loading Recipe Books...
15:53:18 I Recipes: Loading Recipes...
15:53:18 I Titles: Loading Titles...
15:53:18 I Languages: Loading Languages...
15:53:18 I Chat: Loading channels...
15:53:18 I Merchants: Loading Merchants...
15:53:18 I LUA: Loading Spawn Scripts...
15:53:18 I LUA: Loading Zone Scripts...
15:53:18 I Net: World server listening on: 70.xxx.xxx.218:9000
15:53:18 I Net: World server listening on: localhost:9000
15:53:18 I Zone: Starting static zones...
15:53:18 I Console: Type 'help' or '?' and press enter for menu options.
15:53:19 E World: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'

MiniLogin log

Code: Select all

===[ New log 'logs/2013-01-17_eq2login_2104.log' started ]===


15:52:08 I DB: Using database 'eq2_login2' at 127.0.0.1
15:52:08 I Login: =====================================
15:52:08 I Login: Initializing LoginServer...
15:52:08 I Login: LoginServer.ini read.
15:52:08 I Login: Loading opcodes...
15:52:08 D DBCore: Query Successful, 5 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:08 D DBCore: Query Successful, 41 rows returned
15:52:09 I Login: Loading Structs... SUCCESS!
15:52:09 I Login: Loading world list...
15:52:09 D Login: Resetting World Stats...
15:52:09 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldstats set world_status=-4, current_players=0, current_zones=0
15:52:09 I Login: Login server listening on port: 9100

Contents of EQ2 root folder:

Code: Select all

05/28/2011  01:23 PM            14,890 CommonStructs.xml
12/21/2011  10:02 AM         2,520,379 eq2logindb.sql
12/31/2011  02:00 PM         1,958,400 EQ2Minilogin.exe
01/14/2013  09:17 AM         3,386,368 EQ2World.exe
01/14/2013  09:17 AM         5,563,904 EQ2World_x64.exe
01/17/2013  02:27 PM    <DIR>          ItemScripts
07/31/2012  04:12 PM           153,669 ItemStructs.xml
01/17/2013  03:40 PM               474 LoginServer.ini
05/28/2011  01:23 PM            13,270 LoginStructs.xml
01/17/2013  02:07 PM               264 login_db.ini
01/17/2013  03:41 PM    <DIR>          logs
01/17/2013  02:33 PM             3,045 log_config.xml
01/17/2013  02:27 PM    <DIR>          Quests
12/21/2009  05:32 PM             1,861 README.TXT
01/17/2013  02:27 PM    <DIR>          SpawnScripts
07/17/2012  08:16 PM            88,400 SpawnStructs.xml
01/17/2013  02:27 PM    <DIR>          Spells
08/05/2012  06:38 PM           456,242 WorldStructs.xml
01/17/2013  01:57 PM                74 world_db.ini
06/22/2008  04:04 PM            98,304 zlib.dll
01/17/2013  02:27 PM    <DIR>          ZoneScripts

Posted: **Thu Jan 17, 2013 2:23 pm**

Well, appending :9200 to the eq2_defaults LS line seemed to work so I guess 'problem solved'...

Posted: **Thu Jan 17, 2013 4:33 pm**

If you are using Minilogin and not our Public LoginServer, you should use your private IP addresses, not your public one (70.xxx)

Code: Select all

[LoginServer]
loginserver=127.0.0.1
loginport=9100
worldname=Minilogin
worldaddress=127.0.0.1
# internalworldaddress=
worldport=9000
locked=false
account=your_minilogin_name
password=your_minilogin_pass
autotableupdates=always
autotableverbose=false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=127.0.0.1
updateserverport=9103

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

[LogConfig]
logfile=log_config.xml

and your cl_login_address should be 127.0.0.1

Check out our Releases for ServerPacks which are turn-key systems, they will give you the best examples of how to run a local setup (non-public). Also in the serverpack release is the Admin Guide, which may help as well.

Posted: **Thu Jan 17, 2013 4:35 pm**

Code: Select all

worldname=Minilogin
worldaddress=70.xxx.xxx.218
internalworldaddress=localhost
worldport=9000

worldaddress=70.xxx.xxx.218 should be localhost or (127.0.0.1) for minilogin

Posted: **Fri Jan 18, 2013 7:46 am**

@John Adams,@Zcoretri

I believe I tried that as well, and just verified it now.

Changing my 'worldaddress' to 127.0.0.1 or localhost has the same effect of giving the error

"E World: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'"

@JohnAdams - I did get the last server pack and played around with it a bit. Had no luck with that one either, however the .ini's and admin guide did give me some more info to work with before posting.

My cl_login_address is 127.0.0.1, i just had to modify it to
127.0.0.1:9200 to get the client to attempt to connect.

The connection was rejected as on this machine I don't have any of the working clients - just the Steam F2P client right now - but at least it seems to work.
I forgot to grab my retail discs from home to try.

Posted: **Fri Jan 18, 2013 11:04 am**

If you are able to connect now which if I understand correctly you can, but you are getting client errors do this:

1. In your login db edit your login_versions table and add another row with 0.7.2-dev in the version column.

2. Change the login_version value in your worldservers table to the same (not sure if this is required but it won't hurt)

3. Run this query to replace your opcodes in your logindb with a copy of the codes from your worldserver (replacing eq2ls and eq2world as the respective schema names if required)

Code: Select all

DROP TABLE eq2ls.opcodes;
CREATE TABLE eq2ls.opcodes LIKE eq2world.opcodes;
INSERT eq2ls.opcodes
SELECT *
FROM eq2world.opcodes;

note: These instructions are assuming you are using the svn build and not server pack, although I have had issues with the latest minilogin.exe

Posted: **Fri Jan 18, 2013 11:14 am**

@thefoof

Thanks for the reply,

I believe I'm getting client errors due to the fact that the only client I have installed on this machine is from Steam F2P build 8425L, which to the best of what I can find on the wiki and forums, is not yet supported.

I didn't explicitly state what I did but in the OP i stated

... I tried to change the login server port from 9100 to 9200 and viola! world connects to the mini-LS. (after adding the new login_versions entry)

meaning i did add the 0.7.2-dev to the login_versions (your #1 and #2)

and yes, i'm using the SVN as my base, not the repacks.

Edit:
I didn't explicitly perform your #2, it was updated automatically after changing the port from 9100 to 9200 and successfully connecting the world server to the login server.

Posted: **Fri Jan 18, 2013 11:22 am**

That's strange, the current live build is closer to 9552L and should be compatible, I don't use steam to update I use sony's eq2.exe so try that maybe? You should be able to get the whole client even if you are f2p. If you do have crashes with the latest minilogin after you get this working, pull revision 1908 from the svn it is stable and will still work with the latest db and structs

UPDATE: I just checked and when I pulled older versions they wouldn't work for me either..if all else fails here is a copy of my working exe:
http://www.mediafire.com/?22he1fkqb0fv3ba

Posted: **Fri Jan 18, 2013 12:35 pm**

The version from steam is 1184, when we started working on getting CoE compatible it was at 1188, while the changes between the 2 are probably minimal we don't have the opcodes or structs for it so the steam version will not work currently.

The live client should connect and mostly work though.

As for why your mini login is listening on port 9200 and not 9100 I have no clue, all the configs look right from quickly glancing over it. As for the client, it will always try to connect to port 9100 by default so if the port is diffrent for the loginserver it needs to be specified, wich you already figured out.

Posted: **Mon Jan 21, 2013 6:37 am**

@thefoof

I never updated the client, it's the same as the day it was installed the 1st time. Like I said, it's been a long time since i tried running the emu. I'm sure there's something else I'm doing wrong.
I'll pull the SVN again and start from scratch again and see what I can figure out - or at the very least maybe try using one of the repacks. Getting things up and running is half the fun of the learning experience!

Maybe I'll backup the client and update it and see what happens.

Again, I'm probably missing something somewhere along the line.

@Jabantiz

It's strange - I'm now getting errors trying to run EQEmu (EQ1) when it tries to connect (i think to 9100 as well) so I don't think the port problem is part of EQ2Emu, it has to be my local machine, but I have no idea what changed. I'm going to try and run it in a VM when I get a chance and see what happens.

So far everything seems stable - I haven't gotten any crashes - other than my initial attempts, which was just missing .ini / struct files.

Can't connect to minilogin server

Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server

Re: Can't connect to minilogin server