SQLite database issues
-
Are there any known issues with 2.0.1 and sqlite ? I constantly get "Your database has format version -1 but server is compiled for version 392" I have deleted the db and re initialzed it and also upgraded it and after I reboot I get the same error and have to do it all over
-
Works for me:
~/Development/netxms/netxms (develop↑1|…)% nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_sqlite.sql NetXMS Database Manager Version 2.0.2 Build 8060 (2.0.2-RELEASE-16-gf466c8f) (UNICODE) Initializing database... Database initialized successfully ~/Development/netxms/netxms (develop↑1|…)% nxdbmgr check NetXMS Database Manager Version 2.0.2 Build 8060 (2.0.2-RELEASE-16-gf466c8f) (UNICODE) Checking database (excluding collected data): * Checking zone objects... [PASSED] * Checking node objects... [PASSED] * Checking interface objects... [PASSED] * Checking network service objects... [PASSED] * Checking cluster objects... [PASSED] * Checking template to node mapping... [PASSED] * Checking object properties... [PASSED] * Checking event processing policy... [PASSED] * Checking network map links... [PASSED] * Checking data tables... [PASSED] Database doesn't contain any errors Database check completed ~/Development/netxms/netxms (develop↑1|…)% cat /opt/netxms/etc/netxmsd.conf LogFile=/tmp/netxmsd.log DBDriver=sqlite.ddr DBName=/tmp/netxmsd.dbHowever I highly recommend to use PostgreSQL or any other decent database engine instead of SQLite.
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