NetXMS Support Forum

Hi!

NetXMS by itself is working on Windows 7 (I do most of development and testing on Windows 7), but mssql database driver uses very old and deprecated API called DB-library, which may be incompatible with modern Windows versions. It will be removed in 1.1.x branch. For connecting to MS SQL, it is now recommended to use ODBC.

Best regards,
Victor

Ja podumaju chto eto mozet bit'. U menja sejchas net vremeni, smogu vecherom vnimatel'no etim zanjatsja. Esli vremja terpit, to podozdite otveta do zavtra.

Poprobuhte prosto udalit' etu zapis:
Delete from interfaces where id=17;
Delete from object_properties where object_id=17;

A kakoj rezul'tat dadut sledujuschie SQL zaprosi, esli ih vipolnit' iz mysql klienta:

SELECT name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,guid FROM object_properties WHERE object_id=17;

SELECT attr_name,attr_value FROM object_custom_attributes WHERE object_id=17;

Zapustite s debug level 9 - posmotrim kakie SQL zaprosi delajutsja i na chem vse obrivaetsja. Takze mozno poprobovat' zapustit' pod gdb.

By default, server check configuration of each node every hour - it's called "configuration poll". You can forcibly execute configuration poll by right-clicking node in console and then selecting Poll->Configuration. Or you can just wait one hour.

Best regards,
Victor

Hi!

Did you select component called "Microsoft SQL DB-Library" during installation? Also, you can try to use ODBC driver instead of mssql.

Best regards,
Victor

Default configuration file name is /etc/nxagentd.conf. There are configuration file example with comments in source package: contrib/nxagentd.conf-dist. You can copy it to /etc/nxagentd.conf and modify as needed, or use as reference. There are also startup scripts for various platforms under contrib/startup.

Best regards,
Victor

Hi!

I see that this is a bit confusing... You should get netxms-1.0.11.tar.gz (common source package), unpack it, and run

./configure --with-agent
make
make install

Best regards,
Victor

Hi!

APKG file is an installer script with embedded archive, which mostly intended for centralized agent upgrades. Generic UNIX package is a source package, and using it is equivalent to just get source .tar.gz archive, unpack it, and run

./configure --with-agent
make
make install

For Ubuntu you can use Debian packages (netxms-base_1.0.11_i386.deb and netxms-agent_1.0.11_i386.deb).
For CentOS/RHEL and others you have to compile agent from sources.

Best regards,
Victor

Hi all!

NetXMS version 1.0.11 is out. It's a bugfix release, which fixes few bugs in server and legacy management console.

Best regards,
Victor

Hi!

Yes, there is the limitation on script size of about 256KB, imposed by communication protocol. I'll fix that.

Best regards,
Victor

Popravil v 1.0.11.

You can try to execute the following SQL script to downgrade database:

DROP TABLE ap_common;
DROP TABLE ap_bindings;
DROP TABLE ap_config_files;
ALTER TABLE items DROP COLUMN system_tag;

ALTER TABLE users DROP COLUMN auth_failures;
ALTER TABLE users DROP COLUMN last_passwd_change;
ALTER TABLE users DROP COLUMN min_passwd_length;
ALTER TABLE users DROP COLUMN disabled_until;
ALTER TABLE users DROP COLUMN last_login;
ALTER TABLE users DROP COLUMN password_history;

DROP TABLE network_maps;
DROP TABLE network_map_elements;
DROP TABLE network_map_links;

UPDATE metadata SET var_value='105';

Best regards,
Victor

Hi!

There are no standard downgrade procedure. It is not safe to just change schema version. I'll take a look how to downgrade database manually.

Best regards,
Victor