Tag: sysadmin

Who’s linking to your site?

If you’re using LogMiner to analyse your Apache/IIS logs, here’s an easy recipe to be notified of sites that send visitors your way. First, let’s define a Pg/PLSQL function to extract the new referrers: 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748CREATE TYPE new_referrer AS (     site_id         int8,     site_name       text,   …

Read more

lm_sensors config for Asus T3-P5945GCX (P5L13L motherboard)

I’ve just installed the latest Mandriva 2008.1 RC on this fine Asus barebone. Everything went fine, except that the output of sensors showed too many ALARM messages for my taste… so, here’s how I’ve modified the pre-installed sensors.conf to set some min/max values closer to reality and to hide useless lines: 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748# Winbond W83627EHF configuration …

Read more

LogMiner: purging old accesses

I’ve just committed a function to easily purge old data from LogMiner’s database, useful to prevent it from growing too much. It’ll appear in the next version, but since its release might still be far from now, here’s the code for those who need it: 123456789101112131415161718192021222324252627282930313233343536373839CREATE OR REPLACE FUNCTION cleanup( _site int8, _upToDate DATE ) …

Read more