EQEmulator Forums - What have I done wrong to setup an Uber Server ???

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

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

- - What have I done wrong to setup an Uber Server ??? (https://www.eqemulator.org/forums/showthread.php?t=15977)

What have I done wrong to setup an Uber Server ???

:shock:
i get error 10061 appear on world server Command Prompt after trying to attempt entering my server ???

Post output of world.exe, post your loginserver.ini

I also get this issue, am running the server on my own network, do not want to share with internet at this stage.

Any help would be good.

Am running on Win2003 server with laters Mysql.

umm also the Boot5Zones.bat runs and loads 5 screens but they all close after a while, is that normal ?

My World.exe oputput

Code:



[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2

[Status] Loading variables..

[Status] Loading zones..

[Status] Clearing groups..

Unable to clear groups: #1146: Table 'eq.character_' doesn't exist

[Status] Loading items..

[Status] EMuShareMem loaded

[Status] Loading items from database: count=36965

[Status] ./LoginServer.ini read.

[Status] Loading guild ranks..

Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,

 rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran

k5, rank5title from guilds' #1146: Table 'eq.guilds' doesn't exist

[Status] Loading ./addon.ini..

Couldn't open './addon.ini'.

[Status] Loading EQ time of day..

[Error] Could not load EQTime file ./eqtime.cfg

[Error] Unable to load ./eqtime.cfg

[Status] Deleted -1 stale player corpses from database

[Status] Deleted -1 stale player backups from database

Assassinating people that whine about horses...done

TCP listening on: 192.168.1.102:9000

World server listening on: 192.168.1.102:9000

Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:

 10061'

My LoginServer.ini

Code:





[LoginServer]

loginserver=192.168.1.102

loginport=5994

worldname=HoppysHome

worldaddress=192.168.1.102

locked=false

account=

password=





[WorldServer]

Defaultstatus=0

Unavailzone=



[ChatChannelServer]

worldshortname=

chataddress=

chatport= on a differant computer than world.exe.

My Boot5Zones.bat

Code:



REM:--------------Start-----------------------

@echo off



if NOT exist spells_us.txt goto NOSPELL



start zone . 192.168.1.102 7995 192.168.1.102

start zone . 192.168.1.102 7996 192.168.1.102

start zone . 192.168.1.102 7997 192.168.1.102

start zone . 192.168.1.102 7998 192.168.1.102

start zone . 192.168.1.102 7999 192.168.1.102

exit

cls



:NOSPELL

echo You did not copy the spells_us.txt from your everquest directory to this one.  Please do so or zones will crash on startup.

PAUSE



REM:---------------END------------------------mputer than world.exe.

thanks

Hoppy

ok added this to my LoginServer.ini

Code:



[LoginConfig]

ServerMode=Standalone

ServerPort=5997

UplinkAddress=

UplinkPort=

UplinkAccount=

UplinkPassword=

and seems to work, but now i can not connect from my client (on other PC)

the eqhost.txt has

Code:



[LoginServer]

Host=192.168.1.102:15900

Have you sourced PEQ fresh install, or PEQ update databases ?
you're missing a few mysql tables, like account, and guilds. account causes a fatal error obviously.

If this is your first server and you don't have any account to preserve, run mysql and source PEQ fresh install. it contains roughly anything you need for your server. Don't forget to run the DB fixes, right after.

ok thanks guys I can now login and create a character, but now when i try to enter the world I get a Zone unavailable error.

my zone.exe is showing this

Code:



[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2

[Status] Loading Variables

[Status] Loading zone names

[Status] Loading items

[Status] EMuShareMem loaded

[Status] Loading npcs

[Status] Loading npc faction lists

[Status] Loading loot tables

[Status] Loading doors

Error: EMuShareMem: DLLLoadDoors: !DoorsMMF.IsLoaded() (timeout)

[Status] Loading guilds

[Status] Loading factions

[Status] Loading AA effects

[Status] Loading swarm spells

[Status] Loading tributes

[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':

#1146: Table 'eq.tributes' doesn't exist

[Status] Loading corpse timers

[Status] Loading what ever is left

Couldn't open './addon.ini'.

[Status] Loading commands

[Status] 176 commands loaded

[Status] Loading embedded perl XS

[Status] Error initializing perlembed: failed to install plugin printhook, do yo

u lack IO::Scalar?

[Status] Fatal error initializing perl: failed to install plugin printhook, do y

ou lack IO::Scalar?

Now I know IO::Scalar is installed cos I did this

perl -MIO::Scalar -e "print 'Installed'" and I got a message that said installed back.

Also the 5 zone.exe widows don't stay open they all eventually close.

any idea's ?

ok have resolved this, can log in now fine, but only one prob, there are no trainers, mechs or mobs at all.

agghhhhh would this be a DB prob ?

hellllllllllllllppp !!

a DB prob ? funny idea :)
have you sourced a DB file ? like PEQ_kunark for example ?

yep I have sourced that one and also the update one as well.

here is some of the output from my zone.exe

Code:



[Status] Loading Temporary Merchant Lists...

Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge

s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=

ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='hal

as' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'eq.merchantlis

t_temp' doesn't exist

[Status] Zone Bootup: Halas (29)

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

Error loading NPCs from database. Bad query.

[Status] 190103 New client from ip:192.168.1.101 port:2278

Read group ID for 'Hoppy': 0

[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:

 opcode: 0x02f5, size: 4

Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4

   0: 48 1F 73 00                                        | H.s.

Run this into mysql, its for merchantlist_temp error

CREATE TABLE merchantlist_temp (
npcid int(10) unsigned NOT NULL default '0',
slot tinyint(3) unsigned NOT NULL default '0',
itemid int(10) unsigned NOT NULL default '0',
charges int(10) unsigned NOT NULL default '1',
UNIQUE KEY merchantid (npcid,slot)
) TYPE=MyISAM;

Run this for the npc error :

ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

ok just added those..

Just had a look at my zone.exe out put and have one more error

Code:



[Status] Loading npc faction lists

[Status] Loading loot tables

[Status] Loading doors

[Status] Loading Doors from database...

Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading

,opentype,guild,lockpick,keyitem,triggerdoor,triggertype,dest_zone,dest_x,dest_y

,dest_z,dest_heading,door_param,invert_state,incline,size from doors' #1054: Unk

nown column 'door_param' in 'field list'

If you get an error about door_param and size, run the following queries:

ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4)  DEFAULT "0" NOT NUL

L;

ALTER TABLE `doors` ADD `size` SMALLINT(5)  UNSIGNED DEFAULT "100" NOT NULL;

Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors

[Status] FileLoadSPDat() Loading spells from ./spells_us.txt

[Status] FileLoadSPDat() spells loaded: 6299

[Status] Loading guilds

I think that this is the doors prob right ?

P.S - Thanks for help on NPCs, they all there now :-)

yeah right :)
Just add a field named liftheigth, int 11

umm can u plz give me the code on how to do that as am not good with sql...

and this is the last time i promise :-)

hehe

ALTER TABLE npc_types ADD liftheight INT NOT NULL DEFAULT '0';

I've got your answer right here...

Quote:

Originally Posted by kathgar

If you post here asking for support, you will have your posts ignored, moved, or deleted. Why are you trying to run a server if you can't read the forum rules?

thanks Muuss, all works now

oh but just can't sell anything :-(

and I zoned to a zone that I did not have, now can not load the char doh !! hehehe

am having fun though :-)

Quote:

am having fun though

Great, that's the goal of that project, some people seem to forget it , sometimes :)

About merchants, there was a bug till recently in the source code, try eventually to get the latest one, i ve read somewhere that Doodman fixed it.

I fixed it all up, works very well.

hey on a side note, how would I go about changing my characters race ?? I have a barberian and wanna change him to a troll.

lol, what a lazy guy you are !

#permarace $raceid

Barb might be something like 2, you'll be disconnected after the command, no worries, that's the intended behaviour !

hehehe

sweet thanks for that, I got the Trolls race id out of the database, it is 9, so I will login and do a #permarace 9

and will prob have to change the diaty as well ....

fun fun

Quote:

Originally Posted by hoppy02

ok have resolved this, can log in now fine, but only one prob, there are no trainers, mechs or mobs at all.

agghhhhh would this be a DB prob ?

hellllllllllllllppp !!

Hey, how did you resolve this:

[Status] Error initializing perlembed: failed to install plugin printhook, do yo
u lack IO::Scalar?
[Status] Fatal error initializing perl: failed to install plugin printhook, do y
ou lack IO::Scalar?

I'm having the same problem and I know IO::Scalar is installed.

that uninstalling perl and reinstalling from scratch unitl everything goes right according to the server setup guide. I had to reinstall perl after a week of it not working and it worked great.