RN104 Stuck on booting 99% mysql.service

---

Kiptanoi_New wrote:
And how is the backup going to work?
How to do that? What do you have in mind there?

---

You said you were offloading data with ReclaiMe.  So that is your backup.

Great. The upload of my found data is happening now as a write.

After that, I am thinking of putting back my disk in reverse order.

Put my disk nr 4 as disk nr 1. (My disk nr 4 is the newest.)

And I am guessing the os will be on disk nr 1 in the NAS?
In that case the os will be on the newest disk at least.

After that I do a factory reset, updating os if it wants that.

And let the nas sync the disks, and after that put back my data on it again.

---

Kiptanoi_New wrote:

 

And I am guessing the os will be on disk nr 1 in the NAS?
In that case the os will be on the newest disk at least.

 

---

The OS is mirrored on all disks.

If you are wanting to avoid the reset, then the best thing to try after the data is safe is an OS reinstall from the front panel. Do this with the disks installed (original order is best).

That will change a couple of settings:

• the admin password will be reset to password
• the network connection will be reset to use DHCP with no bonding
• volume quota will be disabled (it is re-enabled from the volumes setting tab).

If this fails (or doesn't help), then I suggest moving directly to the default.  No need to change the disk order, as the default will reformat them all anyway.

StephenB 

I have now done a reset.

And after some days the sync was completed.

My reset did X-Raid, Raid5, and the name of it is "data"

out of the box, without inputs from me at all.

And then I copy over my backup from my usb.

And now is the USB disk in my NAS and doing my first backup job.

It should be finish today. The backup taking long time, it has working on it 27 hours now, and got 1 TB left to do of total 5.5 TB.

Now I wonder some stuff....

1)

Snapshots, do I need that on my data on the NAS?

And what is that? What use do I have of it?

(Sometimes it can be months for me without saving any new data to the nas, and sometimes I do save data to the nas many days in a row.)

And Snapshots have never saved me from failures that I run into with my NAS.

Like this one, with my force to reset the nas and so on...

So I guess I dont need Snapshots in the future, lol

2)

Other settings....

If I am looking at Volumes and settings on my "data"

in the section volume schedule and action:

- Scrub, what does that? How often should I have that set to?

- Defrag, that one should be enough with once a year, right?

- Balance? What is that? Do I need that? How often?

- Disk test? Once a week? is that to often? Once a month? Or what do you suggest here?

3)

And finaly this backup thing...

How do I setup a good backup for my nas?

I make a backup of all my data today.

And I have that job set to once a week (I could not find once a month)

What will that job do next week? Will it run the whole process again?

Or just copy over the new data that is on my nas?

And if no new data is on the nas, it will not run the job?

Once again, thank you for your time and help StephenB 

I really appreciates that.

---

Kiptanoi_New wrote:

 

1) Snapshots, do I need that on my data on the NAS?

And what is that? What use do I have of it?

---

They are similar to the Windows recycle bin.  If you accidentally delete a file or folder (or make a bit editing mistake), you can recover an older copy from the snapshot.  You can do that by right-clicking on the file/folder in Windows and clicking on "restore previous versions".

If you want to use them, then I don't recommend using the "smart" snapshots.  The problem with those is that Netgear never deletes the monthly ones, and over time that can fill up the data volume.  I use custom snapshots myself with 3 months retention on most shares.  You can tune the retention to balance the amount of snapshot data.

Note that if you download torrents, you shouldn't enable snapshots on that share.  Similarly if the share has a live database.  The reason is fairly technical - the net is that the main share will end up heavily fragmented, and you will also end up with a lot of snapshot data.

---

Kiptanoi_New wrote:

 

2)

Other settings....

If I am looking at Volumes and settings on my "data"

in the section volume schedule and action:

- Scrub, what does that? How often should I have that set to?

- Defrag, that one should be enough with once a year, right?

- Balance? What is that? Do I need that? How often?

- Disk test? Once a week? is that to often? Once a month? Or what do you suggest here?

 

---

Balance is a BTRFS maintenance function (the NAS uses the BTRFS file system).  Scrub is both a BTRFS and a RAID maintenance function.

Personally I run one of these tests each month, cycling through them 3x a year.  Scrub requires accessing all the data on all the disks, so it also serves as a disk test.  So I run those 2 months apart.  For instance,

• Disk Test (Jan, May, Sept)
• Balance (Feb, June, Oct)
• Scrub (Mar, July, Nov)
• Defrag (Apr, Aug, Dec)

This is done on a schedule, so I don't need to remember to run them. 

Disk Test and Scrub can take a couple of days, and the RN104 won't be as responsive when they are running. Balance and Defrag complete very quickly on my NAS (minutes), but the time needed does depend on your usage pattern.  Generally the less frequently you run them, the longer they take.

---

Kiptanoi_New wrote:

3)

And finaly this backup thing...

How do I setup a good backup for my nas?

 

---

