Hardware: VPS bought online YunoHost version: 3.7.1.2 I have access to my server : Through SSH | through the webadmin Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : yes If yes, please explain: minor tweakings like putting my own DNS resolvers in /usr/share/yunohost/templates/dnsmasq/plain/resolv.dnsmasq.conf (in fact, I think that’s all).
Description of my issue
Hi !
This morning, I wanted to check the size of my mysql databases. Since I don’t know the mysql CLI, I quickly checked on the internet how to connect as root to type my SQL query. But I misread the article I found… I thought this command would do the trick :
sudo mysqladmin -u root password <SECRET_PASSWD>
But in fact, instead of connecting to the root user, this command sets the password of the root user. For the password (so instead of <SECRET_PASSWD>), I looked into the /etc/yunohost/mysql file.
Have I screwed up my setup ? Or did I just set the same root password as the previous one ?
I don’t know if this is related or just a coincidence, but I tried to create a new user and I got this error.
Thank you for your attention !
Edit : well, since I can’t connect anymore to my Rainloop or my TTRSS, I definitely screwed up my Yunohost Edit2 : on a side note, just before typing the mysqladmin command, I upgraded the yunohost package to 3.7.1.2. Edit3 : this is weirder and weirder : when I disconnect my Yunohost user and try to reconnect via the Yunohost portal, nothing happens when I click on some of my apps like Monitorix, Rainloop and TTRSS (here is the complete list of them). For the public apps (Nextcloud and Wallabag), even after being logged in via the Ynh portal, they redirect me to their login page and ask me for my credentials. Seems like ssowat is broken… I don’t get how changing the mysql root password could do that.
About edit3
I have same issue on my private applications (nextcloud and rainloop), think is due to last yunohost update 3.7.1.2 ?
Never mind, to fix temporarily, i have modify my URL address of my private application by adding a path from yunohost panel admin : https://application/ to https://application/1 (or whatever you want)
Uh wokay folks I’m not able to reproduce the issue with the ssowat tiles … Can you provide some more details about what are the url the tiles point to and why the url ain’t right ?
All my apps have been installed with dedicated domains. More precisely, all of them are subdomains of the main/default one (e.g. app1.domain1.eu, app2.domain1.eu and app3.domain1.eu are the dedicated domain of my apps and domain1.eu is the default domain of my Yunohost instance).
Thus all my apps have a path set to /.
I don’t know what’s wrong with the links to which the tiles point to. Everything seems normal. And I can’t find any error in the logs…
Ah, I haven’t thought about that. Tbh, I don’t remember exactly why I concluded that I had to modify /usr/share/yunohost/templates/dnsmasq/plain/resolv.dnsmasq.conf. I’m going to restore the file and put back my resolvers in /etc/resolv.dnsmasq.conf.
Yes, I’m pretty sure that’s what I did. I tried to install another app that requires a mysql db (wordpress) and it seems to work.
Ok, I’m going to investigate what’s the problem there.
FYI, the issue with Wallabag (which occurs after creating or deleting a user) was known and will be fixed as soon as this pull request gets merged.
I upgraded my Wallabag and I can confirmed the permission issue doesn’t show up anymore (sudo yunohost app upgrade wallabag2 -u https://github.com/YunoHost-Apps/wallabag2_ynh/tree/testing --debug).