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

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

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;

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

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

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

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:

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

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

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.

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:

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

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

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…

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…

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

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.

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;

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

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