Forum OpenACS Q&A: Re: question

Collapse
11: Re: question (response to 1)
Posted by xx xx on
SSH.

First check your error.log as described in your previous question. Post the error.

IF SWA login is the problem:

As postgres user do something like:
/usr/local/pgsql/bin/psql <databasename>

Then:

select * from users;

check all users. And reset the password as previously described. Or maybe:
update acs_permissions set object_id = -4, privilege = 'admin' where grantee_id = $user_id;

Or:

select * from membership_rels ;
update membership_rels set member_state = 'approved' where rel_id = $rel_id;

If that didn't help:

dropdb <databasename>
createdb <databasename>

to reinstall, IF (!) there is nothing really important in the database.

Collapse
12: Re: question (response to 11)
Posted by yani ballesfin on
aldert,

in our acs_permissions table, the object_id with privilege='admin' is equal to 0?

update acs_permissions set object_id = 0, privilege = 'admin' where grantee_id = $user_id;

is this correct? is this for assigning new user as an admin? tnx