[horde] php-pgsql grief

[David Pieper]

Dr. Michael J. Chudobiak wrote:

> 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
> 

Is your postgres listening on TCP?

What does your pg_hba.conf file look like.

Enjoy,
Davod Pieper

-- 
programmer n. /pro gram er/ A device for transmuting caffeine into code.