jeltsch's blog

Konqueror stores its bookmarks in an xml file (bookmarks.xml) of document type xbel (XML Bookmark Exchange Language). Because I want to have my bookmark file always online (a link from my homepage), I need a way to convert the XBEL file into an HTML file or make the browser display the XML file. Most browsers can display xml data, but they need a seperate style sheet document to do so. Thus I inserted into the bookmarks.xml file a reference to a css style sheet file (bookmarks.css):

Crontab entry to backup all mysql databases to a file every midnight:
0 0 * * * mysqldump -u mjeltsch -h localhost --all-databases | gzip -9 > /home/mjeltsch/Documents/mysqldump.gz > /dev/null

Granting privileges to users connecting from localhost:
GRANT ALL PRIVILEGES ON *.* TO 'michael'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Granting privileges to users connecting from everywhere:
GRANT ALL PRIVILEGES ON *.* TO 'michael'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

I have set up OpenVPN on our pribvate network, but our special setup requires manually adding a static entry to the routing table of computers that we want to access from the outside via our VPN server. In SuSE Linux this is a nobrainer as Yast provides a section where to add static routing information. On MacOS X the command line works, but upon reboot the route is lost:

route add 10.8.0.0/24 192.168.0.2

Check what the route is for a specific IP:

route get 10.8.0.1