Backing up to USB drives is a reasonable way.  One potential risk - if there is a power surge, then the backup drive might also fail due to the surge.  Another is physical loss - theft, fire, etc would result in losing both the backup and the NAS.  One way to defend against that is to make a full backup onto another drive every now and then, and store that somewhere off site.  If you don't have a lot of data, you could also use cloud backup (though that can be hard to set up for a NAS).

The backups can be set to run incrementally (and mine are).  But they will always run, and compare the files on the NAS with what is on the disk.  Then update anything that is out-of-date.

One potential annoyance is deleted files.  The normal backup jobs won't remove any files you delete from the USB disks for incremental backups.  There is a setting to delete everything on the backup and start fresh every now and then, which would help with that.  There is also a workaround, though it can be a bit tricky to set up.

Also, make sure you use a disk format that you can read from your PC, since if the NAS fails you'll need to do that.  NTFS is the best available option,

Note you can also connect the backup disk to a Windows PC, and back up the data from the PC (instead of using the NAS backup jobs).  FreeFileSync is one free tool that can do incremental backups from the PC (and which can be scheduled).

Cool thank you for the answers.

I can now  manage and setup some stuff on the nas, like maintenance stuff and so on.

And yeah, I might do that with this usb disk, keep it offline and just do manual backups 3 times a year or once every 6 mounth.

I have one other problem now.

I can not install any apps from the NAS gui or upload them and install.

The NAS is just saying it wont work: "Cannot install application X"

I have tried the apps I used before the crash, MySql, PHPMyAdmin, and PHP.

None of them work, so I tried others, random to check if anyone would work, but no app wont install from the NAS gui. "Cannot install application X"

---

Kiptanoi_New wrote:

but no app wont install from the NAS gui. "Cannot install application X"

---

That's because Debian 8 ("Jessie") has been archived by the Debian community.  The first post in this thread tells you what you need to change:

• https://community.netgear.com/t5/Using-your-ReadyNAS-in-Business/How-I-got-apt-update-and-install-to-work-with-Debian-Jessie/m-p/2306772#M199238

StephenB Thank you, I did try that.

I have documented and take photos with my phones.

Here are my files and folders inside NAS

Here is my source.list

Here is my apt.conf

I have then restarted the nas, and verified that the files are saved and on the nas.

All good there.

Installing PHPMyAdmin.

Then this happens, and I get mail that say:

Cannot install application PHPMyAdmin

And then I am back on admin login page.

Could you point me to the latest firmware that application works?
In that case I will be forced to install older firmware and never update it.

I need PHPMyAdmin and MySql server to work on my NAS.

After one last test, to install applications, it worked.

It works if I upload a downloaded application and installing it.

StephenB 

PHP app worked.

phpMyAdmin app worked.

But MySqlServer wont work to install.

tried mysqlr6_1.0.1_all.deb and mysqlr6_1.0.0_all.deb

and tried to install from nas gui and manually upload files.

But it wont install the application.

So I need the newest firmware where applications do work on it.

And I can not remeber what firmware I was using before the crash.

So where can I download older firmware? So I can test them.

Thanks

Kiptanoi_New:  Try manually upgrading to 6.10.9, and then modify your source list to use the 6.10.9 repository.  There is an issue with the 6.10.8 one.

• https://kb.netgear.com/000065653/ReadyNAS-OS-Software-Version-6-10-9

Ok, I tried 6.10.9, 6.10.8, 6.9.0, and after I updated my sources.list each time.

And each time first try to install from nas gui, and upload app files, but mysql server never worked. So I find a guide how to do it from SSH, so I tried this after each firmware installation after I updated my sources.list each time

apt-get update

apt upgrade

apt-get install mysql-server

 But it never worked with those newer firmwares.

Then I installed firmware 6.8.1, updated my source.list

and run those commands again via SSH, and now I have fully function mysql server running, and a fully function NAS for my needs working.

It took all day to fix this 😛

Anyway, one last question...
If I..... By misstake press the button to update the firmware inside nas gui.

what will then happend to mysql server?

will it still be there? Or deleted?

In this old firmware, I dont have any checkboxes to uncheck on firmware updates and firmware checks..... Can I via SHH command tell my NAS to never check after firmware updates? How would that command look like in that case?

StephenB Big thanks to you for your time and help.

Anyone knows?

If I..... By misstake press the button to update the firmware inside nas gui.

what will then happend to my current mysql server?

Will it still be there? Or deleted?

Is press update the same as install os from USB?

It won't be deleted, but there is a chance that a library update will break it.

What is a library update? 

When is library update happening?

---

Kiptanoi_New wrote:

What is a library update? 

When is library update happening?

 

---

Various linux libraries are often updated as part of the firmware update.

I don't understand this, why cant I just have a updated OS and running mysql server at the same time? What is the problem? And why can I not have a updated OS and have mysql server at the same time?

And what is the latest OS I can run mysql server on?

---

Kiptanoi_New wrote:

 

And what is the latest OS I can run mysql server on?

---

Only way to find out is to update the firmware and see if it still works.