[imp] [using imp/horde with postgresql - trying to use unix domain sockets (fwd)]

[Jon Parise]

----- Forwarded message from Paul Traina <pst@juniper.net> -----

Folks,

I am trying to run apache2/imp/horde/postgres on a single machine, all
latest release versions.

I can get everything up and running if I allow postgres to bind and listen
on a TCP socket (using the -i option to postgres when I start it).  However,
I do not want postgres to listen on a tcp socket, since everything is local
to the machine anyway, pipe's are more efficient and more secure.

I'm a DB::pgsql newbie and the PQconnect function in PHP is damn near
unreadable to my uneducated eyes.

What configuration should I put in my horde config to configure it for local
access to postgres?  Here is what I am using now...

$conf['prefs']['params']['phptype'] = 'pgsql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['port'] = '5432';
$conf['prefs']['params']['password'] = '************';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

I tried seting hostspec to unix+/tmp/s.PGSQL.5432 and that didn't seem to
help.

Thanks in advance,

Paul


----- End forwarded message -----

-- 
Jon Parise (jon@horde.org) :: The Horde Project (http://horde.org/)