1
response

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
AskedOctober 25, 2021 - 11:57am

Answer (1)