There are different methods to run queries against an SQL Server from a Linux machine. The one I am using is mssql-cli (https://github.com/dbcli/mssql-cli)
As you can check in the related github website, it has the following features:
- Syntax highlighting
- Query history
- Configuration file support
- Multi-line queries
The -Q parameter
It has been packetized for a lot of distributions … Read more
I use Powershell to send monitoring results to the Icinga API (passive checks). For example, to check if the Exchange backups were processed correctly, I run a Exchange powershell and then the results are sent using “Invoke-WebRequest” command.
Since I disabled obsolete and insecure TLSv1 and TLSv1.1 protocols in the Exchange server, the script was not working anymore returning error:… Read more
It is very important to keep your Checkpoint environment monitored. Given that it offers a wide variety of SNMP data, I have collected some of the (in my opinion) most useful OIDs MIBs. Altough I use Icinga and Grafana (as you can see the related outputs in this post), almost any monitoring system can be used to get … Read more
Last monday I realized that the cpu was very high on one of my Checkpoint VSX nodes.
Looking at my Icinga graphs it seemed it started on friday at 3 o’clock:
Running a top directly on the VSX, I delimited the high to one of the virtual systems that runs on that VSX. In this image the fwk2 threads that … Read more
A common task among system administrators is the renewal of SSL certificates. It is important to keep track of expiration dates so that it is not too late for us to renew it.
You can simply create an excel or some other type of record of the certificate dates, but you have to remember to check it from time … Read more
In the previous post I explained what is the difference between Icinga active and passive checks, why can be interesting to use passive checks, what is the result format Icinga is expecting when processing those checks and the way I use to send those results (instead of using snmp traps).
Now it is time to show how to configure it … Read more
As I posted long time ago for Nagios (Nagios – Using passive checks without agent), it is time to show an easy way to configure Icinga to perform passive checks (without using SNMP traps).
This is the first of two posts. In this I only want to make some theoretical explanations and then in the second I will … Read more
It is not the first time my Icinga suddenlty, stops showing the grafana graphs.
If trying to log to Grafana, admin password is not accepted. I am pretty sure i have not changed the password but I am unable to login to Grafana.
And even worse, given that I still have not configured Grafana SMTP section / admin … Read more
Here I am trying to present (I hope in an easy way to understand) some Icinga concepts (maybe also applicable in Nagios) like active and passive checks, enabling and disabling freshness checks, soft and hard states,… and the related parameters to configure them.
ACTIVE and PASSIVE services
There are two types of services:
- ACTIVE: Check initiated by the Icinga
… Read more
As you can see in previous posts…, Im in love with Nagios to monitor my systems… after creating some powerful, customized plugins for my Checkpoint firewalls, Exchange servers… cannot live with it… but maybe, it's "a bit" old fashioned and I have decided to try the Icinga monitoring tool. If it fits my environment, I'll have to replace my old … Read more