Trouble installing/initialising db on Ubuntu 16.04 xenial
-
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 failedWhen running
netxmsd -f, I get:2018.09.02 22:06:06.833 *E* Unable to get database schema versionI 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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login