//
{Question} Need Guided on ACCOUNT DB
12/22/2014 05:50
kasuma11#1
12/22/2014 11:42
Urbons#2
The problem is obviously in the sp_acc_login procedure, indicated in the second screenshot first just check whether changing from global to korea or the other way around in data/script/localdefine/locale will fix it, if that doesn't work, find another account database because there's no way you're gonna fix it on your own.
Eh, click New Query and execute this script
WARNING : thats a long ass text
Eh, click New Query and execute this script
WARNING : thats a long ass text
12/22/2014 22:49
kasuma11#3
thank you gonna try it now. Its been a while since i been in dekaron world. old DB user lmao!!! :)
I tried both the local.txt changed it from korea to global even tried HONGKONG still doesnt work so far and the script so far i still get the error. Thanks for trying.
I tried both the local.txt changed it from korea to global even tried HONGKONG still doesnt work so far and the script so far i still get the error. Thanks for trying.
12/22/2014 23:31
guesswho-.-#4
start up profiler and see what info sessionserver sends to the db and what the result is. then go to the SP it called and edit it.
12/23/2014 03:12
kasuma11#5
SESSION_SERVER_ID = 1100
SESSION_SERVER_PORT = 10000
WORLD_INDEX = 1
REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0
LOG_PATH = LogFiles
BILLING = 0
NO_CHARGE_CODE = NODATA
DONATION_UPDATE = 1
NATIONALCODE = HONGKONG
CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1
this is what it shows in the config on session server
i left out the database login credits out lol
SESSION_SERVER_PORT = 10000
WORLD_INDEX = 1
REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0
LOG_PATH = LogFiles
BILLING = 0
NO_CHARGE_CODE = NODATA
DONATION_UPDATE = 1
NATIONALCODE = HONGKONG
CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1
this is what it shows in the config on session server
i left out the database login credits out lol
12/23/2014 03:15
Snaiil#6
PM me, can help you
12/23/2014 03:17
guesswho-.-#7
this has nothing to do with what I said.Quote:
SESSION_SERVER_ID = 1100
SESSION_SERVER_PORT = 10000
WORLD_INDEX = 1
REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0
LOG_PATH = LogFiles
BILLING = 0
NO_CHARGE_CODE = NODATA
DONATION_UPDATE = 1
NATIONALCODE = HONGKONG
CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1
this is what it shows in the config on session server
i left out the database login credits out lol
12/23/2014 03:23
kasuma11#8
O LMAO, ok so whats profiler and i use this to find out which SP file in the stored procedure is pulling the information ?
12/23/2014 03:25
guesswho-.-#9
sql profiler will tell you which server accesses what in SQL.
your goal is to see what is sessionserver accessing and which SP it's calling.
your goal is to see what is sessionserver accessing and which SP it's calling.
12/23/2014 03:35
kasuma11#10
never used that before just opened it lol. basically its like wireshark sniffing packets, its just a real time log of whats going on on the server O.o
declare @p5 varchar(21)
set @p5=NULL
declare @p6 int
set @p6=NULL
declare @p7 int
set @p7=NULL
declare @p8 int
set @p8=NULL
declare @p9 varchar(21)
set @p9=NULL
declare @p10 varchar(21)
set @p10=NULL
declare @p11 varchar(6)
set @p11=NULL
declare @p12 int
set @p12=NULL
declare @p13 int
set @p13=NULL
declare @p14 int
set @p14=NULL
exec sp_acc_login 'dev','eb62f6b9306db575c2d596b1279627a4',1100,0xCF 90D76D,@p5 output,@p6 output,@p7 output,@p8 output,@p9 output,@p10 output,@p11 output,@p12 output,@p13 output,@p14 output
select @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14
so basically im wanting to look somewere in sp_acc_login ? and somthing is stoping login from there right
this is what is displayed
also i noticed no matter what i try login with it says cannot use ID. even putting random letters as user and pass.
declare @p5 varchar(21)
set @p5=NULL
declare @p6 int
set @p6=NULL
declare @p7 int
set @p7=NULL
declare @p8 int
set @p8=NULL
declare @p9 varchar(21)
set @p9=NULL
declare @p10 varchar(21)
set @p10=NULL
declare @p11 varchar(6)
set @p11=NULL
declare @p12 int
set @p12=NULL
declare @p13 int
set @p13=NULL
declare @p14 int
set @p14=NULL
exec sp_acc_login 'dev','eb62f6b9306db575c2d596b1279627a4',1100,0xCF 90D76D,@p5 output,@p6 output,@p7 output,@p8 output,@p9 output,@p10 output,@p11 output,@p12 output,@p13 output,@p14 output
select @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14
so basically im wanting to look somewere in sp_acc_login ? and somthing is stoping login from there right
this is what is displayed
also i noticed no matter what i try login with it says cannot use ID. even putting random letters as user and pass.
12/23/2014 04:06
guesswho-.-#11
good I guess.
now copy the query and run it and see what the SP returns.
running a query will return something. it might say you're using too many arguments, or to few, I'm not gonna guess or look into your issue. once you solve that, the query should return a value, check the code for the value it returns and see under which conditions it gets returned.
I guess you'll be able to go alone from there
now copy the query and run it and see what the SP returns.
running a query will return something. it might say you're using too many arguments, or to few, I'm not gonna guess or look into your issue. once you solve that, the query should return a value, check the code for the value it returns and see under which conditions it gets returned.
I guess you'll be able to go alone from there
12/23/2014 04:18
kasuma11#12
I parsed and executed it and it returns this and still doesn't change anything. :(
Command(s) completed successfully.
Command(s) completed successfully.
12/23/2014 05:20
baica123#13
you try to edit the script/localedefine/locale.txt a global, korea or china . I hope it will work .
sorry for the english
sorry for the english
12/23/2014 05:23
kasuma11#14
Yea i have tried that to HONGKONG, KOREA, GLOBAL, and USA, i havnt tried china or japan guess i could try.......
12/23/2014 05:37
baica123#15