NXLog manager cannot communicate with DB server
nhryshalevich
I've tried to deploy NXLog manager, but when I enter the credentials in Web UI, the output says "Cannot communicate with database server."
I use NXLog-manager v5.5, MySQL v8.0.26
log/nxlog-manager.err output:
java.sql.SQLException: Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.Driver.connect(Driver.java:115)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:571)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:501)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:722)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:281)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
... 9 more
nxlog-manager.conf
NXLOG_MANAGER_PATH=/opt/nxlog-manager
BIN_PATH=${NXLOG_MANAGER_PATH}/bin
WEBAPP_PATH=${NXLOG_MANAGER_PATH}/webapps/nxlog-manager
LOGS_PATH=${NXLOG_MANAGER_PATH}/log/nxlog-manager
CONTEXT_PATH=/nxlog-manager
JROBIN_PATH=${NXLOG_MANAGER_PATH}/data/rrd
JETTY_RUNNER_PATH=${NXLOG_MANAGER_PATH}/lib/jetty-runner-9.0.7.v20131107.jar
JETTY_LIB=${NXLOG_MANAGER_PATH}/lib
JETTY_CONFIG_PATH=${NXLOG_MANAGER_PATH}/conf/jetty-config.xml
JETTY_RUN_CMD="-cp $JETTY_RUNNER_PATH org.eclipse.jetty.runner.Runner"
# This uses standalone mode, for distributed mode use 'distributed-manager'
INSTANCE_MODE=nxlog-manager
JVM_OPTS="-Xms1g -Xmx2g -XX:PermSize=64m -XX:MaxPermSize=256m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Dorg.apache.commons.collections.enableUnsafeSerialization=true -Dorg.eclipse.jetty.annotations.maxWait=120 -Dnxlog.manager.jrobin.path=$JROBIN_PATH -Dlogs.root=$LOGS_PATH -Dnxlog.manager.path=$NXLOG_MANAGER_PATH -Dnxlog.manager.contextpath=$CONTEXT_PATH -Dnxlog.manager.webapp.path=$WEBAPP_PATH -Dspring.profiles.active=$INSTANCE_MODE"
PIDFILE=${NXLOG_MANAGER_PATH}/data/nxlog-manager.pid
JAVA=/usr/bin/java
PORT=9090
NXLOG_MANAGER_USER=nxlog-mgr
NXLOG_MANAGER_GROUP=nxlog-mgr