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”

WordPress Blog isn’t on Google: Possible Yoast SEO sitemap error

A few months ago I discovered, that MeineKleineFarm.Net is not findable on Google anymore. This resulted in dramatically decreased visitor statistics, despite the fact the new content was created by me. I suspected a wrong sitemap configuration to guilty. Let’s find out!

A few months ago I discovered, that MeineKleineFarm.Net is not findable on Google anymore. This is really bugging me, since the purpose of this blog is to share knowledge. But a blog that is not findable doesn’t bring value to anyone. On the other hand, search engines like Bing, DuckDuckGo and Yandex index an rank this blog.
I suspect the Yoast SEO sitemap to be guilty. Let me explain why. Continue reading “WordPress Blog isn’t on Google: Possible Yoast SEO sitemap error”

HowTo: Update to Roundcube 1.3.8

Time for another Roundcube update! This time it’s a major upgrade from release branch 1.2 to 1.3. See all changes here: https://github.com/roundcube/roundcubemail/releases/tag/1.3.0 ->
https://github.com/roundcube/roundcubemail/releases/tag/1.3.8

On 25.10.2018 the latest bugfix Release Version 1.3.8, was released. By now it’s really time to install the update, isn’t it? 😉

Continue reading “HowTo: Update to Roundcube 1.3.8”

My first time: Citrix Machine Creation Services (MCS)

After years of MCS virginity I decided it’s finally time to ditch the little farms and try out good ol’ Citrix Machine Creation Services.

Introduction

So today is my very first time: After years of MCS virginity I decided it’s finally time to ditch the little farms and try out good ol’ Citrix Machine Creation Services. In the last ten years I almost exclusively installed small deployments. The big ones have about 150 concurrent user. All are build upon XenApp 6.5 or XenApp 7.6+ with static persistent virtual machines. I always told myself, that static persistent virtual machines, together with a fully automated patch management (for example: PDQ) are enough. And this is still true, because the maintenance effort is virtually not existent. But it really bugs me, that I’m not equally familiar with at least one of the provisioning methods. You might ask, why I don’t try to learn PVS instead. Well, the simple reason is that my stomach tells me not to. The more valid reason is that MCS is included in every XenApp license and doesn’t require additional infrastructure. And additional infrastructure is always a really big topic for the customer.

This blog post won’t be a real classical Blog HowTo Guide, but more of a report of my journey to help me keep track about what I do. Maybe others suffer the same knowledge gap and are interested in my findings and the path I take. Continue reading “My first time: Citrix Machine Creation Services (MCS)”

Group Policy: Show only specified Control Panel items for Outlook 2016 via Office 365

Quick Tip Blog article: HowTo whitelist the Outlook 2016/Office 365 control panel item correctly.

I just stumbled over something at a customers environment. We had a Outlook 2016 / Office 365 problem in a XenApp session. We tried to access the Outlook control panel item, but it was missing. This was no surprise, as we have the GPO…

…enabled in every environment. This acts as a whitelisting for the control panel items, so the user only has access to those items, that matter to him. Continue reading “Group Policy: Show only specified Control Panel items for Outlook 2016 via Office 365”