PhpMyAdmin with LetsEncrypt


#1

Hello

I have a problem with my server.

I have linux server with centos 6
Don’t have plesk
only command line
There ara phpmyadmin and mysql

After install letsEncrypt I can’t empty to phpmyadmin
https://x.x.x.x/phpmyadmin/
error

Este sitio web no puede proporcionar una conexión segura

phpanunzia no ha aceptado el certificado de inicio de sesión o es posible que no se haya proporcionado ninguno.

  • Intenta ponerte en contacto con el administrador del sistema.
    ERR_BAD_SSL_CLIENT_AUTH_CERT

There is a domain with letsEncrypt certificate, but it don’t have any problem

Could you help me?

Thanks

Best Regards,


#2

Hi,

You’ll need to copy the entire http virtual host and convert it to https version.

Thank you


#3

Hi @anunzia

if you have installed a certificate, you must use phpmyadmin with your domain name, not with your ip address.

https://yordomain-name.com/phpmyadmin/

should work.


#4

Hello

https://phpanunzia.anunzia.com/phpmyadmin

Sorry, I Agree
But it’s the same error.

Best Regards,


#5

Hi,

Could you please share us the https virtual host that controls your phpmyadmin?

Also, please share the output of sudo certbot certificates

Thank you


#6

Ah, now you have shared your domain name.

There is a self signed certificate, not a Letsencrypt certificate.

And there

https://transparencyreport.google.com/https/certificates?cert_search_auth=&cert_search_cert=&cert_search=include_expired:true;include_subdomains:false;domain:phpanunzia.anunzia.com&lu=cert_search

is no Letscencrypt certificate created. So I can’t find this domain.

What means this?

Which tool you had used?


#7

Also, some of these errors look like they’re related to client certificate authentication (in which your web browser tries to present a certificate to the server). Is it possible that you obtained a Let’s Encrypt certificate and then mistakenly installed it into your web browser instead of your web server? Let’s Encrypt certificates are meant to be installed on servers.


#8

Hello
Thanks you help,

---------------------the instalation--------------------------------------

yum install epel-release

yum install git

cd /usr/local/

git clone https://github.com/letsencrypt/letsencrypt

cd /usr/local/letsencrypt

./letsencrypt-auto --apache -d your_domain.tld


The install is en server, centos 6.1

[root@php letsencrypt]# ./letsencrypt-auto --apache -d phpanunzia.anunzia.com/phpMyAdmin
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator apache, Installer apache
Obtaining a new certificate
An unexpected error occurred:
The request message was malformed :: Error creating new order :: Invalid character in DNS name
Please see the logfiles in /var/log/letsencrypt for more details.
You have new mail in /var/spool/mail/root
[root@php letsencrypt]#

Best reguards,


#9

No /phpMyAdmin necessary. It’s just the domain name.