× NETGEAR will be terminating ReadyCLOUD service by July 1st, 2023. For more details click here.
Orbi WiFi 7 RBE973
Reply

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

xbmcgotham
Tutor

Upgrading to latest stable Mysql version on Readynas NV+ V2

Hi,

 

I have issues with a stable database connection between the Mysql database on the NAS and KODI devices on the network. For some reason the connection constantly brakes which gives issues with the playback and functions in KODI.

 

The KODI team advised to upgrade to the latest DB version as I am getting the following message in the KODI log:

 

Your database server version 5.1.49-3 is very old and might not be supported in future Kodi versions. Please consider upgrading to MySQL 5.7 or MariaDB 10.2.

For this reason I am trying to find the correct steps to upgrade the Mysql database. The original install of Mysql was through the Mysql PHP bundle that was bought online a few years back.

 

Hope someone can advise.

 

Thanks

 

Model: RND4000v2|ReadyNAS NV+ v2 Chassis only
Message 1 of 8
StephenB
Guru

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

You can get a newer version at rnxtras.com (though it would be 5.6.x, not 5.7).  Perhaps reach out there and see if that app can be updated.

Message 2 of 8
xbmcgotham
Tutor

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

Hi @StephenB 

 

Thanks for the tip. Yes the PHP version for the R5 OS goes only to 5.6. I will reach out and see what they give back as answer. 🙂

 

Message 3 of 8
xbmcgotham
Tutor

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

@StephenB 

 

Just downed on me. Are we talking about the same thing? The Mysql needs upgrading, not the PHP. Mysql is by default installed on the Readynas NV+ v2 and is not related to the PHP Apps bought on RNXtras.

 

Its current version is 5.1.49-3

 

Anyway I can upgrade Mysql manually to 5.7 on the NAS?

 

 

Message 4 of 8
StephenB
Guru

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2


@xbmcgotham wrote:

 

Just downed on me. Are we talking about the same thing? The Mysql needs upgrading, not the PHP. Mysql is by default installed on the Readynas NV+ v2 and is not related to the PHP Apps bought on RNXtras.

 

 


Somehow I got stuck on PHP - not sure why.

 

I don't own a v2, so I have no personal experience with that NAS.  My understanding for the v1 is that mysql was only used for ReadyPhotos, and wasn't used by the NAS itself.  It's also not used by OS 6.  But I don't have any real information on for OS 5 (v2). @mdgm might know though.

 

So I do suggest making sure you have a current backup before you begin.  Then you could try logging in as root with ssh and entering

# apt-get update
# apt-get install mysql-server

Since the server is already installed, that will do an upgrade (assuming a newer version is in the apt repository).

 

Note that apt-get upgrade isn't a good idea, and there are some old posts here that warn against doing that in an v2 nas.  For instance here: https://community.netgear.com/t5/Using-your-ReadyNAS-in-Business/Is-it-safe-to-use-apt-get/m-p/97000...

 

Message 5 of 8
xbmcgotham
Tutor

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

I had the same issue, I also started thinking of PHP. Maybe because of the similarity in versions. 🙂

 

Thanks for the "simple" solution. Yes I will give it a try after christmas. Looking forward to any additional info @mdgm might have.

 

Enjoy your time ahead. 🙂

 

Message 6 of 8
SiO2y16
Aspirant

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

I'm in exactly the same boat, ReadyNAS NV+ v2 running MySQL 5.1.49-3 (Debian)

Firmware is RAIDiator 5.3.13 (which I believe to be the latest version released for this model).

Debian version is 6.0.3

 

root@ReadyNAS:~# uname -srm
Linux 2.6.31.8.nv+v2 armv5tel
root@ReadyNAS:~# mysql -v -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is ######
Server version: 5.1.49-3 (Debian)

 

root@ReadyNAS:~# cat /etc/debian_version
6.0.3

Pretty much all of the apt sources fail to resolve but I'm worried if I update the source list to newer sources, it could replace important bits that might brick the entire thing.

 

root@ReadyNAS:~# sudo apt-get update
Err http://www.readynas.com 5.3.13/ Release.gpg                                                          
  Could not resolve 'www.readynas.com'
Err http://www.readynas.com/packages/ 5.3.13/ Translation-en                                             
  Could not resolve 'www.readynas.com'
Err http://www.readynas.com/packages/ 5.3.13/ Translation-en_US                                          
  Could not resolve 'www.readynas.com'
Err http://ftp.us.debian.org squeeze Release.gpg                                                         
  Could not resolve 'ftp.us.debian.org'
Err http://ftp.us.debian.org/debian/ squeeze/main Translation-en        
  Could not resolve 'ftp.us.debian.org'
Err http://ftp.us.debian.org/debian/ squeeze/main Translation-en_US     
  Could not resolve 'ftp.us.debian.org'
Err http://ftp.us.debian.org squeeze-updates Release.gpg                
  Could not resolve 'ftp.us.debian.org'
Err http://ftp.us.debian.org/debian/ squeeze-updates/main Translation-en
  Could not resolve 'ftp.us.debian.org'
Err http://ftp.us.debian.org/debian/ squeeze-updates/main Translation-en_US
  Could not resolve 'ftp.us.debian.org'
Err http://security.debian.org squeeze/updates Release.gpg              
  Could not resolve 'security.debian.org'
Err http://security.debian.org/ squeeze/updates/main Translation-en
  Could not resolve 'security.debian.org'
Err http://security.debian.org/ squeeze/updates/main Translation-en_US
  Could not resolve 'security.debian.org'
