https://old.andunix.net/ 2026-06-03T22:03:57+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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 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: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 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 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 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 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-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 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 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 2009-04-27T11:30:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/project_idea_wikitable Project Idea: WikiTable I'm using wikis a lot but every wiki I tried so far lacks support for tables. The wikis are able to show tables, but building a table using lots of pipes “|” sucks. What I want to develop (or learn that such a this already exists) is a small application which creates tables which then can be included in wiki pages. text/html 2009-07-21T17:52:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/virtual_network_visualization Virtual Network Visualization OpenSolaris supports virtual networks using virtual interfaces connected with virtual switches. This feature was introduced with Project Crossbow in OpenSolaris 2009.06. To visualize the internal network(s), I created a perl script which takes the output of dladm show-link and generates a dot-File, which then can be rendered using 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 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-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 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 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-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-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:53:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2011/start_and_stop_apple_file_server_command_line Start and Stop the Apple File Server from Command Line You can use /sbin/service to start or stop the “Personal File Sharing”. Start the Apple File Server (“Personal File Sharing”): sudo /sbin/service com.apple.AppleFileServer start And likewise stop it: 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:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/dladm2dot Virtual Network Visualization OpenSolaris supports virtual networks using virtual interfaces connected with virtual switches. This feature was introduced with Project Crossbow in OpenSolaris 2009.06. To visualize the internal network(s), I created a perl script which takes the output of 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-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 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 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 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 2014-05-16T06:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/disable_core_dumps Disable Core Dumps To disable core dumps create a file /etc/security/limits.d/no_core_dumps with the content * hard core 0: echo '* hard core 0' > /etc/security/limits.d/no_core_dumps Based on the “Nix Craft” article Linux Disable Core Dumps. linux sysadmin admin config 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 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/dokuwiki DokuWiki wiki:dokuwiki DokuWiki is a simple to use and highly versatile Open Source wiki software that doesn't require a database. It is loved by users for its clean and readable Formatting Syntax. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in 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 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-01T20:38:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/resize_instance Oracle: Resize Instance In this example, the SGA will be resized to 6GB and the PGA to 2GB. First, change the SPFile: ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; Then, (optionally) export the SPFile to a PFile: 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-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 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}\$")…