PDA

View Full Version : Unable to log in to own server...


Dondarrion
12-06-2003, 07:48 AM
I've noticed others able to connect to my server, as their accounts are added to my database, however, I am unable to connect to it myself. The router has the server set as a DMZ host, I've started over with a new database several times, and have a fully up to date version of the game; I can even connect and play fine on other servers. Upon connecting to my server, the World.exe displays the following,

2044160 New client from ip:65.29.60.131 port: 2256
Logged in: FirstLogin LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Logged in: LS#39342: Dondarrion
Client disconnected
Removing client from ip:65.29.60.131 port: 2256
2053660 New client from ip:65.29.60.131 port: 2256
Logged in: LS#39342: Dondarrion
Client disconnected
Removing client from ip:65.29.60.131 port: 2256

During this, the screen goes blank as though it were about to load the game, and there after, kicks me back to the server select screen.

I'm running a Windows ME operating system, MySQL 4.0 on a SMC 7004AWBR. I'ved sourced the latest blank, items, and mwnpc databases. The only error I recieve when starting up the server is in the World.exe when trying to load the eqtime.cfg, for there is no such file. Though, I would not assume this as the problem for others being able to join the server, and other posts noting it as okay.

My setup files are configured as follows,

db.ini:
[Database]
host=localhost
user=Dondarrion
password=*******
database=eq
compression=off

loginserver.ini:
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=A new testing
locked=false
worldaddress=65.29.60.131

[WorldServer]
Defaultstatus=0
Unavailzone=

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

boot5zones.bat:
REM:--------------Start-----------------------
@echo off

if NOT exist spells_en.txt goto NOSPELL

start zone . 65.29.60.131 7995 192.168.123.112
start zone . 65.29.60.131 7996 192.168.123.112
start zone . 65.29.60.131 7997 192.168.123.112
start zone . 65.29.60.131 7998 192.168.123.112
start zone . 65.29.60.131 7999 192.168.123.112
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------------------------

Any suggestions on how to fix this problem would be appreciated, as I am quite stumped at the moment.

a_Guest03
12-06-2003, 09:41 AM
Try the NAT tutorial (http://www.everquestserver.com/forums/viewtopic.php?t=4177).

It recommends that you use a domain name from a free host to use in place of your real IP.

Dondarrion
12-07-2003, 12:02 PM
Ah, thank you for the speedy reply. Indeed, that does seem to fix my problem. Unfortunatly, a new problem has arisen. I can attempt to create a character, however, it seems no matter what name I choose, it is always rejected. There are no resriction rows in the name_filter table.
World.exe has the following to say on the matter:

0\0\0\etc...' WHERE account_id=1 and name='x'' #1054
: Unkown column 'timelaston' in 'field list'
database.CreateCharacter failed
Got a bogus character <x>, deleting it.
PP length =0

I'm not sure where the second line in the error above comes from. The column being unknown makes sense, since there is no table named "field list" in my database. Does the order in which one sources a database matter? I've source in the latest blank db.sql the latest itemsdump and the latest MWncp; I've tried sourcing in the Update0.5.1.sql posted, however it always fails for some unknown reason.