tbenyon

Hey @rjjacob,

Won’t be able to check until tomorrow as at a family event. This is a good excuse to escape for 5mins 🙂

I could see the db change on my end this morning, however I hadn’t tried logging in with the e-mail (I always use the username) to make sure that logging in with email would work.

The only other thing I would ask you to do when testing this is to turn off the setting that falls back to the WP database for logging in if the external database isn’t available. On the off chance the external db connection failed on the test it would hide the issue and keep the current user details.

I will test this again tomorrow to confirm we’re getting different results but if you can check the above in the mean time that’d be great.

Regarding the username. If your client is happy that sounds great. If not, get back in contact and I can add it to the backlog but I’ve got a handful of other feature requests to cater for first.

In the meantime, let’s definitely fix this email updating issue 🙂

Tom

😀

No worries. I’ll mark this as resolved for now but if you have any further issues just let me know.

Thanks,

Tom

Hey @rjjacob,

Looking into this now.

Tom

Hey Jonathan,

Really glad that the plugin is working so well for you and I’m very grateful that you took the time to write a review!

Good luck with the site!

Thanks,

Tom

Hey @rushwhq,

Brilliant! Really glad that you got it working! I’d be SOOOOO grateful if you you write a review:
https://wordpress.org/support/plugin/external-login/reviews/#new-post

I would happily give you out my details to help you but I’ve been warned by the moderators for this before as I’m not allowed to give out my details even though some people have found me on Facebook or LinkedIn before.

To help you with your problem here let me mention a couple of points:
User Access
Being able to see other users details is dependent on their “Role”. If you’re an ‘admin’ role, by default, you’ll be able to access everyones roles. A ‘subscriber’ will not be able to.

Redirection After Login
If you want to redirect the user to a different page after they have logged in you can do this but because this is custom and outside of the scope of the plugin this is something you will manage yourself (or I’m sure there’s a plugin to do it).

In your functions.php file you can add the following code and it will redirect the user to the home page once they log in.

function exlog_login_redirect() {
    return '/';
}

add_filter('login_redirect', 'exlog_login_redirect');

If you wanted the dinosaurs page you just have something like this:

function exlog_login_redirect() {
    return '/dinosaurs';
}

add_filter('login_redirect', 'exlog_login_redirect');

Let me know if you have any more questions.

Again, a review would be really appreciated 🙂

Thanks,

Tom

• This reply was modified 7 years, 6 months ago by tbenyon. Reason: fixed type
• This reply was modified 7 years, 6 months ago by Steven Stern (sterndata).

Hey @rushwhq,

I’m sure we can find the answer together. Thanks for the screenshot as it clearly seems that the connection to the database is fine.

Can you go through these steps and tell me where you get stuck and then we can try some more steps until we find the issue.

1) Can you make doubly sure you’ve got a username and password that are working with the other system that uses the external database. I know this is obvious but I’ve made this cock up many times before. Double check.

2) With the password from the account that you know works, go to a website such as the one below and type in your password. Make sure that the result is exactly the same as what is in the password field on the external database for that user.
https://www.md5hashgenerator.com/

3) If you don’t see any issues, could you please screenshot your settings page for me so I can have a look? If this is the case we’ll try some more things.

Thanks,

Tom

Hey @windly,

Haven’t heard back from you so I’m presuming you’ve got this in hand.

If you need any advice or have any further questions get back to me but for now I’ll mark this as resolved.

Thanks,

Tom 🙂

Hey Kyle,

Sorry for the delay.

My first thought is, have you searched for User Migration plugins? I haven’t but there may already be something out there that does exactly what you want.

If not . . .

You’re right that the users are getting converted to the WordPress users after they login.

I don’t know where you’re current DB is but you could leave it where it is, or move it to the same place as the WordPress DB one so you don’t have to have two servers running. You may already have it on the same server?

This way I guess using the plugin would mostly do what you’re looking for as it stands.

The plugin I’ve written was based on the external system and database being the master record and handling the resetting of passwords and creating accounts.

The benefits of what’s already in my plugin:
– A new user would get created from the old system at first login
– This user would have a new safer password hash created

The issues to solve would be:

1) We would have to reserve any usernames already used in the external database to ensure that a new user doesn’t take it before an old user has been migrated

2) We would need to make the new DB be the preference so if a user already exists with that username we log them in, with WP. If not we check the external DB and see if they exist there and create them.

3) I’ve had someone before who had a very custom hashing method like yours and I suggested I didn’t want to add it to the plugin as it was going to bloat it with a custom solution that no one else would use. I’ve now had a thought seeing yours that I could allow users to create a function (with a name I define in the instructions) that would exist in your functions.php file that would take in the password and salt and you could put the code you’ve specified above in it for your custom case.

Does this all make sense? Do you have any thoughts? Have I missed anything?