EQEmulator Forums - Server still locked

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

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

- - Server still locked :: Help me plz (https://www.eqemulator.org/forums/showthread.php?t=4717)

Server still locked :: Help me plz

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

Quote:

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=

Quote:

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

Quote:

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

Re: Server still locked :: Help me plz

Quote:

Originally Posted by fnemo

worldaddress=fnemo.no-ip.org

worldaddress=YOURREAL IP

dont use DNS's.

Quote:

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

Quote:

Originally Posted by db.ini

# READ README.TXT!

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

This is fine.

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.

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

go into mysql>

type use eq;

then

show tables;

if zoneserver_auth is there, type

describe zoneserver_auth;

no "zoneserver_auth" in the tables :(

Well, that would be your problem...

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

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

use eq;

show tables;

what tables DO you see?

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.

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

Thx again :)