Cant acces phpmyadmin

[erwin]

dear sir,
i cant acces to login phpmyadmin… how i can acces this ? this is new server with new setting on hestia cp

[sahsanu]

Basically you should use yourDomain/phpmyadmin instead of yourServerIp/phpmyadmin

Take a look to these docs:

Why I can’t use http://ip/phpmyadmin/
Database & phpMyAdmin SSO | Hestia Control Panel

How can I enable access to http://ip/phpmyadmin/
Database & phpMyAdmin SSO | Hestia Control Panel

[erwin]

thks for answer… i want to try it

[erwin]

i still confused to follow this …

i am still failed, and cannt acces phpmyadmin

after i write this >>> nano /etc/apache2/conf.d/ip.conf
and then appear like this

have to i save directly using control x, and then save … ???
i ask about writing include optional … ???

[erwin]

make erorr

[sahsanu]

Hi @erwin,

Note: As I don’t know which is your ip, I will use 203.0.113.1 in all my post so you must replace it with your own public ip.

Note 2: all the commands must be executed as user root.

/etc/apache2/conf.d/ip.conf doesn’t mean literally the file ip.conf but a file with your public ip like 203.0.113.1.conf

To view the files inside that dir:

ls -l /etc/apache2/conf.d/

Once you know what is the actual conf file, edit it:

nano /etc/apache2/conf.d/203.0.113.1.conf

And this is what you would see before modifying it:

Listen 203.0.113.1:8443
Listen 203.0.113.1:8080
<VirtualHost 203.0.113.1:8080>
    ServerName 203.0.113.1
    DocumentRoot /var/www/html/
    Alias /error/ /var/www/document_errors/

</VirtualHost>

<VirtualHost 203.0.113.1:8443>
    ServerName 203.0.113.1
    DocumentRoot /var/www/html/
    Alias /error/ /var/www/document_errors/

    SSLEngine on
    SSLVerifyClient none
    SSLCertificateFile         /usr/local/hestia/ssl/certificate.crt
    SSLCertificateKeyFile      /usr/local/hestia/ssl/certificate.key

</VirtualHost>

Now you need to add IncludeOptional /etc/apache2/conf.d/*.inc inside both VirtualHost blocks and it should look like this:

Listen 203.0.113.1:8443
Listen 203.0.113.1:8080
<VirtualHost 203.0.113.1:8080>
    ServerName 203.0.113.1
    DocumentRoot /var/www/html/
    Alias /error/ /var/www/document_errors/
    IncludeOptional /etc/apache2/conf.d/*.inc
</VirtualHost>

<VirtualHost 203.0.113.1:8443>
    ServerName 203.0.113.1
    DocumentRoot /var/www/html/
    Alias /error/ /var/www/document_errors/

    SSLEngine on
    SSLVerifyClient none
    SSLCertificateFile         /usr/local/hestia/ssl/certificate.crt
    SSLCertificateKeyFile      /usr/local/hestia/ssl/certificate.key
    IncludeOptional /etc/apache2/conf.d/*.inc
</VirtualHost>

Save the file.

Remove the ip.conf file you created previously:

rm -f /etc/apache2/conf.d/ip.conf

And now restart Apache2:

systemctl restart apache2

[erwin]

after restart …appear this ???

[sahsanu]

chown -R root:www-data /etc/phpmyadmin/

[erwin]

BE SUCCESS… thks very much