Hi, I am installing NetXMS on Debian stretch, using MariaDB. The database installation is failing with the following error:
root@family:~# nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 2.2.1 Build 9502 (2.2.1) (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
root@family:~#
Hi,
we will fix it in release 2.2.2. As a workaround, edit file /usr/share/netxms/sql/dbinit_mysql.sql and change line
var_name varchar(255) not null
to
var_name varchar(63) not null
Best regards,
Victor