Error 500 when testing connection

  • Resolved sovrgn

    (@sovrgn)


    4 years, 5 months ago

    Hi There,

    First off, great plugin and well documented, so thanks!

    I have set up the plugin accordingly, double and tripled checked the details and still I am receiving a Error 500.

    I took a look through the forum at the other error 500 issues, and none of them seem to be an issue, I have a mysql db with data in the table, I am able to access the DB via another method, as it is sending the data and saving the data to the DB.

    I am waiting for my server support to give me access to the logs, which may help to debug this. The error doesn’t return anything special, just a generic “Error: 500 There was an error on the server.”

    When test connection is pressed, the loading screen appears, and seems to be doing something. After a few seconds, it returns the error message. I am assuming it may be timing out or permissions on the server.

    I will update once I hear from the support re the logs.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author tbenyon

    (@tbenyon)

    Hey @sovrgn,

    This is frustrating – sorry to hear you’ve hit this hurdle.

    The best place to be looking at for errors is probably the database server, but if not, checking the PHP error logs for your WordPress install may also shed some light.

    I’m presuming this is while you’re using the ‘Test Connection’ button?

    If you wanted to add additional logs, you could add them to the exlog_test_query() function in external_login/login/db.php.

    I would be very surprised if this is an issue with the plugin itself but if you have more questions I’m happy to do what I can to help you debug this.

    Either way – keep me posted, I’m sure we’ll get there ??

    Thread Starter sovrgn

    (@sovrgn)

    Hi @tbenyon

    Good news! I’ve managed to get it to work. I simply changed the Database host from the ip address of the server to localhost. I mean, it may as well be right ??

    Now when I pull the data from the table, it works.

    Thread Starter sovrgn

    (@sovrgn)

    success!

    Plugin Author tbenyon

    (@tbenyon)

    Hey @sovrgn,

    That’s great news! Thanks for getting back to me to let me know how you got on and well done for sorting it! ??

    If it is all working now I’d be grateful if you could write a review or even buy me a beer.

    Thanks again,

    Tom ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error 500 when testing connection’ is closed to new replies.

Tags