[horde] groups, members and vacations

[Michael Menge]

Hi

>> 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.
>

I had the same problem that sequences where not created on demand but  
had to be created by hand. I used  
framework/admintools/horde-create-sequence.php which has the same  
privileges as Hode as it uses the same user. So i don't think its a  
problem of privileges. But maybe its a problem of Pear DB / Pear MDB2  
and postgres.




--------------------------------------------------------------------------------
M.Menge                                 Tel.: (49) 7071/29-70316
Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
Zentrum fuer Datenverarbeitung          mail:  
michael.menge at zdv.uni-tuebingen.de
Waechterstrasse 76
72074 Tuebingen