EQEmulator Forums - Pulling hair out.. no servers listed

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Pulling hair out.. no servers listed (https://www.eqemulator.org/forums/showthread.php?t=32977)

Pulling hair out.. no servers listed

Having the no servers listed. Server sees the login, sees requesting the server list, but it never seems to make it. Havent ever seen a server pop up.. Logs dont show any errors. Have tried pre-compiled server and also compiled my own. Dont have any idea where to even start. This is on a titanium setup, locally, so shouldnt be any issues with firewall / ports.

Have started and restarted client over and over since some people said it shows up for them when they restart it. Just inst happening..

Any ideas where to even start?

OK.. so.. I guess if you want your server to actually activate you have to enter that account / password in the .xml cofig file.. Never saw that listed anywhere or I missed it lol.. Anywho, have a LAN server up and running!!!

Can you give some more detail on how you solved this? I'm having a similar problem, but adding my login info in the .xml doesnt fix it. Maybe I put it in the wrong place? Talk about pulling hair out...

If you're using the EQEmuLoginServer, the values in the AccountName and AccountPassword columns of the table tblserveradminregistration must match the <account> and <password> entries in the <loginserver> section of your eqemu_config.xml for your world server to be listed by EQEmuLoginServer.

This my xml file. EXACTLY how it is, line for line, for my lan server.
I only changed one thing for this post, which is the database password.
Since my Lan server has been working, I have NEVER changed this file.

Code:

<?xml version="1.0">

<server>

        <world>

                <shortname>huppys</shortname>

                <longname>Huppys Little Norrath</longname>



                <!-- Only specify these two if you really think you need to.  (read: You don't) -->

                <address>192.168.1.100</address>

                <!-- <localaddress>70.61.222.38</localaddress> -->



                <!-- Loginserver information.  Defaults shown -->

                <loginserver>

                        <host>192.168.1.100</host>

                        <port>5999</port>

                        <account></account>

                        <password></password>

                </loginserver>



                <!-- Server status.  Default is unlocked -->

                <!--<locked/>-->

                <!-- <unlocked/> -->



                <!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->

                <tcp ip="localhost" port="9000" telnet="disable"/>



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

                <key>hujbyg6ygkbm7b7b</key>

                

                <!-- Enable and set the port for the HTTP service.  Defaults are shown -->

                <http port="9080" enabled="false" mimefile="mime.types"/>

        </world>



        <!-- Chatserver (channels) information.  Defaults shown -->

        <chatserver>

                <host>192.168.1.100</host>

                <port>10234</port>

        </chatserver>



        <!-- Mailserver (in-game mail) information.  Defaults shown -->

        <mailserver>

                <host>192.168.1.100</host>

                <port>10234</port>

        </mailserver>



        <zones>

                <defaultstatus>0</defaultstatus>



                <!-- Sets port range for world to use to auto configure zones -->

                <ports low="7000" high="7100"/>

        </zones>



        <!-- Database configuration, replaces db.ini.  Defaults shown -->

        <database>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>root</username>

                <password>xxxxxx</password>

                <db>peq</db>

        </database>



        <!-- Launcher Configuration -->

        <launcher>

                <!-- <logprefix>logs/zone-</logprefix> -->

                <!-- <logsuffix>.log</logsuffix> -->

                <!-- <exe>zone.exe or ./zone</exe> -->

                <!-- <timers restart="10000" reterminate="10000"> -->

        </launcher>



        <!-- File locations.  Defaults shown -->

        <files>

                <!-- <spells>spells_us.txt</spells> -->

                <!-- <opcodes>opcodes.conf</opcodes> -->

                <!-- <logsettings>log.ini</logsettings> -->

                <!-- <eqtime>eqtime.cfg</eqtime> -->

        </files>

        <!-- Directory locations.  Defaults shown -->

        <directories>

                <!-- <maps>Maps</maps> -->

                <!-- <quests>quests</quests> -->

                <!-- <plugins>plugins</plugins> -->

        </directories>

</server>

And this is my login.ini file

Code:

[database]

host = localhost

port = 3306

db = peqlogindb

user = root

password = xxxxx

subsystem = MySQL



[options]

unregistered_allowed = TRUE

reject_duplicate_servers = TRUE

trace = FALSE

world_trace = FALSE

dump_packets_in = FALSE

dump_packets_out = FALSE

listen_port = 5999

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

And this is my eqemulogin.ini file:

Code:

[LoginServer]

loginserver=192.168.1.100

loginport=5999

DumpPacketsIn=false

DumpPacketsOut=false

Trace=false

DatabaseServerName=localhost

DatabaseCatalogName=peqlogindb

DatabaseUserName=root

DatabaseUserPassword=xxxxx

OPCodePathAndFileName=login_opcodes_sod.conf

The way I solved it was just by deleting my PEQ database and starting over with a new PEQDB folder. Must have made an error in my mysql configuration the first time around or something.

Ok so here is my eqemu_config.xml

Code:

<?xml version="1.0"?>

<server>

<world>

<shortname>myworld</shortname>

<longname>myworld long name</longname>



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

<address>192.168.1.101</address>

<localaddress>192.168.1.101</localaddress>



<!-- Loginserver information. -->

<loginserver>

<host>192.168.1.101</host>

<port>5999</port>

<account>Nightworker8</account>

<password>Password</password>

</loginserver>



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

<key>blehblahblehblee</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>****</password>

<db>peq1667</db>

</database>

</server>

so like c0ncrete was saying to make it work I would need to setup my tblserveradminregistration found in the local database as such:

Code:

INSERT INTO `tblserveradminregistration` (`ServerAdminID`, `AccountName`, `AccountPassword`, `FirstName`, `LastName`, `Email`, `RegistrationDate`, `RegistrationIPAddr`) VALUES (2, 'Nightworker8', 'Password', 'J', 'c', 'j@j.COM', '2010-09-04 06:24:59', '192.168.1.101');

For my eqemulogin.ini, I would set it up like this (change your opcodes file to whatever version of EQ you are running, I am using Titanium here):

Code:

Port=5999

DumpPacketsIn=true

DumpPacketsOut=true

Trace=true

DatabaseServerName=localhost

DatabaseCatalogName=local

DatabaseUserName=root

DatabaseUserPassword=****

OPCodePathAndFileName=login_opcodes.conf

And eqhost.txt:

Code:

[LoginServer]

Host=192.168.1.101:5999

I don't think login.ini does anything, unless it was included recently.

Quote:

Originally Posted by Capheus (Post 196955)

I don't think login.ini does anything, unless it was included recently.

The login.ini is included with the EQEmuLoginServer binary download from here:

http://code.google.com/p/projecteqemu/downloads/list

From DEC 11th, 2010 (EQEmuLoginServer.rar)

It also allows both port logins (5998 for Titanium and 5999 for SoD+)