Reading package lists... Done         
W: Failed to fetch http://www.readynas.com/packages/5.3.13/Release.gpg  Could not resolve 'www.readynas.com'

W: Failed to fetch http://www.readynas.com/packages/5.3.13/en.bz2  Could not resolve 'www.readynas.com'

W: Failed to fetch http://www.readynas.com/packages/5.3.13/en_US.bz2  Could not resolve 'www.readynas.com'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze/Release.gpg  Could not resolve 'ftp.us.debian.org'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze/main/i18n/Translation-en.bz2  Could not resolve 'ftp.us.debian.org'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze/main/i18n/Translation-en_US.bz2  Could not resolve 'ftp.us.debian.org'

W: Failed to fetch http://security.debian.org/dists/squeeze/updates/Release.gpg  Could not resolve 'security.debian.org'

W: Failed to fetch http://security.debian.org/dists/squeeze/updates/main/i18n/Translation-en.bz2  Could not resolve 'security.debian.org'

W: Failed to fetch http://security.debian.org/dists/squeeze/updates/main/i18n/Translation-en_US.bz2  Could not resolve 'security.debian.org'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze-updates/Release.gpg  Could not resolve 'ftp.us.debian.org'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze-updates/main/i18n/Translation-en.bz2  Could not resolve 'ftp.us.debian.org'

W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze-updates/main/i18n/Translation-en_US.bz2  Could not resolve 'ftp.us.debian.org'

W: Some index files failed to download, they have been ignored, or old ones used instead.

 

  Did anyone manage to get a newer version of MySQL installed? I don't want to break my setup (it all works at the moment) but I can't export and backup my video libraries due to (what I assume to be) non-UTF-8 characters and I'm worried the whole thing will just go and I'll be done.

 

I had to fix some broken dependencies when I first attempted to install mysql-server

 

root@ReadyNAS:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 tzdata-java : Depends: tzdata (= 2014e-0squeeze1) but 2012c-0squeeze1 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@ReadyNAS:~# apt-get -f install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
  libupsclient1 libpcap0.8 cracklib-runtime libnss-mdns libcrack2 libcap-ng0 libavahi-client3 libnet1
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  tzdata
The following packages will be upgraded:
  tzdata
1 upgraded, 0 newly installed, 0 to remove and 104 not upgraded.
Need to get 0 B/639 kB of archives.
After this operation, 487 kB disk space will be freed.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
  tzdata
Install these packages without verification [y/N]? Y
debconf: delaying package configuration, since apt-utils is not installed
(Reading database ... 15278 files and directories currently installed.)
Preparing to replace tzdata 2012c-0squeeze1 (using .../tzdata_2014e-0squeeze1_all.deb) ...
Unpacking replacement tzdata ...
Setting up tzdata (2014e-0squeeze1) ...

Current default time zone: 'Europe/Lisbon'
Local time is now:      Thu Mar  7 15:27:15 WET 2024.
Universal Time is now:  Thu Mar  7 15:27:15 UTC 2024.
Run 'dpkg-reconfigure tzdata' if you wish to change it.

root@ReadyNAS:~# dpkg-reconfigure tzdata

Current default time zone: 'Europe/London'
Local time is now:      Thu Mar  7 15:27:43 GMT 2024.
Universal Time is now:  Thu Mar  7 15:27:43 UTC 2024.

 

and then when I retried to install mysql-server:

 

root@ReadyNAS:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be upgraded:
  mysql-server
1 upgraded, 0 newly installed, 0 to remove and 100 not upgraded.
Need to get 65.7 kB of archives.
After this operation, 0 B of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
  mysql-server
Install these packages without verification [y/N]? Y
Err http://ftp.us.debian.org/debian/ squeeze/main mysql-server all 5.1.73-1
  Could not resolve 'ftp.us.debian.org'
Err http://security.debian.org/ squeeze/updates/main mysql-server all 5.1.73-1
  Could not resolve 'security.debian.org'
Failed to fetch http://security.debian.org/pool/updates/main/m/mysql-5.1/mysql-server_5.1.73-1_all.deb  Could not resolve 'security.debian.org'
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

 

I've tried it with the suggested --fix-missing as well:

 

root@ReadyNAS:~# apt-get install mysql-server --fix-missing
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be upgraded:
  mysql-server
1 upgraded, 0 newly installed, 0 to remove and 100 not upgraded.
Need to get 65.7 kB of archives.
After this operation, 0 B of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
  mysql-server
Install these packages without verification [y/N]? y
Err http://ftp.us.debian.org/debian/ squeeze/main mysql-server all 5.1.73-1
  Could not resolve 'ftp.us.debian.org'
Err http://security.debian.org/ squeeze/updates/main mysql-server all 5.1.73-1
  Could not resolve 'security.debian.org'
Failed to fetch http://security.debian.org/pool/updates/main/m/mysql-5.1/mysql-server_5.1.73-1_all.deb  Could not resolve 'security.debian.org'

 

Thanks in advance

Sandy

Message 7 of 8
StephenB
Guru

Re: Upgrading to latest stable Mysql version on Readynas NV+ V2

Squeeze has been archived for a while, so you will need to change the debian references to the archive repo.

 

I don't know what's going on with the readynas repo, but you could try switching to

(which is where the OS-6 repo is).

 

Message 8 of 8
Discussion stats
  • 7 replies
  • 2251 views
  • 0 kudos
  • 3 in conversation
Announcements