- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Upgrading to latest stable Mysql version on Readynas NV+ V2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Upgrading to latest stable Mysql version on Readynas NV+ V2
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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. 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).