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 <[email protected]> wrote: > > not too comfortable with ftp, clear text passwords, etc... > > > > On Sat, Jun 20, 2009 at 2:51 AM, Scott Reed > > <[email protected]>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 <[email protected]> wrote: > >> > > >> > > >> >> I would be interested in this as well. Please share on-list! > >> >> > >> >> Thanks, > >> >> > >> >> > >> >> Brad > >> >> > >> >> > >> >> -----Original Message----- > >> >> From: [email protected] [mailto:[email protected]] 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: [email protected] > >> >> > >> >> 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: [email protected] > >> >> > >> >> 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: [email protected] > >> > > >> > 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: [email protected] > >> > >> 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: [email protected] > > > > 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: [email protected] > > 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: [email protected] Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/
