Recommended way to backup/restore OH2 configurations and things?

thefathefa · February 11, 2018, 6:22pm

@aksnet, thanks for your scripts, very interesting. Just one question : why didn’t you consider using amanda as a basis for your backups?
I did set Amanda up, have it running and yes, what I see is that it is not backing up influxdb & grafana stuff but I was thinking that might be possible to add it to the amanda config file and yet you did choose another way, so I thought I’d ask the question

Thanks,

aksnet · February 12, 2018, 8:06am

@thefathefa, When i started to work on the script i guess amanda was not yet implemented or only in some beta versions already.
So i have never looked into it to be honest.
I just opened the 2 main Amanda pages and will see if a switch might be an option.

BR
Andreas

mstormi · February 12, 2018, 8:15am

Sure it is. Just add the directories you want to backup to /etc/amanda/<yourconfig>/disklist .

aksnet · February 12, 2018, 8:31am

@mstormi, would it be possible to stop the grafana service as well before the backup via amanda? Or do i have to do this manually before starting amanda?

Andreas

mstormi · February 12, 2018, 9:09am

You can write a simple script to do this and run Amanda afterwards.
Then again I don’t think it’s required to stop Grafana, it’s more of a myth. Try to backup a runnning Grafana and to then restore it if to prove this if you feel uncomfortable about this.

tailor · February 12, 2018, 9:34am

I’m using a custom script for backing up openHAB, Grafana and InfluxDB on my Ubuntu machine. The 3 zip files get afterward synced to Google Drive (Grive2). The script get executed automatically with a dedicated Cron job.

#!/usr/bin/env bash

#####################################################
# Date with Timestamp
#####################################################
echo "+-+-+-+-+-+-+ Set Timestamp  +-+-+-+-+-+-+-+-+"
DATE=`date +%Y_%m_%d-%H_%M_%S`

#####################################################
# Backup openHAB
#####################################################
echo "+-+-+-+-+-+-+ openHAB Backup +-+-+-+-+-+-+-+-+"
sudo openhab-cli backup

