Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - MartinR

#1
Hi Victor,
it seems that any newly detected device will not be put into the database. In the Eventlog there ist following error message repeating:

---8<----

SQL query failed (Query = "INSERT INTO nodes (primary_ip,primary_name,snmp_port,node_flags,snmp_version,community,status_poll_type,agent_port,auth_method,secret,snmp_oid,uname,agent_version,platform_name,poller_node_id,zone_guid,proxy_node,snmp_proxy,icmp_proxy,required_polls,use_ifxtable,usm_auth_password,usm_priv_password,usm_methods,snmp_sys_name,bridge_base_addr,down_since,driver_name,rack_image_front,rack_position,rack_height,rack_id,boot_time,agent_cache_mode,snmp_sys_contact,snmp_sys_location,last_agent_comm_time,syslog_msg_count,snmp_trap_count,node_type,node_subtype,ssh_login,ssh_password,ssh_proxy,chassis_id,port_rows,port_numbering_scheme,agent_comp_mode,tunnel_id,lldp_id,fail_time_snmp,fail_time_agent,runtime_flags,rack_orientation,rack_image_rear,agent_id,agent_cert_subject,hypervisor_type,hypervisor_info,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): table nodes has no column named rack_image_front

--->8---

During runtime the devices could be treated normally, but after a Restart of the Netxms Server they are all vanished. I assume because they where never in the database.
I suppose somewhere in the Migration path the additional Column "rack_image_front" is not added correctly. Also the table check of nxdbmgr claims all ok, even if this column is missed. I think this should be fixed.

Meanwhile I set up a completely new instance of Netxms and it is now working as expected. Due to all Devices where missed either, it was not worth to repair the old database.

I use SQLite database. In the Version before it was mariaDB.

Thank you for your help and sorry for the late answer.

Best Regards
Martin
#2
Hi guys,
my main Problem is, that the database Forgets all devices each time the Netxms Server Service starts.
I use Version 2.2.8, upgraded from 2.2.7, upgraded from 2.0.M2 in a Windows Environment with around 150 devices to monitor with MariaDB.
All Upgrades seem to work.
The Problem exists from 2.2.7 and is not fixed by upgrade.

The eventlog showed many db Errors, there were many links, which did not match.

I ran nxdbmgr check, which found many Errors. I let it fix them all.
I ran nxdbmgr check-data-tables and let it fix one error.

-> devices already do not survive a Restart of the netxms Server Service.
-> eventlog Shows an error "table nodes has no column named rack_image_front"

I suppose a Problem in nxdbmgr in this Version, which does not check this table correctly.

Now I wanted to create a new install with a new database. The Setup created an empty database file and the Service won't start.
I suppose another Problem with the Setup, which does not create a new database correctly.

What can I do now?

Thank you for your help.
Regards
Martin
#3
Hi,
many thanks for this hint. The line

Device = 0:ANY:USB

connects successfully to the APC Back-UPS CS650.
I recommend an output in a higher Debuglevel, which serial number the agent detects in this case. I tried different numbers but with any number instead of ANY the connection fails.
Nevertheless, my problem is solved, now.
Thank you for your help
Martin
#4
General Support / Re: Alert Sound?
June 28, 2013, 02:04:26 PM
Hi,
I did not need it so far. But I would try to define an Action which Executes a command on management server, which calls a suitable program that makes the noise.
Best Regards
Martin
#5
Hi,
I have to connect an ups to an agent machine.
With serial attached ups it works fine.
I need more detailed information for USB-attached ups.

http://wiki.netxms.org/wiki/Uninterruptible_Power_Supply_(UPS)_Monitoring
says I need a line like following:

Device = 0:<UPS serial number>:USB

What exactly is meant with <UPS serial number>?
Thank you for your help
Best Regards
Martin
#6
Hi,
now the penny dropped.
The agent reacts now as expected.

Thank you very much for your help

Best Regards
Martin
#7
Hi,
I now tried different versions of the Agent's action line.

%a shutthisdown
<name_of_machine> shutthisdown
<IP-Address> shutthisdown
nxaction <name_of_machine> shutthisdown

I assumed that "Agent's action" means of course the agent that initiates the action.

Can you please give me an example for a line that executes a command on the agent that causes the action (maybe with %a or %n)? The penny has not dropped yet.
Thank you for your help.
Best Regards
Martin
#8
Hi Victor,
action definition and processing rules are attached.
I defined two actions in this processing rule. The mail as second action will be sent as expected.
The shutdown initiated with the shutdown button of the Object Details View of the client works as expected, too.
nxaction command line tool executes the action correctly (as expected).
Thank you for your help.
Best Regards
Martin
#9
Oh, sorry.
I should tell you some versions:
Server and Agent are running in W2k3R2
I use the actual netxms version 1.2.7
The notification of the ups works fine on that agent.

Thank you for help.

Martin
#10
Hi there, after hours of googling I hope to get help here.
I just want to execute a command on the agent's computer, but it still ignores it.
- I successfully configured an alarm with somehow action (send an E-mail).
- I additionally configured an Agent's action named 'shutthisdown' and configured it to the same alarm, which sends the email.
- examined the log file, but I can not find an entry about any command to execute.
Only wevtapi.dll was not found.

Here is the Agent config file:

--8<--
#
# NetXMS agent configuration file
# Created by agent installer at Tue Jun 25 10:47:56 2013
#

DebugLevel = 9
Controlservers = netxms.lorenz-messtechnik.local
MasterServers = netxms.lorenz-messtechnik.local
ConfigIncludeDir = C:\NetXMS\etc\nxagentd.conf.d
#LogFile = {syslog}
LogFile = C:\NetXMS\debuglog.txt
FileStore = C:\NetXMS\var
SubAgent = ecs.nsm
SubAgent = ping.nsm
SubAgent = logwatch.nsm
SubAgent = portcheck.nsm
SubAgent = winperf.nsm
# Action= shutthisdown:cmd.exe /c "shutdown /s /t 180 /f"
Action= shutthisdown:cmd.exe /c "dir c:\ > c:\1.txt"
SubAgent = wmi.nsm
SubAgent = ups.nsm

# UPS subagent configuration section
*UPS
Device = 0:"COM2:":APC
-->8--

Many thanks for your help

Martin