NetXMS Support Forum

There are two workarounds:
1. use built-in "admin" account - it always has all access rights;
2. Assign access rights directly in database. To do so, stop NetXMS server, then execute query like this:

UPDATE users SET system_access=system_access+134217728 WHERE id=insert_user_id_here

and start server.

Best regards,
Victor

Yes, seems like a bug. I'll fix it in 1.2.13 release.

Best regards,
Victor

Quote from: Dani@M3T on February 19, 2014, 10:18:56 PM
I just updated to V1.2.12 (on linux 64bit from sources). When I want to upload a new image to the Image Library, I get the error 'Access denied'. I checked then the user group for the new permission 'Manage Image Library', but there is no such item in the list (in java console). See attached printscreen.

Yes, seems that GUI update was forgotten. We will fix it in next patch release.

Best regards,
Victor

Hi!

You can drag tabs around using tab header. See this: https://www.netxms.org/documentation/userguide/management-console.html#rearranging-views

Best regards,
Victor

You have to install Oracle client manually because it's not an open source software and there are no package in Debian repository for it. I recommend using Instant Client (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html) version 11.2.0.4.0. Recommended location - /opt/instantclient_11_2.

Best regards,
Victor

Just for information - 1.2.12 available as wheezy build (on web site download page and at https://www.netxms.org/apt/dists/wheezy/main/) and as squeeze build (at https://www.netxms.org/apt/dists/squeeze/main/).

It should be like this. Attached is an example dashboard from my system showing line charts for different periods. Can you share a screenshot how it looks like on your system?

Best regards,
Victor

Yes. Drop all tables from database and then initialize it with command

nxdbmgr init c:\netxms\lib\sql\dbinit_mssql.sql

Best regards,
Victor

Hi!

Can you share a screenshot?

Best regards,
Victor

Hi!

Similar problem was reported on Russian forum as well. It seems that NetXMS syslog server cannot write incoming messages to database fast enough. I'll try to do load test in my lab and hopefully fix that.

Best regards,
Victor

Any help with documentation is very welcome You can edit manual in wiki (I'll move it to pdf then), or just create separate articles about how to configure things.

Best regards,
Victor

For Oracle you have to create database user manually (and this will create schema) and choose "existing database" option.

If you are using InstantClient you should specify Oracle connection string in DBServer parameter in form //server_ip/service_name

To do initialization manually, follow these steps:

1. Connect to Oracle server with sqlplus as sysdba:


C:\Source\NetXMS\x64\debug>sqlplus sys/admin@//192.168.64.3 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 19 11:41:37 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>


2. Create user and grant necessary rights:


SQL> create user netxms identified by netxms;

User created.

SQL> grant create session to netxms;

Grant succeeded.

SQL> grant resource to netxms;

Grant succeeded.

SQL> grant create view to netxms;

Grant succeeded.

SQL>


3. Set correct values in netxmsd.conf. In my case it will be


DBDriver = oracle.ddr
DBServer = //192.168.64.3/XE

DBLogin = netxms
DBPassword = netxms


4. Initialize database:


C:\Source\NetXMS\x64\debug>nxdbmgr init ..\..\sql\dbinit_oracle.sql
NetXMS Database Manager Version 1.2.12 Build 7861

Initializing database...
Database initialized successfully

C:\Source\NetXMS\x64\debug>


Also, it seems that initialization script shipped with NetXMS installer may contain errors and database initialization will fail with "cannot insert NULL" error. In that case, please use attached initialization script.

Best regards,
Victor

I think that rebuild database is easiest fix here.

Best regards,
Victor

Hi!

Looks like lot of data tables are missing. Is it new setup or errors appear after upgrade?

Best regards,
Victor

Hi!

Try to remove libstrophe.so* from previous version before build. Sometimes linker takes already installed library from installation prefix instead of freshly built in source tree.

Best regards,
Victor