Fulltext results:
- mySQL @linux:databases
- ---- == mysqldump == dump a database to a .sql file. there are many parameters. check 'man mysqldump'... ter-set=utf8 --user=root --password=${PWD} $DB > $FILE If you get "error 34 too many open files".. inc... ---- == mysql import == works by piping an sql file into the 'mysql' command: mysql --host=127.0.... $PORT --password=${DBPWD} ${DBNAME} < ${MYSQLDUMP_FILE} ---- == execute mysql command == any sql sta
- Crypto @linux:filesystems
- --hash sha512 -y luksFormat /dev/mdX [/path/to/keyfile] If you add a key file, leave out "-y" **ciphers:** * aes-cbc-essiv:sha256 is deprecated: http://ww... tsetup luksOpen /dev/mdX cryptname Open with key file: cryptsetup --key-file /path/to/keyfile luksOpen /dev/md1 cryptname The opened volume is available
- Apache @linux:webserver
- rsions of apache2 require a chain of certs in one file, not anymore separate files: cat /etc/apache2... t config for all vhosts in 000-default: # cert-file: # SSLCertificateFile /etc/apache2/ssl/cert.crt # replaced by chain-file: SSLCertificateFile /etc/apache2/ssl/chain.crt
- Filesystems
- subpages ===== swap ===== **create and use a swapfile** dd if=/dev/zero of=/swapfile bs=1024 count=1000000 # = 1000mb mkswap /swapfile edit /etc/fstab -- add a swap-line for auto activation after reboot: /swapfile swap swap defaults 0 0
- Nginx @linux:webserver
- nformation about frequently accessed files open_file_cache max=2000 inactive=20s; open_file_cache_valid 60s; open_file_cache_min_uses 5; open_file_cache_errors off; # buffers optimzed: client_max_body_size 20m; cl
- Shell Commands & Oneliner
- fault :(** it enables a lot of auto complete for file paths, commands, command parameters(!) and more ... -get install bash-completion add this to /etc/profile to enable completion for all users: if [ -f /... it by opening a new console or source /etc/profile info from: http://www.howtoforge.com/how-to-add-bash-completion-in-debian ==== Create Random File ==== count is in KiB dd bs=1024 count=1000 </
- Synergy @linux:network
- n. mcedit /etc/gdm/PostLogin/Default If the file doesn't exist, create it and write the synergyc c... e way: **put the following line in a startup hook-file of gdm/kdm/xdm:** Just replace username with your... ace scripts in ~/.kde/Autostart/ directory**. The file must be executable and the first line must contai... OSTNAME> == LXDE autostart: == Put a .desktop file in here: **~/.config/autostart/** [Desktop Ent
- Replication @linux:databases:mysql
- = /var/log/mysql/relay-bin.index relay_log_info_file = /var/log/mysql/relay-bin.info expire_l... xyxyxyxyxyxyxyxyxy', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=9235331, MASTE... the log position show master status\G; .. File: mysql-bin.000052 Position: 597 .. **On Serv... xyxyxyxyxyxyxyxyxy', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000052', MASTER_LOG_POS=597, MASTER_SS
- LXC @linux:virtualization
- s on host or in vs - only in the container config file!** **Move eth0 to br0 in /etc/network/interfaces... to the container, they have wrong uid/gid. if the file should belong to root, just run this from the roo... 000 /vservers/<containername>/rootfs/<path to the file in container> **Links:** * https://unix.stac
- SSH @linux:network
- t password, you need to add the public key to the file **~/.ssh/authorized_keys** on that box. less ~... -get install keychain add keychain to ~/.bash_profile eval `keychain --eval --agents ssh --clear id_... nd re-use it for all logins: source ~/.bash_profile \\ ===== setup a tunnel ===== this creates a
- Multiboot Stick @linux:filesystems
- ry "ubuntustudio-12.04-dvd-amd64" { set isofile="/iso/ubuntustudio-12.04-dvd-amd64.iso" loopback loop $isofile linux (loop)/casper/vmlinuz boot=casper iso-scan/filename=$isofile noeject noprompt -- initrd (loop)/casper/i
- PXE netboot @linux:debian_install
- an automated installer, which downloads a preseed file: label Install Automat MENU DEFAULT kernel ... everything :) Add a download url for the preseed file to the bootmenu in pxelinux.cfg/default. This can... and run it, with a similar command in the preseed file: d-i preseed/late_command string in-target wge
- vsFTPd @linux:network
- config with SSL in debian ===== Generate a pem file from an official SSL certificate ===== cat /et... sftpd/server.pem ===== Generate a selfsigned pem file ===== openssl req -x509 -nodes -days 365 -newk... v1=YES ssl_sslv2=YES ssl_sslv3=YES rsa_cert_file=/etc/vsftpd/server.pem require_ssl_reuse=NO p
- CourierMLM @linux:emailserver
- ===== **Export:** couriermlm exports to a textfile: one address per line, subscription infos, follow... ers **Import:** couriermlm expects a nasty text file format for import: one address per line, separate... t_subscibers Converter script, which reads a textfile containing one address per line, roughly checks t
- duplicity @linux:backup
- e error 'too many open files' ==== increase open file limits in /etc/security/limits.conf add: root soft nofile 4096 root hard nofile 8192 re-login and check: ulimit -Hn