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

[evilzippy]

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

[Malignus Wingnut]

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

[hoppy02]

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



[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




[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



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

[hoppy02]

ok added this to my LoginServer.ini



[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



[LoginServer]
Host=192.168.1.102:15900

[Muuss]

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.

[hoppy02]

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



[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 ?

[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 !!

[Muuss]

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

[hoppy02]

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

here is some of the output from my zone.exe



[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.

[Muuss]

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';

[hoppy02]

ok just added those..

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



[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,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,door_param,invert_state,incli ne,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 :-)

[Muuss]

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

[hoppy02]

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 :-)

[Muuss]

hehe

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

[Spike]

I've got your answer right here...

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?

[hoppy02]

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 :-)

[Muuss]

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.

[hoppy02]

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.

[Muuss]

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 !

[hoppy02]

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

[MayhemMby]

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.

[watcher001]

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.