Database create. Fail to create table

Started by Dan6, October 01, 2018, 05:57:07 PM

Previous topic - Next topic

Dan6

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.

Alex Kirhenshtein

Hello.

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

Dan6

#2
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

Dan6

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.

Tatjana Dubrovica

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

Dan6

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