andunix.net

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…

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

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…

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;

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

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

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:

MySQL: Create Database

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

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

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

MySQL: Grant Permissions

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

MySQL: Grant Permissions Grant Permissions GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql

MySQL: View Permissions

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

MySQL: View Permissions View Permissions SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; admin database mysql sql

MySQL: Revoke Permissions

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

MySQL: Revoke Permissions Revoke Permissions REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; admin database mysql sql

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

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:

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.

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"

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

MySQL

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

MySQL mysql index

Firefox

Anonymous (anonymous@undisclosed.example.com) — 2013-08-02T19:34:46+00:00

Firefox Start another Firefox To start another instance of firefox, use this command: firefox -P "My Profile" -no-remote For more information visit Opening a new instance of your Mozilla application with another profile in the mozillaZine Knowledge Base. mozilla firefox cli howto

Cryptography

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

Cryptography This guide tries to easily describe the terms used in cryptography. As all pages on this site, it's meant as a mnemonic for myself, but I'm happy if someone else finds it helpful too. cryptography index cryptography guide