NetXMS Support Forum

To use "nxdbmgr migrate", you need to do a few preparation steps:

1) Create a copy of existing netxmsd.conf, I'll name it "netxmsd_old.conf" in this example
2) Create new database
3) Init with initial schema: nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql
Please note, that there are different files for different database types, in this example - "dbinit_pgsql.sql" is for PostgreSQL.
4) Adjust "netxmsd.conf" - change DBDriver, DBName, etc. to match new database
5) (optional) run "nxdbmgr check" to verify connectivity to new database
6) run "nxdbmgr migrate netxmsd_old.conf". This will load data from old database (using credentials in netxmsd_old.conf) and migrate it into new one (as configured in netxmsd.conf)

Hello.

Bundled DB engine is SQLite. You can try to export/reimport db into a new file (run in cmd.exe): echo ".dump" | sqlite3 c:\netxms\ database\netxms_db | sqlite3 c:\netxms\ database\netxms_db.new

sqlite3.exe can be downloaded here: http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080500.zip

This should produce a clean copy of the database in file netxms_db.new. Move original netxms_db tor backup and rename netxms_db.new to netxms_db.

I also highly recommend you to migrate to any other database engines, PostgreSQL is common and quite good choice - it's powerful, free and require just a little of the system resources in default configuration.

nxdbmgr can be used for migration (so you don't have to dump data and reimport it manually).

Если подвести курсор к объекту, появится тултип (первый скриншот)
Для каждого DCI на любой ноде (или в темплейте) можно включить опцию "Network Maps -> Show last value on network map" (второй скриншот)
Третий скриншот - пример ноды из первого скриншота, на которой я включил эту опцию на двух DCI

Сейчас IP есть только в tooltip-е (который кстати настраивается)

You need to create all required tables and load initial configuration. This can be done with "nxdbmgr init path_to_sql_file" command, for example:

nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql


You need to change path (/opt/netxms/share/netxms/sql/) to conform your installation, and please note, that file name is different for different database types:

AirAlk:~() $ ls -l /opt/netxms/share/netxms/sql/dbinit_*.sql
-rw-r--r--  1 alk  admin  120673 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_db2.sql
-rw-r--r--  1 alk  admin  119910 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_mssql.sql
-rw-r--r--  1 alk  admin  112856 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_mysql.sql
-rw-r--r--  1 alk  admin  120498 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_oracle.sql
-rw-r--r--  1 alk  admin  117540 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_pgsql.sql
-rw-r--r--  1 alk  admin  118248 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_sqlite.sql


In your case, most likely command will be

nxdbmgr init /usr/share/netxms/sql/dbinit_sqlite.sql



NB! We strongly suggest not to use SQLite for anything than testing or development

Yes, it's known, low priority issue - it does not affect anything except scary record in log file (server tries to delete collected data for template itself - and fails, since idata_* tables are created only for nodes).

nxdbmgr unlock
nxdbmgr check

А какая версия джавы (я переделаю, что бы везде работало — но интересно)?
Как временное решение: java -Djava.io.tmpdir=/tmp/ -jar ...

В Tools -> Server Settings есть три параметра: SMTPServer, SMTPFromAddr и SNMPFromName
Для отсылки через gmail (или любой другой сервер, который требует авторизацию и/или шифрование), надо настроить локальный мейл сервер. Для UNIX систем инструкция ищется по словам "postfix smarthost gmail" (postfix заменить на используемый MTA). Для Windows систем я ставлю http://emailrelay.sourceforge.net/, маленький, но отлично работающий SMTP прокси, которые поддерживает и авторизацию и шифрование.

Quote from: Mainfin on May 23, 2014, 03:09:08 PM
Покажите, пожалуйста, еще как настроить e-mail нотификацию? Я нашел статью на wiki про нотификацию (How to send e-mail notification when disk space is low), но там нет не слова про настройку SMTP сервера. Я же могу использовать какой-нибудь gmail для отправки алармов?

gdb should print out stack trace.

Sample session:
AirAlk:~() $ gdb ./crashapp
GNU gdb 6.3.50-20050815 (Apple version gdb-1820) (Sat Jun 16 02:40:11 UTC 2012)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "x86_64-apple-darwin"...Reading symbols for shared libraries .. done

(gdb) run
Starting program: /Users/alk/crashapp
Reading symbols for shared libraries +.......................... done

Program received signal EXC_BAD_ACCESS, Could not access memory.
Reason: KERN_INVALID_ADDRESS at address: 0x0000000000000000
0x0000000100000f93 in main (argc=1, argv=0x7fff5fbff8d0) at crash.c:7
7   *p = 123;
(gdb) bt full
#0  0x0000000100000f93 in main (argc=1, argv=0x7fff5fbff8d0) at crash.c:7
p = 0x0
(gdb)


I'm interested in part starting with "Program received signal..."

Hello.

Please provide backtrace of the crash. There are two options:

1) If "core" file is generated, get stack trace directly from core:gdb /opt/netxms/bin/netxmsd core"
then inside gdb:bt[/bt]

2) Start netxmsd under gdb:
[code]gdb /opt/netxms/bin/netxmsd

Then on GDB prompt, type (everything after run is parameters for netxmsd):run -c /opt/netxms/etc/netxmsd.conf -D0

When server crashed, type "bt" on gdb prompt to produce stack trace.

Quote from: Dani@M3T on May 19, 2014, 02:30:58 PM
I just upgraded my NetXMS Server from 2.1.13 (linux 64bit installed from sources). But the server crashes directly after start.

Note about Mikrotik support — it's already implemented and will be included in upcoming 1.2.14

Do you need to trigger on any change, or just some predefined list of software products?

Скорее всего проблема связана с тем, что в транзакции пересоздается большое количество таблиц (tdata_*), а PG делает при этом exclusive lock до конца транзакции. При большом количестве устройств или специфической настройке PG, локов может не хватать. Попробуйте увеличить значение max_locks_per_transaction в postgresql.conf (нужно только на время апгрейда).

Вопрос — сколько у вас устройств в системе?

Right now there are no proper way to do that. It's probably possible to make transformation script for the table, which will iterate over all rows, compare with previous value and and post events directly in circumvention of the threshold mechanism, but it will be quite a hack.
Right now I'd write a standalone script or application, which process records from tdata_* tables and then post events, either using "nxevent" command line tool or via Java/Jython API.