Latest Posts
📅 2017-08-04
✍️ Bart Schelstraete
If you configure HAProxy by default, the backends will receive the IP address of the HAProxy as the incoming IP address. Some applications (or people) don't want that. It is possible to configure…
Read more →
📅 2017-07-05
✍️ Bart Schelstraete
With the code below, you can set SELinux to allow remote backends. getsebool haproxy_connect_any # by default 0 setsebool -P haproxy_connect_any 1
Read more →
📅 2017-06-13
✍️ Bart Schelstraete
admin@xxx:~/>: psql -p 5555 -U viewuser mcdb mcdb=> Example queries: SELECT * FROM "public"."v_clients"; SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type…
Read more →
📅 2017-06-07
✍️ Bart Schelstraete
from: http://jasonbrimhall.info/2014/01/02/day-9-queries-going-boom/ The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for…
Read more →
📅 2017-04-16
✍️ Bart Schelstraete
You can use Let's Encrypt certificates for the ISPConfig admin console too. In order to achieve this, you can use the following commands: ### as super user of course DOMAIN="www.mydomain.com"…
Read more →
📅 2017-04-06
✍️ Bart Schelstraete
If you have a file system with a lot of small files, it is possible that you are running out of inodes. Unfortunately it is not possible to increase the number of inodes on the fly. In order to…
Read more →
📅 2017-04-05
✍️ Bart Schelstraete
In PowerShell, you can also use a grep like you can do on Linux. In order to search for a string in a file, you can use the following command: sls "Searchthisstring" "C:\myfile.log" -ca If you want…
Read more →
📅 2017-03-29
✍️ Bart Schelstraete
You can use the following mod_security rules for WordPress/Joomla/Drupal: ## Rules for the CWP ## SecRuleRemoveById 910006 SecRuleRemoveById 950000 SecRuleRemoveById 950001 SecRuleRemoveById 950005…
Read more →
📅 2017-03-29
✍️ Bart Schelstraete
The following T-SQL statement returns the server name, server instance, instance, edition & version of the running SQL Server. SELECT SERVERPROPERTY('MachineName') AS [ServerName],…
Read more →
📅 2017-03-22
✍️ Bart Schelstraete
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.…
Read more →
