[imp] IMP and PostgreSQL

[Eric Rostetter]

Quoting Mike DiChiappari <mdichiappari@domanisoft.com>:

> I just got IMP 3.1 running on RedHat 8.0.  I am not sure how to set
> things up for PostgreSQL.  In particular, what should be placed into
> horde.php.  The following are present for MySQL:
> 
>    // use MySQL to store Horde Stuff
>    $conf['prefs']['driver'] = 'sql';
>    $conf['prefs']['params']['phptype'] = 'mysql';

Change 'mysql' to 'pgsql'

>    $conf['prefs']['params']['hostspec'] = 'localhost';

Add:
     $conf['prefs']['params']['protocol'] = 'unix';

or, make postgresql listen on tcp/ip which it doesn't by default for RH 8.0

>    $conf['prefs']['params']['username'] = 'horde';
>    $conf['prefs']['params']['password'] = '';

Might need a real password, might not, depending on your config.

>    $conf['prefs']['params']['database'] = 'horde';
>    $conf['prefs']['params']['table'] = 'horde_prefs';
> 
> I have created the tables in PostgrSQL and the db is running.  I'm
> just not sure what to set in the above config file.

Try the above.  If you use tcp/ip, then you may need to change postgresql,
tcp wrappers, firewall settings, etc.  But the default is to use unix sockets,
so if you just set the 'procotol' to 'unix' as shown above, it should work
and avoid wrappers/firewalls/etc.
 
> Thanks,
> Mike

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

Why get even? Get odd!