MySQL slow select on information_schema

I noticed that selects on the information_schema table was very slow. Found this guide on how to fix it

http://www.percona.com/blog/2011/12/23/solving-information_schema-slowness/

So the magic that fixed it was

set global innodb_stats_on_metadata=0;

That improved my SQL query from taking 15 seconds down to 0.03 seconds.

$5 eBook Bonanza

Packt Publishing $5 eBook Bonanza sale of ebooks and videos now during the holidays from 18th December to 6th January. This is an awesome opportunity to get yourself a holiday treat.

Hurry up and visit http://bit.ly/1uW4pQG before the sale is over.

Packt Publishing is a UK based publisher focusing on educational eBooks and Videos for IT professionals. All their eBooks and Videos are DRM-free.

If you are looking to learn something new or want to freshen up your skills don't miss out on this.

5 dollar promo

Firefox loading issues with Pfsense web interface

A while ago I noticed that Firefox began to have issues with loading the web interface for our Pfsense firewalls while other browsers loaded the website with no problems.

Here is a picture showing the timings of the web request for the index page

Firefox loading pfsense slowly

Then I found out that Firefox had changed the behaviour of how it handles SSL certificates in a recent update

There it states that a server certificate are not allowed to have the CA flag set:

Are not allowed to have basic constraints asserting isCA=TRUE.

And if you check the self-signed certificate used by default in pfsense it has the CA flag set.

So I created a CA certificate in Pfsense and then a "server" certificate signed by the seperate CA certificate and configured Pfsense to use the new server certificate instead. This change fixed the issue and now Firefox is loading the web interface without problems.

A tool for distributing password over unsecure channels like email

A recurring problem at work it how to easily send passwords to users. Or sending shared keys for VPN tunnel setups with customers.

I remembered that I had seen a tool for this online that used a webpage where you could enter the password and get a link for retrieve the password that will also remove the password to prevent others from accessing it.

And since I recently started learning Flask which is a nice Python framework for creating websites, I decided to create my own tool for this.

So here it is

http://that-password.steneteg.org/

That Password

Here is the source code for it:

https://github.com/rogst/that-password