NetXMS Support Forum

I just build new test server with fresh PostgreSQL database, and everything seems to work. My DB settings are like yours:

root@debian7-x64:~/netxms# psql -h 127.0.0.1 -U netxms
Password for user netxms:
psql (9.1.11)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

netxms=> \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
netxms    | netxms   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(4 rows)

netxms=>

I enter characters with umlauts in few different places (see screenshot).

Are you sure you didn't make any mistake when installing unicode version? Also, can you check how these texts really stored in database (for example, in actions table)?

Best regards,
Victor

Hi!

What is your database settings? It is recommended to use UTF-8 encoding in PostgreSQL.

Best regards,
Victor

Hi!

You can just recompile server with UNICODE support and connect to same database. It should work just fine.

Best regards,
Victor

When you set time interval in dashboard graph properties, if it's set to "1 minute" it means "for last one minute", not "every minute". If you had setting like this, then you actually request data for last one minute, and collecting data once per minute you only got one data point in that interval - so no line was drawn.

Best regards,
Victor

Very strange. Still seems to be network problem to me, but I have to know more about actual network topology. You can contact me directly if you wish to continue debugging and don't want to share this information on the forum.

Best regards,
Victor

From screenshot it looks like chart for 1 minute (19:54:50 to 19:55:50). Is it really what you want to display? If yes, are you sure you collect data often enough?

Best regards,
Victor

Hi!

System will generate events in case anything goes wrong with the node - you can handle these events and create alarms, send notifications, etc. Most important events are following:

SYS_NODE_DOWN - entire node is down (NetXMS server cannot communicate using any allowed means)
SYS_NODE_UNREACHABLE - NetXMS server cannot communicate with the node because of intermediate router failure
SYS_NODE_UNMANAGED - someone put node into unmanaged state
SYS_NODE_UNKNOWN - status of the node is unknown
SYS_IF_DOWN - network interface is down
SYS_IF_UNKNOWN - status if network interface is unknown (usually because of disconnected agent)
SYS_IF_DISABLED - network interface was disabled
SYS_SERVICE_DOWN - network service is down
SYS_SERVICE_UNKNOWN - network service state cannot be determined (usually because of agent failure)
SYS_AGENT_UNREACHABLE - NetXMS agent is unreachable
SYS_SNMP_UNREACHABLE - SNMP agent is unreachable
SYS_DCI_UNSUPPORTED - DCI goes to "unsupported" state
SYS_SCRIPT_ERROR - NXSL script execution error
SYS_SMTP_FAILURE - server was unable to sent e-mail notification
SYS_SMS_FAILURE - server was unable to sent SMS notification

Best regards,
Victor

Добавил новый атрибут "driver" - будет доступен после обновления на 1.2.11.

From configuration poll it seems that you connected some Cisco router, not Windows machine with agent. Either you made some mistake or I didn't understand initial question correctly.

Best regards,
Victor

Hi!

Actually looks like a bug. I'll check it a bit later.

Best regards,
Victor

Hi!

Yes, you can use either ODBCquery or dbquery subagent to execute SQL queries periodically. ODBCquery subagent description is here: http://wiki.netxms.org/wiki/Subagent:ODBCQuery.

For DBquery, agent configuration file can be like this:


# standard stuff here ...
SubAgent = dbquery.nsm

*DBQUERY
Database = id=db1;driver=mysql.ddr;server=127.0.0.1;dbname=mydb;login=user;password=pass


Then to get number of records in table t1, you can use parameter

DB.Query(db1,"SELECT count(*) FROM t1")

Please note that DBquery is a new subagent intended to replace ODBCquery, but it's not 100% ready yet.

Best regards,
Victor

From the log I can see that agent does not receive connection from server. This can be firewall or routing problem. Can you telnet to port 4700 on problematic machine?

Best regards,
Victor

Hi!

Try to run agent with debug level 9:

nxagentd -D9

run configuration poll for that node and see what happens on agent.

Best regards,
Victor

Can you also post results of configuration poll (right click on node, then Poll -> Configuration)? I suppose that for some reason server cannot communicate with agent (maybe firewall in between or on target node?).

Best regards,
Victor

Hi!

Most correct way would be to add IPMI support to NetXMS server, so it can query IPMI directly and allow easy configuration of IPMI based DCIs. I'll check if this will require significant development effort.

Best regards,
Victor