Server DB Problems!

[Geneandjims]

I've gotten my server almost totally set up only problem is when I try to login with my character it says after giving me a message that I cant read...

[ERROR] Database: could not find start_zones table in database. Using defaults...

so what should I do about this? Im also having a problem with it not being able to load EQtime file ./eqtime.cfg aside from this my server has no errors.

Help is welcome,
-Gene

[jim_d]

I would find a new database or try resourcing the one you currently have.. as for the eqtime.cfg you can ignore that.

[Geneandjims]

I got all that fixed and the server works all the way to the character creation screen. I have even made a character but when I try to login to my server the screen goes black and a bunch of words appear on top of eachother. The only thing I think I can make out is "Server not Responding" then it boots me to char creation. Here is what it says in my world command prompt...

-----------------------------
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[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
Assassinating people that whine about horses...done
TCP listening on: ***.***.*.*:9000
World server listening on: ***.***.*.*:9000
Connected to LoginServer: ***.***.*.*:5999
11125 New TCP connection: 127.0.0.1:1395
New zoneserver: #1 127.0.0.1:1395
Zoneserver SetConnectInfo: 127.0.0.1:1395: YourIP:7996
11188 New TCP connection: 127.0.0.1:1396
New zoneserver: #2 127.0.0.1:1396
Zoneserver SetConnectInfo: 127.0.0.1:1396: YourIP:7998
11219 New TCP connection: 127.0.0.1:1397
11219 New TCP connection: 127.0.0.1:1398
11219 New TCP connection: 127.0.0.1:1399
New zoneserver: #3 127.0.0.1:1399
New zoneserver: #4 127.0.0.1:1398
New zoneserver: #5 127.0.0.1:1397
Zoneserver SetConnectInfo: 127.0.0.1:1397: YourIP:7999
Zoneserver SetConnectInfo: 127.0.0.1:1398: YourIP:7997
Zoneserver SetConnectInfo: 127.0.0.1:1399: YourIP:7995
48938 New client from ip: ***.***.*.* port: 1404
Logged in: Local: eqemu
Received unknown opcode: 0x02db size:0 bytes
Attempting autobootup of gukta (52) for Death
Zoneserver SetZone: YourIP:7999 gukta (52)
Enter world: Death: gukta (52)
Broadcasting a world time update
Zoneserver SetZone: YourIP:7999 gukta (52)
Client disconnected
Removing client from ip:***.***.*.* port:1404
-----------------------------

from looking at this the only odd thing I see is the line "Received unknown opcode: 0x02db size:0 bytes" and I have no idea what that means so im pretty much lost. So I decided to ask for help.

Thankies for help,
-Gene

[Scorpious2k]

You don't need the start_zones, so ignore that message.

The unknown opcode message is a debug message for developers, and you can ignore it too.

So if its working, you have it right. Congrats.

[Geneandjims]

Well thats the problem its just near working I can't play it yet. All I can reach is the character creation and when I hit "enter world" it gives me the messages and also I looked at my zones and one had a bit o' strange to it have a look at the end...

------------------------------
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.3-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 149 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
[Status] Weather should change in 12688 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa
ded into memory
, timezone data - Done. ZoneID = 82; Time Offset = 0
Reading zhdr file './cfg/cabwest.cfg'
Using database for safe coords.
Zone safe coords are x = 528.3; y = -59.5; z= 3.8
Reading zhdr file './cfg/cabwest.cfg'
Using database for safe coords.
Zone safe coords are x = 528.3; y = -59.5; z= 3.8
Using default zone header data...
Converting old zone data...
Attempting to write cfg\cabwest.cfg
Write complete.
Reading zhdr file './cfg/cabwest.cfg'
Using database for safe coords.
Zone safe coords are x = 528.3; y = -59.5; z= 3.8
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for cabwest ...
[Status] Done loading doors for cabwest ...
[Status] Zone Bootup: cabwest (82)
127.0.0.1:9000: TCPConnection::RecvData(): Error: 10054
------------------------------

Im so damn close to getting it running I can almost taste it. And whats with it saying "Server not responding"?

Thankies,
-Gene

[Geneandjims]

Sorry to bump but I REALLY want to get this server up before this weekend so I can blow the weekend playing EQ on my server. So please anyone if you know what to do to fix my problem(see above) please post ANY suggestions.

CMON you know you wanna help,
-Gene

[sandy]

verify that the cfg files in your cfg directory are not read only

[Geneandjims]

Nope not read-only.

[Conan]

127.0.0.1:9000: TCPConnection::RecvData(): Error: 10054
------------------------------



That would be your problem right there.

I noticed that you are useing minilogin as well?

Try Changeing the 127.0.0.1 in boot5zones.bat to you local ip address

[Geneandjims]

-----------------------
start zone . 192.168.0.2 7995 192.168.0.2
start zone . 192.168.0.2 7996 192.168.0.2
start zone . 192.168.0.2 7997 192.168.0.2
start zone . 192.168.0.2 7998 192.168.0.2
start zone . 192.168.0.2 7999 192.168.0.2
exit
-----------------------

Thats my boot5zones.bat so I don't think it's that.

[mattmeck]

what dose it say when you run it?

[Geneandjims]

Well it works fine until I hit the enter world screen then it waits a few seconds and in the center of the screen a bunch of text appears on top of itself it's impossible to read, the only thing I think I got was "server not responding" but I don't know for certain.

[Conan]

Are you running sql and everything from the same machine?

If so try useing

localhost

or

127.0.0.1

inplace of your up addresses listed above.

[Geneandjims]

That didn't work either :( . I could post my server's info like login and database if that will help.

[Geneandjims]

Decided to post my DB file and my LoginServer file for hopes of someone knowing whats up.

Database
----------------------
# READ README.TXT!

[Database]
host=localhost
user=Gene
password=gold
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.
----------------------
ServerLogim
----------------------
### --- 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=192.168.0.2
loginport=5999
worldname=Genes Ultra
worldaddress=192.168.0.2
locked=false
account=
password=

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[Shawn319]

1) dont use internal IP numbers. you need to go to www.whatismyip.com and find your real IP, then you need to forword all the ports in your router so it knows which computer to come back to.

