Thanks for putting this guide together Huppy, I really appreciate you taking the time to document all these steps, extremely helpful.
I finally got my lan server up and running successfully thanks to this guide and a few other helpful folks on these forums. I wanted to share my findings in setting this up in hope that someone can use my experience. Since my server setup was a while after this guide was written some things have changed slightly or were not exactly clear to me, so here are some my notes that may help others:
Setup date: 9/22/2011
EqEmu revision: 2018
Database revision: 1900 -- but this is no longer clear, the latest database updates are not labeled clearly like "peqdb_Rev1667.sql" but instead simply, "db_dump.sql" this is the file you need to setup the database.
1) After you get your database setup You need to run all the sql files in the following directory (if you setup as Huppy suggested):
C:\eqemusource\EQEmuServer\utils\sql\svn
any file that is after your database revision, 1900, so starting with file 1908_required_npc_types_definitions.sql up through
2004_charges_alt_currency.sql, you do not need to run the "optional" files.
2) There are a couple of sql update files that break the above rule, you need to run these two file even though they are less than 1900:
1711_account_restricted_aa.sql -- this fixed my login problems
1723_required_sql_corruption.sql -- you need this if you want BOTS
-- note we do not need the last line of 1723, it must have been added previously
3) eqemulogin.ini does not exist anymore, use login.ini instead populate like this:
[database]
host = localhost
port = 3306
db = PEQLoginDB
user = root
password = <yourpassword>
subsystem = MySQL
[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = FALSE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.0.100
4) eqemu_config.xml
Mine needed to be set up slightly differently than in the guide:
note replace 192.168.9.999 with your ip:
<?xml version="1.0">
<server>
<world>
<shortname>Huppys</shortname>
<longname>Huppys Little Norrath</longname>
<localaddress>192.168.9.999</localaddress>
<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>192.168.9.999</host>
<port>5998</port>
<account>Admin</account>
<password>Password</password>
</loginserver>
... the rest of the eqemu_config.xml file is as Huppy set up.
Thats all for now, have fun seting up =)