Beiträge von bmhj2

I recently tried to get Greyhole to add an extra set of physical copies of the files in one of my shares. This maxed out my hard disk capacity and so I decided to go back on it and restore the number of copies to what it was previously. Following a reboot, I have run into some mySQL problems - screenshot attached of the Greyhole logs page and the dashboard. mySQL, Plex and Greyhole are not working and I appear to have lost the ability to use all three.

I have a system image taken a week or two ago - is that the best option or is there a way of getting OMV/mySQL to recover itself?

Thanks!

Nice one - that solved it. Thank you.

Yes, that's pointing to the right location.

Ownership of the files and folders in the new location appears to be correct: owner/group are listed as mysql/mysql.

The mysql.log file is blank - nothing in it.

Yes, they appear to have copied over - checked that already.

Here you go - looks as it did before to me...

I've rebooted now; MySQL is running and Greyhole appears to be behaving itself as well - both the indicators are green.

Still getting the error as per screenshot when I try and log in via MySQL management site.

Current load average is extremely high, though, as per second shot - not sure whether that's related.

Thank you - I can no longer get in via the SQL management panel - is that as expected?

Thanks. Is it possible/sensible to move the mySQL folder, then? (I went to Shared Folders and tried to alter the location of the MySQL folder there but it said this would not move the files and I would need to do that myself, at which point I decided not to mess around yet...) I have recently repartitioned the (120GB) SSD that previously was only the system drive and contained a lot of wasted space. Ideally I would like the mySQL databases on that drive, but I'm being a bit circumspect because I suspect that doing this wrong will break things....

Zitat von ryecoaaron

Yep, very easy. Decide where you want it - ie /media/long_uuid/mysql

Stop the service - service mysql stop
Make the directory - mkdir -p /media/long_uuid/mysql
Change the owner - chown mysql:mysql /media/long_uuid/mysql
Then copy all files to that location - cp -rfvp /var/lib/mysql/* /media/long_uuid/mysql/

Add datadir = /media/long_uuid/mysql to the extra options box in the plugin. Save and apply.

That's it.

Alles anzeigen

Will these steps work OK without making any alterations to the 'data directory' dropdown in the plugin? In other words, does the text added to the 'extra options' box override the contents of that dropdown?

Thank you!

That fixed it - thank you.

Hi,

I am going through MySQL setup again, this time on an RPi OMV setup that I'm making for a friend.

Was following instructions here and above in this thread to set up MySQL as a precursor to setting up Greyhole. While setting MySQL admin passwords as per step 6 of the guide (modified as per earlier posts in this thread which responded to my question), MyWebSQL logged out and went back to its login window, and wouldn't log back in again. Now if I try to get back into the management site, I get an error message (see screenshot) and can't log in as root, either using the blank password or the one I had set for two out of the four users by the time of the problem.

Any ideas how I can get back in to finish editing the root passwords?

Thanks!

I can do the SSH but have no idea about the xming or the systemrescuecd. I'll put its head back on and work on it that way. Thanks for the advice.

Any advice on how best to repartition the system drive if the system is headless? I see in the 'backup' plugin that gparted offers advice NOT to try running this on a headless system. Am I going to need to dig out some cables and move the box, or are there any short cuts?

Thanks!

Had to wait till I got home to test this one out; but when I got back I found the server in suspend mode, and it appears to have fixed itself after a reboot this morning. I can't explain why. Just tested it with a pm-suspend via shell and that's working too. I don't know what happened but all's well for now.

Will post again on here if I encounter a repeat of the problem.

Thanks for helping all the same....

Hi, thanks for getting back to me.

The motherboard is a Gigabyte GA-H77-D3H.

'Suspend' does work if you press the power button on the case - this is what I have configured it to do in the OMV settings.

Or did you mean running the suspend command via shell?

Should have added: I haven't found anything in crontabs that would appear to be keeping it awake.

B

Hi all,

I've configured autoshutdown to suspend the OMV when certain conditions apply. It's not doing so. The logs show that it has issued the command 'pm-suspend' as expected, but the server didn't, as far as I can tell, suspend - there are no gaps in the performance stats graphs, which instead show quite a high level of CPU activity and high load averages through the night.

Any ideas what might be causing this?

Thanks.

Thank you - I should have mentioned that I had tried that, without success. However, I'd misinterpreted the instructions in the @ekasperc post, so thank you for having clarified them. It's now working fine again.

I used this and made it work but realised on logging in just now that I hadn't thanked you. Cheers!