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

Cleanup Packages

Anonymous (anonymous@undisclosed.example.com) — 2014-04-28T09:01:22+00:00

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:

Compare a Key with its Certificate

Anonymous (anonymous@undisclosed.example.com) — 2013-02-18T14:26:27+00:00

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

Debug Server Certificate from Client

Anonymous (anonymous@undisclosed.example.com) — 2014-04-28T08:07:54+00:00

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.

Notes for the Solaris 10 System Administration Exam (CX-310-200 & -202)

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

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:

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:

Firefox Extensions

Anonymous (anonymous@undisclosed.example.com) — 2013-09-02T20:37:01+00:00

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.

Oracle: Recovery Manager

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

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:

Git

Anonymous (anonymous@undisclosed.example.com) — 2018-12-06T10:07:22+00:00

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

Android Apps

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

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

Download a Server Certificate

Anonymous (anonymous@undisclosed.example.com) — 2015-02-11T14:42:38+00:00

Download a Server Certificate First, load the certificate chain from the server: openssl s_client -showcerts -connect www.example.org:443

Oracle Errors

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

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

DynDNS Updates without a Client

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

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…

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

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…

localeadm

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

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.

Change Encoding with iconv

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

Change Encoding with iconv Convert Single File iconv -f iso-8859-1 -t utf-8 -o OUTPUT.txt INPUT.txt Converts INPUT.txt from iso-8859-1 to utf-8 and writes it to OUTPUT.txt. Convert All Files in a Directory for f in $(find . -type f) do iconv -f iso-8859-1 -t utf-8 -o ${f}_$$_TEMP ${f} \ && mv ${f}_$$_TEMP ${f} done

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.

Android Backup

Anonymous (anonymous@undisclosed.example.com) — 2013-04-24T12:11:00+00:00

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

MySQL: Remove User

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

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

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 …

Convert a Certificate

Anonymous (anonymous@undisclosed.example.com) — 2014-12-18T15:34:24+00:00

Convert a Certificate Convert DER to PEM openssl x509 -inform der -in testkey.der -out testkey.pem Convert PEM to DER openssl x509 -outform der -in testkey.pem -out testkey.der openssl security cryptography certificate howto

Package Repositories

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

Package Repositories There's a list of multi-OS repositories at . More on IPS, the Image Package System can be found at: * . * Repository Description OpenSolaris Distribution, Releases OpenSolaris Distribution, Development Quality

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…

List Open Ports

Anonymous (anonymous@undisclosed.example.com) — 2017-04-13T20:11:34+00:00

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 …

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.

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

/etc/path_to_inst

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

/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

jps - Java Virtual Machine Process Status Tool

Anonymous (anonymous@undisclosed.example.com) — 2013-02-19T14:05:55+00:00

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 . I'm using it with the parameters -l (long listing) and -m

Increase the Tomcat Upload Limit

Anonymous (anonymous@undisclosed.example.com) — 2017-01-04T09:33:36+00:00

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:

52428800

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

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

MySQL: Remove Database

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

MySQL: Remove Database Remove Database DROP DATABASE IF EXISTS `{db}`; admin database mysql sql

Shell Script Variables

Anonymous (anonymous@undisclosed.example.com) — 2015-10-23T12:39:10+00:00

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

exiftool

Anonymous (anonymous@undisclosed.example.com) — 2016-09-26T19:25:34+00:00

exiftool Rename Photos Try it first with -testname: exiftool -d %Y-%m-%d_%H%M%S%%-c.%%e "-testname

MacPorts

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

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 ...

Print all certificates in a file

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

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.

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

Plaintext

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

Plaintext The plaintext is unencrypted and unsigned text. It's the payload which then get's signed and/or encrypted. Wikipedia defines plaintext as: " In cryptography, plaintext is information a sender wishes to transmit to a receiver. Cleartext is often used as a synonym. Before the computer era, plaintext most commonly meant message text in the language of the communicating parties. Plaintext has reference to the operation of cryptographic algorithms, usually encryption algorithms, and is …

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"

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

init

Anonymous (anonymous@undisclosed.example.com) — 2013-07-03T13:03:11+00:00

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

Command Line Tools Used in My Scripts

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

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

Virtual Network Visualization

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

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

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;

Install the Java-Plugin for Firefox

Anonymous (anonymous@undisclosed.example.com) — 2014-09-05T12:12:53+00:00

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

Clear DNS Cache

Anonymous (anonymous@undisclosed.example.com) — 2016-04-05T06:49:10+00:00

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

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;