Hi again,
some days ago I said under another topic, that I have problems using
Informix because names of database objects are lowercase and suspect, that
Informix is case sensitive.
Well, only the first is true.
I have traced this down to the initialization via Village (Schema.schema()
...).
The metadata returned, e.g. column names, is lowercase. As a consequence,
the peer objects are populated with lowercase column names.
Until now this is no problem but later in the authentification process the
HashTable "permStorage" in TurbineUser gets populated with lowercase keys.
The get and set-methodes in TurbineUser try to retrieve information with the
upper-case versions from the MapBuilder. As a result the hash entries are
not found and this leads to the message "Failed to check account's
presence".
I have attached a turbine.log. This log contains some additional
"Log.note"-entries I have added to TurbineUserPeer.doSelect(...). The first
represents the Record object "row" retrieved from the database. The
following starting with "Col:" are the column names and values as they are
added to the hashtable "tempHash". The line "User-Object: " contains only a
toString on the variable "obj". The last note "User-object contents:"
contains the result on TurbineUser.getPermStorage().toString(). The rest are
'normal' log messages.
The place where the problem arise is
org.apache.turbine.services.security.DBUserManager.retrieve(DBUserManager.ja
va:236)!
BTW the whole is done with a version from todays cvs.
I hope it is only a kind of configuration problem.
[Wed Nov 29 11:41:12 GMT+01:00 2000] -- NOTICE -- IDBroker thread was
started.
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- TurbineUserPeer:
{'1','turbine','turbine','turbine','turbine','null','null','null','null','nu
ll','null','null','null','null','null','null','null','null','null','null','n
ull','null','null','null','null','null','null'}
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- Col: loginid = turbine
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- Col: password_value =
turbine
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- Col: first_name = turbine
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- Col: last_name = turbine
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- User-object:
org.apache.turbine.om.security.TurbineUser@d2984614
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- NOTICE -- User-object contents:
{last_name=turbine, first_name=turbine, loginid=turbine,
password_value=turbine}
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- ERROR -- Failed to check account's
presence
[Wed Nov 29 11:41:17 GMT+01:00 2000] -- ERROR --
Exception: java.lang.Exception: Criteria: null, Column Name:
TURBINE_USER.LOGINID, Comparison: =
Stack Trace follows:
java.lang.Exception: Criteria: null, Column Name: TURBINE_USER.LOGINID,
Comparison: =
at org.apache.turbine.util.db.SqlExpression.build(SqlExpression.java:181)
at org.apache.turbine.om.peer.BasePeer.createQueryString(BasePeer.java,
Compiled Code)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:1012)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer
.java, Compiled Code)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer
.java:235)
at
org.apache.turbine.services.security.DBUserManager.accountExists(DBUserManag
er.java:125)
at
org.apache.turbine.services.security.DBUserManager.accountExists(DBUserManag
er.java:105)
at
org.apache.turbine.services.security.DBUserManager.authenticate(DBUserManage
r.java:289)
at
org.apache.turbine.services.security.DBUserManager.retrieve(DBUserManager.ja
va:237)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUse
r(BaseSecurityService.java:285)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(Tu
rbineSecurity.java:193)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:105)
at org.apache.turbine.modules.Action.perform(Action.java:91)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:121)
at org.apache.turbine.Turbine.doGet(Turbine.java, Compiled Code)
at org.apache.turbine.Turbine.doPost(Turbine.java:454)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
9)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:745)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java,
Compiled Code)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java,
Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
Stefan Günther
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
