MySQL login not defined
Closed this issue · 1 comments
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: []
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.