Backup Backuppc + Mysql, SSH keys

Sat, 15/11/2014 - 22:36
Body

Install backuppc

http://www.lycom.net/blog/?p=160 http://forums.openmediavault.org/index.php/Thread/5087-BackupPC-Install-Guide/ http://askubuntu.com/questions/191991/how-to-configure-backuppc-in-ubuntu-12-04 http://www.pcc-services.com/sles/backuppc4.html https://www.debian-administration.org/article/588/Introduction_BackupPC_part_1 http://ichbloggebei.blogspot.de/2012/09/1und1-premium-webseite-automatisch-mit.html http://wiki.centos.org/HowTos/BackupPC nice

Client

http://www.lycom.net/blog/?p=181 | SSH Client Configuration with BackupPC https://www.digitalocean.com/community/tutorials/how-to-use-backuppc-to-create-a-backup-server-on-an-ubuntu-12-04-vps http://www.howtoforge.com/linux_backuppc_p4 http://www.php2all.de/tutorialpage-7-linux-client-ins-backup-nehmen.html

Config

http://monklinux.blogspot.de/2012/02/installing-backuppc-on-gentoo-linux.html

Fehlerquellen

https://wiki.archlinux.de/title/SSH-Authentifizierung_mit_Schl%C3%BCsselpaaren

SSH keys einrichten

http://www.schlittermann.de/doc/ssh.html https://www.youtube.com/watch?v=rgLCtkbPqKg

Webhost1 spezifisch

https://www.webhostone.de/faq-webpakete/wie-kann-ich-mich-mit-dem-server-per-ssh-mit-key-verbinden.html http://forum.webhostone.de/showthread.php?5342-Kurzanleitung-SSH-Zugang-mit-Key-auf-dem-Mac-einrichten webhost one hat .ssh in home und in /. der key muss in /.ssh/ !!!!!!!!!!!!!!! pub key reinpasten in
  1. chmod 600 authorized_keys2
  2. mv authorized_keys2 /.ssh/
  3. exit
STEP 1: SERVER (backup pc is running here) --------------------------------------- su -s /bin/bash backuppc ssh-keygen -t rsa creates "id_rsa.pub" and "id_rsa" inside: /var/lib/backuppc/.ssh STEP 2: CLIENT (this server will be backupped) ------------------------------------------ copy the "id_rsa.pub" from SERVER to the CLIENT inside /.ssh/authorized_keys2 (naming it authorized_keys2 is a special case for my provider) Info: my provider especially told me to use mv authorized_keys2 /.ssh/ NOT mv authorized_keys2 ~/.ssh/ ssh-keygen -t rsa copy the pub key content to /var/lib/backuppc/.ssh/known_hosts STEP 3: Test the conenction from the SERVER ------------------------------------------- We are still logged in as backuppc and do ssh -v username@1.1.1.1 Info: Bei webhost one hat es erst geklappt wenn ich anstatt die direkte IP die Server dns genommen habe in meinem Fall "xb3.serverdomain.org". Die steht übrigens auch im generierten pub key. Nochmal danke an den tollen support von Webhostone.

All inkl spezifisch

http://blog.jenconsulting.de/?p=181
  1. cd ~
  2. cd .ssh
  3. touch authorized_keys

Problemlösungen

1.) Als backuppc user connecten und key akzeptieren ssh -v username@1.1.1.1 2.) Ping und Hostname prüfen (siehe Hinweis bei Webhost one) 3.) Keys und Usernamen prüfen

Permissions:

--------------------------------------------- chmod -R go-rxw .ssh/* (700)

Mysql

http://sourceforge.net/p/backuppc/mailman/message/22979052/ http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/backuppc-21/mysqldump-92269/ http://blog.zencoffee.org/2013/04/capturing-mysql-backups-with-backuppc/ http://www.d-herrmann.de/2014/04/automated-mysql-database-backup-backuppc/ http://www.linux.com/learn/tutorials/659107-how-to-do-painless-mysql-server-backups-with-automysqlbackup

mit pre command

http://sourceforge.net/p/backuppc/mailman/message/22979052/ direkt mit mysql command oder dem skript?

mit drupal drush

http://janaksingh.com/blog/automated-drupal-database-backups-using-drush-bash-and-cron-139 Ins root der drupal multisites egehn als in /sites und dann folgendes laufen lassen.
  1. drush -y @sites sql-dump --result-file --gzip --structure-tables-key=common
backupt alle dbs nach /home/drush-backups

Backup manuell ausführen

Quelle: http://backuppc.sourceforge.net/faq/debugXfer.html Oft geht es immer noch nicht und es kommt EOF connection reset, can not read 4 bytes im log. Wenn das Backup immer noch nicht geht dann:
  1. /usr/share/backuppc/bin/BackupPC_dump -v -f hostname
Add new comment
The content of this field is kept private and will not be shown publicly.

Plain text

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <drupal-entity data-*>
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.