MySQL - SimpleAuth

I have MySQL installed on a Ubuntu server. To use it with SimpleAuth do I need to make a table? If so how would I do that? (MySQL n00b xD)

Nope. SimpleAuth will automatically create it. But you have to create a database for SimpleAuth to use. The database name should be the same as https://github.com/PocketMine/SimpleAuth/blob/master/resources/config.yml#L14

OK, thanks! Trying that now.

My config looks like this:

Code:

# Default config for SimpleAuth plugin
#Sets the data provider (yaml, sqlite3, mysql, none).
#Only use none when there is another plugin that will integrate its dataProvider with SimpleAuth
#Be aware that data is not automatically moved between data providers.
dataProvider: mysql
#For MySQL:
dataProviderSettings:
host: "52.19.23.88"
port: 3306
user: "user"
password: "password"
database: "sql8112360"
#dataProviderSettings: []

#If enabled, existing logged-in accounts won't be kicked if a new player joins with the same name
forceSingleSession: true

#Sets the minimum amount of characters to be used when registering a new account
minPasswordLength: 6

#Will block user after this number of failed attempts. Set to 0 to disable
blockAfterFail: 6

#If enabled, accounts that are using the same unique id (ip + clientId + name) when logging in again will be automatically authenticated
authenticateByLastUniqueId: false

#If enabled, will set all the permissions for simleauth.command.register to false
disableRegister: false

#If enabled, will set all the permissions for simleauth.command.login to false
disableLogin: false

#Number of seconds to wait for a player to be authenticated. If false, disables the timeout
#TODO
authenticateTimeout: 120

This is the error I get:

Code:

[16:29:35] [Server thread/CRITICAL]: [SimpleAuth] Invalid MySQL settings

What did I do wrong?

Change to
host: "0.0.0.0"

Spoiler: P.S

If you want to use one unique SimpleAuth folder for all your servers aka you want to share the same passwords across multiple serves on the same vps, you can just link files using 'ln -s'

Ok thanks, I tried a file link... Do I link /server/plugins/simpleauth/players to server2/plugins/simpleauth/players or /server/plugins/simpleauth/ to /server2/plugins/simpleauth/?

Suppose
server1 is the main server (/server1)
server2 is a sub-server (/server2)



You must first delete or rename your server2's SimpleAuth/players folder. Then

ln -s /server1/plugins/SimpleAuth/players /server2/plugins/SimpleAuth

Indent the MySQL lines one space forward.