https://old.andunix.net/ 2026-06-03T23:25:09+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/travian_map_download_script Travian Map Download Script This is my script(s) which I use to downoad the map.sql from Travian and import it to the database. config.inc # # database DB_USER="travian" # set this to your database user DB_PASS="travian" # set this to your database password DB_INST="travian" # set this to your database instance # # directories MAP_DIR=${HOME}/opt/travian DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql # # executables MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -… text/html 2015-11-25T08:54:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/home_server_goals Home Server Goals As Constantin suggested, here is a list of services, which my home server should provide: * Personal Video Recorder: I'm using the EyeTV Hard- and Software from Elgato to record, cut and archive TV broadcasts. * Secure File Archive/Backup text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/backup MySQL: Backup Export a Database # set or replace the variables $USER, $PASS and $DB mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} Export all Databases individually # set or replace the variables $USER and $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases') for db in ${DATABASES} do mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql & bzip2 ${DB}_${DATE_YMD}.sql & # sleep 10 # option… text/html 2013-07-03T13:03:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/init init Managing init Scripts To activate an init script (“myscript”): update-rc.d myscript enable To deactivate an init script (“myscript”): update-rc.d myscript remove Further information can be found at Daemon - Debian Wiki sysadmin linux debian cli text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/syntax Formatting Syntax DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressing text/html 2013-02-04T22:17:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/tools Command Line Tools Used in My Scripts This is a list of comman dline tools which I use in my scripts an which should be installed on every of my systems. Basic tools (e.g. awk, find, grep, ps) which are always installed are not listed. Audio/Video text/html 2010-04-21T08:17:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/memory_usage_solaris_container_zone Memory Usage of a Solaris Container (Zone) Last week one of my servers ran out of RAM and Swap. Shame on me for not monitoring that, but it's now. As the server is running several zones, my first question was: Which zone is eating up my RAM? So, here are the commands I used. text/html 2013-12-17T09:09:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/password MySQL: Change Password * Replace {passwd} with the password of the user. * Replace {user} with the name of the user. GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; Or you can alternatively use the following: UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/mysql mysql Pages Bookmarks text/html 2013-02-04T22:17:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/dyndns_updates_without_client DynDNS Updates without a Client My new hosting provide Strato offers DynDNS. I was searching for a DynDNS client for my OpenSolaris Home Server, but a small bash script does the job as good as any other client. #! /bin/bash . ${HOME}/.dyndns.cfg DOMAINS=$(cat ${HOME}/.dyndns.domains) echo "$(date '+%Y-%m-%d %H:%M') $(basename $0)" for domain in ${DOMAINS}; do echo -n " ${domain} - " curl --silent --show-error --insecure --user ${LOGIN} "${UPDATE_URL}?hostname=${domain}" d… text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/revoke MySQL: Revoke Permissions Revoke Permissions REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; admin database mysql sql text/html 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/create MySQL: Create User Create User CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; Create User and Database * Usually, {user} == {db} CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/view MySQL: View Permissions View Permissions SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/remove MySQL: Remove User Remove User DROP USER '{user}'@'%'; Remove User and Database * Usually, {user} == {db} DROP USER '{user}'@'%'; DROP DATABASE '{db}'; admin database mysql sql text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/remove MySQL: Remove Database Remove Database DROP DATABASE IF EXISTS `{db}`; admin database mysql sql text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/index Travian Welcome to the Travian tools at andunix.net. Here I will publish my projects regarding the browsergame “Travian” (german page). travian index Links to other Tools * Travian Analyzer * Travian Toolbox * Travian Village Planner -- the inspiration for my village planner * TravMap * Travianmap * Travian Kampfberichtparser (german) travian text/html 2013-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/exam_notes Notes for the Solaris 10 System Administration Exam (CX-310-200 & -202) I'm preparing myself for the two exams to achieve the Sun Certified System Administrator (SCSA) certification. This are my notes taken while studying the preparation books. Managing File Systems List Devices To list the system's devices, you can use the following commands: text/html 2013-03-12T21:41:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/drupal_reverse_proxy Drupal: Reverse Proxy skybow wrote the very helpful article “Drupal via HTTPS/SSL Proxy Server (shared certificates)”. While following his advice, I found some improvements. To reduce the amount of editing and to increate the reusability, I substituted * www.example.com with $_SERVER['SERVER_NAME'] and text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/create MySQL: Create Database Create Database CREATE DATABASE IF NOT EXISTS `{db}`; Create Database and Grant Rights to a User CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2015-11-25T08:53:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/make_your_mac_feel_home Make your Mac feel at Home A small snippet from one of my scripts which tests whether your Mac is in the given (home) WLAN. # # Path to 'airport' executeable, as of Mac OS X 10.5. AIRPORT="/System/Library/PrivateFrameworks/Apple80211.framework/Versions/Current/Resources/airport" # # Set this to your Home WLAN SSID (name): HOMESSID="mycastle" # # Get SSID info from 'airport' and search for $HOMESSID SSID=$(${AIRPORT} --getinfo | grep ' SSID:') SSID=$(echo ${SSID} | grep "^SSID: ${HOMESSID}\$")… text/html 2010-02-28T23:00:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/welcome Hello Drupal Some time ago, I decided to migrate my blog from DokuWiki to Drupal. Blogging with DokuWiki was OK using the plugins from the DokuWiki Blogsuite BundleHub, but Drupal has some advantages. It's always fascinating to get into a new technology. After using misc. wiki systems and Wordpress, I wanted to try a content management system. I had a quick look into Drupal, Joomla and Silverstripe, and then decided to go with Drupal. text/html 2009-11-27T16:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/relax ReLAX Thanks to Wolfgang Stief and Constantin Gonzalez, I got hold on one of the proceedings of the Linux Kongress and OpenSolaris Developer Conference. In this book, I found amoung other, also very interesting, articles one about LAX by Thomas Groß. LAX has some very interesiting concepts, but, unfortunately, it doesn't fit my needs. So I decided to take some of the concepts of LAX and build my own sysadmin-automation-framework. text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/grant MySQL: Grant Permissions Grant Permissions GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/index MySQL mysql index text/html 2013-02-04T22:17:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/index Cryptography This guide tries to easily describe the terms used in cryptography. As all pages on this site, it's meant as a mnemonic for myself, but I'm happy if someone else finds it helpful too. cryptography index cryptography guide text/html 2013-03-03T14:10:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2011/project_pda Project PDA I'm currently working on a project called 'PDA'. PDA stands for “Personal Digital Assistant”. I used several PDAs over the last two decades, from Sharp, Psion, Palm and others. But they all were just Personal Datastorages. I always missed the text/html 2013-03-15T09:42:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/travian_village_planner Travian Village Planner Currently I'm working on a village planner for Travian. It was inspired by the village planner at <http://www.ebav.co.uk/travian/>, but I was missing a possibility to save and reference my village. So the main feature was saving the village to a bookmark. This is done by the text/html 2010-05-17T07:55:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/how_create_moveable_vm_virtualbox How To Create a Moveable VM with VirtualBox VirtualBox works good when you use the same VMs all the time. It organizes the disk images in one directory and the configuration files in another. It kees a record of all known disk images and virtual machines. text/html 2013-08-02T19:34:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/prog/firefox/index Firefox Start another Firefox To start another instance of firefox, use this command: firefox -P "My Profile" -no-remote For more information visit Opening a new instance of your Mozilla application with another profile in the mozillaZine Knowledge Base. mozilla firefox cli howto text/html 2009-10-26T11:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/geocache_gc1vy11 Found Geocache GC1VY11 "Ringpromenade" Yesterday, I visited my first geocache. For those interested, here is evidence: [geocache logbook] geocache gps outdoor text/html 2013-03-10T21:06:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/mac_command_line_audio Command Line Audio Change Mac Audio Volume from Command Line To change the audio volume from remote of my Mac at home, I needed a command line tool which I can use via ssh. I've found it here: OS X Daily - Change the system volume from the command line. It's as easy as sudo osascript -e "set Volume 10" text/html 2013-10-18T08:01:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2013/welcome_back Welcome Back In 2010 I moved my blog from DokuWiki to Drupal. Today, I moved it back to DokuWiki. The reason for switching to Drupal was for the better blogging support. As I'm using this site more as Knowledge Base than a Blog, DokuWiki is the better alternative. You can still access the old site at old.andunix.net. text/html 2015-02-11T09:25:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2014/foldersync_and_owncloud_7 Workaround for FolderSync with ownCloud 7 The Android App “FolderSync” stopped working when I upgraded my ownCloud to Version 7. FolderSync always showed “Bad Request” when testing the connection. ANd when I looked into the Apache log, the requests were closed with text/html 2013-02-19T14:05:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/jps jps - Java Virtual Machine Process Status Tool The Java Virtual Machine has a jps tool wich is a bit like the ps command. jps lists all java Processes of a user. You can find the man page at <http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html>. I'm using it with the parameters -l (long listing) and -m