EQEmulator Forums - Issues Building a Local Server

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

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

- - Issues Building a Local Server (https://www.eqemulator.org/forums/showthread.php?t=37885)

Issues Building a Local Server

Hey everyone, new to the forums and EQEmu, old to EQ. I'm out deployed at the moment and there are a few of us that enjoy EQ, have access to a closed network (no outside access) and would like to setup a local EQEmu site. I followed the Windows Server guide and then edited it with the LAN setup guide and am still having some issues. Basically, when I login to my client, located on the same computer as the server, I can't see any servers in the server select screen. BTW, I'm not worried about the exposed passwords or IPs as like I said, I'm on a closed network and I'll probably just change the passwords in the end.

I have a ton of information, so I'll post what I've seen others post in their cries for help:

EQEmuConfig:

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






<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>Admin</account>
<password>password</password>
</loginserver>






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


<key>some long random string</key>


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


<chatserver>
<host>192.168.1.200</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>192.168.1.200</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


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


<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>password</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>password</password>
<db>peq</db>
</qsdatabase>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

Login.ini

[database]
host = 127.0.0.1
port = 3306
db = login
user = root
password = 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 = 5999
local_network = 192.168.1.200

[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

Log File login_1393021465

[Debug] [02.21.14 - 14:24:25] Logging System Init.
[Debug] [02.21.14 - 14:24:25] Config System Init.
[Debug] [02.21.14 - 14:24:25] MySQL Database Init.
[Debug] [02.21.14 - 14:24:25] Encryption Initialize.
[Debug] [02.21.14 - 14:24:25] Encryption Loaded Successfully.
[Debug] [02.21.14 - 14:24:25] Server Manager Initialize.
[Network] [02.21.14 - 14:24:25] ServerManager listening on port 5999
[Debug] [02.21.14 - 14:24:25] Client Manager Initialize.
[Network] [02.21.14 - 14:24:25] ClientManager listening on Titanium stream.
[Network] [02.21.14 - 14:24:25] ClientManager listening on SoD stream.
[Debug] [02.21.14 - 14:24:25] Server Started.
[Network] [02.21.14 - 14:26:46] New SoD client connection from 127.0.0.1:62076
[Network] [02.21.14 - 14:26:46] Application packet received from client (size 14)
[Network] [02.21.14 - 14:26:46] Session ready received from client.
[Network] [02.21.14 - 14:26:46] Application packet received from client (size 28)
[Network] [02.21.14 - 14:26:46] Login received from client.
[Client] [02.21.14 - 14:26:46] User: phil
[Client] [02.21.14 - 14:26:46] Hash: 5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8
[Network] [02.21.14 - 14:26:51] Client disconnected from the server, removing client.
[Network] [02.21.14 - 14:26:51] New SoD client connection from 127.0.0.1:62077
[Network] [02.21.14 - 14:26:51] Application packet received from client (size 14)
[Network] [02.21.14 - 14:26:51] Session ready received from client.
[Network] [02.21.14 - 14:26:51] Application packet received from client (size 28)
[Network] [02.21.14 - 14:26:51] Login received from client.
[Client] [02.21.14 - 14:26:51] User: phil
[Client] [02.21.14 - 14:26:51] Hash: e888d2bd6f13f82caa51a37c03d034c76f661ba3
[Network] [02.21.14 - 14:26:51] Application packet received from client (size 12)
[Network] [02.21.14 - 14:26:51] Server list request received from client.
[Network] [02.21.14 - 14:27:52] Application packet received from client (size 12)
[Network] [02.21.14 - 14:27:52] Server list request received from client.

Any help would be appreciated. I also have screenshots of my DB that I can share, just have to find something to host the pics.

Phil

This is my 5 windows pre-login:

http://imageshack.com/a/img812/9351/jrd4.jpg

This is what it looks like when I login:

http://imageshack.com/a/img43/3189/4wkm.jpg

This is what my databases look like:

http://imageshack.com/a/img703/4407/ivh2.jpg

Top 3 are Login and bottom 3 are PEQ

From a brief glance, it looks like the server admin registration info doesn't match the one in the XML config file. Also, if the long/short names are case-sensitive (I'm not sure), then you have a problem there as well.

Edit: On a second glance, it looks like the login server port in your XML file doesn't match the listen port of the actual login server.

Ahh...nice catch. Those are easy fixes. I've rebuilt the database probably twenty times, so I don't think that's the problem, but it can't be helping. It's close to midnight here, but I'll fix that first thing tomorrow morning my time and repost. Thanks a lot for looking it over. Hopefully it's that easy.

No problem.

I edited my previous post with another possible solution. If those are your only problems, then you should have the server up and running in no time.

Ok, so I fixed the easy things that we talked about first and as I suspected, they didn't fix the problem, but definitely needed to be fixed. Once that was done, I changed the loginserver port to 5999 from 5998 and boom, my server showed up and I can login now. Thanks so much for the help Vexyl. Next step is to get bots working. I'll search the bots area a bit before I start bugging people about that though. The hard part is done now. Thanks again!

I personally don't remember the last time that 'load_bot.sql' was updated, so sourcing in the correct revisions can be a bit tricky...

But, it can be done :)

