Problem with version 4.4.1 on Windows 10
-
I tried to install NetXMS latest version 4.4.1 on Windows 10 with MySQL80 several times, and every time it cannot connect to the database server, no matter what username/password combination I used (tried also to change authentication method to legacy password). In addition to that, I cannot login to the NetXMS server for the first time, no matter what client I use - new webUI, jar or legacy web, I always get message "Connection refused"...
I thought it is just run-and-use operation, but for me it's mission impossible... Where'm I wrong??? -
Yes, the MySQL client library shipped with NetXMS requires to use "legacy password" mode (it's possible to replace this lib, but it's not what we are currently fixing).
I've just tried installing mysql-installer-community-8.0.34.0.msi and netxms 4.4.1, it worked fine.
Did you check "Create database and database user..." on the attached screen during installation:
-
Yes, of course, every time, I even manualy made netxms_db schema from NetXMS mysql template, but the problem is with rights, NetXMS cannot login to MySQL for some reason... I can't figure it out why...
Today I tried to install on Windows Server 2019, and got totally the same result...Here is the part of a log file:
2023.08.20 19:17:30.947 *I* [logger ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:17:30.947 *I* [startup ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:17:30.948 *I* [logger ] Debug level set to 0
2023.08.20 19:17:30.948 *I* [config ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:17:30.948 *I* [config ] Configuration tree:
2023.08.20 19:17:30.948 *I* [config ] config
2023.08.20 19:17:30.948 *I* [config ] +- server
2023.08.20 19:17:30.948 *I* [config ] +- DBDriver
2023.08.20 19:17:30.948 *I* [config ] | value: mysql.ddr
2023.08.20 19:17:30.948 *I* [config ] +- DBServer
2023.08.20 19:17:30.948 *I* [config ] | value: localhost
2023.08.20 19:17:30.948 *I* [config ] +- DBName
2023.08.20 19:17:30.948 *I* [config ] | value: netxms_db
2023.08.20 19:17:30.948 *I* [config ] +- DBLogin
2023.08.20 19:17:30.948 *I* [config ] | value: root
2023.08.20 19:17:30.948 *I* [config ] +- DBPassword
2023.08.20 19:17:30.948 *I* [config ] | value: ********
2023.08.20 19:17:30.948 *I* [config ] +- LogFile
2023.08.20 19:17:30.948 *I* [config ] value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:17:30.966 *I* [db.drv ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:17:30.971 *I* [comm.listener ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:17:30.971 *I* [comm.listener ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:17:56.009 *E* [db ] Unable to establish connection with database (Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.)2023.08.20 19:31:56.000 *I* [logger ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:31:56.000 *I* [startup ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:31:56.000 *I* [logger ] Debug level set to 0
2023.08.20 19:31:56.001 *I* [config ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:31:56.001 *I* [config ] Configuration tree:
2023.08.20 19:31:56.001 *I* [config ] config
2023.08.20 19:31:56.001 *I* [config ] +- server
2023.08.20 19:31:56.001 *I* [config ] +- DBDriver
2023.08.20 19:31:56.001 *I* [config ] | value: mysql.ddr
2023.08.20 19:31:56.001 *I* [config ] +- DBServer
2023.08.20 19:31:56.001 *I* [config ] | value: localhost
2023.08.20 19:31:56.001 *I* [config ] +- DBName
2023.08.20 19:31:56.001 *I* [config ] | value: netxms_db
2023.08.20 19:31:56.001 *I* [config ] +- DBLogin
2023.08.20 19:31:56.001 *I* [config ] | value: admin
2023.08.20 19:31:56.001 *I* [config ] +- DBPassword
2023.08.20 19:31:56.001 *I* [config ] | value: ********
2023.08.20 19:31:56.001 *I* [config ] +- LogFile
2023.08.20 19:31:56.001 *I* [config ] value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:31:56.021 *I* [db.drv ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:31:56.022 *I* [comm.listener ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:31:56.022 *I* [comm.listener ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:32:21.056 *E* [db ] Unable to establish connection with database (Access denied for user 'admin'@'%' to database 'netxms_db')2023.08.20 19:43:49.985 *I* [logger ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:43:49.985 *I* [startup ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:43:49.985 *I* [logger ] Debug level set to 0
2023.08.20 19:43:49.985 *I* [config ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:43:49.985 *I* [config ] Configuration tree:
2023.08.20 19:43:49.985 *I* [config ] config
2023.08.20 19:43:49.986 *I* [config ] +- server
2023.08.20 19:43:49.986 *I* [config ] +- DBDriver
2023.08.20 19:43:49.986 *I* [config ] | value: mysql.ddr
2023.08.20 19:43:49.986 *I* [config ] +- DBServer
2023.08.20 19:43:49.986 *I* [config ] | value: localhost
2023.08.20 19:43:49.986 *I* [config ] +- DBName
2023.08.20 19:43:49.986 *I* [config ] | value: netxms_db
2023.08.20 19:43:49.986 *I* [config ] +- DBLogin
2023.08.20 19:43:49.986 *I* [config ] | value: admin
2023.08.20 19:43:49.986 *I* [config ] +- DBPassword
2023.08.20 19:43:49.986 *I* [config ] | value: ********
2023.08.20 19:43:49.986 *I* [config ] +- LogFile
2023.08.20 19:43:49.986 *I* [config ] value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:43:49.998 *I* [db.drv ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:43:49.998 *I* [comm.listener ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:43:49.998 *I* [comm.listener ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:44:15.059 *E* [db ] Unable to establish connection with database (Access denied for user 'admin'@'localhost' to database 'netxms_db') -
First thing to try would be 127.0.0.1 instead of localhost - may be localhost is resolved into ipv6 address and database does not like it?
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login