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

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;

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…

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

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

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

password

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

password Pages Bookmarks

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.

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

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.

base-net-load-url

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

base-net-load-url Loads a file from an URL and outputs it to STDOUT. Usage base-net-load-url URL * URL: the URL to load. Returns Returns the contents of the resource referenced by the URL. Examples base-net-load-url "${service_url}" PASSWORD=$(base-net-load-url ${PASSWORD_URL})

WiFi Config QR-Code

Anonymous (anonymous@undisclosed.example.com) — 2016-07-14T06:40:34+00:00

WiFi Config QR-Code To generate a qr-code for a wifi config, you must encode the following URL in the qr-code: WIFI:S:;T:;P:;; If the network is hidden, then add H:true;: WIFI:S:;T:;P:;H:true;; You can try it here:

host-user-tab

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

host-user-tab Lists the users on a given host as a colon separated table. Usage host-user-tab HOST * HOST: a key of a host service definition in the repository. Returns Returns the contents of the /etc/passwd file.

host-user-list

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

host-user-list Lists the users on a given host. Usage host-user-tab HOST * HOST: a key of a host service definition in the repository. Returns Returns the first colum (login) of the /etc/passwd file. Example users=$(host-user-list "${host}" \ | egrep -v "${IGNORED_USERS}" )

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: