NetXMS Support Forum

Quote from: DanG on February 13, 2012, 02:25:06 PM
- Reports is still not working for me: Execute works, however when I try to render the result to PDF I receive the following error:
   'Rendering report' has encountered a problem. Cannot render report xxx job y: Input/Output error

I've fixed couple more issues with reporting, it will be included in 1.1.11.
In a meantime, please check couple of things:
1) netxmsd started with full path to netxmsd.conf (e.g. "netxmsd -c c:\netxms\etc\netxmsd.conf", not something like "netxmsd -c ..\etc\netxmsd.conf")
2) "JavaPath" parameter in netmxsd.conf should point to java executable (e.g. "JavaPath=C:\Java\jdk1.6.0_17.x86\bin\java.exe")
3) "JDBCDriver" should be set to appropriate driver (e.g. "JDBCDriver=org.postgresql.Driver"). Currently supported: org.postgresql.Driver, com.ibm.db2.jcc.DB2Driver, com.microsoft.sqlserver.jdbc.SQLServerDriver, com.mysql.jdbc.Driver and oracle.jdbc.OracleDriver.
4) "JDBCUrl" is set to proper jdbc connection string (e.g. "JDBCUrl=jdbc:postgresql://localhost/netxms")
5) "report-generator.jar" is in directory specified by "JavaLibraryDirectory" parameter. Default location (for windows build) is "c:\netxms\lib\java\"

Отчеты сейчас требуют дополнительных шагов:

1) Скачать https://netxms.org/report-generator.jar (или собрать из trunk/src/java/report-generator/) и положить в любой каталог (в этом примере — /opt/netxms/java-lib/)
2) Добавить в конфиг примерно такое:JavaPath=/usr/bin/java
JavaLibraryDirectory=/opt/netxms/java-lib
JDBCDriver=org.postgresql.Driver
JDBCUrl=jdbc:postgresql://localhost/netxms

Логин/пароль используется из DBLogin/DBPassword.

Hi

I have no real experience with OpenDMK, but did a quick test and seems that integration should be like this:

1) make MIB file
2) generate java stubs using mibgen
3) implement these stubs to return real data
4) copy MIB file to ${prefix}/share/netxms/mibs (c:\NetXMS\var\mibs on Windows)
5) recompile all NetXMS MIBs:nxmibc -d /usr/share/netxms/mibs -o /usr/share/netxms/mibs/netxms.mib
6) restart management console, it should download updated netxms.mib from server
7) add your server to NetXMS
8) configure DCIs (set source to "SNMP Agent")

Check that netxmsd is not running, then run "nxdbmgr check", this will remove stale lock and also check database integrity.

Да, установка с DESTDIR была поломана некоторое время назад.
/trunk уже поправлен, 1.1.7 должен уже ставиться нормально.

Это старая проблема MySQL с utf-8, баг висит с 2004 года (http://bugs.mysql.com/bug.php?id=4541).

Можно попробовать так:

CREATE TABLE images
(
   guid varchar(36) not null,
   name varchar(255) not null,
   category varchar(255) not null,
   mimetype varchar(32) not null,
   protected integer default 0,
   PRIMARY KEY(guid),
   UNIQUE(`name`(165), `category`(165))
)

В выводе ldd не видно libnetxms.so, что странно.
Проверьте sha1 библиотеки:alk@normandy:~/deb$ sha1sum /usr/lib/libnsm_linux.so.0.0.0
ab272c256ffc9f88a1c85360ca9b02b09de18858  /usr/lib/libnsm_linux.so.0.0.0

Если sha1 отличается, то удалите все следы из системы и попробуйте поставить с нуля:

apt-get purge netxms-agent netxms-base
rm -i /usr/lib/libnxsqlite.so* /usr/lib/libnetxms.so* /usr/lib/libnsm_* /usr/lib/libnxlp.so* /usr/bin/nxagentd /usr/bin/nxcptest



Проверьте, что символ есть в библиотеке:
alk@normandy:~/deb$ nm /usr/lib/libnetxms.so|grep AgentWriteDebugLog
000000000000c600 T _Z18AgentWriteDebugLogiPKcz
000000000000c5a0 T _Z19AgentWriteDebugLog2iPKcP13__va_list_tag

И используется именно он:
alk@normandy:~/deb$ nm /usr/lib/libnsm_linux.so|grep AgentWriteDebugLog
                 U _Z18AgentWriteDebugLogiPKcz


My bad, it should be https://netxms.org/report-generator.jar (or you can build it from svn: https://svn.netxms.org/public/netxms/trunk/src/java/report-generator)

I don't have MSSQL available right not to test, but connection string should be like jdbc:microsoft:sqlserver://server_name:port/dbname. Port (including colon) is optional, default value is 1433.

Also set JDBCDriver to "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Hi.

You can get this list from DB using following query:
SELECT
    interfaces.ip_addr AS interfaces_ip_addr,
    interfaces.ip_netmask AS interfaces_ip_netmask,
    object_properties.name AS object_properties_name,
    interfaces.node_id AS interfaces_node_id
FROM
    object_properties
INNER JOIN
interfaces
ON
object_properties.object_id = interfaces.node_id
ORDER BY
interfaces_node_id, interfaces_ip_addr

I've also made a simple report for that, it's available in svn: http://svn.netxms.org/public/netxms/trunk/reports/IP%20Inventory.jrxml

To run it you need to setup your netxms server first:
1) download https://netxms.org/report-generator.jar and put it into server's DataDirectory (default values are c:\NetXMS\var on Windows and $prefix/share/netxms/ on UNIX)
2) add following parameters to netxmsd.conf:JavaPath=/usr/bin/java
JDBCDriver=org.postgresql.Driver
JDBCUrl=jdbc:postgresql://localhost/netxms

After that you could import report definition in management console by right click on "Reports" in the object browser and selecting "New Report"

Sorry for delayed answer; I've just fixed RSS feed.

Quote from: tops on July 08, 2011, 11:59:13 AM
Hi.
Maybe a dumb question, but where do i find DCI properties dialog?

Right click on an object in object browser → Data Collection → double click on DCI

Right now "CreateCrashDumps" is Windows only parameter.
You can run server under gdb:gdb /path/to/netxmsd
Then in GDB prompt:(gdb) run -c /path/to/netxmsd.conf -D3

When it crash, do thread apply all bt

You can use msmtp (http://msmtp.sourceforge.net/) instead of built-in smtp sender.

1) Control Panel -> Server Configuraration:
set "SMTPServer" to yout SMTP server IP

2) Control Panel -> Actions:
Right click -> New.
Set options as shown on attached image (email_action.png)

3) Control Panel -> Event Processing Policy:
Find rule for SYS_NODE_DOWN event, right click on "Action" field and add action you've created in previous step.
EPP should be like shown on attached image (epp.png)

Какое количество открытых сокетов, когда перестает работать icmp в NetXMS?

for f in /proc/net/{tcp,udp,raw}; do wc -l $f ; done