Client not logging :(
and no match more.
Client - GP.
log's in attached file.
Server - cabal-repack-2.8, on vmware - CentOSv4.8
ip for mssql - 192.168.1.3
ip for server - 192.168.1.18
What i'm doing nothing?
help please.
And sorry for my bad english.
Try to ping your IP addresses make sure there is a connection.
Also, double check make sure your firewall and ports are not disabled and blocked.
i think he want to say Firewall must be Disabled...so you have to get sure,your firewall is DISABLED and your Ports are Forwarded on your Router...Originally Posted by Daman2009
Regards...
The firewall is disabled or else...it wouldnt connect to sql,you didn't open the ports,or you didn't forward,or in internal.txt doesn't listen the right ports
firewall - off, 100%
ping 192.168.1.3->192.168.1.18 - OK
ping 192.168.1.18->192.168.1.3 - OK
PORT=38101 - open
CHAT_PORT=38121 - open
Same idea's?
And qustion - how i can check from 192.168.1.3 my cabal-server(192.168.1.18)? ping bla.bla.bla. or how? :)
from CentOS:
ping -c4 WINDOWS IP..
ping -c4 www.google.com (to check if its online)
from Windows:
ping CentOS IP...
thats it...
if all gives you a good ping,there is no Problem in Firewall...
then check your Router config,if you Ports are Forwarded,as Emi said...
i'm reinstall CentOS, MSSQL.
ping centos(192.168.1.18)->mssql(192.168.1.3) - very good
ping mssql->centos - good to
In log's all ok, but gameclient don't connect to the server :(
What i'm doing wrong?
p.s. server's status is ok. (use this - Server status web page)
Last edited by Combiner; 26-12-09 at 09:24 AM. Reason: add last log's
in internal.txt what ip did u put?the centos ip or your WAN ip?I think this is the problem
CentOS - 192.168.1.18
I can see login attempts in the loginsvr so it's getting that far. The worldsvr is on the correct IP for an offline server (lan-only) too. Not one single "database connect success!" in the logs though so my guess is a firewall is blocking access to mssql or it is refusing remote connections (check remote connections in the "surface area config" tool in the start menu).
i see there are database connect succes in the logs:
[Sat Dec 26 2009 10:13:59.625984 3064933280]: Database Connect success!
[Sat Dec 26 2009 10:13:59.644073 3054443424]: Database Connect success!
[Sat Dec 26 2009 10:13:59.649196 3043953568]: Database Connect success!
[Sat Dec 26 2009 10:13:59.663894 3054443424]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
[Sat Dec 26 2009 10:14:55.255688 3085912992]: Database Connect success!
I'm realy don't now wath happend :(
What more information can help?
Not for other logs there should be connection successes in emi.
Is your windows a 64 bit version? If so and you use 2005 you _must_ have the 64-bit version.
My windows a 32 bit version :( Wath can i do?
Run this query on any db and post the results. This will tell me if sql is correctly configured.
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
my screen.
P.S. this client - need patch?
Last edited by Combiner; 26-12-09 at 06:01 PM.
SQL is configured correctly so that isn't the problem.
That client does need a patch which you can find in /root/clientfiles/clientpatch on the server (or extract the clientfiles.tar.gz). The connections are getting at least as far as loginsvr though so i don't think it's the client.
Try extracting this to your /root/ folder on centos:
http://mrmagoo.psiblade.net/sqltest.7z
Now open a terminal/putty and type:
/root/test_sql.sh
It will ask for your database user and password and then try reading a row from the database. 1 row should get returned and if it does then centos can connect to sql ok.
Do your centos use "sa" to log into sql or did you set up a login for it? If you set up a login try running cabal_config again and using your "sa" login to make sure it's not a permissions problem.
screen say - all ok
Last edited by Combiner; 26-12-09 at 07:49 PM.
Ok, try deleting the /etc/cabal folder and then try running cabal_install again if you have just upgraded to v2.8. There may be a bug in the upgrade this time around which i have seen on another install.
Other than that nothing is really giving me any clues. Try stopping the services and deleting the old logs, then start and services again. Leave it for 5 minutes and then have a few goes at logging in before posting the fresh logs. Hopefully that will contain a clue.
Well, now all work )
i'm use the client patch (from Cabal server repack v2.8) and fix linkserver.
Thx to all for help.
Reply With Quote