SQlite failing

[Trab]

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

[victor]

Hello!

You can purge your SQLite database simply by deleting database file. Look at your netxmsd.conf, in case of SQLite parameter DBName will contain database file name. Delete this file and run nxdbmgr init - you will get fresh database.

Best regards,
Victor

[Goriem]

@victor said in SQlite failing:

Hello!

You can purge your SQLite database simply by deleting database file. Look at your netxmsd.conf, in case of SQLite parameter DBName will contain database file name. Delete this file and run nxdbmgr init - you will get fresh database.

Best regards,
Victor

One question regarding purging af database as im haveing insert into talbe problems, does purging delete all configuration or just history?

[victor]

If you clear your database you will delete everything - configuration, collected data, etc. What kind of problems do you have?

Best regards,
Victor

[Goriem]

In event browser i see this:

severity: Critical

Event: SYS_DB_QUERY_FAILED

Message: Database query failed (Query: INSERT INTO object_properties (object_id,name,status,is_deleted,i...

using SQLite

[victor]

Could you please post complete error message from server's log?

Best regards,
Victor

[lindeamon]

hi victor,

i have installed version 1.1.10 with sqlite on a windows 7 and i have the same problem too.
here is the event details

Faulting application name: netxmsd.exe, version: 0.0.0.0, time stamp: 0x4f33f8f3
Faulting module name: sqlite.ddr_unloaded, version: 0.0.0.0, time stamp: 0x4f33f89c
Exception code: 0xc0000005
Fault offset: 0x00651090
Faulting process id: 0x3dc
Faulting application start time: 0x01ccf6086be09425
Faulting application path: C:\NetXMS\bin\netxmsd.exe
Faulting module path: sqlite.ddr
Report Id: 21522e1e-638a-11e1-8ead-001c25cb005c

best regards,
lindamon