Error on database upgrade
-
Hello,
I tried to upgrade from 2.27 to 2.30
When i try the nxdbmgr upgrade i get the following :C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 0.2.29Configuration file OK
Upgrading database...
Upgrading from version 93 to 94
Upgrading from version 94 to 95
Upgrading from version 95 to 96
SQL query failed (near "DROP": syntax error):
ALTER TABLE object_properties DROP COLUMN image_id
Rolling back last stage due to upgrade errors...
Database upgrade failedAnyone that can help me ? I searched the forum and found a new exe tried that too but doesn't work.
I also tried the -X option than the upgrade goes on after only 1 error... (shown above).NetXMS is than starting (service) but console can't connect (Time Out).
-
Hello!
What database you are using? Also, when starting netxmsd after nxdbmgr -X, what is in netxmsd log?
Best regards,
Victor -
C:\NetXMS\bin>netxmsd
Using configuration file "C:\NetXMS\etc\netxmsd.conf"
[16-Mar-2010 10:40:38] Database driver "sqlite.ddr" loaded and initialized successfully
[16-Mar-2010 10:40:39] Stalled database lock removed
[16-Mar-2010 10:40:40] SMS driver "generic.sms" initialization failed
[16-Mar-2010 10:40:42] NetXMS Server started
[16-Mar-2010 10:40:42] Unable to bind socket to port 162 in function SNMPTrapReceiver: Only one usage of each socket address (protocol/network address/port) is normally permitted.
[16-Mar-2010 10:40:42] Unable to bind socket to port 58942 in function LocalAdminListener: Only one usage of each socket address (protocol/network address/port) is normally permitted.
[16-Mar-2010 10:40:42] Unable to bind socket to port 4701 in function ClientListener: Only one usage of each socket address (protocol/network address/port) is normally permitted.NetXMS Server V1.0.0-rc2 Ready
Enter "help" for command list or "down" for server shutdown
System Console -
-
Yes, you can use 1.0.0-rc2 - so far only few minor issues was reported, and most likely it will become 1.0.0 release with only minor fixes.
Best regards,
Victor
everything is up and running again.Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login