Print Page - SQL query failed during installation

Title: SQL query failed during installation
Post by: mikkoztail on May 24, 2021, 01:08:19 PM

I'm trying to install NetXMS on Windows Server 2019 and using MySQL version 8. I try to create the database at installation but I get the following error. I'm new to MySQL so I'm not sure what to do.

thanks for any help

Title: Re: SQL query failed during installation
Post by: Filipp Sudanov on May 24, 2021, 02:46:39 PM

The reason could be that caching_sha2_password, let me cite a paragraph from the docs:

Bundled MySQL database drive does not support caching_sha2_password authentication which is default for MySQL starting from version 8. Either select Legacy Authentication Method when installing MySQL, or use database driver installed along with MySQL. Databasedriver gets installed when installing MySQL with Server-only option, however these two folders should be included into system path:C:\Program Files\MySQL\MySQL Server 8.0\lib C:\Program Files\MySQL\MySQL Server 8.0\bin.

Title: Re: SQL query failed during installation
Post by: mikkoztail on May 24, 2021, 02:49:28 PM

Thank you for your reply. I did select legacy authentication when installing MySQL

Title: Re: SQL query failed during installation
Post by: Victor Kirhenshtein on May 26, 2021, 08:45:37 AM

Hi,

this is bug NX-1964: https://track.radensolutions.com/issue/NX-1964 (https://track.radensolutions.com/issue/NX-1964). It is fixed in development branch, but not in version 3.8. In the meantime, create user and database manually and choose to initialize existing database in installation wizard.

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: mikkoztail on May 24, 2021, 01:08:19 PM