Hello RaGEZONErs,
i want to ask you this, because i´m working on a server with my friend. And at the last Server i helped, i couldn´t use GM Tool (Any) through Hamachi. I think that Hamachi blocks the request of SQL Access on the Server PC.
The log of the java GM Tool said me, that SQL blocks TCP/IP requests, but i allowed it on the installation of MSSQL 2005.
Any idea how to fix it? Can i put the DB on Xampp, and when i do something with the GM Tool, it updates the DB in MSSQL?
Thanks.
you can connect to mssql trough hamachi.
When connecting to SQL on a hamachi based server you must have the windows SQL computer in the hamachi network and connect the gm tools to the sql server hamachi ip.
I did that, but it didn´t work for me oO
I´m going to post exact error and log content tomorrow.
firewall blocking or tcpip disabled.
its my first time here,
anyways i got some problem on my server, session,agent,login,and field server are working good, my problem was when i input my Username and PassWord it takes time to process and in the end it doesnt work, and when i input a Username and Password that was not registerd there was no confirmation that that user and pass does not registered
logs please.
So, the Error:
SQL Exception: Check log.txt for more information
Log:
2009-11-10 @ 15:39:15 : com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 5.1.212.10, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
Firewall is disabled, and TCP/IP Connection is allowed in MSSQL.
Make sure that your mssql server is listening on all ips. Use netstat to make sure.
I made a screen on which you can see CMD (netstat) and the SQL Connections.
http://img5.imagebanana.com/img/sjxw3ydk/sqlfuck.JPG
I hope this will give you more information.
The 5.1.212.10 is definitely the windows one and not centos? Can you ping the IP address? Remember the computer you have the gm tools on must also be logged into the hamachi network as only those logged into the network can access other ip addresses on it.
netstat -a and make a screenshot please.
It is the Hamachi IP of the windows machine where the server is running on. But WHY the hell do you know that? I can´t see that ip on the screen OO.
And yes, the windowss computer is in hamachi, and i´m too, but i cannot connect to the database with the gm tool.
here, chumpy`s no magician...Originally Posted by Zemu
http://img5.imagebanana.com/view/59920dck/cmdcabal.JPG
I hope you meant that :)
see, here we have a problem:
I do not see any listenings on 0.0.0.0:1433 and this means nobody will be able to connect remotely on your mssql server.
Maybe windows firewall is blocking him, or if you use windows server 2003 you didn`t configure it properly!
I´m using windows XP.Firewall is disabled, and TCP/IP Connection is allowed in MSSQL.
So, no one got an idea how i can fix this problem? Should I turn off MY Firewall AND the one on the server pc?
i tought you did that before...
The Server is running at my friend. The Firewall of his Windows and his CentOS are off. And mine is on, i think, i should shut it down? :)
just remote desktop your friend server then use GM tool on his pc. hehehehe
That was a really senseless post.
If he got 6 GMs, and all want to do something with the GM Tool, what to do then?...
a true gm is the person that has direct access to the database, not by using crappy gm tools.
As Cypher Said...
A real GM has Access to DB and can Edit it that way...
BTW...
It can be Much easier to Setup a Local Webserver(by search butten on this Forum,you will find a guide about handling that...
then, on dynDNS,you let redirect you on this webserver...
just on thing to do....edit the local Website...you can find a really good one from sir Jhon_d , or from sir Chumpy, or from many other good developer of this Forum...
on the Website you have Admin-Panel..and GM-Panel...
Regards...
Reply With Quote