Help to sync shop within cluster

Rumaan

New member
Messages
14
Likes
0
Points
1
Here is a full guide, courtesy of WETBATMAN (They helped walk me through the full process of installing MySQL).

Go to this website and download the larger of the two MySQL msi installer options.
https://dev.mysql.com/downloads/windows/installer/8.0.html
Windows (x86, 32-bit), MSI Installer
(I had issues with the online version, the smaller one, so I recommend the offline version, the larger one)

Run the msi installer.
Choose the "Custom" option.
Under what to install choose these three options:
-MySQL Server 8.0.16 - x64
-MySQL Workbench 8.0.16 - x64
-Connector/C++ 8.0.16 - x64

Once these finish installing it will have you configure your options.
First option chooses how much RAM MySQL will use. I went with medium usage, though I feel you may get away with low easily enough.
Then set up your connection port. Remember this number as you will need it to connect to the MySQL database.
Next is the Authentification Type, choose legacy.
Then choose the main password for connecting to your MySQL. Make sure to save this too.
For Windows service just leave it as default.
Now it should apply all of your settings and finish up.

Once it does this you should have the MySQL Workbench pop up for you.
Click the "Local Instance" and open it up.
Add and name a Schema to it, remember this name (has to be lower case).

That should be it. Add all the relevant info to your Shop API config file at the top and run the server, making sure your MySQL database is online. The database will store player points and player kit amounts. If you need to separate points/kit amount for any reason, say between PvE and PvP servers, then just create and name a different Schema and link the relevant Shop API config to that one instead by using that Schema's name.

Example Shop API config:

"Mysql":{
"UseMysql":true,
"MysqlHost":"localhost",
"MysqlUser":"root",
"MysqlPass":"<my root password>",
"MysqlDB":"<schema name>"
},

Again, all thanks to WETBATMAN for helping me through this. Just wanted to outline the steps I took in case anyone else needs them. Feel free to ask for clarification and I will adjust the guide to include it.
 
Last edited:
Advertisement

Monetise Your Game Server

Want to monetise your ARK Server? Create your own webstore at tebex.io

sombruuh

New member
Messages
9
Likes
0
Points
1
I can't seem to get the MySQL connection to work. I have followed all of the steps and have tested the connection in the workbench and it is working.

But when adding the details to my ArkShop json, the shop fails to load because "can't connect to mysql database"
 

Rumaan

New member
Messages
14
Likes
0
Points
1
that's not necessary since you can just use the ROOT account to connect to mysql
I had issues with that, even after opening the root account to allow for other IPs other than localhost to connect to it. The easy fix was making a secondary login account and using that in the jsons.
 
Top