Error 11001

[CHowell2005]

Im trying to set up a server for some friends and myself.
After running minilogin i run worlddebug.exe and this is what i get.

Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
DB Query Error #1054: Unknown column 'casttime2' in 'field list'
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: port 9000
World server listening on: port 9000
Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
Error: 11001'

Im not sure what my problem is, but it seems the world server cannot connect to minilogin?

Here are my ini's

loginserver.ini
[LoginServer]

loginserver=localhost

worldname=Aldarics server

locked=false

account=

password=
worldaddress=localhost
loginport=5999

[WorldServer]

Defaultstatus=

Unavailzone=
[LoginConfig]

ServerMode=Standalone

ServerPort=5999

UplinkAddress=

UplinkPort=

UplinkAccount=

UplinkPassword=

db.ini (though i doubt my problems here)
# READ README.TXT!


[Database]
host=localhost
user=*******
password=*******
database=eq
compression=off

### --- This file tells world.exe what computer mySQL is on. Host should

### --- be left "localhost" unless mysql is on a differant computer than world.exe.

boot5zones.bat
REM: ****Read this first!!!****



REM: This file requires your real IP in the place of "YourIP" when you are connecting

REM: To the EQEmu Loginserver.



REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1



REM: If you still get errors try using localhost instead of 127.0.0.1



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

@echo off



if NOT exist spells_en.txt goto NOSPELL

start ZoneDebug.exe . localhost 7995 localhost
start ZoneDebug.exe . localhost 7996 localhost
start ZoneDebug.exe . localhost 7997 localhost
start ZoneDebug.exe . localhost 7998 localhost
start ZoneDebug.exe . localhost 7999 localhost
exit
cls

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



REM:---------------END------------------------



Any help on this is appreciated.
Also.....where can i find a good database to use for 050?

Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.

See this recent thread

http://www.everquestserver.com/forum...ic.php?t=10981

Delete your db.ini and re-type it back in 'by hand'.

I set up a local DR5 server yesterday and used TCS's DB from here

http://www.everquestserver.com/forum...ic.php?t=10890

That should fix these errors:

DB Query Error #1054: Unknown column 'casttime2' in 'field list'
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown

This is odd:

Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
Error: 11001'

Check you have the line

127.0.0.1 localhost

in c:\windows\system32\drivers\etc\hosts, if you are running XP, or try changing all occurrences of locahost to 127.0.0.1 in your loginserver.ini

Oh, and if you do get past these errors, don't forget to do:

INSERT INTO account SET name='eqemu', password='eqemu', status=200;

I hadn't set up a server since back in the 4.4 days and was scratching my head at the 1017s I was getting when trying to login

[CHowell2005]

I downloaded that database you linked for me, but im not quite sure how to use it....do i replace the database i have or is there someway i combine them?
Also.....i changed all of my files so that i could run my server on the eqemu login server instead of making it private through minilogin, and im still getting that same error. I checked to make sure localhost was in hosts and it was. Any other ideas? You said you put up your own server..........mind putting up your ini's, and boot5zones.bat, ect as examples..... thanks again

The DB I linked is complete, so drop your existing one first, e.g.

drop database eq;
create database eq;
use eq;

source <path to TCS db>

here are my ini's:

db.ini

# READ README.TXT!

[Database]
host=localhost
user=test
password=test
database=eq5
compression=off


### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

LoginServer.ini

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.

### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5997
loginport2=5997
worldname=stevedr5server
worldaddress=localhost
locked=false
account=eqemu
password=eqemu

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5997
UplinkAddress=
UplinkPort=
UplinkAccount=eqemu
UplinkPassword=eqemu

MiniLoginAccounts.ini

127.0.0.1 eqemu eqemu

boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "hosthere" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zonedebug . 127.0.0.1 7995 127.0.0.1
start zonedebug . 127.0.0.1 7996 127.0.0.1

exit
cls

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

REM:---------------END------------------------

As I said, I was having some problems with 1017s for a while, so some of the places where I have put account/password of eqemu/eqemu are likely not required.

[CHowell2005]

Ok....now ive got everything fixed and ready to go but im still getting that error.

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25315, max id=67382
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
:9000istening on: localhost
:9000 server listening on: localhost
Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
Error: 11001'

I appreciate your help thusfar....any more ideas?

