database

Setting up the database

SimpleStats uses the Bukkit persistance system. This means that you need to configure your bukkit.yml in your server directory with your database settings. Below are example bukkit.yml for MySQL and SQlite3.

MySQL

This is an example configuration if you wanted to use MySQL. This assumes that it is hosted locally and you want your minecraft database to be minecraft_game. You will need to customise this for your own username and password.

database:
    username: bukkit
    isolation: SERIALIZABLE
    driver: com.mysql.jdbc.Driver
    password: walrus
    url: jdbc:mysql://localhost:3306/minecraft_game

Troubleshooting

If you get errors when setting this up make sure that you have given your user enough permissions to administrate the database and the database itself does actually exist.

If the server appears to hang on start up, wrong database settings can be to blame. Swap back to the basic SQlite3 setup and see if that fixes the issue.

SQlite3

This is the default setting when you setup bukkit for the first time. It creates a sqlite database for each plugin that needs in the plugins data folder. For DimensionDoor this would be at plugins/SimpleStats/SimpleStats.db. You can change those folders by changing the settings below.

database:
    username: bukkit
    isolation: SERIALIZABLE
    driver: org.sqlite.JDBC
    password: walrus
    url: jdbc:sqlite:{DIR}{NAME}.db