tbenyon

Hi there,

If I understand you correctly – yes, this is exactly what the plugin is made for.

I would encourage you to have a good read through of the main plugin page particularly the “FUNCTIONALITY WARNINGS AND LIMITATIONS” section just to make sure this works with your user flow.

If you need minor modifications I’m happy to look into adding basic additions for you.

If you have any issues getting this setup please feel free to get back to me. In fact – I’d even love to hear back if you got it all set up and working ok ??

Thanks,

Tom

Hey Asbell,

Apologies for the delayed reply. No it doesn’t. The main purpose of the plugin is to use an already exisiting login system with a full work flow and be able to login with that table of users.

If you don’t already have that in an external system, you could just use WordPress’ built in users system. I’m guessing there might well be a reason why you don’t want to do this?

Even if this isn’t the plugin you’re looking for, I’m more than happy to come up with ideas for you to help you solve your problem if you want to give me more information.

Thanks Asbell,

Tom

Hey Bartekryt,

I’m just going to test compatibility with it now.

If it’s not, are you still interested in the plugin? If so I’m happy to get this working for you asap.

Tom

I haven’t heard from you so I’m marking this as resolved. Let me know if you have any more questions as I’m more than happy to help.

Hey Wayne,

Has this stopped you from being able to use the plugin? If so, I’d like to look at how I can update the plugin to work for your installation.

Let me know how you’re getting on.

Tom

Hey Santosh,

Just checking to see if you still need support. If you do there are some thing you can do to help me check things out for you.

As always I recommend you take a databse and code backup before continuing with these steps, but to help me help you, can you please do the following.

– Download the Health Check plugin.
– Go to the admin area
– Click on Dashboard (near the top left)
– Click the “Debug Information” tab
– Click “Show copy and paste field in English”
– Copy and paste the details here so I can have a look at your setup

Once that is done it’d be nice to see if the plugin is clashing with other plugins you have installed.

This same plugin has a “Troubleshooting” tab. Try clicking that and work your way through there, activating one plugin at a time till you see the issue.

Lastly, we could look at any browser errors you’re getting. You can open the developer tools in your browser, go to the “Console” tab and refresh your page. I’d be interested to see if you got any error outputted.

Let me know if you need any further help with any of these steps.

Thanks,

Tom

Hey Sandrope,

I’ve just checked and it appears to be working on a fresh installation of 4.7.9 for me.

As always I recommend you take a DB and code backup before continuing with these steps, but to help me help you, can you please do the following.

– Download the Health Check plugin.
– Go to the admin area
– Click on Dashboard (near the top left)
– Click the “Debug Information” tab
– Click “Show copy and paste field in English”
– Copy and paste the details here so I can have a look at your setup

Once that is done it’d be nice to see if the plugin is clashing with other plugins you have installed.

This same plugin has a “Troubleshooting” tab. Try clicking that and work your way through there, activating one plugin at a time till you see the issue.

Lastly, we could look at any browser errors you’re getting. You can open the developer tools in your browser, go to the “Console” tab and refresh your page. I’d be interested to see if you got any error outputted.

Let me know if you need any further help with any of these steps.

Thanks,

Tom

I’ll have a look into this today to see if I can replicate or add more error logging to help me diagnose the issue.

Hey Santosh,

I completely understand what Jan is saying so I’m going to spend some time tomorrow adding in some additional error logging to help me diagnose your problem. Will get back to you in here once I’ve made an updated version of the plugin with the extra error logs and will instruct you on the info I need then.

Thanks for your patience and apologies for not being more aware of the www.ads-software.com rules. I should have thought to read up on this stuff.

Will get back to you soon.

Tom

Hey Santosh,

I’ve just tried to be hacky to test this out live on the site by changing the test code in the wp-admin area. Unfortunately I’m getting the error when I try to save the code:

“Unable to communicate back with site to check for fatal errors, so the PHP change was reverted. You will need to upload your PHP file change by some other means, such as by using SFTP.”

Can I have a copy of your DB and codebase so that I can test locally?

Alternatively, to test if your theory is correct here is the code blocks that need changing so that the query is using mysqli.

In the the plugin root, go to the login directory and open dp.php. There are two blocks that need changing.
— 1) Changing from this:

    $data = array(
        "db_instance" => new wpdb(
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name"),
            exlog_get_option("external_login_option_db_host")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 1) to this:

    $data = array(
        "db_instance" => new mysqli(
            exlog_get_option("external_login_option_db_host"),
            exlog_get_option("external_login_option_db_username"),
            exlog_get_option("external_login_option_db_password"),
            exlog_get_option("external_login_option_db_name")
        ),
        "dbstructure_table" => exlog_get_option('exlog_dbstructure_table'),
        "dbstructure_username" => exlog_get_option('exlog_dbstructure_username'),
        "dbstructure_password" => exlog_get_option('exlog_dbstructure_password'),
        "dbstructure_first_name" => exlog_get_option('exlog_dbstructure_first_name'),
        "dbstructure_last_name" => exlog_get_option('exlog_dbstructure_last_name'),
        "dbstructure_role" => exlog_get_option('exlog_dbstructure_role'),
        "dbstructure_email" => exlog_get_option('exlog_dbstructure_email'),
    );

— 2) From this:

    $users = array();
    if (sizeof($rows) > 0) {
        foreach ($rows as $user_data) {
            array_push($users, exlog_build_wp_user_data($db_data, $user_data));
        };
        return $users;
    }

— 2) To this:

    $rows = $db_data["db_instance"]->query($query_string);

    $users = array();
    while ($user = $rows->fetch_assoc()) {
        array_push($users, $user);
    }
    return $users;

Thanks,

Tom

Small update. I’ve modified one file in the plugin to use the mysqli db connection for the “test” button in the settings page.

Before rolling this out, I would like confirmation that this was the issue.

I can either give you some code snippets to replace in the plugin, to help test it on your site, or if you can give me a copy of your database I can test it my end.

Let me know if you are able to do either of these.

Thanks,

Tom

Hey @kumarsmishra,

I’m more than happy to look into this for you. I’m just reading up on this now.

I presume you don’t have an example database that I can demo this with?

Thanks,

Tom

Hey @dereckmartin,

I haven’t heard back so I’m assuming this is resolved. Let me know if this is not the case so I can continue to support you.

Thanks,

Tom

Hi again dereckmartin,

I’ve added the functionality that you require. Could you please test it your end and let me know if it is working for you.

I’ve updated the main plugin page with an additional FAQ entry to help users find the correct algorithm option with the use of example hashes.

The setting you’ll need for the Hash Type is phpcrypt. You can set this by adding the following line to your wp-config.php file:
define('EXTERNAL_LOGIN_OPTION_HASH_ALGORITHM', 'phpcrypt');

If you find this is not working please get back to me and let me know and I’ll continue to work with you.

You also mentioned that you don’t use roles. I don’t think this will stop your use of the plugin. If you set the ‘Unspecified Role’ setting to the role you want all your users to come across as that will do the job. If this is not working for you let me know what specifically is the issue and I’ll rectify it for you.

If it does all work, a positive review would be much appreciated ??

Thanks,

Tom

Hey dereckmartin,

Sorry, I’ve only just seen this. I don’t seem to be getting notifications for this support.

If you’re still interested in using the plugin I’ll look at adding this functionality today.

I might get back to you at some point so you can test the functionality.

Thanks,

Tom