NetXMS Support Forum

Poprobujte zapustit' server s kljucom -D 9 (togda budet pisat'sja mnogo debug informacii, vkljuchaja i sql zaprosi) i prislat' log servera pered vipolneniem etogo sql zaprosa (vkljuchaja i sam zapros).
I kakaja versija PostgreSQL i operacionki?

Ochen' stranno - vrode kak ispravlena uze eta oshibka. Sravnite pozalujsta fail src/server/core/netobj.cpp s prilozennim. Esli oni ne sovpadajut, zamenite na prilozennij i peresoberite server.

Sdelaju vecherom patch i vilozu. Spasibo

Viktor

Do you have any other program running which may communicate with UPS - agent form UPS vendor, Windows UPS service, etc.?

Best regards,
Victor

Very strange. Could you please run netxmsd under gdb, like this:


debian:~# gdb /opt/netxms/bin/netxmsd
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i486-linux-gnu"...
(gdb) run -D 5


and when it crashes, enter gdb command bt and post it's output?

Thank you for patience!

Best regards,
Victor

Hi!

Did you grant all privileges on netxms database to user 'netxms'?
Try to drop and re-create database. After that, run netxmsd in debug mode and post it's output.

Best regards,
Victor

Да, если пропали настройки, сделанные давно - это конечно к порядку остановки сервисов отношения не имеет. А что в логах сервера? Добавьте в netxmsd.conf строчку

LogFailedSQLQueries = yes

возможно какие-то SQL запросы не проходят.

Добрый день!

Если я правильно понимаю этот скрипт, при остановке сначала останавливается база данных, а уже потом netxmsd. Соответственно при выходе сервер может не записать какие-то данные из памяти, поскольку база уже остановлена. Правильная последовательность - дать SIGTERM процессу netxmsd, дождаться его завершения (в зависимости от ситуации это может занять какое-то время - до 30 секунд на больших базах), и только после этого останавливать базу.

Best regards,
Victor

Hi!

If you are connecting to localhost, you should grabt access to database in this way:

GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'PaSsWd';

Because MySQL threats localhost connections differently. (MySQL page where this behavior is explained: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html).

Best regards,
Victor

Hi!

Currently, --enable-unstable only enables ODBCQUERY subagent. If you ever need it, you will have to install UNIXODBC first, and then it should compile as well.

Best regards,
Victor

Hi!

Quote from: borislavl on February 06, 2010, 02:33:48 AM
1.Is there a better way for monitoring the 2 way connection between the NetXMS servers?

One possible alternative is to check remote port 4701 via portcheck subagent.

Quote from: borislavl on February 06, 2010, 02:33:48 AM
2.Is there performance issue if events (logging unchecked) are generated on short interval (i.e. 5 sec)?

Should not be. Event processing is usually very fast. Btw, it is one of the reasons why direct data collection not allowed in event processing policy's scripts.

Quote from: borislavl on February 06, 2010, 02:33:48 AM
3.What is the code in NXSL to access the last DCI?

What you mean by "last DCI"?

Quote from: borislavl on February 06, 2010, 02:33:48 AM
4.What is the code to access the last DCI collected timestamp?

It's not possible in 0.2.31. However, I have added new function GetDCIObject which returns reference to object containing all DCI's attributes, including last poll timestamp.

Quote from: borislavl on February 06, 2010, 02:33:48 AM
5.In DCI Transformation, using NXSL, can we use other other DCI value and based on both to return value (i.e. true or false), which to be used in the thresholds (to generate event).

Yes, you can access other DCIs values via FindDCIByName, FindDCIByDescription, and GetDCIValue functions. If you creating computed DCI, sometimes it can be useful to use Internal Dummy parameter as a source and read values of all relevant DCIs in transformation script.

Best regards,
Victor

P.S. Example of calculated DCI: https://www.netxms.org/forum/index.php/topic,289.0.html

You should pass device number you have specified in Device= parameter. For exasmple, if you have

Device = 0:ANY:USB

in your config, then you should use for example UPS.SerialNumber(0).
Could you please post your agent's config? Also, try to tun agent in debug mode (with -D switch) and see if there area additional UPS-related messages.

Best regards,
Victor

Hello!

How do you run ./configure? odbcsapi.cpp is a part of odbcquery subagent, which compiles only if --enable-unstable is set. Try to run configure without that switch.

Best regards,
Victor

No, the only requirement is that agent should be reachable by IP. Try to run remote agent in debug mode (nxagentd -D) to see if connections comes to agent. Don't forget that if NetXMS server is multihomed or there are NAT between server and agent, you may need to specify different IP address under MasterServers in agent's configuration file.

Best regards,
Victor

Yes, it's libnxsms_nxagent.so on Linux and nxagent.sms on Windows.

Best regards,
Victor