NetXMS Support Forum

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

Debian 6 binaries available at https://www.netxms.org/apt/dists/squeeze/main/

Best regards,
Victor

Debian 6 binaries available at https://www.netxms.org/apt/dists/squeeze/main/

Best regards,
Victor

Version 1.2.12 build for Debian 7. I'll publish deb files for Debian 6 shortly.

Best regards,
Victor

Yes, NetXMS 1.2.12 built on Debian 7 (wheezy). I'll publish Debian 6 build shortly as it seems that there are still many Debian 6 installations.

Best regards,
Victor

Hi!

Try to add --disable-xmpp to configure as a workaround. I'll check what the problem is in the meantime.

Best regards,
Victor

Поставьте знак > перед IP адресом - тогда будут фильтроваться объекты с указанным IP, независимо от имени.

Я посмотрел MIB - там не используется какой-то стандартный формат:

A date-time specification.

            field  octets  contents                  range
            -----  ------  --------                  -----
              1      1-2   year*                     0..65536
              2       3    month                     1..12
              3       4    day                       1..31
              4       5    hour                      0..23
              5       6    minutes                   0..59
              6       7    seconds                   0..60
                           (use 60 for leap-second)
              7       8    deci-seconds              0..9
              8       9    direction from UTC        '+' / '-'
              9      10    hours from UTC*           0..13
             10      11    minutes from UTC          0..59

            * Notes:
            - the value of year is in network-byte order
            - daylight saving time in New Zealand is +13

Так что надо будет писать transformation script на эту колонку.