preferences with postgres

[Paul Bauer]

I have been trying to save my user preferences using a Postgresql database.
I have had a problem authenticating when I activate it.

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

/* Any parameters that the preferences driver needs. This includes
 * database or ldap server, username/password to connect with, etc.
 */
$conf['prefs']['params'] = array();

/* This is an example configuration for a MySQL preference backend.
 * Be sure to set the prefs driver to 'sql' above if you use this
 * configuration.
 */
$conf['prefs']['params']['phptype'] = 'pgsql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';
 
I am using imap for authentication to the system.  MAybe this is where I am
going wrong?
 
// What backend should we use for authenticating users to Horde? Valid
// options are currently 'imap', 'ldap', 'mcal', 'sql', and 'ftp'.
$conf['auth']['driver'] = 'imap';

$conf['auth']['params']['dsn'] = '{localhost/imap:143}INBOX';
 
If i change:
$conf['prefs']['driver'] = 'sql';
 
to 
$conf['prefs']['driver'] = 'none';  in the preferences section, I can login
fine.
 
Here is what the database looks like:
horde=# \dt
              List of relations
            Name             | Type  | Owner  
-----------------------------+-------+--------
 active_sessions             | table | pgsql
 clients                     | table | pgsql
 filters                     | table | pgsql
 horde_categories            | table | pgsql
 horde_categories_categories | table | pgsql
 horde_prefs                 | table | pgsql
 horde_users                 | table | pgsql
 network_mappings            | table | pgsql
 turba_objects               | table | pbauer
 users                       | table | pgsql
 version                     | table | pgsql
(15 rows)

horde=# 

I get the following error:
pq_recvbuf: unexpected EOF on client connection when switched to driver sql.
 
I used the scripts/db/files to create the tables and the auth tables.

Any pointer would be greaatly appreciated.
 


>From boiboi@stberlin.com Date: Tue,  5 Feb 2002 14:03:52 +0800
Return-Path: <boiboi@stberlin.com>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 83237 invoked from network); 5 Feb 2002 06:00:27 -0000
Received: from unknown (HELO stberlin.com) (216.12.219.9)
  by clark.horde.org with SMTP; 5 Feb 2002 06:00:27 -0000
Received: (qmail 1818 invoked by uid 0); 5 Feb 2002 06:03:52 -0000
Received: from 216.101.190.3 ( [216.101.190.3])
	as user boiboi@localhost by www.stberlin.com with HTTP;
	Tue,  5 Feb 2002 14:03:52 +0800
Message-ID: <1012889032.3c5f75c8c5993@www.stberlin.com>
Date: Tue,  5 Feb 2002 14:03:52 +0800
From: boiboi alavaren <boiboi@stberlin.com>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.1-cvs
X-Originating-IP: 216.101.190.3
Subject: login page from CVS missing in Netscape 4

login page from CVS missing in Netscape 4. 



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