Official server leak 3.1-4.0 private backup

Resources

sql-3.2.7z / welink-pkg.7z / srv-bins.7z / Leak.zip

https://pan.huang1111.cn/s/6vk6hN?password=LEAKISNOTGOOD&path=%2FServer%20Side%20Leak

Leak.zip password is 2022.10.24.114515

Special thanks to xudong.zhong

GuideEN

Notice: we’ll be using a bundled dispatch server, but it can only serve HTTP. You will need to wrap HTTPS traffic from the client by using e.g. mitmproxy.
Notice: the bundle provided doesn’t include SDK server. You’ll have to find one by yourself, otherwise you won’t be able to login.
-) Install VirtualBox (or other virtualization solution)
-) In VBox, create a new virtual network
-) In VBox, create a new VM with 20 Gb of HDD space and 10 Gb or RAM (16 Gb recommended).
-) For this new VM add two network adapters, one NAT for accessing the Internet, another “virtual host adapter” for communicating with the host machine.
-) In VBox, create a shared folder pointing to the desired location of the files. Assign this folder to the VM.
-) Move scripts from “sql-3.2.7z” archive into “tools/op_tools” subdirectory.
-) Move data from “welink_3.2_qa” directory of “welink-pkg.7z” archive into “data/” subdirectory.
-) Put dev_gio.yaml into the directory “tools/op_tools/conf/dev”. Remember to change the IP address everywhere to match the virtual host adapter IP assigned to your VM.
-) Register this config in “tools/op_tools/conf/global.xml” by adding a line
-) Change line #418 in “tools/op_tools/bin/build_conf.py” from env=”test” to env=”dev”. Comment or remove lines 161 and 195.
-) Change line #109 in “tools/op_tools/bin/server_parse.py” from env=”test” to env=”dev”
-) Comment line #173 in ready_deploy_dev.py. Add new line #153 with an argument auth_plugin=’mysql_native_password’. Add new line #160 with text mycursor.execute(“CREATE DATABASE IF NOT EXISTS db_hk4e_deploy_config_{0}”.format(suffix_name))
-) In VBox, install Ubuntu Server 22.04 (you can use any distro, just make adjustmensts).
Next steps are preformed inside the VM
-) Set timezone to UTC.
-) Add an /etc/fstab mount point to the shared folder you’ve created. Mount it.
-) Set bash as a default system-wide shell by running “dpkg-reconfigure dash”
-) Install openssh-server and configure it for passwordless login of your user (with a key file). You can also just type the password everytime scripts require it, but that’s a ton of typing…
-) Install git and golang
-) Install mysql-server, libmysqlclient-dev, redis and gawk
-) Setup MySQL: user “work”, password “GenshinImpactOffline2022”, auth method “mysql_native_password”. Grant all priveleges to this user.
-) Setup Redis: default password “GenshinImpactOffline2022”. Increase databases number to 20.
-) Install python2.7 and python2.7-dev, make a symbolic link /usr/bin/python2
-) Install python-pip and using pip2 install requests, Jinja2, enum and pyyaml packages.
-) Install a very old version of mysql-connector-python package: https://downloads.mysql.com/archives/get/p/29/file/mysql-connector-python-2.0.5.tar.gz (“sudo python2 setup.py install” will do the trick)
-) Clone https://github.com/schemalex/schemalex into “tools/schemalex_tool” directory.
-) Build it with “make build”. Put binaries into “bin” subfolder of schemalex directory, create if necessary.
-) Now DISABLE THE INTERNET CONNECTION FOR THE VM. You can “unplug” a virtual cable or shutdown your VM and remove / disable NAT Ethernet adapter entirely. Only leave virtual host adapter “plugged in”.
-) Run ready_deploy_dev.py as “python2 ready_deploy_dev.py dev_gio”. Now you have empty MySQL databases ready.
-) Run “bash tools/op_tools/bin/deploy_dev dev_gio config”
-) Run “bash tools/op_tools/bin/deploy_dev dev_gio reload”
-) Now you should have configs and data ready. Copy provided version.txt file into the generated data directory. Create a new empty “res” directory.
-) Go to “tools/op_tools/bin” directory and run “python2 update_sql.py dev_gio”.
-) Go to “tools/op_tools/sql_temp/0.1” directory and run “sudo mysql db_hk4e_deploy_config_gio < hk4e_deploy_config.sql”.
-) Now you have a database structure with all the reqiured empty tables.
-) Look at the attached SQL script “populate_tables.sql” and modify client version, UID, RSA keys and all URLs to your needs. Apply script by running “sudo mysql < populate_tables.sql”.
-) Copy all binaries to their respective directories.
-) Run “nodeserver -i 9001.3.1.1”
-) Run “gateserver -i 9001.1.1.1”
-) Run “dbgate -i 9001.4.1.1”
-) Run “dispatch -i 9001.5.1.1”
-) Run “gameserver -i 9001.2.1.1”
-) Start your SDK server emulator.