-
Notifications
You must be signed in to change notification settings - Fork 3
Database
Realty stores properties, offers, auctions, rentals, and signs in a MariaDB database.
This page covers what to set up and how to edit database.yml. You need someone who can create a database and a login on MariaDB.
Create an empty database on MariaDB (many servers name it realty). Create a user that may create and change tables in that database. Realty creates and updates tables on startup and upgrades, so you normally do not import SQL by hand.
The Minecraft server must reach MariaDB over the network (localhost or a remote host with the port open).
After Realty runs once, open plugins/Realty/database.yml. You should fill in all three fields.
url: ''
username: ''
password: ''Put the database address in url without typing jdbc: first. Realty adds that.
Example when MariaDB is on the same machine and the database is named realty:
url: 'mariadb://127.0.0.1:3306/realty?useUnicode=true&characterEncoding=utf-8'
username: 'realty'
password: 'your-secure-password'Match host, port, database name, username, and password to what you created. Managed hosts often give you a host or string you can drop into the same pattern.
| What you see | What to try first |
|---|---|
| The plugin disables immediately when the server starts. | Confirm database.yml exists, has a non-empty url, and uses valid YAML spacing and quotes. |
| Errors about connecting or SQL access. | Confirm MariaDB is running, the IP and port are correct, firewalls allow the game server to reach MariaDB, and the username and password work from another client. |
| A message about the economy when the server starts. | That is separate from the database. Install Vault and a Vault-compatible economy plugin (Installation). |
Related pages: Installation · Configuration