New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Owncloud 8.1.1-7: Failed to install "owncloud": "Incorrect MySQL root password" #2136

Open
caco3 opened this Issue Feb 13, 2016 · 35 comments

Comments

Projects
None yet
@caco3

caco3 commented Feb 13, 2016

I am failing to install owncloud 8.1.1-7 on Synology DSM 6beta2.

It always ends with the error "Incorrect MySQL root password".

I made sure the trust level is correct, even had it on "Any publisher".
I have phpMyAdmin installed and checked that the root password is matching and working.
Also I created a folder /volume1/owncloud" beforehand.

Is there a way to see any log output?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

@cytec cytec added the dsm 6.0 label Feb 15, 2016

@the1ts

This comment has been minimized.

Show comment
Hide comment
@the1ts

the1ts Feb 25, 2016

I think that owncloud has the same issues with Synology DSM 6Beta as Newznab has. Namely mysql is nolonger at /usr/syno/mysql/bin/mysql, so the installer.sh fails on the preinst stage through failing to find the mysql binary, not login.

Seems we'll need to have some tests for DSM version to change at least that variable.

the1ts commented Feb 25, 2016

I think that owncloud has the same issues with Synology DSM 6Beta as Newznab has. Namely mysql is nolonger at /usr/syno/mysql/bin/mysql, so the installer.sh fails on the preinst stage through failing to find the mysql binary, not login.

Seems we'll need to have some tests for DSM version to change at least that variable.

@gliderguider

This comment has been minimized.

Show comment
Hide comment
@gliderguider

gliderguider Mar 25, 2016

I've also just encountered this issue, and had also created the owncloud folder beforehand.

gliderguider commented Mar 25, 2016

I've also just encountered this issue, and had also created the owncloud folder beforehand.

@symera

This comment has been minimized.

Show comment
Hide comment
@symera

symera Mar 26, 2016

Same issue here while trying to install Roundcube on DSM6.
@the1ts I guess the binary is now located in /<volume>/@appstore/MariaDB/usr/bin/mysql

symera commented Mar 26, 2016

Same issue here while trying to install Roundcube on DSM6.
@the1ts I guess the binary is now located in /<volume>/@appstore/MariaDB/usr/bin/mysql

@supachupa

This comment has been minimized.

Show comment
Hide comment
@supachupa

supachupa Mar 31, 2016

hi there.. based on your previous comments, I as able to get this installed by:

  1. create directory: /usr/syno/mysql/bin
  2. ln -s /user/local/bin/mysql /usr/syno/mysql/bin/mysql
    Now I just have "Can't create or write into the data directory /volume1/owncloud" to contend with...

supachupa commented Mar 31, 2016

hi there.. based on your previous comments, I as able to get this installed by:

  1. create directory: /usr/syno/mysql/bin
  2. ln -s /user/local/bin/mysql /usr/syno/mysql/bin/mysql
    Now I just have "Can't create or write into the data directory /volume1/owncloud" to contend with...
@chbwien

This comment has been minimized.

Show comment
Hide comment
@chbwien

chbwien Apr 15, 2016

Same problem here: DSM 6 and the password is wrong whatever I do... Any solution for that???

chbwien commented Apr 15, 2016

Same problem here: DSM 6 and the password is wrong whatever I do... Any solution for that???

@supachupa

This comment has been minimized.

Show comment
Hide comment
@supachupa

supachupa Apr 15, 2016

I had to SSH in and set the mysql root password manually to fix this.
http://www.herlitz.nu/2013/07/31/administering-a-synology-mysql-server/ http://www.herlitz.nu/2013/07/31/administering-a-synology-mysql-server/

On 16 Apr 2016, at 12:54 AM, chbwien notifications@github.com wrote:

Same problem here: DSM 6 and the password is wrong whatever I do... Any solution for that???


You are receiving this because you commented.
Reply to this email directly or view it on GitHub #2136 (comment)

supachupa commented Apr 15, 2016

I had to SSH in and set the mysql root password manually to fix this.
http://www.herlitz.nu/2013/07/31/administering-a-synology-mysql-server/ http://www.herlitz.nu/2013/07/31/administering-a-synology-mysql-server/

On 16 Apr 2016, at 12:54 AM, chbwien notifications@github.com wrote:

Same problem here: DSM 6 and the password is wrong whatever I do... Any solution for that???


You are receiving this because you commented.
Reply to this email directly or view it on GitHub #2136 (comment)

@Vitriia

This comment has been minimized.

