If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query:

stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
start slave;
show slave status\G

s3cmd du s3://bucket-name | awk '{print $0/1024/1024/1024" GB"}'

Following good practice we put user credentials into the non-replicated admin database. Note the empty role array for admin.

$ use admin
$ db.auth('root','***')
$ db.addUser({user:'new_user',pwd:'***',otherDBRoles: { peachy_prod: ['read']}, roles: []})

We then reference the new user in the actual db.

$ use peachy_prod
$ db.addUser({user:'new_user',userSource:'admin', roles: ['read']})

Now we can auth against the admin database and obtain the authorization to access the actual db.

$ use admin
$ db.auth('new_user...

Todo

• rotate logs
• startup script for carte server

Software

1. Setup centos 6.5
2. set hostname in /etc/hosts
3. start sshd
4. turn off iptables
5. add EPEL repo

  wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
  wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
  sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

1. yum install htop acpi iotop iftop ftop wget man mlocate
2. create users pentaho and postgres
3. Java setup package via http://wiki.centos.org/HowTos...

Example

knife ssh -x sysadmin.a -a ipaddress "chef_environment:stage" uptime

• always define the user with -x
• always give the ssh attribute -a ipaddress for knife to rely on the ip attributes of the search query result
• the actual search query goes along standard knife search syntax
• remember quotes around constructed commands, in particular sudo do_this

http://www.codetweet.com/nginx/solved-504-gateway-timeout-error-in-nginx-web-server/

https://rtcamp.com/tutorials/nginx/tweaking-fastcgi-buffers/

netstat -A inet -p

ss -tp

for dir in /tmp/*/
do
    dir=${dir%*/}
    echo ${dir##*/}
done

find . -type d -ctime +60 -exec rm -rf {} +

rsync --partial --progress --rsh=ssh user@host:remote_file local_file

https://www.digitalocean.com/community/tutorials/how-to-use-rsync-to-sync-local-and-remote-directories-on-a-vps

grep "^[^;[]" /etc/php.ini | less

wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2%2Fwww.oracle.com%2F" "http://download.oracle.com/otn-pub/java/jdk/7u51-b13/jdk-7u51-linux-i586.rpm"

nohup find /Backup/ -type f -execdir shred -zu -n7 '{}' \; &

sed -i".bak" '3d' filename.txt

1. Ctrl+Z to stop (pause) the program and get back to the shell
2. bg to run it in the background.
3. disown -h [job-spec] where [job-spec] is the job number (like %1 for the first running job; find about your number with the jobs command) so that the job isn't killed when the terminal closes

Create route-ethX file in: /etc/sysconfig/network-scripts/

ADDRESS0=x.x.x.x
NETMASK0=x.x.x.x
GATEWAY0=x.x.x.x

Example: We want to route two networks

192.168.6.0/24 and 192.168.5.0/24 through 10.10.16.231

ADDRESS0=192.168.6.0
NETMASK0=255.255.255.0
GATEWAY0=10.10.16.231

ADDRESS1=192.168.5.0
NETMASK1=255.255.255.0
GATEWAY1=10.10.16.231

NB: Do not forget to increment the number for every route:
ADDRESS(X)
NETMASK(X)
GATEWAY(X)

General info for Linux users

Although the printer can be found and installed, a driver installation from below source is usually necessary.

Driver download

Quick

1. add space via gui
2. delete old, create bigger new one
3. resize filesystem

Helpful links

• Official doku
• Tutorial

Tips

• when resizing boot partitions, remember to reboot after partition size change
• add NFS shares via WebGUI
• relevant config files: /etc/pve/storage.cfg
• on windows 7 servers, don't do resizing adjustment OS-side over rdp session, but via proxmox vnc terminal (possible permissions issue of RDP)