Thinking out loud as I type through this, something might come to me….

So I managed to pull everything over, nodes came over fine, permissions are correct, etc… and now the dreaded “red draw error” on the graphs. :-/

Picking a random device, digging into the graph, displaying the details of RRD Command shows simply:

RRDTool Output:

Total time: 10.26 | RRDtool time: 10.26s

If I go to the shell and run the rrdtool command manually, it will generate the .png file, but the data is only good to where I did the migration off the old server. Hmm.   So run poller.php –d on that node… no errors generated. Hmmm. Ok… cron is running the pollers as expected, so data is being (presumably) collected. Ok, let’s look at a poller.php –d and see what we can determine… AHA!

STDERR[

sh: 1: /opt/rrdtool-1.4.9/bin/rrdtool: not found

]

Let’s see what I can do to fix this.

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: Thursday, August 13, 2015 10:45 AM
To: observium@observium.org
Subject: Re: [Observium] backup data

I was going to write a migration guide in the documentation for you, but I got busy.

Yeah, mysqldump, the nat the other end after creating the database (before the isntall guide tells you to run update.php, do mysql -u user -p'password' database_name < backupfile.sql

adam.

On 13/08/2015 16:35:49, Ron Marosko <ron@rjr-services.com> wrote:

All my answer are belong to google. ;-)

mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

Sorry for the bandwidth.

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Ron Marosko
Sent: Thursday, August 13, 2015 8:44 AM
To: 'Observium Network Observation System'
Subject: Re: [Observium] backup data

Sorry to resurrect this thread… apparently at some point my system quit processing inbound syslog messages and I can’t figure out why.  I do see through tcpdump that the rsyslog messages are hitting the server, and rsyslogd is running on the observium host, just the messages are no longer showing up in the observium application.   I’m figuring this may be a good opportunity to stand up a new VM on 14.04 instead of 12.04 and just migrate everything over… so I’ll show my lack of knowledge of MySQL…. I know to copy config.php and rrd/*, but what’s the best way to back up the database? Just copy that file? Or export/import the database (and if so, how?)?

Thanks,

    Ron

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: Wednesday, June 10, 2015 5:45 AM
To: observium@observium.org
Subject: Re: [Observium] backup data

MySQL database, config.php and rrd/

Logs are just... logs, no need to back those up. :)

adam.

Sent from Mailbird

On 10/06/2015 11:43:47, Farshid Abediny <farshidabediny@gmail.com> wrote:

Hi,

how can we backup observium data that if our VMs lost we can recover data ?

only backup of database rrd/ logs/ folder is enough? 

thanks,

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium