[horde] DB permission problem

[Marcus Schopen]

I used the two scripts "pgsql_cuser.sh" and "pgsql_create.sql" in
"/usr/share/doc/horde/examples/database/".

There is a missing "DELETE" in the "pgsql_create.sql" script:

  GRANT SELECT, INSERT, DELETE, UPDATE ON active_sessions TO hordemgr;
  GRANT SELECT, INSERT, DELETE, UPDATE ON imp_pref, imp_addr TO hordemgr;

Marcus Schopen wrote:
> 
> Hi,
> 
> just installed horde & imp (IMP, Version 2.2.6 - debian packages)
> on my woody, database is postgresql (7.2.1-2), IMAP is cyrus.
> 
> I can log in, read and write mails. That part works fine. I'm happy!
> 
> Problem is, that horde can't write into table "imp_addr".
> 
> I get to follwing error:
> 
> Warning: PostgreSQL query failed: ERROR: imp_addr: Permission denied. in
> /usr/share/horde/imp/lib/db.pgsql on line 34
> 
> Writing my signature and fullname to table "imp_pref works" fine. That's strange!?
> 
> When logging out I get this error:
> 
> Warning: PostgreSQL query failed: ERROR: active_sessions: Permission denied. in
> /etc/horde/db_pgsql.inc on line 52
> Warning: Cannot add header information - headers already sent by (output started at
> /etc/horde/db_pgsql.inc:52)
> in /etc/horde/session.inc on line 150
> Warning: Cannot add header information - headers already sent by (output started at
> /etc/horde/db_pgsql.inc:52) in /usr/share/horde/imp/templates/doctype.inc on line 8
> 
> In table "active_sessions" I set "changed" to "varchar(32) not null", because "varchar(14)"
> didn't work.
> 
> For testing I set postgres' pg_hba.conf to:
> local        all                                           trust
> host         all         127.0.0.1     255.0.0.0           trust
> host         all         0.0.0.0       0.0.0.0             reject
> 
> The postgres tables:
> 
> template1=# select * from pg_user;
>  usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |  passwd  | valuntil
> ----------+----------+-------------+----------+----------+-----------+----------+----------
>  postgres |        1 | t           | t        | t        | t         | ******** |
>  hordemgr |       33 | f           | t        | f        | t         | ******** |
> (2 rows)
> 
> template1=# select * from pg_database;
>   datname  | datdba | encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid |
> datfrozenxid | datpath
> 
> -----------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------
>  horde     |      1 |        7 | f             | t            |         16554 |           49 |
> 49 |
>  template1 |      1 |        7 | t             | t            |         16554 |           49 |
> 49 |
>  template0 |      1 |        7 | t             | f            |         16554 |           49 |
> 49 |
> (3 rows)
> 
> Any help would be great !
> 
> Bye
> Marcus
> 
> --
> Petition for a Software Patent Free Europe
> http://petition.eurolinux.org
> 
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

-- 


 ,---- [ Marcus Schopen ] 
|  (0>   
|  //\   P.O. Box 10 25 25
|  V_/_  33525 Bielefeld
|        Germany
 `----

__________________________________________________

Petition for a Software Patent Free Europe 
http://petition.eurolinux.org