MySQL auth and horde 1.3.5

Sat Sep 1 20:11:16 PDT 2001

After trying mpasswd auth and not getting anywhere, I decided to poke
at MySQL, since I have an already functional MySQL DB. After time
spent putting little echos through the files:

      /horde/lib/Auth.php
      /horde/lib/Auth/sql.php
      /horde/config/horde.php
      /horde/login.php

I figured out the params I need to at least get to the PHP/PEAR DB.php
and DB/mysql.php. However, where it's dying is in DB.php. It seems to
not be able to get a persistant connection to the DB, if I'm reading
the errors. I've gone through mysql and can connect to the db with
hordemgr (the user I'm trying for the auth part), I can see the
correct permissions for DB horde for hordemgr in the db table and I
even added a couple of users by hand with md5 encrypted passwds into
the horde user table. No dice.

What files do folks (like Chuck B^) need to see to help me debug?

Current config/horde.php has:

  $conf['auth']['driver'] = 'sql';

  $conf['auth']['params'] = array(
        'phptype'       => 'mysql',
        'hostspec'      => 'localhost',
        'protocol'      => 'unix',
        'username'      => 'hordemgr',
        'password'      => 'XXXXXXXX',
        'database'      => 'horde',
        'table'         => 'horde_users'
  );

MySQL has:

  mysql> connect horde;
  mysql> select * from horde_users;
  +----------+----------------------------------+
  | user_id  | user_pass                        |
  +----------+----------------------------------+
  | test     | 5185e8b8fd8a71fc80545e144f91faf2 |
  | hordemgr | fe132c3694b53c76347166993c4774e5 |
  +----------+----------------------------------+

  mysql> describe horde_users;
  +-----------+-------------+------+-----+---------+-------+
  | Field     | Type        | Null | Key | Default | Extra |
  +-----------+-------------+------+-----+---------+-------+
  | user_id   | varchar(32) |      | PRI |         |       |
  | user_pass | varchar(32) |      |     |         |       |
  +-----------+-------------+------+-----+---------+-------+

>From chuck at horde.org Date: Sat,  1 Sep 2001 23:39:55 -0400
Return-Path: <chuck at horde.org>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 96010 invoked from network); 2 Sep 2001 03:41:59 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by horde.org with SMTP; 2 Sep 2001 03:41:59 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id E52AF3D9F; Sat,  1 Sep 2001 23:39:55 -0400 (EDT)
Received: from 192.168.0.117 ( [192.168.0.117])
	as user chuck at localhost by marina.horde.org with HTTP;
	Sat,  1 Sep 2001 23:39:55 -0400
Message-ID: <999401995.3b91aa0bc3cf4 at marina.horde.org>
Date: Sat,  1 Sep 2001 23:39:55 -0400
From: Chuck Hagenbuch <chuck at horde.org>
To: horde at lists.horde.org
References: <999207411.3b8eb1f3eccb6 at webmail.birddog.com> <999279687.3b8fcc47d59f7 at marina.horde.org> <999286506.3b8fe6ea6dcb3 at secure.birddog.com> <999286628.3b8fe76496575 at marina.horde.org> <999289053.3b8ff0dd228e1 at secure.birddog.com> <999289738.3b8ff38a1460e at marina.horde.org> <999290089.3b8ff4e9afe81 at secure.birddog.com> <999295038.3b90083eeedb8 at marina.horde.org> <999325352.3b907ea8f01ec at secure.birddog.com> <999359361.3b91038185968 at marina.horde.org> <999396877.3b91960d68932 at secure.birddog.com>
In-Reply-To: <999396877.3b91960d68932 at secure.birddog.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [horde] error on horde/kronolith

Quoting Terry Davis <tdavis at birddog.com>:

> I am thinking we should drop this "bug/error" I was seeing as user error on my
> part.  I cannot seem to duplicate it at this point and everything is working
> fine.  I appreciate your help and patience.

Okay - thanks for letting me know it's working.

-chuck

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

>From chuck at horde.org Date: Sat,  1 Sep 2001 23:42:57 -0400
Return-Path: <chuck at horde.org>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 96522 invoked from network); 2 Sep 2001 03:45:01 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by horde.org with SMTP; 2 Sep 2001 03:45:01 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 9BC663D9F; Sat,  1 Sep 2001 23:42:57 -0400 (EDT)
Received: from 192.168.0.117 ( [192.168.0.117])
	as user chuck at localhost by marina.horde.org with HTTP;
	Sat,  1 Sep 2001 23:42:57 -0400
