Server still locked :: Help me plz

[fnemo]

Hardware:
Athlon XP1700+
Ram 512 MB
HD Seagate 18.1 GB LVD U160
Software:
Windows 2K Pro SP1

Originally Posted by loginserver.ini

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=20000 miles inside Norrath
locked=false
account=
password=
worldaddress=fnemo.no-ip.org

[WorldServer]
Defaultstatus=
Unavailzone=

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

Originally Posted by boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . fnemo.no-ip.org 7995 127.0.0.1
start zone . fnemo.no-ip.org 7996 127.0.0.1
start zone . fnemo.no-ip.org 7997 127.0.0.1
start zone . fnemo.no-ip.org 7998 127.0.0.1
start zone . fnemo.no-ip.org 7999 127.0.0.1
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

Originally Posted by db.ini

# READ README.TXT!

[Database]
host=localhost
user=*****
password=*****
database=eq


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

I linked the result of the world.exe once i launched boot5zones.bat

[Shawn319]

Originally Posted by fnemo

worldaddress=fnemo.no-ip.org

worldaddress=YOURREAL IP

dont use DNS's.

Originally Posted by boot5zones.bat

start zone . fnemo.no-ip.org 7995 127.0.0.1
start zone . fnemo.no-ip.org 7996 127.0.0.1
start zone . fnemo.no-ip.org 7997 127.0.0.1
start zone . fnemo.no-ip.org 7998 127.0.0.1
start zone . fnemo.no-ip.org 7999 127.0.0.1

Dont use DNS's.. and that 127.0.0.1 needs to be your REAL IP address, not 127.0.0.1.

IP PORT IP

Originally Posted by db.ini

# READ README.TXT!

[Database]
host=localhost
user=*****
password=*****
database=eq

This is fine.

[Trumpcard]

What's wrong with dns ?

Here's what I have always used, and it works fine..

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=The Halls of Paranor
worldaddress=xxx.dyndns.org
locked=false

./zone . xxx.dyndns.org 7995 127.0.0.1 &
./zone . xxx.dyndns.org 7996 127.0.0.1 &

This is linux though, so might be a difference there, but i wouldnt think so..


His problem looks like a bad database..

eq.zoneservers doesnt exist.. I'd suggest recreating his eq database.

[fnemo]

I delete all the DB and resource it with only the db.sql from the last release and still got the same problem.
I also tried the IP thing, but there is still the problem :(

[Trumpcard]

go into mysql>

type use eq;

then

show tables;

if zoneserver_auth is there, type

describe zoneserver_auth;

[fnemo]

no "zoneserver_auth" in the tables :(

[Trumpcard]

Well, that would be your problem...


What db.sql are you using? Its definitely in the 0.4.1 release db.sql

[fnemo]

I just redownloaded it from Sourceforge on another server and still no "zoneserver_auth" :(

[Trumpcard]

use eq;

show tables;


what tables DO you see?

[fnemo]

here you are :

[Trumpcard]

Open up the db.sql you sourced in... Do a search for zoneserver_auth

Verify that table is in the sql file.

For some reason its not in your database.

[fnemo]

/dev/n00b rocks !
We tried several base db.sql. all were corrupted (?!). Then he send me his and it works perfectly !!!

Thx again