Newb setting up Private LAN Server

[mercdady4965]

Hello. I will begin by saying I have been all over these forums correcting problems with my server. Great Job! You guys are great.

My intentions are to have a Private LAN Server for three computers. The desktop I am working on and two laptops.

I have followed this guide. http://wiki.eqemulator.org/p?Complet...Guide&frm=Main. Very helpful.

Also this one for Private server. http://wiki.eqemulator.org/p?Windows...Guide&frm=Main.

After running my Start.bat I get 5 cmd prompt windows.

1. EQEmu login server - No errors. Last line states Server Started.
2. World.exe - No errors. using database 'peq' at 127.0.0.1
3. Queryserv.exe - No errors. using database 'peq' at 127.0.0.1
4. Ucs.exe - No errors. using database 'peq' at 127.0.0.1
5. EQLaunch.exe - No text.

At this point I have assumed that everything is working correctly. I have no true idea of what I am looking for. I also have XAMPP Control panel(running Mysql) and HeidiSQL running.

I am using Everquest Titanium. When I start my EQ shortcut( pointing to eqgame.exe"patchme -w) I am allowed to enter a username and password, but they are rejected as incorrect.

Here is my Login.ini:

[database]
host = localhost
port = 3306
db = peq
user = root
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 = 5998
local_network = 127.0.0.

[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


Here is my EQEmu-config.xml:

<?xml version="1.0"?>
<server>
<world>
<shortname>Dragon</shortname>
<longname>Dragon's Rest</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</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="127.0.0.1" 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.3</host>
<port>10234</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>192.168.1.3</host>
<port>10234</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>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<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>


Is there any other info I can give?

Thank you.


I decided to try making another account to try using this method.

Step 5: Create a login account.
You now have the required database tables, but they are empty and so no one will be able to log in yet. Open up either HeidiSQL or just do this in the mysql prompt:-
?
1
2
INSERT INTO tblloginserveraccounts (AccountName,AccountPassword,AccountEmail,LastIPAd dress,LastLoginDate)
VALUES ('your_account_name',sha('your_password'),'me@me.c om','127.0.0.1','2014-01-01 00:00:01');
Changing 'your_account_nam'e to the name of the account you wish to create, 'your_password' to the password you want to use. Of course, you can create as many accounts as you like this way.
I get an error saying peq.tblloginserveraccounts doesn't exist.

Thank you again.