Can't connect to my server

Hi everyone,

I already posted on the thread treating connection to server problems but didn't get an answer so...In case my question was inapporpriate there, i post it here on my own :


I'm coming here cause I have troubles connecting on my server.

First not to be the bothering one, I followed all PDF guides and here is what I can describe :

Win7 Host : 192.168.0.10
CentOS VMWare : 192.168.0.20

Installed and restored DataBases one my Win7 machine as described : OK
--> ui : sa / pwd : test
--> created cabal account with rights (SQL)
--> Linked server seems to be OK
installed CentOS : OK
--> Cabal repack 2.8 installed : OK
--> Configuration runned : Server IP : 192.168.0.20, SQL server 192.168.0.10, login : sa, pwd : test
--> Services started : OK

Ping between CentOS and Windows : OK

I used GMTools to create the account (id : user1 // pwd : test)

My client has been take on the site :
Cabal_Setup_US_12162009
Patch : 2.8

I followed the guide to start a client (internal.txt) :
IP=192.168.0.20
PORT=38101
CHAT_IP=192.168.0.20
CHAT_PORT=38121

Cabal start.bat :
@echo off
start CabalMain.exe breaklee
exit

I'd like not to have to bother any of you but...I really need your help cause...I can't find what's wrong, When I try to log in with my account user1/test, connexion fails...

PS : I'm available on skype (vgout69)

I have bases on networking and databases it's just getting old for me.
Thanks a lot for your help !!
(Logs are in attachment if needed)
Thanks again !

Logs : http://forum.ragezone.com/attachment...-read-logs.rar

It's failing at the user/pass screen and if it fails there then the server cannot talk to the database. There are no database connect successful messages in your log files either.

Run this query on any database and post the results. It will see if SQL is configured correctly.

Code:

---

Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
  set @insname='MSSQLSERVER'
else
  set @insname=convert(varchar(25),serverproperty('instancename'))
  select @insname as 'Instance',
  serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
  serverproperty('edition') as 'Edition'
  if @insname<>'MSSQLSERVER'
  begin
    select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
  end

  begin
    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 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
      end
    else
      begin
        select 'This is good! I have nothing to do :(' as 'Remote connections checker'
      end
    select account.dbo.fn_md5('test') as 'xp_md5.dll check'
  end

---

Hi chumpywumpy,

(I'm french sorry if sometime i don't make myself understood as I should...I hope it's ok)
Thanks a lot for coming helping me.
I followed all your guides thoroughly so I think I'm not coming here for bad reasons.

Thanks a lot for you advice, i executed this query on my DB and...to be honnest I don't really know how to read the result so I post in attachment the result as a picture but at the first look, I think everything is OK...You'll tell me.

Thanks again for your help !

Yap,from what it seems you cannot connect to your server because you did not forwarding some ports what windows and server need and dont forget to disable your firewall(unless you knows what to add except ports in firewall)

P/S:If u want to see if your server is connected corectly to your database just type this command: cat DBAgent_01.log,If its show something like Database is connect with succes!,thats mean its connected good,but dont forget to forwarding ports

Hi all0c3n,

About my port forwarding :
I check when I installed VMWare and I applied the procedure.
I followed the section about port forwarding.

I did what was asked. I give you a screen shot of my confirguration on the firewall and of the website conyouseeme that confirms my forwarding seems OK.

The log I have isn't called DBAgent_01.log but GlobalDBAgent.log and you're right it doesnt make any trace of successfull connection.

Can you tell me if there is somethins missing like on the Win7 host machine that should forward or something...I really don't know.
Thanks for your help



PS : I just cleaned the logs and here is what is in GlobalDBAgent.log right after starting cabal server ("service cabal start") :

[Wed Feb 9 2011 15:30:28.151364 3086943936]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Wed Feb 9 2011 15:30:28.151529 3086943936]: LOG LEVEL: 3
[Wed Feb 9 2011 15:30:28.151580 3086943936]: MemPoolUnitSizeClass(0): 14336Bytes
[Wed Feb 9 2011 15:30:28.154484 3086943936]: Start GlobalDBAgent Server
[Wed Feb 9 2011 15:30:28.156474 3086943936]: UseEcryptText (Off)
[Wed Feb 9 2011 15:30:28.174399 3086941088]: CProcessLayer(0)::svc Start [3086941088]
[Wed Feb 9 2011 15:30:28.174541 3076451232]: CProcessLayer(0)::svc Start [3076451232]
[Wed Feb 9 2011 15:30:28.175347 3065961376]: CProcessLayer(0)::svc Start [3065961376]
[Wed Feb 9 2011 15:30:28.175444 3055471520]: CProcessLayer(0)::svc Start [3055471520]
[Wed Feb 9 2011 15:30:28.175564 3044981664]: CProcessLayer(0)::svc Start [3044981664]
[Wed Feb 9 2011 15:30:28.176505 3086943936]: try listening 38180 port
[Wed Feb 9 2011 15:30:28.177321 3034491808]: CProcessLayer(0)::svc Start [3034491808]
[Wed Feb 9 2011 15:30:28.177403 3024001952]: CProcessLayer(0)::svc Start [3024001952]
[Wed Feb 9 2011 15:30:28.177501 3013512096]: CProcessLayer(0)::svc Start [3013512096]
[Wed Feb 9 2011 15:30:28.178280 3003022240]: CProcessLayer(0)::svc Start [3003022240]
[Wed Feb 9 2011 15:30:28.178415 2992532384]: CProcessLayer(0)::svc Start [2992532384]
[Wed Feb 9 2011 15:30:28.841329 3086943936]: accept success 8(127.0.0.1:32824)
[Wed Feb 9 2011 15:30:28.844308 3086943936]: 1.open user 8 [87D7BC0] (127.0.0.1)
[Wed Feb 9 2011 15:30:33.134446 3086943936]: accept success 10(127.0.0.1:32832)
[Wed Feb 9 2011 15:30:33.135478 3086943936]: 2.open user 10 [87E6300] (127.0.0.1)

maybe the xx.xx.0.20 IP you assigned to CentOS is allready used by another machine in your network...try using another IP..disable your firewall completely or any antivirus you got and give it a try...

192.168.0.20 IP is assigned to CentOS and I'm sure it can't be given to any other machine.
I don't have any firewall to stop...
I'm getting lost guys :S

Thanks a lot for help...hope we'll solve it

Quote:

---

Originally Posted by Vgout69

Hi chumpywumpy,

(I'm french sorry if sometime i don't make myself understood as I should...I hope it's ok)
Thanks a lot for coming helping me.
I followed all your guides thoroughly so I think I'm not coming here for bad reasons.

Thanks a lot for you advice, i executed this query on my DB and...to be honnest I don't really know how to read the result so I post in attachment the result as a picture but at the first look, I think everything is OK...You'll tell me.

Thanks again for your help !

---

Your English is much better than my French so don't worry about that ;)

The SQL server is installed perfectly. Is the Windows firewall enabled? Something is blocking connection from centos to the database.

I noticed some errors in your logs..try using this method,maybe it will fix your problem.. http://forum.ragezone.com/f460/remov...server-576629/

@chumpy better look again at the logs because there are some errors :lol:

Hi all,

I followed the guide for removing linked server (dbo.sp_newchar and db.sp_delchar)

Then I deleted the linked server and executed the query :


/****** Object: LinkedServer [GAMESERVER] Script Date: 00/00/0000 00:00:00 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'GAMESERVER', @srvproduct=N'GameServer', @provider=N'MSDASQL', @provstr=N'DRIVER={SQL Server};SERVER=LOCALHOST;UID=SA;PWD=test;'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GAMESERVER',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GAMESERVER',@useself=N'True',@locallogin=N'NT AUTHORITY\SYSTEM',@rmtuser=NULL,@rmtpassword=NULL
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GAMESERVER',@useself=N'True',@locallogin=N'sa',@rmtuser=NULL,@rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'collation compatible', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GAMESERVER', @optname=N'use remote collation', @optvalue=N'true'




And the result I have is this :

Msg 15007, Niveau 16, État 1, Procédure sp_addlinkedsrvlogin, Ligne 76
'NT AUTHORITY\SYSTEM' n'est pas une connexion valide ou vous ne possédez pas d'autorisation.


In english : 'NT AUTHORITY\SYSTEM' isn't a valide connexion or you don't have the rights.

try using the lower one by "TheMaker99"...

Hi again,

With "TheMaker99"'s query, I have exactly same result and same message.
BTW the linked server is created, I can see it after refreshing.

I installed cabal serv again with same conf (but clean and new).
I checked the log after started the server and tried to connect. I post my logs. I checked and didn't see any error like before ! So maybe now the solution's easier.

At least I hope so.

Thks again everyone for your time ! can't wait to make it work

well i saw some succesfull connections on the login logs...you still can't login or what?

Still not..."You failed to connect server"...

---------- Post added at 10:59 PM ---------- Previous post was at 10:47 PM ----------

Restarted server services and after 2 unsuccessful atempts:


LoginSvr_01
WorldSvr_24_01
CashDBAgent
ChatNode_24
DBAgent_24
GlobalDBAgent
GlobalMgrSvr

man,i'm sorry but i'm out of ideas...what SQL are you using?