Have a look at your postgres init skript.
Logging works, thanks!!
This is the log segment of a single login attempt: [SNIP] 010904.20:38:44.456 [1473] query:
select groupname from groups, users, user_group_map where users.username = 'milos' and users.user_id = user_group_map.user_id and groups.group_id = user_group_map.group_id
Issuing this statement manually, what do you get? Does it return roles with sufficient priviledges? cheers, oliver
select groupname from groups, users, user_group_map where users.username = 'milos' and users.user_id = user_group_map.user_id and groups.group_id = user_group_map.group_id
Issuing this statement manually, what do you get? Does it return roles with sufficient priviledges?
The result of this statement is: groupname ------- mygroup (1 row) The statement returns name of group. How does groupname relate to role? Contents of my users table: user_id username password 1 milos secret Contents of my groups table: group_id groupname 1 mygroup Contents of my user_group_map table: user_id group_id 1 1 -- Milos Prudek
participants (2)
-
Milos Prudek -
Oliver Bleutgen