March 2017

ModSecurity: Mod Security rules for wordpress/joomla/drupal

You can use the following mod_security rules for wordpress/joomla/drupal ## Rules for the CWP ## SecRuleRemoveById 910006SecRuleRemoveById 950000SecRuleRemoveById 950001SecRuleRemoveById 950005SecRuleRemoveById 950006SecRuleRemoveById 950117SecRuleRemoveById 950907SecRuleRemoveById 958039SecRuleRemoveById 958051SecRuleRemoveById 958291SecRuleRemoveById 959006SecRuleRemoveById 959151SecRuleRemoveById 960008SecRuleRemoveById 960010 SecRuleRemoveById 960011 SecRuleRemoveById 960012 SecRuleRemoveById 960035 SecRuleRemoveById 960335 SecRuleRemoveById 960904 SecRuleRemoveById 960915 SecRuleRemoveById 970003 SecRuleRemoveById 970015 SecRuleRemoveById 970903 SecRuleRemoveById 973301 SecRuleRemoveById…

March 29, 2017

SQL-Server: Get Server – Edition – Instance Name with T-SQL

The following t-sql statement returns the server name, server instance, instance, edition & version of the running SQL-Server.

March 29, 2017

SQL-Server: sp_cursorprepexec: The value of the parameter XX is invalid.

When tracing with SQL profiler, it returned a query using ‘sp_cursorprepexec’. When executing the same query within SSMS, it failed with: sp_cursorprepexec: The value of the parameter XX is invalid. I managed to solve this by adding ‘+ 0x1000’ to…

March 22, 2017

Avamar: spawn after execve errno:8 code 8: Exec format error

When running pre/post scripts, it is possible that you are getting the following error message: 2017-03-20 19:43:43 avtar Info <5916>: Executing run-at-start ‘/usr/local/avamar/etc/scripts/test.sh’2017-03-20 19:43:43 avtar Info <6033>: Begin STDERR from run-at-start:avspawn::spawn after execve errno:8 code 8: Exec format error …

March 20, 2017

Linux: run commandline internet speed test

There are different possibilities to run internet speed tests from Linux (and Unix based systems) command line. Personally I don’t always want to install extra applications on the servers.Because of that, I use the following command line. The only thing…

March 1, 2017

ModSecurity: Mod Security rules for wordpress/joomla/drupal

SQL-Server: Get Server – Edition – Instance Name with T-SQL

SQL-Server: sp_cursorprepexec: The value of the parameter XX is invalid.

Avamar: spawn after execve errno:8 code 8: Exec format error

Linux: run commandline internet speed test

Add Schelstraete.org as app.