in db connect

[ilia333]

Hello i have the folowing problem

[Thu Apr 23 2009 18:02:46.680815 3086214864]: open log file '/var/log/cabal/DBAgent_24.log'
[Thu Apr 23 2009 18:02:46.681467 3086214864]: LOG LEVEL: 3
[Thu Apr 23 2009 18:02:46.681531 3086214864]: MemPoolUnitSizeClass(2): 24576Bytes
[Thu Apr 23 2009 18:02:46.684849 3086214864]: Start DBAgent_24 Server
[Thu Apr 23 2009 18:02:46.686901 3086214864]: UseEcryptText (Off)
[Thu Apr 23 2009 18:02:46.710869 3086211984]: CProcessLayer(0)::svc Start [3086211984]
[Thu Apr 23 2009 18:02:46.711479 3075722128]: CProcessLayer(0)::svc Start [3075722128]
[Thu Apr 23 2009 18:02:46.712802 3086214864]: try listening 38181 port
[Thu Apr 23 2009 18:02:46.713549 3054742416]: CProcessLayer(0)::svc Start [3054742416]
[Thu Apr 23 2009 18:02:46.713903 3044252560]: CProcessLayer(0)::svc Start [3044252560]
[Thu Apr 23 2009 18:02:46.714793 3065232272]: CProcessLayer(0)::svc Start [3065232272]
[Thu Apr 23 2009 18:02:47.314869 3086214864]: accept success 8(127.0.0.1:58060)
[Thu Apr 23 2009 18:02:47.319528 3086214864]: 1.open user 8 [9410B28] (127.0.0.1)
[Thu Apr 23 2009 18:02:47.938442 3086214864]: accept success 10(127.0.0.1:58062)
[Thu Apr 23 2009 18:02:47.938986 3086214864]: 2.open user 10 [941F250] (127.0.0.1)
[Thu Apr 23 2009 18:03:04.905468 3075722128]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:03:04.905977 3075722128]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:03:04.906042 3075722128]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:03:04.906103 3075722128]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:03:04.906164 3075722128]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:03:04.906217 3075722128]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:03:04.906356 3075722128]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:03:04.906409 3075722128]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:03:04.906468 3075722128]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Apr 23 2009 18:03:04.954243 3054742416]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:03:04.954344 3054742416]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:03:04.954399 3054742416]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:03:04.954449 3054742416]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:03:04.954499 3054742416]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:03:04.954555 3054742416]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:03:04.954711 3054742416]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:03:04.954773 3054742416]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Thu Apr 23 2009 18:03:04.954835 3054742416]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Thu Apr 23 2009 18:03:04.992964 3044252560]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:03:04.993047 3044252560]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:03:04.993091 3044252560]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:03:04.993132 3044252560]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:03:04.993172 3044252560]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:03:04.993214 3044252560]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:03:04.993258 3044252560]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:03:04.993299 3044252560]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Thu Apr 23 2009 18:03:04.993929 3044252560]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Thu Apr 23 2009 18:03:47.933469 3086211984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:03:47.934450 3086211984]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:03:47.934517 3086211984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:03:47.934574 3086211984]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:03:47.934629 3086211984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:03:47.935304 3086211984]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:03:47.935368 3086211984]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:03:47.935421 3086211984]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:03:47.935484 3086211984]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Apr 23 2009 18:04:47.948288 3065232272]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:04:47.949054 3065232272]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:04:47.949101 3065232272]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:04:47.949144 3065232272]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:04:47.949186 3065232272]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:04:47.949228 3065232272]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:04:47.949273 3065232272]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:04:47.949314 3065232272]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:04:47.949362 3065232272]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Apr 23 2009 18:05:47.953556 3065232272]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:05:47.953982 3065232272]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:05:47.954028 3065232272]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:05:47.954070 3065232272]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:05:47.954112 3065232272]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:05:47.954335 3065232272]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:05:47.954381 3065232272]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:05:47.954422 3065232272]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:05:47.954469 3065232272]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Apr 23 2009 18:06:47.932007 3086211984]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:06:47.932754 3086211984]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:06:47.932800 3086211984]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:06:47.932843 3086211984]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:06:47.932885 3086211984]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:06:47.932927 3086211984]: [##ERROR##] Database Connect Fail (uid=sa;pwd=62260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:06:47.932972 3086211984]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:06:47.933013 3086211984]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:06:47.933061 3086211984]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Apr 23 2009 18:07:47.953767 3065232272]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 23 2009 18:07:47.954218 3065232272]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 23 2009 18:07:47.954285 3065232272]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 23 2009 18:07:47.954345 3065232272]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 23 2009 18:07:47.954405 3065232272]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 23 2009 18:07:47.954463 3065232272]: [##ERROR##] Database Connect Fail (uid=sa;pwd=6260037;dsn=CabalGame24;APP=DBAgent_24)
[Thu Apr 23 2009 18:07:47.954879 3065232272]: [##ERROR##] check 'pDB' fail
[Thu Apr 23 2009 18:07:47.954933 3065232272]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Apr 23 2009 18:07:47.954998 3065232272]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)

