[imp] IMP 2.3.7, prefs, and Postgresql 7.0.3

[freebsd@XtremeDev.com]

Thanks for the reply all. I've got it working now, and it was an error in 
creating the tables that was the problem (-d 10 to postmaster, mucho mucho 
debug messages). I'd like to share my steps for those who are interested in how 
I got IMP-2.3.7 to install on FreeBSD 4.3-RC:

1. I grabbed the latest php4 from cvs.php.net and installed it
2. I grabbed the latest imp from cvs.horde.org and installed it into my apache 
document root.
3. I installed postgresql 7.0.3 from FreeBSD ports (without ssl support, it has 
issues which I wasn't able to solve).
4. As root, I su'd to pgsql (user installed by the postgresql port), and 
ran /usr/local/pgsql/bin/createuser myacct, where myacct is my regular login 
system account that I manage postgresql with.
5. Then as myacct, I did: /usr/local/pgsql/bin/psql template1 
< /usr/local/apache/horde/scripts/db/pgsql_create.sql
6. Next: /usr/local/pgsql/bin/psql horde
7. horde=# \i prefs.sql
8. horde=# \i auth.sql
9. horde=# CREATE USER www PASSWORD 'hordepass' CREATEDB NOCREATEUSER;
10. horde=# GRANT all ON horde_prefs TO www;
11. horde=# GRANT all ON auth TO www;
12. After adding the prefs lines (below) to imp/conf.php, it's now saving my 
preferences.

P.S. I made a shar for the cvs php4 to install PEAR. You can find it attached. 
All 
it is is a modified mod_php4 port.

P.P.S. Where I erred was in following the horde/scripts/db/README almost to the 
letter. psql template1 < prefs.sql created the horde_prefs table in the 
template1 database instead of the horde database.

P.P.P.S. Hmm. And it seems attachments doesn't work.. Sigh. On to the next 
problem...



Quoting Nuno Silva <nuno_silva@websolut.net>:

> 
> 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.
> 
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
> 
>