Unfortunately, if I want a copy of the MT filesystem the sftp does not work for subdirectories like 'hotspot' for my customized login pages.
On Tue, Jun 23, 2009 at 8:27 AM, jp <j...@saucer.midcoast.com> wrote: > 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/ > -------------------------------------------------------------------------------- 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/
