Next Steps

Introduction

Welcome! This is the next part in our EVEmu tutorial. At this point you should have a working server and client and be able to connect. We're going to cover a couple different topics here so please check the Contents to find out what exactly you're looking for.

Market Seeding

The EVEmu Market by default comes unseeded. This means that there are no buy or sell orders populated into the database. We're going to cover how to fix that.

Docker Seeding

Figure 1

To be able to seed our market with the EVEmu docker setup we have to make a few changes to the docker-compose.yml

1. Locate your root EVEmu directory
2. Assuming you are on linux run nano docker-compose.yml
3. You should be presented with something like Figure 1
4. There are two changes you need to make here. Change #ports: to be ports:. Do this by removing the # in front of the line
5. Next remove the # in front of #  - "3306:3306" so that it looks like   - "3306:3306"
6. Ctrl + O
7. Click Enter
8. Ctrl + X
9. Run your build again by running docker-compose -p evemu up -d
10. Assuming you already have the mysql client installed run mysql -u evemu -p -h 127.0.0.1 < sql/seed_and_clean/seed_market.sql from the evemu_Crucible folder.
11. You will be prompted for a password. Enter evemu
12. This will take awhile to complete. Once it is done run mysql -u evemu -p -h 127.0.0.1
13. This will bring you into the mysql client connected to the EVEmu database.
14. Insert use evemu;
15. Click Enter
16. Now run select * from mktOrders LIMIT 10; This command grabs the top 10 entries in the mktOrders table.
17. If this command returns data you now have a successfully seeded market.
    1. NOTE: The script that we ran in Step 9 currently only seeds the Derelik Region. If you'd like to seed others please change the regionID variable in the seed_market.sql script
18. Now with your market successfully seeded we suggest undoing steps 4 and 5 by replacing the comments and rerunning step 9. This makes your database no longer accessible from anywhere protecting it.

Source Seeding

1. Locate your root EVEmu directory
2. Assuming you already have the mysql client installed run mysql -u evemu -p -h 127.0.0.1 < sql/seed_and_clean/seed_market.sql from the evemu_Crucible folder.
3. You will be prompted for a password. Enter your evemu users password.
4. This will take awhile to complete. Once it is done run mysql -u evemu -p -h 127.0.0.1
5. This will bring you into the mysql client connected to the EVEmu database.
6. Insert use evemu;
7. Click Enter
8. Now run select * from mktOrders LIMIT 10; This command grabs the top 10 entries in the mktOrders table.
9. If this command returns data you now have a successfully seeded market.
   1. NOTE: The script that we ran in Step 9 currently only seeds the Derelik Region. If you'd like to seed others please change the regionID variable in the seed_market.sql script