i can't connect to my cabal server even all work out.

john007 · Apr 18, 2010

pings to LAN,WAN, database IPs all worked.. but i can't connect to my own server when start the servers all worked fine, no errors at all pluses normal windows 7 firewall off too pluses router all opened ports. what goes wrong?

schneemann101 · Apr 18, 2010

Is CentOS installed on your Game-PC?

you have to write in your cabal_config.sh the hamachi / Lan IP.
With Wan IP it dosen't work on your Game-PC.

have you installed on your Cabal-Client the Patch from your server?
have you edit the internal.txt in your x:\Cabal\Data folder?
what cabal-client do you use?

john007 · Apr 18, 2010

the recommended one by chumpy pluses all patched.. i tried with LAN IP too but i don't use hamachi. yes its installed in my window 7 with vmware.

schneemann**** do you have have MSN,YIM or any communication programs? maybe you cna help me out about it. i keep getting fail to connect to my server. hey why when i am finding my WAN IP it doesn't shows on the putty or terminal? but only show me that LAN IP for the centos that i assigned to it?

gezz i followed all chumpy guide it endings i can't connecting to my own server, Connecting to Server....ZzzzZzz 'Failed to connect to the server please try again LMAO good game guys thanks for the help maybe i will give it up if i can't try it some more times.

chumpywumpy · Apr 19, 2010

We need to see a set of logs from /var/log/cabal really. It failing to connect to the channel is normally a mis-configuration somewhere but there are several places it could be.

If cabal_config can't detect the WAN IP it means the DNS on centos isn't working. The DNS server in the centos networking (type "setup" at putty) should be the same ones as you see under "ipconfig /all" on Windows.

john007 · Apr 28, 2010

ahh sorry for the late reply, i was working on my Dekaron P server lol.

i will attach my logs thanks for helping chumpy

chumpywumpy · Apr 28, 2010

First you can't use "localhost" as the server IP when cabal_config asks, it must be the WAN IP (for online) or the centos LAN IP (for local network only). As long as DNS is working it should detect the correct IP for you.

The centos machine also can't connect to your SQL server. Assuming centos can ping windows this is almost always down to SQL not being installed correctly as express default to a "named instance" which won't work and remote connections are also disabled by default. Run the query below and it will check:

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

john007 · Apr 28, 2010

hmm i guess was the link server.. caused i only leave it like that when making it. so, i run that query in MSSQL under master? and one more problems when installing cabal server files from winSCP i don't see a root folder on my window's but only can found a root folder on Centos. so. i just copy from my server files on my window's to centos. will that causes any problems? or i need to make a Root folder for my server files first then use WinSCP to copy over to Centos' root?

chumpywumpy · Apr 30, 2010

That query can be run on any DB. ALl it does is check the SQL server version, the instance name, remote connections and xp_md5.

The files should go into the root folder on centos. From there use chmod on cabal_install.sh and run it to install the files.

The linked server isn't actually needed anymore:
http://forum.ragezone.com/f460/how-to-remove-the-need-for-a-linked-server-576629/

john007 · May 1, 2010

thanks chumpy i'll try but first i really followed your guides lol. but a part from the SQl guide that really don't look like mine when assigned the privilege for the user. the rest are fine and matched.

EDIT: i just removed my link server with that guide. what else should i do? or just run the server and try again?

EDIT2: hmm same result i can't connect to my server. btw, what this MSSQL IP when it asked on your centos. i used /home/cabal/cabal_config.sh this time a little weird though it doesn't asked me to put server IP 0.0 only MSSQL IP, username and Password. i put MSSQL IP= my local IP which is 127.0.0.1. caused i can make an account with that IP on chumpy's GM tool. so i guess that is the right MSSQL IP then lol. one more problems its something wrong with my my server? all server started picked a channel but on RAM usages i see only 600m+.. if this really work and i can connect that would be great caused this server really used less RAM lol.

EDIT3 OMG i finally can play it thanks chumpy kiss your feets lol. its was my MSSQL IP that was wrong lol...

ace5121 · May 31, 2023

Please check my logs i can't log in

[Mon May 29 2023 18:11:32.805661 4147988224]: CASHWEB_URL =