1
response

h1, sorry my eng bad.
Why do I need to http://192.168.91.133:9090/nxlog-manager when specifying the login "admin" and the password "nxlog123", I get the error " could not contact the database server."

OS: CentOS Linux release 8.4.2105
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DB: usr/libexec/mysqld Ver 8.0.21 for Linux on x86_64 (Source distribution)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
my.cnf -> [client]
password=asdf
Password "asdf" install mysql root user

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

./dbinit.sh - Done

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

in /etc/hosts -> 192.168.91.133 localhost.localdomain

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[root@localhost db_init]# systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2021-09-22 15:59:27 MSK; 9min ago
Process: 4119 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
Process: 4277 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
Process: 4196 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
Process: 4171 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 4233 (mysqld)
Status: "Server is operational"
Tasks: 42 (limit: 49168)
Memory: 352.8M
CGroup: /system.slice/mysqld.service
└─4233 /usr/libexec/mysqld --basedir=/usr

сен 22 15:59:27 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server...
сен 22 15:59:27 localhost.localdomain systemd[1]: Started MySQL 8.0 database server.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[root@localhost db_init]# service nxlog-manager status
● nxlog-manager.service - NXLog Manager
Loaded: loaded (/usr/lib/systemd/system/nxlog-manager.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2021-09-22 15:58:28 MSK; 11min ago
Main PID: 4013 (java)
Tasks: 53 (limit: 49168)
Memory: 1.5G
CGroup: /system.slice/nxlog-manager.service
└─4013 /usr/bin/java -Xms1g -Xmx2g -XX:PermSize=64m -XX:MaxPermSize=256m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Dorg.apache.commons.collections.enableUnsa>

Sep 22 16:00:13 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:13 PM org.apache.jasper.compiler.JDTJavaCompiler setSourceVM
Sep 22 16:00:13 localhost.localdomain service.sh[4013]: WARNING: Unknown source VM 1.7 ignored.
Sep 22 16:00:14 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:14 PM org.apache.jasper.compiler.JDTJavaCompiler setTargetVM
Sep 22 16:00:14 localhost.localdomain service.sh[4013]: WARNING: Unknown target VM 1.7 ignored.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

nxlog-manager.log

2021-09-22 16:23:28,589 WARN localhost.localdomain unknown [com.mchange.v2.resourcepool.BasicResourcePool] - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@487eb16 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Unknown system variable 'tx_isolation'
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:268)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:296)
at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:349)
at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:408)
at org.mariadb.jdbc.MySQLConnection.getTransactionIsolation(MySQLConnection.java:410)
at com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:120)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:240)
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: Unknown system variable 'tx_isolation'
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:995)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1050)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1030)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289)
... 12 more

AskedSeptember 22, 2021 - 3:20pm

Answer (1)

Hey Julius,

Would you mind contacting our Presales Team for help? The community forum is focused on NXLog Community Edition, so catching Presales Team (or Support Team, in case of current customers) is the best way to get help.

Thanks!
Raf