perfSONAR User Q&A and Other Discussion

[Jeremy Palmer <>]

This may or may not be what you are looking for, but a while back I had some issues when I converted my nodes from standalone to a mesh config and I needed to clear out the OWAMP database. I used the following command to basically re-create the owamp database from scratch (deleting ALL data in the process):

/opt/perfsonar_ps/perfsonarbuoy_ma/bin/owdb.pl -i root

There is also a script in that directory for the bwctl database which I assume does the same thing for that db:

/opt/perfsonar_ps/perfsonarbuoy_ma/bin/bwdb.pl -i root

This appears to completely drop and recreate the database, so make sure thats what you really want to do.

Jeremy Palmer
Senior Network Engineer
ViaWest, Inc.
Office: 720.891.1045
Fax: 303-874-5236
http://www.viawest.com

On 7/25/2014 1:23 PM, Pol Llovet wrote:

After a lot of trial and error, I have managed to improve the experience by clearing out older data, but I still have a ton of nodes in my Throughput graph list (most now listed in the Inactive Tests list).  I have experimented with removing nodes from the 201407_NODES table, but that messes other things up (even removing just one host will screw up the rest). I can only assume that there is some other master-list of nodes that I have to edit in order to remove the nodes permanently. 

Any help on that?  

Also, on a different but somewhat related topic: should I be using the perfsonar-users list for this? This is the list that is posted on the perfsonar site, but I saw the other list in the internet2 sympa list...

Pol M. Llovet
Research Computing / Middleware

Montana State University
w: 406-994-3416
c: 406-646-6747

On Fri, Jul 25, 2014 at 12:13 PM, Andrew Lake <> wrote:

Hi,

Ah sorry, i sent you the wrong FAQ. I meant this: http://psps.perfsonar.net/toolkit/FAQs.html#Q29. I must have scrolled around while looking for it and not cleared my address bar.

It has pointer to a script already installed on your system. The other one does not do what you want (it's good to correct the link though). Sorry for the confusion.

Thanks,

Andy

On Jul 25, 2014, at 1:39 PM, Pol Llovet <> wrote:

I take it back, that links to the html. I don't know how to link to the raw file on google code.

Pol M. Llovet
Research Computing / Middleware

Montana State University
w: 406-994-3416
c: 406-646-6747

On Fri, Jul 25, 2014 at 11:37 AM, Pol Llovet <> wrote:

The link in the FAQ is wrong:

# wget http://anonsvn.internet2.edu/svn/perfSONAR-PS/trunk/perfSONAR_PS-Toolkit/scripts/ps-toolkit-migrate-backup.sh

--2014-07-25 11:34:43--  http://anonsvn.internet2.edu/svn/perfSONAR-PS/trunk/perfSONAR_PS-Toolkit/scripts/ps-toolkit-migrate-backup.sh

Resolving anonsvn.internet2.edu... 207.75.164.19, 2001:48a8:68fe::19

Connecting to anonsvn.internet2.edu|207.75.164.19|:80... connected.

HTTP request sent, awaiting response... 500 Internal Server Error

2014-07-25 11:34:43 ERROR 500: Internal Server Error.

I think it should probably be this:

https://code.google.com/p/perfsonar-ps/source/browse/perfSONAR_PS-Toolkit/scripts/ps-toolkit-migrate-backup.sh

Pol M. Llovet
Research Computing / Middleware

Montana State University
w: 406-994-3416
c: 406-646-6747

On Fri, Jul 25, 2014 at 6:47 AM, Andrew Lake <> wrote:

Hi,

We have a script that can help with that. See http://psps.perfsonar.net/toolkit/FAQs.html#Q60 for examples. The examples will mysql dump the old data to files and then delete it from the database. If you don't care about saving dumps of the data you can drop the --mysqldump-opts and --dumpdir options, and replace them with --no-save-dumps See the --help of that script for a full listing of options.

Thanks,
Andy

On Jul 24, 2014, at 5:46 PM, Pol Llovet <> wrote:

> I have tweaked the targeted hosts for bandwidth tests quite a lot, and now I am in a situation where I have lots of historical data for nodes that I don't need test against anymore.  The Graph UI takes a very long time to load due to the excessive number of hosts.
>
> How do I remove the host data?  Is it just a matter of dumping the mysql database and clearing it?
>
> thanks,
>
> pol
>
> Pol M. Llovet
> Research Computing / Middleware
> Montana State University
> w: 406-994-3416
> c: 406-646-6747