[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