Fórum

user to usergroup associations being lost in database

thumbnail
Jack Bakker, modificado 11 Anos atrás.

user to usergroup associations being lost in database

Liferay Master Postagens: 978 Data de Entrada: 03/01/10 Postagens Recentes
Liferay CE 6.0.6 ; postgresql 8.4 ; import from Active Directory on login only (not on interval or on startup)

I have a sql script running every hour that checks if a test user is associated with a usergroup in the postgresql database ; the user mysteriously gets dissassociated from the usergroup seemingly at random ; this is happening with many user/usergroup associations ; on login, the user is associated again but then mysteriously the database gets updated at some point where the association is lost

what event could be causing this ?
thumbnail
David H Nebinger, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Legend Postagens: 14914 Data de Entrada: 02/09/06 Postagens Recentes
You could add model listeners in order to find out if it's being done on the Liferay side... If it's done on the database side, it's probably up to you to track down...
thumbnail
Hitoshi Ozawa, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Legend Postagens: 7942 Data de Entrada: 24/03/10 Postagens Recentes
Seems to be connection pool timeout. Liferay updates the memory cache and then flushes the memory cache to a database. I think your connection pool is timing out so the data is updated to the memory cache but not to the database.
thumbnail
Jack Bakker, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Master Postagens: 978 Data de Entrada: 03/01/10 Postagens Recentes
thanks Hitoshi

any ideas/posts on how to determine best config ?

http://www.liferay.com/community/wiki/-/wiki/Main/Portal+Properties+6.0.5#section-Portal+Properties+6.0.5-JDBC
thumbnail
Hitoshi Ozawa, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Legend Postagens: 7942 Data de Entrada: 24/03/10 Postagens Recentes
Sorry, no. It's dependent on the environment. I remember having to set it to a large value when my liferay and database were in a different segment. I think the switch was timing out the sessions. This is another reason to use Apache http server upfront - to keep liferay and database in a same segment.
thumbnail
Jack Bakker, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Master Postagens: 978 Data de Entrada: 03/01/10 Postagens Recentes
got apache in front (there is no other way really)

what do you mean by 'it' being set to a large value ; I think you are onto something here for me
thumbnail
Jack Bakker, modificado 11 Anos atrás.

RE: user to usergroup associations being lost in database

Liferay Master Postagens: 978 Data de Entrada: 03/01/10 Postagens Recentes
I guess it is time for me to get to know c3p0 better

http://www.liferay.com/community/wiki/-/wiki/Main/Portal+Properties+6.0.5#section-Portal+Properties+6.0.5-JDBC

http://www.mchange.com/projects/c3p0/index.html#configuration