Mailing List Archive: Corrupt user account

Hey folks,
Has anyone had problems with corrupt user accounts before? We
have an account experiencing two issues, and I'm not sure how best to
handle it.

1) The user is being denied checkout access to templates, even though
his permissions are identical to my other student programmers, who can
check out templates without issue.

2) The user is seeing errors on preview that indicate he's getting
old, sandbox versions of templates, even though he checked those
templates back in two months ago.

For issue 1, is there any way to cleanly delete/purge the account from
the database? The behavior seems to indicate that there's a bad row
in a permissions table somewhere that's setting a DENY.

For issue 2, we found old template files in his sandbox (/path/to/
bricolage/data/burn/sandbox/user_XXXX/oc_1). Is it safe to just
delete those? Why weren't they deleted when he checked the templates
back in?

Any insights would be appreciated - thanks!

-Aaron

---------------------------------
Aaron Fuleki
Senior Web Architect
Denison University
740.587.5752
---------------------------------

On Jan 5, 2010, at 6:45 AM, Aaron Fuleki wrote:

> 1) The user is being denied checkout access to templates, even though his permissions are identical to my other student programmers, who can check out templates without issue.

Sounds odd. I'd quadruple-check his group memberships.

> 2) The user is seeing errors on preview that indicate he's getting old, sandbox versions of templates, even though he checked those templates back in two months ago.

That can happen sometimes. Make sure all his templates are checked in and delete his sandbox from the file system. It will be named $BRICOLAGE_ROOT/data/burn/sandbox/user_$id.

> For issue 1, is there any way to cleanly delete/purge the account from the database? The behavior seems to indicate that there's a bad row in a permissions table somewhere that's setting a DENY.

No, because users are associated with the objects they've worked with in the past. You can delete the user via the UI and create a new one, though, even with the same username.

> For issue 2, we found old template files in his sandbox (/path/to/bricolage/data/burn/sandbox/user_XXXX/oc_1). Is it safe to just delete those? Why weren't they deleted when he checked the templates back in?

Yeah, just delete them. I haven't figured out why they're sometimes not removed from the sandbox. It has annoyed me a few times in the past, though not enough to really look into, since I've not found a recipe to reliably reproduce it.

Best,

David