Check external database *every login*, yes?

  • Resolved gonzosdrummer

    (@gonzosdrummer)


    4 years, 11 months ago

    Hi — this plugin looks like exactly what I want, and I want to confirm something.

    The scenario I need to support:

    1. A user in my external database logs into a WordPress site that uses this plugin.
    2. The plugin successfully validates the user’s username and password.
    3. As a result (I think), a record is created in the wp_users table for this user.

    4. Later, this user loses his status (leaves, terminates, stops paying, whatever).
    5. As a result, I NULL his password in my external database.
    6. The defunct user tries to log into WordPress.
    7. I want him to NOT get into WordPress, because I want the plugin to validate his credentials against my external database *every time he logs in*, and not just the very first time. I don’t want WordPress ever to validate him against the wp_users table.

    Based on some comments in the support thread, I *think* this plugin operates this way, but wanted to confirm.

    Thanks,

    Steve

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

    (@tbenyon)

    Hey @gonzosdrummer,

    The plugin will always try and find the user on the external system first. If they can be found, they are validated and because you disabled them they would no longer be authenticated.

    However, if the user is not found, or if the connection to the external data fails, the plugin will fall back to login users with the WordPress database (at which point they would be validated). You can however disable falling back to local login. There is a check box for this.

    If you have any further issues or questions please get back to me ??

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

    Thanks!

    Tom

    Thread Starter gonzosdrummer

    (@gonzosdrummer)

    Thanks for the very quick response, Tom. I’ll give it a try and let you know.

    Thread Starter gonzosdrummer

    (@gonzosdrummer)

    Tom,

    Worked like a charm (except for the part where I locked myself out of WordPress entirely (even as an admin), had a heart attack, and had to start over).

    Thanks again for your quick response, and for writing a great plugin. Beer is coming your way. PayPal says you’re in Burgess Hill? Closest I’ve ever been to that is the Roman ruins at Fishbourne.

    Steve

    Plugin Author tbenyon

    (@tbenyon)

    Hey Steve,

    Locked myself out of WordPress so many times during development ??

    I feel the pain!!! ??

    Yep! Lived in Burgess Hill forever. I’ve got so much family here I can’t leave …and the last couple of weeks has given another factor keeping me locked here ??

    Thank you for generosity! Genuinely made my day. ?? I’m actually going to use it for a Beer52 order.??

    If you have any further issues please don’t hesitate to get in contact.

    Stay safe ??

    Tom

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Check external database *every login*, yes?’ is closed to new replies.