EQemu Login Server

nosfentora · #11 07-20-2009, 03:46 PM

Ok, unless i'm completely stupid and missed something critical... here's what i've done so far:

1 ) Pulled sources rev 800.
2 ) compiled 'release'
3 ) copied the new 'EQEmuLoginServer.exe' and release 'EQEmuAuthCrypto.dll' to a separate folder containing 'libmysql.dll','login_opcodes.conf,' and 'eqemulogin.ini'.

4 ) started 'EQEmuLoginServer.exe' and it seems to be ok:

Code:

EQEmuLoginServer

  Using Port: 5998
  Dumping Inbound packets.
  Dumping Outbound packets.
  Tracing ON.
  Database Server: localhost
  Database Catalog: login


Server (TCP) listener started.

5 ) created a new database 'login', and sourced 'EQEmuLoginServerDBInstall.sql'

6 ) in 'tblloginserveraccounts' i created an account entry using

Code:

insert into tblLoginServerAccounts 
(AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) 
values ('nosfentora', sha('obviouslynotmypassword'), 'myemail@yahoo.com', now(), '192.168.1.105');

7 ) in 'tblserveradminregistration' i added an entry

Code:

insert into tblserveradminregistration (Accountname,AccountPassword,FirstName,LastName,Email,RegistrationDate,RegistrationIPAddr)
values ('nosfentora','obviouslynotmypassword','MyName','MyLastName','MyEMail@yahoo.com',now(),'192.168.1.105');

8 ) in 'tblworldserverregistration' i added an entry

Code:

insert into tblworldserverregistration
(ServerID,ServerLongName,ServerTagDescription,ServerShortName,ServerListTypeID,ServerLastLoginDate,ServerLastIPAddr,ServerAdminID,Note)
values
('1','LongNameFromConfig','Blah','ShortNameFromConfig','3',now(),'192.168.1.105','1','');

where the ServerAdminID=1, from 'tblserveradminregistration', ServerAdminID

9 ) In my eqemu db, in 'account' i added an entry
with the lsaccount_id=1, and status=250
where lsaccount_id=1=LoginServerID from 'tblloginserveraccounts'

10 ) I modified my 'eqemu_config.xml' to read

Code:

<loginserver>
<host>localhost</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

11 ) fired up world and

Code:

[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: localhost:5998

the login server spits out a bunch of text about 'Updating stats for server'

Code:

Received server Opcode:     1001, Size: 12
   0: FE FF FF FF 00 00 00 00 - 00 00 00 00              | ............
ServerOP_LSStatus:   Status: -2  Players: 0    Zones: 0

so far, i think, so good.....

12 ) edit and save my eqhost.txt:

Code:

[LoginServer]
Host=192.168.1.103:5998

13 ) fire up SoF client..., login using user/pass created in step 6 and see my server in the list!

Yea!

or so i thought....

I select my server and click Play....

......

.......

This error pops up

Code:

'Error 1017: Cannot login to the EverQuest server.
You may need to re-run the Update Patch.
Repeatedly seeing this message indicates a loss of connectivity
to the Patch Server. This is usually temporary'

and then an empty server list.

Any ideas?