Show comment
Hide comment
@Vitriia

Vitriia Apr 21, 2016

@supachupa , it works ? Can you explain us how you fix it ? Thx :)

Vitriia commented Apr 21, 2016

@supachupa , it works ? Can you explain us how you fix it ? Thx :)

@chbwien

This comment has been minimized.

Show comment
Hide comment
@chbwien

chbwien Apr 21, 2016

I have given up. I've installed owncloud myselve (without the package):

  • Installed MariaDB
  • Created an owncloud user and an owncloud table
  • Created a shared directory and set the rights via console to root:http 0770
  • Added the owncloud directoy to the php basedir
  • Installed the latest 9 version of owncloud (with the owncloud user, the owncloud table and the /volume1/owncloud shared directory)

Everything works as expected and you can do the backup using hyperbackup (MariaDB, web/owncloud, shared owncloud diectory). You have to add another directory to the php basedir as explained by the owncloud status.

chbwien commented Apr 21, 2016

I have given up. I've installed owncloud myselve (without the package):

  • Installed MariaDB
  • Created an owncloud user and an owncloud table
  • Created a shared directory and set the rights via console to root:http 0770
  • Added the owncloud directoy to the php basedir
  • Installed the latest 9 version of owncloud (with the owncloud user, the owncloud table and the /volume1/owncloud shared directory)

Everything works as expected and you can do the backup using hyperbackup (MariaDB, web/owncloud, shared owncloud diectory). You have to add another directory to the php basedir as explained by the owncloud status.

@gnacho

This comment has been minimized.

Show comment
Hide comment
@gnacho

gnacho May 19, 2016

Same problem here. Is not just owncloud, any package with Mariadb dependency is failing to install. I even restore the Synology to factory defaults but the problem persists.

gnacho commented May 19, 2016

Same problem here. Is not just owncloud, any package with Mariadb dependency is failing to install. I even restore the Synology to factory defaults but the problem persists.

@gnacho

This comment has been minimized.

Show comment
Hide comment
@gnacho

gnacho May 28, 2016

What worked for me

mkdir /usr/syno/mysql
mkdir /usr/syno/mysql/bin 
ln -s /usr/bin/mysql /usr/syno/mysql/bin/mysql

source: #2217

gnacho commented May 28, 2016

What worked for me

mkdir /usr/syno/mysql
mkdir /usr/syno/mysql/bin 
ln -s /usr/bin/mysql /usr/syno/mysql/bin/mysql

source: #2217

@gnacho

This comment has been minimized.

Show comment
Hide comment
@gnacho

gnacho Jun 6, 2016

