Spksrc: Synology: Firefox Sync can not be uninstalled (Incorrect MySQL root password)

[rbieb]

Version is 1.5.2-3

MariaDB was installed before installing Firefox Sync since it came as a dependency. No matter what password I enter, ffsync always complains it's wrong, therefore preventing me from uninstalling the package.

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

[nickbroon]

This is also a problem with installing tt-rss. See https://github.com/SynoCommunity/spksrc/pull/2056#issuecomment-173900759

[Dr-Bean]

Please look at CONTRIBUTING. Could you add the missing information please, in particular the DSM version?

If DSM6 Beta: I assume you already know this, but otherwise: it's a beta. Synology seems to have a habit of breaking backwards compatibility with new DSM versions, and breaking our packages in the process.

It could be related to the root user changes, but that's not clear to me atm. If you have shell access, you can try to play around with the following command, and see if you can get access or not: https://github.com/SynoCommunity/spksrc/blob/master/spk/ffsync/src/installer.sh#L41.

This will probably affect all packages that use MariaDB...

[Hubfront]

I can confirm that the root user account still works with my beta 2 with old password. I can login as root to Mysql via phpmyadmin and also login successfully via console as root with correct password. The users in MariaDB seems to be not affected by the upgrade from DMS 5.2 -> DSM 6.0 b2. There is the root user and ffsync user in my mysql table. I'll try to uninstall ffsnc and reinstall it.

UPDATE: same problem uninstalling as rbieb. Did not go through because "Incorrect MYSQL root passowrd". Login to mysql with root account via shell on console works, weird, that the above uninstall shell-script gives a failure.

[Sprinkle-Master]

@rbieb
It is easy to blank out the root password with MariaDB. Maybe you are trying to use a password when there isn't one. Also, I ran into this last night, if root pass is blank, Firefox Sync will not reconcile. You have to put something, anything, into the root pass with MariaDB then Firefox Sync will take it.

[Sprinkle-Master]

@Hubfront
Could you be in the same boat with a blank password? I am still a nub but... If root pass is blank, would shell let you in with anything you give it? Just a thought but it would make for a decent explanation.

[Hubfront]

@Sprinkle-Master
Before i wrote herein i also blanked out the root password in the mariadb database. The problem with the uninstaller persisted though.

[Dr-Bean]

Copied mostly from #2217:
We can use /usr/bin/mysql when the buildnumber is associated with DSM6. The approach will probably be similar to this.

PR's welcome, but please note that this affects all packages using MariaDB, so the PR should take all those packages into account.
Secondly, after merging a PR/change to fix this particular issue, it does not mean the affected packages will immediately work after upgrading. There are several reasons why packages on DSM6 are broken, this is just one of them. Some packages will be affected by multiple changes in DSM6.

[Dr-Bean]

Done in part with d6900764830d2500a382cbd9a27fb84cdaf1dc3a. This solves the mysql location, but it does not solve the issue with creation of users (#2216), and we'll also need to have the DSM6-final toolchains (not yet released)

[mettix]

Hello!

I'm also stuck with the uninstall of Owncloud.

-> Tried resetting MariaDB root password from the MariaDB GUI
-> Tried resetting password from SSH

Both shots didnt work out, still throws error; MySQL incorrect root password.

Any other thoughts?

[gnacho]

What worked for me:

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

source: https://github.com/SynoCommunity/spksrc/issues/2217

[qu1gl3s]

Any progress on this issue.

Has Synology released the toolchains?

[calvinleea]

@gnacho

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

That really works for me when installing the fengoffice to my dsm6.0

thanks

[Sigawan]

Years later.. most packages still will not install throwing error : incorrect mysql root password.
Should these packages all be marked DSM 5.xx only?

[ymartin59]

Yes. That is explained in FAQ. Upgrades and DSM 6.x support is in progress, package by package.

[a575606]

Sorry to revive an old thread, but I can't install Firefox Sync on DSM 6 due to the incorrect mysql password issue. Any progress on DSM 6 support?