Installing the Microsoft ODBC Driver for SQL Server on Debian Linux with Saltstack

Installing the Microsoft ODBC Driver for SQL Server on Debian Linux (msodbcsql17) with Saltstack requires to pass ACCEPT_EULA=Y to the package manager. This blog post shows a possible solution.

Introduction

Microsoft offers several open source utilities for quite some time now. One is the Microsoft ODBC Driver for SQL Server on Linux which can be leveraged with unixodbc. In my case, I need this driver to query Microsoft SQL Server for my Zabbix ODBC monitoring, to execute native SQL queries for monitoring purposes. As I have to take control over 30+ Zabbix Proxies, I’m currently transforming all of them into Salt minions. My goal here is to achieve 100% automation, as soon as I install the Salt minion on a fresh Debian Linux. Continue reading “Installing the Microsoft ODBC Driver for SQL Server on Debian Linux with Saltstack”

Zabbix: Simple file count for Linux

Watch the files count of a dir on Linux with Zabbix.

In EDI based communications you often have a dir where EDI files get saved and wait for processing. Every now and then these processes don’t work and the file count grows. Of course this is only one example, but it’s often handy to have a trigger fire, when a certain folder has more than X files in it.

Continue reading “Zabbix: Simple file count for Linux”

I created a GitHub repository for Zabbix Templates

Two months ago I started a repository to upload and share some of my Zabbix templates. Of course they’re also listed on: 

Somehow I forgot to post about it on Twitter and my blog. But it’s never too late:

Continue reading “I created a GitHub repository for Zabbix Templates”

HowTo: Monitoring if a specific user is logged on with Zabbix

Sometimes you face the problem, that a software vendor depends on logged on user sessions, instead of windows services. We had the case, that a partner constantly complained, that we logged of his service user. To have a history about the logged on state, I added a Zabbix item through the possibility to add custom UserParameter. The CMD line utility qwinsta is able to check if a specific user is logged on.

Continue reading “HowTo: Monitoring if a specific user is logged on with Zabbix”

Veeam Backup & Replication v8 PowerShell SDK AddIn nicht registriert

Durch unsere Kunden weite Migration weg von XenServer und SEP Sesam, hin zu VMware und Veeam, wurde es interessant mit Hilfe der PowerShell Befehle für Veeam den Backup Status zu überwachen. Hierzu gibt es ein schönes Template welches wir bereits erfolgreich einsetzen. (ZBX-VEEAM-BACKUP) Continue reading “Veeam Backup & Replication v8 PowerShell SDK AddIn nicht registriert”