Im trying to figure out why i cant connect to the server with a client. So i typed ifconfig and thats what i got. Some help please!
Im trying to figure out why i cant connect to the server with a client. So i typed ifconfig and thats what i got. Some help please!
just make your client connect to 192.168.1.110
i did that. And the blue bar in the client loads all the way then says failed to connect.
so then i tried 71.59.174.158 cause in cabal config it asked if i wanted to find my WAN and thats what it said. So then it still loads all the blue bar then says failed to connect. Like its not getting response. Doesnt even say "wrong user or pass" like it should when its actually connected.
the logs from \var\log\cabal would be verry usefull to us
as i suspected, your MSSQL IP cfg is probably wrong, get the chs video to learn where you must edit the configs
Ok i got the DB to connect. But when i try to login on a client i get this:
But if you look at my Loginsvr logs you can see im trying to connect. What is the problem?
Code:[Sat Feb 20 2010 18:54:15.212966 3086714560]: open log file '/var/log/cabal/LoginSvr_01.log' [Sat Feb 20 2010 18:54:15.214045 3086714560]: LOG LEVEL: 3 [Sat Feb 20 2010 18:54:15.214125 3086714560]: MemPoolUnitSizeClass(0): 14336Bytes [Sat Feb 20 2010 18:54:15.218131 3086714560]: Start LoginSvr_01 Server [Sat Feb 20 2010 18:54:15.218241 3086714560]: SITE_CHN, GAMEGUARD_V25, APEX_V10 [Sat Feb 20 2010 18:54:15.218287 3086714560]: TestChannelGroupIdxStartPoint=50 [Sat Feb 20 2010 18:54:15.219074 3086714560]: affiliatedCorpIP=121.170.135.; [Sat Feb 20 2010 18:54:15.219105 3086714560]: AdminIP=121.170.135.; [Sat Feb 20 2010 18:54:15.219169 3086714560]: client_version=22 [Sat Feb 20 2010 18:54:15.219198 3086714560]: IgnoreClientVersion(1) [Sat Feb 20 2010 18:54:15.219261 3086714560]: UseAntiOnlineGameAddictionSystem(1) [Sat Feb 20 2010 18:54:15.219290 3086714560]: AdultAge(18) [Sat Feb 20 2010 18:54:15.219924 3086714560]: DefaultAgeAdult(1) [Sat Feb 20 2010 18:54:15.220069 3086714560]: UsePSS(0) [Sat Feb 20 2010 18:54:15.220111 3086714560]: CachedPSS(0) [Sat Feb 20 2010 18:54:15.220141 3086714560]: PssCacheDurationMin(1440) [Sat Feb 20 2010 18:54:15.220173 3086714560]: CutIfPssUserNotFound(0) [Sat Feb 20 2010 18:54:15.220208 3086714560]: PssLogLevel(0) [Sat Feb 20 2010 18:54:15.221059 3086714560]: InstantPlayTimeClearIntervalMin(300) [Sat Feb 20 2010 18:54:15.221093 3086714560]: IDC(1) [Sat Feb 20 2010 18:54:15.221133 3086714560]: SharedPssPersonId(0) [Sat Feb 20 2010 18:54:15.221171 3086714560]: NormalClientMagicKey(1168110) [Sat Feb 20 2010 18:54:15.221213 3086714560]: UseImageAuth(0) [Sat Feb 20 2010 18:54:15.221244 3086714560]: ImageAuthDataPath(./ImageAuth/) [Sat Feb 20 2010 18:54:15.221285 3086714560]: ImageAuthMaxTryCount(5) [Sat Feb 20 2010 18:54:15.221317 3086714560]: ImageAuthWaitTime(120000) [Sat Feb 20 2010 18:54:15.221933 3086714560]: BlockIfImageAuthFail(0) [Sat Feb 20 2010 18:54:15.222071 3086714560]: UseServerListManualOrder(0) [Sat Feb 20 2010 18:54:15.222108 3086714560]: 00:00 => 0 [Sat Feb 20 2010 18:54:15.222147 3086714560]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0 [Sat Feb 20 2010 18:54:15.222184 3086714560]: ImageAuthDataMgr Init Begin [Sat Feb 20 2010 18:54:20.569089 3086714560]: ImageAuthDataMgr Init End(Count:1995) [Sat Feb 20 2010 18:54:20.571886 3086714560]: try connect 127.0.0.1:38170, Sync [Sat Feb 20 2010 18:54:20.572287 3086714560]: sock 7 ->LinkHandler Open [Sat Feb 20 2010 18:54:20.572287 3086714560]: SendIPSConnect2Svr (195:128:01:00) [Sat Feb 20 2010 18:54:20.572287 3086714560]: try connect 127.0.0.1:38180, Sync [Sat Feb 20 2010 18:54:20.575229 3086714560]: sock 9 ->LinkHandler Open [Sat Feb 20 2010 18:54:20.575301 3086714560]: SendIPSConnect2Svr (195:128:01:00) [Sat Feb 20 2010 18:54:20.576116 3086714560]: try listening 38101 port [Sat Feb 20 2010 18:54:20.582173 3078413216]: CProcessLayer(0)::svc Start [3078413216] [Sat Feb 20 2010 18:54:20.582327 3078413216]: ServerState changed(0 -> 0) [Sat Feb 20 2010 19:02:25.942437 3086714560]: accept success 11(192.168.1.100:37011) [Sat Feb 20 2010 19:02:25.943377 3086714560]: 1.open user 11 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:02:25.947029 3078413216]: AuthRequest: UserID(sgadmin), Addr(192.168.1.100) [Sat Feb 20 2010 19:04:32.408132 3078413216]: NOACTV_LIMIT(120000) Addr(192.168.1.100) [Sat Feb 20 2010 19:04:32.409269 3078413216]: 1.close user -1 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:04:47.838519 3086714560]: accept success 11(192.168.1.100:37144) [Sat Feb 20 2010 19:04:47.838974 3086714560]: 1.open user 11 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:04:47.842545 3078413216]: AuthRequest: UserID(sgadmin), Addr(192.168.1.100) [Sat Feb 20 2010 19:06:50.981313 3078413216]: NOACTV_LIMIT(120000) Addr(192.168.1.100) [Sat Feb 20 2010 19:06:50.984203 3078413216]: 1.close user -1 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:16:18.849172 3086714560]: accept success 11(192.168.1.100:37204) [Sat Feb 20 2010 19:16:18.849172 3086714560]: 1.open user 11 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:16:18.851656 3078413216]: AuthRequest: UserID(sgadmin), Addr(192.168.1.100) [Sat Feb 20 2010 19:18:23.362041 3078413216]: NOACTV_LIMIT(120000) Addr(192.168.1.100) [Sat Feb 20 2010 19:18:23.363076 3078413216]: 1.close user -1 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:18:24.584807 3086714560]: accept success 11(192.168.1.100:37207) [Sat Feb 20 2010 19:18:24.584807 3086714560]: 1.open user 11 [94498F0] (192.168.1.100) [Sat Feb 20 2010 19:18:24.584807 3078413216]: AuthRequest: UserID(sgadmin), Addr(192.168.1.100) [Sat Feb 20 2010 19:20:30.570243 3078413216]: NOACTV_LIMIT(120000) Addr(192.168.1.100) [Sat Feb 20 2010 19:20:30.570993 3078413216]: 1.close user -1 [94498F0] (192.168.1.100)
try ping from centos,the windows ip,and from windows,ping centos ip,tell us the results
Idk a ping command for centos. But heres windows pinging centos
Whats the ping command for centos?Code:Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Admin>cd c:\windows\system32 C:\WINDOWS\system32>ping 192.168.1.110 Pinging 192.168.1.110 with 32 bytes of data: Reply from 192.168.1.110: bytes=32 time=21ms TTL=64 Reply from 192.168.1.110: bytes=32 time=21ms TTL=64 Reply from 192.168.1.110: bytes=32 time=21ms TTL=64 Reply from 192.168.1.110: bytes=32 time<1ms TTL=64 Ping statistics for 192.168.1.110: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 21ms, Average = 15ms C:\WINDOWS\system32>
same command:ping
Ping to windows router from centos
Ill ping 71.59.174.158 once it stops.Code:ping 192.168.1.100 PING 192.168.1.100 (192.168.1.100) 52(84)bytes recieved 64 bytes recieved from 192.168.1.100: icmp_seq=1 ttl=128 time=0.000 ms 64 bytes recieved from 192.168.1.100: icmp_seq=2 ttl=128 time=0.114 ms 64 bytes recieved from 192.168.1.100: icmp_seq=3 ttl=128 time=0.015 ms etc... (IT WONT STOP!)
the connection between...centos to sql is correct
Make sure:you have configured Sql correctly
also MAKE SURE YOU DON'T HAVE ANY FIREWALL ENABLED!!!
My firewalls off. And what do you mean SQL configured correctly? Like in cabal_config.sh? or? I dont know what ip to use for the MSSQL ip in config setup.
I have all of these:
and my centos ifconfig is:Code:Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Admin>cd c:\windows\system32 C:\WINDOWS\system32>ipconfig Windows IP Configuration Ethernet adapter VMware Network Adapter VMnet1: Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.60.1 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : Ethernet adapter VMware Network Adapter VMnet8: Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.254.1 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : Ethernet adapter Local Area Connection 2: Connection-specific DNS Suffix . : hsd1.wa.comcast.net. IP Address. . . . . . . . . . . . : 192.168.1.100 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.1.1 Ethernet adapter VirtualBox Host-Only Network: Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.56.1 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : C:\WINDOWS\system32>
no,like sql guides...2005/2000
I have 2005. What guides? Should i completly delete MSSQL and reinstall?
ping from centos to WAN 71.59.174.158
Code:ping -c 10 71.59.174.158 64 bytes received from 71.59.174.158: icmp_seq=0 ttl=64 time 5.58ms etc.... ----- 71.59.174.158 ping statistics ----- 10 packets transmitted, 10 recieved, 0 failed, 0% loss, time 9013ms rtt min/avg/max/mdev = 0.900/1.497/5.885/1.464 ms, pipe 2
this guide:http://www.mediafire.com/?a3fuz4qyy1z
Ok so im following that guide. And when i get to the SQL Server 2005 Surface config part i get this error:
But i know i have sql installed on this machine cause SQL management can connect no problem.Code:TITLE: Surface Area Configuration ------------------------------ Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC) ------------------------------ ADDITIONAL INFORMATION: An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476 ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ The operation could not be completed. (WinMgmt) ------------------------------ BUTTONS: OK ------------------------------
bump
as far as i know if you put in centos your wan ip you cant connect with cabal on the same pc,and if you did the setup of centos corect that means you messed something up at mssql,enter chumpy's code in mssql in a new querry in any db and see if it's instaled corect,if not follow chumpy's guide carefull..Originally Posted by Thesnowman
So you mean if the centos is set up properly and if u look in my login log up there ull see im trying to connect. I cant connect to cabal on this machine? Ill have to use my laptop?
In my DBagent09_log it says this:
But i know the details are right.Code:[Sun Feb 21 2010 12:46:07.477923 3086952128]: open log file '/var/log/cabal/DBAgent_09.log' [Sun Feb 21 2010 12:46:07.477923 3086952128]: LOG LEVEL: 3 [Sun Feb 21 2010 12:46:07.477923 3086952128]: MemPoolUnitSizeClass(2): 24576Bytes [Sun Feb 21 2010 12:46:07.481934 3086952128]: Start DBAgent_09 Server [Sun Feb 21 2010 12:46:07.484339 3086952128]: UseEcryptText (Off) [Sun Feb 21 2010 12:46:07.485419 3086952128]: try listening 38181 port [Sun Feb 21 2010 12:46:07.488935 3086949280]: CProcessLayer(0)::svc Start [3086949280] [Sun Feb 21 2010 12:46:07.489403 3076459424]: CProcessLayer(0)::svc Start [3076459424] [Sun Feb 21 2010 12:46:07.489962 3065969568]: CProcessLayer(0)::svc Start [3065969568] [Sun Feb 21 2010 12:46:07.490366 3055479712]: CProcessLayer(0)::svc Start [3055479712] [Sun Feb 21 2010 12:46:07.490973 3044989856]: CProcessLayer(0)::svc Start [3044989856] [Sun Feb 21 2010 12:46:08.618152 3086952128]: accept success 8(127.0.0.1:33294) [Sun Feb 21 2010 12:46:08.622806 3086952128]: 1.open user 8 [9961440] (127.0.0.1) [Sun Feb 21 2010 12:46:09.812067 3086952128]: accept success 10(127.0.0.1:33296) [Sun Feb 21 2010 12:46:09.813450 3086952128]: 2.open user 10 [996FB80] (127.0.0.1) [Sun Feb 21 2010 12:46:11.841677 3086952128]: accept success 11(127.0.0.1:33300) [Sun Feb 21 2010 12:46:11.842923 3086952128]: 3.open user 11 [997BD90] (127.0.0.1) [Sun Feb 21 2010 12:46:15.751184 3086952128]: accept success 12(127.0.0.1:33304) [Sun Feb 21 2010 12:46:15.751184 3086952128]: 4.open user 12 [9987FE0] (127.0.0.1) [Sun Feb 21 2010 12:47:05.797958 3065969568]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Sun Feb 21 2010 12:47:05.799176 3076459424]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(CODE) : 20009 [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] Database Connect Fail (uid=cabaladmin;pwd=cabalserver;dsn=CabalGame09;APP=DBAgent_09) [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] check 'pDB' fail [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9) [Sun Feb 21 2010 12:47:05.868425 3076459424]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1) [Sun Feb 21 2010 12:47:05.799646 3044989856]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Sun Feb 21 2010 12:47:05.868818 3044989856]: [##ERROR##] DB ERROR(CODE) : 20009 [Sun Feb 21 2010 12:47:05.868839 3044989856]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Feb 21 2010 12:47:05.868860 3044989856]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Sun Feb 21 2010 12:47:05.868879 3044989856]: [##ERROR##] DB ERROR(STM_TEXT) : And many more.........
---------- Post added at 09:16 PM ---------- Previous post was at 08:43 PM ----------
See post above but also Chumpys tools cant connect either.
I know i installed MSSQL 2005 properly. The only thing i didnt do was the surface area config cause i get this error:
And chumpys tools say:Code:TITLE: Surface Area Configuration ------------------------------ Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC) ------------------------------ ADDITIONAL INFORMATION: An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476 ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ The operation could not be completed. (WinMgmt) ------------------------------ BUTTONS: OK ------------------------------
The IP is 127.0.0.1 and i know the User and pass are correct. I see it clear as day in my MSSQL server managementCode:MSSQL Server did not respond. Check server IP (Must be a IP not a hostname) and make sure your username and password are correct. Also make sure no firewall is in the way.
Last edited by Thesnowman; 21-02-10 at 09:59 PM.
well i'm not very good in reading logs,but try to setup centos with WAN ip,then connect to cabal from another PC,also you have to forward the ports,
(here is the link to the guide).Try that and tell us the results.
Last edited by FastBlade; 22-02-10 at 02:39 PM.
Reading logs arnt hard dude...
i'm just a begginer dude
Reply With Quote
