Ask questions. Get answers. Find technical product solutions from passionate experts in the NXLog community.
NXLog manager cannot communicate with DB server
nhryshalevich created
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
Сollect events from the database use Time-based (Not Id)
toreno93 created
Hello
Help me please.
I want collect events from the database use Time-based (Not Id)
What can i do?
Thank
toreno93 created