sftp/ssh.

I wrote up this last year and have been using since.
http://wiki.mikrotik.com/wiki/Using_SSH_for_system_backup

I have a MT database which produces a list of MT IPs, which my script loops 
through and backs them up as described above.

If you want a diff between two MTs, they are filenamed based on date, so it's 
real simple to determine changes over time with the diff command.

j...@huehuetenango:~/bin> more /usr/local/mis/bin/mtbackup 
#!/bin/bash

for mt in `ssh -o ConnectTimeout=5 -n j...@mocha mysql -h 127.0.0.1 -u root -s 
-pxxxxxxxx -e \"use mt\; select ip from router where sshaccess is not null \"` 
; do
 mtnamer=`ssh -o ConnectTimeout=5 -n j...@mocha mysql -h 127.0.0.1 -u root -s 
-pxxxxxxxx -e \"use mt\; select hostname from router where ip=\'$mt\' \"`
 mtname=`echo $mtnamer |sed -e "s/ //g"`
 bfile=`date +%Y%m%d-$mtname`
 ssh -o ConnectTimeout=5 ad...@$mt export file=$bfile
 sftp ad...@$mt:$bfile.rsc /home/jp/mtbackups/$bfile.rsc
 ssh -o ConnectTimeout=5 ad...@$mt /file remove $bfile.rsc
done



