by ds | Sep 25, 2014 | MySQL, PHP
Scenario You have to move a MySQL database table to another database, but you have many other tables, functions, routines, events etc. which access it. Before moving it, it is not enough to find only the tables containing foreign keys, but also find functions etc....
by ds | Aug 13, 2014 | Uncategorized
Einer KNX-Installation, vor allem in Kombination mit KNX-IP-Gateway, stehen eine Unzahl an Angriffsmöglichkeiten gegenüber. Der Bus selbst bietet keinerlei Authentifizierungsmechanismen oder sonstige Sicherheitsmechanismen. Für die meisten Fälle gibt es vernünftige...
by ds | Aug 13, 2014 | Administration
The documentation of the Zyxel GS1900-48HP seems to be quite useless when it comes to security features. It does not explain what e.g. the Protected Port or similar features do in detail. Anyway, in this tutorial you will see how to allow exactly one Ethernet device...
by ds | Aug 13, 2014 | Uncategorized
You can monitor basic functionality of KNX components with the components you find on this site. Unfortunately, they don’t offer a script for reading KNX group addresses. According to check_maskversion.pl, I modified the script a bit to be able to get KNX GA...
by ds | Aug 13, 2014 | Uncategorized
Wenn es um die Überwachung der Basisfunktionen von KNX-Modulen geht, sind die Plugins von dieser Seite sehr empfehlenswert. Habe in meinem Dev-Blog ein weiteres Modul als Ergänzung zur Verfügung gestellt, um auch Gruppenadressen abfragen zu können. Dies kann z.B. für...
by ds | Jul 28, 2014 | Administration
Older Mainboards seem to have a problem with the TFTP block size setting. When you try to boot the image via PXE, you see the white status bar filling up, but suddenly the error appears: “0xc0000001, a required devices isn’t connected.” In Windows...
by ds | Jul 28, 2014 | Administration
Adding an RSS feed via GPO is pretty simple, e.g. import the Administrative Template for Outlook and you get some options to create default RSS feeds. But there is no way by default to remove certain feeds remotely. You can only e.g. disable the whole RSS feature, but...
by ds | Jul 28, 2014 | MySQL, PHP
Problem Framework CakePHP sets strings to null which are loaded from database tables and contain special characters like German Umlaute. Solution In app/Config/database.php, add to your config array: ‘encoding’ => ‘utf8’ Example: public...
by ds | Jul 22, 2014 | Administration
There are some steps which can’t be (easily) done with group policy objects. So it makes sense to create your custom Windows image if you have e.g. 3 workstations or more. Microsoft offers software for deploying which is quite comfortable. In most cases, you do...
by ds | Jul 10, 2014 | Administration
Scenario You run a Windows server with MySQL DB, want to keep it up to date, keep all settings and the upgrade process should work as fast as possible. Unfortunately, the official MySQL upgrading guides are too detailed in most cases, however they don’t really...
