[imp] IMP 2.3.7, prefs, and Postgresql 7.0.3

[Nuno Silva]

Hi,

if I was trying to debug this I would "su" to the webserver uid, then 
try psql like this:

psql -h localhost -U www -W horde

this should prompt you with a password.
after loggin in, try to insert something in those tables.

If any of this fails it's a user/permition problem in your postgresql 
setup ;)

regards,
Nuno Silva

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.
> 
> test.php returns:
> 
> Horde: System Capabilities TestHorde Versions
>         Horde: 1.3.4-cvs
>         IMP: 2.3.7-cvs
>         Turba: 0.0.2-cvs
>       PHP Version
>         View phpinfo() screen
>         PHP Version: 4.0.6-dev
>         PHP Major Version: 4.0
>         PHP Minor Version: 6
>         PHP Version Classification: dev
>         You are running a supported version of PHP. Enjoy the ride!
>       PHP Module Capabilities
>         FTP Support: Yes
>         Gettext Support: Yes
>         IMAP Support: Yes
>         LDAP Support: No
>         MCAL Support: No
>         Mcrypt Support: Yes
>         MySQL Support: No
>         PostgreSQL Support: Yes
>         XML Support: Yes
>       Miscellaneous PHP Settings
>         magic_quotes_gpc set to Off: Yes
>         magic_quotes_runtime set to Off: Yes
>       PHP Sessions
>         Session counter: 1
>         To unregister the session: click here
>       PEAR
>         PEAR - Yes
>         Mail::RFC822 - Yes
>         Log - Yes
>         DB - Yes
> 
> Please, does anyone have any ideas? Thanks in advance.