NetXMS installation with Sqlite

Started by shivpremani, December 22, 2010, 04:26:35 PM

Previous topic - Next topic

shivpremani

Hi,

While trying to install NetXMS on Solaris/RHEL, with Sqlite, when I start the NetXMS server, I was getting this error:
Database version -1, but server is compiled for version 105

However if initialise the database again with
#/usr/local/bin/nxdbmgr init /usr/local/share/netxms/sql/dbinit_sqlite.sql
and restart the server,
#/usr/local/bin/nxagentd -d
Its working fine.

Installation with Oracke and Mysql went smooth though...

Shiv


Victor Kirhenshtein

Hi!

Maybe I'm not understand correctly, but what do you mean by "install" on Solaris or RHEL? If you are installing NetXMS server on UNIX from sources (using make install), you are supposed to create netxmsd.conf and initialize database manually, "make install" command will not do that. Or you experience this problem even after running "nxdbmgr init" for the first time?

Best regards,
Victor

shivpremani

#2
Yes, I did install from src using make install, here are my steps:

#sh ./configure --with-server --with-sqlite --with-agent
#make
#make install
#cp contrib/netxmsd.conf-dist /etc/netxmsd.conf
#cp contrib/nxagentd.conf-dist /etc/nxagentd.conf

edit config file
vi /etc/netxmsd.conf
DBDriver = /usr/local/lib/libnxddr_sqlite.so
DBServer = localhost
DBName = netxms
DBLogin = netxms
DBPassword = netxms
LogFile = /var/log/netxmsd
LogFailedSQLQueries = yes

and start services
#/usr/local/bin/nxdbmgr init /usr/local/share/netxms/sql/dbinit_sqlite.sql
#/usr/local/bin/nxagentd -d


Victor Kirhenshtein

For SQLite, parameter DBName is database file name. So, if you specify just "netxms", it is relative to current directory. If you run netxmsd from different directory, it will pick wrong file. You should specify fully qualified file name in DBName.

Best regards,
Victor