tbenyon

Hey @stezter,

Just keeping you updated.

I’ve found that I need to make a new release for you to achieve what you want but I’ve got the bit you need working locally.

It won’t work yet, but after the release you’ll need to add the following code to your functions.php file:

function stezter_exlog_add_additional_user_data($wp_user, $exlog_user_data, $rawResponse) {
    update_user_meta(
        $wp_user->ID,               // User ID
        'sunrise_userid',           // WP Meta field key
        $rawResponse['UserID'],     // External table data
        false                       // Not unique
    );
    update_user_meta(
        $wp_user->ID,               // User ID
        'sunrise_companyid',        // WP Meta field key
        $rawResponse['CompanyID'],  // External table data
        false                       // Not unique
    );
}

add_action('exlog_hook_action_authenticated', 'stezter_exlog_add_additional_user_data', 10, 3);

Keeping this ticket open still as I haven’t done the release and I need to look into your other issue and another users query also before then.

Thanks,

Tom

Hey @stezter,

The beers are much appreciated! 🙂

Looks like I’ll have a sore head over the weekend 🙂

Sure, let’s see if we can help you with this. I’m working today but will definitely be back to you over the weekend.

To get us started, can you tell me if the fields that you need to carry across are in the same users table as your other data? If they are in other tables it gets a little more complicated.

Can you let me know the names of the fields that you need to pull across also?

Thanks again for the beer. It’s genuinely appreciated,

Tom 🙂

I need to get on with my day job so can’t test now but had a quick look.

I think it might be because of migration mode. I’ll check at the weekend but on the off chance you want to test this in the mean time I thought I’d share this.

At the bottom of login/authenticate.php in the plugin folder there is this code:

                // Hook that passes user data on successful login
                do_action('exlog_hook_action_authenticated', $user, $exlog_userdata);
            }
        }

        // Whether to disable login fallback with the local WordPress version of the username and password
        // Prevents local login if:
        // - Disable local login  is set in the admin area
        // - OR
        // - The user was found but the password was rejected
        if (exlog_get_option('external_login_option_disable_local_login') == "on" || is_wp_error($user)) {
            remove_action('authenticate', 'wp_authenticate_username_password', 20);
        }
    }

    return $user;
}

if (exlog_get_option("external_login_option_enable_external_login") == "on") {
    add_filter('authenticate', 'exlog_auth', 10, 3);
}

I speculate that the issue may be fixed if you change it to:

                // Hook that passes user data on successful login
                do_action('exlog_hook_action_authenticated', $user, $exlog_userdata);
            }
        }

    }

    // Whether to disable login fallback with the local WordPress version of the username and password
    // Prevents local login if:
    // - Disable local login  is set in the admin area
    // - OR
    // - The user was found but the password was rejected
    if (exlog_get_option('external_login_option_disable_local_login') == "on" || is_wp_error($user)) {
        remove_action('authenticate', 'wp_authenticate_username_password', 20);
    }

    return $user;
}

if (exlog_get_option("external_login_option_enable_external_login") == "on") {
    add_filter('authenticate', 'exlog_auth', 10, 3);
}

Let me know if you try it 🙂

• This reply was modified 5 years, 8 months ago by tbenyon.

Hey @stezter,

Thanks for getting in contact and flagging this issue.

Can you please double check that you haven’t got ‘disable local login’ ticked in the admin area.

If it is not ticked the plugin SHOULD try to login on the external DB and then if it fails to connect, try to login using the WordPress DB.

I believed this to be working but I will have time this weekend to try and replicate this and rectify the issue. I wonder if it’s the migration mode preventing this functionality for some reason.

Keep me posted and I’ll get back to you at latest Sunday with an update.

Thanks,

Tom 🙂

I have solved it by adding drupal’s passord.inc file

GREAT IDEA!!!

I’m sure others will find it useful so thanks for sharing back here.

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

Thanks,

Tom 🙂

Hey @pwozniak89,

The problem is that I try to connect with a username that I have already created then deleted on WordPress database…
Maybe deletion have not removed all information about this account on WordPress database…

This was very interesting to me. What I expect to happen is the user would be overwritten by the external user. I’m going to put in a ticket for myself to see if I can replicate this. I’m wondering if it may be something like the user had the same username but different e-mail or the other way round. Or like you said, that the user was ‘soft’ deleted in some way. I will investigate 🙂

Is there a php function I can call on a page that allows me to access directly the external database to read other field for logged user?

The best way to achieve this is to map additional data as meta fields on the user. This is the WordPress way of storing additional data for a user.

You could use the exlog_hook_action_authenticated hook to add additional meta fields when they get authenticated.

The hook pulls in the new wordpress user and all the fields grabbed from the external table on the authenticated user.

You can find more information on how to use the plugin hooks in the FAQ.

I haven’t tested this, so treat it like pseudo code, but you could do something like this:

function pwozniak89_exlog_add_additional_user_data($wp_user, $exlog_user_data) {
  add_user_meta(
    $wp_user->ID,                          // User ID
    'fav_colour',                          // WP Meta field key
    $exlog_user_data['favourite_colour'],  // External table data
    false                                  // Not unique
  );
}

add_action('exlog_hook_action_authenticated', 'pwozniak89_exlog_add_additional_user_data', 10, 2);

This code could live in your functions.php file or where ever you like to store this information.

Sorry for the inconvenience, but I’d like to thank you for this great plugin and your answers that make me think about my mistakes!

No problem at all, and I’m glad you’re getting good use from the plugin.

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

Feel free to get back to me if you have any further questions.

Thanks,

Tom

🙂

Hey @pwozniak89,

I can ensure you that your English is way better than my French! 🙂

Great that the test connection is working!

When I try to connect my WordPress with a login/password in external DB it seems to work but nothing happen

This is a new one that I’ve never had reported. I presume you mean that it is redirecting you to the admin panel when you say it seems to work?

There are three next steps:

1. Disable ALL other plugins to ensure that it is not another plugin that is preventing this from working
2. Share your error logs so we can see if there is anything in there that indicicates what is going on
3. Ensure this is not a multisite as the plugin has not been tested on it

Thanks,

Tom