NetXMS Support Forum

From directory name I assume it's installed by hand. Most likely it will work if you create nxmc.properties in /usr/local/tomcat7/lib/ (next to "catalina.jar", etc.)

Nothing is set in stone yet, but we want to release 2.0 in August. RC1 is scheduled for mid-July.

What servlet container you are using? Tomcat, Jetty, Winston? Is is installed from package?

Server installer is not affected – problem was because of missing sqlite.ddr, which is included in server package.

Most  likely you don't need it – and it should be completely disabled after upgrade, system should behave exactly as before. However, if for some reason (bug in upgrade procedure, most likely) it's on – server may stop collecting data from older agents (this will be fixed in next release).

Caching is intended for use on unreliable links. When server connects to the agent, complete DCI schedule for this node is sent, then agent collects data on it's own (and keep it in local database, hence new sqlite dependency). When connection is restored, all collected data is sent to server and then processed. Caching can be set globally (not recommended in this release), per node, or per DCI.

If DCIs are not collected, please check cache mode setting, it can be set in two places:
1) Global parameter DefaultAgentCacheMode, 1 is on, 2 is off. Check that with "nxdbmget get DefaultAgentCacheMode" or in server settings.
2) Cache mode on the node and DCIs – in node properties and in DCI properties respectively

You can download missing sqlite.ddr (both 32 and 64bit versions) here: https://www.dropbox.com/s/to6n0azk3j6qxui/sqlite.zip?dl=0
We will repack installer shortly.

For crashing agents, please add these options to config file and then send us minidump:
CreateCrashDumps = yes
DumpDirectory = c:\path

Native MSSQL driver is windows only, you'll have to use unixODBC.

Install unixODBC-devel package to fix this error.

For 2.x branch you need at least Tomcat7 (Servlet API 3.0) running on JRE7 or newer.

Ну и самое простое (если записи только добавляются) – delta по max:select count(*) from t1

В данных, которые лежат в таблице – в них есть время добавления записи?

Я бы возвращал время последней записи в виде unix timestamp (количество секунд) и потом сделал бы threshold с функцией delta.

Что-то типа:select extract(epoch from record_timestamp) from ... where ... order by record_timestamp desc limit 1

Запрос можно выполнять через DBQuery субагент: https://www.netxms.org/documentation/adminguide/subagents.html#dbquery

Package structure was changed in M3: https://www.netxms.org/forum/announcements/debian-packages-for-version-2-0-m3-and-up/.
Remove existing package (don't purge or you'll loose configuration files) and install two packages: "netxms-dbdrv-mysql " and "netxms-server".

Это сделано специально.
Если очень хочется – остановите сервер и поменяйте флаги в базе: update users set flags = flags|4 where id=0

А в Event Log что-то пишется?