https://old.andunix.net/ 2026-06-03T21:23:51+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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-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: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 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 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 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 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/database database Pages Bookmarks 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:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-exec-user base-exec-user Executes a command as a given user. Command is executed using ssh if the user is not on localhost. Usage base-exec-user USER COMMAND * USER: A key of an user definition in the repository. From this, the following properties are used: 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: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 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-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-ssh-umount base-ssh-umount Unmounts a remote share which had been mounted using sshfs/fuse (sftp). Usage base-ssh-mount SERVICE * SERVICE: A key of a service definition in the repository. Returns No output. text/html 2013-02-04T22:17:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/base/base-ssh-mount base-ssh-mount Mounts a remote share using sshfs/fuse (sftp). Usage base-ssh-mount SERVICE * SERVICE: A key of a service definition in the repository. Returns No output. 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 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 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-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: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-02-04T22:17:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/db/index Database db index 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 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-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 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: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 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 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-03-01T20:43:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/error Oracle Errors ORA-00257: archiver error. Connect internal only, until freed. * Reason: The flash recovery area is full. * Resolution: Remove archive logs. * Resolution: Enlarge the flash recovery area. * Documentation: 10.2 11.2 database documentation error oracle reference 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:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/index Database Administration database index 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-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 2013-10-18T08:01:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2013/welcome_back Welcome Back In 2010 I moved my blog from DokuWiki to Drupal. Today, I moved it back to DokuWiki. The reason for switching to Drupal was for the better blogging support. As I'm using this site more as Knowledge Base than a Blog, DokuWiki is the better alternative. You can still access the old site at old.andunix.net. 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 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-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