NetXMS 2.0-M1 released
-
-
I've made some changes in installer - hopefully it will help. Please try 2.0-M2 when it will be available.
Best regards,
Victor -
-
Nice catch!
Fixed, will be released in upcoming 2.0-M2.@volkoff said in NetXMS 2.0-M1 released:
Funny bug:
configuration parameter in nxagent ListenAddress actually read backwards.
So instead of 192.168.1.2 you should write 2.1.168.192 -
This one is much more serious:
I can't create or deleteย DCI.
History:
I tried to play with SNMP's table DCI, but wasn't successful. Later we'll get back to that
But I created one for the node (printer). And since that I can't create or delete DCI. Looks like after "sync" period something breaks, sync thread stops answering to watchdog and I can't connect with console.
So, my opinion - something is wrong in sync thread.
Error is 100% reproducible, so I can supply you with any kind of data.
DB is SQLite, Windows server 2008 R2, but since data is accumulated correctly I do believe something is wrong in sync thread (or with SQLite). -
@volkoff said in NetXMS 2.0-M1 released:
This one is much more serious:
I can't create or deleteย DCI.
History:
I tried to play with SNMP's table DCI, but wasn't successful. Later we'll get back to that
But I created one for the node (printer). And since that I can't create or delete DCI. Looks like after "sync" period something breaks, sync thread stops answering to watchdog and I can't connect with console.
So, my opinion - something is wrong in sync thread.
Error is 100% reproducible, so I can supply you with any kind of data.
DB is SQLite, Windows server 2008 R2, but since data is accumulated correctly I do believe something is wrong in sync thread (or with SQLite).DCI tables do not work with SQLite.
This is a known issue.
As a workaround for now, you can use a different DB.
-
@tomaskir said in NetXMS 2.0-M1 released:
DCI tables do not work with SQLite.
This is a known issue.
As a workaround for now, you can use a different DB.How terrible
I didn't know about that.
But as a guy who do some programming, I'm aware of the fact, that if there is some issue that prevents using of the product you should provide some bugfix rather than "it's a known issue" even for free and open source product
And since I have this particular bug isolated I can provide some (or even all in my case) data to fix it. -
Proper solution is to migrate to any sane DBMS โย you can do it using "nxdbmgr" tool, there is special "nxdbmgr migrate" mode.
SQLite never was intended for use in production environment, and we will probably remove support in future altogether.
Main reason for that โย a lot of features are not supported in SQLite (lack of ALTER TABLE DROP COLUMN is perfect example) or implemented poorly โย and while it's possible to add workarounds, it require time, which we prefer to spend on more critical tasks.@volkoff said in NetXMS 2.0-M1 released:
@tomaskir said in NetXMS 2.0-M1 released:
DCI tables do not work with SQLite.
This is a known issue.
As a workaround for now, you can use a different DB.How terrible
I didn't know about that.
But as a guy who do some programming, I'm aware of the fact, that if there is some issue that prevents using of the product you should provide some bugfix rather than "it's a known issue" even for free and open source product
And since I have this particular bug isolated I can provide some (or even all in my case) data to fix it. -
-
Migration process is really easy:
- stop server
- copy existing netxmsd.conf into netxmsd.conf.old
- create user and database in new DBMS
- edit netxmsd.conf โ change DBDriver and all other DB* parameters
- run "nxdbmgr migrate /etc/netxmsd.conf.old"
@volkoff said in NetXMS 2.0-M1 released:
@alk said in NetXMS 2.0-M1 released:
SQLite never was intended for use in production environment, and we will probably remove support in future altogether.
Well, that's the answer
Ok, I'll use other DBMS. -
@alk said in NetXMS 2.0-M1 released:
- stop server
- copy existing netxmsd.conf into netxmsd.conf.old
- create user and database in new DBMS
- edit netxmsd.conf โ change DBDriver and all other DB* parameters
- run "nxdbmgr migrate /etc/netxmsd.conf.old"
Well I used another step "3.5 - Initialize database", because migrate didn't work on empty database (said something about not detecting something (the same as check command on empty database), but anyway it didn't work out, since migration command breaks on syncronization of the first table "config" or something like that with error of SQL statement preparation.
So since it was clean installation and I didn't set up much DCIs so I just used new initialized MySQL database without migration.
If you need/want this SQLite database for some additional testing I can send it to you. -
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