This is a Ubuntu 16.04 system, fully patched using the packages for installation. Running the command:
nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
Results in the following:
NetXMS Database Manager Version 2.1-RC1 Build 9010 (2.1-RC1) (UNICODE)
Initializing database...
SQL query failed (Specified key was too long; max key length is 767 bytes):
CREATE TABLE user_profiles ( user_id integer not null, var_name varchar(255) not null, var_value longtext not null, PRIMARY KEY(user_id,var_name) )
Database initialization failed
Suggestions on getting past this point?
Resolved this on my own, by specifying the character set on the DB create:
QuoteCREATE DATABASE netxms CHARACTER SET utf8;