unable to login

Hi,

I am not able to login. I get some exceptions (see below). I
debugged 
the login session with Eclipse and there's something I dont
understand 
in method SQLSession.getEntry() : map storedFieldnames
contains a string 
"groups" and there's a loop searching if there's a
column named 'groups" 
in the table 'users', which does not exist.
I forgot to mention that nxsqldirectory is a MySQL
database.

2007-04-06 20:58:02,171 DEBUG 
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: 
registering pool with interval 900000 old interval: 450000

2007-04-06 20:58:02,250 ERROR
[org.nuxeo.ecm.core.api.ClientException] 
ClientException created...

org.nuxeo.ecm.directory.DirectoryException: getEntry failed

	at
org.nuxeo.ecm.directory.sql.SQLSession.getEntry(SQLSession.j
ava:220)

	at
org.nuxeo.ecm.directory.sql.SQLSession.authenticate(SQLSessi
on.java:509)

	at 
org.nuxeo.ecm.directory.api.AbstractDirectoryClient.authenti
cate(AbstractDirectoryClient.java:118)

	at 
org.nuxeo.ecm.platform.usermanager.UserManagerImpl.checkUser
namePassword(UserManagerImpl.java:81)

	at 
org.nuxeo.ecm.platform.login.NuxeoLoginModule.validateUserna
mePassword(NuxeoLoginModule.java:194)

	at 
org.nuxeo.ecm.platform.login.NuxeoLoginModule.getPrincipal(N
uxeoLoginModule.java:122)

	at 
org.nuxeo.ecm.platform.login.NuxeoLoginModule.login(NuxeoLog
inModule.java:148)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

	at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
ssorImpl.java:39)

	at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
thodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:585)

	at
javax.security.auth.login.LoginContext.invoke(LoginContext.j
ava:769)

	at
javax.security.auth.login.LoginContext.access$000(LoginConte
xt.java:186)

	at
javax.security.auth.login.LoginContext$4.run(LoginContext.ja
va:683)

	at java.security.AccessController.doPrivileged(Native
Method)

	at
javax.security.auth.login.LoginContext.invokePriv(LoginConte
xt.java:680)

	at
javax.security.auth.login.LoginContext.login(LoginContext.ja
va:579)

	at 
org.jboss.security.plugins.JaasSecurityManager.defaultLogin(
JaasSecurityManager.java:601)

	at 
org.jboss.security.plugins.JaasSecurityManager.authenticate(
JaasSecurityManager.java:535)

	at 
org.jboss.security.plugins.JaasSecurityManager.isValid(JaasS
ecurityManager.java:344)

	at 
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.authenti
cate(JBossSecurityMgrRealm.java:491)

	at 
org.apache.catalina.authenticator.FormAuthenticator.authenti
cate(FormAuthenticator.java:257)

	at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(A
uthenticatorBase.java:416)

	at 
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo
ntextValve.java:74)

	at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHo
stValve.java:126)

	at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
rtValve.java:105)

	at 
org.apache.catalina.core.StandardEngineValve.invoke(Standard
EngineValve.java:107)

	at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd
apter.java:148)

	at 
org.apache.coyote.http11.Http11Processor.process(Http11Proce
ssor.java:869)

	at 
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection
Handler.processConnection(Http11BaseProtocol.java:664)

	at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo
lTcpEndpoint.java:527)

	at 
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste
rSlaveWorkerThread.java:112)

	at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException: Column 'groups' not
found.



	at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:970)

	at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4755)

	at 
org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(W
rappedResultSet.java:878)

	at
org.nuxeo.ecm.directory.sql.SQLSession.getEntry(SQLSession.j
ava:206)

	... 32 more

_______________________________________________
ECM mailing list
ECMlists.nuxeo.com
http://li
sts.nuxeo.com/mailman/listinfo/ecm

Vincent Dutat a écrit :
> Hi,
> 
> I am not able to login. I get some exceptions (see
below). I debugged
> the login session with Eclipse and there's something I
dont understand
> in method SQLSession.getEntry() : map storedFieldnames
contains a string
> "groups" and there's a loop searching if
there's a column named 'groups"
> in the table 'users', which does not exist.
> I forgot to mention that nxsqldirectory is a MySQL
database.

'groups' should not be in the storedFieldNames list since
it's not stored in the
main users table but computed as a reference.

You probably need define the missing references as done in
the default
SQLDirectory setup:


http://svn.nuxeo.org/trac/nuxeo/browser/org.nuxeo.ecm.
directory/trunk/sql/resources/default-sql-directories-bundle
.xml

Please also have a look at how to upgrade your users
directories with the
instructions included in this simple script:



http://svn.nuxeo.org/trac/nuxeo/browser/org.nuxeo.ecm.direct
ory/trunk/sql/resources/upgrade-reference-tables.sql

Best,

-- 
Olivier

_______________________________________________
ECM mailing list
ECMlists.nuxeo.com
http://li
sts.nuxeo.com/mailman/listinfo/ecm