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"
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
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.
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