[horde] Mysql - Horde -Imp - cvs - Logging in

[Chuck Hagenbuch]

Quoting Eric Ekong <eric at unixtechs.org>:

> I am attaching it to this email.

Okay. Where you have this:

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


... you need something that looks like the preferences driver. The above line 
essentially says "use no Authentication backend". The Auth:: system defaults to 
a lightweight Auth class which - given nothing to authenticate anyone against - 
simply fails every login attempt.

Judging by your preferences configuration (which looks fine), you should have 
something like this:

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

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

Make sure you have the horde_auth table; the schema for it is:

  create table horde_auth (
      user_id         varchar(32) not null,
      user_pass       varchar(32) not null,
      primary key (user_id)
  );

(this is in the comments at the top of horde/lib/Auth/sql.php)

Also, you might want to make sure that you have the latest Horde, and to re-do 
your configuration files using the .dist files as a starting point; connection 
tracking is deprecated, though the rest of your horde.php looks fairly up-to-
date.

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
Some fallen angels have their good reasons.