Certbot generating Selfsigned Cert not signed cert

Certbot is issuing a selfsigned cert, and not a signed cert.

My domain is: ottawakaraoke.ca

I ran this command:
sudo /usr/local/bin/certbot-auto --apache

It produced this output:
Congratulations…
My web server is (include version):
Server version: Apache/2.4.10 (Debian)

The operating system my web server runs on is (include version):

My hosting provider, if applicable, is:

I can login to a root shell on my machine (yes or no, or I don’t know):
Debian 8 (Jessie)
I’m using a control panel to manage my site (no, or provide the name and version of the control panel):
i have root server access
The version of my client is (e.g. output of certbot --version or certbot-auto --version if you’re using Certbot): Certbot 0.40.1

Please show:
certbot-auto certificates

Found the following certs:
  Certificate Name: canadakaraoke.com
    Domains: canadakaraoke.com www.canadakaraoke.com www.ottawakaraoke.ca
    Expiry Date: 2020-02-06 01:02:33+00:00 (VALID: 89 days)
    Certificate Path: /etc/letsencrypt/live/canadakaraoke.com/fullchain.pem
    Private Key Path: /etc/letsencrypt/live/canadakaraoke.com/privkey.pem
  Certificate Name: www.ottawakaraoke.ca
    Domains: www.ottawakaraoke.ca
    Expiry Date: 2020-02-06 01:34:52+00:00 (VALID: 89 days)
    Certificate Path: /etc/letsencrypt/live/www.ottawakaraoke.ca/fullchain.pem
    Private Key Path: /etc/letsencrypt/live/www.ottawakaraoke.ca/privkey.pem
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

You have not obtained a cert to cover this name:

You have two certs; and both cover:

If you browse to the website the cert is showing as invalid:

If you would care to show the URL used, we might see the problem better.
This is my point:
https://www.ssllabs.com/ssltest/analyze.html?d=ottawakaraoke.ca&hideResults=on&latest
https://www.ssllabs.com/ssltest/analyze.html?d=www.ottawakaraoke.ca&hideResults=on&latest

Please use the following link:ottawakaraoke.ca

It has no choice but to serve you with that "catch-all" cert.

In case you missed it:

Ready to “fix” the problem?
[you do see the problem… right?]

Hello,

I have reviewed the SSL labs.

I ran the following command, chose “reinstall” and was still issued with the same cert.

 sudo /usr/local/bin/certbot-auto --apache -d ottawakaraoke.ca

Yes, please @rg305, I appreciate your guidance.

I think it’s because my pre-installed config has Debian 8, and not Ubuntu 16, I’m experiencing this strange config.

If your willing to “go under the hood” (just a bit), this may be the quickest solution:
Step 1: Obtain a cert with both names:

sudo /usr/local/bin/certbot-auto certonly --apache -d ottawakaraoke.ca -d www.ottawakaraoke.ca

[show results (again) with: cerbot-auto certificates]

Hello @rg305

If your willing to “go under the hood” (just a bit), this may be the quickest solution:
Step 1: Obtain a cert with both names:

I ran the following command.
sudo /usr/local/bin/certbot-auto certonly --apache -d ottawakaraoke.ca -d www.ottawakaraoke.ca

Here is the output from sudo /usr/local/bin/certbot-auto certificates

Saving debug log to /var/log/letsencrypt/letsencrypt.log

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Found the following certs:
  Certificate Name: canadakaraoke.com
    Domains: canadakaraoke.com www.canadakaraoke.com www.ottawakaraoke.ca
    Expiry Date: 2020-02-06 01:02:33+00:00 (VALID: 89 days)
    Certificate Path: /etc/letsencrypt/live/canadakaraoke.com/fullchain.pem
    Private Key Path: /etc/letsencrypt/live/canadakaraoke.com/privkey.pem
  Certificate Name: ottawakaraoke.ca
    Domains: ottawakaraoke.ca www.ottawakaraoke.ca
    Expiry Date: 2020-02-06 02:12:39+00:00 (VALID: 89 days)
    Certificate Path: /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
    Private Key Path: /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem
  Certificate Name: www.ottawakaraoke.ca
    Domains: www.ottawakaraoke.ca
    Expiry Date: 2020-02-06 01:34:52+00:00 (VALID: 89 days)
    Certificate Path: /etc/letsencrypt/live/www.ottawakaraoke.ca/fullchain.pem
    Private Key Path: /etc/letsencrypt/live/www.ottawakaraoke.ca/privkey.pem
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
root@vps258057:/etc/apache2/sites-enabled#

If you visit the link again ottawakaraoke.ca, you will notice that there is 'mixed content'.

let me attempt a fix...

Perfect!
[ I was a bit skeptical about that success as you have failed to mention that your site is running WordPress]

Step 2: Use the new cert.

  • (A) Locate the vhost config that is using the “www” cert
    grep -Eri 'www.ottawakaraoke.ca' /etc/apache2/
    or
    grep -Eri 'fullchain.pem|privkey.pem' /etc/apache2/
    [show output]
  • (B) Modify file found in (2A) replacing sections relating to which cert is being used.
    edit file:
    /etc/apache2/sites-available/wordpress-le-ssl.conf
    replacing portion of cert lines with new cert info:
    /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
    /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem
  • (C) Restart Apache
    systemctl restart apache2

@rg305, I have been working with WordPress for a long time, and learned a lot.

grep -Eri 'www.ottawakaraoke.ca' /etc/apache2/

/etc/apache2/sites-available/wordpress.conf:ServerAlias www.ottawakaraoke.ca
/etc/apache2/sites-available/wordpress.conf:RewriteCond %{SERVER_NAME} =www.ottawakaraoke.ca [OR]
/etc/apache2/sites-available/wordpress-le-ssl.conf:ServerAlias www.ottawakaraoke.ca

apache restarted by sudo systemctl restart apache2

the website is still showing as "not secure" ottawakaraoke.ca

We are not done yet - we’re still on 2B.
^^^ Please review my previous post; as that is where I’m updating the steps to follow ^^^

grep -Eri 'fullchain.pem|privkey.pem' /etc/apache2/
/etc/apache2/sites-available/wordpress-le-ssl.conf:SSLCertificateFile /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
/etc/apache2/sites-available/wordpress-le-ssl.conf:SSLCertificateKeyFile /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem
/etc/apache2/sites-available/wordpress-le-ssl.conf:#SSLCertificateFile /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
/etc/apache2/sites-available/wordpress-le-ssl.conf:#SSLCertificateKeyFile /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem

I also replaced the 2A, although it was using the same full path.

SSLCertificateFile /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem
#SSLCertificateFile /etc/letsencrypt/live/ottawakaraoke.ca/fullchain.pem
#SSLCertificateKeyFile /etc/letsencrypt/live/ottawakaraoke.ca/privkey.pem

My eyes must be crossed.
Those lines look the same.
anywho - move to step 2C

`

they are the same, i only changed it to show you i looked at the file.

I have restarted the apache server, and the website is still showing as “not secure”