MySQL Installation on V3 MyCloud - Help

[thm22]

Hi all,

I am trying to install MySql or MariaDB on my WD MyCloud. 6 GB. Ser# WD11DB56ZYZJ.

I read your posts on the 64K page size issue and of @[ cagoune ] being able to do that.

Mysql installation

HI I need some help configuriong mysql on 3.04 firmware so far i installed mysql-server with those commands -aptitude update -aptitude install mysql-server created password … then i followed instructions from xbmc’s wiki and created advancedsetting.xml and the xbmc user on the mysql side the problem is librarys won’t creates. do i need to install php5 thing i have lost the gui and ssh once.  (possibly cake error, not sure) i don’t wish to go through that again can i follow insturctions…

I tried to follow his instructions but Apt-get gives me errors.

I have several SMB and NFS shares that are important on this device. So then I stopped because I did not want to brick my system.

Is it safe to continue there?

Will that install or replace libraries that will not work with this device?

Here is my list of commands:

WDMyCloud:/etc# uname

Linux

WDMyCloud:/etc# uname -a

Linux WDMyCloud 3.2.26 #1 SMP Thu Jul 9 11:14:15 PDT 2015 wd-2.4-rel armv7l GNU/Linux

WDMyCloud:/etc# cat /etc/version

04.05.00-315

WDMyCloud:/etc# cd

WDMyCloud:~# apt-get update

Get:1 HTTP: //ftp.us.debian.org jessie Release.gpg [1652 B]

Hit HTTP ://ftp.us.debian.org jessie Release

Ign HTTP ://ftp.us.debian.org jessie Release

Ign HTTP ://ftp.us.debian.org jessie/main armhf Packages/DiffIndex

Hit HTTP ://ftp.us.debian.org jessie/main Translation-en

Err HTTP ://ftp.us.debian.org jessie/main armhf Packages

Hit HTTP ://ftp.us.debian.org jessie/main armhf Packages

Fetched 1652 B in 0s (1793 B/s)

Reading package lists… Done

W: GPG error: HTTP: //ftp . us . debian .org jessie Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 7638D0442B90D010

WDMyCloud:~# apt-get -f 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:

libtirpc1 : Breaks: nfs-common (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed

Breaks: nfs-kernel-server (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed

mysql-server : Depends: mysql-server-5.5 but it is not going to be installed

E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).

WDMyCloud:~# apt-get -f install

Reading package lists… Done

Building dependency tree

Reading state information… Done

Correcting dependencies… Done

The following package was automatically installed and is no longer required:

libgssglue1

Use ‘apt-get autoremove’ to remove it.

The following extra packages will be installed:

nfs-common nfs-kernel-server

Suggested packages:

open-iscsi watchdog

The following packages will be upgraded:

nfs-common nfs-kernel-server

2 upgraded, 0 newly installed, 0 to remove and 268 not upgraded.

6 not fully installed or removed.

Need to get 0 B/291 kB of archives.

After this operation, 106 kB disk space will be freed.

Do you want to continue [Y/n]? Y

WARNING: The following packages cannot be authenticated!

nfs-kernel-server nfs-common

Install these packages without verification [y/N]? N

E: Some packages could not be authenticated

WDMyCloud:~#

Any help greatly apprciated.

Thm22

[cagoune]

I don’t remember much about this project as I switched to plex instead of Kodi for my media.

And I used MySQL to manage Kodi s database.

I do remember I bricked the device a few times trying to set it up.

If I remember correctly you have to compile MySQL yourself on your device. Some guy shared a compiled version compatible with my firmware version. There Is no way to use standard debian ones.

For unbricking drive has to come out connected to a Linux pc or vm and reflash one of the partition. If. I recall there is 8 of em. So you don’t lose data if you do it correctly

Good. Luck

-------- Message d’origine --------

[thm22]

Thank you @cagoune.
Do you have a name or location for these compiled versions for this HW?
What are you using as a server now for Plex?
Thanks

[thm22]

@Fox_exe, I found your website with the distribution for jessie-64k.
Will the SQL server port in there work for my 1Gen My Cloud ?

I have the 6GB version with:
Linux WDMyCloud 3.2.26 #1 SMP Thu Jul 9 11:14:15 PDT 2015 wd-2.4-rel armv7l GNU/Linux
WDMyCloud:/etc# cat /etc/version > 04.05.00-315
It’s the one with the Comcerto 2000 EVM ARMv7 Processor rev 1 (v7l).

Will that HW even run MySQL at a decent speed to support severe Kodi instances?
In what order would I need to install the MySQL deb files?

Thanks,
thm22.

[Fox_exe]

MySQL preinstalled in all MyCloud’s.
Find a port by this command:
netstat -tulnp

User/Password stored somewhere in web gui folders. User grep -rn 'root' /var/www/ or similar for search string inside files (Search root password).

[thm22]

@Fox_exe the only SQL package can find on this device is sqlite3.

Which if these should I install and in what order?
mysql-client-5.5_5.5.44-0+deb8u1_armhf.deb 11-Jan-2017 01:20 1 MB
mysql-client_5.5.44-0+deb8u1_all.deb 11-Jan-2017 01:20 71 KB
mysql-common_5.5.44-0+deb8u1_all.deb 11-Jan-2017 01:20 73 KB
mysql-server-5.5_5.5.44-0+deb8u1_armhf.deb 11-Jan-2017 01:20 2 MB
mysql-server-core-5.5_5.5.44-0+deb8u1_armhf.deb 11-Jan-2017 01:20 3 MB
mysql-server_5.5.44-0+deb8u1_all.deb 11-Jan-2017 01:20 71 KB
mysql-source-5.5_5.5.44-0+deb8u1_armhf.deb 11-Jan-2017 01:20 22 MB
mysql-testsuite-5.5_5.5.44-0+deb8u1_armhf.deb 11-Jan-2017 01:20 4 MB
mysql-testsuite_5.5.44-0+deb8u1_all.deb

Thanks,
thm22.

[Fox_exe]

Better to install inside chroot.
For firmware v04.xx - possible to install only re-compiled packages from my website:

echo "deb http://fox-exe.ru/ jessie-64k main" > /etc/apt/sources.list.d/fox.list
apt-get update
apt-get install mysql-server

For FW v03xx - possible to install regular packages for “armhf” architecture (From debian apt archive, because original (wd) kernel does not fully supported latest debian releases)

[thm22]

Hi @Fox_exe , I really appreciate your help with this. I confirmed the Firmware is v04.05.00-315.
So I tried the steps you recommended. Here is the error I got. Something about not having the right nfs-common and nfs-kernel-server.? The MySQL server did not install. “'apt-get -f install” did not fix it. Any idea on how to fix this?

WDMyCloud:~# echo “deb http://fox-exe.ru/ jessie-64k main” > /etc/apt/sources.list.d/fox.list
WDMyCloud:~# cat /etc/apt/sources.list.d/fox.list
deb http://fox-exe.ru/ jessie-64k main
WDMyCloud:~# ls /etc/apt/sources.list.d/
fox.list
WDMyCloud:~# apt-get update
Get:1 http://ftp.us.debian.org jessie Release.gpg [1652 B]
Hit http://ftp.us.debian.org jessie Release
Ign http://ftp.us.debian.org jessie Release
Ign http://ftp.us.debian.org jessie/main armhf Packages/DiffIndex
Get:2 http://fox-exe.ru jessie-64k Release.gpg [473 B]
Hit http://ftp.us.debian.org jessie/main Translation-en
Err http://ftp.us.debian.org jessie/main armhf Packages
Hit http://ftp.us.debian.org jessie/main armhf Packages
Get:3 http://fox-exe.ru jessie-64k Release [1461 B]
Ign http://fox-exe.ru jessie-64k Release
Get:4 http://fox-exe.ru jessie-64k/main armhf Packages [527 kB]
Ign http://fox-exe.ru jessie-64k/main Translation-en
Fetched 531 kB in 5s (104 kB/s)
Reading package lists… Done
W: GPG error: http://ftp.us.debian.org jessie Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 7638D0442B90D010
W: GPG error: http://fox-exe.ru jessie-64k Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 55C02F624E96DBB2
WDMyCloud:~# 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:
libtirpc1 : Breaks: nfs-common (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
Breaks: nfs-kernel-server (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).
WDMyCloud:~# apt-get install nfs-kernel-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:
libtirpc1 : Breaks: nfs-common (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
nfs-kernel-server : Depends: nfs-common (= 1:1.2.8-9) but 1:1.2.6-4 is to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).
WDMyCloud:~# apt-get install nfs-common
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:
libtirpc1 : Breaks: nfs-kernel-server (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
nfs-common : Breaks: nfs-kernel-server (< 1:1.2.8-6~) but 1:1.2.6-4 is to be installed
nfs-kernel-server : Depends: nfs-common (= 1:1.2.6-4) but 1:1.2.8-9 is to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).
WDMyCloud:~# apt-get -f install
Reading package lists… Done
Building dependency tree
Reading state information… Done
Correcting dependencies… Done
The following package was automatically installed and is no longer required:
libgssglue1
Use ‘apt-get autoremove’ to remove it.
The following extra packages will be installed:
nfs-common nfs-kernel-server
Suggested packages:
open-iscsi watchdog
The following packages will be upgraded:
nfs-common nfs-kernel-server
2 upgraded, 0 newly installed, 0 to remove and 268 not upgraded.
6 not fully installed or removed.
Need to get 0 B/291 kB of archives.
After this operation, 106 kB disk space will be freed.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
nfs-kernel-server nfs-common
Install these packages without verification [y/N]? y
(Reading database … 26461 files and directories currently installed.)
Preparing to unpack …/nfs-kernel-server_1%3a1.2.8-9_armhf.deb …
Unpacking nfs-kernel-server (1:1.2.8-9) over (1:1.2.6-4) …
dpkg: error processing archive /var/cache/apt/archives/nfs-kernel-server_1%3a1.2.8-9_armhf.deb (–unpack):
trying to overwrite ‘/etc/init.d/nfs-kernel-server’, which is also in package nfs 01.00.00-aef4b02
[ ok ] Stopping NFS kernel daemon: mountd nfsd.
[ ok ] Unexporting directories for NFS kernel daemon…
[ ok ] Exporting directories for NFS kernel daemon…
[ ok ] Starting NFS kernel daemon: nfsd mountd.
dpkg: considering deconfiguration of nfs-kernel-server, which would be broken by installation of nfs-common …
dpkg: yes, will deconfigure nfs-kernel-server (broken by nfs-common)
Preparing to unpack …/nfs-common_1%3a1.2.8-9_armhf.deb …
De-configuring nfs-kernel-server (1:1.2.6-4) …
Unpacking nfs-common (1:1.2.8-9) over (1:1.2.6-4) …
dpkg: error processing archive /var/cache/apt/archives/nfs-common_1%3a1.2.8-9_armhf.deb (–unpack):
trying to overwrite ‘/etc/default/nfs-common’, which is also in package nfs 01.00.00-aef4b02
[ ok ] Stopping NFS kernel daemon: mountd nfsd.
[ ok ] Unexporting directories for NFS kernel daemon…
[ ok ] Exporting directories for NFS kernel daemon…
[ ok ] Starting NFS kernel daemon: nfsd mountd.
[ ok ] Stopping NFS common utilities:.
[ ok ] Starting NFS common utilities:.
Errors were encountered while processing:
/var/cache/apt/archives/nfs-kernel-server_1%3a1.2.8-9_armhf.deb
/var/cache/apt/archives/nfs-common_1%3a1.2.8-9_armhf.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
WDMyCloud:~# 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:
libtirpc1 : Breaks: nfs-common (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
Breaks: nfs-kernel-server (< 1:1.2.8-7) but 1:1.2.6-4 is to be installed
mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).

Thanks,
thm22

[cagoune]

Right now i am using nvidia shield as plex server. It is working fairly well is no more then 2 transcode at a time. I switch to plex because it was way easier to view content on the go. For tthe compiled versions. It is somewhere in this thread. Search for your firmware version within MySQL thread. Something will pop up. Not sure the guy is still holding these file on his google drive

Good luck

Provenance : Courrier pour Windows 10