[imp] IMP 2.3.7, prefs, and Postgresql 7.0.3

Jon Parise jon@csh.rit.edu
Fri, 13 Apr 2001 13:45:36 -0400


On Fri, Apr 13, 2001 at 11:37:28AM -0600, FreeBSD wrote:

> I just recently installed IMP 2.3.7 from cvs (as of last night), and have
> not been able to get prefs to save to postgresql. I have created the horde
> table and the horde_prefs table in it. I created both hordemgr and www
> users as well as giving both all privs with psql. In my
> horde/imp/config/conf.php I have:
> 
> $conf['prefs']['driver'] = 'sql';
> $conf['prefs']['params'] = array();
> $conf['prefs']['params']['phptype'] = 'pgsql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['username'] = 'www';
> $conf['prefs']['params']['password'] = 'hordepass';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
> 
> I have tried 'www' as username, 'hordemgr' as username, neither worked. I
> tried rebuilding the database, I tried reinstalling IMP from cvs, nothing
> has worked. Postgresql is running and listing on the default 5432 tcp
> port. It seems everything else works (send mail etc) but for prefs.
 
Those settings look just fine to me.  My only thought is that there's
some sort of permissions problem.  I'm afraid you'll have to
investigate further.

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member