[Help] Little issue with Database

[DevilDek]

So i got my local server up and running.
Got my client all set up

Issue:
When i open SQL 2008 or 2014 (tried both now)
I set up my account ID /Password and resident_no (801011000000) in the table ''USER_PROFILE''

I then repeat the same step in CP_USER_PROFILE
Only this time i use a MD5 hashed password.

I execute it, go to my client, type in the details and log in.
i get this
ID :craig
Pass :5f4dcc3b5aa765d61d8327deb882cf99
IPServer :127.0.0.1
Check Account Login
Login Fail : User Name Or PassWord Wrong !

I done this first in SQL 2008 and then 2014, both saying the same thing.

Could i be using the wrong databse ?

Also if someone could message me a DL link for A9 11 class databse that'd be awesome, i could maybe try a different database.

Been stuck on this issue all day, pulling my hair out.
Thanks in advance

EDIT: Downloaded the A9 11 class databases from stickied post with no luck.
Still having same issue

[guesswho-.-]

you need the password in md5 in USER_PROFILE table

[DevilDek]

Thanks man! Appreciated.

Now onto another issue. (*** hates me tonight lol)

So now it says this on accountserverapp
Pass :7561dfb3b25a09760d53b75c5bc54d5a
IPServer :127.0.0.1
Check Account Login
Login User No :1
Login success :1

However on the client it displays this error ''600,300'' really really fast when i try log in.

Any ideas ?


EDIIT:
This is on the debug
23:28:34 1650 .\Client\Pc\State\NotLogins\Authening.cpp(157) :
23:28:34 1650 [OnAccountGatePacket][Recv AccountGate Packet]
23:28:34 2584 .\Pc\State\NotLogins\Loginings\Logining.cpp(279) :
23:28:34 2584 [onPCListMethod] [MethodCode : 4]
23:28:34 1650 .\Client\Pc\State\NotLogins\Loginings\Logining.cpp (170) :
23:28:34 1650 [Logining][Session Recved APcket][-300]
23:28:44 0F20 avcore\npsm\localprovider\baseprovider\lib\basepro vider.cpp(604)\NPSMDesktopProvider.dll!00007FFD983 92140: (caller: 00007FFD983926E5) ReturnHr(1704) tid(fcc) 80070490 Element not found.

-------------------------------------------------------------------------------------

Now managed to pass that (somehow)

Can log into my server, create a character.
now getting this issue once ive selected character and connect to game.

00:35:48 0D50 onecore\ds\security\umstartup\usermgr\cli\usermgrc li.cxx(165)\usermgrcli.dll!00007FF9E1F411F6: (caller: 00007FF9CA1FE08B) ReturnHr(284) tid(2770) 80070005 Access is denied.
00:35:48 0D50 onecoreuap\base\appmodel\execmodel\modern\lifetime manager\appxexecutionutil.cpp(41)\modernexecserver .dll!00007FF9CA1FE16C: (caller: 00007FF9CA1CB485) ReturnHr(295) tid(2770) 80070005 Access is denied.


Any ideas?


Does whitelist have anything to do with this issue ?

01:13:49 0498 IGIESW c:\users\craig\downloads\dekaron\dekaron\bin\dekar on.exe found in whitelist: NO
01:13:49 0498 IGIWHW Game c:\users\craig\downloads\dekaron\dekaron\bin\dekar on.exe found in whitelist: NO

[[DEV]Dekaron]

i see this first time and i don't have idea wtf?! is wrong with this

Write more info this is Server and client A2 or A9?

[DevilDek]

Yeah i found the issue.
It's the client files have been messed with so much that they have been rendered useless.

Time to look for more client files.
Client files that actually work lol

[Proxynear]

I had that problem with diferent server-files structure, and after i change it, it had worked fine.Try to look foward at epvp, theres many posts about that

[DevilDek]

now i've managed to get everything to run, except the dekaronserver.exe

here's what it's displaying
12:29:25 1C68 ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
12:29:30 0C34 onecore\base\appmodel\resourcepolicy\gameconfigsto re\client\gameconfigstoreclient.cpp(104)\resourcep olicyclient.dll!00007FFF9F50976C: (caller: 00007FFF83358BE3) LogHr(41) tid(2168) 80070490 Element not found.
12:29:31 0760 IGIESW c:\users\craig\downloads\dekaron new\dekaron\bin\dekaron.exe found in whitelist: NO
12:29:31 0760 IGIWHW Game c:\users\craig\downloads\dekaron new\dekaron\bin\dekaron.exe found in whitelist: NO

[Proxynear]

Which server files you are using on?

[freez00]

Originally Posted by Proxynear

Which server files you are using on?

Troll alert beware!