NetXMS Forum

@nets said in NetXMS server crash when triggering SMS action to multiple destinations:

Thanks. But i allready transfer server from Windows Server 2008R2 to Ubuntu 12.04 x64.

Now it works for 2 of 3 Numbers. I tried to add dummy numbers and it works but passes numbers through one. First-work Second-no Third-Work Fourth-Work ... etc. I think that need delay for send sms, becouse driver not send correctly multiple numbers on one time.

I'm not sure if this is a driver's fault, but could be. The most obvious guess is that your modem needs some time to process an sms and ignores subsequent AT commands for this period of time. Please post your log here (or PM me) and we'll try to figure this out.

@nets said in NetXMS server crash when triggering SMS action to multiple destinations:

how to make it?

SMSDrvConfig has the following format:

Device[,PortSpeed[,DataBits[,Parity[,StopBits[,Mode]]]]]

Where Mode is either P (PDU) or T (Text). PDU is on by default.

For example: /dev/ttyUSB0,9600,8,n,1,T will enable SMS driver to send texts in plain text mode.

Некоторое время назад из NetXMS внутренний веб-сервер был удален вообще. А документация немного отстала. Используйте TomCat или любой другой servlet container.

Can you run the agent with full debug enabled (-D 9) from a command line and check what does it say in the log.

Once the server tries to reach the agent you will see something like this in the agent log:

[06-Mar-2013 13:52:23.028] Incoming connection from 127.0.0.1

Then normally it would report that connection is accepted. Note that the IP address from the line above must match one of the IPs you specify in the MasterServers. Hope this helps, if not then please post the log here.

Hi, all!

If you happen to have a linuxquestions.org account dont forget to vote for NetXMS in members choice awards Please be quick, just 2 days left before the voting closes! 

http://www.linuxquestions.org/questions/2012-linuxquestions-org-members-choice-awards-104/network-monitoring-application-of-the-year-4175441862/

This is useful in scripts. If you want to map say country codes to country names or translate some obscure ids to more sensible text representations etc. There is a new NXSL function map(table, key) which returns the value which corresponds to "key". "table" is a name of mapping table.

@pcmaster said in Manual start discovery process:

What differences between server configuration variables "ActiveDiscoveryInterval" and "DiscoveryPollingInterval"?

There are two types of network discovery in NetXMS. One is a passive discovery, which periodically checks arp caches and routing tables of known nodes. Second one is an active discovery which scans one or more configured network ranges. ActiveDiscoveryInterval is responsible for active discovery periodicity and DiscoveryPollingInterval specifies passive. You should set ActiveDiscoveryInterval to a reasonably big value (hours or even days) for obvious network performance reasons.

Guys... Just a reminder or in case you are not aware. Please do not use SQLite for production. SQLite is not designed to handle big data volumes or a high DB load. Don't get me wrong, SQLite is still a great DB engine and does very well what its designed for. But it's just not up to the task for an average NetXMS production environment. Use NetXMS with SQLite for trying out, testing new features or if you monitor home network with 3 nodes But stay away from it in the production!!! You will be really better off with MySQL, Postgres or Oracle.

As for the topic. There is a fix for this specific problem committed yesterday. Well, actually this is a work around some obscure SQLite behaviour (see warning above!). It will go into 1.2.3. If you need it faster feel free to get it off the svn and test

Hi Peter,

Sorry for the late reply too!

Can you please post your full nxagentd.log from the agent run with -D 9. I'm particularly interested in what the agent reports when server asks parameters. Please run the agent,  request Oracle.DBInfo.Name() from the console and then copy the logfile.

Hi,

@prutser said in Subagent: oracle.nsm configuration.:

I really have no idea anymore what has to be changed to make this work. Any help is really appreciated!!

The Oracle subagent report unsupported parameter if the parameter cannot be read from the database. In 99% of cases this means that the database itself is inaccessible.

Please would you double-check that there is a correct TNS name is nxagentd.conf file. If yes then check if you can connect using the same TNS name from command line with sqlplus.

And btw, did you do this?

There is a new parameter in the Oracle subagent - Oracle.DBInfo.IsReachable. The new code is in the svn already and scheduled for 1.2.0 release later this month. Should you need this sooner please give me your agent platform details (OS, current agent version) I'll see if I can build the binary off the svn trunk for you.

