https://old.andunix.net/ 2026-06-04T06:11:36+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico 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 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 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-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 2020-08-29T19:05:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/index andunix.net Tags Recent Changes 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: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-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 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-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-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 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/wikitable wikitable Pages Bookmarks text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/immutable_service_containers immutable_service_containers Pages Bookmarks text/html 2014-01-27T14:49:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/tag/cloudtable cloudtable Pages Bookmarks text/html 2013-02-04T22:17:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/relax/api/host/host-user-tab host-user-tab Lists the users on a given host as a colon separated table. Usage host-user-tab HOST * HOST: a key of a host service definition in the repository. Returns Returns the contents of the /etc/passwd file. 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: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-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-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 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 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-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-02-04T22:17:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/db/index Database db index 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-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: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-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 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/database/index Database Administration database index 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-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 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: