COMPLETE PUBLIC SERVER SETUP - Jan-2011

[dhgbrown]

Thanks. Got it going server-wise except I am getting [Debug] [World__LS_ERR] Unable to resolve 'PEQ' to an IP.

I plan to delete my folders and start over to try to repeat the process and maybe fix the IP issue.

Dave

[wolfwalkereci]

Its been awhile since I played with this but I put mine back up today on a new machine. Started fresh and it took roughly 2hours because I was being dumb.
The guide is still pretty much spot on.

I used a copy of the following that I had saved:
ActivePerl-5.10.1.1007-MSWin32-x86
Mysql-5.0.82-win32
zlib123-dll
Visual C++ 2008 Express Edition with SP1

[dhgbrown]

[Debug] Starting Log: logs/eqemu_debug_3012.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server localhost
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

This is getting frustrating.

Dave

[lerxst2112]

It's normal to see that when you start everything as things get in sync. If you're still having trouble after it has been running a few minutes then you need to post those errors.

[dhgbrown]

I am getting this error message on the client:

Sorry %3, you already have the maximum number of active tasks.

What did I miss now?

Dave

[dhgbrown]

Ok after reading and searching the forums this tutorial is to establish a server online with a login server remotely.

I need to setup this server so that it is Lan only because it will soon not have internet access indefinately. So with that said. After checking on the server the world.exe was failing due to not finding end statement. Fixed that.

Then Started batch file again and I get Handle_NewLSInfo error, remote address was null, defaulting to stream address ... Login server crashes.

What can I do to get a Lan only server running? Do I need two boxes on with login server and another with database server?

Dave

[nikkisman69]

I just put all of the files listed at the beginning in a rar file and uploaded them for easier downloads.
http://www.megaupload.com/?d=JRN4CP6Y

Includes:
WinRAR
Zlib
ActivePerl 5.10.1.1007 32-bit
MySQL 5.1.54 32-bit
MS Visual C++ 2008 Express Edition
Navicat
TortoiseSVN
Notepad++

[pepsiphreak79]

Can someone please write a walkthrough that a normal human can understand None of this is working its all just messing everything up

[pepsiphreak79]

I have my sql pearl and apache up as portable but i dont know how to get the DB into it every time i try i get some error another and it never goes in correctly i dont understand what it means to sorce something or how to do it i cant even find matching maps to matching db files its all so scattered around that its to complex to just find the right things you need
Im just trying to get a server up for offline use for a new SOF un patched install that works on all the content. I figured out how to write uests and add content but the repack i used is so outdated and gimped i cant get sof to work on it
This is all so very frustrating that the people making the emu expect all of us to be devs and programmers and we arent :( More people might do eqemu if it was simplified alot more ...
Just so frustrated sorry for the rant but ive been trying to make mine work for 2 weeks and every time i get close it all gets screwed up and i have to start over i have so much crap downloaded none of it is ever versioned corectly its hard to tell what goes with what . im just going to have to delete everything and start all over

[joligario]

You don't have to set up a server just to play. There also isn't a need for new servers. So if it is too complicated for the given step-by-step instructions, just join an existing server.

[wolfwalkereci]

If you really really must have your own local server I can assist you with compiled binaries but its up to you to get everything else working.
I have copy/pasted the guide from here to my forums and made it prettier and easier to follow (my opinion) however its almost exactly word for word what is posted here.
The only thing I do is provide downloads of the required files and compiled binaries starting with I believe 2027.
PM me if you want to go that route.

[pepsiphreak79]

Yes i must ave my own due to internet issues when i move iwill be out in never never land where net is non existant


Ok because i cant find a compatible set of portable servers i took the ones out of another repack "ax to be specific"

i gutted it.

i cleared the peq and ax DB out clean

i deleted the ax dir from it
i overwrote the files in the peq dir with the ones from

http://code.google.com/p/projecteqemu/downloads/list

EQEmu-Rev2068-Bots.zip Rev 2068 with Bots
EQEmuLoginServer.rar EQEmuLoginServer compiled from Rev1765 Source

so they went to ...
c:\eqemu\peq\World.exe
c:\eqemu\peq\EQEmuLoginServer.exe
ect....

I corrected the logins

I went into the DB and removed peq and ax database and created a blank peq DB using utf8 generic

I then imported peqdb_rev2027.sql to the peq database with no errors



i placed maps from http://eqemu-maps.googlecode.com/svn/trunk/
and Pathfiles_01.zip from http://code.google.com/p/projecteqemu/downloads/list
into c:\eqemu\peq\maps\*.*

I updated quests from http://projecteqquests.googlecode.com/svn/trunk/quests/
into c:\eqemu\peq\quests\*\









[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 3. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (3)
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'peq.variables'
doesn't exist'
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3400
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3400
[Debug] [WORLD__LAUNCH] Adding pending launcher 4



So i copied the variables table from the login db










[Debug] [WORLD__INIT] Clearing groups..
Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'peq.group_id' doesn't exist
[Debug] [WORLD__INIT] Clearing raids..
Unable to clear raids: #1146: Table 'peq.raid_members' doesn't exist
Unable to clear raid details: #1146: Table 'peq.raid_details' doesn't exist
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=90209



[Debug] [WORLD__INIT] [Debug] Starting Log: logs/eqemu_debug_4296.log
Loading guilds..[Debug] [LAUNCHER__INIT] Loading server configuration..

[Debug] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus
, motd, motd_setter,channel,url FROM guilds': #1146: Table 'peq.guilds' doesn't
exist
[Error] Starting Log: logs/eqemu_error_world_3004.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='de
fault': #1146: Table 'peq.rule_sets' doesn't exist
[Debug] [WORLD__INIT] No rule set configured, using default rules
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
Error in ClearMerchantTemp query 'delete from merchantlist_temp' #1146: Table 'p
eq.merchantlist_temp' doesn't exist
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Error] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exis
t



t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (10)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:3437
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:3437
[Debug] [WORLD__LAUNCH] Adding pending launcher 11
[Error] Error in AdventureManager:::GetLeaderboardInfo: select ch.name, ch.id, a
dv_stats.* from adventure_stats AS adv_stats left join character_ AS ch on adv_s
tats.player_id = ch.id; (#1146: Table 'peq.adventure_stats' doesn't exist)
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 11. Adding zones to active lis
t.
[Debug] [WORLD__LAUNCH] Removing launcher zones (11)












This is where im stuck this time

I am lost and nhave no idea what its doing I am pretty sure the peqdb_rev2027.sql was incomplete somehow and that im missing a chunk of stuff from my DB but i dont know where to get a full and ungimped DB i guess

[lerxst2112]

It sounds like you did not source your database correctly. Steps 14 and 15 in the guide.

[joligario]

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

[lerxst2112]

Originally Posted by joligario

You're already out of date. CD uploaded a new database (2083). Get that one. Drop everything, source players and source system.

That is generally good advice, but when using precompiled binaries a newer database may not work with the older server code. If you really can't compile your own server I'd stick with a slightly lower database rev and apply the updates to make it match your binary version.