Loading...
 
Architecture / Installation

Architecture / Installation


Re: Re: Problem with PostgreSQL

posts: 2881 United Kingdom

Ok some english translations of the results wink

> eru:

>
> SELECT * FROM users_grouppermissions ;
>

> returns empty set.

This means that there are no global permissions setup by admin->groups the results below show me that all those permName permissions for Registered are only for 1 particular wiki page. (the objectId hash)

I think you'll need to review the global permissions through admin->groups rather than individuals to get what you want setup first. Then go locking individual pages if needed.

Damian

p.s. follow here for reference wink

> You meant probably
> SELECT * FROM users_objectpermissions ;
>
> where I get:
>  groupName  |       permName        | objectType |             objectId             
> ------------+-----------------------+------------+----------------------------------
>  Registered | tiki_p_view           | wiki page  | 6d7f618fdb6590000b06a03865b40191
>  Registered | tiki_p_edit           | wiki page  | 6d7f618fdb6590000b06a03865b40191
>  Registered | tiki_p_lock           | wiki page  | 6d7f618fdb6590000b06a03865b40191
>  Registered | tiki_p_admin_wiki     | wiki page  | 6d7f618fdb6590000b06a03865b40191
>

> I don't know how objectId translates to wiki page ID (which is 1 - HomePage), but it works as DB changes when I manipulate website.

> And, of course:
> select * from users_usergroups ;
>
> yields:
>  userId | groupName  
> --------+------------
>       2 | Registered
>

> where 2 is my user id.
> So, database seems ok... strange, right? :-)
> A hint - maybe something with small/capital letters, as pgsql is case-sensitive? No other ideas here.

Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.