External login , in case internal login fail

Question

I have a website which needs to authenticate users using drupal users table.

If authentication fails, then I want to run the authentication against users table from another database.

lf authentication is successful , then I want to register this user inside drupal, so the next this user next time he logs in , he get authenticated from drupal users table , not the external users table.

I wish to get a complete solution for that.

the following code is my attempt :

function external_auth_form_user_login_alter(&$form,$form_state){

$form['#validate'] = array( 'user_login_name_validate' );
user_login_authenticate_validate( $form, $form_state );
if(!empty($form_state['uid'])){

db_set_active('barakah');
$result=db_query('select username,password from users where username= :name   and password= :pass',array(':name' =>$form_state['input']['name'],':pass'=>$form_state['input']['pass']));
db_set_active('default');
if(!empty($result)){
$username = $form_state['input']['name'];
user_external_login_register($username, 'external_auth');

}




} 

}

but as if the code doesn't exist, nothing happens

Answer 1

You can use:

drupal_external_login_register

Helper function for authentication modules. Either logs in or registers the current user

An example implementation is detailed here:

https://api.drupal.org/comment/13434#comment-13434

Answer 2

Try something like this :

function custom_user_validate_login_validate(&$form,$form_state){
    $form['#validate'][] = 'custom_user_validate_login_validate';
}

function custom_user_validate_form_user_login_alter($form, &$form_state) {
    drupal_set_message("Custom Validation"); //Just to check if the hook_validate is called
    user_login_authenticate_validate( $form, $form_state );
    if(empty($form_state['uid'])){ // remove the ! here
        db_set_active('barakah');
        $result=db_query('select username,password from users where username= :name   and password= :pass',array(':name' =>$form_state['input']['name'],':pass'=>$form_state['input']['pass']));
        db_set_active('default');
        if(!empty($result)){
        $username = $form_state['input']['name'];
        user_external_login_register($username, 'external_auth');
        }
    }
}

[Edit] Need to remove ['submit'] from hook_form_alter

[Edit2] Renaming the function names: replace custom_user_validate by your module name

[Edit3] Updating the name of hook_validate to match function names