log out button does nothing

[m4lvin]

Clicking the log out button in phpMyAdmin sends me to /phpMyAdminPath/index.php?route=/logout but that does nothing and shows the phpMyAdmin start page again, still being logged in.

Is there a way to make it lead to /yunohost/sso/, similar to how the nextcloud package does it?

Versions:

• yunohost 12.0.16
• phpMyAdmin package 5.2.2~ynh1

[williamdes]

What is the auth type in the phpMyAdmin config?

[m4lvin]

Do you mean these lines in the config.inc.php file?

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'phpmyadmin_root';
$cfg['Servers'][$i]['password'] = 'XXXXXXXXXXXXXXX';

I guess this means there is a hard-coded account that phpMyAdmin uses to talk to the mysql server, so there is no way to "log out" of this account? As far as I understand the outer authentication is done by the yunohost ssowat via the nginx config, so phpMyAdmin does not even "see" it. But is there any way to make the log out button trigger a log out at the SSO level, or, as a workaround, redirect it to the SSO portal where there is a log out button?

[williamdes]

I guess this means there is a hard-coded account that phpMyAdmin uses to talk to the mysql server, so there is no way to "log out" of this account?

Nope, you can not logout from a config account. I makes no sense from a tech point of view.

As far as I understand the outer authentication is done by the yunohost ssowat via the nginx config, so phpMyAdmin does not even "see" it. But is there any way to make the log out button trigger a log out at the SSO level, or, as a workaround, redirect it to the SSO portal where there is a log out button?

If you want a real SSO switch to a real SSO setup: https://docs.phpmyadmin.net/en/latest/setup.html#signon-authentication-mode