<?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-04T05:25:03+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/android/apps"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/localeadm"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/java/jps"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/java/firefox_java-plugin"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/plaintext"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/mac_command_line_audio"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/exam_notes"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/debug_server_certificate_from_client"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/rman"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/dladm2dot"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/sqlplus_scripting"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/compare_key_with_certificate"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/prog/firefox/extensions"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/make_your_mac_feel_home"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/spfile_and_pfiles"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/database/backup"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/link/dokuwiki_plugins"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/root_login_with_bash"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/code/git"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/javascript/autosubmit"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/pkg_repositories"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/user/password"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mysql/user/create"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/sysadmin/tomcat_upload_limit"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/accounts_with_objects"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/hg"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/convert_key"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/macports"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/prog/firefox/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/rmdir"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/filesystem"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/print_certificate"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/compact_sparseimage"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/print_key"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/mac/index"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/fstyp"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/tools"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/script/dyndns_updates_without_client"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/solaris/etc/path_to_inst"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/oracle/resize_instance"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/linux/debian/timezone"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/sysadmin/list_open_ports"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/cryptography/openssl/download_server_certificate"/>
                <rdf:li rdf:resource="https://old.andunix.net/info/java/jax-ws_debugging"/>
            </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/android/apps">
        <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 Apps</title>
        <link>https://old.andunix.net/info/android/apps</link>
        <description>Android Apps

Here are some links to Android Apps I'm using.
Where available, there are both links, the paid and the free version.

	*  Barcode Scanner
	*  DavDrive / DavDrive Lite
	*  DGT GTD &amp; To-do List
	*  Gleeo Time Tracker
	*  K-9 Mail
	*  KeePassDroid
	*  Note Everything
	*  Öffi - ÖPNV Auskunft
	*  WebDAV Navigator / WebDAV Navigator Lite
	*  Zeiterfassung Pro / Zeiterfassung

android app list recommendation</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/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/java/firefox_java-plugin">
        <dc:format>text/html</dc:format>
        <dc:date>2014-09-05T12:12:53+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Install the Java-Plugin for Firefox</title>
        <link>https://old.andunix.net/info/java/firefox_java-plugin</link>
        <description>Install the Java-Plugin for Firefox

To install the Java plugin for Firefox, you have to create a symlink from Firefox's plugin directory /usr/lib/firefox-addons/plugins/ to the file libnpjp2.so in the JRE's “lib” dir.


sudo ln -s \
  ${JAVA_HOME}/jre/lib/amd64/libnpjp2.so \
  /usr/lib/firefox-addons/plugins/libnpjp2.so</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/plaintext">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:20+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Plaintext</title>
        <link>https://old.andunix.net/info/cryptography/plaintext</link>
        <description>Plaintext

The plaintext is unencrypted and unsigned text.
It's the payload which then get's signed and/or encrypted.

Wikipedia defines plaintext as:

	&quot; 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 …</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mac/mac_command_line_audio">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-10T21:06:49+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Command Line Audio</title>
        <link>https://old.andunix.net/info/mac/mac_command_line_audio</link>
        <description>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 &quot;set Volume 10&quot;</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/cryptography/openssl/debug_server_certificate_from_client">
        <dc:format>text/html</dc:format>
        <dc:date>2014-04-28T08:07:54+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Debug Server Certificate from Client</title>
        <link>https://old.andunix.net/info/cryptography/openssl/debug_server_certificate_from_client</link>
        <description>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.</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/solaris/dladm2dot">
        <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>Virtual Network Visualization</title>
        <link>https://old.andunix.net/info/solaris/dladm2dot</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/sqlplus_scripting">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:30:32+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: SQLplus Scripting</title>
        <link>https://old.andunix.net/info/oracle/sqlplus_scripting</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/compare_key_with_certificate">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-18T14:26:27+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Compare a Key with its Certificate</title>
        <link>https://old.andunix.net/info/cryptography/openssl/compare_key_with_certificate</link>
        <description>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</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/mac/make_your_mac_feel_home">
        <dc:format>text/html</dc:format>
        <dc:date>2015-11-25T08:53:11+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Make your Mac feel at Home</title>
        <link>https://old.andunix.net/info/mac/make_your_mac_feel_home</link>
        <description>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=&quot;/System/Library/PrivateFrameworks/Apple80211.framework/Versions/Current/Resources/airport&quot;
#
# Set this to your Home WLAN SSID (name):
HOMESSID=&quot;mycastle&quot;
#
# Get SSID info from 'airport' and search for $HOMESSID
SSID=$(${AIRPORT} --getinfo | grep ' SSID:')
SSID=$(echo ${SSID} | grep &quot;^SSID: ${HOMESSID}\$&quot;)…</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/spfile_and_pfiles">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:36:05+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: SPFile and PFiles</title>
        <link>https://old.andunix.net/info/oracle/spfile_and_pfiles</link>
        <description>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:</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/link/dokuwiki_plugins">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:24+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>DokuWiki Plugins</title>
        <link>https://old.andunix.net/info/link/dokuwiki_plugins</link>
        <description>DokuWiki Plugins

