Complément :
J’ai désinstaller Opensondage dans l’espoir de pouvoir le réinstaller et cela ne fonctionne pas. Voici le journal : hastebin
Ce qui me fait vraiment penser que c’est un pb de droits user mysql
2019-05-11 23:56:54,382: DEBUG - + local sql
2019-05-11 23:56:54,383: DEBUG - + local database
2019-05-11 23:56:54,384: DEBUG - + ynh_handle_getopts_args ‘–sql=CREATE DATABASE opensondage; GRANT ALL PRIVILEGES ON opensondage.* TO ‘'‘opensondage’'’@’'‘localhost’'’ IDENTIFIED BY ‘'‘SOME PASSWORD’'’ WITH GRANT OPTION;’
2019-05-11 23:56:54,384: DEBUG - + set +x
2019-05-11 23:56:54,385: DEBUG - + database=
2019-05-11 23:56:54,386: DEBUG - ++ sudo cat /etc/yunohost/mysql
2019-05-11 23:56:54,487: DEBUG - + ynh_mysql_connect_as --user=root --password=SOME OTHER PASSWORD --database=
2019-05-11 23:56:54,488: DEBUG - + local legacy_args=upd
2019-05-11 23:56:54,488: DEBUG - + args_array=([u]=user= [p]=password= [d]=database=)
2019-05-11 23:56:54,489: DEBUG - + declare -Ar args_array
2019-05-11 23:56:54,490: DEBUG - + local user
2019-05-11 23:56:54,490: DEBUG - + local password
2019-05-11 23:56:54,491: DEBUG - + local database
2019-05-11 23:56:54,491: DEBUG - + ynh_handle_getopts_args --user=root --password=hnlDckQohUZy --database=
2019-05-11 23:56:54,492: DEBUG - + set +x
2019-05-11 23:56:54,492: DEBUG - + database=
2019-05-11 23:56:54,493: DEBUG - + mysql -u root --password=SOME OTHER PASSWORD -B ‘’
2019-05-11 23:56:54,595: DEBUG - + ynh_exit_properly
2019-05-11 23:56:54,595: WARNING - ERROR 1044 (42000) at line 1: Access denied for user ‘root’@‘localhost’ to database ‘opensondage’
2019-05-11 23:56:54,597: DEBUG - + local exit_code=1
2019-05-11 23:56:54,598: WARNING - !!
2019-05-11 23:56:54,600: DEBUG - + ‘[’ 1 -eq 0 ‘]’
2019-05-11 23:56:54,601: WARNING - opensondage’s script has encountered an error. Its execution was cancelled.
2019-05-11 23:56:54,602: DEBUG - + trap ‘’ EXIT
J’ai donc essayé ça :
Tout se passe bien, j’arrive à changer le mot de passe root et le tester mais ça ne résout pas mon pb ensuite.
A noter : quand je suis en mode --skip-grant-tables, évidemment toutes mes applis fonctionnent bien. Mais je ne peux pas laisser ça comme ça…
Alors j’ai essayé ça :
source /usr/share/yunohost/helpers
source /usr/share/yunohost/hooks/restore/11-conf_ynh_mysql
tiré de ce topic : Impossible de (ré)installer Roundcube - #7 by Aleks
Mais ça me retourne ça :
root@YunoHost:/home/admin# source /usr/share/yunohost/hooks/restore/11-conf_ynh_mysql
cat: /conf/ynh/mysql/root_pwd: No such file or directory
cat: /conf/ynh/mysql/mysql: No such file or directory
+++ echo '! Helper used in legacy mode !'
+++ set +x
+++ length=10
+++ tr -c -d A-Za-z0-9
+++ sed -n 's/\(.\{10\}\).*/\1/p'
+++ dd if=/dev/urandom bs=1 count=1000
mysqladmin: Can't turn off logging; error: 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation'
It seems that you have already configured MySQL. YunoHost needs to have a root access to MySQL to runs its applications, and is going to reset the MySQL root password. You can find this new password in /etc/yunohost/mysql.
et là, je ne sais plus quoi faire…il y a clairement un pb mais je ne sais pas comment le résoudre proprement…
Une idée?