Trouble with mini-login server

[Jezebell]

I'm trying to setup a server for only me to log into.

Mini-Login Output
LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999

World.exe Output
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown107, unknown
108,id,weight,norent,nodrop,size,itemclass,idfile, lore,slots,cost,name,icon,unknown105,booktype,file name,
bagtype,bagslots,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknown020,casttime2,unkno wn061,
unknown067,unknown069,unknown070,unknown076,unknow n077,augtype,ldonpointtheme,ldonpointcost,unknown0 99,
astr,asta,aagi,adex,awis,aint,acha,pr,mr,dr,fr,cr, skillmodvalue,skillmodtype,banedmgamt,banedmgbody, banedmgrace,
magic,hasteproclvl,light,delay,effecttype,range,da mage,material,maxcharges,reclevel,recskill,charmfi le,factionmod1,
factionmod2,factionmod3,factionmod4,faction
amt1,factionamt2,factionamt3,factionamt4,reqlevel,
hp,mana,ac,color,classes,races,spellid,casttime,fo cusid,itemtype,accuracy,avoidance,bardtype,bardval ue,combateffects,
deity,elemdmgamt,elemdmgtype,sellrate,shielding,sp ellshield,strikethrough,stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'field list'
[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..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[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: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'

DB.ini file:
# READ README.TXT!

[Database]
host=localhost
user=darkangel
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.

Loginserver.ini file:
### --- 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 recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=127.0.0.1
loginport=5997
worldname=DarkAngel's Test
worldaddress=127.0.0.1
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

MiniLoginAccounts.ini file:

127.0.0.1 Jezebell ******{space}

[Jezebell]

Ok, I got the -10061- error fixed all by myself, ports didn't match :)

what is this though:

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

and where can I download item db's?

[samandhi]

the eqtime is no big deal. It is because you havent logged on the the server yet and therefore there IS no time set... BUT, you will still not be able to log onto your server because of this:

[Error] Error: Could not load item data. But ignoring You are trying to use a db that is NOT compatible with the emu version you are running... OR there is NO db sourced in at all...

[Jezebell]

Well, I have my server on the list with 0 Pop-count, but I am still getting errors:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[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,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field 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
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 192.168.2.69:9000
World server listening on: 192.168.2.69:9000
Connected to LoginServer: eqlogin3.eqemulator.net:5997
317360 New TCP connection: 67.8.129.150:2969
317360 New TCP connection: 67.8.129.150:2968
317360 New TCP connection: 67.8.129.150:2967
317360 New TCP connection: 67.8.129.150:2970
317360 New TCP connection: 67.8.129.150:2966
New zoneserver: #1 67.8.129.150:2969
Zoneserver SetConnectInfo: 67.8.129.150:2969: 192.168.2.69:7997
New zoneserver: #2 67.8.129.150:2966
New zoneserver: #3 67.8.129.150:2970
New zoneserver: #4 67.8.129.150:2967
New zoneserver: #5 67.8.129.150:2968
Zoneserver SetConnectInfo: 67.8.129.150:2968: 192.168.2.69:7996
Zoneserver SetConnectInfo: 67.8.129.150:2967: 192.168.2.69:7998
Zoneserver SetConnectInfo: 67.8.129.150:2970: 192.168.2.69:7995
Zoneserver SetConnectInfo: 67.8.129.150:2966: 192.168.2.69:7999
380953 New client from ip: 192.168.2.69 port: 2974
[Error] Expecting OP_SendLoginInfo, got 254
Removing client from ip:192.168.2.69 port:2974

The last error happens when I try to login.

I seem to be having ALOT of difficulty with MySQL and getting DB's sourced in, I am getting alot of errors about duplicate entries. Heck i don't even know if I am doing it right, the program is definately not easy to use. I downloaded Myra's DB's and tried to source them in but not sure how to tell if it worked. Also do you have to manually enter in item and mob info?

[RexChaos]

Just use the MW database. It's a complete database and no sourcing needed. You can find it at:

http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip

I used alpha_01 though. Not sure what 02 is like. Just a heads up. :)

My question is this - how close are Myra's and MW's in terms of what mobs are in game and what zones are done? I thought Myra's was complete (after sourcing), but I've heard no official word from any of the developers either way.

[samandhi]

It's a complete database and no sourcing needed. This statement is NOT true. You will initally have to source it into MySQL just as you do with others. BUT, you will not have to source any other db's in on top of that one...

My question is this - how close are Myra's and MW's in terms of what mobs are in game and what zones are done? I thought Myra's was complete (after sourcing), but I've heard no official word from any of the developers either way. You have not heard anything because that is too difficult of a question to answer. They would have to write literally a 2000 page report listing all the things that were put in or changed.. If you like though, you can read the .sql file in any text editor, or even do a compare of the two to find the differences. IMHO they are both excellant db's and hope they BOTH continue to update them, as I use them both for different types of servers....:)

[RexChaos]

It's a complete database and no sourcing needed. This statement is NOT true. You will initally have to source it into MySQL just as you do with others. BUT, you will not have to source any other db's in on top of that one...

My question is this - how close are Myra's and MW's in terms of what mobs are in game and what zones are done? I thought Myra's was complete (after sourcing), but I've heard no official word from any of the developers either way. You have not heard anything because that is too difficult of a question to answer. They would have to write literally a 2000 page report listing all the things that were put in or changed.. If you like though, you can read the .sql file in any text editor, or even do a compare of the two to find the differences. IMHO they are both excellant db's and hope they BOTH continue to update them, as I use them both for different types of servers....:)

Right, you do have to source that one database into your eq databse. What was meant is that you won't need to source several .sql files. :)

As for comparing the two databases, if you've used both, could we open a discussion on the pros and cons of each? I would recommend doing so in the World Building forum. Thanks!