andunix.net

VBoxManage (The VirtualBox CLI)

Anonymous (anonymous@undisclosed.example.com) — 2014-02-22T13:16:38+00:00

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 []

Oracle: SQLplus Scripting

Anonymous (anonymous@undisclosed.example.com) — 2013-03-01T20:30:32+00:00

Oracle: SQLplus Scripting To show only data in SQLplus and no header or other stuff, enter the following: SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF

IPS Repository Appliance

Anonymous (anonymous@undisclosed.example.com) — 2010-10-27T12:36:00+00:00

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.

Travian Map Download Script

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:18:02+00:00

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} -…

Simulating slow network connections with trickle

Anonymous (anonymous@undisclosed.example.com) — 2014-01-27T14:38:19+00:00

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)

AirPort Command Line Interface

Anonymous (anonymous@undisclosed.example.com) — 2015-11-25T08:50:59+00:00

AirPort Command Line Interface AirPort On/Off Infos from OS X Daily AirPort On networksetup -setairportpower airport on AirPort Off networksetup -setairportpower airport off Select AirPort Network networksetup -setairportnetwork {Network} AirPort mac osx device wlan cli shell script sysadmin

Set PHP Variables in .htaccess Files

Anonymous (anonymous@undisclosed.example.com) — 2010-04-29T14:07:00+00:00

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.

Set a Mac's Hostname

Anonymous (anonymous@undisclosed.example.com) — 2015-11-25T08:53:23+00:00

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 * mac osx cli sysadmin

Drupal: Reverse Proxy

Anonymous (anonymous@undisclosed.example.com) — 2013-03-12T21:41:05+00:00

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

setup

Anonymous (anonymous@undisclosed.example.com) — 2014-01-27T14:49:51+00:00

setup Pages Bookmarks

Setting the Timezone

Anonymous (anonymous@undisclosed.example.com) — 2013-03-08T10:45:00+00:00

Setting the Timezone The timezone is stored in the file /etc/timezone. Check the Timezone cat /etc/timezone Example: # cat /etc/timezone Europe/London Set the Timezone You can use vi: vi /etc/timezone Or set it directy: echo "Europe/Berlin" > /etc/timezone

settings

Anonymous (anonymous@undisclosed.example.com) — 2014-04-22T11:35:23+00:00

settings Pages Bookmarks

Dice Roller

Anonymous (anonymous@undisclosed.example.com) — 2009-02-18T19:25:00+00:00

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.

Cursor Size

Anonymous (anonymous@undisclosed.example.com) — 2016-07-12T09:43:10+00:00

Cursor Size To change the mouse cursor size in GNOME, use this command. Substitute the value 32 with your prefered size. gsettings set org.gnome.desktop.interface cursor-size 32 desktop gnome linux mouse cursor settings

OpenSolaris / VirtualBox: Mount Shared Folder

Anonymous (anonymous@undisclosed.example.com) — 2009-08-11T10:16:00+00:00

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

Shadows

Anonymous (anonymous@undisclosed.example.com) — 2013-07-11T06:39:41+00:00

Shadows Box Shadow Normal Shadow Only the shadow: box-shadow: 1px 4px 8px #888888; Looks even better with a tiny grey border: border: 1px solid #DDDDDD; box-shadow: 1px 4px 8px #888888; Inset Shadow The shadow inside the box: box-shadow: 1px 4px 8px #888888 inset;

Hello Drupal

Anonymous (anonymous@undisclosed.example.com) — 2010-02-28T23:00:00+00:00

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.

Make your Mac feel at Home

Anonymous (anonymous@undisclosed.example.com) — 2015-11-25T08:53:11+00:00

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}\$")…

Formatting Syntax

Anonymous (anonymous@undisclosed.example.com) — 2020-09-15T19:10:57+00:00

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

base-repo-get-value

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:32+00:00

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.

Oracle: SPFile and PFiles

Anonymous (anonymous@undisclosed.example.com) — 2013-03-01T20:36:05+00:00

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:

MySQL: Backup

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:25+00:00

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…

root login with bash

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:35+00:00

