2.3.7-cvs: pgsql.php error
Claus Heiko Niesen
cniesen@gmx.net
Tue, 12 Jun 2001 08:45:45 -0500
I'm trying to install IMP with postgresql support but since I added the
configuration I get the following error:
Warning: Undefined index: protocol in /usr/local/lib/php/DB/pgsql.php on
line 95
The weird part is that the preferences are actually stored and I can
continue using IMP by reloading the page.
I have the following lines in horde/config/horde.php:
$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'pgsql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = 'secret';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';
and the table layout is as follows:
horde=# \d horde_prefs
Table "horde_prefs"
Attribute | Type | Modifier
------------+---------------+---------------------
uid | character(32) | not null
scope | character(16) | not null default ''
pref_name | character(32) | not null
pref_value | text |
Index: horde_prefs_pkey
horde=# \d horde_prefs_pkey
Index "horde_prefs_pkey"
Attribute | Type
-----------+---------------
uid | character(32)
scope | character(16)
pref_name | character(32)
unique btree (primary key)
I did the test with doing a "su" to the webserver uid and accessing the
database by doing
"psql -h localhost -U www -W horde". Everything works fine, select,
insert, update, and delete. I haven't found anything interesting in the
logs of apache or postgresql. Does anybody have an idea of what I
configured wrong?
Claus