Gilles Darold :: GPL tools

Here you can find some tools that's I've developed under GPL, BSD like or Artistic licences and documentation under the Creative Commons BY-NC-SA licence.

Apache modules


Apache2::ModProxyPerlHtml is the most advanced Apache output filter to rewrite HTTP headers and HTML links for reverse proxy usage. It is written in Perl and exceeds all mod_proxy_html.c limitations without performance lost.

Apache2::ModProxyPerlHtml is very simple and has far better parsing/replacement of URL than the original C code. It also support meta tag, CSS, and javascript URL rewriting and can be use with compressed HTTP. You can now replace any code by other, like changing images name or anything else. mod_proxy_html can't do all of that. Since release 3.0 ModProxyPerlHtml is also able to rewrite HTTP headers with refresh url redirection. One of the common used of ModProxyPerlHtml is as free replacement for Microsoft TM ISA servers.

AuthenCacheLDAP Apache2::AuthenCacheLDAP is an advanced Apache2 / mod_perl2 authentication program (allow group auth + non standard LDAP schema + cache + single signon (SSO)). Last version include SSO logout.
AuthenCacheLDAP Apache::AuthenCacheLDAP, same as above but for Apache/mod_perl versions 1



SquidClamav is an antivirus for Squid proxy based on the Awards winnings ClamAv anti-virus toolkit. Using it will help you securing your home or enterprise network web traffic. SquidClamav is the most efficient Squid Redirector and ICAP service antivirus tool for HTTP traffic available for free, it is written in C and can handle thousand of connections. The way to add more securing on your network for free is here.

SquidClamav is build for speed and security in mind, it is first used and tested to secure a network with 2,500 and more users. It is also known to working fast with 15000+ users.



Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.

Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database. It is really easy to used and doesn't need any Oracle database knowledge than providing the parameters needed to connect to the Oracle database.


pgBadger is a PostgreSQL log analyzer build for speed with fully detailed reports from your PostgreSQL log file. It's a single and small Perl script that aims to replace and outperform the old php script pgFouine.

pgBadger is written in pure Perl language. It uses a javascript library to draw graphs so that you don't need additional Perl modules or any other package to install. Furthermore, this library gives us more features such as zooming.


pgFormatter is a SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May works with any other databases too.

pgFormatter can work as a console program or as a CGI. It will automatically detect his environment and output as text or as HTML following the context.


pgCluu is a PostgreSQL Cluster performances monitoring and auditing tool.

pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL cluster using psql and sar, a grapher that will generate all HTML and charts output.

External file extension

external_file is a PostgreSQL extension that allows access to "external files" from PostgreSQL server file systems.

Uri extension

uri is a PostgreSQL extension to add uri data type for postgresql, it allows to insert data in uri format and provide all functions to extract uri parts, validate and compare uris. Some functions are provided to check if an uri exists, check size and content-type of remote uri. uri columns can be indexed using btree and hash indexes.

Log analyzer / Reporting tools


SendmailAnalyzer as is name suggest is a free Sendmail/Postfix log analyzer. It process maillog files and generate dynamic statistics in HTML and graphical output. The reports are generated in real time so that it let you know at any moment what is going on your mail servers. It use time (hour, day, month and year views) and cross-linked navigation for easy use.

SendmailAnalyzer is easy to install and highly configurable to match the dozen of Sendmail possible configurations. It also support report for all the major milter or sendmail filters like SpamAssassin, MailScanner, Clamav, Amavis, RBL check, J-ChkMail, etc. SendmailAnalyzer is really helpful for IT reporting.


Squid proxy native log analyser and reports generator with full statistics about times, hits, bytes, users, networks, top urls and top domains. Statistic reports are oriented toward user and bandwidth control; this is not a pure cache statistics generator.

SquidAnalyzer use flat files to store data and don't need any SQL, SQL Lite or Berkeley databases.

This log analyzer is incremental and should be run in a daily cron or more often on huge network trafic.


