Server DB Problems!
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 |
I would find a new database or try resourcing the one you currently have.. as for the eqtime.cfg you can ignore that.
|
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 |
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. |
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 |
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 |
verify that the cfg files in your cfg directory are not read only
|
Nope not read-only.
|
Quote:
I noticed that you are useing minilogin as well? Try Changeing the 127.0.0.1 in boot5zones.bat to you local ip address |
-----------------------
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?
|
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.
|
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. |
That didn't work either :( . I could post my server's info like login and database if that will help.
|
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= |
| All times are GMT -4. The time now is 06:51 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.