掲示板

RE: Activate deactivate users from database

thumbnail
12年前 に Vahid M によって更新されました。

Activate deactivate users from database

Junior Member 投稿: 26 参加年月日: 08/03/27 最新の投稿
Hi All,

I have a question regarding activation and deactivation of users in Liferay. I'm using Liferay version 4.4.2. I want to disable a user by just updating the "active_" field in "User_" table. I thought this is sufficient for preventing a user from logging in. Of course, I know that it's possible to disable a user from the UI but I don't want to use the UI.

My problem is, when I disable a user by updating the "active_" to 0 (zero) (which indicates a disabled user), then, when the same user tries to log in, the system automatically enables it again? I cannot understand why this is happening? On the other hand, if I disable a user through UI everything is perfect and that user won't be able to log in again. There should be something that I'm missing. Something more should be done in addition to just changing a field from 1 to 0.

Could anyone please shed some light over this issue?


Thanks a lot :-)
thumbnail
12年前 に Ravi Kumar Gupta によって更新されました。

RE: Activate deactivate users from database

Liferay Legend 投稿: 1302 参加年月日: 09/06/24 最新の投稿
Have a look at the source of LR4.4.2 and see how the deactivation process is done. That should help.
thumbnail
11年前 に Vahid M によって更新されました。

RE: Activate deactivate users from database

Junior Member 投稿: 26 参加年月日: 08/03/27 最新の投稿
This issue is somehow related to database cache I suppose. I performed a test and it’s working. I updated active_ field from 0 to 1, which means I enabled the user, by updating the database table. Then I immediately tried to login and it was a failure. Next time I did the same except after the update I waited for couple of minutes. By waiting, I think the cache got expired and the state of the user was checked against the data from the database not data from cache. This is my understanding. It might have other reasons.
thumbnail
11年前 に David H Nebinger によって更新されました。

RE: Activate deactivate users from database

Liferay Legend 投稿: 14914 参加年月日: 06/09/02 最新の投稿
You should never update the database directly. Updates should only be done using the Liferay API.

Liferay uses lucene indices, especially for users. The only way to ensure lucene is updated is to use the Liferay API.

Seriously, this comes up over and over again. It doesn't matter how many times we tell people not to modify the database, they keep insisting on trying and then wonder why their database updates are not reflected.
thumbnail
11年前 に Hitoshi Ozawa によって更新されました。

RE: Activate deactivate users from database (回答)

Liferay Legend 投稿: 7942 参加年月日: 10/03/24 最新の投稿
Yes, liferay uses data from a cache instead of directly from the database. Cache is used to increase performance as well as to share content across a cluster.

Waiting cache to timeout is one alternative, but it's possible to force cache to clear from Control Panel -> Server Administration -> Clear Cache or by restarting liferay.

David talked about indexing but cache is actually not related to indexing but liferay api ensures indexes are updated as well.