Implementing SSO with IIS Basic Authentication (No AD Or LDAP Available)

Implementing SSO with IIS Basic Authentication (No AD Or LDAP Available)

by Joao Raposo -
Number of replies: 2

Hi everybody!

I'm implementing moodle in a windows server 2008 r2 and I'm having some trouble activating a Single Sign On service.

I have all of my users registered in Local Users and Groups and no Active Directory or LDAP Available.

My users are signing in into other application (in the same server) using basic authentication of IIS7 with no problem. I want to moodle user the same users/login of that application.

I already configured the II7 to use basic authentication to moodle folder, but moodle when I log in to moodle, I'm being redirected to the login page because moodle don't recognize my previous login.

Is it possible to do this kind of implementation with moodle?

Thanks ;)

Average of ratings: -
In reply to Joao Raposo

Re: Implementing SSO with IIS Basic Authentication (No AD Or LDAP Available)

by Joao Raposo -

Hello all,

I discovered how to implement this question.

Activated external DB authentication plug-in
Configured the application to alternateloginurl -> autologin.php with the following code:

<?php
$username = stripslashes($_SERVER['REMOTE_USER']);
$password = '';
?>

<form action="https://XXXXX/login/index.php" method="post" name="login" id="form" style="display:none">

<p><input type="text" name="username" value="<?php echo $username ?>">

<p><input type="hidden" name="password" value="<?php echo $password ?>">

<script language="JavaScript">

function Validate()
{
document.login.submit();
}
Validate();
</script>
</form>';
?>


Thanks anyway

In reply to Joao Raposo

Re: Implementing SSO with IIS Basic Authentication (No AD Or LDAP Available)

by Mairsile Hourihane -

I think your solution might be a work-around for a problem I am having with cross-platform external DB authentication. 

A couple of questions ...

What setting did you use for the external DB password format? 

Is it used?

What was the structure of your external DB table/view?

I am trying to set up external DB authentication between a PHP/MySQL moodle and a site running on IIS/MySQL - the authentication is failing because of the encryption method on the IIS site.  A SSO solution would be ideal.