andunix.net

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

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

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)

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.

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.

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

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.

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

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;

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

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.

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.

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:

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

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

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

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…

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.

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

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:

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;

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

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:

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

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…