Forum OpenACS Q&A: Cannot Delete User Groups

Collapse
1: Cannot Delete User Groups
Posted by amit singh on 08/22/01 03:21 PM
I created a user group of type portal_group in version 3.2.5. When i tried to delete it it gave me an error like: 
Errors since 22/Aug/2001:18:38:06

[22/Aug/2001:18:39:17]
    Error: Ns_PgExec: result status: 7 message: ERROR: 
portal_group_info: Permission denied.
    

[22/Aug/2001:18:39:17]
    Error: dbinit: error(localhost::acs,ERROR:  portal_group_info:
Permission denied.
    ): 'delete from user_groups where group_type =  'portal_group''

[22/Aug/2001:18:39:17]
    Error: Database operation "dml" failed
    Database operation "dml" failed
        while executing
    "ns_db dml $db "delete from user_groups where group_type = 
'$QQgroup_type'""
        (file
"/var/lib/aolserver/servers/defaultacs/www/admin/ug/group-type-delete-2.tcl"
line 119)
        invoked from within
    "source $script"
        (procedure "ns_sourceproc" line 6)
        invoked from within
    "ns_sourceproc cns109 {}"
    202.88.151.25 - - [22/Aug/2001:18:39:17 +0530] "GET
/admin/ug/group-type-delete-2.tcl?group_type=portal_group HTTP/1.0"
500 530
"http://202.88.151.25:8000/admin/ug/group-type-delete.tcl?group_type=portal_group"
"Mozilla/4.75 [en] (X11; U; Linux 2.2.16-22 i686)"
    202.88.151.25 - - [22/Aug/2001:18:39:17 +0530] "GET
/pull-down-menus/style?menu_id=1 HTTP/1.0" 200 1172 "" "Mozilla/4.75
[en] (X11; U; Linux 2.2.16-22 i686)"
Cansome help me get rid of the error.
Collapse
2: Response to Cannot Delete User Groups (response to 1)
Posted by Roberto Mello on 08/22/01 04:44 PM
Looks like a PG permissions problem to me. You probably created the database as one user and AOLserver is accessing the database as another user who does not have all privileges to the tables in that database.

You should create the database as the AOLserver user to avoid that type of problem.

Collapse
3: Response to Cannot Delete User Groups (response to 1)
Posted by amit singh on 08/22/01 04:51 PM
Thanks Roberto,

I was using the rpm version in which the user is acs. and my init.file was configured for nsadmin as per the documentation. I was able to delete the same after doing the necessary Modifications.

Collapse
4: Response to Cannot Delete User Groups (response to 1)
Posted by Jonathan Marsden on 08/22/01 06:02 PM
Amit, do you mean that the RPM version includes a file where the DB user is set to 'nsadmin'?  If so, which file and which line of that file?  Or do you mean you edited a file to do this?

If I've left an instance of 'nsadmin' (is that really the recommended PG username) somewhere it shouldn't be, I'll very gladly change it to acs so things work better 😊