[horde] groups, members and vacations

[Jan Schneider]

Zitat von Tom Plancon <tplancon at bkaarchs.com>:

> Hello All,
>
> I'm working with horde-webmail-1.1.1 on a CentOS 5 system with a  
> postgresql backend. I want to propose Horde as a groupware solution  
> to my office and I'm trying to get everything I think they would  
> want up and running. I think I'm 90% there, but there are a couple  
> of things I can't get past.
>
> 1. Group members: I can create groups but when I tried to add  
> members to a group I see a "DB Error: no such  > field" in the  
> interface. I've checked horde.log. he only error I've seen that I  
> thought might relate was:
>    "Jul 02 15:31:36 HORDE [error] [horde] DB Error: no such field:   
> > SELECT lock_id, lock_owner, lock_scope, lock_principal,  >  
> lock_origin_timestamp, lock_update_timestamp, lock_expiry_timestamp,  
>  > lock_type FROM horde_locks WHERE lock_expiry_timestamp >=  
> 1215027096  > AND lock_principal =  
> '/kronolith/tplancon/tplancon.ics' AND  > lock_scope = 'webdav'  
> [nativecode=ERROR:  column "lock_owner" does  > not exist]"
>
> I added the "lock_owner" field and I haven't seen that error since,  
> nor any other errors in horde.log when I'm performing a group-member  
> add. In the posrgesql pg_log file I see "ERROR:  column "1" does not  
> exist".

http://bugs.horde.org/ticket/7046

> 2. Ingo - vacation: Ingo is installed, I see it in the list of Horde  
> components, Filters (Ingo) H3 (1.2). I can define and save filter  
> rules, I see Whitelist and Blacklist, but nothing is available to  
> set a vacation or away message. I've checked the .conf file and see  
> vacation, forward etc. are enabled. Again no notice or error in  
> horde log but when setting up the Ingo tables in Postgres I see in  
> pg_log:
>    NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
> "ingo_rules_pkey" for table "ingo_rules"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
> "ingo_forwards_pkey" for table "ingo_forwards"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
> "ingo_vacations_pkey" for table "ingo_vacations"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
> "ingo_spam_pkey" for table "ingo_spam"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
> "ingo_shares_pkey" for table "ingo_shares"
> ERROR:  relation "ingo_rules_seq" does not exist
> Could that be the issue? What is the sequence I need to create?

You don't create sequences manually. If necessary sequence tables are  
created by PEAR DB package, so make that your DB user has sufficient  
privileges.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/