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

[Joseph M. Day]

Hi Eric,

That worked like a champ. I did not have the protocol parameter set to unix.

Thanks,

Joe,


Eric Rostetter wrote:
> 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,
> 
>