Message-ID: <999402177.3b91aac17c1c8 at marina.horde.org>
Date: Sat,  1 Sep 2001 23:42:57 -0400
From: Chuck Hagenbuch <chuck at horde.org>
To: horde at lists.horde.org
References: <999397487.3b91986f4a1e3 at secure.birddog.com>
In-Reply-To: <999397487.3b91986f4a1e3 at secure.birddog.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [horde] global authentication between modules (imp/horde)

Quoting Terry Davis <tdavis at birddog.com>:

> I have horde setup to do its authentication to my imap server.  When that user
> logs into horde, why should they have to login to imp which uses the same
> authentication?  Is there a way to tie these to authentication functions
> together? like if horde's auth is set to imap, then imp uses that information?

Yup. You can change your auth driver to IMP; it's done in config/registry.php. 
See the list archives for more details.

-chuck

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

>From tdavis at birddog.com Date: Sat,  1 Sep 2001 23:07:18 -0500
Return-Path: <tdavis at birddog.com>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 97481 invoked from network); 2 Sep 2001 04:08:05 -0000
Received: from hermes.birddog.com (63.125.164.131)
  by horde.org with SMTP; 2 Sep 2001 04:08:05 -0000
Received: from localhost (prometheus.birddog.com [10.2.0.4])
	by hermes.birddog.com (8.11.6/8.11.6) with ESMTP id f8248Si01411
	for <horde at lists.horde.org>; Sat, 1 Sep 2001 23:08:28 -0500
Received: from 216.170.58.10 ( [216.170.58.10])
	as user td at imap.birddog.com by secure.birddog.com with HTTP;
	Sat,  1 Sep 2001 23:07:18 -0500
Message-ID: <999403638.3b91b07645eee at secure.birddog.com>
Date: Sat,  1 Sep 2001 23:07:18 -0500
From: Terry Davis <tdavis at birddog.com>
To: horde at lists.horde.org
References: <999397487.3b91986f4a1e3 at secure.birddog.com> <999402177.3b91aac17c1c8 at marina.horde.org>
In-Reply-To: <999402177.3b91aac17c1c8 at marina.horde.org>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Originating-IP: 216.170.58.10
X-Scanned-By: MIMEDefang 1.3 (www dot roaringpenguin dot com slash mimedefang)
Subject: Re: [horde] global authentication between modules (imp/horde)

awesome. thank you.
-- 
Terry Davis
Systems Administrator
BirdDog Solutions, Inc.
(402) 829-6059

Quoting Chuck Hagenbuch <chuck at horde.org>:

> Quoting Terry Davis <tdavis at birddog.com>:
> 
> > I have horde setup to do its authentication to my imap server.  When that
> user
> > logs into horde, why should they have to login to imp which uses the same
> > authentication?  Is there a way to tie these to authentication functions
> > together? like if horde's auth is set to imap, then imp uses that
> information?
> 
> Yup. You can change your auth driver to IMP; it's done in
> config/registry.php. 
> See the list archives for more details.
> 
> -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
> 

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

>From chuck at horde.org Date: Sun,  2 Sep 2001 14:04:01 -0400
Return-Path: <chuck at horde.org>
Mailing-List: contact horde-help at lists.horde.org; run by ezmlm
Delivered-To: mailing list horde at lists.horde.org
Received: (qmail 12006 invoked from network); 2 Sep 2001 18:06:11 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by horde.org with SMTP; 2 Sep 2001 18:06:11 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id AE1A43D9F; Sun,  2 Sep 2001 14:04:01 -0400 (EDT)
Received: from 192.168.0.118 ( [192.168.0.118])
	as user chuck at localhost by marina.horde.org with HTTP;
	Sun,  2 Sep 2001 14:04:01 -0400
Message-ID: <999453841.3b9274918e70e at marina.horde.org>
Date: Sun,  2 Sep 2001 14:04:01 -0400
From: Chuck Hagenbuch <chuck at horde.org>
To: horde at lists.horde.org
References: <200109012331.f81NVqL17080 at ns1.pae.com>
In-Reply-To: <200109012331.f81NVqL17080 at ns1.pae.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [horde] horde login.php and Kronolith/Turba? 

Quoting list-horde at dragon.net:

> Well, I punted at the moment with auth mcal and went with auth imap,
> since imap is working. I would like to figure out why mcal/mpasswd
> didn't work though, if anyone has leads.

Does Kronolith work for you, now that you're using imap for Horde auth?

-chuck

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