Print Page - Database create. Fail to create table

Title: Database create. Fail to create table
Post by: Dan6 on October 01, 2018, 05:57:07 PM

Hi,

Have MySql installed and trying to hook up NetXMS.

Ive tried the create new database option but it cant even grant itself permission to the DB

Now trying use existing,
Ive created a user for netxms in MySQL.

It seems to be able to create a load of tables but always fails on the attached.

Between every try i am dropping the schema.

Title: Re: Database create. Fail to create table
Post by: Alex Kirhenshtein on October 02, 2018, 02:28:40 PM

Hello.

What version of the NetXMS you are installing? This issue was fixed in 2.2.9.

Title: Re: Database create. Fail to create table
Post by: Dan6 on October 02, 2018, 05:07:45 PM

2.2.9

Now tried sql express 2017 and it cant even login. Haveenable mixed login mode so its not just windows authentification.

Would be useful to have a guide for this stuff so we know what settings to choose. Seems to be many posts with same issues.
Enabled named pipes and tcp in sql express.
With sql express 2017 you get the message when installing Netxms that a newer version of the SQl client is installed so it doesnt use the one in the netxms installer

Title: Re: Database create. Fail to create table
Post by: Dan6 on October 03, 2018, 01:31:04 PM

Nope, Definatly not fixed in MySQL

just did a complete reinstall, Created the DB in workbench and assigned the user.

Still get the error in the pic above.

Title: Re: Database create. Fail to create table
Post by: Tatjana Dubrovica on October 25, 2018, 11:48:47 AM

What version of MySQL are you using? We do not support MySQL 8.

Title: Re: Database create. Fail to create table
Post by: Dan6 on November 01, 2018, 04:25:41 PM

Downloaded the last release of sql and everything went through OK thx.

NetXMS Support Forum

English Support => General Support => Topic started by: Dan6 on October 01, 2018, 05:57:07 PM