Re: [BackupPC-users] Dump Databases

2014-11-20 Thread Carl Cravens
On 11/20/2014 07:03 AM, Fanny Alexandra Oyarzún Bórquez wrote: I databases postgres and mysql to back and I wonder if is it possible to add two script DumpPreUSerCmd?, eg DumpPreUSerCmd $sshPath -q -x -l root $host /usr/local/sbin/automysqlbackup.sh;$sshPath -q -x -l root $host

Re: [BackupPC-users] lastlog

2014-10-30 Thread Carl Cravens
Why not dump the SQL data live to a text file and back that up? That's what mysqldump is for... you can back up everything you need to restore an entire database without ever taking down the mysql server. And this makes restores much simpler... if a developer drops an table by mistake, you

Re: [BackupPC-users] Running BackupPC and Nagios web interfaces from the same box

2014-10-14 Thread Carl Cravens
On 10/14/2014 02:53 PM, xpac wrote: Is there a way to make it so that the BackupPC interface doesn't have to user backuppc as the user in httpd.conf? Or some other way I can do this? Take a look at the suexec Apache module. It lets you specify which user:group each virtual host runs as. I

Re: [BackupPC-users] QNX 4.23A

2014-09-19 Thread Carl Cravens
Can you compile rsync from source? That's what I used to have to do on HP-UX and other systems that didn't come with GNU tools... install GCC and then compile everything I wanted. (Heck, that's what I used to do with everything back on BSD/OS. I don't miss the days of having to compile Perl

Re: [BackupPC-users] 504 Gateway Time-out on Backuppc web interface

2014-09-03 Thread Carl Cravens
# ps -ef |grep BackupPC root 7014 6189 0 08:31 pts/000:00:00 grep BackupPC backuppc 14760 1 0 2013 ?00:37:44 /usr/bin/perl /usr/share/backuppc/bin/BackupPC -d backuppc 14791 14760 0 2013 ?1-17:52:08 /usr/bin/perl /usr/share/backuppc/bin/BackupPC_trashClean If

Re: [BackupPC-users] 504 Gateway Time-out on Backuppc web interface

2014-09-03 Thread Carl Cravens
I'm assuming Ubuntu is close enough to stock Debian. The main BackupPC log is in /var/lib/backuppc/log. If you need to look at compressed logs, use BackupPC_zcat, as the developer didn't use standard gzip-compatible compression. My startup section looks like this: 2014-09-03 14:00:48 Reading

Re: [BackupPC-users] Queue Order / Queue Pools

2014-08-28 Thread Carl Cravens
This is a feature I've wanted as well. I have virtual machines running on multiple hypervisors, and I'd prefer to only run one backup per hypervisor at a time. If I could do that, I could get away with backups during the day... but if I back up the main file server and the groupware server at

Re: [BackupPC-users] Queue Order / Queue Pools

2014-08-28 Thread Carl Cravens
easier to deal with. On 08/28/2014 09:45 AM, Les Mikesell wrote: On Thu, Aug 28, 2014 at 8:11 AM, Carl Cravens ccrav...@excelii.com wrote: This is a feature I've wanted as well. I have virtual machines running on multiple hypervisors, and I'd prefer to only run one backup per hypervisor

Re: [BackupPC-users] Have to set Apache User to BackupPC?

2014-05-15 Thread Carl Cravens
Debian does it by making index.cgi setuid backuppc. Now that's a binary and not a script, and I don't know if that's the standard BackupPC or if the Debian maintainer has written a setuid wrapper. Another way to do it is to set up a separate virtual host for BackupPC and use suexec to run the

[BackupPC-users] rsync file list myth?

2014-05-15 Thread Carl Cravens
rsync will load the whole directory tree at both ends before starting to walk for the comparison I keep seeing statements to this effect, but it hasn't been true for rsync defaults for years. From the rsync manpage: Beginning with rsync 3.0.0, the recursive algorithm used is now an

Re: [BackupPC-users] Backuppc and KVM virtual machine

2014-01-03 Thread Carl Cravens
The VM isn't an issue (my BackupPC has run in a KVM guest for over two years), but using file-based storage (a filesystem inside a file stored on another filesystem) is extremely inefficient (we recently ran benchmarks on file versus raw device... the performance is awful in comparison). Use a

Re: [BackupPC-users] first time full and then only increamental backup

2013-12-19 Thread Carl Cravens
This is something it took me two years of using BackupPC before I realized... BackupPC doesn't treat full and incremental quite the way you expect. When BackupPC does an rsync incremental, it compares to the last full for purposes of deciding what to download and *then* does deduplication

Re: [BackupPC-users] BackupPC for laptops?

2013-12-19 Thread Carl Cravens
On 12/04/2013 01:34 PM, Russell R Poyner wrote: In my new position I'm looking for options for backing up laptops and tablets. Most of these machines rarely connect to our wired network or vpn. We solved this by creating a script on the client side that rsync's the user's data to a central

Re: [BackupPC-users] Filesystem?

2013-12-02 Thread Carl Cravens
My experience troubleshooting I/O performance over iSCSI is that Ext4 journaling has a much higher CPU overhead than XFS does. Papers I've read show evidence that modern XFS journaling scales better (better performance) than Ext4 as disks grow larger. http://lwn.net/Articles/476263/ As a

Re: [BackupPC-users] Starting with backuppc

2013-11-11 Thread Carl Cravens
JLuc, Did you run the init.d script as root? The best way to start a process normally started at boot on Debian or a derivative (such as Ubuntu) is with... $ sudo invoke-rc.d backuppc start This ensures that it starts in the same environment that it does at boot, and doesn't pick up any

Re: [BackupPC-users] BackupFilesExclude

2013-02-15 Thread Carl Cravens
You don't need the trailing /* with rsync. I use that in a few places, but only because it excludes everything under the directory, but backs up the directory itself. Useful for restoring directory meta-data. Note that the excludes are simply passed to the underlying transport (rsync, tar,

Re: [BackupPC-users] Some usefull features for the future

2013-02-13 Thread Carl Cravens
I've built up quite a list of features I could really use... * prioritization (the ERP system gets top priority every 24 hours, no matter how many hosts are further past-due) * exclusive groups (don't back up more than one host in group virtual host 1 at a time) * profiles (this is a Windows

Re: [BackupPC-users] BackupPC-Visualize - visual plot of host backup durations

2013-02-11 Thread Carl Cravens
Thanks. That was dumb of me... I've done a lot of Perl coding (since Perl 4), but I'm a little rusty. I don't use host sorting much, so I hadn't noticed it wasn't working right. On 02/02/2013 08:19 PM, The Lunatic wrote: On 01/28/2013 11:46, Carl Cravens wrote: I've written a little tool

Re: [BackupPC-users] BackupPC-Visualize - visual plot of host backup durations

2013-02-11 Thread Carl Cravens
Also merged. Not a common occurrence, but it would cause the script to keep failing until a successful backup occurred. Thanks. On 02/06/2013 05:04 AM, Jonathan Schaeffer wrote: avoid the error when parsing a host that has never been backed up -- Carl D Cravens (ccrav...@excelii.com), Ext

[BackupPC-users] BackupPC-Visualize - visual plot of host backup durations

2013-01-28 Thread Carl Cravens
I've written a little tool to help analyze BackupPC scheduling that I thought others might find useful. It is meant to generate plots that can be viewed from the web, but it's just as easily used from the command line. https://github.com/ravenx99/backuppc-visualize/ Over the past year+ that

Re: [BackupPC-users] Offsite copy

2012-06-26 Thread Carl Cravens
I manage my offsite disaster-recovery backup (which is rsync'd over the net) by: + Creating a directory of links that point only to the most recent full and incremental for each host. (Incrementals always go against the last full.) + rsync each host directory individually. This breaks dedupe