NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
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
7 Replies
Replies have been turned off for this discussion
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.
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. :-)
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?
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 armv5telroot@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.3Pretty 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
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).
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
