Phpmyadmin sso - remote db

Community Support
1

Hello

Please tell me why, when automatically logging into a remote database, the PMA database is pulled from the local server instead of the remote server where it was created.
Because of this, the databases aren’t showing up and the login isn’t working correctly.
If I log into the remote database using my username and password, everything is fine.
But the auto-login isn’t working.

mysqli::real_connect(): (HY000/1045): Access denied for user ‘pma’@‘localhost’ (using password: YES)
Connection for controluser as defined in your configuration failed.

It is unclear why, when logging into a remote database, it pulls up localhost instead of the address of the remote database and the password that is written in /etc/phpmyadmin/conf.d/01-remote.php

2

Added:

$cfg[‘Servers’][$i][‘controlhost’] = ‘’;
$cfg[‘Servers’][$i][‘controlport’] = ‘’;

Specified the remote server host and port in /etc/phpmyadmin/conf.d/01-remote.php

There are no errors, but the control panel doesn’t create a temporary user to log in to the remote MySQL server.
((((

3

Does anyone know anything?):frowning:

4

It’s a pity that no one knows the answer to this question.:smiling_face_with_tear:

5

not 100% sure, but I think the one click sign in doesnt support remote db servers.

6

Who can know this information for sure?

7

Will SSO support be implemented for a remote server?

8

I didn’t test it but you could try this:

Replace RemoteHost in sed command with the actual remote host as seen in your current conf (v-list-database-hosts):

 cd /usr/local/hestia/install/deb/phpmyadmin/
 cp hestia-sso.php hestia-sso.php.ori
 sed -i -E 's/\$host = "localhost"/\$host = "RemoteHost"/' hestia-sso.php
 v-delete-sys-pma-sso
 v-add-sys-pma-sso
9

A “to many redirect” message pops up for a couple of seconds and then redirects you to the phpMyAdmin login page. Autologin for the remote server doesn’t work.

10

A phpmyadmin database has been created on the remote server. Login with username and password works perfectly. A separate file named 01-remote.php has been created in /etc/phpmyadmin/conf.d for the remote server.

01-localhost.php has been disabled.

11

211261 [Warning] Access denied for user ‘hestia_sso_RWIqHqyCgDduzQA3’@‘192.168.25.10’ (using password: YES)

I see this in the database server logs when attempting to auto-login to phpMyAdmin.
When creating a user, the control panel uses localhost instead of %.

Where can I change this in the scripts?

12

In short, the panel creates a temporary user with the host localhost.
Since we’re using a remote server, it would be logical to allow access for all hosts “%”
Where can I change the logic in the panel scripts?

I can help test auto-login on remote servers if you’re interested in any modifications to the panel.