[horde] php-pgsql grief

Dr. Michael J. Chudobiak mjc at avtechpulse.com
Thu Nov 13 06:36:42 PST 2003


Hi,

I am having problems getting Horde to access a Postgresql database. I am 
using Fedora Core 1 (basically Redhat 10), with the php, php-ldap, 
php-imap, and php-pgsql rpms.

The test.php page says that I have pgsql support installed.

In horde.php, I have:

$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params']['phptype'] = 'pgsql';
$conf['prefs']['params']['hostspec'] = '127.0.0.1';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '(deleted for the posting)';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

and

$conf['log']['enabled'] = true;
$conf['log']['type'] = 'file';
$conf['log']['name'] = '/tmp/horde.log';
$conf['log']['priority'] = LOG_DEBUG;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();


However, after I log in (using LDAP) I get:

A fatal error has occurred:
DB Error: connect failed
[line 108 of /var/www/html/horde/lib/Prefs/sql.php]
Details have been logged for the administrator.


Despite the claim above, nothing useful is logged by Horde. The 
Postgresql logs do not show any connection attempts to the Horde 
database. It is correctly logging other connections, so I've concluded 
that the php-pgsql module isn't working correctly.

How can I debug this problem? Has anyone seen anything similar?

I did have this set-up working previously, by compiling php and 
postgresql from source code, but I wanted to re-install it from RPMs to 
ease the maintenance burden.

Any suggestions appreciated!


- Mike



More information about the horde mailing list