[horde] Re: AW: Required 'phptype' not specified in preferences configuration

[Eric Rostetter]

Quoting "Joseph M. Day" <jday at gisolutions.us>:

> I am also having a heck of a time getting this working with pgsql. I
> know I have my database configured because I can can use the php
> function pg_connect("dbname=horde user=horde"); and it connects just fine. 
> I've logged into the horde db I created using psql and I can query all
> the tables I created.

That's a good start. :)

> No matter what I still get the "DB Error: connect failed"
> [line 108 of /var/www/.../Prefs/sql.php]

Bummer.
 
> I have the follwing for my settings:
> 
> $conf['prefs']['driver'] = 'sql';
> $conf['prefs']['params'] = array();
> $conf['prefs']['params']['phptype'] = 'pgsql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['username'] = 'horde';
> $conf['prefs']['params']['password'] = '*****';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';

Try adding a protocol type, either unix (local unix socket) or
tcp (tcp/ip connection).  Something like:

$conf['pefs']['params']['protocol'] = 'unix';

If using standard port/socket then that is all that is needed, otherwise
if you have a non-standard port/socket then you will need to specify
that also.  But I'm pretty sure you have standard settings or your other
php test wouldn't work.

> I have the following set for my security for pqsql: localhost trust
> 
> Obviously I replaced the password with the actual password. This seems
> like it should be the easiest part of the setup but I am shooting blanks.

Do you know if it is using unix sockets or tcp?  Some versions of pgsql
ship with only sockets, yet I think Hord/PEAR defaults to tcp, so that
is likely the problem.  Try adding the unix protocol setting...

> Any help that any of you can provide would be immensely appreciated.

Need to know more about your setup to help more, really.  I'm not a pgsql
expert, but it is the database I use...

> Thanks,
> 
> Joe,

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

Why get even? Get odd!