[Obm] OBM 2.3.7 : synchro lightning apres suppression / recreation d'un user OBM

Patrick BOSSARD Patrick.Bossard at ifremer.fr
Tue Jun 8 17:32:25 CEST 2010


Bonjour à tous,

J'ai procédé a des tests, notamment  l suppression de mon user 
(pbossard) via l'administrateur global admin0.
la reconnexion via lemonLDAP me régénère bien mon user. La connexion se 
passe sans pb.

au niveau de lightning  (thunderbird[ext: 2.4.0.1, light: 1.0b1]), j'ai 
du reparametrer le connecteur, mais l'authentification ne se fait plus :

/var/log/obm-tomcat/obm-java.log

> 2010-06-08 15:17:50,188 SyncServlet INFO - Starting obm-sync 2.3.9
> 2010-06-08 15:17:50,188 LoginHandler INFO - method: doLogin
> 2010-06-08 15:17:50,238 UserTransactionFactory INFO - 
> UserTransactionFactory created
> 2010-06-08 15:17:50,238 UserManagement INFO - access refused to login: 
> 'pbossard' domain: 'ifremer.fr' auth type: OBM DB
> 2010-06-08 15:17:50,238 SyncServlet INFO - handler responded to 
> login/doLogin in 50ms.

en regardant le log, j'ai eu une erreur, à la suite de laquelle je 
n'arrive plus a me connecter (meme apres arret/redemarrage de tomcat).
Comment résoudre le pb et re-activer un user dans un tel cas ?
Voici les erreurs du fichier obm-java.log :

> 2010-06-08 13:19:15,234 LoginHandler INFO - method: doLogin
> 2010-06-08 13:19:15,234 UserManagement INFO - pbossard at ifremer.fr 
> logged in from thunderbird[ext: 2.4.0.1, light: 1.0b1]. auth type: OBM 
> DB (mail: patrick.bossard at ifremer.fr) on obm-sync 2.3.9
> 2010-06-08 13:19:15,234 SyncServlet INFO - handler responded to 
> login/doLogin in 2ms.
> 2010-06-08 13:19:15,336 SyncServlet INFO - handler responded to 
> calendar/listCategories in 0ms.
> 2010-06-08 13:19:15,438 CalendarBindingImpl INFO - [null] Calendar : 
> getSync(pbossard, Mon Jun 07 11:59:06 GMT 2010)
> 2010-06-08 13:19:15,438 CalendarBindingImpl INFO - getSync(pbossard) 
> => 1 upd, 0 rmed.
> 2010-06-08 13:19:15,438 SyncServlet INFO - handler responded to 
> calendar/getSync in 12ms.
> 2010-06-08 13:19:16,701 CalendarBindingImpl INFO - [null] Calendar : 
> getSync(pbossard, Tue Jun 08 13:19:15 GMT 2010)
> 2010-06-08 13:19:16,701 UserManagement ERROR - FATAL: terminating 
> connection due to administrator command
> org.postgresql.util.PSQLException: FATAL: terminating connection due 
> to administrator command
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
>         at 
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
>         at 
> fr.aliacom.obm.common.UserManagement.findUserByLogin(UserManagement.java:496)
>         at 
> fr.aliacom.obm.common.UserManagement.checkCalendarUser(UserManagement.java:571)
>         at 
> fr.aliacom.obm.common.calendar.CalendarBindingImpl.getSync(CalendarBindingImpl.java:261)
>         at 
> fr.aliacom.obm.common.calendar.CalendarBindingImpl.getSync(CalendarBindingImpl.java:235)
>         at org.obm.sync.server.EventHandler.getSync(EventHandler.java:483)
>         at org.obm.sync.server.EventHandler.handle(EventHandler.java:89)
>         at 
> org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:88)
>         at org.obm.sync.server.SyncServlet.service(SyncServlet.java:65)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>         at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>         at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>         at 
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
>         at 
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:722)
>         at 
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2214)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> 2010-06-08 13:19:16,701 UserManagement INFO - user :pbossard not 
> found, archived or have no email
> 2010-06-08 13:19:16,701 CalendarHandler ERROR - Calendar not exist or 
> not valid
> org.obm.sync.auth.ServerFault: Calendar not exist or not valid
>         at 
> fr.aliacom.obm.common.calendar.CalendarBindingImpl.getSync(CalendarBindingImpl.java:264)
>         at 
> fr.aliacom.obm.common.calendar.CalendarBindingImpl.getSync(CalendarBindingImpl.java:235)
>         at org.obm.sync.server.EventHandler.getSync(EventHandler.java:483)
>         at org.obm.sync.server.EventHandler.handle(EventHandler.java:89)
>         at 
> org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:88)
>         at org.obm.sync.server.SyncServlet.service(SyncServlet.java:65)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>         at 
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
>         at 
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:722)
>         at 
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2214)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> 2010-06-08 13:19:16,701 SyncServlet INFO - handler responded to 
> calendar/getSync in 10ms.
> 2010-06-08 13:19:45,839 ConnectionProxy INFO - Connexion recycled 
> successfuly.
> ....
> 2010-06-08 13:29:15,347 LoginHandler INFO - method: doLogin
> 2010-06-08 13:29:15,347 DatabaseAuthentificationService ERROR - Could 
> not authentificate against OBM
> org.postgresql.util.PSQLException: FATAL: terminating connection due 
> to administrator command
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
>         at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
>         at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
>         at 
> fr.aliasource.obm.aliapool.pool.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:163)
>         at 
> org.obm.sync.server.auth.impl.DatabaseAuthentificationService.isValidPassword(DatabaseAuthentificationService.java:85)
>         at 
> org.obm.sync.server.auth.impl.DatabaseAuthentificationService.doAuth(DatabaseAuthentificationService.java:49)
>         at 
> fr.aliacom.obm.common.UserManagement.login(UserManagement.java:182)
>         at 
> org.obm.sync.login.LoginBindingImpl.logUserIn(LoginBindingImpl.java:29)
>         at org.obm.sync.server.LoginHandler.doLogin(LoginHandler.java:77)
>         at org.obm.sync.server.LoginHandler.handle(LoginHandler.java:49)
>         at 
> org.obm.sync.server.SyncServlet.handleQuery(SyncServlet.java:88)
>         at org.obm.sync.server.SyncServlet.service(SyncServlet.java:65)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>         at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>         at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>         at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>         at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
>         at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>         at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>         at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
>         at 
> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
>         at 
> org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:722)
>         at 
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2214)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> 2010-06-08 13:29:15,347 UserManagement INFO - access refused to login: 
> 'pbossard' domain: 'ifremer.fr' auth type: OBM DB

Merci à tous,
Patrick.



-- 
Patrick BOSSARD - DOP/DCB/IDM/RIC
IFREMER centre de Brest
BP 70 29280 Plouzane FRANCE
Tel  : 02 98 22 44 09 - Fax: 02 98 22 45 46
Email: Patrick.Bossard at ifremer.fr



More information about the Obm mailing list