i cant login at login screen it just kept connecting to server till the end n pop up fail to connect.
n i found these errors at var/log/cabal. pls help. thanks
i cant login at login screen it just kept connecting to server till the end n pop up fail to connect.
n i found these errors at var/log/cabal. pls help. thanks
Does not change the IP in the files you have to change your IP by Centos..
open - WinScp /etc/cabal/GlobalDBAgent.ini and change IP 121.0.0.1 centos changes
Seems pretty clear, it can't connect with the DB. Either the windows ip is /etc/odbc.ini is wrong, a firewall is enabled in windows or you use mssql2005 express and installed it wrong as a default 2005 express install won't work. See the guides in my sig if you use 2005.
JulioCtC - globalDBAgent have ip to change? hw?
Chumpywumpy - i found out that my ip address in odbc.ini in winscp is nt change. do i have to change the TDS_Version = 8.0 to TDS_Version = 9.0 n add anything to freetds.conf?
thanks all
ohya.. im using ms sql 2005 express. bt i install it like hw the mssql2005.pdf teaches. the onli thing i dont know is wat i should put at the servername. cant figure that out. where to get the servername. so i put it as localhost
Last edited by cypher; 21-04-09 at 09:32 PM. Reason: fixed dbl post.
[mod]lordz91: do not double post, use edit![/mod]
In the linked server settings put the windows ip address not localhost (that bit of the guide won't work for everybody and might not have been the best example to use in the guide).
[Wed Apr 22 2009 23:14:37.627917 3085952704]: open log file '/var/log/cabal/DBAgent_24.log'
[Wed Apr 22 2009 23:14:37.628226 3085952704]: LOG LEVEL: 3
[Wed Apr 22 2009 23:14:37.628345 3085952704]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Apr 22 2009 23:14:37.630668 3085952704]: Start DBAgent_24 Server
[Wed Apr 22 2009 23:14:37.632415 3085952704]: UseEcryptText (Off)
[Wed Apr 22 2009 23:14:37.633896 3085952704]: try listening 38181 port
[Wed Apr 22 2009 23:14:37.634815 3085949856]: CProcessLayer(0)::svc Start [3085949856]
[Wed Apr 22 2009 23:14:37.635344 3075460000]: CProcessLayer(0)::svc Start [3075460000]
[Wed Apr 22 2009 23:14:37.635654 3064970144]: CProcessLayer(0)::svc Start [3064970144]
[Wed Apr 22 2009 23:14:37.635893 3054480288]: CProcessLayer(0)::svc Start [3054480288]
[Wed Apr 22 2009 23:14:37.636253 3043990432]: CProcessLayer(0)::svc Start [3043990432]
[Wed Apr 22 2009 23:14:38.648494 3085952704]: accept success 8(127.0.0.1:32770)
[Wed Apr 22 2009 23:14:38.651326 3085952704]: 1.open user 8 [8F55428] (127.0.0.1)
[Wed Apr 22 2009 23:14:40.079286 3085952704]: accept success 10(127.0.0.1:32772)
[Wed Apr 22 2009 23:14:40.083911 3085952704]: 2.open user 10 [8F63B68] (127.0.0.1)
[Wed Apr 22 2009 23:16:25.065575 3085952704]: sock 10 ->handle_timeout
[Wed Apr 22 2009 23:16:29.164691 3085952704]: 2.close user -1 [8F63B68] (127.0.0.1)
[Wed Apr 22 2009 23:17:33.075481 3085952704]: accept success 10(127.0.0.1:32779)
[Wed Apr 22 2009 23:17:33.081468 3085952704]: 2.open user 10 [8F63B68] (127.0.0.1)
[Wed Apr 22 2009 23:17:41.958241 3054480288]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Apr 22 2009 23:17:41.963467 3054480288]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Apr 22 2009 23:17:41.963581 3054480288]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Apr 22 2009 23:17:41.963685 3054480288]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Apr 22 2009 23:17:41.963756 3054480288]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Apr 22 2009 23:17:41.963826 3054480288]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=12345;dsn=CabalGame24;APP=DBAgent_24)
[Wed Apr 22 2009 23:17:41.964084 3054480288]: [##ERROR##] check 'pDB' fail
[Wed Apr 22 2009 23:17:41.964163 3054480288]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Apr 22 2009 23:17:41.964237 3054480288]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Wed Apr 22 2009 23:17:44.975781 3075460000]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Apr 22 2009 23:17:44.975974 3075460000]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Apr 22 2009 23:17:44.976045 3075460000]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Apr 22 2009 23:17:44.976113 3075460000]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Apr 22 2009 23:17:44.976214 3075460000]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Apr 22 2009 23:17:44.976285 3075460000]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=12345;dsn=CabalGame24;APP=DBAgent_24)
[Wed Apr 22 2009 23:17:44.976358 3075460000]: [##ERROR##] check 'pDB' fail
[Wed Apr 22 2009 23:17:44.976425 3075460000]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Apr 22 2009 23:17:44.976500 3075460000]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Wed Apr 22 2009 23:17:48.010388 3043990432]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Wed Apr 22 2009 23:17:48.010545 3043990432]: [##ERROR##] DB ERROR(CODE) : 20009
[Wed Apr 22 2009 23:17:48.010835 3043990432]: [##ERROR##] DB ERROR(VAR_INFO) :
[Wed Apr 22 2009 23:17:48.010905 3043990432]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Wed Apr 22 2009 23:17:48.010972 3043990432]: [##ERROR##] DB ERROR(STM_TEXT) :
[Wed Apr 22 2009 23:17:48.011040 3043990432]: [##ERROR##] Database Connect Fail (uid=cabal;pwd=12345;dsn=CabalGame24;APP=DBAgent_24)
[Wed Apr 22 2009 23:17:48.011204 3043990432]: [##ERROR##] check 'pDB' fail
[Wed Apr 22 2009 23:17:48.011277 3043990432]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Apr 22 2009 23:17:48.011451 3043990432]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)this is frm the DBAgent n worldsvr after i have change the link server name to lan ip bt it still have error so i change it to hamachi ip n the same thing.[Wed Apr 22 2009 23:15:40.712308 3086968512]: try listening 38111 port
[Wed Apr 22 2009 23:17:27.647800 3086968512]: sock 9 ->LinkHandler close
[Wed Apr 22 2009 23:17:28.063733 3086968512]: sock 8 ->LinkHandler close
[Wed Apr 22 2009 23:17:28.066762 3086968512]: sock 7 ->LinkHandler close
[Wed Apr 22 2009 23:17:28.069770 3086968512]: sock 5 ->LinkHandler close
[Wed Apr 22 2009 23:17:32.659534 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,1), serverAddr(127.0.0.1:38121)
[Wed Apr 22 2009 23:17:32.660575 3086968512]: try connect 127.0.0.1:38121, Sync
[Wed Apr 22 2009 23:17:32.666534 3086968512]: sock 5 ->LinkHandler Open
[Wed Apr 22 2009 23:17:32.667630 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Wed Apr 22 2009 23:17:33.064089 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38190)
[Wed Apr 22 2009 23:17:33.064975 3086968512]: try connect 127.0.0.1:38190, Sync
[Wed Apr 22 2009 23:17:33.069003 3086968512]: sock 7 ->LinkHandler Open
[Wed Apr 22 2009 23:17:33.070432 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Wed Apr 22 2009 23:17:33.071071 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38181)
[Wed Apr 22 2009 23:17:33.071527 3086968512]: try connect 127.0.0.1:38181, Sync
[Wed Apr 22 2009 23:17:33.083494 3086968512]: sock 8 ->LinkHandler Open
[Wed Apr 22 2009 23:17:33.084468 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Wed Apr 22 2009 23:17:33.089554 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Wed Apr 22 2009 23:17:33.090062 3086968512]: try connect 127.0.0.1:38170, Sync
[Wed Apr 22 2009 23:17:33.105468 3086968512]: sock 9 ->LinkHandler Open
[Wed Apr 22 2009 23:17:33.106087 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Wed Apr 22 2009 23:17:33.489383 23767968]: ChannelType changed(0 -> 1)
[Wed Apr 22 2009 23:19:35.837643 3086968512]: sock 5 ->LinkHandler close
[Wed Apr 22 2009 23:19:40.955880 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,1), serverAddr(127.0.0.1:38121)
[Wed Apr 22 2009 23:19:40.956117 3086968512]: try connect 127.0.0.1:38121, Sync
[Wed Apr 22 2009 23:19:40.957768 3086968512]: sock 5 ->LinkHandler Open
[Wed Apr 22 2009 23:19:40.957916 3086968512]: SendIPSConnect2Svr (161:24:01:00)
uid=cabal;pwd=12345;
use your sa account!
u mean edit the username n password in cashDBAgent,DBAgent n globalDBAgent to sa acc? bt i dont noe the password.
run again in VMWare or putty command:
/home/cabal/cabal_config.sh
and change IPs you like.
i think i have just make the database connect already bt i gt this error in worldsvr
[Fri Apr 24 2009 03:55:18.928175 2857806752]: CProcessLayer(25)::svc Start [2857806752]
[Fri Apr 24 2009 03:55:19.537949 2842803104]: CProcessLayer(26)::svc Start [2842803104]
[Fri Apr 24 2009 03:55:20.084376 2826701728]: CProcessLayer(27)::svc Start [2826701728]
[Fri Apr 24 2009 03:55:20.787098 2811714464]: CProcessLayer(28)::svc Start [2811714464]
[Fri Apr 24 2009 03:55:21.503516 2795109280]: CProcessLayer(29)::svc Start [2795109280]
[Fri Apr 24 2009 03:55:22.088827 2779863968]: CProcessLayer(30)::svc Start [2779863968]
[Fri Apr 24 2009 03:55:22.469543 3086968512]: try listening 38111 port
[Fri Apr 24 2009 03:56:41.172447 3086968512]: sock 7 ->LinkHandler close
[Fri Apr 24 2009 03:56:41.274503 3086968512]: sock 8 ->LinkHandler close
[Fri Apr 24 2009 03:56:41.274895 3086968512]: sock 9 ->LinkHandler close
[Fri Apr 24 2009 03:56:41.275501 3086968512]: sock 5 ->LinkHandler close
[Fri Apr 24 2009 03:56:46.283188 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38181)
[Fri Apr 24 2009 03:56:46.369077 3086968512]: try connect 127.0.0.1:38181, Sync
[Fri Apr 24 2009 03:56:46.379014 3086968512]: sock 5 ->LinkHandler Open
[Fri Apr 24 2009 03:56:46.470102 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Fri Apr 24 2009 03:56:46.588442 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38190)
[Fri Apr 24 2009 03:56:46.588620 3086968512]: try connect 127.0.0.1:38190, Sync
[Fri Apr 24 2009 03:56:46.589418 3086968512]: sock 7 ->LinkHandler Open
[Fri Apr 24 2009 03:56:46.589601 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Fri Apr 24 2009 03:56:46.590022 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,1), serverAddr(127.0.0.1:38121)
[Fri Apr 24 2009 03:56:46.590187 3086968512]: try connect 127.0.0.1:38121, Sync
[Fri Apr 24 2009 03:56:46.590890 3086968512]: sock 8 ->LinkHandler Open
[Fri Apr 24 2009 03:56:46.591098 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Fri Apr 24 2009 03:56:46.591452 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Fri Apr 24 2009 03:56:46.591547 3086968512]: try connect 127.0.0.1:38170, Sync
[Fri Apr 24 2009 03:56:46.592250 3086968512]: sock 9 ->LinkHandler Open
[Fri Apr 24 2009 03:56:46.592425 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Fri Apr 24 2009 03:56:47.280470 23767968]: ChannelType changed(0 -> 1)
[Fri Apr 24 2009 03:57:04.660264 23767968]: [##ERROR##] OnResultItems(): ItemNum(0)
ACE_ASSERT: file WorldMgr.cpp, line 371 assertion failed for '0'.Aborting...editted: found out after awhile there is this error in DBAgent.[Fri Apr 24 2009 03:56:46.602305 3086366400]: accept success 10(127.0.0.1:32801)
[Fri Apr 24 2009 03:56:46.603357 3086366400]: 2.open user 10 [8DFEB60] (127.0.0.1)
[Fri Apr 24 2009 03:56:49.019305 3065383840]: Database Connect success!
[Fri Apr 24 2009 03:56:54.990252 3044404128]: Database Connect success!
[Fri Apr 24 2009 03:57:03.897526 3075873696]: Database Connect success!
[Fri Apr 24 2009 03:57:03.899603 3075873696]: [##ERROR##] DB ERROR(MSG) :
[Fri Apr 24 2009 03:57:03.900524 3075873696]: [##ERROR##] DB ERROR(CODE) : 0
[Fri Apr 24 2009 03:57:03.905127 3075873696]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Apr 24 2009 03:57:03.905287 3075873696]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Fri Apr 24 2009 03:57:03.905357 3075873696]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Fri Apr 24 2009 03:57:03.985974 3075873696]: Database Connect success!
[Fri Apr 24 2009 03:57:03.986720 3075873696]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Fri Apr 24 2009 03:57:03.987685 3075873696]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Fri Apr 24 2009 03:57:04.296449 3044404128]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Fri Apr 24 2009 03:57:04.297464 3044404128]: [##ERROR##] DB ERROR(CODE) : 32000
[Fri Apr 24 2009 03:57:04.307510 3044404128]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 0<UNKNOWN>, datatype in operator <</>>: INT
[Fri Apr 24 2009 03:57:04.308465 3044404128]: [##ERROR##] DB ERROR(SQLSTATE) :
[Fri Apr 24 2009 03:57:04.309461 3044404128]: [##ERROR##] DB ERROR(STM_TEXT) : SELECT KINDIDX, SERIALBGN, SERIALEND FROM CABAL_ITEMSERIAL_TABLE WHERE GROUPIDX = ?
[Fri Apr 24 2009 03:57:04.645735 3044404128]: Database Connect success!
[Fri Apr 24 2009 03:57:04.645948 3044404128]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:132)
[Fri Apr 24 2009 03:57:04.646033 3044404128]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(84:0:132) Addr(127.0.0.1)
[Fri Apr 24 2009 03:57:05.028368 3086366400]: 2.close user 10 [8DFEB60] (127.0.0.1)
if i change it to ms sql 2000 is there a installer guide like there is for ms sql 2005?
yes there is, and the error is about some items you gave yourself is crashing the server.
wat should i do abt those error?? thanks
change your inventory to 0x00
where do i change it? this is to fix worldsvr? the dbagent is connect already without error for nw. leaving wif only the worldsvr wif errorsOriginally Posted by cypher
reinstall your cabal server.
You can actually just delete the inventory row for that char. Whenever the inventory is check the sql database will insert a blank inventory row if one doesn't exist already ;)
i have these 2 errors for allow null when i try to create acc ms sql 2005 using 'exec dbo.cabal_tool_registerAccount 'yourusername' , 'yourpw''
i change to allow nulls for password in dbo.cabal_auth_table bt i still cant login into the game at login screen after creating acc. n there's error in the log. bt i deleted it already forgot to save. i change my DBAgent port to another port num n worldsvr do nt have error anymore. can help me check if my log is correct?Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
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.
(1 row(s) affected)
No need, i know what is wrong. CHanging the table to allow nulls is not correct, why would you want null passowrds?
The problem is your xp_md5 support isn't working and so the passwords are not being incrypted. Look for it in the enxtended procedures folder of the "master" db and check the path to the .dll is correct.
Don't manually change ports or it will definitely stop things working.
i open properties of the xp_md5.dll n change the path n press ok bt after that the xp_md5.dll is gone frm extended stored procedures
It has probably just moved. Right-click the extended procedures folder and select refresh. Or just delete it completely and recreate it.
ya. i reconnect the mssql. n nw without the password null already. bt i still have this worldsvr error nt fix. nw trying if i let everything connect already thn restart worldsvr n c if there's any error coming out.
Editted: This is the error after i start the service 1 by 1. the worldsvr is the last to start[Sun Apr 26 2009 23:49:46.933627 3086968512]: sock 5 ->LinkHandler close
[Sun Apr 26 2009 23:49:46.953520 3086968512]: sock 7 ->LinkHandler close
[Sun Apr 26 2009 23:49:46.954361 3086968512]: sock 8 ->LinkHandler close
[Sun Apr 26 2009 23:49:46.954884 3086968512]: sock 9 ->LinkHandler close
[Sun Apr 26 2009 23:49:51.934458 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Sun Apr 26 2009 23:49:52.038175 3086968512]: try connect 127.0.0.1:38170, Sync
[Sun Apr 26 2009 23:49:52.039259 3086968512]: sock 5 ->LinkHandler Open
[Sun Apr 26 2009 23:49:52.039536 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 26 2009 23:49:52.041234 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38181)
[Sun Apr 26 2009 23:49:52.043263 3086968512]: try connect 127.0.0.1:38181, Sync
[Sun Apr 26 2009 23:49:52.043978 3086968512]: sock 7 ->LinkHandler Open
[Sun Apr 26 2009 23:49:52.044113 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 26 2009 23:49:52.044427 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38190)
[Sun Apr 26 2009 23:49:52.044523 3086968512]: try connect 127.0.0.1:38190, Sync
[Sun Apr 26 2009 23:49:52.045046 3086968512]: sock 8 ->LinkHandler Open
[Sun Apr 26 2009 23:49:52.045248 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 26 2009 23:49:52.045581 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,1), serverAddr(127.0.0.1:38121)
[Sun Apr 26 2009 23:49:52.045669 3086968512]: try connect 127.0.0.1:38121, Sync
[Sun Apr 26 2009 23:49:52.047874 3086968512]: sock 9 ->LinkHandler Open
[Sun Apr 26 2009 23:49:52.048060 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Sun Apr 26 2009 23:49:52.178259 23767968]: ChannelType changed(0 -> 1)
bt the sock 5 -> linkhandler open, sendIPSConnect2Svr (161:24:01:00) means that it has connect back rite..?? so the previous error means nothing already?[Mon Apr 27 2009 00:21:55.516314 3086968512]: try listening 38111 port
[Mon Apr 27 2009 00:23:06.099768 27233184]: ChannelType changed(0 -> 1)
[Mon Apr 27 2009 00:28:03.630487 122805152]: [##ERROR##] AdjustTilePos(Mob:205009D) Tile(0:-2) species(326), Cur(88:85), To(88:85)
[Mon Apr 27 2009 00:28:22.091055 3086968512]: sock 5 ->LinkHandler close
[Mon Apr 27 2009 00:28:27.136537 3086968512]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Mon Apr 27 2009 00:28:27.149315 3086968512]: try connect 127.0.0.1:38170, Sync
[Mon Apr 27 2009 00:28:27.168517 3086968512]: sock 5 ->LinkHandler Open
[Mon Apr 27 2009 00:28:27.192013 3086968512]: SendIPSConnect2Svr (161:24:01:00)
[Mon Apr 27 2009 00:28:27.444036 27233184]: ChannelType not changed. this(1), fromGMS(1)
wats this error from globalmgrsvr? need to fix?[Mon Apr 27 2009 00:24:49.678909 3085843360]: [##ERROR##] 24:1 server notify time over (time: 69810)
[Mon Apr 27 2009 00:25:04.516490 3085843360]: 3.close user -1 [9006E38] (127.0.0.1)
[Mon Apr 27 2009 00:25:22.937861 3085843360]: [##ERROR##] 24:1 server notify time over (time: 109215)
[Mon Apr 27 2009 00:25:23.495813 3085843360]: already unlink 9006E38 (status=2)
[Mon Apr 27 2009 00:25:23.546007 3085843360]: [##ERROR##] 24:1 server notify time over (time: 110075)
[Mon Apr 27 2009 00:25:23.546643 3085843360]: already unlink 9006E38 (status=2)
[Mon Apr 27 2009 00:28:27.286786 3086313152]: accept success 12(127.0.0.1:32813)
[Mon Apr 27 2009 00:28:27.423135 3086313152]: 3.open user 12 [9006E38] (127.0.0.1)
[Mon Apr 27 2009 00:28:27.439229 3085843360]: new server session (24:01)
Editted: i can login bt cant create new char it shows this error after i press create in game 'cannot proceed due to unknown DB error. please try again'
this error is frm DBAgent.[Mon Apr 27 2009 01:41:48.455264 3054451616]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 16)
[Mon Apr 27 2009 01:41:48.455777 3054451616]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" reported an error. Authentication failed.
[Mon Apr 27 2009 01:41:48.455864 3054451616]: [##ERROR##] DB ERROR(CODE) : 7399
[Mon Apr 27 2009 01:41:48.455934 3054451616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Apr 27 2009 01:41:48.456002 3054451616]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Mon Apr 27 2009 01:41:48.456345 3054451616]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
[Mon Apr 27 2009 01:41:48.903261 3054451616]: Database Connect success!
[Mon Apr 27 2009 01:42:13.073974 3085921184]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 17)
[Mon Apr 27 2009 01:42:13.075733 3085921184]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]The OLE DB provider "MSDASQL" for linked server "GAMESERVER" reported an error. Authentication failed.
[Mon Apr 27 2009 01:42:13.075812 3085921184]: [##ERROR##] DB ERROR(CODE) : 7399
[Mon Apr 27 2009 01:42:13.075881 3085921184]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Apr 27 2009 01:42:13.075978 3085921184]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Mon Apr 27 2009 01:42:13.076048 3085921184]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )}
[Mon Apr 27 2009 01:42:13.471909 3085921184]: Database Connect success!
Last edited by lordz91; 26-04-09 at 08:40 PM.
your wan ip settings is incorrect.
im using hamachi nw. i can login n create char already. i del away the GAMESERVER. in stored procedure cabal_sp_newchar. saw it at another thread. bt it needs quite a long time or need a relog to c the char is created
nw i cant login again. i get this error in globaldbagent
[Mon Apr 27 2009 22:52:11.304678 3065699232]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Mon Apr 27 2009 22:52:11.304924 3065699232]: [##ERROR##] DB ERROR(CODE) : 20009
[Mon Apr 27 2009 22:52:11.304998 3065699232]: [##ERROR##] DB ERROR(VAR_INFO) :
[Mon Apr 27 2009 22:52:11.305068 3065699232]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Mon Apr 27 2009 22:52:11.305136 3065699232]: [##ERROR##] DB ERROR(STM_TEXT) :
[Mon Apr 27 2009 22:52:11.305213 3065699232]: [##ERROR##] Database Connect Fail (uid=sa;pwd=12345;dsn=CabalAccount;APP=GlobalDBAgent)
[Mon Apr 27 2009 22:52:11.305461 3065699232]: [##ERROR##] check 'pDB' fail
[Mon Apr 27 2009 22:52:11.305543 3065699232]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:96)
[Mon Apr 27 2009 22:52:11.306084 3065699232]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(60:0:96) Addr(127.0.0.1)
Last edited by cypher; 27-04-09 at 08:11 PM. Reason: fixed dbl post.
[mod]do not double post, use edit[/mod]
you messed it up again, use the configs that worked a while ago,as for the previous problems was that the linked server had a wrong user or password.
Reply With Quote