babelouest / glewlwyd

Experimental Single Sign On server, OAuth2, Openid Connect, multiple factor authentication with, HOTP/TOTP, FIDO2, TLS Certificates, etc. extensible via plugins
https://babelouest.github.io/glewlwyd
Other
429 stars 80 forks source link

glewlwyd attempts to log in as root to mysql server despite different data provided #211

Closed danielw1990 closed 1 year ago

danielw1990 commented 1 year ago

So during the setup it asks for credentials for mysql. I provide them and then it fails because it attempts a root login without password. According to itself. Well, of course that fails, I never asked it to do that and that account needs a password. Which I was never asked to provide and don't see the need for.

What is going on here? Why does it attempt to log in as root into the mysql server during the installation process?

babelouest commented 1 year ago

This doesn't seem right, what installation process are you using? Is it installed via a distribution package?

danielw1990 commented 1 year ago

I installed it via the package manager of Ubuntu 20.04.5 LTS.

babelouest commented 1 year ago

I don't know what causes your issue, but don't use the root MySQL user to run glewlwyd (you already know that).

You can for example install the package without installing the database, then manually install the database based on the install documentation, use the database scripts that should be available in /usr/share/doc/glewlwyd, not the one from this repo, they are not up to date.

Or you can open an issue at Ubuntu, they may help you better then I.

babelouest commented 1 year ago

Also note that glewlwyd 1.x is deprecated for a long time, and not recommended to be used in production.

danielw1990 commented 1 year ago

Oh, okay, So I will try again after the dist upgrade.

glewlwyd Version 1.4.9