Does Greyhole keep a list of files?

ksburgess
Posts: 41
Joined: Sun Jan 29, 2012 6:29 pm

Does Greyhole keep a list of files?

Postby ksburgess » Thu May 10, 2018 4:36 am

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 :(

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Does Greyhole keep a list of files?

Postby bigfoot65 » Thu May 10, 2018 5:16 am

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.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

ksburgess
Posts: 41
Joined: Sun Jan 29, 2012 6:29 pm

Re: Does Greyhole keep a list of files?

Postby ksburgess » Thu May 10, 2018 6:49 am

Where is the Greyhole database? When I launch phpMyAdmin, these are the databases listed:

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

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Does Greyhole keep a list of files?

Postby bigfoot65 » Thu May 10, 2018 7:03 am

I cannot access the link you provided.

Check in the hda_production database.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

ksburgess
Posts: 41
Joined: Sun Jan 29, 2012 6:29 pm

Re: Does Greyhole keep a list of files?

Postby ksburgess » Thu May 10, 2018 7:29 am

Okay when I go in phpMyAdmin says Server: localhost and the three databases listed are:

information_schema
phpmyadmin
test

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Does Greyhole keep a list of files?

Postby bigfoot65 » Thu May 10, 2018 9:05 am

Are you logging into phpmyadmin App as root?

You should see other databases, specifically hda_production.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

ksburgess
Posts: 41
Joined: Sun Jan 29, 2012 6:29 pm

Re: Does Greyhole keep a list of files?

Postby ksburgess » Thu May 10, 2018 6:49 pm

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

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Does Greyhole keep a list of files?

Postby bigfoot65 » Fri May 11, 2018 4:46 am

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.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

Who is online

Users browsing this forum: No registered users and 7 guests