Page 1 of 1

Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 4:36 am
by ksburgess
I appear to have a HDD failure on one of my pool drives. The boot sequence reports a SMART pass, but the drive just clicks and won't spin up. Using an Ubuntu LiveUSB sees the drive, but I cannot navigate its contents, so I think it's well and fully dead.

I do have off-site backups of my data, but they are via iDrive with my Samba shares mapped as network drives on my Windows computer (since Crashplan stopped offering their home-level backup service :( ).

However, due to backing up from the Samba shares, I can't really see what Greyhole actually had stored on THAT drive. Some of my files were mirrored across both pool drives, but not all.

Commenting out the bad drive in the fstab allowed me to boot into the HDA and much is working, but I need to figure out what files were on that drive, I think. Is there a way to get Greyhole to tell me what files were on that drive? What's the best practice for this?

I think at this point I'm going to buy two drives to replace this one and mirror all the files at least once :(

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 5:16 am
by bigfoot65
Is there a way to get Greyhole to tell me what files were on that drive?
You might check the greyhole database.

Use an app such as adminer App or phpmyadmin App. I believe there is a table in the database that reflects where files are stored. Using that, you should be able to see what's where.

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 6:49 am
by ksburgess
Where is the Greyhole database? When I launch phpMyAdmin, these are the databases listed:

https://www.screencast.com/t/4JheXpvYYyi

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 7:03 am
by bigfoot65
I cannot access the link you provided.

Check in the hda_production database.

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 7:29 am
by ksburgess
Okay when I go in phpMyAdmin says Server: localhost and the three databases listed are:

information_schema
phpmyadmin
test

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 9:05 am
by bigfoot65
Are you logging into phpmyadmin App as root?

You should see other databases, specifically hda_production.

Re: Does Greyhole keep a list of files?

Posted: Thu May 10, 2018 6:49 pm
by ksburgess
Okay sorry for the delay; day got away from me. Logging in as root worked. I do see the greyhole database. There's a table called du_stats that seems to have files listed. I'm not seeing a column that's obviously a particular drive, though. I see these columns: share,full_path,depth,size

Tables listed in the database are:

du_stats
settings
tasks
tasks_completed

Re: Does Greyhole keep a list of files?

Posted: Fri May 11, 2018 4:46 am
by bigfoot65
I'm not seeing a column that's obviously a particular drive, though.
Not sure if there is anywhere else you can look.

You might consider contacting the Greyhole author at his site.

Since this is an add-on application, we have limited support capability.