@filipp-sudanov said in Oracle 26ai monitoring CDB and PDB´s with common user:
You can enquote the whole value:
Database = "id=CDB0;driver=oracle.ddr;server=//hostABC:1521/CDB0;login=c##netxms_agent;Password=mypassword"
Thank you Filipp. This was the missing hint. I tried to enqoute only username. Now it works like a charme. Thank you verry much!
Hi
My enviroment:
Database: Oracle 26ai with CDB and PDB´s.
NetXMS: Version 6.0
Subagent: Oracle.nsm
Subagent: dbquery.nsm
Im using common user with prefix c## to monitor the CDB via Oracle.nsm subagent. The prefix working well for CDB.
Now I tried to get data from PDB´s with this subagent. As example open_mode, etc.
I tried as second solution via dbquery.nsm (I use it for special select statements in oracle and this works with traditional Oracle DB´s (Instance based). Now i tried to get data like open_mode from PDB´s with dbquery.nsm. It seems that the agent does not support the "c##" user prefix. If I use it, the agent service will not start. If I try it on SQLDevelopment Studio it works. Is there a solution to use common accounts to monitor PDB´s?
This is how I tried the connection:
*DBQUERY
Database = id=CDB0;driver=oracle.ddr;server=//hostABC:1521/CDB0;login=c##netxms_agent;Password=mypassword
Query = Open_Mode_PDB1:CDB0:15:select open_mode from v$pdbs where NAME = 'PDB1'
--> This query works on Oracle SQL Develper.
How do you monitor your PDB´s without creating collection data for every PDB?
We using dataguard-manager with switchover and failover capability.
Thank you for any hint´s or suggestions.
Sincerly Lars
@victor said in java.util.ConcurrentModificationException nxmc-light.app:
Just fixed it, fix will be included into next patch release.
Best regards,
Victor
Working like a charme!
Thank you verry mucht Victor.
Greets Lars
@victor said in java.util.ConcurrentModificationException nxmc-light.app:
Are you using autologin to open dashboard or map in kiosk mode?
Best regards,
Victor
Yes. I will start Kiosk mode on a thin-client (Igel) with Chrome browser automatically.
Best regards,
Lars
Hey guys
I run into 500 error by using "autologin". It worked for about 2 weeks and now Im getting these error.
I updated to newest version 5.0.4.
Hi
I run into config problems with OneWire Sensor.
The subAgent is loading but always got the message:
2019.11.12 07:47:00.477 *W* Unable to add sensor from configuration file. Original configuration record:
2019.11.12 07:47:00.478 *I* Subagent "DS18X20" (ds18x20.nsm) loaded successfully (version 2.2.8)
The sensor is working and I got some temperatures from it:
:/sys/bus/w1/devices/28-0000022801e4# cat w1_slave
35 01 4b 46 7f ff 0b 10 31 : crc=31 YES
35 01 4b 46 7f ff 0b 10 31 t=19312
The config looks like this, but tried some other things more by try-and-error:
SubAgent = ds18x20.nsm
# 1Wire Seonsors
[DS18X20]
Sensor = Test:28-0000022801e4
Are there anybody who can provide a working "config" or has hints of that issue?
A higher debug level don´t tell me more informations about the config problem.
Thank you guys for your help!
Ok, I tell you "from unmanaged node". This is not correct. The node is in managed mode, only the interface is in unmanaged mode.
I think, there is no setting in server-config, because this is by default, that no traps are processed in unmanaged mode, isn´t it?
So there is no way to disable snmp-traps from managed node in case of unmanaged interfaces?
Hope you guys understand my description 
sincerly Lars
Hi
Im getting alarms from snmp traps of unmanaged nodes. After searching for solution, I found some threads about the server setting "ProcessTrapsFromUnmanagedNodes".
I´m running netxms 2.2.12.
This are the results for searching trap in server settings (see attached screenshot).
Any idea?
Kind regards Lars
Ok,
compiled nxagend from source. No rpi.nsm on my system.
What´s wrong?
locate *.nsm
/usr/lib/arm-linux-gnueabihf/netxms/dbquery.nsm
/usr/lib/arm-linux-gnueabihf/netxms/devemu.nsm
/usr/lib/arm-linux-gnueabihf/netxms/ds18x20.nsm
/usr/lib/arm-linux-gnueabihf/netxms/ecs.nsm
/usr/lib/arm-linux-gnueabihf/netxms/filemgr.nsm
/usr/lib/arm-linux-gnueabihf/netxms/gps.nsm
/usr/lib/arm-linux-gnueabihf/netxms/linux.nsm
/usr/lib/arm-linux-gnueabihf/netxms/lmsensors.nsm
/usr/lib/arm-linux-gnueabihf/netxms/logwatch.nsm
/usr/lib/arm-linux-gnueabihf/netxms/netsvc.nsm
/usr/lib/arm-linux-gnueabihf/netxms/ping.nsm
/usr/lib/arm-linux-gnueabihf/netxms/portcheck.nsm
/usr/lib/arm-linux-gnueabihf/netxms/sms.nsm
/usr/lib/arm-linux-gnueabihf/netxms/ssh.nsm
/usr/lib/arm-linux-gnueabihf/netxms/ups.nsm
/usr/local/lib/netxms/dbquery.nsm
/usr/local/lib/netxms/devemu.nsm
/usr/local/lib/netxms/ds18x20.nsm
/usr/local/lib/netxms/ecs.nsm
/usr/local/lib/netxms/filemgr.nsm
/usr/local/lib/netxms/gps.nsm
/usr/local/lib/netxms/linux.nsm
/usr/local/lib/netxms/logwatch.nsm
/usr/local/lib/netxms/netsvc.nsm
/usr/local/lib/netxms/ping.nsm
/usr/local/lib/netxms/portcheck.nsm
/usr/local/lib/netxms/sms.nsm
/usr/local/lib/netxms/ups.nsm
Ohhh man. There is a switch " --with-rpi-agent"
I will try and report....
Ok, little bit tricky, but it works. This is the way to get running:
# download the latest version of the library, say bcm2835-1.xx.tar.gz, then:
sudo tar zxvf bcm2835-1.xx.tar.gz
cd bcm2835-1.xx
sudo ./configure
sudo make
sudo make check
sudo make install
# download the latest netxms source
sudo tar zxvf netxmsxxx
cd netxm...
sudo ./configure --with-agent --with-snmp --with-client --with-client-proxy --disable-ssh --disable-mqtt --with-rpi-agent --libdir=/usr/local/lib
sudo make
sudo make install
Hi
I installed the nxagentd from repo. After activating the subagend rpi, I got error message:
2019.07.04 09:50:00.870 *E* Error loading subagent module "rpi.nsm": /usr/lib/arm-linux-gnueabihf/netxms/rpi.nsm: cannot open shared object file: No such file or directory
Checked the folder of "/usr/lib/arm-linux-gnueabihf/netxms/". There are all subagents, but the rpi subagent is missing.
Reinstalled the nxagend does not fix the issue.
Any solution for Raspberry without compile from source?
cat /proc/version
Linux version 4.14.79-v7+ (dc4@dc4-XPS13-9333) (gcc version 4.9.3 (crosstool-NG crosstool-ng-1.22.0-88-g8460611)) #1159 SMP Sun Nov 4 17:50:20 GMT 2018
nxagentd -v
NetXMS Core Agent Version 2.2.8 Build 9514 (2.2.8-32-g4a24d07a2a) (UNICODE)
Sincerly Lars