<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://old.andunix.net/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://old.andunix.net/feed.php">
        <title>andunix.net</title>
        <description></description>
        <link>https://old.andunix.net/</link>
        <image rdf:resource="https://old.andunix.net/_media/favicon.ico" />
       <dc:date>2026-06-03T23:26:45+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://old.andunix.net/info/virtualbox/cli"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/linux/debian/cleanup_packages"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/rman"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/accounts_with_objects"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/exam_notes"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/user/create"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/print_all_certificates_in_a_file"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/java/jps"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/compare_directories"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/webdesign/css/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/android/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/localeadm"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/dyndns_updates_without_client"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/prog/firefox/extensions"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/database/create"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/exp"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/generate_key"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/android/backup"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/permissions/grant"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/macports"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/iconv"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/permissions/revoke"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/database/backup"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/exiftool"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://old.andunix.net/_media/favicon.ico">
        <title>andunix.net</title>
        <link>https://old.andunix.net/</link>
        <url>https://old.andunix.net/_media/favicon.ico</url>
    </image>
    <item rdf:about="https://old.andunix.net/info/virtualbox/cli">
        <dc:format>text/html</dc:format>
        <dc:date>2014-02-22T13:16:38+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>VBoxManage (The VirtualBox CLI)</title>
        <link>https://old.andunix.net/info/virtualbox/cli</link>
        <description>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 [&lt;general option&gt;] &lt;command&gt;</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/linux/debian/cleanup_packages">
        <dc:format>text/html</dc:format>
        <dc:date>2014-04-28T09:01:22+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Cleanup Packages</title>
        <link>https://old.andunix.net/info/linux/debian/cleanup_packages</link>
        <description>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:</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/rman">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:24:52+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: Recovery Manager</title>
        <link>https://old.andunix.net/info/oracle/rman</link>
        <description>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:</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/accounts_with_objects">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:26:48+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: List Accounts with Objects</title>
        <link>https://old.andunix.net/info/oracle/accounts_with_objects</link>
        <description>Oracle: List Accounts with Objects

To list all accounts (users) the objects (like tables), you can query them with:


SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER;


If you want to list all accounts, you can query them with:


SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/solaris/exam_notes">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:36+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Notes for the Solaris 10 System Administration Exam (CX-310-200 &amp; -202)</title>
        <link>https://old.andunix.net/info/solaris/exam_notes</link>
        <description>Notes for the Solaris 10 System Administration Exam (CX-310-200 &amp; -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:</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/user/create">
        <dc:format>text/html</dc:format>
        <dc:date>2016-01-25T11:49:04+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Create User</title>
        <link>https://old.andunix.net/info/mysql/user/create</link>
        <description>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}'@'%';</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/print_all_certificates_in_a_file">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-18T14:27:02+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Print all certificates in a file</title>
        <link>https://old.andunix.net/info/cryptography/openssl/print_all_certificates_in_a_file</link>
        <description>Print all certificates in a file

This command is especially helpful if you want to use Tomcat-/Java-Keystore-Certificates with the Apache webserver.
Use the -print_certs to print all the certificates and then cut the file and store each certificate in a single file.</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/java/jps">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-19T14:05:55+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>jps - Java Virtual Machine Process Status Tool</title>
        <link>https://old.andunix.net/info/java/jps</link>
        <description>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 &lt;http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html&gt;.
I'm using it with the parameters -l (long listing) and -m</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/compare_directories">
        <dc:format>text/html</dc:format>
        <dc:date>2018-09-19T12:34:39+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Compare directories</title>
        <link>https://old.andunix.net/info/script/compare_directories</link>
        <description>Compare directories

For each of the directories, generate a digest file:


find DIR -type f -exec shasum {} + | LC_ALL=C sort -d -k 2 &gt; shasums.txt


It's important to use LC_ALL=C and the option -d of sort, to get compareable results on different machines.</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/webdesign/css/index">
        <dc:format>text/html</dc:format>
        <dc:date>2013-07-11T06:43:48+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>CSS - Cascading Stylesheets</title>
        <link>https://old.andunix.net/info/webdesign/css/index</link>
        <description>CSS - Cascading Stylesheets

Pages
css index


Links

German CSS Reference Links:

	*  SELFHTML - CSS Kurzreferenz: im DEV Netz de.selfhtml.org
	*  CSS 4 you - CSS-Referenz: www.css4you.de

More CSS Bookmarks:

