VizesLufi: Use this: http://forum.ragezone.com/f460/basic...resses-545188/
Printable View
VizesLufi: Use this: http://forum.ragezone.com/f460/basic...resses-545188/
/etc/odbc.iniQuote:
Originally Posted by VizesLufi
In /etc/cabal/AuthDBAgen.ini, CashDBAgent.ini, DBAgent_01.ini, EventDBAgent.ini, GlobalDBAgent.ini, PcBangDBAgent.ini find and replace with these:Code:[CabalAccount]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = ACCOUNT
TDS_Version = 8.0
[CabalCash]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = CabalCash
TDS_Version = 8.0
[CabalNetCafe]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = NetCafeBilling
TDS_Version = 8.0
[CabalGame01]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = SERVER01
TDS_Version = 8.0
[EventData]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = EventData
TDS_Version = 8.0
[Authentication]
Driver = FreeTDS
Address = MSSQL IP (Windows IP)
Port = 1433
Database = Authentication
TDS_Version = 8.0
In /etc/cabal/WorldSvr_01_xx.ini add your WAN IP on these lines:Code:DBId=sa
DBPwd=MSSQL PASSWORD
Good luck...Code:IPAddress=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
AddrForClient=xxx.xxx.xxx.xxx
Thanks cypher now i understand that cuz i have now other problem with when i start "service cabal start" command i use to "service cabal status" command this say ChatNode01 is stopped and all Ch too...Quote:
Originally Posted by cypher
Here is my ChatNode01 log if any1 know the problem help me!
Quote:
[Wed Jan 23 2013 21:56:02.638928 3086756480]: [##ERROR##] connect 127.0.0.1:38170 fail
[Wed Jan 23 2013 21:56:02.639066 3086756480]: [##ERROR##] Link(): link open fail(Automatic), Exit
[Wed Jan 23 2013 21:56:02.639115 3086756480]: [##ERROR##] RunServer(): active fail
[Wed Jan 23 2013 21:56:02.639160 3086756480]: waiting for caching(PR message)
[Wed Jan 23 2013 21:56:02.639452 3023543184]: CProcessLayer(0)::svc Start [3023543184]
[Wed Jan 23 2013 21:56:02.639529 3023543184]: CProcessLayer(0)::svc Terminated [3023543184]
[Wed Jan 23 2013 21:56:02.639875 3013053328]: CProcessLayer(0)::svc Start [3013053328]
[Wed Jan 23 2013 21:56:02.639934 3013053328]: CProcessLayer(0)::svc Terminated [3013053328]
[Wed Jan 23 2013 21:56:02.640096 3086482320]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640145 3086482320]: CProcessLayer(0)::svc Terminated [3086482320]
[Wed Jan 23 2013 21:56:02.640288 3075992464]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640337 3075992464]: CProcessLayer(0)::svc Terminated [3075992464]
[Wed Jan 23 2013 21:56:02.640412 3065502608]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640476 3065502608]: CProcessLayer(0)::svc Terminated [3065502608]
[Wed Jan 23 2013 21:56:02.640549 3055012752]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640596 3055012752]: CProcessLayer(0)::svc Terminated [3055012752]
[Wed Jan 23 2013 21:56:02.640676 3044522896]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640724 3044522896]: CProcessLayer(0)::svc Terminated [3044522896]
[Wed Jan 23 2013 21:56:02.640790 3034033040]: [##ERROR##] getq fail (108)
[Wed Jan 23 2013 21:56:02.640837 3034033040]: CProcessLayer(0)::svc Terminated [3034033040]
[Wed Jan 23 2013 21:56:02.641073 3086756480]: try listening 38121 port
[Wed Jan 23 2013 21:56:02.641536 3086756480]: FinalEnv BEGIN
[Wed Jan 23 2013 21:56:02.642321 3086756480]: FinalEnv END
Check AuthDBAgent logs... I think you didn't configure ODBC how it must be configured. DB Connection failed on other processes gives your errors...Quote:
Originally Posted by VizesLufi
Very very thanks bro now i will try to connect :D <3Quote:
Originally Posted by walkernight88
TDS_Version = 8.0 you use sql 2005? 0.oQuote:
Originally Posted by walkernight88
replace with TDS_Version = 10.0
10 were use sql 2008
MSSQL 2008 R2 works fine even if it's 8.0 9.0 10.0.... :) Useless comment...
oh sry ><Quote:
Originally Posted by walkernight88
walkernight88
i can't select channel help
Attachment 121986
EventDBAgent error
[Thu Jan 24 2013 11:18:43.102337 3034155920]: [##ERROR##] OnIPCEMSGetEvents fail
[Thu Jan 24 2013 11:18:43.102384 3034155920]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Thu Jan 24 2013 11:18:43.102401 3034155920]: [##ERROR##] DB ERROR(CODE) : 32000
[Thu Jan 24 2013 11:18:43.102415 3034155920]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 3<TIMESTAMP>, datatype in operator <</>>: INT
[Thu Jan 24 2013 11:18:43.102429 3034155920]: [##ERROR##] DB ERROR(SQLSTATE) :
[Thu Jan 24 2013 11:18:43.102443 3034155920]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}
MSSQL Errors, did you erased the old data from DB and added a linked server "Gameserver" ?Quote:
Originally Posted by aeyemo
guys help me,i have to add Linked server in SQL 2008?
This is my AuthDbAgent log:
I configed still what u say that and i still getting the:Quote:
[Wed Jan 23 2013 22:14:23.154306 3013168016]: [##ERROR##] OnIPCGMSAuthRequest type(0) fail : ip(127.0.0.1), port(38170), naion(BRA), srcKey(f2b76e1ee8a92a8ce99a41c07926d3f3), binKey(9f5a8dec8b44e4be05cdb9c91fa941f7)
[Wed Jan 23 2013 22:14:23.154356 3013168016]: [##ERROR##] DB ERROR(MSG) :
[Wed Jan 23 2013 22:14:23.154399 3013168016]: [##ERROR##] DB ERROR(CODE) : 0
[Wed Jan 23 2013 22:14:23.154440 3013168016]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Jan 23 2013 22:14:23.154481 3013168016]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Wed Jan 23 2013 22:14:23.154522 3013168016]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.sp_gmsauth_keyrequest_type( ? , ? , ? , ? , ? , ? )}
[Wed Jan 23 2013 22:14:23.170747 3013168016]: Database Connect success!
[Wed Jan 23 2013 22:14:23.170961 3013168016]: OnIPCGMSAuthRequest(): GMS STATE nation(BRA, 0) : IP(127.0.0.1), PORT(38170), RESULT(Alert), SS(KeepState), ALT(KeepState), FAIL(KeepState), ITEM(Items.scp), MOB(Mobs.scp), WARP(Warp.scp)
ChatNode_01 Stopped
EventMgrSvr Stopped
AgentShop_01 Stopped
LoginSvr_01 Stopped
WorldSvr_01_01 Stopped
WorldSvr_01_02 Stopped
WorldSvr_01_03 Stopped
WorldSvr_01_04 Stopped
WorldSvr_01_05 Stopped
WorldSvr_01_06 Stopped
Friend the database is so heavy it takes to restore itQuote:
Originally Posted by Nadiell
@walkernight88 Can you tell us how to edit Simp cabal client to make it connect to our server? That would be great. Thx in advance
he used breaklee + internal :)Quote:
Originally Posted by cadena
That does not work. Cmon stop being selfish. If everyone were as selfish u even would not have EP8 files.Quote:
Originally Posted by x30unlimited
150% true... Actually maybe it's breaklee + internal + brain ... not sure yet :D XoXoXoQuote:
Originally Posted by x30unlimited
Walkernight88 This is my AuthDBAgent Log i didnt understant what my problem?
Quote:
what more can i do for you ... i just tested it and ... it's workin ... please stop accusing us of not shearing ... i alone gave out a ton of info ... not being able to do it urself is not my mistake ...Quote:
Originally Posted by cadena
how u edit language.enc?
decompress, change the ips, compress.Quote:
Originally Posted by cadena
Easy going 8D.
You would need a ENC Decrypter.
Friend, I am able to connect the server quiet now, but alas I have a problem login to the server, changed the "language.enc" and I'm running "breaklee" but when you log in, it shows how (SUCCESS) in the log the LoginSvr_01 but not past the login, always comes back to the login screen, can you help me?
I think it's something with the doors of the files (. ini) seen in some who exchanged the door "DBAgent" by the "AuthDBAgent" can you help me with this question?
My Logs
new logs.zip
Quote:
Originally Posted by x30unlimited
check my log plese Attachment 121987Quote:
Originally Posted by walkernight88
did you read the whole thread before posting ?
btw: if you use breaklee it's useless to edit language.enc ... use internal.txt :PQuote:
Originally Posted by x30unlimited
hello my friends after much dispute with these errors could someone help me?