mysqld process must be executed by mysql user:
sudo -u mysql mysqld --skip-grant-tables
Thanks, after looked, I ve already tried as root (āuser=root) but I have this message
170302 11:29:06 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:29:06 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
170302 11:29:07 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:29:07 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
170302 11:29:08 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:29:08 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
but when I tried to move as the fix says;
pi@yunohost:~ $ sudo mv /usr/local/mysql/data/ibdata1 /usr/local/mysql/data/ibdata1.bak
mv: cannot stat ā/usr/local/mysql/data/ibdata1ā: No such file or directory
pi@yunohost:~ $ ^C
I donāt have idbdata1.
So, if I understand well:
- you managed to apply the commands in the first part of the solution, until the āFix for MySQL āUnable to lock ibdata1ā errorā part, right?
- if thatās the case, were you able to restart mysql and log in with root user with the newly defined password?
- with which command do you produce the above error log (
Unable to lock ./ibadata1)?
nothingā¦
I mean, just to be shureā¦
- I stop/start the raspberry (to be shure)
- I connect as ssh to the rasberry
- tape sudo -u mysql ā¦
thatās all
For information: I checked the mysql password with my img that I ve done 3 months ago (when I installed yunohost) itās the same password. So I donāt think itās an application who change it in factā¦
here my terminal with ssh connection and the only command tape
WORD OF THE SESSION: GUISE
MEANING : OUTWARD APPEARANCE; FALSE APPEARANCE; PRETENSE
elekis@carla:~$ ssh 192.168.178.27 -l pi
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Thu Mar 2 11:28:52 2017 from carla.fritz.box
pi@yunohost:~ $ sudo -u mysql mysqld --skip-grant-tables
170302 11:42:46 [Note] mysqld (mysqld 10.0.29-MariaDB-0+deb8u1) starting as process 1681 ā¦
170302 11:42:46 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170302 11:42:46 [Note] InnoDB: The InnoDB memory heap is disabled
170302 11:42:46 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170302 11:42:46 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170302 11:42:46 [Note] InnoDB: Compressed tables use zlib 1.2.8
170302 11:42:46 [Note] InnoDB: Using Linux native AIO
170302 11:42:46 [Note] InnoDB: Not using CPU crc32 instructions
170302 11:42:46 [Note] InnoDB: Initializing buffer pool, size = 128.0M
170302 11:42:46 [Note] InnoDB: Completed initialization of buffer pool
170302 11:42:46 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:42:46 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
170302 11:42:46 [Note] InnoDB: Retrying to lock the first data file
170302 11:42:47 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:42:47 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
170302 11:42:48 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
170302 11:42:48 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
170302 11:42:49 [ERROR] InnoDB: Unable to lock ./
OK, you have to stop mysql before executing the command (the idea is to launch mysql in a special mode):
sudo systemctl stop mysql
oki, everything works now. (I saved the password in my keepass also :-D).
- new password ok
- sudo mysql -uroot -p
sudo cat /etc/yunohost/mysqlwork - restart raspberry and check kanboard: work
- piwigo installationā¦ work (ouaisā¦:-D).
thanks for all, I own you a chocolate box.
1 Like
Great news!
No need for a chocolate box, just spread the YunoHost love! 
The Piwigo YunoHost app has been refactored and updated to version 2.9.0!
Changelog excerpt:
Design matters. This is what recent user testing sessions have clearly revealed. This is why this version 2.9 focuses on refreshing our design, for the administration pages. Of course we have also added a few features, improved ergonomy and made your Piwigo even faster. A few weeks after its 15th birthday, Piwigo releases its version 2.9. Happy update!
You can read the complete changelog here.
Happy upgrading! 
The Piwigo YunoHost app has been updated to version 2.9.1.
Bug fixes:
See complete changelog here.
707 number of views, hide decimals when less than 1k
706 [security] identification should redirect within Piwigo only - quality report by Eric Fernando CastaƱeda Nazario
705 user list backend, check input parameter - report by Eric Fernando CastaƱeda Nazario
701 The album synchronise link reaches the page to synchronise ./galleries/ even if the album is located in another folder
699 File inclusion in administration - reported by feric jeje
696 PIWIGO API - pwg.categories.delete doesnāt work properly.
693 Batch downloader failing using pclzip and php 7.1
685 batch manager, delete photo does not work with Safari
683 disk usage, hide decimals when more than 100GB
679 admin dashboard, need trigger for plugins
674 [php7.1] user edit box, [] operator not supported for strings
667 Bug Report: Cross Site Scripting(XSS) in page parameter of admin.php - reported by ghi5107
663 SQL error in tour 2.9
Happy upgrading!
1 Like
Thanks
The Piwigo YunoHost app has been updated to version 2.9.2.
Bug fixes:
See complete changelog here.
#767 Publishing via Shotwell 0.22.0 fails with Piwigo 2.9.1
#789 ability to avoid error message on log in page
#777 WS categories getImages, TotalCount
#787 unexpected āactionā for password.php displays errors
#723 when requesting an private id, the permalink is revealed
#747 PHP notice when changing admin pageās theme
#760 Date creation not refreshed when changing it from picture_modify
#678 PHP 7 RSS error
#751 Cannot run install/piwigo_structure-mysql.sql twice
#755 Syncāing the metadata send a date creation incorrect for Mysql 5.7
#731 dashboard, missing number of photos
#739 [search] when a search on word also matches tags
#732 rename transliterate function
#726 trigger on album creation
#725 protect pwg.images.setInfo from HTML
#724 SQL injection in page cat_options
#721 Set administrator private album to public via CSRF & Incorrect Permissions
#713 update notification mail in french/english mix
#710 input parameter āredirect_decodedā is not valid
Furthermore, the package has taken into account comments and improvements from the āofficialā review and will become an official app soon 
Happy upgrading!
1 Like
Error for me using graphical wayā¦
It seems that upgrade process wants to backup all my pictures : not enougth space !
Error message said :
40GB needed
5GB free space
failed
I donāt remember previous releases saved pictures before upgradingā¦ Am I right ?
Yes, youāre right. Saving the whole photos directory was supposed to be an improvement 
If you really canāt backup your whole data, you can avoid backing up the data directory with this command:
sudo yunohost app setting piwigo backup_core_only -v 1
1 Like
Improvementā¦
Anyway thanks !
Damned. All my pictures disappeared ! I donāt know if this is linked with previous upgradeā¦ Previews were still present so I didnāt see it. Letās upload againā¦
So, youāre not sure whether your photos disappeared when upgrading or later, are you?
No Iām not sure. I will try to investigate and report if I have information.