Skip to content

Instantly share code, notes, and snippets.

View jbfavre's full-sized avatar

Jean Baptiste Favre jbfavre

56 followers · 8 following
View GitHub Profile
@jbfavre
jbfavre / ubuntu_precise_ec2_post_install
Created July 25, 2012 12:55
Ubuntu 12.04 Precise post install on AWS EC2
aptitude -y purge accountsservice acpid apport apport-symptoms apt-transport-https apt-xapian-index at busybox-static byobu cloud-initramfs-growroot cloud-initramfs-rescuevol console-setup curl dbus dmidecode dosfstools ed eject fonts-ubuntu-font-family-console friendly-recovery ftp fuse geoip-database gettext-base gir1.2-glib-2.0 gir1.2-gudev-1.0 grub-common grub-gfxpayload-lists grub-pc grub-pc-bin grub2-common hdparm iptables iputils-ping iputils-tracepath irqbalance iw kbd keyboard-configuration krb5-locales landscape-client landscape-common language-selector-common laptop-detect libaccountsservice0 libcap-ng0 libcurl3 libdate-manip-perl libdbus-glib-1-2 libevent-2.0-5 libfreetype6 libfuse2 libgc1c2 libgirepository-1.0-1 libgudev-1.0-0 libiw30 libjs-jquery libnfnetlink0 libparted0debian1 libpcap0.8 libpci3 libpolkit-gobject-1-0 libsasl2-modules libusb-1.0-0 libx11-6 libx11-data libxau6 libxcb1 libxdmcp6 libxext6 libxmuu1 libyaml-syck-perl logwatch lshw lsof ltrace memtest86+ mlocate nano ntfs-3g os-prober
@jbfavre
jbfavre / selfoss_import_from_rsslounge.php
Last active December 14, 2015 23:59
Little script to import into selfoss data from rsslounge. DB structure are quite close, so it's easy. **Warnings**: - Provide your own DB credentials line 2 & 3 - For category -> tag migration, default value was "Sans catégorie" (in french). Beware to adapt it to your rsslounge value (line 34) - Since I only use RSS feeds in rsslounge, I could n…
<?php
$rssloungeDB="rsslounge";
$selfossDB="selfoss";
$rsslounge= new mysqli("localhost", "username", "password", $rssloungeDB);
$selfoss= new mysqli("localhost", "username", "password", $selfossDB);
/* Export categories into tags */
$categories_query="select name from ".$rssloungeDB.".categories where ".$rssloungeDB.".categories.id>0";
$categories= $rsslounge->prepare($categories_query);
@jbfavre
jbfavre / gist:6811939
Last active March 8, 2020 19:24
Vertica monitoring draft. Which relevant informations can we get from v_monitor view ?

Vertica monitoring

Found into Vertica Ganglia monitoring package:

SQL statements

from verticalib.php

Events (SNMP Trap)

@jbfavre
jbfavre / gist:9341702
Created March 4, 2014 07:15
GnuSocial Error
Mar 4 08:13:08 www statusnet: PHP Fatal error: Ostatus_profile::ensureActivityObjectProfile(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "LooseOstatusProfile" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition in /plugins/OStatus/classes/Ostatus_profile.php on line 1380
@jbfavre
jbfavre / Wheezy-preseed-partman
Created May 2, 2014 11:21
d-i partman-auto/method string lvm
d-i partman-lvm/device_remove_lvm boolean true
d-i partman-lvm/confirm boolean true
d-i partman-lvm/confirm_nooverwrite boolean true
d-i partman-auto-lvm/new_vg_name string vg0
d-i partman-auto-lvm/guided_size string 12GB
d-i partman-auto/expert_recipe string \
boot-root :: \
256 100 256 ext2 \
@jbfavre
jbfavre / nginx vhost config
Created January 6, 2015 23:19
Nginx: using map to find root dir based on subdomain
map $http_host $dirname {
~(?P<subdomain>.*).domain.tld $subdomain;
}
server {
listen 80;
server_name domain.tld *.domain.tld;
root /var/www/$dirname/docroot;
index index.html;
try_files $uri $uri/ =404;
@jbfavre
jbfavre / gist:4d012fdb6b3332c16e6f
Created March 27, 2015 19:00
hdparm -I Macbook Pro
# hdparm -I /dev/sda
/dev/sda:
ATA device, with non-removable media
Model Number: APPLE SSD SM0512F
Serial Number: S1K5NYAG225885
Firmware Revision: UXM2JA1Q
Transport: Serial, ATA8-AST, SATA 1.0a, SATA II Extensions, SATA Rev 2.5, SATA Rev 2.6, SATA Rev 3.0
Standards:
@jbfavre
jbfavre / Zabbix trapper items, trigger issue
Last active September 12, 2015 12:44
Problem: item get triggered, and alert sent, when threshold is reached. But, it get recovered within seconds despite hysteresis.
Since data are collected every minutes using trappers, we got an alert+recovery every minute.
Zabbix version: 2.4.6 for both server & agent
Item is discovered through LLD. Here's the actual LLD paylod:
{
"{#RMQQUEUENAME}": "queue_name",
"{#RMQRATIOTHRES}": 5,
@jbfavre
jbfavre / ZBXNEXT-611-2.4.patch
Last active February 19, 2016 14:07
ZBXNEXT-611 backport for Zabbix 2.4: run Zabbix in foreground, including standard redirection on console
diff --git a/conf/zabbix_agentd.conf b/conf/zabbix_agentd.conf
index 1a76d61..c42052d 100644
--- a/conf/zabbix_agentd.conf
+++ b/conf/zabbix_agentd.conf
@@ -1,4 +1,4 @@
-# This is a config file for the Zabbix agent daemon (Unix)
+# This is a configuration file for Zabbix agent daemon (Unix)
# To get more information about Zabbix, visit http://www.zabbix.com
############ GENERAL PARAMETERS #################
@jbfavre
jbfavre / output
Last active May 17, 2016 11:56
smartctl -a /dev/sda
smartctl 6.5 2016-01-24 r4214 [x86_64-linux-4.5.0-2-amd64] (local build)
Copyright (C) 2002-16, Bruce Allen, Christian Franke, www.smartmontools.org
=== START OF INFORMATION SECTION ===
Model Family: Crucial/Micron MX100/MX200/M5x0/M600 Client SSDs
Device Model: Micron_M600_MTFDDAV512MBF
Serial Number: 1533106321A4
LU WWN Device Id: 5 00a075 1106321a4
Firmware Version: MA01
User Capacity: 512 110 190 592 bytes [512 GB]