Hi,

Strangely enough, now NetXMS can monitor quite a few Oracle DB parameters (such as number of open cursors, sessions, etc) but hasn't got a DCI just to tell whether an Oracle database is on or off. But this is planned for the next release though.

If this is an urgent matter for you please tell me which version and platform do you use and we can work something out.

Are you still getting "Unable to establish connection with database" message?

Please try the following:

1. Run cmd.exe, then set NLS_LANG environment variable to say AMERICAN_AMERICA.UTF8,
   then from the same window start netxmsd

2. If #1 doesn't help run cmd.exe and check if the Oracle environment variables are ok
   (ORACLE_HOME, PATH to Oracle binaries, TNS_ADMIN) - if not set them to proper
   locations

3. If #1 and #2 dont help and you're using Oracle instant client try to specify fully
   qualified TNS name instead of SID in DBServer parameter of netxmsd.conf
   Please see explanation here:
   http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html#A4428

Hope this helps

I assume that you have tested your connection to Oracle DB with some other tools (e.g. sqlplus) and everything is in order. The only problem you have is to get NetXMS to connect to DB. If this is not the case please test Oracle connectivity first.

There are two problems with your netxmsd.conf:

• For Oracle, DBServer parameter must be set to your Oracle SID, not the hostname. This is the main problem which prevents NetXMS from connecting to your database
• Setting DBLogin to system (Oracle's administrator username) is a very very very bad idea. NetXMS doesn't need admin rights and by using "system" you are not only giving it full admin rights but also cluttering system schema with absolutely foreign objects. Please create a separate username, assign "connect" and "resource" roles to it and you'll be fine.

The proper netxmsd.conf file looks like this:

# Driver - Oracle
DBDriver = oracle.ddr
# Oracle SID (check tnsnames.ora)
DBServer = ODB1
# Not used by NetXMS Oracle driver
DBName = netxms_db
# Oracle user name (schema)
DBLogin = NETXMS
# Oracle user password
DBPassword = NETXMS

Please post your netxmsd.conf

Enterprise Manager - не показатель имхо, я не знаю как он ходит в базу, но вполне возможно, что не через sqlnet. Для начала удостоверьтесь, что работает статндартная схема подключения - через, скажем, sqlplus. Запустите коммандную строку (cmd.exe), из нее:

sqlplus NETXMS/NETXMS@NXDB

 (естесно заменив на ваши параметры). Если sqlplus-ом подключиться удалось, то переходим к NetXMS:

1. Удаляем юзера и схему NETXMS (через тот же Enterpise Manager) и пересоздаем заново (на случай, если Configuration Wizard там уже что-то сделал). Ролей должно хватить CONNECT и RESOURCE, DBA ему не нужен.
2. Заполняем схему структурами и данными из командной строки:

nxdbmgr -c C:\netxmsd.conf init C:\NetXMS\lib\sql\dbinit_oracle.sql

3. Если nxdbmgr прошел успешно, пробуем запустить сервер в режиме отладки:

netxmsd -c C:\netxmsd.conf -D 9

4. Если сервер запустился и работает - все в порядке, если вышел, то постим лог сюда и пробуем разобраться 

У Oracle отличная от большинства других баз концепция организации данных. Базой называется совокупность физического хранилища (файлы, тейблспейсы) и процессов, обслуживающих это хранилище. Внутри одной базы живет множество пользователей и каждому выделяется свое место для хранения пользовательских структур - называется схема. Имея уже созданную при инсталяции Оракла базу вам надо просто создать новую схему (либо командой create user либо с помощью GUI тулов Оракла) и указать имя пользователя этой схемы и пароль. Вот как выглядит вырезка из netxmsd.conf :

# Driver - Oracle
DBDriver = oracle.ddr
# Oracle SID (check tnsnames.ora)
DBServer = ODB1
# Not used by NetXMS Oracle driver
DBName = netxms_db
# Oracle user name (schema)
DBLogin = NETXMS
# Oracle user password
DBPassword = NETXMS

И еще момент - лично у меня NetXMS на Оракле поднялся только после того, как я установил переменную окружения NLS_LANG - без нее драйвер законектиться не мог.