Implements interfaces:

• AuthenticationUserInfoProvider
• AuthenticationPasswordBackend

Authentication backend for SQL-based RDBMSs

Requires a tabled named "users" having the fields "uid" (usigned int), "password" (string), "uname" (string) in the default (config: "rdbms.default") or authentication database (config: "auth.rdbms.db"). Usernames as well as UIDs have be uniqe. You may use this piece of SQL to create a table like this:

     --
    -- Tablestructure of 'users' table
    --
 
    CREATE TABLE `users` (
      `uid` int(10) unsigned NOT NULL auto_increment,
      `uname` varchar(100) NOT NULL,
      `password` varchar(255) NOT NULL COMMENT 'hashed password',
      PRIMARY KEY  (`uid`),
      UNIQUE KEY `uname` (`uname`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

Passwords are stored hashed by the Hash module.

Located in /phpsatk-lib/global/org.eenterphace.sat.auth.backend.rdbms/authentication.backend.rdbms.php (line 54)