World with no Items

[vales]

Originally Posted by Hrothgar

Cheap PC: AMD Sempron Dual Core Processor 2300 2.2 GHz
I had to let it run overnight. The other scripts ran quickly though.

If you're running Windows XP (that doesn't have SP2 or SP3 installed), then I highly recommend downloading the AMD CPU fix here and here. That could have been the culprit. It shouldn't take that long at all on that CPU. My old Athlon 64 3500+ didn't even take that long, and it's only a single core.

Originally Posted by Hrothgar

Database is definitely named "PEQ" not "EQ". I can "USE" PEQ from MYsql and see it in Navicat. Don't know why World.exe is looking for 'eq'.

There's a </server> at the end of your eqemu_config.xml file right?

Forgot to add that if you download the binaries from the google site, make sure you use the eqemu_config.xml.full one and not the eqemu_config.xml. Just edit out the .full at the end of the file, and you should be good to go. I just looked at it, and the default of that file is set to eq instead of what you specify it to be.

If you just use that file, and edit in your information, then you should be good to go. I knew there was something missing from the guide.

Make sure you take out the comment lines in the file at the top as well.

[Shiny151]

Originally Posted by Hrothgar

My build/maps folder contains 602 files and is 3.38 GB. Perhaps your SVN Checkout was incomplete?

I will try it again tonight. I didn't get a timeout or error message and actually got a "finished!" message for Maps.

Thanks for confirming. Perhaps vales can shed some light on your EQ database issue.

[Hrothgar]

I am close enough to smell it but not close enough to step in it. I can start EQ, login to EQemulator.net using the appropriate account info and see the available worlds, except for mine which is missing. When I change all various "host" and "addresses" settings to point to the EQEmuLoginServer running on my server (instead of EQemulator.net) I get the "Error - The username and/or password were not valid. Please check them and try again." I added my AccountName and AccountPassword to the tblloginserveraccounts table of database peqlogindb with a LastIPAddress of 127.0.0.1 and added the same info to the accounts table of database PEQ.

For now, I only need to get it running for local login. I might open it to others after I experiment with it for awhile. I am sure it is just something simple that I am getting crossed between all the "host", "address" and "port" entries but much like the jitterbug it just plum evades me.

EQEmuLoginServer v1.0 ALPHA
Using Port: 5998
Dumping Inbound Packets.
Dumping Outbound Packets.
Tracing ON.
Database Server: localhost
Database Catalog: PEQloginDB
Datebase UserName: EDITED
Database Password: EDITED
Server (TCP) listener started.
Total World Server TCP Connections is 0.
Total World Server Registrations is 0.
New Server TCP connection from 127.0.0.1:50840
Received server Opcode
(blah, blah, blah)
Updating status for server: Slobovia

EQlaunch
[Debug] Starting Log: logs/eqemu_debug_5128.log
[Debug] [LAUNCHER_INIT] Loading server configuration..
[Debug] [NET_WORLD] WorldConnection connect: Connecting to the server slobovia.no-ip.biz:9000 failed: TCPConnection::Connect() failed. Error: 10061
[Debug] [LAUNCHER_ERROR] worldserver.connect() FAILED! Will retry.
[Debug] [LAUNCHER_INIT] Starting main loop...
[Debug] [NET_WORLD] Connected to World: slobovia.no-ip.biz:9000
(blah, blah, blah, then it starts the dynamic zones 1-5)

C:\EQemu Server\build\World.exe
[Debug] Starting Log: logs/eqemu_debug_world_0944.log
[Debug] [World__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_0944.log
[Status] Using database 'PEQ' at localhost:3306
[Debug] [WORLD__INIT] HTTP world service disabled.
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=76214
(blah, blah, blah, set rules, launch zones)

eqhost.txt
[LoginServer]
Host=eqemulator.net:5998

eqemu_config.xml
<?xml version="1.0">
<server>
<world>
<shortname>Slobovia</shortname>
<longname>Slobovia</longname>
<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>slobovia.no-ip.biz</address> -->
<!-- <localaddress>192.168.1.101</localaddress> -->
<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>localhost</host>
<port>5998</port>
<account></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="slobovia.no-ip.biz" 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>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>
<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</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>localhost</host>
<port>3306</port>
<username>EDITED</username>
<password>EDITED</password>
<db>PEQ</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=EDITED
DatabaseUserPassword=EDITED
OPCodePathAndFileName=login_opcodes.conf

Startup EQemu.bat
@echo off
start EQEmuLoginServer.exe
start world
echo waiting for the world to finish before starting zone...
sleep 10
start eqlaunch zone

Directory Structure
C:\EQemu Server\build (logs, Maps, plugins,quests, templates,worldui, .exe, .ini, .conf)
C:\EQEmu Server Files (svn folders: branches, tags, trunk,wiki)
C:\MySQL\MySQL Server 5.1\bin\projecteqdb\peqdatabase
C:\ProgramData\MySQL\MySQL Server 5.1\data\peq
C:\ProgramData\MySQL\MySQL Server 5.1\data\peqlogindb

[vales]

You've got some errors in your setup there.

=== Then delete the red text and change it to the orange one if there is.

eqhost.txt
[LoginServer]
Host=change this to your LAN IP of the server:5998

If everyone on your network is on the same LAN, then you can just change it to your server's LAN IP.

eqemu_config.xml
<?xml version="1.0">
<server>
<world>
<shortname>Slobovia</shortname>
<longname>Slobovia</longname>
<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>slobovia.no-ip.biz</address> -->
<!-- <localaddress>192.168.1.101</localaddress> -->

<!-- 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="slobovia.no-ip.biz - change it to localhost" port="9000" telnet="enable"/>

[Hrothgar]

Vales, I appreciate your patience and the restraint you have exercised in not pointing out exactly how clueless I am. I guess I just don't test well. I made the changes you noted in red and orange above.

When I use 192.168.1.1 in eqhost.txt and as the local address in eqemu_config.xml then I receive the error: "A connection to the server could not be reached. Please check your internet connection to make sure you are online." I have opened the relevant ports and even tried temporarily disabling (and applying change) Windows Firewall.

When I use 192.168.1.101 in eqhost.txt and as the local address in eqemu_config.xml then I receive "Error - The username and/or password were not valid. Please check them and try again." I have tried three different login accounts and verified them by checking the table in HeidiSQL.

[vales]

No problem. It's all a learning process, and we were all there at one time or another.

Just missed the loginserver part of your config file. Sorry about that.

Try this:

<loginserver>
<host>slobovia.no-ip.biz</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

then in your eqhosts.txt file, change it to:

[LoginServer]
Host=slobovia.no-ip.biz:5998

If that doesn't work, change it to:

[LoginServer]
Host=192.168.1.101:5998

And finally, if that fails... It could be that your router doesn't support NAT routing. A lot of older routers have this issue.

What you could to test it out is put your dyndns name in your eqhosts.txt file like so:

[LoginServer]
Host=slobovia.no-ip.biz:5998

This will be for any clients connecting to your PC that's hosting the server.


Then go to C:/windows/system32/drivers/etc, and open your hosts file with notepad or something.

You should see:

127.0.0.1       localhost

at the bottom.

Add this line:

slobovia.no-ip.biz       192.168.1.101

Then save the hosts file.

What this does is loops your connection and reroutes it to your server's PC - assuming 192.168.1.101 is the LAN IP to your server. So any PC with this modified host file will have their connection rerouted.

[EQFAN2009]

Vales - Fantastic guide thanks very much