And had to do it again after upgrade DSM :(

gnacho commented Jun 6, 2016

And had to do it again after upgrade DSM :(

@Dr-Bean

This comment has been minimized.

Show comment
Hide comment
@Dr-Bean

Dr-Bean Jun 15, 2016

Member

@buzter This is a bugtracker for SynoCommunity packages. It's fine if you don't use one of our packages, we don't mind that at all, but you don't need to suggest a manual installation as an alternative here.

Member

Dr-Bean commented Jun 15, 2016

@buzter This is a bugtracker for SynoCommunity packages. It's fine if you don't use one of our packages, we don't mind that at all, but you don't need to suggest a manual installation as an alternative here.

@buzter

This comment has been minimized.

Show comment
Hide comment
@buzter

buzter Jun 15, 2016

@Dr-Bean Okay, I understand. Sorry for that.
I really tried to make Your package work. But I failed. So I only wanted to show how to make OC work in other ways.

buzter commented Jun 15, 2016

@Dr-Bean Okay, I understand. Sorry for that.
I really tried to make Your package work. But I failed. So I only wanted to show how to make OC work in other ways.

@Dr-Bean

This comment has been minimized.

Show comment
Hide comment
@Dr-Bean

Dr-Bean Jun 15, 2016

Member

Sure, but that doesn't belong here. Your suggestion is the same as saying: "Hey, if your car has a flat tire because of bad road conditions. Don't repair the car, just get yourself a kitcar instead: after building it, it works fine for me!"

We know the package doesn't work on DSM6...that's why the issue is open, and labeled as such.

Member

Dr-Bean commented Jun 15, 2016

Sure, but that doesn't belong here. Your suggestion is the same as saying: "Hey, if your car has a flat tire because of bad road conditions. Don't repair the car, just get yourself a kitcar instead: after building it, it works fine for me!"

We know the package doesn't work on DSM6...that's why the issue is open, and labeled as such.

@supachupa

This comment has been minimized.

Show comment
Hide comment
@supachupa

supachupa Jun 15, 2016

Dear “Dr” Bean

Not sure if your analogy works or if I can come up with one that works better, but it’s more like needing to get to work when your car breaks down and your neighbour offers a workaround while you wait for the dealer to get through the backlog. You do sound a little unnecessarily defensive, for some reason. The spirit of open source is that we’re all helping each other for free.. so if we’re finding workarounds, it’s meant to help each other get things working until the packages are fixed.. nothing more. Do you think we are happy to sit around for a few months until things get fixed when we can fix it ourselves? No. If need be, I could compile a kernel from scratch and build up an OS that suits my purposes.. spending many hours in the process, but I sure as hell don’t want to waste my time on that shit anymore. We all acknowledge that a package is the most efficient way for the masses… so keep up the good work, but don’t get defensive if we circumvent slow processes. We do so because we want stuff now and we also don’t want to press you knowing that it’s all voluntary. Once things are fixed, we will gladly use that method!

Thanks for your hard work.

On 15 Jun 2016, at 8:45 PM, Dr-Bean notifications@github.com wrote:

Sure, but that doesn't belong here. Your suggestion is the same as saying: "Hey, if your car has a flat tire because of bad road conditions. Don't repair the car, just get yourself a kitcar instead: after building it, it works fine for me!"

We know the package doesn't work on DSM6...that's why the issue is open, and labeled as such.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub #2136 (comment), or mute the thread https://github.com/notifications/unsubscribe/AJHp_vTOer5PbO5XwAE7Mqywqxra1ZS_ks5qL9fMgaJpZM4HZsr2.

supachupa commented Jun 15, 2016

Dear “Dr” Bean

Not sure if your analogy works or if I can come up with one that works better, but it’s more like needing to get to work when your car breaks down and your neighbour offers a workaround while you wait for the dealer to get through the backlog. You do sound a little unnecessarily defensive, for some reason. The spirit of open source is that we’re all helping each other for free.. so if we’re finding workarounds, it’s meant to help each other get things working until the packages are fixed.. nothing more. Do you think we are happy to sit around for a few months until things get fixed when we can fix it ourselves? No. If need be, I could compile a kernel from scratch and build up an OS that suits my purposes.. spending many hours in the process, but I sure as hell don’t want to waste my time on that shit anymore. We all acknowledge that a package is the most efficient way for the masses… so keep up the good work, but don’t get defensive if we circumvent slow processes. We do so because we want stuff now and we also don’t want to press you knowing that it’s all voluntary. Once things are fixed, we will gladly use that method!

Thanks for your hard work.

On 15 Jun 2016, at 8:45 PM, Dr-Bean notifications@github.com wrote:

Sure, but that doesn't belong here. Your suggestion is the same as saying: "Hey, if your car has a flat tire because of bad road conditions. Don't repair the car, just get yourself a kitcar instead: after building it, it works fine for me!"

We know the package doesn't work on DSM6...that's why the issue is open, and labeled as such.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub #2136 (comment), or mute the thread https://github.com/notifications/unsubscribe/AJHp_vTOer5PbO5XwAE7Mqywqxra1ZS_ks5qL9fMgaJpZM4HZsr2.

@Dr-Bean

This comment has been minimized.

Show comment
Hide comment
@Dr-Bean

Dr-Bean Jun 15, 2016

Member

Okay, I didn't wan tto get into a discussion about it. Again, this is not a generic discussion forum to talk about all things Synology or Owncloud. This is a package bugtracker. Feel free to contribute, but please keep it focused on the package.

Member

Dr-Bean commented Jun 15, 2016

Okay, I didn't wan tto get into a discussion about it. Again, this is not a generic discussion forum to talk about all things Synology or Owncloud. This is a package bugtracker. Feel free to contribute, but please keep it focused on the package.

@graffen

This comment has been minimized.

Show comment
Hide comment
@graffen

graffen Jun 20, 2016

Any update on when this issue will be fixed? Should I hold my breath (it's been open since Feb 13th it seems) or just go for the manual install?

graffen commented Jun 20, 2016

Any update on when this issue will be fixed? Should I hold my breath (it's been open since Feb 13th it seems) or just go for the manual install?

@gnacho

This comment has been minimized.

Show comment
Hide comment
@gnacho

gnacho Jun 20, 2016

Didn't work my solution?

gnacho commented Jun 20, 2016

Didn't work my solution?

@mettix

This comment has been minimized.

Show comment
Hide comment
@mettix

mettix Jun 23, 2016

It freaks me out.. I want to uninstall owncloud I have this error also for like ages :( all 'fixed' wont work for me. Or I must have missed one..

mettix commented Jun 23, 2016

It freaks me out.. I want to uninstall owncloud I have this error also for like ages :( all 'fixed' wont work for me. Or I must have missed one..

@gitty8

This comment has been minimized.

Show comment
Hide comment
@gitty8

gitty8 Jun 25, 2016

Hi, im getting same error - ANY updates?

gitty8 commented Jun 25, 2016

Hi, im getting same error - ANY updates?

@mettix

This comment has been minimized.

Show comment
Hide comment
@mettix

mettix Jul 4, 2016

So, I have made a backup of my NAS, did a format and did a restore of settings, files but no applications :)

mettix commented Jul 4, 2016

So, I have made a backup of my NAS, did a format and did a restore of settings, files but no applications :)

@fuuman

This comment has been minimized.

Show comment
Hide comment
@fuuman

fuuman Jul 6, 2016

Same problem here. Solution would be awesome. It's really annoying.

fuuman commented Jul 6, 2016

Same problem here. Solution would be awesome. It's really annoying.

@MathieuMH

This comment has been minimized.

Show comment
Hide comment
@MathieuMH

MathieuMH Jul 6, 2016

I'm encountering this issue as well. Running DSM6, and unable to install OwnCloud. I'dd like a more permanent solution instead of doing it every time I install a new update.

MathieuMH commented Jul 6, 2016

I'm encountering this issue as well. Running DSM6, and unable to install OwnCloud. I'dd like a more permanent solution instead of doing it every time I install a new update.

@jknaebel

This comment has been minimized.

Show comment
Hide comment
@jknaebel

jknaebel Sep 26, 2016

Hallo to all.
Take a look at the date of my comment......
OwnCloud is still not running on DSM 6.
Any solutions? Any updates?

Thanks.

jknaebel commented Sep 26, 2016

Hallo to all.
Take a look at the date of my comment......
OwnCloud is still not running on DSM 6.
Any solutions? Any updates?

Thanks.

@KaraokeStu

This comment has been minimized.

Show comment
Hide comment
@KaraokeStu

KaraokeStu Sep 26, 2016

Member

Unfortunately we're still having issues with DSM 6 and our packages. We are looking at possible solutions, but it's not simple and it affects all packages, not just this one.

Member

KaraokeStu commented Sep 26, 2016

Unfortunately we're still having issues with DSM 6 and our packages. We are looking at possible solutions, but it's not simple and it affects all packages, not just this one.

@benpaddlejones

This comment has been minimized.

Show comment
Hide comment
@benpaddlejones

benpaddlejones Oct 25, 2016

I can confirm this issue is still present in 8.1.1-7 on a DS215j running DSM 6.0.2-8451 Update 2 with vol1/ownCloud created a HTML permisisons applied before trying install.

benpaddlejones commented Oct 25, 2016

I can confirm this issue is still present in 8.1.1-7 on a DS215j running DSM 6.0.2-8451 Update 2 with vol1/ownCloud created a HTML permisisons applied before trying install.

@tofuSCHNITZEL

This comment has been minimized.

Show comment
Hide comment
@tofuSCHNITZEL

tofuSCHNITZEL commented Feb 3, 2017

any news?

@magefesa

This comment has been minimized.

Show comment
Hide comment
@magefesa

magefesa Feb 13, 2017

Same question ... Any solution ? Thanks to all who hav spend some time with this !

magefesa commented Feb 13, 2017

Same question ... Any solution ? Thanks to all who hav spend some time with this !

@tchwpkgorg

This comment has been minimized.

Show comment
Hide comment
@tchwpkgorg

tchwpkgorg Feb 16, 2017

@Dr-Bean "This is a bugtracker for SynoCommunity packages. It's fine if you don't use one of our packages, we don't mind that at all, but you don't need to suggest a manual installation as an alternative here."

This is normally a sane advice, but this issue is opened already for a year! So either close the issue as "wontfix" and remove owncloud package, because it's broken, or make a fix I would say.

tchwpkgorg commented Feb 16, 2017

@Dr-Bean "This is a bugtracker for SynoCommunity packages. It's fine if you don't use one of our packages, we don't mind that at all, but you don't need to suggest a manual installation as an alternative here."

This is normally a sane advice, but this issue is opened already for a year! So either close the issue as "wontfix" and remove owncloud package, because it's broken, or make a fix I would say.

@ymartin59

This comment has been minimized.

Show comment
Hide comment
@ymartin59

ymartin59 Mar 26, 2017

Contributor

I did an installation from scratch on DSM 6.0.1 (virtual machine):

  • install packages Web station, Apache 2.2, PHP 5.6 and MariaDB (no root password set)
  • run sudo mkdir /volume1/owncloud
  • install owncloud package providing only database password (leave defaults for others)
  • Web station configurations: PHP extensions and open_basedir appended with :/dev/urandom:/volume1/owncloud

And ownCloud works properly.

May you please try again after resetting MariaDB root password ? Or after reinstalling MariaDB ?

WARNING: do not uninstall owncloud package on DSM 6, or you will lost management interface !! Fix to apply on SSH: synoservice --enable DSM; synoservice --start DSM

Contributor

ymartin59 commented Mar 26, 2017

I did an installation from scratch on DSM 6.0.1 (virtual machine):

  • install packages Web station, Apache 2.2, PHP 5.6 and MariaDB (no root password set)
  • run sudo mkdir /volume1/owncloud
  • install owncloud package providing only database password (leave defaults for others)
  • Web station configurations: PHP extensions and open_basedir appended with :/dev/urandom:/volume1/owncloud

And ownCloud works properly.

May you please try again after resetting MariaDB root password ? Or after reinstalling MariaDB ?

WARNING: do not uninstall owncloud package on DSM 6, or you will lost management interface !! Fix to apply on SSH: synoservice --enable DSM; synoservice --start DSM

@ymartin59

This comment has been minimized.

Show comment
Hide comment
@ymartin59

ymartin59 Mar 26, 2017

Contributor

I am working on ownCloud package fixes for DSM 6.0: typically check preconditions on packages, document post-configuration in webstation if cannot be scripted

Contributor

ymartin59 commented Mar 26, 2017

I am working on ownCloud package fixes for DSM 6.0: typically check preconditions on packages, document post-configuration in webstation if cannot be scripted

@Remvis

This comment has been minimized.

Show comment
Hide comment
@Remvis

Remvis May 4, 2017

Is there some progress in the 'new' owncloud package for DSM6.0?

Manual installation doesn't work for me!

Remvis commented May 4, 2017

Is there some progress in the 'new' owncloud package for DSM6.0?

Manual installation doesn't work for me!

@Sigawan

This comment has been minimized.

Show comment
Hide comment
@Sigawan

Sigawan Feb 6, 2018

Installation of the owncloud package on the latest DSM 6.1.5 15254 fails with the same error as most other packages hosted at synocommunity 'incorrect mysql root password'

Is any work being done on this generic problem in the years since it was first reported?

Sigawan commented Feb 6, 2018

Installation of the owncloud package on the latest DSM 6.1.5 15254 fails with the same error as most other packages hosted at synocommunity 'incorrect mysql root password'

Is any work being done on this generic problem in the years since it was first reported?

@ymartin59

This comment has been minimized.

Show comment
Hide comment
@ymartin59

ymartin59 Feb 9, 2018

Contributor

There is no chance ownClound package to be upgraded - I should probably disabled it just now. I plan a brand new DSM 6 package for NextCloud.

Contributor

ymartin59 commented Feb 9, 2018

There is no chance ownClound package to be upgraded - I should probably disabled it just now. I plan a brand new DSM 6 package for NextCloud.

@LinuxArchitects

This comment has been minimized.

Show comment
Hide comment
@LinuxArchitects

LinuxArchitects Jul 22, 2018

That works for me 👍

ssh admin@syno
sudo su -
find / -type f -iname "mysql"

/run/lock/subsys/mysql
/volume1/@appstore/MariaDB/etc/logrotate.d/mysql
/volume1/@appstore/MariaDB/usr/bin/mysql

mkdir -p /usr/syno/mysql/bin
ln -s /volume1/@appstore/MariaDB/usr/bin/mysql /usr/syno/mysql/bin/mysql

LinuxArchitects commented Jul 22, 2018

That works for me 👍

ssh admin@syno
sudo su -
find / -type f -iname "mysql"

/run/lock/subsys/mysql
/volume1/@appstore/MariaDB/etc/logrotate.d/mysql
/volume1/@appstore/MariaDB/usr/bin/mysql

mkdir -p /usr/syno/mysql/bin
ln -s /volume1/@appstore/MariaDB/usr/bin/mysql /usr/syno/mysql/bin/mysql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment