Johnny Morano
43 posts
OSSEC: building an OpenBSD package
OSSEC is an Open Source Host-based Intrusion Detection System that performs log analysis, file integrity checking, policy monitoring,…
Perl: Archive E-Mails in an IMAP Folder
IMAP folders are really because you can have your e-mails synchronized on multiple devices, without losing e-mails across…
Perl: SSL Communication in web applications
The following demonstrates how to create a strict SSL communication between client and server, using HTTP.This setup could…
Perl: Create schema backups in PostgreSQL
At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema…
Monitor running processes with Perl
Update: This article is updated thanks to Colin Keith his excellent comment. I was extremely inspired by it…
Postgresql: Monitor sequence scans with Perl
Not using indexes or huge tables without indexes, can have a very negative impact on the duration of…
Postgresql: Monitor unused indexes
Working on large database systems, with many tables and many indexes, it is easy to loose the overview…
Postgresql 9.3: Creating an index on a JSON attribute
Recently I’ve discovered some very interesting new features in the PostgreSQL 9.3 database.First of all, a new data…
Datatables and Perl (and a little bit of jQuery)
Recently I’ve stumbled on a pretty cool OpenSource project called ”datatables” (http://datatables.net/), which allows to easily create tables…
Google GeoChart, JSON and Perl
The Google API GeoChart Map (https://developers.google.com/chart/interactive/docs/gallery/geochart) is pretty nice widget to generate nice maps based on certain values.…