[Résolu] Autre problème après upgrade : impossible de se connecter

guidtz · April 9, 2013, 9:45am

avec n’importe quel compte, que ce soit un compte admin (admin0, admin d’un domaine) ou un compte utilisateur.

Voici le log de bm-core :

2013-04-09 09:43:31,841 n.b.c.s.a.i.AuthenticationRegistry INFO - Validate password using service net.bluemind.core.server.auth.impl.DatabaseAuthenticationService: YES in 0ms.
2013-04-09 09:43:31,844 n.b.c.u.UserHome ERROR - ERROR: argument of IS FALSE must be type boolean, not type smallint
  Position: 1730
org.postgresql.util.PSQLException: ERROR: argument of IS FALSE must be type boolean, not type smallint
  Position: 1730
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[na:na]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[na:na]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[na:na]
	at net.bluemind.pool.xa.impl.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:193) ~[na:na]
	at net.bluemind.core.user.UserHome.runFindQuery(UserHome.java:679) ~[net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.user.UserHome.find(UserHome.java:569) ~[net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.UserManagement.findUserByLogin(UserManagement.java:760) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.UserManagement.login(UserManagement.java:218) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.login.LoginBindingImpl.logUserIn(LoginBindingImpl.java:61) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.server.LoginHandler$1.execute(LoginHandler.java:68) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.server.AbstractSyncHandler.handle(AbstractSyncHandler.java:94) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.server.SyncServlet.handleQuery(SyncServlet.java:139) [net.bluemind.core_1.0.0.b8471.jar:na]
	at net.bluemind.core.server.SyncServlet.service(SyncServlet.java:98) [net.bluemind.core_1.0.0.b8471.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [javax.servlet_2.5.0.v201103041518.jar:na]
	at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) [org.eclipse.equinox.http.registry_1.1.100.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [javax.servlet_2.5.0.v201103041518.jar:na]
	at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317) [org.eclipse.equinox.http.jetty_2.0.100.v20110502.jar:na]
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.Server.handle(Server.java:326) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) [org.mortbay.jetty.util_6.1.23.v201012071420.jar:na]
2013-04-09 09:43:31,847 n.b.c.s.SyncServlet ERROR - sending ServerFault: org.postgresql.util.PSQLException: ERROR: argument of IS FALSE must be type boolean, not type smallint
  Position: 1730
net.bluemind.core.api.fault.ServerFault: org.postgresql.util.PSQLException: ERROR: argument of IS FALSE must be type boolean, not type smallint
  Position: 1730
	at net.bluemind.core.user.UserHome.find(UserHome.java:586) ~[na:na]
	at net.bluemind.core.UserManagement.findUserByLogin(UserManagement.java:760) ~[na:na]
	at net.bluemind.core.UserManagement.login(UserManagement.java:218) ~[na:na]
	at net.bluemind.core.login.LoginBindingImpl.logUserIn(LoginBindingImpl.java:61) ~[na:na]
	at net.bluemind.core.server.LoginHandler$1.execute(LoginHandler.java:68) ~[na:na]
	at net.bluemind.core.server.AbstractSyncHandler.handle(AbstractSyncHandler.java:94) ~[na:na]
	at net.bluemind.core.server.SyncServlet.handleQuery(SyncServlet.java:139) ~[na:na]
	at net.bluemind.core.server.SyncServlet.service(SyncServlet.java:98) ~[na:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [javax.servlet_2.5.0.v201103041518.jar:na]
	at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) [org.eclipse.equinox.http.registry_1.1.100.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68) [org.eclipse.equinox.http.servlet_1.1.200.v20110502.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [javax.servlet_2.5.0.v201103041518.jar:na]
	at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317) [org.eclipse.equinox.http.jetty_2.0.100.v20110502.jar:na]
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.Server.handle(Server.java:326) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) [org.mortbay.jetty.server_6.1.23.v201012071420.jar:na]
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) [org.mortbay.jetty.util_6.1.23.v201012071420.jar:na]
Caused by: org.postgresql.util.PSQLException: ERROR: argument of IS FALSE must be type boolean, not type smallint
  Position: 1730
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[na:na]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[na:na]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[na:na]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[na:na]
	at net.bluemind.pool.xa.impl.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:193) ~[na:na]
	at net.bluemind.core.user.UserHome.runFindQuery(UserHome.java:679) ~[na:na]
	at net.bluemind.core.user.UserHome.find(UserHome.java:569) ~[na:na]
	... 27 common frames omitted

Toony · April 9, 2013, 9:58am

Avez-vous utilisé le setup wizard pour terminer l’installation ?

Lors du passage en version avec souscription, il faut remplacer le paquet bm-installation-wizard par le paquet bm-setup-wizard. Vous devez avoir reçu les instructions complète lors de l’envoi de la souscription.

guidtz · April 9, 2013, 12:28pm

J’ai du zapper cette partie ! J’ai bien réinstallé bm-setup-wizard et fait l’update et ça marche mieux maintenant.

Toony · April 9, 2013, 12:38pm

En fait la mise à jour de Blue Mind se déroule en 2 étapes:
[list=*]
]mise à jour des paquets/]
]mise à jour des données/]
[/list]

Cette 2° étape n’est disponible qu’avec la souscription et permet de migrer les données de Blue Mind pour la nouvelle version. Il faut donc installer le setup wizard (disponible uniquement avec la souscription) lors de l’installation de la souscription.

À partir de maintenant, cette étape ne pourra pas être manquée, suite à la mise à jour des paquets, l’interface web redirige automatiquement vers la mise à jour des données.