NetXMS Support Forum

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


However I highly recommend to use PostgreSQL or any other decent database engine instead of SQLite.