https://old.andunix.net/ 2026-06-03T23:40:39+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 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 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/create MySQL: Create User Create User CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; Create User and Database * Usually, {user} == {db} CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; text/html 2013-02-04T22: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 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 2014-11-20T08:13:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/generate_key Generate a Test Key openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout testkey.key -out testkey.crt Informations about the used arguments from the OpenSSL man page: * req: PKCS#10 certificate request and certificate generating utility. * -x509: this option outputs a self signed certificate instead of a certificate request. This is typically used to generate a test certificate or a self signed root CA. The extensions added to the certificate (if any) are specified in the configurati… text/html 2014-02-22T13:16:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/virtualbox/cli VBoxManage (The VirtualBox CLI) This is a online reference of the output of VBoxManage without options. Oracle VM VirtualBox Command Line Management Interface Version 4.2.16 (C) 2005-2013 Oracle Corporation All rights reserved. Usage: VBoxManage [<general option>] <command> text/html 2013-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 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 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 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 2014-02-02T12:02:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/dmx/program Program The controller (Arduino) can be programmed to animate the value on a DMX channel from one value to another. The contoller has an program counter which is counted up by one every iteration. The iterations will be 5ms (200Hz), 10ms (100 Hz) or 20ms (50 Hz) long. The value of the program counter ist exchanged between the host an the controller with the command 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 2013-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-ssh-login base-ssh-login Logs into a remote host using ssh. This can be used to open a remote sesssion, but ususally it's used by other methods (especially base-exec-user) to remotely execute a command. Usage base-ssh-login SERVICE [ COMMAND ] * SERVICE: a key of an user or host definition in the repository. From this, the following properties are used: text/html 2009-11-27T16:36:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/relax ReLAX Thanks to Wolfgang Stief and Constantin Gonzalez, I got hold on one of the proceedings of the Linux Kongress and OpenSolaris Developer Conference. In this book, I found amoung other, also very interesting, articles one about LAX by Thomas Groß. LAX has some very interesiting concepts, but, unfortunately, it doesn't fit my needs. So I decided to take some of the concepts of LAX and build my own sysadmin-automation-framework. text/html 2013-02-18T14:27:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/cryptography/openssl/print_all_certificates_in_a_file Print all certificates in a file This command is especially helpful if you want to use Tomcat-/Java-Keystore-Certificates with the Apache webserver. Use the -print_certs to print all the certificates and then cut the file and store each certificate in a single file. 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 2010-04-29T14:07:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2010/set_php_variables_htaccess_files Set PHP Variables in .htaccess Files If your PHP scripts run longer than the maximum execution time set by your webhoster, then you will see a message like this: Fatal error: Maximum execution time of 30 seconds exceeded in ... To override the default for your webspace, you can use the php_value directive in a .htaccess file. text/html 2013-02-04T22:17:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-exec-superuser base-exec-superuser Executes a command as a given user. Command is executed using ssh if the user is not on localhost. Before executing the command, the privileges will be elevated. This privilege elevation method is defined by $RIGHT_ELEVATION in the service configuration and can be either 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 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 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 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 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 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 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 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: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 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 2014-02-02T11:19:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/dmx/protocol Serial Protocol For the communication between the host (PC) and the controller (Arduino), there is a serial protocol over USB. The protocol is line by line, with carriage return (“\n”) as end. The first character denotes the type of command or information. The following commands have been defined: