Authentication with SQL...

[Curtis, Darren S]

Hello,

I have set up horde to be an application framework for
our internal software. I removed all the other horde
applications and I am trying to get logins to work
using MySQL as the user authentication. Anyway, I am
not having much luck. The horde code is pretty well
documented. I modified the login.php code and I am
finding that Auth::getAuth() is not working. I have
the following in my config/horde.php:

-------------------------------------------------------------------------
/**
 ** Horde Authentication
 **/

// What backend should we use for authenticating users to Horde? Valid
// options are currently 'imap', 'ldap', 'mcal', 'sql', and 'ftp'.
$conf['auth']['driver'] = 'sql';

// An array holding any parameters that the Auth object will need to
// function correctly. For IMAP, this is the server name, port,
// protocol, etc.
$conf['auth']['params'] = array();
$conf['auth']['params']['phptype']  = 'mysql';
$conf['auth']['params']['hostspec'] = 'localhost';
$conf['auth']['params']['username'] = 'hordemgr';
$conf['auth']['params']['password'] = '_changed_'; # Hidden from email :-)
$conf['auth']['params']['database'] = 'horde';
$conf['auth']['params']['table']    = 'horde_prefs';

/**
 ** Preference System Settings
 **/

// What preferences driver should we use? Valid values are 'none'
// (meaning use system defaults and don't save any user preferences),
// 'session' (preferences only persist during the login), 'ldap', 
// and 'sql'.
// $conf['prefs']['driver'] = 'none';

// Any parameters that the preferences driver needs. This includes
// database or ldap server, username/password to connect with, etc.
$conf['prefs']['params'] = array();
$conf['prefs']['driver']             = 'sql';
$conf['prefs']['params']             = array();
$conf['prefs']['params']['phptype']  = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['password'] = '_changed_';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table']    = 'horde_prefs';


/**
 ** Connection Tracking
 **/
$conf['connections']['track']              = true;
$conf['connections']['driver']             = 'sql';
$conf['connections']['params']             = array();
$conf['connections']['params']['phptype']  = 'mysql';
$conf['connections']['params']['hostspec'] = 'localhost';
$conf['connections']['params']['username'] = 'hordemgr';
$conf['connections']['params']['password'] = '_changed_';
$conf['connections']['params']['database'] = 'horde';
$conf['connections']['params']['table']    = 'connections';

/**
 ** Problem Reporting
 **/

// Should we display a problem reporting link in Horde application
// menus?
$conf['problems']['enabled'] = true;

// If so, where should problem report emails be sent?
$conf['problems']['email'] = 'postmaster at arm.gov';
-------------------------------------------------------------------------

The only two uncommented lines I have in config/registry.php are:

$this->registry['auth']['login'] = 'sql';
$this->registry['auth']['logout'] = 'sql';


Am I missing something? Has anyone else succeeded using MySQL as
the driver for Authentication?

Any help would be greatly appreciated and thanks in advance,

Darren Curtis
http://www.arm.gov
http://playground.arm.gov
(509) 375-2152