Word press stopped working - certificate issues

Discussion in 'Server Operation' started by Trunkles, Jan 20, 2017.

  1. Trunkles

    Trunkles Member

    Woordpress site just stopped working after I changed thepassword in wp-config.php. I changed the password via PHPMyAdmin too and yes, I MD5ed it.Now I get Error establishing a database connection when I go to the site and apach2/error.log has this in it.

    [Fri Jan 20 21:51:44.020859 2017] [ssl:warn] [pid 27212] AH01909: laphroaig.drsimon.co.nz:8080:0 server certificate does NOT include an ID which matches the server name
    [Fri Jan 20 21:51:44.021044 2017] [ssl:error] [pid 27212] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: emailAddress=simon@drsimon.co.nz,CN=Simon,O=Dr Simon,L=Paraparaumu,ST=Kapiti,C=NZ / issuer: emailAddress=simon@drsimon.co.nz,CN=Simon,O=Dr Simon,L=Paraparaumu,ST=Kapiti,C=NZ / serial: DD1F36DA2EC78DE9 / notbefore: Dec 18 23:30:21 2016 GMT / notafter: Dec 16 23:30:21 2026 GMT]
    [Fri Jan 20 21:51:44.021055 2017] [ssl:error] [pid 27212] AH02604: Unable to configure certificate laphroaig.drsimon.co.nz:8080:0 for stapling
    [Fri Jan 20 21:51:44.032610 2017] [mpm_prefork:notice] [pid 27212] AH00163: Apache/2.4.18 (Ubuntu) mod_fcgid/2.3.9 mod_python/3.3.1 Python/2.7.12 OpenSSL/1.0.2g configured -- resuming normal operations

    Obviously I've done something silly but I'm bloed if I know what. Any ideas?
    Thanks folks.
    Simon.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    MySQL passwords are not encrypted with md5, they are encrypted with the "password" function of MySQL.
     
  3. Trunkles

    Trunkles Member

    The mysql user is encrypted with "Native MySQL authentication" whiich I think is the right one.
    The user in the wp-users table is the one done with MD5 which is what the wordpress instructions said to use. However, I've just redone that with the PASSWORD function and it's made no difference.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then there was a misunderstanding. Using password for mysql and md5 for the wp admin user is fine.

    The ssl error is not an error of mysql or wp users, I guess you might have missed to install the intermediate / bundle ssl certificate for the ssl cert that you use in that website.
     
  5. Trunkles

    Trunkles Member

    "install the intermediate / bundle ssl certificate for the ssl cert that you use in that website.". You're probably right. Which leads to the obvious question... how do I do that? Is it a section in "Perfect Server" that I missed somehow?
     

Share This Page