The last few lines of your output look strange,i.e

:9000istening on: localhost
:9000 server listening on: localhost

this is what I get:

[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Screwing up windows compiles...
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: localhost:5997
15281 New TCP connection: 127.0.0.1:3364
15281 New TCP connection: 127.0.0.1:3365
New zoneserver: #1 127.0.0.1:3365
New zoneserver: #2 127.0.0.1:3364
Zoneserver SetConnectInfo: 127.0.0.1:3364: 127.0.0.1:7996
Zoneserver SetConnectInfo: 127.0.0.1:3365: 127.0.0.1:7995

Not sure what the problem is. When did you download the source from CVS (I got mine yesterday) ?

[CHowell2005]

Ok...i booted up mini login..jumped on my other comp and played with eqhost.txt until i figured out what ip was needed to connect.

the eqhost.txt on my other comp(i will be playing eq on there) is:
[Registration Servers]
{
"192.168.0.5:5999"
}
[Login Servers]
{
"192.168.0.5:5999"
}

my server files are as follows:
db.ini(retyped and fixed)
[Database]
host=localhost
user=*****
password=*****
database=eq
compression=off

loginserver.ini
[LoginServer]

loginserver=192.168.0.5

loginport=5999

worldname=Aldarics Server

worldaddress=192.168.0.5

locked=false

account=eqemu

password=eqemu



[WorldServer]

Defaultstatus=

Unavailzone=



[LoginConfig]

ServerMode=Standalone

ServerPort=5999

UplinkAddress=

UplinkPort=

UplinkAccount=eqemu

UplinkPassword=eqemu

miniloginaccounts.ini
localhost eqemu eqemu

boot5zones.bat
REM:--------------Start-----------------------

@echo off



if NOT exist spells_en.txt goto NOSPELL

start ZoneDebug.exe . localhost 7995 localhost
start ZoneDebug.exe . localhost 7996 localhost
start ZoneDebug.exe . localhost 7997 localhost
start ZoneDebug.exe . localhost 7998 localhost
start ZoneDebug.exe . localhost 7999 localhost
exit
cls

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



REM:---------------END------------------------



Info:
This comp(the eqemu server) LANIP:192.168.0.5
My comp(where iwill be playing eq from) LANIP:192.168.0.2
External IP:24.154.92.139

........there might be an ip address somewhere in there that needs to be changed.....im not sure....ive been working on this server since 8 or 9 this morning so umm yeah im kind of mentally exhausted and ive lost all train of thought...and thats why im here

[CHowell2005]

i downloaded my source this morning.....and yes i noticed that it was strange too.......it has switched off and on between what you have(TCP and server) and what i have at the moment (NOTHING ) .....im pretty damn sure it has something to do with the login server addy and the world server addy in loginserver.ini ......im going to play around with it and see if i can get it back ...ill let you know

Well, I am out of ideas. One thing I notice is that your LoginServer.ini has blank lines after each line of text ... maybe a sign that it has 'odd' characters in there somewhere, perhaps as a result of using MS Word or something to edit it. You could try creating it from scratch using 'notepad ... just a shot in the dark really ... Good Luck

[CHowell2005]

ok i will go ahead and retype that........just to make sure would you mind clearing up what is suppose to go in these sections:
loginserver=
worldaddress=
im not sure what to put in these .....is it the computers lanip, or the internet ip, or localhost(127.0.0.1) or what......i also have a question about the IPs in the boot5zones.bat
what are the 2 sets of IPs in it?

IP port IP2

if i knew what these represented i could probably get this all figured out.....but all i had to go with when i started making the server was it said "YourIP"....didnt help me much.....thanks again

I've only ever created a 'local' server with world, zone, minilogin and EQ client all running on the same PC, so I always put 127.0.0.1 wherever an address is required. There are tutorials for setting up a LAN server in the Tutorial/Howto forum, which, albeit they are probably for 4.4 servers, should apply to 5.0 as well.

[CHowell2005]

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25315, max id=67382
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: You need to get laid...
TCP listening on: 24.154.92.139:9000
World server listening on: 24.154.92.139:9000
Connected to LoginServer: localhost:5999


retyping loginserver.ini did the trick it looks like woohoo......thanks alot bro

Congrats ... and I got my second 'ass' in the process