I actually got the bots working. I had to do more than the load_bot.sql though. It required a change to the load_bot.sql and then I had to source two other sqls, the hpandmana one and then one other. I'll update this post with that information as soon as I rebuild, that way I have the exact file names and all that. At the moment I am working on getting the mercs to work, which I found a post for that, so it's been an interesting time going through all of the old posts. I've definitely learned more than I ever knew about sql databases...lol.

pfev1980, I am monitoring your/this post for both mercs and bots are incomplete tasks for me to complete on my source 2/15/2014 build.

What reference are you using for the mercs?

Hey Yummy, I'm rebuilding right now on our server machine, I had been using my personal computer until I got everything right. I'll post exactly how to get the bots to work once I am done with that. The mercs didn't work so well. I can get them to show up at the vendors, but I can't get the mercs to actually spawn. I get the fabled "Merc failed to spawn" error. This is the reference I used to load them:

http://eqemulator.org/forums/showthr...ight=mercs.sql

I got a few errors when I tried to load the scripts into my database, but that probably has something to do with me trying some other stuff before I tried that. So, when I finish my clean install, I'll try again and see how it goes.

Pfev,

You may have already moved on.. but if not.

I have mercs and bots working. Testing now and except for bots and zoning, they seem to behaving.

I used the following SQL files in the order listed after compiling from git, Feb 15 2014. One of the puzzling things for me is knowing which needs to be done first for bots.sql and mercs.sql. I simply followed someone else's post and hoped for the best.

Bots:
/utils/sql/svn/bots.sql
/utils/sql/svn/2087_required_bots_hp_and_mana_and_spell_updates.s ql
/utils/sql/svn/2107_required_bot_stances.sql
/utils/sql/svn/2164_require_bots_bottimers.sql

Mercs:
/utils/sql/svn/2383_required_group_ismerc_rule
/utils/sql/svn/2380_optional_merc_rules
/utils/sql/svn/2380_optional_merc_merchant_npctypes_update
/utils/sql/svn/2380_optional_merc_data
/utils/sql/svn/mercs.sql

/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT
/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment
/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells

Feel free to comment or make suggestions. No idea if I did it correctly, but working, mostly.

Quote:

Originally Posted by Yummy (Post 228733)

Bots:
/utils/sql/svn/bots.sql
/utils/sql/svn/2087_required_bots_hp_and_mana_and_spell_updates.s ql
/utils/sql/svn/2107_required_bot_stances.sql
/utils/sql/svn/2164_require_bots_bottimers.sql

For the sake of not spreading misinformation, the above bots and *.sql is wrong or incomplete. I am still attempting to identify, install, and test.

There have been a number of posts regarding the current peqdb and bots but none that I have stumbled across give the complete details. For example, a couple posts cite folks are using bots.sql not load_bots.sql from the old peqdb svn. However, between the svn and git, what should follow?

I can figure it out by trial and error but I would rather be playing. :)
Guidance would be appreciated.

PEQ has never supported bots. This was maintained by someone that is now inactive.

Please Do Not Use The Eqemu Git Repo Version Of 'bots.sql' At This Time

'/utils/sql/svn/bots.sql' is the wrong version of the bot sql file...

PLEASE DO NOT USE THE EQEMU GIT REPOSITORY VERSION OF THIS FILE TO LOAD BOT DATABASE INFORMATION AT THIS TIME.

The correct bot script file is located at the old google svn for the peq database and is entitled 'load_bots.sql' - not 'bots.sql.'

I believe the correct svn address of the old database repo is what is listed in the current guide.

Yes, we know this is an issue..and yes, we are working on it.

Bots and Mercs are not one in the same...

I do believe mercs are (going to be) supported by peqtgc..and, therefore, will be incorporated into the daily dump once they are fully
ironed out.

Bots, on the other hand, are not a functional part of the 'live' experience..so, they will not be incorporated unless the peq admins
decide to do so.

Either way, please look for posts related to this subject if you are affected by this issue.

And, as sorvani stated, these are not maintained by peqtgc personnel.

Sorvani and Uleat,

Good information and I appreciate the clarification on bot support.