Authentication without password on Moodle

Question

Actually I am trying to integrate my system with moodle. I need a functionality that supposed to work like that:

Login into my system (same username as in moodle db)
User decide to switch to moodle, so his clicking a link to script (on moodle server - both systems are on other servers), and I getting all data from database about user that I want to log in (whole row from database) ...
Because password is encrypted, I can't redirect now to login form with post params, because it won't work.

Is there any good and easy way to achieve this goal? I have username and hashed and eventually hashed password.

I am using moodle 1.9 (system requirments).

Thanks in advance for any help,

Regards David

score 1 · Answer 1 · edited May 30 '11 at 19:39

1

Some things to look at for SSO and Moodle 1.9:

If you are ready to spend quite some hours you could use Mnet: http://docs.moodle.org/en/MNet
There is also a phpcas authentication method that could do what you want: http://docs.moodle.org/en/CAS_server_(SSO)

edited May 30 '11 at 19:39

Devin Burke

13,642
12
55
82

answered May 30 '11 at 09:57

Jerome Mouneyrac

363
2
10

score 0 · Answer 2 · edited Apr 16 '13 at 05:58

Here is what I did

1 - I enabled the (External database) Authentication Plugin

2 - Create this php file in folder (my/moodle/root/login/)

    <?php
    require('../config.php');
    $username =  $_GET['id'];// 's3265';
    $serverName = 'moodle' ;
    $connectionInfo = array( "UID"=>"mssqlUser","PWD"=>"********","Database"=>"external_Database");
//I am using MSSQL2008
        echo '<form action="' . $CFG->wwwroot . 
             '/login/index.php" method="post" name="login" id="form">';

    $conn = sqlsrv_connect( $serverName, $connectionInfo );

    if (!$conn)
       {die('Could not connect: ' . sqlsrv_error());}
    $result = sqlsrv_query($conn , "SELECT * FROM Users WHERE LoginID = '" . $username . "'");

    var_dump($conn, $result);
    while($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
    {
            echo  $row['FName'] . " " . $row['LName'] . ", please wait. . .";
        $password =  $row['LoginPassword'];
    }
    sqlsrv_close($conn);
?>
        <p><input type="hidden" 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>

3 - assume you named the rhr file (test.php) now your link should look like (http://your_domain/moodle/login/test.php?id=yourusername) for me it is working , but . . . I am not concerned about security . . . if you do . . . you have to add something to this

Authentication without password on Moodle

2 Answers2