Can't get the server to work

[djbette]

Can someone help me setup the server so i am able to connect to it, i did everything the tutorials said, but i can't seem to get it working

 

[luis R]

too many tutorials and post your problems with logs so we can help you

 

[djbette]

i dont know how to find the logs but it just stops some of the services when i start the server

 

[djbette]

Centos OS:6.4 32 bit
Windows OS:10 64 bit

Centos LAN IP:192.168.163.129
Windows LAN IP:192.168.1.103

Do u have turned off firewall?(Yes/No):Yes on both systems
Describe ur problem:Some of my services are stopped, name of them are: ChatNode_01, LoginSvr_01, WorldSvr_01_01, AgentShop_01, EventMgrSvr

Logs: I have logs for them all

You must be registered to see links

 

[netsstea]

First thing you need to fix your problem.
Check your database connection.

[unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.

 

[djbette]

First thing you need to fix your problem.
Check your database connection.

I know but i cant seem to get it to connect, i tried searching for the error code 20009, which it said in the logs. But couldn't figure out how to get it working

 

[netsstea]

Then, be sure that your MSSQL DB is allowing connections through port 1433, that SQL Server is not blocking the incoming server's IP address, and that you have the correct password.

using nmap and ping to 1433 port

 

[djbette]

Then, be sure that your MSSQL DB is allowing connections through port 1433, that SQL Server is not blocking the incoming server's IP address, and that you have the correct password.

using nmap and ping to 1433 port

it said

You must be registered to see links

 

[netsstea]

It seem one of your OS was filtered and blocked port 1433.
Let's make sure, you disabled firewall of windows and firewall of Antivirut program
When you using nmap and get result is opepned, cabal services will work normally.

it said

You must be registered to see links

 

[djbette]

It seem one of your OS was filtered and blocked port 1433.
Let's make sure, you disabled firewall of windows and firewall of Antivirut program
When you using nmap and get result is opepned, cabal services will work normally.
View attachment 157205

cant get it to say open, still says filtered
and firewall are disabled



i got it to work, but i cant create a account
tried
gmtools
exec [Account].[dbo].[cabal_tool_registerAccount] 'YOUR ACC NAME', 'PASSWORD', null, null

 

[netsstea]

use
[Account].[dbo].[cabal_tool_registerAccount_web]

 

[djbette]

use
[Account].[dbo].[cabal_tool_registerAccount_web]

i used the one you said and i got this error

Msg 8152, Level 16, State 11, Procedure cabal_tool_registerAccount_web, Line 11
String or binary data would be truncated.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 17
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 20
Cannot insert the value NULL into column 'UserNum', table 'CabalCash.dbo.CashAccount'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 208, Level 16, State 1, Procedure cabal_tool_registerAccount_web, Line 23
Invalid object name 'CabalCash2.dbo.CashAccount'.
Msg 266, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 23
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

 

[PunkS7yle]

i used the one you said and i got this error

Msg 8152, Level 16, State 11, Procedure cabal_tool_registerAccount_web, Line 11
String or binary data would be truncated.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 17
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 20
Cannot insert the value NULL into column 'UserNum', table 'CabalCash.dbo.CashAccount'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 208, Level 16, State 1, Procedure cabal_tool_registerAccount_web, Line 23
Invalid object name 'CabalCash2.dbo.CashAccount'.
Msg 266, Level 16, State 2, Procedure cabal_tool_registerAccount_web, Line 23
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Are you using SQL Server 2014?

 

[djbette]

Are you using SQL Server 2014?

yeah is that bad?

 

[golddragooon]

Not sure if this helps

http://forum.ragezone.com/f451/cabal-sql-2014-a-1103746/

 

[PunkS7yle]

yeah is that bad?

No, you just have to change the design of your cabal_auth_table, from varchar(50) on passwords to varchar(100). See http://forum.ragezone.com/f451/gm-tools-mssql-server-issue-1104140/#post8643485. Also remember to run

EXEC sp_MSforeachdb 'ALTER DATABASE [?] SET COMPATIBILITY_LEVEL = 100

I have been running sql 2014 for over a year non-stop on my server and it's great, way better than 2008.