I am trying to create a website that the main purpose is to authenticate users on the LAN with the freeradius server. So basically what I want is that when a user logs in it checks the drupal database for usename and password and if it is there and correct it will then check the freeradius database and if both are correct it will allow access if one is wrong it will deny access. If I could get the two databases synchronized that would be great. I have set up in the sites/default/settings.php $db_url as an array
$db_url['default'] = 'mysqli://username:password@localhost/database';
$db_url['second_db'] = 'mysqli://username:password@localhost/database';
To do this I would need to create a module and hook into the registration process to add/synchronize the username/password information and I would need to do the same for when the user changes/edits there information as well as if the administrator added the user to a role or changed there password or updated it, would I not? I know there is a couple of modules already but are based on coovachilli and LDAP and I am using freeradius with mysql. If anyone has any suggestions on this it would be greatly appreciated.