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]

Originally Posted by Geneandjims

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.

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=