Hi Tibor,
Thanks for the reply. Toggling active/inactive status via the web is
indeed updating database.
user.note is toggling between 0,1 when I set via web or direct using dbexec.
However, it appears to be a different issue (error displayed is wrong)
1. If user has no role (default for most users) or is assigned role
'submitter' then user gets error
"Authorization failure Account 'xxxxx' is not yet activated. Try to
login with another account.
If you think this is not correct, please contact..."
2. If user has Librarian role, then user doesn't get above error.
Thanks
Gary
<mailto:[email protected]>
Gary Holman
NPL/CENPA, University of Washington
email: [email protected]
On 05/13/2015 01:19 PM, Tibor Simko wrote:
On Wed, 13 May 2015, holman wrote:
I have tried toggling the active status on/off but that does not work.
Can I fix this in the database directly?
Toggling status seems to work well for me using maint-1.1 branch.
On the database level, you can check the value of the column `note` of
the `user` table. A value of 1 means the account is activated, a value
of 0 means it is inactivated.
For example, to list statuses of all accounts:
$ echo "select id,email,note from user" | dbexec
For example, to make user ID=2 inactive:
$ echo "update user set note=0 where id=2" | dbexec
You should well see the active/inactive status flipped in the WebAccess
Admin interface, menu Manage Accounts:
https://example.org/admin/webaccess/webaccessadmin.py/modifyaccounts
Best regards
--
Tibor Simko
