NetXMS Support Forum

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