pgBadger is a PostgreSQL log analyzer build for speed with fully detailed reports from your PostgreSQL log file. It's a single and small Perl script that aims to replace and outperform the old php script pgFouine.

pgBadger is written in pure Perl language. It uses a javascript library to draw graphs so that you don't need additional Perl modules or any other package to install. Furthermore, this library gives us more features such as zooming.

SysAdmin tools


SysUsage continuously monitor your systems informations and generate periodical graph reports using rrdtool or javascript jqplot library. All reports are shown throught a web interface. SysUsage is design with simplicity in mind. I want all relevant statistics from my servers within an intuitive web interface and without spending too much time to configure it, if you know Nagios, you know what I mean. You will especially like SysUsage for that.

SysUsage grabs all system activities using Sar and system commands allowing you to keep tracks of your computer or server activity during his life. It is a great help for performance analysis and resources management. The threshold notification can alarm you when the system capabilities are reached by sending SMTP messages or throught Nagios reports.


SquidGuard Manager is a Perl CGI Web GUI for squidGuard and SquidClamav administration. It allow full administration of SquidGuard blocklist and ACLs. You can also manage graphicaly your SquidClamav configuration.

This program support all configurations directives of SquidGuard and SquidClamav without intrusive modification, i-e you can still edit the configuration files by hand before and after using SquidGuard Manager.


pgCluu is a Cluster performances monitoring and auditing tool but it can also be used as a single sar grapher tool.

Conferences and documentation

LT about pgtt

Slides of the lightning talk I've given at PGCon 2018, in Ottawa about pgtt, the Global Temporary Tables extension.

Partitionnement et transactions autonomes (video)

Talk about PostgreSQL partionnement and autonomous transaction, in French I've given at PGDAY France, Toulouse, June 2017.

Oracle, comment s'en passer (video)

Talk about How to leave Oracle, in french I've given at PostgreSQL Session #7, Paris, 2015 September

Migration Oracle, the hard way

Talk about Oracle migration difficulties, in english I've given at PostgreSQL Conference Russia, Moscow, Febuary 2015.

Migration Oracle spatial

Talk about Oracle Spatial migration, in french I've given at PostgreSQL Session #6, Paris, September 2014.

Ora2Pg Performances

Talk about migration performances in french I've given at PGDay Nantes 2013.

Talk about pgBadger v4

Slides of the talk given by Jean-Paul Argudo at PGConf.EU 2013, in Dublin about pgBadger v4.0.

Ora2Pg Quick Tour

Slides of the talk in french I've given at PGSessions #4 October 2012, in Paris about Ora2Pg.

LT about pgBadger

Slides of the lightning talk I've given at PGCon 2012, in Ottawa about pgBadger.

Ora2Pg best practices

Slides of the talk I've given at PgConf.Eu 2011 in Amsterdam, conference "Ora2Pg best practices" in french

Talk about Ora2Pg

In this video from Us PG Day 2011, CEO of Consistent State, Kevin Kempter, talks about migrating from Oracle to PostgreSQL with ora2pg. Kevin will start by giving us an overview of ora2pg, he goes through the install, and spend some time with the config file, finally he show us some examples of ora2pg being used.

Migration Oracle vers PostgreSQL

Conférence donnée à Linux Solution 2005 à Paris par Jean-Paul Argudo sur la migration des bases Oracle vers PosgreSQL avec le projet Ora2Pg.


This document is about building an LDAP server with a PostgreSQL database as backend instead of the standard Bekerley DB.

L'open source et le Groupe SAMSE

Conférence donnée à Linux Solution 2003 à Paris par Philippe Blanchard détaillant l'architecture Open Source que j'ai mis en oeuvre au sein du Groupe SAMSE.

Implémentation d'un annuaire LDAP

Conférence donnée aux JRES2001 à Lyon par Philippe Blanchard détaillant la mise en oeuvre d'un annuaire LDAP que j'ai réalisé au sein du Groupe SAMSE.

More usefull tools to come...

Author : Gilles DAROLD