https://old.andunix.net/ 2026-06-04T01:10:28+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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 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 2014-02-22T13:16:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/virtualbox/cli VBoxManage (The VirtualBox CLI) This is a online reference of the output of VBoxManage without options. Oracle VM VirtualBox Command Line Management Interface Version 4.2.16 (C) 2005-2013 Oracle Corporation All rights reserved. Usage: VBoxManage [<general option>] <command> text/html 2014-04-28T09:01:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/cleanup_packages Cleanup Packages Purge uninstalled Packages If a package is removed, it is only uninstalled, but the configuration remains on the system. This is a good thing, as you are able to reinstall the package and have it configured with the old configuration. But if you want to cleanup this old stuff, you can ge a list of uninstalled (but not purged) packages with this command: 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 2010-10-27T12:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/ips_repository_appliance IPS Repository Appliance Brian Leonard wrote a good guide how to setup a Local Repository Mirror. If you are in a hurry, it's good to know that you don't need to copy the entire repository of about 8GB to a local disk. You can use the repository image directly. Here is how you can do that. text/html 2009-08-11T15:06:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/zfs_playground ZFS Playground This small demo shows the basic ZFS operations. You will need a Solaris 10 or OpenSolaris host and 1,2GB of disk space. Preparation First, go to a directory where you have enought space. We will need 1,2GB for 6 files of 200MB. The files are named like disks, but they are only files for this demo. text/html 2013-03-01T20:58:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/localeadm localeadm The localeadm utility queries and configures Solaris locales through a command line interface. * man page: localeadm(1M) Preparation Check your Solaris Release with cat /etc/release and get a matching DVD or ISO image. If you're using an ISO image, you have to mount it (insert your path in the first line. 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:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/android/apps Android Apps Here are some links to Android Apps I'm using. Where available, there are both links, the paid and the free version. * Barcode Scanner * DavDrive / DavDrive Lite * DGT GTD & To-do List * Gleeo Time Tracker * K-9 Mail * KeePassDroid * Note Everything * Öffi - ÖPNV Auskunft * WebDAV Navigator / WebDAV Navigator Lite * Zeiterfassung Pro / Zeiterfassung android app list recommendation text/html 2013-03-01T20:24:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/rman Oracle: Recovery Manager Start Recovery Manager rman target / Delete Archive Logs Delete all archive logs but keep the last 45 days: DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; To remove archive logs older than 3 days without prompting, e.g. via cron, after backup run: text/html 2009-08-11T10:16:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/opensolaris_virtualbox_mount_shared_folder OpenSolaris / VirtualBox: Mount Shared Folder To mount a shared folder in a OpenSolaris guest in VirtualBox, you have to install the Guest Additions and then mount the file system type vboxfs. The Usage is: mount -F vboxfs <share> <mountpoint> text/html 2013-09-02T20:37:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/prog/firefox/extensions Firefox Extensions Browsing Extensions Extension Description Adblock Plus A must-have. Blocks all these blinking ads which are so anoying. Greasemonkey Customize webpages using JavaScript. WOT, Web of Trust Information about the reputation of a page. Self-Destructing Cookies Removes cookies after closing the tab or navigating to another site. text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/welcome Welcome to your new DokuWiki Congratulations, your wiki is now up and running. Here are a few more tips to get you started. Enjoy your work with DokuWiki, -- the developers Create your first pages Your wiki needs to have a start page. As long as it doesn't exist, this link will be red: 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 2015-10-23T12:39:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/variables Shell Script Variables Last Character Get the last character of $a: ${a: -1} Remove Slash from the End of a Variable Remove a trailing slash from $a: a=${a%/} scripting bash sysadmin variable 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 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 2015-11-25T09:43:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/rmdir rmdir for OSX The Finder on OSX creates .DS_Store files in the directories to store its settings. This makes removing directories from the command line quite complicated: $ rmdir test rmdir: test: Directory not empty $ rm test/.DS_Store $ /bin/rmdir test text/html 2013-03-16T09:04:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/index Blog Archive text/html 2013-02-04T22:17:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/pkg_repositories Package Repositories There's a list of multi-OS repositories at <http://wikis.sun.com/display/IpsBestPractices/Directory+of+Package+Repositories>. More on IPS, the Image Package System can be found at: * <http://www.opensolaris.org/os/project/pkg/>. * <http://wikis.sun.com/display/IpsBestPractices/> Repository Description <http://pkg.opensolaris.org/release/> OpenSolaris Distribution, Releases <http://pkg.opensolaris.org/dev/> OpenSolaris Distribution, Development Quality text/html 2014-01-27T14:38:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2014/simulating_slow_network_connections_with_trickle Simulating slow network connections with trickle You can limit the downlink of a Firefox browser to 512 KB/s with this command: trickle -d 512 /usr/bin/firefox -no-remote -P test More informations can be found on these pages: * trickle Homepage * Trickle in the Ubunutuuser Wiki (german) 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-01T20:43:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/error Oracle Errors ORA-00257: archiver error. Connect internal only, until freed. * Reason: The flash recovery area is full. * Resolution: Remove archive logs. * Resolution: Enlarge the flash recovery area. * Documentation: 10.2 11.2 database documentation error oracle reference text/html 2013-03-01T20:36:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/spfile_and_pfiles Oracle: SPFile and PFiles Oracle reads its parameters from a file called “SPFile”. You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from “PFiles”, which are regular text files. Create PFile To export the SPFiles to a PFile, just enter the following in SQLplus: text/html 2017-01-04T09:33:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/sysadmin/tomcat_upload_limit Increase the Tomcat Upload Limit The “manager”-App of the Tomcats has a limit of 50MiB. This limit is defined in the file WEB-INF/web.xml within the “manager”-App: <multipart-config> <!-- 50MB max --> <max-file-size>52428800</max-file-size> <max-request-size>52428800</max-request-size> <file-size-threshold>0</file-size-threshold> </multipart-config> 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 2015-11-25T08:59:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/macports MacPorts List Ports list requested ports: port echo requested | cut -d ' ' -f 1 | uniq list installed ports: port -qv installed Housekeeping When ports are updated, the old port is only deactivated, not uninstalled: ... autoconf @2.69_2 autoconf @2.69_3 autoconf @2.69_5 ... text/html 2016-04-05T06:49:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/clear_dns_cache Clear DNS Cache To clear the DNS cache on OS X, you first have to flush the cache and then send a signal the the 'mDNSResponder'. dscacheutil -flushcache sudo killall -HUP mDNSResponder mac osx sysadmin dns cache cli text/html 2013-02-14T22:22:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/index Projects p index Project Archive z index text/html 2013-02-03T11:12:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/andunix-tool/index andunix-tool Usage: java -jar andunix-tool.jar <Global Options> <Command> <Command Options> Tip: I suggest to create a shell-script to ease the java starting: #! /bin/sh # Change this to the directory in which you put ''andunix-tool.jar'' # and the corresponding ''lib'' directory ANDUNIX_TOOL_DIR=${HOME}/opt/andunix-tool # Use this to define the path to your Java-Intallation JAVA_HOME=/opt/jdk exec ${JAVA_HOME}/bin/java -jar ${ANDUNIX_TOOL_DIR}/andunix-tool.jar $* text/html 2010-10-04T12:33:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/upgrade_solaris_11opensolaris_text_graphical Upgrade Solaris 11/OpenSolaris from Text to Graphical If you installed your system using the text installer, the system will only be installed with a text interface. Here is how to upgrade to a graphical system. Do the following as root (su) or with appropriate permissions ( text/html 2014-02-02T11:19:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/dmx/protocol Serial Protocol For the communication between the host (PC) and the controller (Arduino), there is a serial protocol over USB. The protocol is line by line, with carriage return (“\n”) as end. The first character denotes the type of command or information. The following commands have been defined: text/html 2009-02-18T19:25:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/dice_roller Dice Roller I programmend a small dice roller in javascript. You enter the number of dice, sides and the offset and press the button “roll”. The script shows the individual dice and the resulting sum. For convenience, there is a second form where you can just enter the number of dice and press the butten for the type of dice. At the bottom, there are some links of six- and eightsided dice, which are often needed in roleplaying games. You can also create bookmarks for dice, e.g. text/html 2014-02-02T12:02:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/dmx/program Program The controller (Arduino) can be programmed to animate the value on a DMX channel from one value to another. The contoller has an program counter which is counted up by one every iteration. The iterations will be 5ms (200Hz), 10ms (100 Hz) or 20ms (50 Hz) long. The value of the program counter ist exchanged between the host an the controller with the command text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/cloudtable/sidebar Project Archive z index Tags text/html 2010-04-29T14:07:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/set_php_variables_htaccess_files Set PHP Variables in .htaccess Files If your PHP scripts run longer than the maximum execution time set by your webhoster, then you will see a message like this: Fatal error: Maximum execution time of 30 seconds exceeded in ... To override the default for your webspace, you can use the php_value directive in a .htaccess file. 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 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:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-ssh-login base-ssh-login Logs into a remote host using ssh. This can be used to open a remote sesssion, but ususally it's used by other methods (especially base-exec-user) to remotely execute a command. Usage base-ssh-login SERVICE [ COMMAND ] * SERVICE: a key of an user or host definition in the repository. From this, the following properties are used: 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:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-repo-get-value base-repo-get-value Loads a service configuration from the repository and outputs a single value (for the given key) to STDOUT. Usage base-repo-get-value SERVICE KEY * SERVICE: A key of a service definition in the repository. * KEY: The key for the value in the service definition to output. text/html 2014-02-08T23:44:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/sidebar Project Archive z index Tags text/html 2013-03-01T17:44:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/index Project Archive z index text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/sidebar Project Archive z index Tags text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/sidebar Project Archive z index Tags text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/sidebar Project Archive z index Tags text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/host/sidebar Project Archive z index Tags text/html 2014-04-28T08:58:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/sidebar Project Archive z index Tags text/html 2017-04-13T20:11:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/sysadmin/list_open_ports List Open Ports To list the open ports together with the listening processes: netstat -tulpn Here is an example output: Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 695/sshd tcp6 0 0 :::22 :::* LISTEN 695/sshd udp 0 0 0.0.0.0:55872 … text/html 2014-11-25T10:40:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/jax-ws_debugging JAX-WS Debugging If you use the builtin JAX-WS implementation and want to see the SOAP requests and responses, you have to turn on the “dump” option in the transport pipe. The system property to set depends on your Java version. com.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true com.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump=true com.sun.xml.ws.transport.http.HttpAdapter.dump=true com.sun.xml.internal.ws.transport.http.HttpAdapter.dump=true text/html 2014-09-05T12:12:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/firefox_java-plugin Install the Java-Plugin for Firefox To install the Java plugin for Firefox, you have to create a symlink from Firefox's plugin directory /usr/lib/firefox-addons/plugins/ to the file libnpjp2.so in the JRE's “lib” dir. sudo ln -s \ ${JAVA_HOME}/jre/lib/amd64/libnpjp2.so \ /usr/lib/firefox-addons/plugins/libnpjp2.so text/html 2013-02-18T14:26:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/compare_key_with_certificate Compare a Key with its Certificate Credit for this example goes to “Verifying that a Private Key Matches a Certificate” from the University of Wisconsin Knowledgebase. To see if a key server.key belongs to the certificate server.crt, they need to have the same “modulus” and “exponent”. openssl x509 -noout -text -in server.crt openssl rsa -noout -text -in server.key text/html 2013-03-02T19:19:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/cloudtable/index CloudTable Big Picture This concept-image shows the currently planned architecture. [CloudTable Big Picture Draft 1] The core appears as a single block for now, it will be broken up in a second version of the drawing. The config store stores the informations about the forms, tables and applications. Also the users will be stored here. The data store stores the 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 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-04-24T12:11:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/android/backup Android Backup To backup your device, use this command. It will automatically insert the current date in the filename: adb backup -apk -shared -all -f $(date '+%Y-%m-%d').db If you are havong problems with the connection (“adb: unable to connect for backup text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/analyzer_bookmarklet Travian Analyzer Bookmarklet Installation First, save a bookmark with title “Analyze” and the location javascript:top.location.href=((String(window.getSelection()).length>0)?'http://travian.ws/analyser.pl?s=de7&q='+window.getSelection():top.location.href.replace(/http:\/\/welt7\.travian\.de\/(spieler|allianz)\.php\?/,'http://travian.ws/analyser.pl?s=de7&')) 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.