https://old.andunix.net/ 2026-06-03T20:36:55+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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 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 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: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 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 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 2015-11-25T08:53:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/hostname Set a Mac's Hostname To set the permanent hostname, use the scutil utility (enter the desired hostname instead of the_hostname): sudo scutil --set HostName the_hostname Credits * <http://osxdaily.com/2010/09/06/change-your-mac-hostname-via-terminal/> mac osx cli sysadmin 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 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-11-20T08:13:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/generate_key Generate a Test Key openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout testkey.key -out testkey.crt Informations about the used arguments from the OpenSSL man page: * req: PKCS#10 certificate request and certificate generating utility. * -x509: this option outputs a self signed certificate instead of a certificate request. This is typically used to generate a test certificate or a self signed root CA. The extensions added to the certificate (if any) are specified in the configurati… text/html 2016-09-26T19:25:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/exiftool exiftool Rename Photos Try it first with -testname: exiftool -d %Y-%m-%d_%H%M%S%%-c.%%e "-testname<CreateDate" *.jpg Then rename the files: exiftool -d %Y-%m-%d_%H%M%S%%-c.%%e "-filename<CreateDate" *.jpg Correct the Date of Photos To shift the photos 43 days, 14 hours and 55 minutes to the future: text/html 2013-03-01T20:26:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/accounts_with_objects Oracle: List Accounts with Objects To list all accounts (users) the objects (like tables), you can query them with: SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; If you want to list all accounts, you can query them with: SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; text/html 2009-02-25T11:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/travian_village_planner_-_tribe_and_village_name Travian Village Planner - Tribe & Village Name Yesterday, I had some time and worked on the Village Planner. It now has an input field for the name of the village and you can select your tribe. Both informations are saved to the URL when clicking on “make bookmark”. The tribe is saved as parameter 't' and the name as 'n'. 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:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/fstyp fstyp fstyp reports the type of file system. With the -v (verbose) option reports even more informations. * man page: fstyp(1M) Example UFS: ''fstyp'' fstyp /dev/rdsk/c1t0d0s0 ufs UFS: ''fstyp -v'' fstyp -v /dev/rdsk/c1t0d0s0 ufs magic 11954 format dynamic time Wed Dec 23 17:26:29 2009 sblkno 16 cblkno 24 iblkno 32 dblkno 760 sbsize 2048 cgsize 8192 cgoffset 64 cgmask 0xffffffc0 ncg 427 size 20972160 blocks 20654449 bsize 819… text/html 2013-02-18T14:27:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_all_certificates_in_a_file Print all certificates in a file This command is especially helpful if you want to use Tomcat-/Java-Keystore-Certificates with the Apache webserver. Use the -print_certs to print all the certificates and then cut the file and store each certificate in a single file. 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 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 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 2018-12-06T10:07:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/code/git Git Basics Init Repository Standard: git init [DIR] Bare: git init --bare [DIR] Log See commits between branches: git log master..develop Branches List Branches git branch Switch Branch git checkout BRANCH Delete Branch git branch -d BRANCH Delete Remote Branch 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 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-04-28T08:07:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/debug_server_certificate_from_client Debug Server Certificate from Client Credit for this example goes to “ Checking A Remote Certificate Chain With OpenSSL” from langui.sh. openssl s_client -showcerts -connect www.andunix.net:443 Informations about the used arguments from the OpenSSL man page: * s_client: SSL/TLS client program * -showcerts: display the whole server certificate chain: normally only the server certificate itself is displayed. text/html 2015-12-09T07:36:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_certificate Print Information about a Certificate openssl x509 -in testkey.crt -noout -text Informations about the used arguments from the OpenSSL man page: * x509: Certificate display and signing utility. * -in testkey.crt: This specifies the input filename to read a certificate from or standard input if this option is not specified. text/html 2015-01-29T09:15:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_key Print Information about a Key openssl x509 -inform DER -in testkey.cer -noout -text Informations about the used arguments from the OpenSSL man page: * x509: Certificate display and signing utility. * -inform DER: This specifies the input format normally the command will expect an X509 certificate but this can change if other options such as -req are present. The DER format is the DER encoding of the certificate and PEM is the base64 encoding of the DER encoding with header and footer lines … 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 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 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-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 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-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/etc/path_to_inst /etc/path_to_inst * path_to_inst(4) The file /etc/path_to_inst maps physical device paths to driver name and driver instance number. Example: e1000g0 "/pci@0/pci@0/pci@1/pci@0/pci@2/network@0" 0 "e1000g" solaris config device text/html 2013-03-01T20:40:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/exp Oracle: EXP Export all Objects from an Account Enter the account name insteand of {user}. exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} admin exp oracle 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-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 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 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-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)