This is a list of DokuWiki plugins I'm using.

dokuwiki add-on list link</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/root_login_with_bash">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:35+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>root login with bash</title>
        <link>https://old.andunix.net/info/script/root_login_with_bash</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/code/git">
        <dc:format>text/html</dc:format>
        <dc:date>2018-12-06T10:07:22+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Git</title>
        <link>https://old.andunix.net/info/code/git</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/index">
        <dc:format>text/html</dc:format>
        <dc:date>2015-08-12T06:56:24+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle</title>
        <link>https://old.andunix.net/info/oracle/index</link>
        <description>Oracle

Pages
oracle index


Bookmarks

	*  Oracle Database Online Documentation 10g Release 2 (10.2)
	*  Oracle Database Online Documentation 11g Release 2 (11.2)

oracle topic</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/javascript/autosubmit">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-14T08:22:05+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Automatic Submission of a Form if an Element is changed</title>
        <link>https://old.andunix.net/info/javascript/autosubmit</link>
        <description>Automatic Submission of a Form if an Element is changed

To submit the form if an element changes, you can use


onChange=&quot;this.form.submit()&quot;


Example


&lt;form action=&quot;index.jsp&quot; method=&quot;post&quot;&gt;
  &lt;select onChange=&quot;this.form.submit()&quot;&gt;
    &lt;option&gt;please select a value&lt;/option&gt;
    &lt;option value=&quot;1&quot;&gt;one&lt;/option&gt;
    &lt;option value=&quot;2&quot;&gt;two&lt;/option&gt;
    &lt;option value=&quot;3&quot;&gt;three&lt;/option&gt;
  &lt;/select&gt;
&lt;/form&gt;</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/solaris/pkg_repositories">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:37+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Package Repositories</title>
        <link>https://old.andunix.net/info/solaris/pkg_repositories</link>
        <description>Package Repositories

There's a list of multi-OS repositories at &lt;http://wikis.sun.com/display/IpsBestPractices/Directory+of+Package+Repositories&gt;.

More on IPS, the Image Package System can be found at:

	*  &lt;http://www.opensolaris.org/os/project/pkg/&gt;.
	*  &lt;http://wikis.sun.com/display/IpsBestPractices/&gt;
  Repository    Description  &lt;http://pkg.opensolaris.org/release/&gt;  OpenSolaris Distribution, Releases  &lt;http://pkg.opensolaris.org/dev/&gt;  OpenSolaris Distribution, Development Quality</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mysql/user/password">
        <dc:format>text/html</dc:format>
        <dc:date>2013-12-17T09:09:25+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MySQL: Change Password</title>
        <link>https://old.andunix.net/info/mysql/user/password</link>
        <description>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;</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/sysadmin/tomcat_upload_limit">
        <dc:format>text/html</dc:format>
        <dc:date>2017-01-04T09:33:36+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Increase the Tomcat Upload Limit</title>
        <link>https://old.andunix.net/info/sysadmin/tomcat_upload_limit</link>
        <description>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:


    &lt;multipart-config&gt;
      &lt;!-- 50MB max --&gt;
      &lt;max-file-size&gt;52428800&lt;/max-file-size&gt;
      &lt;max-request-size&gt;52428800&lt;/max-request-size&gt;
      &lt;file-size-threshold&gt;0&lt;/file-size-threshold&gt;
    &lt;/multipart-config&gt;</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/hg">
        <dc:format>text/html</dc:format>
        <dc:date>2013-07-15T10:39:59+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Mercurial</title>
        <link>https://old.andunix.net/info/hg</link>
        <description>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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/convert_key">
        <dc:format>text/html</dc:format>
        <dc:date>2019-01-17T19:19:12+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Convert a Key</title>
        <link>https://old.andunix.net/info/cryptography/openssl/convert_key</link>
        <description>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.</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/prog/firefox/index">
        <dc:format>text/html</dc:format>
        <dc:date>2013-08-02T19:34:46+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Firefox</title>
        <link>https://old.andunix.net/info/prog/firefox/index</link>
        <description>Firefox

Start another Firefox

To start another instance of firefox, use this command:
firefox -P &quot;My Profile&quot; -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</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mac/rmdir">
        <dc:format>text/html</dc:format>
        <dc:date>2015-11-25T09:43:44+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>rmdir for OSX</title>
        <link>https://old.andunix.net/info/mac/rmdir</link>
        <description>rmdir for OSX

The Finder on OSX creates .DS_Store files in the directories to store its settings.
This makes removing directories from the command line quite complicated:


$ rmdir test
rmdir: test: Directory not empty
$ rm test/.DS_Store 
$ /bin/rmdir test</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/solaris/filesystem">
        <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>File System</title>
        <link>https://old.andunix.net/info/solaris/filesystem</link>
        <description>File System