as you know i have to connect to my win pc.and there is 127.0.0.1
when i am runing /home/cabal/cabal_config.sh i insert my win pc ip but it stil connect to 127.0.0.1
can some one help me fix it? thanke you any way

[MentaL]

[cypher]

Post your odbc.ini files from /etc

[ilia333]

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

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

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

[chumpywumpy]

Are you using mssql 2005 express? If you are it must not be installed as a "named instance" (which is default on 2005 express) and you must also enable remote connections as they are disabled by default. You can't switch a named instance to a default one and so unless you specifically changed this during installation you have to uninstall and reinstall. Remote connections are enabled in the surface area tool in the startmenu.

Check the PDF guide in my sig if you need to reinstall.

[ilia333]

Now i have this error :
[Fri Apr 24 2009 22:23:10.816825 3054586768]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Fri Apr 24 2009 22:23:10.817303 3054586768]: [##ERROR##] DB ERROR(CODE) : 20009
[Fri Apr 24 2009 22:23:10.817349 3054586768]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Apr 24 2009 22:23:10.817392 3054586768]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Fri Apr 24 2009 22:23:10.817434 3054586768]: [##ERROR##] DB ERROR(STM_TEXT) :
[Fri Apr 24 2009 22:23:10.817477 3054586768]: [##ERROR##] Database Connect Fail (uid=server;pwd=6267737;dsn=CabalGame01;APP=DBAgent_01)
[Fri Apr 24 2009 22:23:10.817587 3054586768]: [##ERROR##] check 'pDB' fail
[Fri Apr 24 2009 22:23:10.817630 3054586768]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Fri Apr 24 2009 22:23:10.817720 3054586768]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)

[chumpywumpy]

It's the same error, "Server is unavailable or does not exist.". It can't connect to the database.

Can you ping the windows IP from centos with the "ping" command? Is the windows firewall off?

EDIT: In SQL run the following command and tell me what it says:

SELECT @@ServerName

[ilia333]

It's the same error, "Server is unavailable or does not exist.". It can't connect to the database.

Can you ping the windows IP from centos with the "ping" command? Is the windows firewall off?

EDIT: In SQL run the following command and tell me what it says:

SELECT @@ServerName

Command(s) completed successfully.


--- 192.168.2.108 ping statistics ---
9 packets transmitted, 9 received, 0% packet loss, time 8004ms
rtt min/avg/max/mdev = 0.236/0.813/1.581/0.340 ms

man you are my last hope

[chumpywumpy]

Command(s) completed successfully.

It should have showed a result too.

I have been messing around a little with things to help solve problems like this. Paste all of the following into a query window and run it (doesn't matter which DB).

Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
set @insname='MSSQLSERVER'
else
set @insname=convert(varchar(25),serverproperty('instancename'))
select host_name() as 'HostName',@insname as 'Instance',
serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'Level',
serverproperty('edition') as 'Edition'
if @insname<>'MSSQLSERVER'
begin
select 'THIS IS BAD! You must reinstall MSSQL' as 'MSSQL is a named instance!'
end

Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
@value_name=@insname,
@value=@inspath OUTPUT
set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg,
@value_name='Enabled',
@value=@tcpremote OUTPUT
select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
if @tcpremote='0'
begin
EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
select '! Please reboot !' as 'I had to enable remote connections'
end

It should look something like the attached image, not the one with the red boxes.

[ilia333]

WINDOWSXPSP3 NULL 9.00.1399.06 RTM Express Edition



NULL NULL

Instance set to NULL

there is screan shot
i am sorry for the Wpost please remove this replay when you will see the screan shot

[GunKill]

I already tried the script.
But got no idea what's about it.

[chumpywumpy]

I already tried the script.
But got no idea what's about it.

The command told me what was wrong with yours, it's an instance (i updated your post). I bet it shows remote connections off too. You will need to reinstall.

WINDOWSXPSP3 NULL 9.00.1399.06 RTM Express Edition



NULL NULL

Instance set to NULL

there is screan shot
i am sorry for the Wpost please remove this replay when you will see the screan shot

That is very strange, it can't find the instance or the remote connection setting. Try opening the surface area tool from startmenu and manually setting remote connection on for TCP/IP and run the script again and see if he value change.

[ilia333]

nope no chaanges

[GunKill]

Sorry for the late replies.
I just reinstalled it without a named instance.
It returned to me JAZ only, now what should I do?
(i feel excited)

[chumpywumpy]

nope no chaanges

Do you have an English windows or another language?

The script is looking here for the instancename, does the path exist (the instancename should be "mssqlserver")?
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\

It checks the TCP folder here to see if remote connections are enabled. This does depend on it working out the correct instance name though which will be why it fails as it can't find the instance.
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\

Sorry for the late replies.
I just reinstalled it without a named instance.
It returned to me JAZ only, now what should I do?
(i feel excited)

That sounds better. Run the script i posted in this topic earlier in a query window. The results will appear underneath, it shouldn't be complaining about instances anymore but it should show remote connections = 1 (or force it set and tell you to reboot). As long as the results don't tell you to do anything the SQL server config is correct and as long as centos can ping windows the server should be able to connect now.

EDIT: Didn't spot the image. All looks fine, test it!

[GunKill]

OK sir thanks, just installing the dbs and reconfig the server files.
@TS
Just run the setup of MSSQL EXPRESS 2005 and try to reinstall it with the guide of sir chumpy (worked for me). I hope you get your server to connect to.

[ilia333]

Hahaha chumpywumpy
i found the problem.now i have 0 errors but still can't connect XD
i hvae the line in client thet shows me that he tring to connect to server but it can't .
can it be becouse of client problem ?
i have gp client and i am using you'r patch.

[chumpywumpy]

That is probably down to using the wrong ip addresses in either the server or internal.txt. There is a basic networking guide in my sig which explains which address to use.

[ilia333]

i have this error now
[Sat Apr 25 2009 16:01:20.190758 3065633680]: [##ERROR##] DB ERROR(MSG) :
[Sat Apr 25 2009 16:01:20.191153 3065633680]: [##ERROR##] DB ERROR(CODE) : 0
[Sat Apr 25 2009 16:01:20.191203 3065633680]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sat Apr 25 2009 16:01:20.191247 3065633680]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Sat Apr 25 2009 16:01:20.191289 3065633680]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Sat Apr 25 2009 16:01:20.232289 3065633680]: Database Connect success!
[Sat Apr 25 2009 16:01:20.232379 3065633680]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Sat Apr 25 2009 16:01:20.232453 3065633680]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)

[chumpywumpy]

It's a blank database. You don't have any war results for it to get yet :P

[ilia333]

It's a blank database. You don't have any war results for it to get yet :P

so skip this error?
and i still cant login :(
can you give me link to 100% working client?

[cypher]

no client is 100% working but it a pretty good one. ogplanet + chumpy`s patch

[ilia333]

when i am open the server i have message thet i am disconected from the server can you give me link to patch?

[GunKill]

Hey guys, little confuse, my server can't connect to the database source even it is enabled.
What should I put on the MSSQL Server IP?

[chumpywumpy]

when i am open the server i have message thet i am disconected from the server can you give me link to patch?

Look in /etc/cabal/docs as you will find some useful references in there along with my client patch files and a description of my recommended client.

Hey guys, little confuse, my server can't connect to the database source even it is enabled.
What should I put on the MSSQL Server IP?

The MSSQL IP should be the IP of the windows computer.