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

[Frederic Trudeau]

well i just noticed this Chuck ... My Horde auth table is simply titled
'auth', cuz I used the script located in /horde/scripts/db/auth.sql to
create this specific table...

Now, its seems the table must be horde_auth. I also have problems using
horde auth system via SQL ... I already created horde_auth table, but
without any success =(

I would love to solve this issue asap, in order to use Turba system with
IMP.

As I said before, when I input my username + password on the main horde
page and press connect, I get redirected to the exact same page, without
any error message, and I must re-enter my password again ... (username
stays).

I get nothing much in the mysql logs .. IMP prefs is working fine, so I
dont think this is a mysql related problem.

Configs are fine ;

// 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['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['password'] = 'trD098!';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_auth';

HELP ! =(


Frederic Trudeau


[A]dvanced [S]upport [A]gent
Colocation/Customer Support Agent
CAM Internet -> http://www.cam.org

"My God ! It's full of stars"

On Mon, 20 Aug 2001, Chuck Hagenbuch wrote:

> 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.
>
> --
> Horde mailing list: http://horde.org/horde/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>