↓
Menu ↓
  • News, articles and stuff
    • Development
      • Perl
      • Web
    • Media
      • Photo
      • Video
  • Media
    • Photography
  • About

Johnny Morano's Blog

Geek talk, extreme sports and travels

Johnny Morano's Blog
Home Menu ↓
Skip to primary content
Skip to secondary content
  • Home
  • About
  • Media
    • Photography
  • News, articles and stuff
Home 1 2 3 … 6 7 >>

Post navigation

← Older posts

Install OpenBSD 6.0 on a Soekris net6501

Posted on December 27, 2016 by Johnny MoranoApril 30, 2019

Recently I bought a Soekris net6501 to build a home network in my new house. Things you need before you start: – USB / mSSD drive to install OpenBSD on – USB drive to boot from – Serial cable for … Continue reading →

Posted in Blog, OpenBSD | Tagged Firewall, Installation, OpenBSD, Soekris, SysAdmin | 2 Replies

OSSEC: building an OpenBSD package

Posted on March 15, 2016 by Johnny MoranoMarch 15, 2016

OSSEC is an Open Source Host-based Intrusion Detection System that performs log analysis, file integrity checking, policy monitoring, rootkit detection, real-time alerting and active response. It runs on most operating systems, including Linux, MacOS, Solaris, HP-UX, AIX and OpenBSD. There … Continue reading →

Posted in Blog, OpenBSD | Tagged HIDS, OpenBSD, OSSEC, Security, SysAdmin | 1 Reply

Perl: Archive E-Mails in an IMAP Folder

Posted on November 5, 2015 by Johnny MoranoNovember 5, 2015

IMAP folders are really because you can have your e-mails synchronized on multiple devices, without losing e-mails across your devices when retrieving your new e-mails. IMAP folders actually also aren’t that cool because e-mails are usually never deleted or even … Continue reading →

Posted in Blog, Development, Perl | Tagged IMAP, Perl, SysAdmin | 1 Reply

Skytools 2.x patch for Postgresql 9.3.5

Posted on November 19, 2014 by Johnny MoranoMay 26, 2015

Skytools 2.x compiles perfectly with Postgresql 9.3.5, but when you try to ‘install’ the ticker with the pgqadm.py command, you will receive a strange error. After searching around on the Internet, it seems that when you compile software with Postgresql … Continue reading →

Posted in Blog | Tagged Dev, Patch, Postgresql, Skytools | 1 Reply

Perl: SSL Communication in web applications

Posted on November 6, 2014 by Johnny MoranoNovember 6, 2014

The following demonstrates how to create a strict SSL communication between client and server, using HTTP. This setup could used when creating a web API which requires strong encryption and only allows clients which have a properly signed certificate. The … Continue reading →

Posted in Blog, Development, Perl, Web | Tagged Apache, API, OpenSSL, Perl | Leave a reply

Perl: Create schema backups in PostgreSQL

Posted on August 22, 2014 by Johnny MoranoNovember 4, 2014

At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema to a compressed file and which was able to create weekly and daily backups. The backups had to be full backups each … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | Leave a reply

Monitor running processes with Perl

Posted on May 15, 2014 by Johnny MoranoJune 2, 2014

Update: This article is updated thanks to Colin Keith his excellent comment. I was extremely inspired by it Maintaining a large number of servers cannot be done without proper programming skills. Each good system administrator must therefor make sure he … Continue reading →

Posted in Blog, Development, Linux, Perl | Tagged CPAN, Dev, Linux, Perl, SysAdmin | 15 Replies

Postgresql: Monitor sequence scans with Perl

Posted on February 12, 2014 by Johnny MoranoFebruary 12, 2014

Not using indexes or huge tables without indexes, can have a very negative impact on the duration of a SQL query. The query planner will decide to make a sequence scan, which means that the query will go through the … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | 3 Replies

Postgresql: Monitor unused indexes

Posted on February 11, 2014 by Johnny MoranoFebruary 11, 2014

Working on large database systems, with many tables and many indexes, it is easy to loose the overview on what is actually being used and what is just consuming unwanted disk space. If indexes are not closely monitored, they could … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | 3 Replies

Postgresql 9.3: Creating an index on a JSON attribute

Posted on December 27, 2013 by Johnny MoranoDecember 27, 2013

Recently I’ve discovered some very interesting new features in the PostgreSQL 9.3 database. First of all, a new data type has been introduced: JSON. Together with this new data type, new functions were also introduced. These new features now simply … Continue reading →

Posted in Blog, Development, Perl, Web | Tagged Dev, Perl, Postgresql, SQL | Leave a reply

Post navigation

← Older posts

Ads

Recent Posts

  • Install OpenBSD 6.0 on a Soekris net6501
  • OSSEC: building an OpenBSD package
  • Perl: Archive E-Mails in an IMAP Folder
  • Skytools 2.x patch for Postgresql 9.3.5
  • Perl: SSL Communication in web applications

Categories

  • Blog
  • Database
  • Development
  • DH
  • Freeski
  • Linux
  • Mac OS X
  • Media
  • OpenBSD
  • Perl
  • Photo
  • PostgreSQL
  • Snowboard
  • Video
  • Web

Tags

Ajax Android API austria Bash Bikepark Leogang CPAN CSS Debian Dev DH EXIF Facebook Freedom freeride freeski freestyle Geotag girls rock the park GMail Google Google Calendar GoPro GPS Hack HTML IMAP IPTables JavaScript Linux livingroom MacOSX Media MySQL nature OpenBSD Perl Postgresql Security Snowboard SysAdmin UNIX Web 2.0 winter Wordpress

Archives

  • December 2016
  • March 2016
  • November 2015
  • November 2014
  • August 2014
  • May 2014
  • February 2014
  • December 2013
  • October 2013
  • September 2013
  • August 2013
  • October 2012
  • August 2012
  • April 2012
  • March 2012
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
© 2021 - Johnny Morano's Blog
↑