SCP Backup

kubi

Verified User
Joined
Dec 2, 2004
Messages
5
I'm trying to do a backup and copy it off site with scp. The backup appears to be completing, but nothing shows up on the remote box. I have added the id_dsa.pub to authorized_keys2 on the remote box. I've tested to make sure that I can scp files without entering a password and it works fine. I'll include the message the backup sends since it seems to end prematurely and I'm not entirely sure why.

Here are the settings for the backup
Remote transfer method - scp
Remote Host - otherbox.com
Remote Path - /home/kubi/backups

Performing sanity checks: Completed
Checking load average: Completed
Checking free disk space: Completed
Performing Custom backup
Archiving /etc/exim.conf: Completed
Transfering exim.conf.tar.gz to otherbox.com: Completed
Transfering exim.conf.md5 to otherbox.com: Completed
Archiving /etc/exim.crt: Completed
Transfering exim.crt.tar.gz to otherbox.com: Completed
Transfering exim.crt.md5 to otherbox.com: Completed
Archiving /etc/exim.key: Completed
Transfering exim.key.tar.gz to otherbox.com: Completed
Transfering exim.key.md5 to otherbox.com: Completed
Archiving /etc/exim.pl: Completed
Transfering exim.pl.tar.gz to otherbox.com: Completed
Transfering exim.pl.md5 to otherbox.com: Completed
Archiving /etc/group: Completed
Transfering group.tar.gz to otherbox.com: Completed
Transfering group.md5 to otherbox.com: Completed
Archiving /etc/hosts: Completed
Transfering hosts.tar.gz to otherbox.com: Completed
Transfering hosts.md5 to otherbox.com: Completed
Archiving /etc/passwd: Completed
Transfering passwd.tar.gz to otherbox.com: Completed
Transfering passwd.md5 to otherbox.com: Completed
Archiving /etc/proftpd.conf: Completed
Transfering proftpd.conf.tar.gz to otherbox.com: Completed
Transfering proftpd.conf.md5 to otherbox.com: Completed
Archiving /etc/proftpd.passwd: Completed
Transfering proftpd.passwd.tar.gz to otherbox.com: Completed
Transfering proftpd.passwd.md5 to otherbox.com: Completed
Archiving /etc/proftpd.vhosts.conf: Completed
Transfering proftpd.vhosts.conf.tar.gz to otherbox.com: Completed
Transfering proftpd.vhosts.conf.md5 to otherbox.com: Completed
Archiving /etc/resolv.conf: Completed
Transfering resolv.conf.tar.gz to otherbox.com: Completed
Transfering resolv.conf.md5 to otherbox.com: Completed
Archiving /etc/shadow: Completed
Transfering shadow.tar.gz to otherbox.com: Completed
Transfering shadow.md5 to otherbox.com: Completed
Archiving /etc/system_filter.exim: Completed
Transfering system_filter.exim.tar.gz to otherbox.com: Completed
Transfering system_filter.exim.md5 to otherbox.com: Completed
Archiving /etc/mail: Completed
Transfering mail.tar.gz to otherbox.com: Completed
Transfering mail.md5 to otherbox.com: Completed
Archiving /etc/virtual: Completed
Transfering virtual.tar.gz to otherbox.com: Completed
Transfering virtual.md5 to otherbox.com: Completed
Archiving /usr/local/frontpage: Completed
Transfering frontpage.tar.gz to otherbox.com: Completed
Transfering frontpage.md5 to otherbox.com: Completed
Archiving /var/log: Completed
Transfering log.tar.gz to otherbox.com: Completed
Transfering log.md5 to otherbox.com: Completed
Archiving /var/mail: Completed
Transfering mail.tar.gz to otherbox.com: Completed
Transfering mail.md5 to otherbox.com: Completed
Archiving /var/spool/cron: Completed
Transfering cron.tar.gz to otherbox.com: Completed
Transfering cron.md5 to otherbox.com: Completed
Archiving /var/spool/mail: Completed
Transfering mail.tar.gz to otherbox.com: Completed
Transfering mail.md5 to otherbox.com: Completed
Archiving /var/spool/virtual: Completed
Transfering virtual.tar.gz to otherbox.com: Completed
Transfering virtual.md5 to otherbox.com: Completed
Archiving /var/www: Completed
Transfering www.tar.gz to otherbox.com: Completed
Transfering www.md5 to otherbox.com: Completed
Performing DNS backup
Stage 1 DNS backup: Completed
Transfering zone_records.tar.gz to otherbox.com: Completed
Transfering zone_records.md5 to otherbox.com: Completed
Stage 2 DNS backup: Completed
Transfering named.conf.tar.gz to otherbox.com: Completed
Transfering named.conf.md5 to otherbox.com: Completed
Performing Apache backup: Completed
Transfering apache.tar.gz to otherbox.com: Completed
Transfering apache.md5 to otherbox.com: Completed
Performing MySQL backup
Stage 1 MySQL backup:<br>
 
If it's ending where you show it ending (with <br>) then it's not completing.

And it's stopping long before it even gets to the scp part.

It should continue similarly to this:
Code:
Performing MySQL backup 
     Stage 1 MySQL backup: Completed
     Stage 2 MySQL backup:     Stage 3 MySQL backup:
       Dumping database nobalone_tes:  Completed
Performing backup transfer to backup.host.com:  Completed
Performing cleanup operations:  Completed
with of course more databases besides the one I show in my example.

Jeff
 
So if it's not getting to the SCP part what do all of the transfer statements like

Transfering exim.conf.tar.gz to otherbox.com: Completed
Transfering exim.conf.md5 to otherbox.com: Completed

mean?

I restarted mysql and now the backup actually completes supposedly...

Performing MySQL backup
Stage 1 MySQL backup: Completed
Transfering full-mysql.tar.gz to otherbox.com: Completed
Transfering full-mysql.md5 to otherbox.com: Completed
Stage 2 MySQL backup: Stage 3 MySQL backup:
Dumping database mysql: Completed
Transfering mysql.sql.tar.gz to otherbox.com: Completed
Performing cleanup operations: Completed
<br>

Still nothing, though.
 
I didn't read your first post carefully enough:( .

You're using the option that transfers one file at a time.

I'm not. Sorry about the confusion.

I've had similar experience using ftp when there's been a login connection; it appears that the sysbk log can't tell if there was a login problem or not.

Have you looked at your secure log on the backup system? That might give you some insight as to why the login isn't being completed.

Jeff
 
Back
Top