https://old.andunix.net/ 2026-06-04T05:25:34+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2014-02-22T13:16:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/virtualbox/cli 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 [<general option>] <command> text/html 2013-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/exam_notes 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: text/html 2013-02-04T22:17:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/dyndns_updates_without_client 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… text/html 2013-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/dladm2dot 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 text/html 2013-04-24T12:11:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/android/backup 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 text/html 2015-11-25T08:50:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/airport 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 text/html 2013-07-15T10:39:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/hg 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 text/html 2014-04-28T08:07:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/debug_server_certificate_from_client 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. text/html 2014-04-28T09:01:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/cleanup_packages 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: text/html 2015-11-25T08:59:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/macports 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 ... text/html 2013-03-01T20:36:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/spfile_and_pfiles 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: text/html 2013-02-19T14:05:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/jps 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 <http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html>. I'm using it with the parameters -l (long listing) and -m text/html 2013-07-03T13:03:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/init 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 text/html 2016-10-01T19:54:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/disable_service Disable a Service To disable a service: service <service> stop update-rc.d <service> enable|disable With systemd (starting with Debian 8): systemctl disable <service> To (re)enable a service: update-rc.d <service> enable|disable service <service> stop text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/backup 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… text/html 2018-12-06T10:07:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/code/git 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 text/html 2013-12-17T09:09:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/password 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; text/html 2013-03-01T20:30:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/sqlplus_scripting 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 text/html 2017-01-04T09:33:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/sysadmin/tomcat_upload_limit 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: <multipart-config> <!-- 50MB max --> <max-file-size>52428800</max-file-size> <max-request-size>52428800</max-request-size> <file-size-threshold>0</file-size-threshold> </multipart-config> text/html 2013-03-01T20:24:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/rman 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: text/html 2013-03-01T20:38:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/resize_instance 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: text/html 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/create 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}'@'%'; text/html 2013-02-04T22:17:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/plaintext 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 … text/html 2016-04-05T06:49:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/clear_dns_cache 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 text/html 2013-03-01T20:58:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/localeadm 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. text/html 2013-02-04T22:17:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/root_login_with_bash 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