Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2014, 04:25 AM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default 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>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account>Admin</account>
<password>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="192.168.1.200" 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>192.168.1.200</host>
<port>7778</port>
</chatserver>

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

<zones>
<defaultstatus>20</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>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 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>

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 2
[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 2
[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
Reply With Quote
  #2  
Old 02-21-2014, 04:33 AM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default

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
Reply With Quote
  #3  
Old 02-21-2014, 12:23 PM
Vexyl
Hill Giant
 
Join Date: Oct 2009
Location: U.S.A.
Posts: 197
Default

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.
Reply With Quote
  #4  
Old 02-21-2014, 12:38 PM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default

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.
Reply With Quote
  #5  
Old 02-21-2014, 12:43 PM
Vexyl
Hill Giant
 
Join Date: Oct 2009
Location: U.S.A.
Posts: 197
Default

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.
Reply With Quote
  #6  
Old 02-22-2014, 02:46 AM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default

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!
Reply With Quote
  #7  
Old 02-22-2014, 03:04 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #8  
Old 02-22-2014, 08:51 AM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default

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.
Reply With Quote
  #9  
Old 02-22-2014, 11:59 AM
Yummy
Sarnak
 
Join Date: Feb 2014
Posts: 71
Default

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?
Reply With Quote
  #10  
Old 02-22-2014, 11:48 PM
pfev1980
Fire Beetle
 
Join Date: Feb 2014
Posts: 7
Default

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.
Reply With Quote
  #11  
Old 03-09-2014, 12:06 PM
Yummy
Sarnak
 
Join Date: Feb 2014
Posts: 71
Default

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.
Reply With Quote
  #12  
Old 03-12-2014, 02:05 PM
Yummy
Sarnak
 
Join Date: Feb 2014
Posts: 71
Default

Quote:
Originally Posted by Yummy View Post
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.
Reply With Quote
  #13  
Old 03-12-2014, 03:29 PM
sorvani
Dragon
 
Join Date: May 2010
Posts: 966
Default

PEQ has never supported bots. This was maintained by someone that is now inactive.
Reply With Quote
  #14  
Old 03-12-2014, 04:23 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Exclamation 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.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #15  
Old 03-14-2014, 12:31 PM
Yummy
Sarnak
 
Join Date: Feb 2014
Posts: 71
Default

Sorvani and Uleat,

Good information and I appreciate the clarification on bot support.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:31 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3