NetXMS Support Forum

Добрый день, такой вопрос.

Можно как нибудь используя функционал NetXms реализовать перезагрузку коммутаторов чере контекстное меню коммутатора по SNMP

проще говоря нужен функционал nxsnmpset через графическую консоль.

думается мне что нужно Action создать который на стороне сервера будет вызывать nxsnmpset и передавать ему нужные параметры

подскажите как это правильно сделать.

Добрый день,

Возникла такая проблема.

установлен netxms на виртуалке. Под Centos 5.5, все нормально работает .. но раз примерно в неделю в лог валится

[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:27:33] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:35:34] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:41:25] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:42:27] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:50:20] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:51:20] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:55:30] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:56:10] Unable to create raw socket for ICMP protocol
[27-Dec-2010 18:56:10] Unable to create raw socket for ICMP protocol


Все nodы помечаются как down и на этом все заканчивается.

куда копать ?

да ) все было из-за кодировки UTF 8, сейчас все в норме.

Проблема решилась достаточно просто но неочевидно.

Достаточно было базу сделать в cp1251 вместо UTF8 и в конфиге поменять CodePage c utf8 на cp1251.

Не дружит Netxms с utf8 )

Сегодня возник следующий вопрос.

-Netxmsd очень сильно грузит систему и mysql

top - 12:17:32 up  1:16,  2 users,  load average: 1.71, 1.67, 1.47
Tasks: 104 total,   2 running, 101 sleeping,   1 stopped,   0 zombie
Cpu(s): 54.6%us, 10.4%sy,  0.0%ni, 35.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   4117936k total,   197448k used,  3920488k free,    42456k buffers
Swap:  6377464k total,        0k used,  6377464k free,    71180k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
4455 root      20   0 88112 4044 2212 S     79  0.1  10:34.03 netxmsd
4270 mysql     20   0  127m  18m 5268 S   51  0.5   7:59.36 mysqld

непонятно чем вызывается такая параноидальная активность.

Логи мускула смотрел вроде нечего страшного, нетхмс пуляет ему в табличку eventlog и все..

в логах нетхмс следующее

SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521534,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521527,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521520,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521513,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521506,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521499,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521492,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521485,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521478,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[29-Oct-2009 12:27:47] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521535,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521528,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521521,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521514,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521507,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521500,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521493,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521486,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521479,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

старт нетхмс выглядит так:

/opt/netxms/bin/netxmsd -c /etc/netxmsd.conf
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[29-Oct-2009 12:32:15] Platform subagent "/opt/netxms/lib/libnsm_linux.so" successfully loaded
[29-Oct-2009 12:32:15] Database driver "/opt/netxms/lib/libnxddr_mysql.so" loaded and initialized successfully
[29-Oct-2009 12:32:15] Failed to load subnet object with id 13 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 18 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 23 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 28 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 12 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 17 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 22 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 27 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 14 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 19 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 24 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 29 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 10 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 11 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 15 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 16 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 20 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 21 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 25 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 26 from database
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e          xisting child object 25
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e          xisting child object 26
[29-Oct-2009 12:32:15] Listening for SNMP traps on UDP socket 0.0.0.0:162
[29-Oct-2009 12:32:15] NetXMS Server started

NetXMS Server V0.2.30 Ready
Enter "help" for command list or "down" for server shutdown
System Console

netxmsd: [29-Oct-2009 12:32:15] Listening for client connections on TCP socket 0.0.0.0:4701

конфиг нетхмс выглядит так

#
# Sample configuration file for NetXMS server
#

#
# DBDriver
#
# Database driver to use
#
# UNIX example:
DBDriver = /opt/netxms/lib/libnxddr_mysql.so
#
# Windows example:
# DBDriver = mysql.ddr

#
# DBServer
#
# Database server (ODBC source name for ODBC driver)
#
# Example:
DBServer = localhost

#
# DBName
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ?

#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ?

#
# DBPassword
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ?

#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ?

#
# DBPassword
#
# Database user's password
#
# Example:
DBPassword = ?

#
# LogFailedSQLQueries
#
# Controls logging of failed SQL queries.
# Possible values: "yes" (default) or "no".
#
# Example:
LogFailedSQLQueries = yes

#
# LogFile
#
# Server's log file. To write log to syslog (or Event Log on Windows),
# use {syslog} as file name.
#
# Examples:
# LogFile = {syslog}
LogFile = /var/log/netxmsd.log
CodePage = utf8



Что нибудь можете посоветовать?

это критичная ошибка для сервера или можно пока и так работать ?
Значит с базой все Ок?
Заранее спасибо.

Помогите, немогу понять причины следующего

1) -Ставлю сервер (0.2.30)
2) -Создаю базу, заполняю структуру
3) - Потом запускаю nxdbmgr check, все тесты проходит PASSED без проблем
4) - Запускаем сервер 1й раз netxmsd -c /etc/netxmsd.conf -d
5) - Потом делаем killall netxmsd
6) - запускаем nxdbmgr check и получаем следующее

NetXMS Database Manager Version 0.2.30

Configuration file OK
Checking database:
Missing node object 12 properties. Create? (Y/N) y
SQL query failed (Unknown column 'image_id' in 'field list'):
INSERT INTO object_properties (object_id,name,status,is_deleted,image_id,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds) VALUES (12,'lost_node_12',5,0,0,1,0,0,0,0,0,0,0,'00000000')
* Checking node objects...                                               [ERROR ]
* Checking interface objects...                                         [PASSED]
* Checking network service objects...                                [PASSED]
* Checking cluster objects...                                            [PASSED]
* Checking template to node mapping...                             [PASSED]
* Checking object properties...                                         [PASSED]
* Checking event processing policy...                                [PASSED]
* Checking collected data...                                            [PASSED]
1 errors was found, 0 errors was corrected
Database still contain errors
Database check completed

nxdbmgr исправить эти ошибки не в состоянии. И после каждого перезапуска ошибок все больше...
Непонимаю куда копать... Помогите.