error install netxms on debian 9 database

[lee]

Hello
I installed version 2.2.4 on Debian 9
There is a problem installing the database
By installing the following command, I installed the miradb installed
apt-get install mysql-server

I built the database with the following command
mysql -u root -p mysql
mysql> CREATE DATABASE netxms;
mysql> GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'netxms';
mysql> \q
And I also want to install the database with the following error that I encounter
root@debian:~# nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 2.2.4 Build 9506 (2.2.4) (UNICODE)

Initializing database...
SQL query failed (Specified key was too long; max key length is 767 bytes):
CREATE TABLE userdb_custom_attributes (  object_id integer not null,  attr_name varchar(255) not null,  attr_value longtext not null,  PRIMARY KEY(object_id,attr_name) )
Database initialization failed

The version number of the database used in my system is automatically installed with the above command

root@debian:~# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW VARIABLES LIKE "%version%";
+-------------------------+--------------------------+
| Variable_name          | Value                    |
+-------------------------+--------------------------+
| innodb_version          | 5.6.36-82.1              |
| protocol_version        | 10                      |
| slave_type_conversions  |                          |
| version                | 10.1.26-MariaDB-0+deb9u1 |
| version_comment        | Debian 9.1              |
| version_compile_machine | x86_64                  |
| version_compile_os      | debian-linux-gnu        |
| version_malloc_library  | system jemalloc          |
| version_ssl_library    | YaSSL 2.4.2              |
| wsrep_patch_version    | wsrep_25.19              |
+-------------------------+--------------------------+
10 rows in set (0.00 sec)

please guide me

[victor]

Hi,

I suppose it has something to do with selected database encoding, because it says that length of integer + varchar(255) key exceeds 767 bytes. As a workaround try to edit init script and reduce size of attr_name column in userdb_custom_attributes to 127 (you will not encounter any issues during server operation).

Best regards,
Victor