nxdbmgr.exe upgrade -x

[Moji]

Hello everybody.

                    I have install upgrade netxms form version netxms-1.0.13 to netxms-1.1.7.
        after install i can't log in to Netxms Consol.
     
                      I run command "nxdbmgr.exe check"
      ,have get result below
      NetXMS Database Manager Version 1.1.7
                      Checking database (excluding collected data):
                      Your database has format version 218, this tool is compiled for version 244.
                      Use "upgrade" command to upgrade your database first.
                      Database check aborted
       
        and I run upgrade database with command "nxdbmgr.exe upgrade -X"
        ,have get result below

        NetXMS Database Manager Version 1.1.7
        Upgrading database...
        Upgrading from version 218 to 219
        SQL query failed (Specified key was too long; max key length is 1000 bytes):
        CREATE TABLE images (  guid varchar(36) not null,  mimetype varchar(64) not null, name     
        varchar(255) not null,  category varchar(255) not null,  protected
        integer default 0,      PRIMARY KEY(guid),  UNIQUE(name, category))
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('1ddb76a3
        -a05f-4a42-acda-22021768feaf', 'image/png', 'ATM', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('b314cf44
        -b2aa-478e-b23a-73bc5bb9a624', 'image/png', 'HSM', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('904e7291
        -ee3f-41b7-8132-2bd29288ecc8', 'image/png', 'Node', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('f5214d16
        -1ab1-4577-bb21-063cfd45d7af', 'image/png', 'Printer', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('bacde727
        -b183-4e6c-8dca-ab024c88b999', 'image/png', 'Router', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('ba6ab507
        -f62d-4b8f-824c-ca9d46f22375', 'image/png', 'Server', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('092e4b35
        -4e7c-42df-b9b7-d5805bfac64e', 'image/png', 'Service', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('f9105c54
        -8dcf-483a-b387-b4587dfd3cba', 'image/png', 'Switch', 'Network Objects', 1)
        SQL query failed (Table 'netxms_db.images' doesn't exist):
        INSERT INTO images (guid, mimetype, name, category, protected) VALUES ('7cd999e9
        -fbe0-45c3-a695-f84523b3a50c', 'image/png', 'Unknown', 'Network Objects', 1)
        Upgrading from version 219 to 220
        Upgrading from version 220 to 221
        Upgrading from version 221 to 222
        Upgrading from version 222 to 223
        Upgrading from version 223 to 224
        Upgrading from version 224 to 225
        Upgrading from version 225 to 226
        Upgrading from version 226 to 227
        Upgrading from version 227 to 228
        Upgrading from version 228 to 229
        Upgrading from version 229 to 230
        Upgrading from version 230 to 231
        Upgrading from version 231 to 232
        Upgrading from version 232 to 238
        Upgrading from version 238 to 239
        Upgrading from version 239 to 240
        Upgrading from version 240 to 241
        Upgrading from version 241 to 242
        Upgrading from version 242 to 243
        Upgrading from version 243 to 244
        Database upgrade succeeded

I login to Netxms consol success but "Default Network map cannot load"  and "Cannot load image library: Database failure"

[victor]

Hi!

This caused by a known bug/limitation in MySQL. Until we create a workaround, you can upgrade database manually. If you have a backup of version 218, then you can:

1. Manually execute query

CREATE TABLE images (guid varchar(36) not null,   mimetype varchar(64) not null, name varchar(255) not null, category varchar(255) not null,   protected integer default 0,      PRIMARY KEY(guid));

2. Run nxdbmgr upgrade -X

To fix already upgraded database, manually execute the following queries:

CREATE TABLE images (guid varchar(36) not null,   mimetype varchar(64) not null, name varchar(255) not null, category varchar(255) not null,   protected integer default 0,      PRIMARY KEY(guid));

INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('092e4b35-4e7c-42df-b9b7-d5805bfac64e', 'Service', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('1ddb76a3-a05f-4a42-acda-22021768feaf', 'ATM', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('7cd999e9-fbe0-45c3-a695-f84523b3a50c', 'Unknown', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('904e7291-ee3f-41b7-8132-2bd29288ecc8', 'Node', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('b314cf44-b2aa-478e-b23a-73bc5bb9a624', 'HSM', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('ba6ab507-f62d-4b8f-824c-ca9d46f22375', 'Server', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('bacde727-b183-4e6c-8dca-ab024c88b999', 'Router', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('f5214d16-1ab1-4577-bb21-063cfd45d7af', 'Printer', 'Network Objects', 'image/png', 1);
INSERT INTO images (guid, name, category, mimetype, protected) VALUES
  ('f9105c54-8dcf-483a-b387-b4587dfd3cba', 'Switch', 'Network Objects', 'image/png', 1);

Best regards,
Victor

[Moji]

Thank you Victor , I fix already.

but I run "Default Network map " and found error  "cannot retrieve map list from server : Command not implemented"  ???  ???

Thank you so much.

[victor]

Network map format has been changed in 1.1.x branch and no longer supported in legacy Windows console. You should use Java console (nxmc) for work with 1.1.x server.

Best regards,
Victor