No Server Listed after login 0 of 0 expansions:

[aronnov]

First off I have done many searches over the last 72 hours on similar issues and none have appeared to be exactly like mine or worked for me.

Second off thank you to everyone on this site for the guides and info to help with this process. With that said i'm still doing something wrong that's preventing me from hosting an EQ server.

Also please note this server's intent is for just a LAN so if i need to do something different please let me know.

I followed the updated Windows Guide and have reached the point of starting the services, (EQEmuLoginSErver, World, and Zone)

Everything seems to work fine until i get to zone and maybe it's not even a problem but zone stops here everytime and never goes past it as seen below.



all the logs look perfect except for the one zone error:

[02.24. - 12:46:51] Starting Log: logs/eqemu_error_zone_2936.log
[02.24. - 12:46:51] Unable to load titles: SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set` from titles : #1054: Unknown column 'title_set' in 'field list'

I ran the source load_player.sql and the load_bots.sql so i'm not sure what i'm missing.

Is this error what's stopping the server list from generating?

I'll also attach my .xml and .ini information below. ANY help would be greatly appreciated.

This is the SQL Command I used to populate the world server entry:

INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `Note`) VALUES ('1', 'Everquest', 'EQ Server', 'EQ', '2', NULL, NULL, '1', NULL);

XML File:

<?xml version="1.0">
<server>
<world>
<shortname>Everquest</shortname>
<longname>EQ</longname>

<!-- Only specify these two if you really think you need to. (read: You dont) -->
<address>10.10.10.46</address>
<localaddress>10.10.10.46</localaddress>

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>10.10.10.46</host>
<port>5998</port>
<account>root</account>
<password>"My Password is typed here"</password>
</loginserver>

<!-- Server status. Default is unlocked -->
<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>some long random string</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>10.10.10.46</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>10.10.10.46</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7400"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>"My Password is Typed Here"</password>
<db>peq4</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>

eqemulogin.ini

Port=5998
DumpPacketsIn=true
DumpPacketsOut=true
Trace=true
DatabaseServerName=localhost
DatabaseCatalogName=peqlogindb
DatabaseUserName=root
DatabaseUserPassword="My Password is Here"
OPCodePathAndFileName=login_opcodes.conf
AllowUnregistered=true

Stares into your soul.....

[pfyon]

Looks like you need to source in 1057_titles.sql.

[aronnov]

Originally Posted by pfyon

Looks like you need to source in 1057_titles.sql.

I ran that and that got rid of my error.. but i still have 0 servers showing up... I know have perfect logs with 0 error messages... but no servers... zone.exe is still stopping just like the picture up above.. but no error messages in any log.

[aronnov]

I dont believe this.....

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>10.10.10.46</host>
<port>5998</port>
<account>root</account>
<password>"My Password is typed here"</password>
</loginserver>

was the problem. i had to remove the username and password from the eqemu_config.xml file.. i guess because that info is already in the .ini? anyways i updated to look like:

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>10.10.10.46</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

The server now shows up and works like it's suppose to.

[pfyon]

eqemuloginserver has issues authenticating servers it seems. I've only ever gotten it working allowing anonymous servers and no login/password too.