News:

We really need your input in this questionnaire

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Trab

#1
General Support / SQlite failing
December 24, 2008, 03:42:36 AM
I had everything up and running, but it only worked if I didn't use it as a daemon. as soon as I would kill the running program, everything would be lost.

I'm fairly certain this is a sqlite error. I'm wondering if there's a way to purge my sqlite database? my config may also be messed up for it...what database, username, and password am I supposed to use before I initialize?

here's the error thrown when I try and initalize:

[root@netxms log]# /usr/local/bin/nxdbmgr init /usr/local/share/netxms/sql/dbinit_sqlite.sql
NetXMS Database Manager Version 0.2.24

Configuration file OK
Initializing database...
SQL query failed (table config already exists):
CREATE TABLE config
(
var_name varchar(63) not null,
var_value varchar(255) not null,
is_visible integer not null default 1,
need_server_restart integer not null default 0,
PRIMARY KEY(var_name)
)
Database initialization failed