talk

[NL0bP]

It is impossible to make reconnection or to enter another client

[Kalle801]

Yanlong deleted his project. Its over...

[NL0bP]

Yes, it's unexpected .... But there are 11 forks, for example [here] (https://github.com/veraalex97/Archeage-Server-emulator-or-files).

[Kalle801]

oh lol didnt know that. Amazing :)

[JeyFrey]

Hey I also keep downloading all new files and stages of development, so if all stuff gets deleted, I still have a few backups.

[Kalle801]

Hello again :) I try to get into the work with the newst files but i cant even load the characters. It is like the server does not read the tables.

----------------------------------------------------------------------[ MySQL ] 12.08.2018 04:02 [INFO] - Error: Unknown error 12.08.2018 04:02 [INFO] - Load to 0 accounts

What do i have to do with the: archeage_world Database which i can not find ?

[NL0bP]

For LoginServer, the database should be called archeage. The database must have tables accounts and characters.

[NL0bP]

Let me remind you: the password is encrypted by MD5 and written to the token field.

[NL0bP]

GameServer does not use any database yet, so it's like it's written in the config.

[Kalle801]

i got it all like this but i use your filesonly, do i need other files also?

No matter what i do. It wont connect to mysql: https://img1.picload.org/image/dloppgcr/2018.08.12-12.47.png

It Says: The Host does not support SSL connections: https://img3.picload.org/image/dlopprgi/2018.08.12-13.04.png

[sxeroot]

@Kalle801 localhost or 127.0.0.1 run mysql servers usualy have ssl off unless configured otherwise, loginserver tries to connect with ssl you need to add SslMode=none to the connection string in the Settings.cs file of the loginserver

[Kalle801]

hm i dont know wehere to add it. Im still learning c#

[sxeroot]

@Kalle801

Loginserver files Settings.cs line 24

looks like

string connection = "server=" + Settings.Default.DataBase_Host + ";user=" + Settings.Default.DataBase_User + ";database=" + Settings.Default.DataBase_Name + ";port=" + Settings.Default.DataBase_Port + ";password=" + Settings.Default.DataBase_Password + ";";

change to

string connection = "server=" + Settings.Default.DataBase_Host + ";user=" + Settings.Default.DataBase_User + ";database=" + Settings.Default.DataBase_Name + ";port=" + Settings.Default.DataBase_Port + ";password=" + Settings.Default.DataBase_Password + ";SslMode=none";

[Kalle801]

Got it! Thank you :)

Im in the World! :)
The quest crashed it ^^

We need quest and item database right?

[Kalle801]

@NL0bP Would you be so kind and upload the client u use? With the ArcheRage client i cant do anything.
Or are you using another client database?

[NL0bP]

This is all that is at the moment. There is no one, nothing can be done. You can only see the world.
The fact that we see three NPCs and the quest is the result of hardcoded packages.
To re-enter, you need to restart the server - this is not the resolved issue of this topic.

PS
Please open new issues as needed. Do not use this issue for communication.

[Kalle801]

If i got an ArcheAge mysql database (full) not encrypted. Would that help?

Oh sorry dint saw the last message.

[Rain0Ash]

I think yes. More - no less, come in handy.

[NL0bP]

Yes, if you can give a link to it.

[Kalle801]

I had one but deleted it. I have to find it again. Give me a view days.

[NL0bP]

Good. Let's wait.

[Rain0Ash]

Perhaps not in the subject, but as far as I can remember, in the early versions of AA there was no protection for the packages. It remains to find a beta client or early patches 1.x. But it's just, for the sake of information.

[JeyFrey]

We need to find out how the database can be decrypted, I am just extracting the game_pak (still loading) from the 3.0.3.0 version and found some websites with hints how to decrypt it. Will keep you updated, but I literally just started learning programming, so dont expect anything.

[Kalle801]

i got the client (game_pak) editor if someone needs it.

https://www.file-upload.net/download-13270844/ArcheAgePackTool_v1.0.1.rar.html

[JeyFrey]

Unpacking the game_pak gives me lots of data, including compact.sqlite - but it seems one needs a compact.sqlite3 to do anything further instead, so how do you convert a .sqlite to .sqlite3?

[sxeroot]

@JeyFrey you dont, or more like you cant with that one since it needs to be decrypted first that is the issue the old databases werent encrypted cant remmeber the point of when they started encrypting them but the 2013 leaked files had a sqlite3 file that had alot of things maybe as a base could be used link below

https://anonfile.com/2fw6N7fcba/compact.sqlite3

i believe its more or less the same db provided in the other opened issue as plain sql there

[JeyFrey]

@sxeroot I see. I thought from reading this thread post, that it should still work if I find any way to convert it into the right sqlite3: http://forum.ragezone.com/f857/tools-archeage-db-converter-pack-1040661/#post8281281

So what we basically need is a way to encrypt the new compact.sqlite as well as a way to create + delete characters, right?

[sxeroot]