On Tue, Jun 23, 2009 at 12:40:06AM -0400, Josh Luthman wrote:
> FTP and ssl?
> 
> On 6/23/09, rabbtux rabbtux <rabb...@gmail.com> wrote:
> > not too comfortable with ftp, clear text passwords, etc...
> >
> > On Sat, Jun 20, 2009 at 2:51 AM, Scott Reed
> > <scottr...@onlyinternet.net>wrote:
> >
> >> I believe it supports ssh terminal and ftp only.
> >> There is an API available also.  I do not remember what all is available
> >> in the API, but it can do a lot.
> >> I take it your backup system does not do ftp?
> >>
> >> rabbtux rabbtux wrote:
> >> > Nope, Didn't work.  Using MTv3.17 and found that even though it will so
> >> some
> >> > sftp, it will not do rsync, or even FISH protocol that works with a
> >> vanilla
> >> > ssh server. sorry :-(
> >> >
> >> > On Fri, Jun 19, 2009 at 9:29 AM, Brad Belton <b...@belwave.com> wrote:
> >> >
> >> >
> >> >> I would be interested in this as well.  Please share on-list!
> >> >>
> >> >> Thanks,
> >> >>
> >> >>
> >> >> Brad
> >> >>
> >> >>
> >> >> -----Original Message-----
> >> >> From: wireless-boun...@wispa.org [mailto:wireless-boun...@wispa.org] On
> >> >> Behalf Of rabbtux rabbtux
> >> >> Sent: Friday, June 19, 2009 11:27 AM
> >> >> To: WISPA General List
> >> >> Subject: [WISPA] MT backup system, need script clues
> >> >>
> >> >> All,
> >> >>
> >> >> I've used the excellent open source backup program, rsnapshot, for
> >> >> years
> >> >> with good results.  I recently noticed that routeros supports sftp.
> >> >> I'd
> >> >> like to get snapshot backups of all our APs.  Here's how it would work:
> >> >> Rsnapshot can run a few commands on each system before backing up the
> >> file
> >> >> system.  I'd like to 1) remove all *.backup and *.rsc files. 2) run a
> >> fresh
> >> >> binary backup, followed by a text export.  3) The normal rsnapshot
> >> function
> >> >> resumes getting a copy of the filesystem.
> >> >>
> >> >> Just having trouble putting the parts of the pre-run MT script.
> >> >> Specifically how to delete the existing backup files.
> >> >>
> >> >> Any Hints appreciated, as everyone could use this 'full seatbelt"
> >> >> backup
> >> >> solution.  It includes daily changes to any file or configuration
> >> changes
> >> >> on
> >> >> each routeros system.
> >> >>
> >> >> Thanks,
> >> >> Marshall
> >> >> Rabbit Meadows Technology
> >> >>
> >> >>
> >> >>
> >> >>
> >> ----------------------------------------------------------------------------
> >> >> ----
> >> >> WISPA Wants You! Join today!
> >> >> http://signup.wispa.org/
> >> >>
> >> >>
> >> ----------------------------------------------------------------------------
> >> >> ----
> >> >>
> >> >> WISPA Wireless List: wireless@wispa.org
> >> >>
> >> >> Subscribe/Unsubscribe:
> >> >> http://lists.wispa.org/mailman/listinfo/wireless
> >> >>
> >> >> Archives: http://lists.wispa.org/pipermail/wireless/
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> --------------------------------------------------------------------------------
> >> >> WISPA Wants You! Join today!
> >> >> http://signup.wispa.org/
> >> >>
> >> >>
> >> --------------------------------------------------------------------------------
> >> >>
> >> >> WISPA Wireless List: wireless@wispa.org
> >> >>
> >> >> Subscribe/Unsubscribe:
> >> >> http://lists.wispa.org/mailman/listinfo/wireless
> >> >>
> >> >> Archives: http://lists.wispa.org/pipermail/wireless/
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >> --------------------------------------------------------------------------------
> >> > WISPA Wants You! Join today!
> >> > http://signup.wispa.org/
> >> >
> >> --------------------------------------------------------------------------------
> >> >
> >> > WISPA Wireless List: wireless@wispa.org
> >> >
> >> > Subscribe/Unsubscribe:
> >> > http://lists.wispa.org/mailman/listinfo/wireless
> >> >
> >> > Archives: http://lists.wispa.org/pipermail/wireless/
> >> >
> >> > ------------------------------------------------------------------------
> >> >
> >> >
> >> > No virus found in this incoming message.
> >> > Checked by AVG - www.avg.com
> >> > Version: 8.5.372 / Virus Database: 270.12.80/2187 - Release Date:
> >> 06/19/09 06:53:00
> >> >
> >> >
> >>
> >> --
> >> Scott Reed
> >> Sr. Systems Engineer
> >> GAB Midwest
> >> 1-800-363-1544 x4000
> >> Cell: 260-273-7239
> >>
> >>
> >>
> >>
> >> --------------------------------------------------------------------------------
> >> WISPA Wants You! Join today!
> >> http://signup.wispa.org/
> >>
> >> --------------------------------------------------------------------------------
> >>
> >> WISPA Wireless List: wireless@wispa.org
> >>
> >> Subscribe/Unsubscribe:
> >> http://lists.wispa.org/mailman/listinfo/wireless
> >>
> >> Archives: http://lists.wispa.org/pipermail/wireless/
> >>
> >
> >
> > --------------------------------------------------------------------------------
> > WISPA Wants You! Join today!
> > http://signup.wispa.org/
> > --------------------------------------------------------------------------------
> >
> > WISPA Wireless List: wireless@wispa.org
> >
> > Subscribe/Unsubscribe:
> > http://lists.wispa.org/mailman/listinfo/wireless
> >
> > Archives: http://lists.wispa.org/pipermail/wireless/
> >
> 
> 
> -- 
> Josh Luthman
> Office: 937-552-2340
> Direct: 937-552-2343
> 1100 Wayne St
> Suite 1337
> Troy, OH 45373
> 
> "When you have eliminated the impossible, that which remains, however
> improbable, must be the truth."
> --- Sir Arthur Conan Doyle
> 
> 
> --------------------------------------------------------------------------------
> WISPA Wants You! Join today!
> http://signup.wispa.org/
> --------------------------------------------------------------------------------
>  
> WISPA Wireless List: wireless@wispa.org
> 
> Subscribe/Unsubscribe:
> http://lists.wispa.org/mailman/listinfo/wireless
> 
> Archives: http://lists.wispa.org/pipermail/wireless/

-- 
/*
Jason Philbrook   |   Midcoast Internet Solutions - Wireless and DSL
    KB1IOJ        |   Broadband Internet Access, Dialup, and Hosting 
 http://f64.nu/   |   for Midcoast Maine    http://www.midcoast.com/
*/


--------------------------------------------------------------------------------
WISPA Wants You! Join today!
http://signup.wispa.org/
--------------------------------------------------------------------------------
 
WISPA Wireless List: wireless@wispa.org

Subscribe/Unsubscribe:
http://lists.wispa.org/mailman/listinfo/wireless

Archives: http://lists.wispa.org/pipermail/wireless/

Reply via email to