[Geneandjims]

Ok. I got the IP from www.whatsmyip.com plugged that in and now I watch my world window and it says at the very last entry
---
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10060'
---
also when I try to login it won't appear on my server list and it did before. Also what do you mean by forward all the ports on my router?

:shock: :shock: :shock: ,
-Gene

[m0oni9]

Winsock error 10060 is connection timeout. I would verify that all the ports needing to be opened are opened (or in this case, 5999?).

[Geneandjims]

Well resolved the error I was having above but now it gives me that damn 1017 connection error here are my updated files...

-----
[Database]
host=localhost
user=Gene
password=gold
database=eq
compression=off
-----
### --- 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=192.168.0.2
loginport=5999
worldname=Genes Ultra
worldaddress=***.***.***.**
locked=false
account=
password=

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
-----
THIS IS MY MINILOGIN SERVERLOGIN.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 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=192.168.0.2
loginport=5999
worldname=Genes Ultra
worldaddress=***.***.***.**
locked=false
account=
password=

[WorldServer]
Defaultstatus=0
Unavailzone=

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

-----

I am not getting any errors within my world.exe or any of my 5 booted zones and there are no problems with my minilogin. So whats going on?

So close,
-Gene

[mattmeck]

sounds like a NAT issue

[Geneandjims]

Which means I do what?

[mattmeck]

read the nat sticky maby /shrug

[Geneandjims]

Well I checked out the NAT stickie and downloaded the no-ip thing but does this mean I have to be online for my server to be playable because I do not want that all I want is a server for me and my little brother to play over lan.

:shock: :shock: :shock:,
-Gene

[flyonthewall]

Ok though mabey i would throw my two cps worth into this, I only have one q, in your most recent post i notice that you said this


THIS IS MY MINILOGIN SERVERLOGIN.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 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=192.168.0.2
loginport=5999
worldname=Genes Ultra
worldaddress=***.***.***.**
locked=false
account=
password=

[WorldServer]
Defaultstatus=0
Unavailzone=

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

-----


Is that what your miniloginaccounts.ini file says. I currently have mine set as the following

-------------------------------------------
(Ip #)_username_password_
(Ip #)_username_password_
ect..
-------------------------------------------
Now minus the () marks around your ip and everywhere you see a _ mark make sure there is a space there

Example. Your Ip Address is 111.111.111.111 and your going to be using the username and password of eqemu and eqemu

---------------------------------------------------
111.111.111.111 eqemu eqemu
---------------------------------------------------

there is a space after the last eqemu, simply contiue the process for all the comps that are going to be loging in under your server.
Also i belive that you need to add the accounts under your mysql db.

Here is my post on my personal server that i ran just on my comp, doesnt go across lan, and i do not have a perm internet connection as i am on dial up.

http://www.eqemulator.net/forums/viewtopic.php?t=12406

Dont know if this info could help you Gene, as i dont know to much about lan. But i might be misreading your post and putting something up that has completly no relavance to your situation. I have been seeing your post all over the boards and i do wish you the best of luck on getting this going! :D