How to Enable PhpMyAdmin and RoundCube Auto-Login in DirectAdmin

By on June 4th, 2020

cPanel is one of the most common and widely used control panels. But cPanel has recently announced a massive increase in their pricing scheme. This increase in the price schema has impacted so many customers and businesses. So, customers are now migrating their cPanel sites to other control panels, and some of them are migrating their cPanel sites to DirectAdmin.

With the recent inrush of cPanel to DirectAdmin migration, there is a confusion in the access of PhpMyAdmin and RoundCube. In DirectAdmin, the PhpMyAdmin and RoundCube require login credentials. With cPanel, the users grant access to all the tables created under the cPanel user. The one-click feature within the cPanel interface helps an end-user to log into the PhpMyAdmin and RoundCube automatically.

When clients migrate from cPanel to DirectAdmin, they get confused with the DirectAdmin credentials and the credentials for the PhpMyAdmin and RoundCube. To log in to the PhpMyAdmin, they need to input the database user name and password and in case of the RoundCube, they need to input the user’s email address and password.

The SingleSignOn feature of the DirectAdmin can help the user to automatically log into the PhpMyAdmin and RoundCube with a single click via the DirectAdmin interface. Since October 2019, the Single SignOn feature of DirectAdmin is disabled by default.

In this knowledge base, we will learn how to enable the one-click login or auto-login feature for PhpMyAdmin and RoundCube via the DirectAdmin interface.

Steps to Enable One-Click Login for PhpMyAdmin from DirectAdmin

To enable the one-click login for PhpMyAdmin in the DirectAdmin interface, follow these steps.

First of all, Log in to the DirectAdmin server as a root user.

Then, Switch to the ‘directadmin’ directory by executing the following command.

# cd /usr/local/directadmin/

Run the following command to enable the one-click login for PHPMyAdmin.

# ./directadmin set one_click_pma_login 1

After that, restart the DirectAdmin service by using the following command.

# service directadmin restart

Then, switch to the ‘custombuild’ directory.

# cd custombuild

After that, execute the following command to update the build.

# ./build update

Finally, Run the following command to make all the changes reflect in the DirectAdmin panel.

# ./build phpmyadmin

After enabling the one-click login feature of PhpMyAdmin, you can log in to the PhpMyAdmin from DirectAdmin panel without entering the login credentials as such of cPanel. To test, follow these steps:

  • Log in to the DirectAdmin interface as a root user.
  • Go to the ‘Account Manager’ option and select the ‘MYSQL Management’ from the drop-down.

Auto Login

 

  • Then, select the database name from the list to which you want to login.
  • Click the ‘Login’ button far right to the database to login to the PhpMyAdmin without entering the login credentials.

To make PhpMyAdmin only accessible with the Single SignOn feature and not with the database user name and password, follow the steps given below.

Log in to the DirectAdmin server as a root user.

Switch to the ‘custombuild’ directory by using the following command.

# cd /usr/local/directadmin/custombuild

Then, update the build script by using the following command.

# ./build update

After that, disable the public feature of PHPMyAdmin by executing the following command.

# ./build set phpmyadmin_public no

Execute the following command to make all the changes reflect in the DirectAdmin panel.

# ./build phpmyadmin

After executing the above commands, when a user will try to log in to the PHPMyAdmin using the database credentials, the system will prompt the following message.

Access to phpMyAdmin is only allowed from the control panel.

 

Steps to Enable One-Click Login for RoundCube from DirectAdmin

The one-click login is often known as ‘Single SignOn or SSO logins. To enable the one-click login for RoundCube from the DirectAdmin interface, follow these steps:

Log in to the DirectAdmin server as a root user.

Switch to the ‘directadmin’ directory by using the following command.

# cd /usr/local/directadmin/

Then, enable the one-click Webmail login by executing the following command.

# ./directadmin set one_click_webmail_login 1

After that, restart the DirectAdmin service by executing the following command.

# service directadmin restart

Now, switch to the ‘custombuild’ directory.

# cd custombuild

After that, run the following command to update the build script.

# ./build update

Then, update changes to the dovecot configuration by executing the following command.

# ./build dovecot_conf

Execute the following command to update the changes to the EXIM configuration file.

# ./build exim_conf

Finally, execute the following command to update RoundCube.

# ./build roundcube

After executing the above commands, follow the below-given steps to avail the Single SignOn feature for RoundCube.

Log in to the DirectAdmin interface as a root user.

Navigate to ‘Email Manager’ and click the ‘Email Accounts’ option from the drop-down.

Auto Login

 

Select the email account from the list to which you want to login.

Then, click the ‘+’ symbol at the far right of the email account and select the ‘Sign In to Webmail’ option. This time, the system won’t prompt for login credentials and gets redirected directly to the RoundCube account.

Auto Login

Please note that this above feature does not get applied to the system accounts, and you need to log in to the system accounts using the DirectAdmin login credentials. The virtual email accounts can only use this feature.

 

Conclusion

We can enable the Single SignOn (SSO) login for PhpMyAdmin and RoundCube to easily access them directly from the DirectAdmin interface. We hope that this knowledge base was helpful to you. Please comment below for any questions or queries. If you are an InterServer customer, please reach out to our support team for further help.

Leave a Reply