If OpenOffice doesn’t show any icons in the toolbars then you might want to re-install the packages
- openoffice.org-style-default
- openoffice.org-style-human
.
Mysql Slice a resultset
Slicing a mysql result is easy with
select from_unixtime(unix_timestamp(timestamp) -unix_timestamp(timestamp) % $slicecount) as slice, count(*) from event group
by slice
by slice
This will return the mysql statement sliced on the given number of slices.
Networking Monitoring Tools
A list of useful networking monitoring tools. This is not a Top 10 or Top 5 or Top whatever, the usefulness of these applications depends on your environment and what exactly you want to monitor for.
1. ntop
ntop is a network traffic probe that shows the network usage, similar to what the popular top Unix command does. ntop is based on libpcap and it has been written in a portable way in order to virtually run on every Unix platform and on Win32 as well. It’s great to use, comes with a list of plugins and has a nice web-interface. It’s an easy an inexpensive way to catch misconfigured or compromised hosts on your network.
2. snort
tcpdump is probably the best known monitoring tool, it dumps all the network traffic and comes with extended filtering capabilities.
4. atop
atop is an advanced interactive monitor for Linux-systems to view the load on system-level and process-level but it can also display the network traffic. Start it with atop -N > file.
5. bmon
bmon is a bandwidth monitor for network connections. With it you can watch a certain network card or a many of them. Bmon presents the results in ascii or ncurses.
6. nfsen / nfdump
nfsen is an open source netflow monitor. Results are presented via a webinterface and it comes with tcpdump-like filters. Invaluable tool for network analysis.
Install PHP5 on OpenBSD 4.2
PHP needs expat; this is included in the base set xbase42. If you didn’t install it at install-time you can get it with
cd /
ftp http://ftp.belnet.be/mirror/ftp.openbsd.org/4.2/i386/xbase42.tgz
tar xzvpf xbase42.tgz
ftp http://ftp.belnet.be/mirror/ftp.openbsd.org/4.2/i386/xbase42.tgz
tar xzvpf xbase42.tgz
Magpierss with UTF8
MagpieRSS is an RSS parser in PHP. If you’re parsing UTF-8 streams and the output looks crippled then you might want to try this (add this to your file that calls the Magpie-code ) :
define(‘MAGPIE_OUTPUT_ENCODING’, ‘UTF-8’);
define(‘MAGPIE_INPUT_ENCODING’, ‘UTF-8’);
define(‘MAGPIE_DETECT_ENCODING’, false);
define(‘MAGPIE_INPUT_ENCODING’, ‘UTF-8’);
define(‘MAGPIE_DETECT_ENCODING’, false);
Adjust X11 resolution on the fly
Modern X11 drivers support resolution changing on the fly (as in, you don’t need to restart your X11 server). You can check if your driver supports this when you see this
(==) RandR enabled
(II) Initializing built-in extension RANDR
(II) Initializing built-in extension RANDR
Changing the resolution is very easy:
xrandr –size 1024×768
Entering xrandr without any options shows all the available resolutions.
Snort 3.0 Architecture Serie
If you care at all about Snort you must read Snort 3.0 Architecture Series by Marty Roesch.
start Ubuntu in text mode only
A short command on how to change Ubuntu so that it will only start in text mode, no X11 (graphical) mode. The following removes the graphical greeter from the runlevels :
sudo update-rc.d -f gdm remove
Write a disk full with files with random or zero data
I wanted to test a hard-drive that halted when its internal temperature raised above its safety level. hdparm is one option but the script below creates different files with a certain given size.
#!/bin/bash
COUNTER=0
while [ true ]; do
dd if=/dev/zero of=file$COUNTER bs=$1 count=1024
let COUNTER=COUNTER+1
done
COUNTER=0
while [ true ]; do
dd if=/dev/zero of=file$COUNTER bs=$1 count=1024
let COUNTER=COUNTER+1
done
You can replace /dev/zero with /dev/random if you want random data. Call the script with one argument, the file size.
Set the default height and width of a gnome-terminal
Launch it with gnome-terminal –geometry 135×30 (edit the menu or create a new launcher).
Adjust the launchsettings in ~/.xbindkeysrc
“gnome-terminal –geometry 135×30”
m:0x10 + c:116
m:0x10 + c:116
