[2.3] DBServer wont connect

[3330]

yo all

after seeing all screenies of users servers, i noticed that my dbserver doesnt say "gate connected".... ive checked all ports, all ips, even the database seems to be ok, but dbservers gate wont connect.... maybe thats y after char selection i get kicked off server....


ne hint?

 

[daneo1989]

well which file's are you using? i would guess your not conecting to your database make sure your username/password is correct. and make sure it's going to the right place and make sure you have the same name.


/ancient

 

[3330]

while installing sql ive set mixed auth. mode and set pass "sa" as usual...
but in dbsrc.ini also talks about an id.... where do i get it?

 

[3330]

heres my dbsrc.ini:

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=(local)
SQLPort=3306
SQLDatabase=Mir2
SQLUsername=sa
SQLPassword=sa
[Setup]
ServerName=ktest
ServerAddr=127.0.0.1
ServerPor=6000
MapFile=c:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=127.0.0.1
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=127.0.0.1
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=c:\Mirserver\DBServer\FDB\
IdDir=c:\Mirserver\DBServer\FDB\
HumDir=c:\Mirserver\DBServer\FDB\
FeeDir=c:\Mirserver\DBServer\FDB\
BackupDir=c:\Mirserver\DBServer\Backup\
ConnectDir=c:\Mirserver\DBServer\Connection\
LogDir=c:\Mirserver\DBServer\Log\
[Backup]
AutoBackup=0
BackupTime=18000000

 

[DeathsDoor]

did u name ur database Mir2 or mir2 without the capital M

see if thats your problem then reply

 

[jasper]

or try

SQLHost=localhost

 

[koni]

or try

SQLHost=localhost

mine is the same as his (local) and works fine

is your sql password really the same as the username ?

does the db server display anything ?
any error messages ?
any chance of a screenshot of the gate running ?

here is a copy of my dbsrc and mine works fine, obviously ive edited my password, but mine is not the same as the login "sa"

[Reg]
Key=0123456789
ServerAddr=192.168.0.2
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=(local)
SQLPort=3306
SQLDatabase=lom2
SQLUsername=sa
SQLPassword=********
[Setup]
ServerName=KoniUK
ServerAddr=192.168.0.2
ServerPor=6000
MapFile=C:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=192.168.0.2
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=192.168.0.2
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=C:\mirserver\DBServer\FDB\
IdDir=C:\mirserver\DBServer\FDB\
HumDir=C:\mirserver\DBServer\FDB\
FeeDir=C:\mirserver\DBServer\FDB\
BackupDir=C:\mirserver\DBServer\Backup\
ConnectDir=C:\mirserver\DBServer\Connection\
LogDir=C:\mirserver\DBServer\Log\
[Backup]
AutoBackup=1
BackupTime=18000000

are you running on a router ?

is your firewall stopping the gate ?

are all the other gates connecting ?

 

[3330]

i use a router but all ports are opened on it, even if im doing my server offline (127.0.0.1)

 

[koni]

iam sure if your on a router your ips need to be 192.168.*.* what ever your internal ip is, because when your on a router your offline ip will not be 127.0.0.1 it will be 192.168.*.*

change the ips in your files to your internal ip addy like my db server dbsrc has my internal ip 192.168.0.2 i dont know what your one will be, to find out

goto cmd prompt and type ipconfig /all

that will give you the ip's on your network

 

[3330]

done it, but no ips start with 192.168 etc

 

[koni]

?

so your internal ip doesnt start with 192.168. ?

are you def on a router ?

 

[3330]

yep...
btw my gamegate.exe keeps saying something about a sockettest and dbserver.exe comes with a popup: list index out of bunds(1)

ne hlp?
u got msn? add me [email protected]

 

[Elvin]

try any of these 3
SQLHost=(local)
SQLHost=localhost
SQLHost=127.0.0.1


ID you say is that this line ur on about IdDir=c:\Mirserver\DBServer\FDB\

if so its not used anymore its just there to look pretty and help it along abit :P

 

[KnightRider]

what sql u got? 2000 or 2005?

 

[3330]

sql 2k---------------

 

[Karl]

post your ipconfig /all

 

[3330]

heres the link 2 the screenshot of my ipconfig /all

http://img176.imageshack.us/img176/5210/ipconfigad6.gif

 

[3330]

uuuuuuuuppppppp