Ask questions. Get answers. Find technical product solutions from passionate experts in the NXLog community.

NXLog manager cannot communicate with DB server
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

nhryshalevich created
Replies: 1
View post »
last updated
Сollect events from the database use Time-based (Not Id)
Hello Help me please. I want collect events from the database use Time-based (Not Id)  What can i do? Thank  

toreno93 created