root login with bash On our systems, the root account is set to be a role, so you can't login as root, just su to root from an user which has the root role. Also, the root user has the bourne shell (/bin/sh), but working with /bin/bash is much easier. Using this command, you can directly log in as

Oracle: Resize Instance

Anonymous (anonymous@undisclosed.example.com) — 2013-03-01T20:38:48+00:00

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:

How To Create a Moveable VM with VirtualBox

Anonymous (anonymous@undisclosed.example.com) — 2010-05-17T07:55:00+00:00

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.

Print Information about a Key

Anonymous (anonymous@undisclosed.example.com) — 2015-01-29T09:15:22+00:00

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 …

SSH

Anonymous (anonymous@undisclosed.example.com) — 2015-11-30T12:09:18+00:00

SSH SSH with Public Key Authentication only /etc/ssh/sshd_config Make sure that your SSH config file (sshd_config) contains these settings: PubkeyAuthentication yes PasswordAuthentication no If you changed the config, make sure to restart sshd to activate ist:

Specify Java VM for Eclipse

Anonymous (anonymous@undisclosed.example.com) — 2014-04-22T11:34:42+00:00

Specify Java VM for Eclipse To let Eclipse use the Java VM from /opt/jdk/bin/java add these two lines to the eclipse.ini in the Eclipse installation directory: -vm /opt/jdk/bin/java -vmjava Source: Eclipsepedia: eclipse.ini - Specifying the JVM eclipse java settings

rmdir for OSX

Anonymous (anonymous@undisclosed.example.com) — 2015-11-25T09:43:44+00:00

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

Welcome to your new DokuWiki

Anonymous (anonymous@undisclosed.example.com) — 2020-09-15T19:10:57+00:00

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:

Print Information about a Certificate

Anonymous (anonymous@undisclosed.example.com) — 2015-12-09T07:36:40+00:00

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.

fstyp

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:37+00:00

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…

Convert a Key

Anonymous (anonymous@undisclosed.example.com) — 2019-01-17T19:19:12+00:00

Convert a Key Convert P12 to Java Keystore keytool -importkeystore -srckeystore testkey.p12 -srcstoretype pkcs12 -srcalias 1 -destkeystore testkey.jks -deststoretype jks -destalias testkey You can add -deststorepass PASSWORD to set the password on the command line. If you don't, keytool will ask you for a password.

Mercurial

Anonymous (anonymous@undisclosed.example.com) — 2013-07-15T10:39:59+00:00

Mercurial .hgignore Some handy .hgignore expressions: Ignore Mac Files Ignore .DS_Store and ._* files: (^|/)\._[^/]+$ (^|/)\.DS_Store$ NetBeans These expressions exclude the directories build, dist and nbproject/private. Depending on your project setup, you may want to also exclude

JAX-WS Debugging

Anonymous (anonymous@undisclosed.example.com) — 2014-11-25T10:40:31+00:00

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

Set the Timezone on Debian

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:38+00:00

Set the Timezone on Debian Just run the following command as root (use su or sudo): dpkg-reconfigure tzdata sysadmin linux debian timezone configure

MySQL: Change Password

Anonymous (anonymous@undisclosed.example.com) — 2013-12-17T09:09:25+00:00

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;

Serial Protocol

Anonymous (anonymous@undisclosed.example.com) — 2014-02-02T11:19:35+00:00

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:

base-exec-user

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:31+00:00

base-exec-user Executes a command as a given user. Command is executed using ssh if the user is not on localhost. Usage base-exec-user USER COMMAND * USER: A key of an user definition in the repository. From this, the following properties are used:

base-ssh-login

Anonymous (anonymous@undisclosed.example.com) — 2013-02-04T22:17:32+00:00

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:

Memory Usage of a Solaris Container (Zone)

Anonymous (anonymous@undisclosed.example.com) — 2010-04-21T08:17:00+00:00

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.

Command Line Audio

Anonymous (anonymous@undisclosed.example.com) — 2013-03-10T21:06:49+00:00

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"

MySQL: Create User

Anonymous (anonymous@undisclosed.example.com) — 2016-01-25T11:49:04+00:00

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}'@'%';

Generate a Test Key

Anonymous (anonymous@undisclosed.example.com) — 2014-11-20T08:13:01+00:00

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…