NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Kiptanoi_New
Jun 08, 2023Aspirant
RN104 Stuck on booting 99% mysql.service
Hello. I will use google translate in this case. In connection with moving, my Netgear readynas 104 was shut down via power outage (Most likely) because I wasn't there when it was moved. Now I'...
StephenB
Jun 20, 2023Guru - Experienced User
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).
Kiptanoi_New
Jun 20, 2023Aspirant
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"
- StephenBJun 20, 2023Guru - Experienced User
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:
- Kiptanoi_NewJun 21, 2023Aspirant
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.
- Kiptanoi_NewJun 21, 2023Aspirant
After one last test, to install applications, it worked.
It works if I upload a downloaded application and installing it.
- Kiptanoi_NewJun 21, 2023Aspirant
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
- StephenBJun 21, 2023Guru - Experienced User
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.
- Kiptanoi_NewJun 21, 2023Aspirant
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.
- Kiptanoi_NewJun 25, 2023Aspirant
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?
- StephenBJun 25, 2023Guru - Experienced User
It won't be deleted, but there is a chance that a library update will break it.
- Kiptanoi_NewJun 26, 2023Aspirant
What is a library update?
When is library update happening?
- StephenBJun 26, 2023Guru - Experienced User
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.
- Kiptanoi_NewJun 26, 2023Aspirant
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?
- StephenBJun 26, 2023Guru - Experienced User
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.
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!