[horde] horde and postgres: can't create Usergroups

[listac@nebelschwaden.de]

Hello,

I have checked my logs and they all tell me that the relation (table)
"horde_datatree_seq" does not exist. And, for some reason does not get
created even though the horde user has superuser rights on the database
and had so from beginning for this installation.

>From postgresql.log:

FEHLER:  Relation >>horde_datatree_seq<< existiert nicht
translation: error: relation >>horde_datatree_seq<< does not exist

>From horde.log (debug):

May 04 11:49:04 HORDE [debug] [horde] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_name, c.datatree_parents,
c.datatree_order FROM horde_datatree c WHERE c.group_uid = 'horde.groups' 
[on line 130 of "/home/www/htdocs/horde/lib/Horde/DataTree/sql.php"]
May 04 11:49:07 HORDE [debug] [horde] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_name, c.datatree_parents,
c.datatree_order FROM horde_datatree c WHERE c.group_uid = 'horde.groups' 
[on line 130 of "/home/www/htdocs/horde/lib/Horde/DataTree/sql.php"]
May 04 11:49:18 HORDE [error] [horde] DB Error: unknown error: SELECT
NEXTVAL('horde_datatree_seq') [nativecode=FEHLER:  Relation
>>horde_datatree_seq<< existiert nicht] [on line 451 of
"/home/www/htdocs/horde/lib/Horde/DataTree/sql.php"]
May 04 11:49:18 HORDE [error] [horde] DB Error: unknown error: SELECT
NEXTVAL('horde_datatree_seq') [nativecode=FEHLER:  Relation
>>horde_datatree_seq<< existiert nicht] [on line 53 of
"/home/www/htdocs/horde/admin/groups.php"]
May 04 11:49:18 HORDE [debug] [horde] SQL Query by DataTree_sql::_load():
SELECT c.datatree_id, c.datatree_name, c.datatree_parents,
c.datatree_order FROM horde_datatree c WHERE c.group_uid = 'horde.groups' 
[on line 130 of "/home/www/htdocs/horde/lib/Horde/DataTree/sql.php"]



> Hello,
>
> Have you check to see what your postgresql logs say when trying to
> create said table? Also, do you have your horde install setup to log all
> errors? These are a good place to start hunting.
>
> Nick Peters
> IT Assistant
> Cando Contracting Ltd
> www.candoltd.com
>
>
>
> listac at nebelschwaden.de wrote:
>
>>Thanks for your reply. However, as I said, I also tried setting up horde
>>with the user connecting to the database (horde) being "superuser",
>>meaning having all rights possible. I tried both with the database owned
>>by postgres or by horde. No change.
>>
>>As a sidenote this would be a bug as according to the install
>>documentation the horde db user is supposed to get all neccessary rights
>>by one of the sql scripts, so manual adjustment of user rights should not
>>be possible. However, granting the user all rights did not help.
>>
>>Ede
>>
>>
>>
>>
>>>Quoting listac at nebelschwaden.de:
>>>
>>>
>>>
>>>>I am rather new to horde and I run into the problem, that the table
>>>>horde_datatree_seq is missing which at least prevents the creation of
>>>>groups.
>>>>
>>>>
>>>Your database user needs to have sufficient permissions to create
>>> tables.
>>>
>>>-chuck
>>>
>>>--
>>>"we are plastered to the windshield of the bus that is time." - Chris
>>>--
>>>Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>>>Frequently Asked Questions: http://horde.org/faq/
>>>To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>
>>>
>>>
>>>
>>
>>
>>
>>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>