EQEmulator Forums - Trouble with mini-login server

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

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

- - Trouble with mini-login server (https://www.eqemulator.org/forums/showthread.php?t=12300)

Trouble with mini-login server

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

Mini-Login Output

Code:

 LoginServer.ini read.

MiniLoginAccounts.ini read.

Server mode: Standalone

Login server listening on port:5999

World.exe Output

Code:

 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,filename,

bagtype,bagslots,bagsize,bagwr,augslot1type,

augslot2type,augslot3type,augslot4type,augslot5type,unknown018,unknown019,unknown020,casttime2,unknown061,

unknown067,unknown069,unknown070,unknown076,unknown077,augtype,ldonpointtheme,ldonpointcost,unknown099,

astr,asta,aagi,adex,awis,aint,acha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace,

magic,hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,reclevel,recskill,charmfile,factionmod1,

factionmod2,factionmod3,factionmod4,faction

amt1,factionamt2,factionamt3,factionamt4,reqlevel,

hp,mana,ac,color,classes,races,spellid,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combateffects,

deity,elemdmgamt,elemdmgtype,sellrate,shielding,spellshield,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:

Code:

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

Code:

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

Code:

127.0.0.1 Jezebell ******{space}

Trouble with mini-login server

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

what is this though:

Code:

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

[Error] Unable to load ./eqtime.cfg

and where can I download item db's?

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:

Quote:

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

Trouble with mini-login server

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

Code:

[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,itemclass,idfile,lore,slots,cost,nam

e,icon,unknown105,booktype,filename,bagtype,bagslots,bagsize,bagwr,augslot1type,

augslot2type,augslot3type,augslot4type,augslot5type,unknown018,unknown019,unknow

n020,casttime2,unknown061,unknown067,unknown069,unknown070,unknown076,unknown077

,augtype,ldonpointtheme,ldonpointcost,unknown099,astr,asta,aagi,adex,awis,aint,a

cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace

,magic,hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,recl

evel,recskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factiona

mt1,factionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,

spellid,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combatef

fects,deity,elemdmgamt,elemdmgtype,sellrate,shielding,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?

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.

Quote:

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

Quote:

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

Quote:

Originally Posted by samandhi

Quote:

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

Quote:

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!