NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Trouble installing/initialising db on Ubuntu 16.04 xenial  (Read 595 times)

jeremyh

  • Newbie
  • *
  • Posts: 1
    • View Profile
Trouble installing/initialising db on Ubuntu 16.04 xenial
« on: September 02, 2018, 05:11:20 pm »

Hi,

I am trying to install NetXMS 1.2 on Ubuntu 16.04 xenial. I have followed all instructions as far as I can tell. I have installed the mysql database driver/connector.

I seem to be specifically running into issues initialising the mysql database:
# nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 2.2.8 Build 9514 (2.2.8 ) (UNICODE)

Initializing database...
SQL query failed (Table 'metadata' already exists):
CREATE TABLE metadata (   var_name varchar(63) not null,   var_value varchar(255) not null,   PRIMARY KEY(var_name) )
Database initialization failed


When running netxmsd -f, I get:

2018.09.02 22:06:06.833 *E* Unable to get database schema version

I have tried remaking the netxms database and also importing dbinit_mysql.sql into the db directly.

Any ideas what I am doing wrong? Thanks.
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6584
    • View Profile
Re: Trouble installing/initialising db on Ubuntu 16.04 xenial
« Reply #1 on: September 03, 2018, 03:50:05 pm »

Hi,

Error message "Table 'metadata' already exists" suggests that you are trying to initialize same database after unsuccessful initialization attempt, so it is not possible to determine root cause. Please drop existing database, create a new one, run nxdbmgr init once, and post it's output.

Best regards,
Victor
Logged