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

[Joseph M. Day]

Hi Eric,

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.

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

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

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.

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

Thanks,

Joe,



Eric Rostetter wrote:
> Quoting Udo Schubert <news4dadirtyluk at gmx.de>:
> 
> 
>>i'm not quit sure but it looks as if preferences can't be stored in
>>a pgsql db ...
> 
> 
> Yes, they can/may.
>  
> 
>>i can see only none,session,ldap and mysql as prefs-driver!
> 
> 
> Nope, pgsql is valid.  Set the 'driver' value to 'sql' and then set
> the 'phptype' to the real type, such 'pgsql' in this case.
>