NetXMS Forum

Hello, Victor!

I've read in manual about centralized agent upgrade feature, but I cannot find any reference to how exactly it can be done?
Also, it would be very helpful if such features as Agent Packages and Agent Configurations were documented.

I have installed server configured with: ./configure --with-server --with-agent --with-mysql
I do ./configure --with-server --with-agent --with-mysql --with-nxhttpd
make
killall netxmsd
killall nxagentd
make install
Then i try to start netxmsd:
test3:~/netxms-0.2.20 # netxmsd -D 9
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[17-Apr-2008 17:46:54] Unable to set codepage to ISO-8859-1
[17-Apr-2008 17:46:54] Platform subagent "/usr/local/lib/libnsm_linux.so" successfully loaded
[17-Apr-2008 17:46:54] Database driver "/usr/local/lib/libnxddr_mysql.so" loaded and initialized successfully
[17-Apr-2008 17:46:54] DEBUG: New DB connection opened: handle=0x617240
[17-Apr-2008 17:46:54] DEBUG: Successfully connected to database [email protected]
[17-Apr-2008 17:46:54] DEBUG: Failed sync query: "SELECT var_value FROM config WHERE var_name='DBFormatVersion'" [0 ms]
[17-Apr-2008 17:46:54] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name='DBFormatVersion'")
[17-Apr-2008 17:46:54] Your database has format version 0, but server is compiled for version 78

Then I do ./configure --with-server --with-agent --with-mysql
make
make install
and netxmsd starts without problems.

I have found AgentCommandTimeout parameter in server configuration. Modifying it to the correct time solves the problem. But now all agents have this big time-out and every other paramter I monitor at this node is now waiting for iostat to recieve a value, is there a way to configure this time-out only for some paramaters, so that others wouldn't wait for it? Any work-around is welcome.

Hello, Victor!

I want to monitor disk queue on remote PC, I've wrote script in bash that returns disk queue, but it takes 5 minutes for this script to return a value ( i used command: iostat -xd /dev/sda 300 2). I've modifed time-out's in nxagentd.conf for server to wait. While it works server keeps asking agent to return a value, in the end i have a plenty of iostat processes running, and no value is returned to server. How can i configure agent/server to wait 5 minutes and take a value from the script?

Hello, Victor!

I have such question: If I already installed NetXMS server with agent on some PC, how do I install nxhhtpd there?
Should I do ./configure --with-server --with-agent --with-mysql --with-nxhttpd ot just ./configure --with-nxhhtpd ?
I tried them both - and in first case NetXMS doesn't work any more, and in second case web interface does not accept passwords.
May be I am doing something wrong.. How to correctly install nxhttpd on server with NetXMS server?

Everything is ok now. The problem was in MySql.

@alk said in Database initialization problem.:

Looks like you have created tables in "mysql" databse. Try to "cat ... | mysql -u root -p netxms"

cat /usr/local/netxms/share/netxms/sql/dbinit_mysql.sql | mysql -u root -p netxms
Enter password:
ERROR 1050 (42S01) at line 1: Table 'config' already exists

As I said before:
But if I go in MySQL and manually do use netxms; SELECT var_value FROM config WHERE var_name='DBFormatVersion'; it returns:
+-----------+
| var_value |
+-----------+
| 78        |
+-----------+
1 row in set (0.00 sec)

I've tried to install previous version of NetXMS - result is the same.
As I understand for some reason netxms cannot read or write to database, why can this be?

Hello, Victor!

I was trying to reinstall NetXMS server, and as I did I was trying to re-initialize database:
/usr/local/netxms/bin/nxdbmgr init /usr/local/netxms/share/netxms/sql/dbinit_mysql.sql
NetXMS Database Manager Version 0.2.20

Configuration file OK
Initializing database...
SQL query failed:
CREATE TABLE config
(
 var_name varchar(63) not null,
 var_value varchar(255) not null,
 is_visible integer not null default 1,
 need_server_restart integer not null default 0,
 PRIMARY KEY(var_name)
)
Database initialization failed

Permissions for database schould be ok, because I defined in netxmsd.conf to connect as root.

Then I tried to initialize database manually, so I did: cat /usr/local/netxms/share/netxms/sql/dbinit_mysql.sql | mysql -u root -p
Tables were created, but then:

