[CD3.55] Remote SQL Setup

[woogyeman]

I purchased a new system to run my server on. Since security is always a problem I have decided to just host the game on the new server and host SQL remotely on another system on the LAN. Has anyone done this, and know what IP's to change and which to leave alone? I have searched around for a few days, but don't seem to be able to come up with an apropriate thread.

I changed IP's for DB's in Setup as well as in !Serverinfo, HolleyDBSvrEilP, CruelDragon3g.ini, RegServer, and Set1 DB Conn in TBL_PUBIPS. All others are as they were.

Sometimes after running netcheck and loader server will start and have STDItems Error 1, Most times when I run netcheck and loader Server will not start. But, if I run server on local machine (local to SQL) everything runs and loads perfectly.

I am running:
Working 3.55
SQL2000
intel core duo 1.8

CruelDragon3g
服务器IP=(local)
登陆帐户=sa
登陆密码=*****
数据库名=CruelDragon3GBaseData

HolleyDBSvrEilP
192.168.1.15

!Serverinfo
192.168.1.15,69.205.2.65:7200

RegServer
[Setup]
LocalIP=192.168.1.25
RegPort=7010
SQLIP=192.168.1.15
Username=sa
Password=******
MapName=0
Map_X=160
Map_Y=230
LoginPort=7000
LoginSrvPort=5500
LoginSrvIP=127.0.0.1
Account=Account
Game3G=Game3G
CruelDragon3GBaseData=CruelDragon3GBaseData
DispConnect=0
RegUser=1
ChangePassword=1
FindPassword=1
FindHum=1
DieToLift=1



Any help with this matter would be appreciated greatly. Thanks.

 

[Hazuki]

Change all references of (local) to the IP/name of the remote sql server.

In the !Setup editor change the middle column to remote sql server IP.

 

[Deathbringer]

I purchased a new system to run my server on. Since security is always a problem I have decided to just host the game on the new server and host SQL remotely on another system on the LAN. Has anyone done this, and know what IP's to change and which to leave alone? I have searched around for a few days, but don't seem to be able to come up with an apropriate thread.

I changed IP's for DB's in Setup as well as in !Serverinfo, HolleyDBSvrEilP, CruelDragon3g.ini, RegServer, and Set1 DB Conn in TBL_PUBIPS. All others are as they were.

Sometimes after running netcheck and loader server will start and have STDItems Error 1, Most times when I run netcheck and loader Server will not start. But, if I run server on local machine (local to SQL) everything runs and loads perfectly.

I am running:
Working 3.55
SQL2000
intel core duo 1.8

CruelDragon3g
服务器IP=(local)
登陆帐户=sa
登陆密码=*****
数据库名=CruelDragon3GBaseData

HolleyDBSvrEilP
192.168.1.15

!Serverinfo
192.168.1.15,69.205.2.65:7200

RegServer
[Setup]
LocalIP=192.168.1.25 <<< Change to 69.205.2.65
RegPort=7010
SQLIP=192.168.1.15
Username=sa
Password=******
MapName=0
Map_X=160
Map_Y=230
LoginPort=7000
LoginSrvPort=5500
LoginSrvIP=127.0.0.1
Account=Account
Game3G=Game3G
CruelDragon3GBaseData=CruelDragon3GBaseData
DispConnect=0
RegUser=1
ChangePassword=1
FindPassword=1
FindHum=1
DieToLift=1



Any help with this matter would be appreciated greatly. Thanks.

I've just had a look at mine on the dedi and thats the only thing I can see different in the layout.