File System Organization

	*  File system organization - filesystem(5)

File Systems

This is a non-complete list of file systems in Solaris.

	*  hsfs(7FS): High Sierra &amp; ISO 9660 CD-ROM file system
	*  lofs(7FS): loopback virtual file system
	*  pcfs(7FS): FAT formatted file system</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/print_certificate">
        <dc:format>text/html</dc:format>
        <dc:date>2015-12-09T07:36:40+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Print Information about a Certificate</title>
        <link>https://old.andunix.net/info/cryptography/openssl/print_certificate</link>
        <description>Print Information about a Certificate
openssl x509 -in testkey.crt -noout -text
Informations about the used arguments from the OpenSSL man page:

	*  x509: Certificate display and signing utility.
	*  -in testkey.crt: This specifies the input filename to read a certificate from or standard input if this option is not specified.</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mac/compact_sparseimage">
        <dc:format>text/html</dc:format>
        <dc:date>2015-11-25T08:52:05+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Comapct Sparse Image</title>
        <link>https://old.andunix.net/info/mac/compact_sparseimage</link>
        <description>Comapct Sparse Image


hdiutil compact your.sparseimage


sysadmin cli apple mac osx</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/print_key">
        <dc:format>text/html</dc:format>
        <dc:date>2015-01-29T09:15:22+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Print Information about a Key</title>
        <link>https://old.andunix.net/info/cryptography/openssl/print_key</link>
        <description>Print Information about a Key
openssl x509 -inform DER -in testkey.cer -noout -text
Informations about the used arguments from the OpenSSL man page:

	*  x509: Certificate display and signing utility.
	*  -inform DER: This specifies the input format normally the command will expect an X509 certificate but this can change if other options such as -req are present. The DER format is the DER encoding of the certificate and PEM is the base64 encoding of the DER encoding with header and footer lines …</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/mac/index">
        <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>Mac</title>
        <link>https://old.andunix.net/info/mac/index</link>
        <description>Mac
mac index


apple mac topic</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/solaris/fstyp">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:37+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>fstyp</title>
        <link>https://old.andunix.net/info/solaris/fstyp</link>
        <description>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…</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/script/tools">
        <dc:format>text/html</dc:format>
        <dc:date>2013-02-04T22:17:35+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Command Line Tools Used in My Scripts</title>
        <link>https://old.andunix.net/info/script/tools</link>
        <description>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</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/solaris/etc/path_to_inst">
        <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>/etc/path_to_inst</title>
        <link>https://old.andunix.net/info/solaris/etc/path_to_inst</link>
        <description>/etc/path_to_inst

	*  path_to_inst(4)

The file /etc/path_to_inst maps physical device paths to driver name and driver instance number.

Example: e1000g0
&quot;/pci@0/pci@0/pci@1/pci@0/pci@2/network@0&quot; 0 &quot;e1000g&quot;
solaris config device</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/oracle/resize_instance">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-01T20:38:48+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Oracle: Resize Instance</title>
        <link>https://old.andunix.net/info/oracle/resize_instance</link>
        <description>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:</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/linux/debian/timezone">
        <dc:format>text/html</dc:format>
        <dc:date>2013-03-08T10:45:00+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Setting the Timezone</title>
        <link>https://old.andunix.net/info/linux/debian/timezone</link>
        <description>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 &quot;Europe/Berlin&quot; &gt; /etc/timezone</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/sysadmin/list_open_ports">
        <dc:format>text/html</dc:format>
        <dc:date>2017-04-13T20:11:34+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>List Open Ports</title>
        <link>https://old.andunix.net/info/sysadmin/list_open_ports</link>
        <description>List Open Ports

To list the open ports together with the listening processes:


netstat -tulpn


Here is an example output:


Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      695/sshd        
tcp6       0      0 :::22                   :::*                    LISTEN      695/sshd        
udp        0      0 0.0.0.0:55872      …</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/cryptography/openssl/download_server_certificate">
        <dc:format>text/html</dc:format>
        <dc:date>2015-02-11T14:42:38+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Download a Server Certificate</title>
        <link>https://old.andunix.net/info/cryptography/openssl/download_server_certificate</link>
        <description>Download a Server Certificate

First, load the certificate chain from the server:


openssl s_client -showcerts -connect www.example.org:443 &lt;/dev/null


This will output the whole server certificate chain.
Every chertificate ist wrapped between -----</description>
    </item>
    <item rdf:about="https://old.andunix.net/info/java/jax-ws_debugging">
        <dc:format>text/html</dc:format>
        <dc:date>2014-11-25T10:40:31+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>JAX-WS Debugging</title>
        <link>https://old.andunix.net/info/java/jax-ws_debugging</link>
        <description>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</description>
    </item>
</rdf:RDF>
