Plugin breaks the connection with the database after activation in a multisite

  • Resolved MasterJuan

    (@masterjuan)


    3 years, 1 month ago

    Hi,

    I have a multisite WP which had Really Simple SSL activated. After the latest update to WordPress 5.8.3 plugin something alters in the DB and I am getting error establishing a database connection.

    I checked the db connection with a custom php file and it works. I made a rollback to the db using all the rest plugins activated to the multisite network except from Really Simple SSL, and the sites work.

    Right after the activation of this plugin the error with the DB comes again.

    I am getting also, these errors:
    Undefined index: host in /wp-content/plugins/really-simple-ssl/class-certificate.php on line 41
    strpos(): Non-string needles will be interpreted as strings in the future. Use an explicit chr() call to preserve the current behavior in /wp-content/plugins/really-simple-ssl/class-certificate.php on line 89 & 90

    Any thoughts?

    • This topic was modified 3 years, 1 month ago by MasterJuan.
    • This topic was modified 3 years, 1 month ago by MasterJuan.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Mark

    (@markwolters)

    Hi @masterjuan,

    Really Simple SSL won’t make changes to your database. What options do you have enabled in the Really Simple SSL settings? Did you activate SSL networkwide or on a per-site basis? I’m unable to reproduce the issue on a multisite environment.

    In regards to the undefined index host warning, it could be the parse_url function does not return a host value on your site. We can add an extra check in the plugin to prevent this notice.

    The certificate common name and alternative names should already be strings. We will check this to make sure it won’t cause any issues.

    Thread Starter MasterJuan

    (@masterjuan)

    Hi Mark,

    I removed the plugin because everytime that I enabled it networkwide, immediately I saw the error “Error establishing a database connection”.

    I agree that it is really weird behavior and the plugin doesn’t do any action to the db itself but I am describing what behavior I noticed.

    Plugin Contributor Rogier Lankhorst

    (@rogierlankhorst)

    @masterjuan,

    The error you saw seems a warning because the certificate check returns “false” on the common names and alternative names. I’ll make sure this will be caught in the next update. It looks like the certificate doesn’t return any valid data here.

    As for your database error:

    When the plugin is activated, it changes your site url to https, and adds a redirect to https.

    If this action causes a db error, I would expect a server configuration issue, where the database is not reachable when the site is loaded over https.

    Were you able to load the site over https, (while Really Simple SSL not active)?

    Plugin Contributor Rogier Lankhorst

    (@rogierlankhorst)

    The php warning is caught in this branch:
    https://github.com/Really-Simple-Plugins/really-simple-ssl/tree/catch-not-set-subject-alternative-and-common-names-in-cert

    Thread Starter MasterJuan

    (@masterjuan)

    Hi Rogier,

    Thanks for the feedback.
    Yes, at the moment without having the plugin at all, the site loads over https.
    https://www.antonios-antoniou.gr/

    Plugin Contributor Rogier Lankhorst

    (@rogierlankhorst)

    Additionally, I see that the built in PHP function parse_url() does not return the ‘host’ key on your site_url. Possibly it returns just ‘false’. What is your site_url? Do you have this error on the domain https://www.antonios-antoniou.gr?

    As these are pretty standard functions (site_url from WP, and parse_url from PHP) it seems very strange that your site does not return a valid response on such default functions.

    Is it possible the WordPress function site_url() returns an unexpected value? If that is the case, Really Simple SSL is given incorrect information which would explain strange behaviour.

    Plugin Contributor Rogier Lankhorst

    (@rogierlankhorst)

    Analysing what you describe, I suspect that the issue is in a specific configuration in your wp-config.php.

    Is it possible the database name contains the site_url? Could you send us a copy of your wp-config.php (with passwords and salts removed) so we can investigate that?

    you can send it to support(at)really-simple-ssl.com

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Plugin breaks the connection with the database after activation in a multisite’ is closed to new replies.