https://old.andunix.net/ 2026-06-03T23:11:26+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/syntax Formatting Syntax DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressing 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 2009-08-11T15:06:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/zfs_playground ZFS Playground This small demo shows the basic ZFS operations. You will need a Solaris 10 or OpenSolaris host and 1,2GB of disk space. Preparation First, go to a directory where you have enought space. We will need 1,2GB for 6 files of 200MB. The files are named like disks, but they are only files for this demo. text/html 2013-02-04T22:17:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/android/apps 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 & 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 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:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/analyzer_bookmarklet Travian Analyzer Bookmarklet Installation First, save a bookmark with title “Analyze” and the location javascript:top.location.href=((String(window.getSelection()).length>0)?'http://travian.ws/analyser.pl?s=de7&q='+window.getSelection():top.location.href.replace(/http:\/\/welt7\.travian\.de\/(spieler|allianz)\.php\?/,'http://travian.ws/analyser.pl?s=de7&')) text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/dokuwiki DokuWiki wiki:dokuwiki DokuWiki is a simple to use and highly versatile Open Source wiki software that doesn't require a database. It is loved by users for its clean and readable Formatting Syntax. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in 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-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-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 2009-04-27T11:30:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/project_idea_wikitable Project Idea: WikiTable I'm using wikis a lot but every wiki I tried so far lacks support for tables. The wikis are able to show tables, but building a table using lots of pipes “|” sucks. What I want to develop (or learn that such a this already exists) is a small application which creates tables which then can be included in wiki pages. text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/welcome Welcome to your new DokuWiki Congratulations, your wiki is now up and running. Here are a few more tips to get you started. Enjoy your work with DokuWiki, -- the developers Create your first pages Your wiki needs to have a start page. As long as it doesn't exist, this link will be red: 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-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 2015-11-25T08:53:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2011/start_and_stop_apple_file_server_command_line Start and Stop the Apple File Server from Command Line You can use /sbin/service to start or stop the “Personal File Sharing”. Start the Apple File Server (“Personal File Sharing”): sudo /sbin/service com.apple.AppleFileServer start And likewise stop it: text/html 2013-03-02T19:19:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/cloudtable/index CloudTable Big Picture This concept-image shows the currently planned architecture. [CloudTable Big Picture Draft 1] The core appears as a single block for now, it will be broken up in a second version of the drawing. The config store stores the informations about the forms, tables and applications. Also the users will be stored here. The data store stores the text/html 2010-10-27T12:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/ips_repository_appliance IPS Repository Appliance Brian Leonard wrote a good guide how to setup a Local Repository Mirror. If you are in a hurry, it's good to know that you don't need to copy the entire repository of about 8GB to a local disk. You can use the repository image directly. Here is how you can do that. 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 2010-05-17T07:55:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/how_create_moveable_vm_virtualbox How To Create a Moveable VM with VirtualBox VirtualBox works good when you use the same VMs all the time. It organizes the disk images in one directory and the configuration files in another. It kees a record of all known disk images and virtual machines. text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/travian_info_tool Travian Info Tool This tool in currently in planning. You will be able to get Informations about * players * allies * villages * fields URLs Subject ID URL Player uid /travian/info?w={world}&uid={id} Ally text/html 2013-03-03T14:10:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2011/project_pda Project PDA I'm currently working on a project called 'PDA'. PDA stands for “Personal Digital Assistant”. I used several PDAs over the last two decades, from Sharp, Psion, Palm and others. But they all were just Personal Datastorages. I always missed the text/html 2013-03-15T09:42:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/travian_village_planner Travian Village Planner Currently I'm working on a village planner for Travian. It was inspired by the village planner at <http://www.ebav.co.uk/travian/>, but I was missing a possibility to save and reference my village. So the main feature was saving the village to a bookmark. This is done by the 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 2016-07-12T09:50:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/template _template Pages Bookmarks text/html 2013-09-02T20:37:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/prog/firefox/extensions 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. 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-12T21:41:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/drupal_reverse_proxy Drupal: Reverse Proxy skybow wrote the very helpful article “Drupal via HTTPS/SSL Proxy Server (shared certificates)”. While following his advice, I found some improvements. To reduce the amount of editing and to increate the reusability, I substituted * www.example.com with $_SERVER['SERVER_NAME'] and text/html 2013-02-04T22:17:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/pda/index Project PDA The Project PDA aims to build a real Personal Digital Assistant. * Data Collector: Collection of API Implementations to connect to several (Web-)Services and access data there * Blackbox: Entity Storage. Stores XML objects like tasks, notes etc. * PADD: Personal Access and Data Display. Named after the Star Trek Pads, it implements the pda index text/html 2009-02-18T19:25:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/dice_roller Dice Roller I programmend a small dice roller in javascript. You enter the number of dice, sides and the offset and press the button “roll”. The script shows the individual dice and the resulting sum. For convenience, there is a second form where you can just enter the number of dice and press the butten for the type of dice. At the bottom, there are some links of six- and eightsided dice, which are often needed in roleplaying games. You can also create bookmarks for dice, e.g. text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/sqlplus sqlplus Pages Bookmarks text/html 2015-11-25T08:54:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/home_server_goals Home Server Goals As Constantin suggested, here is a list of services, which my home server should provide: * Personal Video Recorder: I'm using the EyeTV Hard- and Software from Elgato to record, cut and archive TV broadcasts. * Secure File Archive/Backup text/html 2014-09-05T12:13:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/plugin plugin Pages Bookmarks text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/plan plan Pages Bookmarks text/html 2013-02-18T14:26:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/compare_key_with_certificate 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 text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/apple apple Pages Bookmarks 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 2009-02-25T11:04:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/travian_village_planner_-_tribe_and_village_name Travian Village Planner - Tribe & Village Name Yesterday, I had some time and worked on the Village Planner. It now has an input field for the name of the village and you can select your tribe. Both informations are saved to the URL when clicking on “make bookmark”. The tribe is saved as parameter 't' and the name as 'n'. text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/index Travian Welcome to the Travian tools at andunix.net. Here I will publish my projects regarding the browsergame “Travian” (german page). travian index Links to other Tools * Travian Analyzer * Travian Toolbox * Travian Village Planner -- the inspiration for my village planner * TravMap * Travianmap * Travian Kampfberichtparser (german) travian text/html 2013-02-04T22:17:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/link/dokuwiki_plugins DokuWiki Plugins This is a list of DokuWiki plugins I'm using. dokuwiki add-on list link 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 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 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 2013-02-04T22:17:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/pkg_repositories Package Repositories There's a list of multi-OS repositories at <http://wikis.sun.com/display/IpsBestPractices/Directory+of+Package+Repositories>. More on IPS, the Image Package System can be found at: * <http://www.opensolaris.org/os/project/pkg/>. * <http://wikis.sun.com/display/IpsBestPractices/> Repository Description <http://pkg.opensolaris.org/release/> OpenSolaris Distribution, Releases <http://pkg.opensolaris.org/dev/> OpenSolaris Distribution, Development Quality text/html 2010-02-28T23:00:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/welcome Hello Drupal Some time ago, I decided to migrate my blog from DokuWiki to Drupal. Blogging with DokuWiki was OK using the plugins from the DokuWiki Blogsuite BundleHub, but Drupal has some advantages. It's always fascinating to get into a new technology. After using misc. wiki systems and Wordpress, I wanted to try a content management system. I had a quick look into Drupal, Joomla and Silverstripe, and then decided to go with Drupal. 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 2009-07-21T17:52:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/virtual_network_visualization 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 dladm show-link and generates a dot-File, which then can be rendered using 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 2015-02-11T09:25:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2014/foldersync_and_owncloud_7 Workaround for FolderSync with ownCloud 7 The Android App “FolderSync” stopped working when I upgraded my ownCloud to Version 7. FolderSync always showed “Bad Request” when testing the connection. ANd when I looked into the Apache log, the requests were closed with 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 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 2015-08-12T06:56:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/index 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 text/html 2009-08-11T10:16:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/opensolaris_virtualbox_mount_shared_folder OpenSolaris / VirtualBox: Mount Shared Folder To mount a shared folder in a OpenSolaris guest in VirtualBox, you have to install the Guest Additions and then mount the file system type vboxfs. The Usage is: mount -F vboxfs <share> <mountpoint> text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mac/index Mac mac index apple mac topic 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 2013-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-net-load-url base-net-load-url Loads a file from an URL and outputs it to STDOUT. Usage base-net-load-url URL * URL: the URL to load. Returns Returns the contents of the resource referenced by the URL. Examples base-net-load-url "${service_url}" PASSWORD=$(base-net-load-url ${PASSWORD_URL}) text/html 2010-04-21T08:17:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/memory_usage_solaris_container_zone Memory Usage of a Solaris Container (Zone) Last week one of my servers ran out of RAM and Swap. Shame on me for not monitoring that, but it's now. As the server is running several zones, my first question was: Which zone is eating up my RAM? So, here are the commands I used. text/html 2013-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/filesystem 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 & ISO 9660 CD-ROM file system * lofs(7FS): loopback virtual file system * pcfs(7FS): FAT formatted file system text/html 2019-01-17T19:19:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/convert_key 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. 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 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-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:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/host/index host The host module implements the methods to maintain a host. Methods host index text/html 2013-02-04T22:17:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/index base The base module implements the basic methods used by the other modules. Methods base index text/html 2013-08-02T19:34:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/prog/firefox/index Firefox Start another Firefox To start another instance of firefox, use this command: firefox -P "My Profile" -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 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 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-02-03T11:12:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/andunix-tool/index andunix-tool Usage: java -jar andunix-tool.jar <Global Options> <Command> <Command Options> Tip: I suggest to create a shell-script to ease the java starting: #! /bin/sh # Change this to the directory in which you put ''andunix-tool.jar'' # and the corresponding ''lib'' directory ANDUNIX_TOOL_DIR=${HOME}/opt/andunix-tool # Use this to define the path to your Java-Intallation JAVA_HOME=/opt/jdk exec ${JAVA_HOME}/bin/java -jar ${ANDUNIX_TOOL_DIR}/andunix-tool.jar $* text/html 2013-02-04T22:17:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/tools 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 text/html 2015-01-29T09:15:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_key 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 … text/html 2013-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-repo-get-service base-repo-get-service Loads a service configuration from the repository and outputs it to STDOUT. Usage base-repo-get-service SERVICE * SERVICE: a key of a service definition in the repository. Returns Returns the service definition. This is usually evaluated in a shell script by the text/html 2013-02-04T22:17:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/fstyp 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… text/html 2013-02-04T22:17:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/solaris/etc/path_to_inst /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 "/pci@0/pci@0/pci@1/pci@0/pci@2/network@0" 0 "e1000g" solaris config device text/html 2013-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-repo-get-value base-repo-get-value Loads a service configuration from the repository and outputs a single value (for the given key) to STDOUT. Usage base-repo-get-value SERVICE KEY * SERVICE: A key of a service definition in the repository. * KEY: The key for the value in the service definition to output. 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-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 2015-12-09T07:36:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_certificate 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. 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:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/host/host-user-list host-user-list Lists the users on a given host. Usage host-user-tab HOST * HOST: a key of a host service definition in the repository. Returns Returns the first colum (login) of the /etc/passwd file. Example users=$(host-user-list "${host}" \ | egrep -v "${IGNORED_USERS}" ) 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-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 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 2014-01-27T14:38:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2014/simulating_slow_network_connections_with_trickle Simulating slow network connections with trickle You can limit the downlink of a Firefox browser to 512 KB/s with this command: trickle -d 512 /usr/bin/firefox -no-remote -P test More informations can be found on these pages: * trickle Homepage * Trickle in the Ubunutuuser Wiki (german) text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/travian_map_download_script Travian Map Download Script This is my script(s) which I use to downoad the map.sql from Travian and import it to the database. config.inc # # database DB_USER="travian" # set this to your database user DB_PASS="travian" # set this to your database password DB_INST="travian" # set this to your database instance # # directories MAP_DIR=${HOME}/opt/travian DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql # # executables MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -… 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