@JeyFrey i did try that method described in ragezone that you linked yesterday evening tho it was getting late and didnt get any promising results so i gave up, that there takes in an sqlite3 file can change it to take sqlite instead and see if it decrypts it will do that later today and post results.

as for the rest if someone is able to decrypt it would be awesome since we would get all the structures used by the game however they arent really nessesary the database can be recreated in theoretical way like the character table we know what the game will need to store more or less on character data so we can play around with it ofcourse this will take longer to do, tho i still believe the old database can be atleast used as base and newer stuff added to it because even tho its been like 5 years probably not much has changed in the main structure of the database.

[Kalle801]

I am able to import the unencrypted compact.sqlite to the client without errors. If that helps, let me know.

I found this : ASCII "9e53f9e9ea97e79c0d97c29b30aa171e0a3ddf6f"
In ArcheRage client (Russian)

Maybe somebody knows what it is for.

[Rain0Ash]

In archeage.exe - .xlgames? I also found it, but I think it's some kind of hash. Also I found two old programs for decrypt db, but it's not very clear how they work.
App.zip

[JeyFrey]

@Rain0Ash
Its basically the same stuff that can be found in my link few comments above - you can also find a FAQ on how to use it there.
It needs a compact.sqlite3 but I only have a compact.sqlite. So I took the code and tried to exchange the sqlite3 with sqlite but I ended up with some "numbers too big" error while debugging in Visual Studio 2017.

[Rain0Ash]

@JeyFrey
As I understand it, CA1 should create a decrypted.data file with some information in hex, however it creates an empty file. CA2 requires data in this file, but file is empty -> error. There it is said that in patch 2.0 updated the encryption base, apparently because of this.
My CA2 error:
Unhandled exception: System.Security.Cryptography.CryptographicException: Invalid data length for decryption.
in System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock (Byte [] inputBuffer, Int32 inputOffset, Int32 inputCount)
in System.Security.Cryptography.CryptoStream.FlushFinalBlock ()
in System.Security.Cryptography.CryptoStream.Dispose (Boolean disposing)
in System.IO.Stream.Close ()
in ConsoleApplication2.Program.Decrypt (String encryptedFile, String decryptedFile, String keyFile)
in ConsoleApplication2.Program.Main (String [] args)

[JeyFrey]

@Rain0Ash
Yeah I had that same error, I just didnt knew the exact same words in english, thats why I translated it in a kinda free way.
From what I know, you need to place the CA1 and the compact.sqlite in the unpacked game_pak folder bin32 and then start the CA1.
Did you try it that way or with a compact.sqlite only? And do you have a compact.sqlite or .sqlite3?

I seems that the method only worked before they changed the encryption OR we are just missing something.

[Rain0Ash]

@JeyFrey
compact.sqlite, for CA1 i renamed it to compact.sqlite3, i try to add 16 hex \x00 in file head, but no difference.

[JeyFrey]

@Rain0Ash
Guess we need to find someone who is able to decrypt it in a way that we cant see or we just need to trial and error with databases until we find the right way how they work.

[Rain0Ash]

@NL0bP It would be nice if all information about undefined packets were displayed (and save optionaly). Unfortunately, C# I can only read, but not write.

[DancerS]

I ask, create new topics for discussion on various issues, and then it's not on the topic went ... and have a long flipping to the bottom

[JeyFrey]

Can anyone explain me how the tables "accounts" and "characters" need to look like and what the syntax is?
Or can someone upload their sql database for loginserver? Struggeling to get it setup.

[NL0bP]

@JeyFrey look in the folder:
ArcheAgeLogin\bin\Debug\sql\accounts+.sql
ArcheAgeLogin\bin\Debug\sql\characters+.sql

[JeyFrey]

@NL0bP
Thanks, its working now. As you cant accept the quest on the boat (at least I cant), how do you progress to the open world? Or what parameter is needed where to get started directly there?

[Kalle801]

The quest is a thing which need a database to be done (variable) so its not possible yet.

[CaioFPeres]

Hello, i couldnt understand how do i make the server work. Could someone help me on this? The exe's crash after i run them...

[NL0bP]

@CaioFPeres, see https://github.com/NL0bP/Archeage-Server-emulator/releases/tag/1.2.12 or compile a project

[CaioFPeres]

Well i have seen it but the exes crash. Do i have to create an database under 3306 port for it to run?

[NL0bP]

@CaioFPeres, all tables must be installed in the database archeage

[CaioFPeres]

Ok, i did it. But now it wont get past char creation screen. I put name and click, and nothing happens...

[NL0bP]

@CaioFPeres, сreating characters and entering into the world of running for version 1.0.1406. In version 3.0.3.0 encrypted traffic.

[CaioFPeres]

Ok, thanks for the replys. But on the past pictures you posted on the main page, there was showing the client 3.0.3.0 running into the world. Can't it do it?

[NL0bP]

@CaioFPeres, hardcoded packages can. You cannot make your character and them to enter.