Loginserver Blank :(

nopsled · #1 02-11-2015, 03:20 AM

Hi I was wondering if anyone could help me figure this out. So close!
I went ahead and did a clean install and set up the server using the Public Login Server Guide on windows 32 bit (for the sake of simplicity)

Compiled everything INCL loginserver and followed it step by step. No compile errors. Sourced everything in my required folder sourced the login_table.sql
Everything went good.

Now... the issue is that my server is not showing up in the list when I log in the client.
(Eqhost is pointed to 127.0.0.1:5999)
(Also it says I have 0 out of 0 expansions; not sure if this is relevant)

Currently using most up to date from github.
peqbeta_2014-09-25-02-01
Quests: REV1827
Maps: REV49
Using Titanium Client patchme method.

-------------------------------------------------------------------
This is what my loginserver is now telling me:
-------------------------------------------------------------------
[Debug] [02.11.15 - 02:00:45] Logging System Init.
[Debug] [02.11.15 - 02:00:45] Config System Init.
[Debug] [02.11.15 - 02:00:45] MySQL Database Init.
[Debug] [02.11.15 - 02:00:45] Encryption Initialize.
[Debug] [02.11.15 - 02:00:45] Encryption Loaded Successfully.
[Debug] [02.11.15 - 02:00:45] Server Manager Initialize.
[Network] [02.11.15 - 02:00:45] ServerManager listening on port 5998
[Debug] [02.11.15 - 02:00:45] Client Manager Initialize.
[Network] [02.11.15 - 02:00:45] ClientManager listening on Titanium stream.
[Network] [02.11.15 - 02:00:45] ClientManager listening on SoD stream.
[Debug] [02.11.15 - 02:00:45] Server Started.
[Network] [02.11.15 - 02:00:48] New world server connection from 127.0.0.1:50000

[Network Error] [02.11.15 - 02:00:48] Handle_NewLSInfo error, remote address was
null, defaulting to stream address 127.0.0.1.
[World] [02.11.15 - 02:00:48] Server NopSledEQ(nops) successfully logged in.
[Network] [02.11.15 - 02:01:28] New SoD client connection from 127.0.0.1:57867
[Network] [02.11.15 - 02:01:28] Application packet received from client (size 14
)
[Network] [02.11.15 - 02:01:28] Session ready received from client.
[Network] [02.11.15 - 02:01:28] Application packet received from client (size 12
)
[Network] [02.11.15 - 02:01:28] Server list request received from client.
[Network] [02.11.15 - 02:01:39] Client disconnected from the server, removing cl
ient.
[Network] [02.11.15 - 02:05:30] New Titanium client connection from 127.0.0.1:58
727
[Network] [02.11.15 - 02:05:30] Application packet received from client (size 14
)
[Network] [02.11.15 - 02:05:30] Session ready received from client.
[Network] [02.11.15 - 02:05:52] Client disconnected from the server, removing cl
ient.
------------------------------------------------------------------
Also mentions it recieved my account login from client however the list is blank
-------------------------------------------------------------------

Here is my World:
------------------------------------------------------------------
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver 127.0.0.1:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_3932.log'
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[MySQL Error] 1146: Table 'peq.vwbotcharactermobs' doesn't exist
SHOW CREATE VIEW `vwBotCharacterMobs`
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files\MySQL\MySQL Server 5.1\bin/mysql
================================================== ==========
Binary Database Version: (9076)
Local Database Version: (9076)

Database up to Date: Continuing World Bootup...
================================================== ==========
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[World Server] Deleted 0 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
[World Server] New TCP connection from 127.0.0.1:50001
[World Server] New TCP connection from 127.0.0.1:50004
[World Server] New TCP connection from 127.0.0.1:50005
[World Server] New TCP connection from 127.0.0.1:50007
[World Server] New TCP connection from 127.0.0.1:50009
[World Server] New TCP connection from 127.0.0.1:50011
[World Server] New TCP connection from 127.0.0.1:50013
[World Server] New TCP connection from 127.0.0.1:50015
And then it sits like this and says sleeping in eqlaunch
-----------------------------------------------------------------

Any Ideas?

epilz · #2 02-11-2015, 12:32 PM

Do you have the ports forwarded on your router?

nopsled · #3 02-11-2015, 11:06 PM

Not currently. My client is on the same PC as my server.

Riklin · #4 02-12-2015, 02:09 AM

I'm assuming you are referring to the local login server?

The issue is most likely in how you configured the 4 tables.

tblloginserveraccounts
tblserveradminregistration
tblserverlisttype
tblworldserverregistration

Combine this set up with the login.ini and the eqemu_config.xml file and it can be confusing. Trust me, it took me a while. Follow the instructions as laid out in the loginserver setup guide:
http://wiki.eqemulator.org/p?Windows...er_Setup_Guide

The database db, user and password are what you assigned to your database. This same information also needs to be entered in your eqemu_config.xml.

For the host addresses, just use 127.0.0.1 use that for the addresses in the eqemu_config file as well as the host in the login.ini.

Now this is critical and really easy to overlook... The account and password on the loginserver needs to be the same account and password you used in the tblserveradminregistration table! THAT IS CRITICAL! Without it, your server will only show up once, because the information in the database won't match what is in the database.
account needs set to the AccountName from the tblserveradminregistration table.
password needs to be set to the AccountPassword from the tblserveradminregistration table.
<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>AdminAccountName</account>
<password>AdminAccountPassword</password>
</loginserver>

Once again, for all the address or ip= or host addresses, use 127.0.0.1. Even set the chat and mail to 127.0.0.1!

One last thing, use the SQL script from the login server setup guide to set up your loginserver accounts. It must encrypt the password and that script does it nicely. This may be an issue with my specific set up, but I found it works best if you create an account with a name that does not exist on your server already.

That is what I have learned from spending 4 days getting that login server to work...

Riklin (HallsHavoc)

nopsled · #5 02-12-2015, 04:28 PM

Will check into it when I get back home and report back. Thanks!

nopsled · #6 02-12-2015, 05:03 PM

Alright upon inspection of my tables everything checks out.

I have verified that every entry is correct and in accordance to the guide. SQL is not really difficult for me to work with as I have ran multiple servers over the years and have had a few different EQEmu ones but it seems like once everything was moved over to GIT I haven't had much success when it comes to actually getting the clients to connect.

Every IP has been set to 127.0.0.1 and it seems to be connecting and logging in fine between the applications however when I use my client it just simply is not showing it in the list but it says its connected and acknowledged in the actual server.

I did encrypt the server password and copy the hash over as the password and it connects and says my server is there but its still not showing up in the list.

I'm stumped at this point. Im starting to think this may be a client sided issue.

Side note: I know minilogin is deprecated... but i did try it out last night in a cloned server folder and that still did not work with my client. However it did say I had all of the expansions whereas with the self compiled loginserver it says i have 0 out of 0.

I am half tempted to try it out with the RoF2 client and see if it will work.

epilz · #7 02-12-2015, 08:16 PM

oh you are using local login server instead of EQMUs?

nopsled · #8 02-12-2015, 09:22 PM

Yep yep!

Still havent quite figured it out. It seems like its working I just don't understand why its not listed or why eqtitanium says i have 0 out of 0 expansions x.X

epilz · #9 02-12-2015, 10:08 PM

Can you post your login.ini file?

Did you copy the login.ini and opcodes files to your EQEmuServer folder or where ever you have it stored?

Why not download UF or ROF2 to test? Make sure those opcodes are in the folder above too.

nopsled · #10 02-13-2015, 02:40 PM

[database]
host = 127.0.0.1
port = 3306
db = peq
user = root
password = **********
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I updated the opcodes from eqemuupdate option 5. But im not sure if I copied them from anywhere? i do recall copying the opcodes from the source folder into the eqemu folder though as depicted in the guide.

does the eqemuupdate replace them directly into the eqemuserver folder or do i have to copy them from somewhere after running option 5

**Uleat** · #11 02-13-2015, 06:55 PM

It looks like you're doing a solo server..

[login.ini]

Code:

local_network = 192.168.1.

change to:

Code:

local_network = 127.0.0.

nopsled · #12 02-13-2015, 07:23 PM

didnt work with titanium but tried ROF2 client and it worked! thank you so much! I overlooked that tidbit!

**Uleat** · #13 02-13-2015, 08:45 PM

Make sure that your Titanium eqhost is pointing to 127.0.0.1:5998 or it will not log in.

nopsled · #14 02-13-2015, 10:25 PM

Quote:

Originally Posted by Uleat

Make sure that your Titanium eqhost is pointing to 127.0.0.1:5998 or it will not log in.

makes sense haha. Now that ive tried the ROF2 client I don't think I could go back to the old one! :P everything is working perfectly from what I can see.

thank you!