/usr/local/netxms/bin/netxmsd -D 9
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[16-Apr-2008 17:08:51] Unable to set codepage to ISO-8859-1
[16-Apr-2008 17:08:51] Platform subagent "/usr/local/netxms/lib/libnsm_linux.so" successfully loaded
[16-Apr-2008 17:08:51] Database driver "/usr/local/netxms/lib/libnxddr_mysql.so" loaded and initialized successfully
[16-Apr-2008 17:08:51] DEBUG: New DB connection opened: handle=0x617250
[16-Apr-2008 17:08:51] DEBUG: Successfully connected to database [email protected]
[16-Apr-2008 17:08:51] DEBUG: Failed sync query: "SELECT var_value FROM config WHERE var_name='DBFormatVersion'" [0 ms]
[16-Apr-2008 17:08:51] SQL query failed (Query = "SELECT var_value FROM config WHERE var_name='DBFormatVersion'")
[16-Apr-2008 17:08:51] Your database has format version 0, but server is compiled for version 78

But if I go in MySQL and manually do SELECT var_value FROM config WHERE var_name='DBFormatVersion' it returns:
+-----------+
| var_value |
+-----------+
| 78        |
+-----------+
1 row in set (0.00 sec)

I am using Mysql, during re-installation i dropped netxms database. I tried to install different versions of MySQL, and I tried to re-compile NetXMS server.

nxhttpd.conf:

DocumentRoot = /usr/local/share/netxms/nxhttpd
MasterServer = 127.0.0.1
LogFile = /var/log/nxhttpd
ListenPort=80
SessionTimeout=300

I am running Linux openSUSE 10.2 (X86-64)

Hello, Victor.

How can I allow NetXMS agent to restart or shutdown remote nodes? When I look at agent supported actions in console it returns only agent.restart.

Hello, Victor!

I've successfully installed NetXMS server, and I'm trying to install web interface (nxhttpd) on the same PC.
The installation was successful, but when I try to login in web console is says: Unable to login (Access denied).
I am sure that I use the correct username and password, I even tried to add some users in NetXMS console and to login as a new user, but still - Access Denied. I've reproduced this problem twice, and interesting that if I install nxhttpd on another PC, and configure it to connect to my NetXMS server - everything is fine. Here is log of nxhttpd:

Configuration file OK
[15-Apr-2008 11:36:55] NetXMS Web Interface Server started
NXHTTPD running. Press Ctrl+C to shutdown.
[15-Apr-2008 11:36:55] Debug: Session watchdog thread started
[15-Apr-2008 11:36:59] Debug: [302] GET /
[15-Apr-2008 11:37:00] Debug: [200] GET /login.app
[15-Apr-2008 11:37:04] Debug: [200] POST /login.app?&cmd=login&user=admin&pwd=&x=0&y=0
[15-Apr-2008 11:37:04] Debug: [200] GET /xmlextras.js
[15-Apr-2008 11:37:05] Debug: [200] GET /common.js
[15-Apr-2008 11:37:05] Debug: [200] GET /images/login.png
[15-Apr-2008 11:37:05] Debug: [200] GET /images/buttons/normal/login.png
[15-Apr-2008 11:37:05] Debug: [200] GET /netxms.css

How can I get into web console?

Here is config.log

config.log

Hello, Victor!
I am trying to compile netxms 0.2.20 witch odbc support. during compilation the system says:
odbc.cpp: In function 'void* DrvSelect(ODBCDRV_CONN*, WCHAR*, DWORD*)':
odbc.cpp:250: error: cannot convert 'const WCHAR*' to 'const wchar_t*' for argument '1' to 'wchar_t* wcsdup(const wchar_t*)'
odbc.cpp: In function 'LONG DrvGetFieldLength(ODBCDRV_QUERY_RESULT*, int, int)':
odbc.cpp:284: error: cannot convert 'WCHAR*' to 'const wchar_t*' for argument '1' to 'size_t wcslen(const wchar_t*)'
odbc.cpp: In function 'WCHAR* DrvGetField(ODBCDRV_QUERY_RESULT*, int, int, WCHAR*, int)':
odbc.cpp:304: error: cannot convert 'WCHAR*' to 'wchar_t*' for argument '1' to 'wchar_t* wcsncpy(wchar_t*, const wchar_t*, size_t)'
make[5]: *** [odbc.lo] Error 1
What can be the cause of this?

Interesting that netxms 0.2.19 compiles without problems.