Hello,
I have a problem that prevents me from installing NetXMS 3.4.313 x64 server on Windows Server 2019.
My problem is for the connection to the database when installing the NetXMS server.
I have already tested the 2 possibilities of either letting the installer create the database or having already created it myself with a user created especially for this database.
I also tried the basic login credentials "admin" with the password "netxms" although they shouldn't be the ones that should be used at this point in the installation.
In both cases I have the same error which comes to me.
I have already researched the "caching_sha2_password" error and could not find a solution to fix this bug.
In the administrator's guide it is noted that the compatibility with the MySQL 8.0 server is taken into account.
I tried to install an old version of MySQL Server, 5.7 for example, but it still doesn't work.
If you have a solution it is welcome and thank you in advance for your help.
Hi!
Just some suggestions:
As a not so secure workaround, see this: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded (https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded)
Instead you could try downloading and installing a driver from https://www.mysql.com/products/connector/ (https://www.mysql.com/products/connector/), but I don't know if it will do anything. I had other connectivity issues with postgres and oracle (haven't used mysql), and in those cases installing the appropriate driver helped.
Best regards
Hello,
Thanks for your help. Your driver did not work on my MySQL.
But the solution: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
almost worked for me.
Their technique of modifying my.ini (on Windows) blocked the restart of my server.
The real solution that worked for me on Windows Server 2019 was to uninstall and then reinstall the MySQL 8.0.21 server, this time changing the encryption of the password during the installtion.
As well as creating the database myself and the user because the automatic version of NetXMS does not work.
Thanks for the help, good bey.
The other options is to use MySQL client library that is shipped with MySQL server - supports the new authentication option. For this, add these folders to C:\Program Files\MySQL\MySQL Server 8.0\lib`
C:\Program Files\MySQL\MySQL Server 8.0\bin and uncheck MySQL client library in NetXMS installer.