Re: db backup script in gentoo - Mailing list pgsql-general

On Sun, Nov 30, 2008 at 3:16 PM, Andrus <kobruleht2@hot.ee> wrote:
> Scott,
>
>> emerge lftp
>
> root # emerge lftp
> Calculating dependencies... done!
>
>>>> Emerging (1 of 1) net-ftp/lftp-3.4.6 to /
>>>> Downloading 'http://distfiles.gentoo.org/distfiles/lftp-3.4.6.tar.gz'
>
> --23:39:28--  http://distfiles.gentoo.org/distfiles/lftp-3.4.6.tar.gz
>          => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
> Lahendan distfiles.gentoo.org... 64.50.236.52, 64.50.238.52,
> 140.211.166.134, ...
> Loon C¼hendust serveriga distfiles.gentoo.org|64.50.236.52|:80... C¼hendus
> loodud.
> HTTP pC¤ring saadetud, ootan vastust... 404 Not Found
> 23:39:29 VIGA 404: Not Found.
>
>>>> Downloading
>>>> 'http://distro.ibiblio.org/pub/linux/distributions/gentoo/distfiles/lftp-3.4.6.tar.gz'
>
> --23:39:29--
>  http://distro.ibiblio.org/pub/linux/distributions/gentoo/distfiles/lftp-3.4.6.tar.gz
>          => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
> Lahendan distro.ibiblio.org... 152.46.7.109
> Loon C¼hendust serveriga distro.ibiblio.org|152.46.7.109|:80... C¼hendus
> loodud.
> HTTP pC¤ring saadetud, ootan vastust... 404 Not Found
> 23:39:31 VIGA 404: Not Found.
>
>>>> Downloading 'ftp://lftp.yar.ru/lftp/old/lftp-3.4.6.tar.gz'
>
> --23:39:31--  ftp://lftp.yar.ru/lftp/old/lftp-3.4.6.tar.gz
>          => `/usr/portage/distfiles/lftp-3.4.6.tar.gz'
> Lahendan lftp.yar.ru... 193.233.48.99
> Loon C¼hendust serveriga lftp.yar.ru|193.233.48.99|:21... ebaCµnnestus:
> Connection refused.
> !!! Couldn't download 'lftp-3.4.6.tar.gz'. Aborting.

Sounds like your install of gentoo is broken somehow.  I'd check a
gentoo support forum for help, or wait and see if someone here knows
it well enough to help you out.

>> Because ftp is running as a cron?  Doesn't have the right permissions?
>
> I ran script from command line as root.
> Running from cron does not also upload copy. since I used cron -e as root,
> script runs probably in cron also as root.

Don't do that.  Create an extra account on both machines with a
password set to something you know and use that.  If they're both unix
/ linux boxes look into using rsync, which is much more stable, just
setup a set of ssh keys on the machine that's running rsync and put
them in authorized_keys file on the destination.  google it, there's
lots of howtos on that.

>> Because it appeared the username and password were failing?
>> Maybe a lack of EOF in the
>> original example you posted.  Could be a lot of reasons.
>
> This script tries to write to /root/my-backup directory in ftp server which
> fails.
> I fixed this and now it works.
> There is no EOF in script but it still works.

OK, find out how to create users on your gentoo server, and see if you
can figure out what's broken in emerge so you can install lftp.  It's
much better than regular ftp, as it has assured transfer completion
and other useful features if you're interested in making sure the file
gets transferred.  Or switch to rsync, which is how I do it.