webdesign css</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/android/index">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:18+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Android</title>
        <link>https://old.andunix.net/info/android/index</link>
        <description>Android
android index


Android Bookmarks

android</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/index">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:21+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Cryptography</title>
        <link>https://old.andunix.net/info/cryptography/index</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/solaris/localeadm">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:58:12+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>localeadm</title>
        <link>https://old.andunix.net/info/solaris/localeadm</link>
        <description>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.</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/dyndns_updates_without_client">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:34+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>DynDNS Updates without a Client</title>
        <link>https://old.andunix.net/info/script/dyndns_updates_without_client</link>
        <description>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 &quot;$(date '+%Y-%m-%d %H:%M') $(basename $0)&quot;
for domain in ${DOMAINS}; do
        echo -n &quot;  ${domain} - &quot;
        curl --silent --show-error --insecure --user ${LOGIN} &quot;${UPDATE_URL}?hostname=${domain}&quot;
d…</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/prog/firefox/extensions">
        <dc:format>text/html</dc:format>
        <dc:date>2013-09-02T20:37:01+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Firefox Extensions</title>
        <link>https://old.andunix.net/info/prog/firefox/extensions</link>
        <description>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.</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/database/create">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:25+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Create Database</title>
        <link>https://old.andunix.net/info/mysql/database/create</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/exp">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:40:57+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: EXP</title>
        <link>https://old.andunix.net/info/oracle/exp</link>
        <description>Oracle: EXP

Export all Objects from an Account

Enter the account name insteand of {user}.


exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user}


admin exp oracle</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/generate_key">
        <dc:format>text/html</dc:format>
        <dc:date>2014-11-20T08:13:01+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Generate a Test Key</title>
        <link>https://old.andunix.net/info/cryptography/openssl/generate_key</link>
        <description>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…</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/android/backup">
        <dc:format>text/html</dc:format>
        <dc:date>2013-04-24T12:11:00+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Android Backup</title>
        <link>https://old.andunix.net/info/android/backup</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/permissions/grant">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:26+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Grant Permissions</title>
        <link>https://old.andunix.net/info/mysql/permissions/grant</link>
        <description>MySQL: Grant Permissions

Grant Permissions


GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%';


admin database mysql sql</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mac/macports">
        <dc:format>text/html</dc:format>
        <dc:date>2015-11-25T08:59:36+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MacPorts</title>
        <link>https://old.andunix.net/info/mac/macports</link>
        <description>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 
...</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/iconv">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:34+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Change Encoding with iconv</title>
        <link>https://old.andunix.net/info/script/iconv</link>
        <description>Change Encoding with iconv

Convert Single File
iconv -f iso-8859-1 -t utf-8 -o OUTPUT.txt INPUT.txt
Converts INPUT.txt from iso-8859-1 to utf-8 and writes it to OUTPUT.txt.

Convert All Files in a Directory


for f in $(find . -type f)
do
  iconv -f iso-8859-1 -t utf-8 -o ${f}_$$_TEMP ${f} \
  &amp;&amp; mv ${f}_$$_TEMP ${f}
done</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/permissions/revoke">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:26+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Revoke Permissions</title>
        <link>https://old.andunix.net/info/mysql/permissions/revoke</link>
        <description>MySQL: Revoke Permissions

Revoke Permissions


REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%';


admin database mysql sql</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/database/backup">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:25+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Backup</title>
        <link>https://old.andunix.net/info/mysql/database/backup</link>
        <description>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 &quot;+%Y-%m-%d&quot;)
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} &gt; ${DB}_${DATE_YMD}.sql &amp;
    bzip2 ${DB}_${DATE_YMD}.sql &amp;
    # sleep 10 # option…</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/exiftool">
        <dc:format>text/html</dc:format>
        <dc:date>2016-09-26T19:25:34+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>exiftool</title>
        <link>https://old.andunix.net/info/script/exiftool</link>
        <description>exiftool

Rename Photos

Try it first with -testname:
exiftool -d %Y-%m-%d_%H%M%S%%-c.%%e &quot;-testname&lt;CreateDate&quot; *.jpg
Then rename the files:
exiftool -d %Y-%m-%d_%H%M%S%%-c.%%e &quot;-filename&lt;CreateDate&quot; *.jpg
Correct the Date of Photos

To shift the photos 43 days, 14 hours and 55 minutes to the future:</description>
    </item>
</rdf:RDF>
