Can't connect to DB!

[Just_Rytis]

Hi, my server can't connect to Database. I setted my CentOS IP in all files and my server still can't connect. I'm using router(ASUS RX3041), in router I forwarded 1433(SQL),38111(SERVER) ports and in ODBC.ini setted my external IP(don't work and with Windows IP). Please help me some1! Thx!

[MentaL]

[Just_Rytis]

I have this error. That's bad? Thx!

[Sat Jul 19 2008 06:19:38.226079 3086461152]: open log file  '/var/log/cabal/DBAgent_24.log'
[Sat Jul 19 2008 06:19:38.251368 3086461152]: LOG LEVEL: 3
[Sat Jul 19 2008 06:19:38.251457 3086461152]: MemPoolUnitSizeClass(2): 24576Bytes
[Sat Jul 19 2008 06:19:38.252356 3086461152]: Start DBAgent_24 Server
[Sat Jul 19 2008 06:19:38.253023 3086461152]: UseEcryptText (Off)
[Sat Jul 19 2008 06:19:38.253634 3086457744]: CProcessLayer(0)::svc Start [3086457744]
[Sat Jul 19 2008 06:19:38.253829 3075967888]: CProcessLayer(0)::svc Start [3075967888]
[Sat Jul 19 2008 06:19:38.253944 3065478032]: CProcessLayer(0)::svc Start [3065478032]
[Sat Jul 19 2008 06:19:38.254219 3086461152]: try listening 38181 port
[Sat Jul 19 2008 06:19:38.254525 3054988176]: CProcessLayer(0)::svc Start [3054988176]
[Sat Jul 19 2008 06:19:38.254695 3044498320]: CProcessLayer(0)::svc Start [3044498320]
[Sat Jul 19 2008 06:19:38.896063 3086461152]: accept success 8(192.168.1.3:57571)
[Sat Jul 19 2008 06:19:38.896889 3086461152]: 1.open user 8 [88C7FE8] (192.168.1.3)
[Sat Jul 19 2008 06:19:39.519027 3086461152]: accept success 10(192.168.1.3:57575)
[Sat Jul 19 2008 06:19:39.519258 3086461152]: 2.open user 10 [88D6728] (192.168.1.3)
[Sat Jul 19 2008 06:26:18.955833 3065478032]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Sat Jul 19 2008 06:26:18.955934 3065478032]: [##ERROR##] DB ERROR(CODE)     : 20009
[Sat Jul 19 2008 06:26:18.955969 3065478032]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Jul 19 2008 06:26:18.955998 3065478032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Sat Jul 19 2008 06:26:18.956026 3065478032]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Sat Jul 19 2008 06:26:18.956052 3065478032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=lamukas;dsn=CabalGame24;APP=DBAgent_24)
[Sat Jul 19 2008 06:26:18.956264 3065478032]: [##ERROR##] check 'pDB' fail
[Sat Jul 19 2008 06:26:18.956326 3065478032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Sat Jul 19 2008 06:26:18.956359 3065478032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(192.168.1.3)

[chumpywumpy]

Check /etc/odbc.ini and make sure there is a [CabalGame24] section. Your DBAgent_24.ini has the user/pass and the other details it is using are in the odbc.ini. It won't be permissions as you are using the sa account so it's either got te wrong ip or a wrong dsn (the [CabalGame24] section).

[Just_Rytis]

Here is my configs, I didn't see here anything bad.

CentOS IP: 192.168.1.3
Windows IP: 192.168.1.2

odbc.ini

[CabalGame24]
Driver      = FreeTDS
Address     = 192.168.1.2
Port        = 1433
Database    = GAMEDB
TDS_Version = 8.0

[CabalAccount]
Driver      = FreeTDS
Address     = 192.168.1.2
Port        = 1433
Database    = ACCOUNT
TDS_Version = 8.0

[CabalCash]
Driver      = FreeTDS
Address     = 192.168.1.2
Port        = 1433
Database    = CabalCash
TDS_Version = 8.0

DBAgent_24.ini

[NetLib]
Port=38181
SendMaxBufSize=65536
SendMaxBufSizeUserHandler=131072
SendMaxBufSizeLinkHandler=1048576
ProcessDataLimit=10000
MaxUserNum=2048
WatchsNoPackLimit=100000
SystemLogTTimeOut=100
ReactorTimeOut=-1
LogLevel=3
MemPoolUnitSizeClass=2

[DBAgent]
ServerIdx=24
DBProcessTNum=5
DSN=CabalGame24

[DSN]
DBId=sa
DBPwd=lamukas
DBAppName=DBAgent_24

[chumpywumpy]

In which case you are probably missing either the instantwar tables or the stored procedure it's calling. Try backing up your current db and replacing it with the one below as that works ok for me. It's in mssql 2000 format so it should restore on either version and it is a backup file that needs restoring, not attaching.

http://www.mediafire.com/?dddgdfhmdyb

[Just_Rytis]

Thx, but still same :-(

[chumpywumpy]

Are you using SQL2005 express? If so there are 2 things that might be the cause.

1. Open the "surface area" config tool from the start menu and make sure the server allows remote connections via TCP/IP as by default it doesn't.

2. Express installs as a "named instance" be default and this isn't what you want. Check the service name under services and if it mentions "SQLEXPRESS" then SQL was installed wrong. Uninstall it and reinstall, check for the panel that mentions named instances and set it to "default instance". You might be able to get around it by specifying "192.168.1.2\SQLEXPRESS" in place of the server name but i have not tried it so it might not work.

[Just_Rytis]

No, I'm using SQL 2000 but I didn't have SP4, did I need it? Thx!

[Zabuza]

i think u need SQL 2000 + SP4

[Just_Rytis]

I installed SQL 2000 SP4 and same problem :-( Someone know what's bad? Thx!

[ChaosPower]

did u exec the dll?
have you check the sql authentication (counterpart of local authentication)?
any firewalls (router and os)?

[Just_Rytis]

I exec dll, authentication is SQL Server and Windows, I have Windows XP and router.

P.S. I'm using 2 PC's not VMWare!

[Just_Rytis]

Did none know what's bad? :-( Pls help! Thx!

[ChaosPower]

try loging in lan mode, if not restart d procedures (reinstall all) then follow snowman's or mahi's guide. to check for forward ports just do this example.

can be any ip add.

http://192.168.1.2:1433
if you see no errors or it is just a blank page then it has forwarded it to the right ip.
if you really need to check it, use online network check tools, and firewall off.

that is all I can do to help you.

___________________________________________

[Sat Jul 19 2008 06:26:18.955833 3065478032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
means odbc.ini not in proper directory.

[jiahao_94]

@ChaosPower: From your siggy... what directory should odbc.ini be in? /etc right?

[jiahao_94]

Dbl post bump. Hope someone can solve this soon, because we're having the same problems, except that he's using 2000 and I'm using 2005.

[ChaosPower]

@ChaosPower: From your siggy... what directory should odbc.ini be in? /etc right?

you should check d ip in the .ini

[Just_Rytis]

try loging in lan mode, if not restart d procedures (reinstall all) then follow snowman's or mahi's guide. to check for forward ports just do this example.

can be any ip add.

http://192.168.1.2:1433
if you see no errors or it is just a blank page then it has forwarded it to the right ip.
if you really need to check it, use online network check tools, and firewall off.

that is all I can do to help you.

___________________________________________

[Sat Jul 19 2008 06:26:18.955833 3065478032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
means odbc.ini not in proper directory.

I try http://192.168.1.2:1433 and were I see blank page when it's good. My odbc.ini is in etc folder and were is my windows ip's 192.168.1.2. so what's bad?

[ChaosPower]

try this location dood, leave a copy in /etc
go to /usr/etc just try it.

[Just_Rytis]

:-( Same.

From linux I can open http://192.168.1.2:80 but http://192.168.1.2:1433 can't, but from windows I can both. What's bad? Thx!

[ChaosPower]

EDIT:

this is the correct location that the odbc should be.

/usr/local/etc/

if that don't work then restart the install as I said earlier

[Just_Rytis]

I fixed it ;D I forgot what I'm have Sygate Firewall and on it I blocked sql traffic ;D Because I have other server ;D