[horde] php-pgsql grief

[Eric Rostetter]

Quoting "Dr. Michael J. Chudobiak" <mjc at avtechpulse.com>:

> I am having problems getting Horde to access a Postgresql database. I am

What did you do?  Did you create the database tables? Can you connect to
the database with psql?  Can you connect to the database remotely?  Is
it running on unix sockets or via tcp?

> $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';

Try adding a 'protocol' to specify socket type (unix or tcp) and then
specify the

> 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

Did you check your system logs?

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

What kind of other connections?  tcp or unix sockets?

--
Eric Rostetter
The Department of Physics
The University of Texas at Austin

Why get even? Get odd!