NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Database create. Fail to create table  (Read 665 times)

Dan6

  • Newbie
  • *
  • Posts: 4
    • View Profile
Database create. Fail to create table
« 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.
Logged

Alex Kirhenshtein

  • Team Member
  • Administrator
  • Hero Member
  • *****
  • Posts: 905
    • View Profile
Re: Database create. Fail to create table
« Reply #1 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.
Logged

Dan6

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Database create. Fail to create table
« Reply #2 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
« Last Edit: October 02, 2018, 05:54:29 pm by Dan6 »
Logged

Dan6

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Database create. Fail to create table
« Reply #3 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.
Logged

Tatjana Dubrovica

  • Global Moderator
  • Full Member
  • *****
  • Posts: 221
    • View Profile
Re: Database create. Fail to create table
« Reply #4 on: October 25, 2018, 11:48:47 am »

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

Dan6

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Database create. Fail to create table
« Reply #5 on: November 01, 2018, 04:25:41 pm »

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