#####################################################
# Backup Grafana
#####################################################
echo "+-+-+-+-+-+-+ Grafana Backup +-+-+-+-+-+-+-+-+"
#Stop Grafana service
sudo systemctl stop grafana-server
#Backing up ini file
mkdir /var/lib/openhab2/backups/tmp_grafana/
mkdir /var/lib/openhab2/backups/tmp_grafana/$DATE/
sudo cp -arv /etc/grafana/grafana.ini /var/lib/openhab2/backups/tmp_grafana/$DATE/grafana.ini
#Backing up a database
sudo cp -arv /var/lib/grafana/grafana.db /var/lib/openhab2/backups/tmp_grafana/$DATE/grafana.db
#Start Grafana service
sudo systemctl start grafana-server
#Create Zip File
cd /var/lib/openhab2/backups/tmp_grafana/$DATE
sudo zip -r /var/lib/openhab2/backups/grafana-backup-$DATE.zip ./*
#delete tmp folder
rm -rf /var/lib/openhab2/backups/tmp_grafana



#####################################################
# Backup Influxdb
#####################################################
echo "+-+-+-+-+-+-+ Influxdb Backup +-+-+-+-+-+-+-+"

#Backing up the metastore
influxd backup /var/lib/openhab2/backups/tmp_influxdb/$DATE/
#Backing up a database
influxd backup -database openhab_db /var/lib/openhab2/backups/tmp_influxdb/$DATE/
#Backing up conf file
cp -arv /etc/influxdb/influxdb.conf /var/lib/openhab2/backups/tmp_influxdb/$DATE/influxdb.conf
#Create Zip File
cd /var/lib/openhab2/backups/tmp_influxdb/$DATE
zip -r /var/lib/openhab2/backups/influx-backup-$DATE.zip ./*
#delete tmp folder
rm -rf /var/lib/openhab2/backups/tmp_influxdb


############################################
# Sync to Google Drive
############################################
sudo cp -vnpr "/var/lib/openhab2/backups/." "/home/smarty/grive/@Backups/openHAB smarty-nuc"
cd "/home/smarty/grive/"
grive -s "@Backups/openHAB smarty-nuc"

# vim: filetype=sh

thefathefa · February 12, 2018, 5:04pm

Thanks Markus, I think I see it for Grafana, yes, but what about influxdb? If the only way to do backhup is to use influxdb backup then, I’m not sure how Amanda would work?

mstormi · February 12, 2018, 8:29pm

Well I don’t know where influxdb is placing its data but as can be seen in the script above you can actually run an influx command to create a backup. Place these into a directory and add that to Amanda disklist.

rlkoshak · February 12, 2018, 8:33pm

Usually its /var/lib/influxdb.

thefathefa · February 18, 2018, 6:16pm

@mstormi, thanks for this.
I’m trying to have all the backup related stuff in one place and was looking at how to configure a script to be executed before Amanda performs the backup but before I spend time on this I was wondering if any of you are backing up influxdb by just backing up the folder mentioned by @rlkoshak Rich (Usually its /var/lib/influxdb). Something tells me it is probably not a good idea, but I thought I’d check.

allias · February 20, 2018, 7:33pm

As I could not find the public location of the source, I am asking here. My
openhab-cli backup (or /usr/share/openhab2/runtime/bin/backup) does actually not produce a file , I think due to a bug towards the end of the file.

a) is this known?
b) where is the right place to provide a pull req ?

rlkoshak · February 20, 2018, 9:47pm

@Benjy, any ideas about a potentail bug in the backup scripts?

Benjy · February 21, 2018, 12:08am

I think I see the same thing, but only when naming a file right?

If you found the error already the place for a PR is https://github.com/openhab/openhab-linuxpkg and it would be very much appreciated

Benjy · February 21, 2018, 11:04pm

Sorry @rlkoshak and @alias that was completely the wrong link… Not sure how I screwed that one up… The following is a direct path to the github file…

github.com

openhab/openhab-distro/blob/master/distributions/openhab/src/main/resources/bin/backup

#!/bin/sh

setup(){
  if [ "$1" = "--help" ] || [ "$1" = "-h" ]; then
    echo "Usage: backup [filename]"
    echo ""
    echo "  e.g. ./backup                 << Makes a file with a timed filename"
    echo "       ./backup myBackup.zip    << Makes a file called myBackup.zip"
    echo ""
    echo "Use this script to backup your openHAB configuration, you can use the 'restore' script"
    echo "from any machine to transfer your configuration across to another instance."
    echo ""
    echo "Set $OPENHAB_BACKUPS to change the default backup directory."
    exit 0
  fi

  ## Ask to run as root to prevent us from running sudo in this script.
  if [ "$(id -u)" -ne 0 ]; then
    echo "Please run this script as root! (e.g. use sudo)" >&2
    exit 1

This file has been truncated. show original

Benjy · February 26, 2018, 11:38am

Hi @alias, I found the bug and submitted a PR, could you confirm that this fixes the issue?

ariela · April 4, 2018, 10:32am

Guys,

I need to move from one VM to another.
The original VM is Debian 32 bit with latest openHABian (OH2), and I would like to move to Debian 64 bit (as Grafana 32 bit is not supported).

Do I need to install java 32 bit? is sudo openhab-cli backup/restore the right way, considering I’ve also a lot of zwave devices (xml files to be moved as well)?

Any suggestion will be appreciated

Thanks
Andrea

rlkoshak · April 4, 2018, 1:14pm

Backup and restore scripts will grab everything.

Though if the new VM will be running the same OH version, you can just copy over /etc/openhab2 and /var/lib/openhab2 to the new VM and you will have everything.

mstormi · April 4, 2018, 1:45pm

Uhh, now while not completely wrong, that’s a somewhat dangerous statement.
A typical openHABian setup consists of more than just plain OH and it’s config files: mosquitto, NGINX, …

rlkoshak · April 4, 2018, 3:34pm

True, I was only addressing the OH part since that is what Andrea was asking about.

As far as I know, there is no automated or even complete guide for dealing with migrating everything that openHABian can install to a new machine.

ariela · April 4, 2018, 4:14pm

and what about Oracle Java? still makes sense to use the 32 bit or can I install the 64 bit version?