NetXMS Support Forum

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.

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