https://old.andunix.net/ 2026-06-03T20:28:35+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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 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-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 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-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-03-08T10:45:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/debian/timezone 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 "Europe/Berlin" > /etc/timezone 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: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 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 2014-11-25T10:40:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/jax-ws_debugging 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 text/html 2018-09-19T12:34:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/compare_directories Compare directories For each of the directories, generate a digest file: find DIR -type f -exec shasum {} + | LC_ALL=C sort -d -k 2 > shasums.txt It's important to use LC_ALL=C and the option -d of sort, to get compareable results on different machines. 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 2013-03-01T20:26:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/accounts_with_objects 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; 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 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 2015-11-25T09:43:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/rmdir 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 text/html 2015-11-25T08:53:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/make_your_mac_feel_home 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}\$")… text/html 2015-11-30T12:09:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/sysadmin/ssh 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: 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-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/remove 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 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 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-14T08:22:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/javascript/autosubmit Automatic Submission of a Form if an Element is changed To submit the form if an element changes, you can use onChange="this.form.submit()" Example <form action="index.jsp" method="post"> <select onChange="this.form.submit()"> <option>please select a value</option> <option value="1">one</option> <option value="2">two</option> <option value="3">three</option> </select> </form> text/html 2017-04-13T20:11:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/sysadmin/list_open_ports 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 … text/html 2015-10-23T12:39:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/variables Shell Script Variables Last Character Get the last character of $a: ${a: -1} Remove Slash from the End of a Variable Remove a trailing slash from $a: a=${a%/} scripting bash sysadmin variable text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/create 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 text/html 2013-03-10T21:06:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/mac_command_line_audio 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" text/html 2016-07-14T06:40:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/wifi_config_qrcode 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:<SSID>;T:<WPA|WEP|>;P:<password>;; If the network is hidden, then add H:true;: WIFI:S:<SSID>;T:<WPA|WEP|>;P:<password>;H:true;; You can try it here: text/html 2014-09-05T12:12:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/firefox_java-plugin 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 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 2014-04-28T09:01:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/pargs pargs for Linux If you miss pargs from Solaris, then try this: ps eww -p <pid> linux sysadmin cli text/html 2014-05-16T06:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/disable_core_dumps Disable Core Dumps To disable core dumps create a file /etc/security/limits.d/no_core_dumps with the content * hard core 0: echo '* hard core 0' > /etc/security/limits.d/no_core_dumps Based on the “Nix Craft” article Linux Disable Core Dumps. linux sysadmin admin config text/html 2013-03-01T20:40:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/exp 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 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 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/grant MySQL: Grant Permissions Grant Permissions GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2015-02-11T14:42:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/download_server_certificate Download a Server Certificate First, load the certificate chain from the server: openssl s_client -showcerts -connect www.example.org:443 </dev/null This will output the whole server certificate chain. Every chertificate ist wrapped between ----- text/html 2015-01-29T09:15:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_signature Print Information about a Signature openssl pkcs7 -in signature.p7s -text -inform DER -print_certs -noout cryptography howto openssl security text/html 2015-11-25T08:53:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/hostname Set a Mac's Hostname To set the permanent hostname, use the scutil utility (enter the desired hostname instead of the_hostname): sudo scutil --set HostName the_hostname Credits * <http://osxdaily.com/2010/09/06/change-your-mac-hostname-via-terminal/> mac osx cli sysadmin text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/revoke MySQL: Revoke Permissions Revoke Permissions REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/iconv 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} \ && mv ${f}_$$_TEMP ${f} done text/html 2013-02-27T12:34:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/javascript/reload_page Reload Page location.reload(true); javascript text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/remove MySQL: Remove Database Remove Database DROP DATABASE IF EXISTS `{db}`; admin database mysql sql text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/view MySQL: View Permissions View Permissions SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; admin database mysql sql text/html 2014-04-22T11:34:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/code/eclipse/java_vm Specify Java VM for Eclipse To let Eclipse use the Java VM from /opt/jdk/bin/java add these two lines to the eclipse.ini in the Eclipse installation directory: -vm /opt/jdk/bin/java -vmjava Source: Eclipsepedia: eclipse.ini - Specifying the JVM eclipse java settings text/html 2013-07-24T08:05:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/thunderbird_extensions Thunderbird Extendsions * Lightning * Lightning Calendar Tabs * Mail Redirect * Nostalgy * Lightning QR-Code Add-on * Quicktext mozilla thunderbird extension add-on text/html 2015-11-25T08:52:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/compact_sparseimage Comapct Sparse Image hdiutil compact your.sparseimage sysadmin cli apple mac osx text/html 2016-07-12T09:43:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/linux/gnome/cursor-size Cursor Size To change the mouse cursor size in GNOME, use this command. Substitute the value 32 with your prefered size. gsettings set org.gnome.desktop.interface cursor-size 32 desktop gnome linux mouse cursor settings 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 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-03-07T13:51:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/webdesign/urlencode URL Encoding Character URL-Code & %26 ? %3F web webdesign html http encoding reference