Resolved Error with SSL certificates

Discussion in 'Plesk Onyx' started by KarlmitC, Apr 3, 2017.

  1. KarlmitC

    KarlmitC New Pleskian

    4
    20%
    Joined:
    Sep 14, 2016
    Messages:
    21
    Likes Received:
    0
    Location:
    Berlin
    Hello everyone,

    After the last Let's Encrypt update I already had some issues but after some tweaking it worked in the end.
    But now I have the problem that all my certificates are gone and that I can't assign any new ones using Let's Encrypt. Even the default certificates are gone.
    I tried to run the repair tool and got the following error:
    Code:
     Inconsistency in the table 'IP_Addresses' for the column
      ssl_certificate_id: No rows in the table 'certificates' with  = 1 . [ERROR]
        Creating a database dump ........................................ [OK]
        A dump of the database was created before an attempt to repair the database:                                                                                                                                                              /var/lib/psa/dumps/mysql.preresolve.20170403-200911.dump.gz
        Assigning the default SSL/TLS certificate to the IP address ..... [FAILED]
        - Unable to find row with id 1 in certificates table.
    
    Additionally all of my domains are suddenly offline saying that the connection was closed unexpectedly.
    Does anybody now how to resolve that and make SSL certificates work again?

     
    Last edited: Apr 3, 2017
  2. UFHH01

    UFHH01 Platinum Pleskian Plesk Guru

    40
    64%
    Joined:
    Jun 11, 2013
    Messages:
    4,919
    Likes Received:
    1,017
    Location:
    Hamburg / Germany
  3. KarlmitC

    KarlmitC New Pleskian

    4
    20%
    Joined:
    Sep 14, 2016
    Messages:
    21
    Likes Received:
    0
    Location:
    Berlin
    Thanks a lot, this worked and the websites are online again.
    The only problem I have now is that if I want to renew a SSL-certificate for any website I get the following error:
    Code:
    Error: Let's Encrypt SSL certificate installation failed: Install certificate failure: Unable to set certificate name :
    
     
  4. UFHH01

    UFHH01 Platinum Pleskian Plesk Guru

    40
    64%
    Joined:
    Jun 11, 2013
    Messages:
    4,919
    Likes Received:
    1,017
    Location:
    Hamburg / Germany
    Hi KarlmitC,

    This indicates issues with your Plesk Let's Encrypt extension. Consider to re-install the extension and see if this already solves your issue(s).


    Another possible root cause could be an unfinished update/upgrade/patch process, which you could solve with:

    plesk installer --select-product-id plesk --select-release-current --reinstall-patch --install-component base
    plesk installer --select-product-id plesk --select-release-current --upgrade-installed-components
     
    Dukemaster likes this.
  5. KarlmitC

    KarlmitC New Pleskian

    4
    20%
    Joined:
    Sep 14, 2016
    Messages:
    21
    Likes Received:
    0
    Location:
    Berlin
    @UFHH01 I tried all those steps but unfortunately the issue is still there...
     
  6. UFHH01

    UFHH01 Platinum Pleskian Plesk Guru

    40
    64%
    Joined:
    Jun 11, 2013
    Messages:
    4,919
    Likes Received:
    1,017
    Location:
    Hamburg / Germany
    Best Answer
    KarlmitC likes this.
  7. IgorG

    IgorG Forums Analyst Plesk Team

    43
    84%
    Joined:
    Oct 27, 2009
    Messages:
    22,949
    Likes Received:
    755
    Location:
    Novosibirsk, Russia
    @KarlmitC Yes, it looks like that this orphaned database inconsistency still there.
    I would suggest you try solution from the mentioned github article. Contact Plesk Support if it does not help.
     
  8. KarlmitC

    KarlmitC New Pleskian

    4
    20%
    Joined:
    Sep 14, 2016
    Messages:
    21
    Likes Received:
    0
    Location:
    Berlin
    I tried the way described in that Github article but I don't have any entries with a NULL value.

    So I guess I have to contact the support.
     
  9. UFHH01

    UFHH01 Platinum Pleskian Plesk Guru

    40
    64%
    Joined:
    Jun 11, 2013
    Messages:
    4,919
    Likes Received:
    1,017
    Location:
    Hamburg / Germany
  10. trialotto

    trialotto Golden Pleskian Plesk Guru

    34
     
    Joined:
    Sep 28, 2009
    Messages:
    1,325
    Likes Received:
    159
    @KarlmitC

    It is not necessary to have NULL values, the Github article also provides solid suggestions for other scenario´s.

    I have "translated" the Github article to some form of a manual, with all the steps that you can or should follow.

    Please have a look at: Resolved - Solutions for recent Let´s Encrypt issues

    I am pretty sure that you will be able to remove the problematic certificates and re-install them (manually) afterwards. Do not forget to update the Let´s Encrypt extension!

    Regards.....
     
    KarlmitC likes this.
  11. KarlmitC

    KarlmitC New Pleskian

    4
    20%
    Joined:
    Sep 14, 2016
    Messages:
    21
    Likes Received:
    0
    Location:
    Berlin
    After that error is resolved I just have the question whether or not it is possible to also assign certificates to the subdomains of a domain alias. I didn't find that option yet and it seems like it isn't done automatically when issuing a certificate to the alias.
     
Loading...