PermissionsEx

PermissionsEx

14M Downloads

MySQL login not defined

TheSource85 opened this issue ยท 1 comments

commented

I'm trying to create a new login for MySQL but it's based on previous PEX versions and now it doesn't work.
Previously 'uri' was used, now 'url', but the username/password keys don't appear to work and I can't find out what they should be..

Error:

[Server] ERROR [ca.stellardrift.permissionsex.ext.com.zaxxer.hikari.pool.HikariPool] HikariPool-1 - Exception during pool initialization.
[Server] INFO java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)


Config:

version: 0
debug: true
backends:
    default-file:
        file: permissions.json
        auto-reload: true
        alphabetize-entries: false
        type: file
    default:
        prefix: pex
        url: jdbc:h2:permissions
        type: sql
    sql:
        url: mysql://localhost/<DBName>?useSSL=false
        username: <DBUserName>
        password: <DBPass>
        aliases:
            permissions: pex_permissions
            permissions_inheritance: pex_inheritance
            permissions_entity: pex_entity
        type: sql
        prefix: pex
default-backend: sql
platform:
    fallback-op: true
server-tags: []

commented

PEX 2 does SQL configuration differently -- the format is mysql://<user>:<password>@localhost/<database>. The documentation for PEX 2 isn't done yet, and v2 is not ready for production use -- but if you are interested in testing your feedback is appreciated.