SQlite failing

Started by Trab, December 24, 2008, 03:42:36 AM

Previous topic - Next topic

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 Kirhenshtein

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

Quote from: Victor Kirhenshtein on January 28, 2009, 01:08:37 PM
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 Kirhenshtein

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 Kirhenshtein

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