[SOLVED] 2.1RC1 MySQL Database Init Fails

[lweidig]

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?

[lweidig]

Resolved this on my own, by specifying the character set on the DB create:

CREATE DATABASE netxms CHARACTER SET utf8;