You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@roller.apache.org by kelvin pang <ke...@gmail.com> on 2006/08/18 06:46:54 UTC

problem: running roller2.3 under resin 3.0

when I try to login,the following exception occur:

java.sql.SQLException: Unknown column 'userenabled' in 'where clause'
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
        at com.mysql.jdbc.PreparedStatement.executeQuery(
PreparedStatement.java:1586)
        at com.caucho.sql.UserPreparedStatement.executeQuery(
UserPreparedStatement.java:108)
        at com.caucho.sql.UserPreparedStatement.executeQuery(
UserPreparedStatement.java:108)
        at com.caucho.server.security.JdbcAuthenticator.loginImpl(
JdbcAuthenticator.java:394)
        at com.caucho.server.security.JdbcAuthenticator.loginImpl(
JdbcAuthenticator.java:322)
        at com.caucho.server.security.AbstractAuthenticator.login(
AbstractAuthenticator.java:212)
        at com.caucho.server.security.FormLoginServlet.service(
FormLoginServlet.java:76)
        at com.caucho.server.dispatch.ServletFilterChain.doFilter(
ServletFilterChain.java:106)
        at com.caucho.server.webapp.NamedDispatcherImpl.forward(
NamedDispatcherImpl.java:119)
        at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
ForwardFilterChain.java:74)
        at com.caucho.server.cache.CacheFilterChain.doFilter(
CacheFilterChain.java:188)
        at com.caucho.server.webapp.WebAppFilterChain.doFilter(
WebAppFilterChain.java:178)
        at com.caucho.server.dispatch.ServletInvocation.service(
ServletInvocation.java:229)
        at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java
:268)
        at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
        at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
        at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
        at java.lang.Thread.run(Thread.java:595)
[12:38:52.375] Closing dangling connections.  All connections must have a
close() in a finally block.
[12:38:52.375] java.lang.IllegalStateException: Connection UserConnection[
com.caucho.sql.ManagedConnectionImpl@8b1323] was not clo
sed. Connections must have a close() in a finally block.
[12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction(
UserTransactionImpl.java:466)
[12:38:52.375]  at com.caucho.jca.UserTransactionProxy.abortTransaction(
UserTransactionProxy.java:174)
[12:38:52.375]  at com.caucho.server.webapp.WebAppFilterChain.doFilter(
WebAppFilterChain.java:198)
[12:38:52.375]  at com.caucho.server.dispatch.ServletInvocation.service(
ServletInvocation.java:229)
[12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest(
HttpRequest.java:268)
[12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
TcpConnection.java:389)
[12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[12:38:52.375]  at java.lang.Thread.run(Thread.java:595)

-- 
kevin

Re: problem: running roller2.3 under resin 3.0

Posted by kelvin pang <ke...@gmail.com>.

OK,thanks!
now it's ok.howeve something strange happened,after i logined, the first
line of that page showed as:
您登录为 tom <http://roller/editor/yourProfile.do?method=edit> -
???mainPage.currentWebsite??? *tom <http://via:9090/roller/page/tom>* Front
Page <http://roller/main.do> |
???mainPage.mainMenu???<http://roller/editor/yourWebsites.do?method=edit>|
退出 <http://roller/logout-redirect.jsp> some text couldn't display correct,
for example: ???mainPage.currentWebsite??? .

2006/8/18, Matt Raible <mr...@gmail.com>:
>
> Is there a security.xml in your WEB-INF folder?  If so, you don't need
> any security-related settings in resin.conf - just datasource
> settings.
>
> Matt
>
> On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> > Thanks! but
> > Still has this problem after i modified the resin.conf to :
> >
> > <web-app id='/roller'
> > document-directory="D:\EclipseWin2003\eclipse-
> SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> > ">
> >     <access-log path="logs/access.txt">
> >          <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> > "%{User-Agent}i"</format>
> >          <rollover-period>1D</rollover-period>
> >     </access-log>
> >
> >     <!-- Resin-specific JdbcAuthenticator -->
> >     <login-config>
> >          <auth-method>FORM</auth-method>
> >         <form-login-config>
> >              <form-login-page>/login.jsp</form-login-page>
> >
> > <form-error-page>/loginerror.jsp</form-error-page>
> >         </form-login-config>
> >     </login-config>
> >  </web-app>
> >
> > after click login button,ERROR:
> > Unexpected Exception
> >
> > Roller has encountered and logged an unexpected exception.
> >
> > debug info:
> > [20:14:57.953] Closing dangling connections.  All connections must have
> a
> > close() in a finally block.
> > [20:14:57.968] java.lang.IllegalStateException : Connection
> > UserConnection[com.caucho.sql.ManagedConnectionImpl@484c6b]
> > was not clo
> >
> > sed. Connections must have a close() in a finally block.
> > [20:14:57.968]  at
> > com.caucho.jca.UserTransactionImpl.abortTransaction(
> UserTransactionImpl.java
> > :466)
> > [20:14:57.968]  at
> > com.caucho.jca.UserTransactionProxy.abortTransaction(
> UserTransactionProxy.java:174)
> > [20:14:57.968]  at
> > com.caucho.server.webapp.WebAppFilterChain.doFilter(
> WebAppFilterChain.java:198)
> > [20:14: 57.968]  at
> > com.caucho.server.dispatch.ServletInvocation.service(
> ServletInvocation.java:229)
> > [20:14:57.968]  at
> > com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
> > [20:14:57.968]  at com.caucho.server.port.TcpConnection.run
> > (TcpConnection.java:389)
> > [20:14:57.968]  at
> > com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
> > [20:14:57.968]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > [20:14:57.968]  at java.lang.Thread.run( Thread.java:595)
> >
> >
> > 2006/8/18, Matt Raible <mr...@gmail.com>:
> > > The latest version of Roller uses Acegi for Authentication so you
> > > shouldn't need to modify resin.conf.  The WEB-INF/security.xml has all
> > > the settings in it.
> > >
> > > As far as the log4j problem, you need to modify log4j.properties (in
> > > WEB-INF/classes) to remove the ${catalina.home} variable.
> > >
> > > Matt
> > >
> > > On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> > > > and the resin.conf:
> > > >
> > > > <web-app id='/roller'
> > > >     document-directory="D:\EclipseWin2003\eclipse-
> > > >
> >
> SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> > > > ">
> > > >
> > > >
> > > >
> > > >     <access-log path="logs/access.txt">
> > > >         <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> > > > "%{User-Agent}i"</format>
> > > >         <rollover-period>1D</rollover-period>
> > > >     </access-log>
> > > >
> > > >     <!-- Resin-specific JdbcAuthenticator -->
> > > >     <authenticator
> > type='com.caucho.server.security.JdbcAuthenticator '>
> > > >       <init>
> > > >         <data-source>jdbc/rollerdb</data-source>
> > > >           <password-query>
> > > >             SELECT passphrase FROM rolleruser WHERE username=? and
> > > > userenabled=1
> > > >           </password-query>
> > > >           <cookie-auth-query>
> > > >             SELECT username FROM usercookie WHERE cookie=?
> > > >           </cookie-auth-query>
> > > >           <cookie-auth-update>
> > > >             UPDATE usercookie SET cookieid=? WHERE username=?
> > > >           </cookie-auth-update>
> > > >           <role-query>
> > > >             SELECT rolename FROM userrole r, rolleruser u
> > > >             WHERE r.username=? and r.userid = u.id and
> u.userenabled=1
> > > >           </role-query>
> > > >           <password-digest>none</password-digest>
> > > >       </init>
> > > >     </authenticator>
> > > >
> > > >     <login-config>
> > > >         <auth-method>FORM</auth-method>
> > > >         <form-login-config>
> > > >
> > <form-login-page>/login.jsp</form-login-page>
> > > >
> > <form-error-page>/loginerror.jsp</form-error-page>
> > > >         </form-login-config>
> > > >     </login-config>
> > > > </web-app>
> > > >
> > > >
> > > >
> > > > 2006/8/18, kelvin pang < kevindig@gmail.com>:
> > > > >
> > > > > Hi,Eric,
> > > > > the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
> > > > > however when I start the roller under Tomcat5, there's no problem.
> > > > >
> > > > > 2006/8/18, Eric.Bardoux@sanofipasteur.com
> > <Eric.Bardoux@sanofipasteur.com
> > > > > >:
> > > > >
> > > > > > Hi Kevin,
> > > > > > We need to know more about your config : tomcat? Weblo? Other?
> > > > > > Mysql? Oracle? Other?
> > > > > > Hibernate version.
> > > > > > Eric
> > > > > >
> > > > > > -----Message d'origine-----
> > > > > > De : kelvin pang [mailto: kevindig@gmail.com]
> > > > > > Envoyé : vendredi 18 août 2006 06:58
> > > > > > À : roller-user@incubator.apache.org
> > > > > > Objet : Re: problem: running roller2.3 under resin 3.0
> > > > > >
> > > > > > and this exception alse appears:
> > > > > >
> > > > > > java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
> > > > > >         at
> > java.io.FileOutputStream.openAppend(Native Method)
> > > > > >         at java.io.FileOutputStream .<init>(
> FileOutputStream.java
> > :177)
> > > > > >         at
> > java.io.FileOutputStream.<init>(FileOutputStream.java:102)
> > > > > >         at
> > org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
> > > > > >         at
> > org.apache.log4j.FileAppender.activateOptions(
> > > > > > FileAppender.java
> > > > > > :151)
> > > > > >         at
> > org.apache.log4j.DailyRollingFileAppender.activateOptions (
> > > > > > DailyRollingFileAppender.java:206)
> > > > > >         at
> > org.apache.log4j.config.PropertySetter.activate(
> > > > > > PropertySetter.java:247)
> > > > > >         at
> > org.apache.log4j.config.PropertySetter.setProperties (
> > > > > > PropertySetter.java:123)
> > > > > >         at
> > org.apache.log4j.config.PropertySetter.setProperties(
> > > > > > PropertySetter.java:87)
> > > > > >         at
> > org.apache.log4j.PropertyConfigurator.parseAppender (
> > > > > > PropertyConfigurator.java:645)
> > > > > >         at
> > org.apache.log4j.PropertyConfigurator.parseCategory(
> > > > > > PropertyConfigurator.java:603)
> > > > > >         at
> > org.apache.log4j.PropertyConfigurator.configureRootCategory
> > (
> > > > > > PropertyConfigurator.java :500)
> > > > > >         at
> > org.apache.log4j.PropertyConfigurator.doConfigure(
> > > > > > PropertyConfigurator.java:406)
> > > > > >         at
> > org.apache.log4j.PropertyConfigurator.doConfigure (
> > > > > > PropertyConfigurator.java:432)
> > > > > >         at
> > org.apache.log4j.helpers.OptionConverter.selectAndConfigure
> > (
> > > > > > OptionConverter.java:460)
> > > > > >         at org.apache.log4j.LogManager
> > .<clinit>(LogManager.java:113)
> > > > > >         at
> > org.apache.log4j.Logger.getLogger(Logger.java:94)
> > > > > >         at
> > org.apache.commons.logging.impl.Log4jFactory.getInstance (
> > > > > > Log4jFactory.java:101)
> > > > > >         at
> > org.apache.commons.logging.LogFactory.getLog(LogFactory.java
> > > > > > :351)
> > > > > >         at
> > org.apache.roller.presentation.RollerContext.<clinit>(
> > > > > > RollerContext.java:81)
> > > > > >         at
> > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > > > > > Method)
> > > > > >         at
> > sun.reflect.NativeConstructorAccessorImpl.newInstance (
> > > > > > NativeConstructorAccessorImpl.java:39)
> > > > > >         at
> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance (
> > > > > > DelegatingConstructorAccessorImpl.java:27)
> > > > > >         at
> > java.lang.reflect.Constructor.newInstance(Constructor.java
> > > > > > :494)
> > > > > >         at java.lang.Class.newInstance0(Class.java:350)
> > > > > >         at java.lang.Class.newInstance (Class.java :303)
> > > > > >         at
> > com.caucho.server.webapp.Listener.init(Listener.java:82)
> > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke (
> > > > > > NativeMethodAccessorImpl.java:39)
> > > > > >         at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > > > DelegatingMethodAccessorImpl.java:25)
> > > > > >         at java.lang.reflect.Method.invoke (Method.java:585)
> > > > > >         at com.caucho.config.BeanTypeStrategy.init
> > (
> > > > > > BeanTypeStrategy.java
> > > > > > :316)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureImpl
> > (NodeBuilder.java
> > > > > > :255)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureChildImpl(
> > > > > > NodeBuilder.java
> > > > > > :299)
> > > > > >         at
> > com.caucho.config.BeanTypeStrategy.configure (
> > > > > > BeanTypeStrategy.java:195)
> > > > > >         at
> > com.caucho.config.SetterAttributeStrategy.configure(
> > > > > > SetterAttributeStrategy.java:91)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureAttributeImpl (
> > > > > > NodeBuilder.java :377)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureBeanImpl(
> > > > > > NodeBuilder.java
> > > > > > :337)
> > > > > >         at
> > com.caucho.config.TypeStrategy.configureBean (
> > > > > > TypeStrategy.java
> > > > > > :103)
> > > > > >         at
> > com.caucho.config.BeanTypeStrategy.configureBean (
> > > > > > BeanTypeStrategy.java:226)
> > > > > >         at
> > com.caucho.config.EnvironmentTypeStrategy.configureBean (
> > > > > > EnvironmentTypeStrategy.java:70)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java
> > > > > > :193)
> > > > > >         at com.caucho.config.Config.configureBean
> > (Config.java:272)
> > > > > >         at
> > com.caucho.config.Config.configureBean(Config.java:243)
> > > > > >         at
> > com.caucho.config.core.ResinImport.init(ResinImport.java:134)
> > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > > > >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > > > NativeMethodAccessorImpl.java:39)
> > > > > >         at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke (
> > > > > > DelegatingMethodAccessorImpl.java:25)
> > > > > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > > > > >         at
> > com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> > > > > > :316)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureImpl
> > (NodeBuilder.java
> > > > > > :255)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureChildImpl(
> > > > > > NodeBuilder.java
> > > > > > :299)
> > > > > >         at
> > com.caucho.config.EnvironmentAttributeStrategy.configure(
> > > > > > EnvironmentAttributeStrategy.java:56)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > > > > NodeBuilder.java:377)
> > > > > >         at
> > com.caucho.config.TypeStrategy.configureAttribute(
> > > > > > TypeStrategy.java:112)
> > > > > >         at
> > com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> > > > > > EnvironmentTypeStrategy.java:89)
> > > > > >         at
> > com.caucho.config.NodeBuilder.configureAttribute(
> > > > > > NodeBuilder.java
> > > > > > :226)
> > > > > >         at
> > com.caucho.config.NodeBuilderChildProgram.configureImpl(
> > > > > > NodeBuilderChildProgram.java :54)
> > > > > >         at
> > com.caucho.config.BuilderProgramContainer.configureImpl (
> > > > > > BuilderProgramContainer.java:62)
> > > > > >         at
> > com.caucho.config.BuilderProgram.configure(
> > > > > > BuilderProgram.java
> > > > > > :60)
> > > > > >         at
> > > > > >
> > com.caucho.server.deploy.EnvironmentDeployController.configureInstance
> > (
> > > > > > EnvironmentDeployController.java:416)
> > > > > >         at
> > > > > >
> > com.caucho.server.deploy.EnvironmentDeployController.configureInstance
> > (
> > > > > > EnvironmentDeployController.java:80)
> > > > > >         at
> > com.caucho.server.deploy.DeployController.startImpl (
> > > > > > DeployController.java:585)
> > > > > >
> > > > > > 2006/8/18, kelvin pang < kevindig@gmail.com>:
> > > > > > >
> > > > > > > when I try to login,the following exception occur:
> > > > > > >
> > > > > > > java.sql.SQLException : Unknown column 'userenabled' in 'where
> > clause'
> > > > > > >         at
> > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
> > > > > > >         at com.mysql.jdbc.MysqlIO.sendCommand
> > (MysqlIO.java :1167)
> > > > > > >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect
> > (MysqlIO.java:1278)
> > > > > > >         at
> > com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> > > > > > >         at
> > com.mysql.jdbc.PreparedStatement.executeQuery(
> > > > > > > PreparedStatement.java:1586)
> > > > > > >         at
> > com.caucho.sql.UserPreparedStatement.executeQuery (
> > > > > > > UserPreparedStatement.java :108)
> > > > > > >         at
> > com.caucho.sql.UserPreparedStatement.executeQuery(
> > > > > > > UserPreparedStatement.java:108)
> > > > > > >         at
> > com.caucho.server.security.JdbcAuthenticator.loginImpl (
> > > > > > > JdbcAuthenticator.java:394)
> > > > > > >         at
> > com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > > > > > JdbcAuthenticator.java:322)
> > > > > > >         at
> > com.caucho.server.security.AbstractAuthenticator.login (
> > > > > > > AbstractAuthenticator.java:212)
> > > > > > >         at
> > com.caucho.server.security.FormLoginServlet.service(
> > > > > > > FormLoginServlet.java:76)
> > > > > > >         at
> > com.caucho.server.dispatch.ServletFilterChain.doFilter (
> > > > > > > ServletFilterChain.java:106)
> > > > > > >         at
> > com.caucho.server.webapp.NamedDispatcherImpl.forward (
> > > > > > > NamedDispatcherImpl.java:119)
> > > > > > >         at
> > com.caucho.server.dispatch.ForwardFilterChain.doFilter (
> > > > > > > ForwardFilterChain.java:74)
> > > > > > >         at
> > com.caucho.server.cache.CacheFilterChain.doFilter (
> > > > > > > CacheFilterChain.java:188)
> > > > > > >         at
> > com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > > > > > > WebAppFilterChain.java :178)
> > > > > > >         at
> > com.caucho.server.dispatch.ServletInvocation.service(
> > > > > > > ServletInvocation.java:229)
> > > > > > >         at
> > com.caucho.server.http.HttpRequest.handleRequest (
> > > > > > > HttpRequest.java :268)
> > > > > > >         at
> > com.caucho.server.port.TcpConnection.run(TcpConnection.java
> > > > > > > :389)
> > > > > > >         at com.caucho.util.ThreadPool.runTasks
> > (ThreadPool.java:492)
> > > > > > >         at com.caucho.util.ThreadPool.run (ThreadPool.java
> :425)
> > > > > > >         at java.lang.Thread.run(Thread.java:595)
> > > > > > > [12:38:52.375] Closing dangling connections.  All connections
> must
> > > > > > > have a
> > > > > > > close() in a finally block.
> > > > > > > [12:38:52.375 ] java.lang.IllegalStateException: Connection
> > > > > > > UserConnection[
> > com.caucho.sql.ManagedConnectionImpl@8b1323 ] was not
> > > > > > > clo sed. Connections must have a close() in a finally block.
> > > > > > > [12:38:52.375]  at
> > com.caucho.jca.UserTransactionImpl.abortTransaction
> > > > > > > (
> > > > > > > UserTransactionImpl.java:466)
> > > > > > > [12:38:52.375]  at
> > > > > > >
> > com.caucho.jca.UserTransactionProxy.abortTransaction(
> > > > > > > UserTransactionProxy.java:174)
> > > > > > > [12:38: 52.375]  at
> > > > > > >
> > com.caucho.server.webapp.WebAppFilterChain.doFilter (
> > > > > > > WebAppFilterChain.java :198)
> > > > > > > [12:38:52.375]  at
> > > > > > >
> > com.caucho.server.dispatch.ServletInvocation.service (
> > > > > > > ServletInvocation.java:229)
> > > > > > > [12:38:52.375]  at
> > com.caucho.server.http.HttpRequest.handleRequest (
> > > > > > > HttpRequest.java:268)
> > > > > > > [12:38: 52.375]  at
> > com.caucho.server.port.TcpConnection.run(
> > > > > > > TcpConnection.java:389)
> > > > > > > [12:38:52.375]  at
> > com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> > > > > > > :492)
> > > > > > > [12:38:52.375]  at
> > com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > > > > > > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> > > > > > >
> > > > > > > --
> > > > > > > kevin
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > kevin
> > > > > >
> >
> -------------------------------------------------------------------------------------------
> > > > > >
> > > > > > "Cette communication (y compris les pieces jointes) est reservee
> a
> > > > > > l'usage exclusif du destinataire (des destinataires) et peut
> > contenir des
> > > > > > informations privilegiees, confidentielles, exemptees de
> divulgation
> > selon
> > > > > > la loi ou protegees par les droits d'auteur. Si vous n'etes pas
> un
> > > > > > destinataire, toute utilisation, divulgation, distribution,
> > reproduction,
> > > > > > examen ou copie (totale ou partielle) est non-autorisee et peut
> etre
> > > > > > illegale. Tout message electronique est susceptible d'alteration
> et
> > son
> > > > > > integrite ne peut etre assuree. Sanofi Pasteur decline toute
> > responsabilite
> > > > > > au titre de ce message s'il a ete modifie ou falsifie. Si vous
> > n'etes pas
> > > > > > destinataire de ce message, merci de le detruire immediatement
> et
> > d'avertir
> > > > > > l'expediteur de l'erreur de distribution et de la destruction du
> > message.
> > > > > > Merci.
> > > > > > This transmission (including any attachments) is intended solely
> for
> > the
> > > > > > use of the addressee(s) and may contain confidential information
> > including
> > > > > > trade secrets which are privileged, confidential, exempt from
> > disclosure
> > > > > > under applicable law and/or subject to copyright. If you are not
> an
> > intended
> > > > > > recipient, any use, disclosure, distribution, reproduction,
> review
> > or
> > > > > > copying (either whole or partial) is unauthorized and may be
> > unlawful.
> > > > > > E-mails are susceptible to alteration and their integrity cannot
> be
> > > > > > guaranteed.Sanofi Pasteur shall not be liable for this e-mail if
> > > > > > modified or falsified. If you are not the intended recipient of
> this
> > e-mail,
> > > > > > please delete it immediately from your system and notify the
> sender
> > of the
> > > > > > wrong delivery and the mail deletion. Thank you."
> > > > > >
> > **********************************************************************
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > kevin
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > kevin
> > > >
> > >
> >
> >
> >
> >
> > --
> > kevin
>



-- 
kevin

Re: problem: running roller2.3 under resin 3.0

Posted by Matt Raible <mr...@gmail.com>.

Is there a security.xml in your WEB-INF folder?  If so, you don't need
any security-related settings in resin.conf - just datasource
settings.

Matt

On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> Thanks! but
> Still has this problem after i modified the resin.conf to :
>
> <web-app id='/roller'
> document-directory="D:\EclipseWin2003\eclipse-SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> ">
>     <access-log path="logs/access.txt">
>          <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> "%{User-Agent}i"</format>
>          <rollover-period>1D</rollover-period>
>     </access-log>
>
>     <!-- Resin-specific JdbcAuthenticator -->
>     <login-config>
>          <auth-method>FORM</auth-method>
>         <form-login-config>
>              <form-login-page>/login.jsp</form-login-page>
>
> <form-error-page>/loginerror.jsp</form-error-page>
>         </form-login-config>
>     </login-config>
>  </web-app>
>
> after click login button,ERROR:
> Unexpected Exception
>
> Roller has encountered and logged an unexpected exception.
>
> debug info:
> [20:14:57.953] Closing dangling connections.  All connections must have a
> close() in a finally block.
> [20:14:57.968] java.lang.IllegalStateException : Connection
> UserConnection[com.caucho.sql.ManagedConnectionImpl@484c6b]
> was not clo
>
> sed. Connections must have a close() in a finally block.
> [20:14:57.968]  at
> com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java
> :466)
> [20:14:57.968]  at
> com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:174)
> [20:14:57.968]  at
> com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:198)
> [20:14: 57.968]  at
> com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
> [20:14:57.968]  at
> com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
> [20:14:57.968]  at com.caucho.server.port.TcpConnection.run
> (TcpConnection.java:389)
> [20:14:57.968]  at
> com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
> [20:14:57.968]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> [20:14:57.968]  at java.lang.Thread.run( Thread.java:595)
>
>
> 2006/8/18, Matt Raible <mr...@gmail.com>:
> > The latest version of Roller uses Acegi for Authentication so you
> > shouldn't need to modify resin.conf.  The WEB-INF/security.xml has all
> > the settings in it.
> >
> > As far as the log4j problem, you need to modify log4j.properties (in
> > WEB-INF/classes) to remove the ${catalina.home} variable.
> >
> > Matt
> >
> > On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> > > and the resin.conf:
> > >
> > > <web-app id='/roller'
> > >     document-directory="D:\EclipseWin2003\eclipse-
> > >
> SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> > > ">
> > >
> > >
> > >
> > >     <access-log path="logs/access.txt">
> > >         <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> > > "%{User-Agent}i"</format>
> > >         <rollover-period>1D</rollover-period>
> > >     </access-log>
> > >
> > >     <!-- Resin-specific JdbcAuthenticator -->
> > >     <authenticator
> type='com.caucho.server.security.JdbcAuthenticator '>
> > >       <init>
> > >         <data-source>jdbc/rollerdb</data-source>
> > >           <password-query>
> > >             SELECT passphrase FROM rolleruser WHERE username=? and
> > > userenabled=1
> > >           </password-query>
> > >           <cookie-auth-query>
> > >             SELECT username FROM usercookie WHERE cookie=?
> > >           </cookie-auth-query>
> > >           <cookie-auth-update>
> > >             UPDATE usercookie SET cookieid=? WHERE username=?
> > >           </cookie-auth-update>
> > >           <role-query>
> > >             SELECT rolename FROM userrole r, rolleruser u
> > >             WHERE r.username=? and r.userid = u.id and u.userenabled=1
> > >           </role-query>
> > >           <password-digest>none</password-digest>
> > >       </init>
> > >     </authenticator>
> > >
> > >     <login-config>
> > >         <auth-method>FORM</auth-method>
> > >         <form-login-config>
> > >
> <form-login-page>/login.jsp</form-login-page>
> > >
> <form-error-page>/loginerror.jsp</form-error-page>
> > >         </form-login-config>
> > >     </login-config>
> > > </web-app>
> > >
> > >
> > >
> > > 2006/8/18, kelvin pang < kevindig@gmail.com>:
> > > >
> > > > Hi,Eric,
> > > > the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
> > > > however when I start the roller under Tomcat5, there's no problem.
> > > >
> > > > 2006/8/18, Eric.Bardoux@sanofipasteur.com
> <Eric.Bardoux@sanofipasteur.com
> > > > >:
> > > >
> > > > > Hi Kevin,
> > > > > We need to know more about your config : tomcat? Weblo? Other?
> > > > > Mysql? Oracle? Other?
> > > > > Hibernate version.
> > > > > Eric
> > > > >
> > > > > -----Message d'origine-----
> > > > > De : kelvin pang [mailto: kevindig@gmail.com]
> > > > > Envoyé : vendredi 18 août 2006 06:58
> > > > > À : roller-user@incubator.apache.org
> > > > > Objet : Re: problem: running roller2.3 under resin 3.0
> > > > >
> > > > > and this exception alse appears:
> > > > >
> > > > > java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
> > > > >         at
> java.io.FileOutputStream.openAppend(Native Method)
> > > > >         at java.io.FileOutputStream .<init>(FileOutputStream.java
> :177)
> > > > >         at
> java.io.FileOutputStream.<init>(FileOutputStream.java:102)
> > > > >         at
> org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
> > > > >         at
> org.apache.log4j.FileAppender.activateOptions(
> > > > > FileAppender.java
> > > > > :151)
> > > > >         at
> org.apache.log4j.DailyRollingFileAppender.activateOptions (
> > > > > DailyRollingFileAppender.java:206)
> > > > >         at
> org.apache.log4j.config.PropertySetter.activate(
> > > > > PropertySetter.java:247)
> > > > >         at
> org.apache.log4j.config.PropertySetter.setProperties (
> > > > > PropertySetter.java:123)
> > > > >         at
> org.apache.log4j.config.PropertySetter.setProperties(
> > > > > PropertySetter.java:87)
> > > > >         at
> org.apache.log4j.PropertyConfigurator.parseAppender (
> > > > > PropertyConfigurator.java:645)
> > > > >         at
> org.apache.log4j.PropertyConfigurator.parseCategory(
> > > > > PropertyConfigurator.java:603)
> > > > >         at
> org.apache.log4j.PropertyConfigurator.configureRootCategory
> (
> > > > > PropertyConfigurator.java :500)
> > > > >         at
> org.apache.log4j.PropertyConfigurator.doConfigure(
> > > > > PropertyConfigurator.java:406)
> > > > >         at
> org.apache.log4j.PropertyConfigurator.doConfigure (
> > > > > PropertyConfigurator.java:432)
> > > > >         at
> org.apache.log4j.helpers.OptionConverter.selectAndConfigure
> (
> > > > > OptionConverter.java:460)
> > > > >         at org.apache.log4j.LogManager
> .<clinit>(LogManager.java:113)
> > > > >         at
> org.apache.log4j.Logger.getLogger(Logger.java:94)
> > > > >         at
> org.apache.commons.logging.impl.Log4jFactory.getInstance (
> > > > > Log4jFactory.java:101)
> > > > >         at
> org.apache.commons.logging.LogFactory.getLog(LogFactory.java
> > > > > :351)
> > > > >         at
> org.apache.roller.presentation.RollerContext.<clinit>(
> > > > > RollerContext.java:81)
> > > > >         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > > > > Method)
> > > > >         at
> sun.reflect.NativeConstructorAccessorImpl.newInstance (
> > > > > NativeConstructorAccessorImpl.java:39)
> > > > >         at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance (
> > > > > DelegatingConstructorAccessorImpl.java:27)
> > > > >         at
> java.lang.reflect.Constructor.newInstance(Constructor.java
> > > > > :494)
> > > > >         at java.lang.Class.newInstance0(Class.java:350)
> > > > >         at java.lang.Class.newInstance (Class.java :303)
> > > > >         at
> com.caucho.server.webapp.Listener.init(Listener.java:82)
> > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke (
> > > > > NativeMethodAccessorImpl.java:39)
> > > > >         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > > DelegatingMethodAccessorImpl.java:25)
> > > > >         at java.lang.reflect.Method.invoke (Method.java:585)
> > > > >         at com.caucho.config.BeanTypeStrategy.init
> (
> > > > > BeanTypeStrategy.java
> > > > > :316)
> > > > >         at
> com.caucho.config.NodeBuilder.configureImpl
> (NodeBuilder.java
> > > > > :255)
> > > > >         at
> com.caucho.config.NodeBuilder.configureChildImpl(
> > > > > NodeBuilder.java
> > > > > :299)
> > > > >         at
> com.caucho.config.BeanTypeStrategy.configure (
> > > > > BeanTypeStrategy.java:195)
> > > > >         at
> com.caucho.config.SetterAttributeStrategy.configure(
> > > > > SetterAttributeStrategy.java:91)
> > > > >         at
> com.caucho.config.NodeBuilder.configureAttributeImpl (
> > > > > NodeBuilder.java :377)
> > > > >         at
> com.caucho.config.NodeBuilder.configureBeanImpl(
> > > > > NodeBuilder.java
> > > > > :337)
> > > > >         at
> com.caucho.config.TypeStrategy.configureBean (
> > > > > TypeStrategy.java
> > > > > :103)
> > > > >         at
> com.caucho.config.BeanTypeStrategy.configureBean (
> > > > > BeanTypeStrategy.java:226)
> > > > >         at
> com.caucho.config.EnvironmentTypeStrategy.configureBean (
> > > > > EnvironmentTypeStrategy.java:70)
> > > > >         at
> com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java
> > > > > :193)
> > > > >         at com.caucho.config.Config.configureBean
> (Config.java:272)
> > > > >         at
> com.caucho.config.Config.configureBean(Config.java:243)
> > > > >         at
> com.caucho.config.core.ResinImport.init(ResinImport.java:134)
> > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > > >         at
> sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > > NativeMethodAccessorImpl.java:39)
> > > > >         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke (
> > > > > DelegatingMethodAccessorImpl.java:25)
> > > > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > > > >         at
> com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> > > > > :316)
> > > > >         at
> com.caucho.config.NodeBuilder.configureImpl
> (NodeBuilder.java
> > > > > :255)
> > > > >         at
> com.caucho.config.NodeBuilder.configureChildImpl(
> > > > > NodeBuilder.java
> > > > > :299)
> > > > >         at
> com.caucho.config.EnvironmentAttributeStrategy.configure(
> > > > > EnvironmentAttributeStrategy.java:56)
> > > > >         at
> com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > > > NodeBuilder.java:377)
> > > > >         at
> com.caucho.config.TypeStrategy.configureAttribute(
> > > > > TypeStrategy.java:112)
> > > > >         at
> com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> > > > > EnvironmentTypeStrategy.java:89)
> > > > >         at
> com.caucho.config.NodeBuilder.configureAttribute(
> > > > > NodeBuilder.java
> > > > > :226)
> > > > >         at
> com.caucho.config.NodeBuilderChildProgram.configureImpl(
> > > > > NodeBuilderChildProgram.java :54)
> > > > >         at
> com.caucho.config.BuilderProgramContainer.configureImpl (
> > > > > BuilderProgramContainer.java:62)
> > > > >         at
> com.caucho.config.BuilderProgram.configure(
> > > > > BuilderProgram.java
> > > > > :60)
> > > > >         at
> > > > >
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance
> (
> > > > > EnvironmentDeployController.java:416)
> > > > >         at
> > > > >
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance
> (
> > > > > EnvironmentDeployController.java:80)
> > > > >         at
> com.caucho.server.deploy.DeployController.startImpl (
> > > > > DeployController.java:585)
> > > > >
> > > > > 2006/8/18, kelvin pang < kevindig@gmail.com>:
> > > > > >
> > > > > > when I try to login,the following exception occur:
> > > > > >
> > > > > > java.sql.SQLException : Unknown column 'userenabled' in 'where
> clause'
> > > > > >         at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
> > > > > >         at com.mysql.jdbc.MysqlIO.sendCommand
> (MysqlIO.java :1167)
> > > > > >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect
> (MysqlIO.java:1278)
> > > > > >         at
> com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> > > > > >         at
> com.mysql.jdbc.PreparedStatement.executeQuery(
> > > > > > PreparedStatement.java:1586)
> > > > > >         at
> com.caucho.sql.UserPreparedStatement.executeQuery (
> > > > > > UserPreparedStatement.java :108)
> > > > > >         at
> com.caucho.sql.UserPreparedStatement.executeQuery(
> > > > > > UserPreparedStatement.java:108)
> > > > > >         at
> com.caucho.server.security.JdbcAuthenticator.loginImpl (
> > > > > > JdbcAuthenticator.java:394)
> > > > > >         at
> com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > > > > JdbcAuthenticator.java:322)
> > > > > >         at
> com.caucho.server.security.AbstractAuthenticator.login (
> > > > > > AbstractAuthenticator.java:212)
> > > > > >         at
> com.caucho.server.security.FormLoginServlet.service(
> > > > > > FormLoginServlet.java:76)
> > > > > >         at
> com.caucho.server.dispatch.ServletFilterChain.doFilter (
> > > > > > ServletFilterChain.java:106)
> > > > > >         at
> com.caucho.server.webapp.NamedDispatcherImpl.forward (
> > > > > > NamedDispatcherImpl.java:119)
> > > > > >         at
> com.caucho.server.dispatch.ForwardFilterChain.doFilter (
> > > > > > ForwardFilterChain.java:74)
> > > > > >         at
> com.caucho.server.cache.CacheFilterChain.doFilter (
> > > > > > CacheFilterChain.java:188)
> > > > > >         at
> com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > > > > > WebAppFilterChain.java :178)
> > > > > >         at
> com.caucho.server.dispatch.ServletInvocation.service(
> > > > > > ServletInvocation.java:229)
> > > > > >         at
> com.caucho.server.http.HttpRequest.handleRequest (
> > > > > > HttpRequest.java :268)
> > > > > >         at
> com.caucho.server.port.TcpConnection.run(TcpConnection.java
> > > > > > :389)
> > > > > >         at com.caucho.util.ThreadPool.runTasks
> (ThreadPool.java:492)
> > > > > >         at com.caucho.util.ThreadPool.run (ThreadPool.java:425)
> > > > > >         at java.lang.Thread.run(Thread.java:595)
> > > > > > [12:38:52.375] Closing dangling connections.  All connections must
> > > > > > have a
> > > > > > close() in a finally block.
> > > > > > [12:38:52.375 ] java.lang.IllegalStateException: Connection
> > > > > > UserConnection[
> com.caucho.sql.ManagedConnectionImpl@8b1323 ] was not
> > > > > > clo sed. Connections must have a close() in a finally block.
> > > > > > [12:38:52.375]  at
> com.caucho.jca.UserTransactionImpl.abortTransaction
> > > > > > (
> > > > > > UserTransactionImpl.java:466)
> > > > > > [12:38:52.375]  at
> > > > > >
> com.caucho.jca.UserTransactionProxy.abortTransaction(
> > > > > > UserTransactionProxy.java:174)
> > > > > > [12:38: 52.375]  at
> > > > > >
> com.caucho.server.webapp.WebAppFilterChain.doFilter (
> > > > > > WebAppFilterChain.java :198)
> > > > > > [12:38:52.375]  at
> > > > > >
> com.caucho.server.dispatch.ServletInvocation.service (
> > > > > > ServletInvocation.java:229)
> > > > > > [12:38:52.375]  at
> com.caucho.server.http.HttpRequest.handleRequest (
> > > > > > HttpRequest.java:268)
> > > > > > [12:38: 52.375]  at
> com.caucho.server.port.TcpConnection.run(
> > > > > > TcpConnection.java:389)
> > > > > > [12:38:52.375]  at
> com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> > > > > > :492)
> > > > > > [12:38:52.375]  at
> com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > > > > > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> > > > > >
> > > > > > --
> > > > > > kevin
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > kevin
> > > > >
> -------------------------------------------------------------------------------------------
> > > > >
> > > > > "Cette communication (y compris les pieces jointes) est reservee a
> > > > > l'usage exclusif du destinataire (des destinataires) et peut
> contenir des
> > > > > informations privilegiees, confidentielles, exemptees de divulgation
> selon
> > > > > la loi ou protegees par les droits d'auteur. Si vous n'etes pas un
> > > > > destinataire, toute utilisation, divulgation, distribution,
> reproduction,
> > > > > examen ou copie (totale ou partielle) est non-autorisee et peut etre
> > > > > illegale. Tout message electronique est susceptible d'alteration et
> son
> > > > > integrite ne peut etre assuree. Sanofi Pasteur decline toute
> responsabilite
> > > > > au titre de ce message s'il a ete modifie ou falsifie. Si vous
> n'etes pas
> > > > > destinataire de ce message, merci de le detruire immediatement et
> d'avertir
> > > > > l'expediteur de l'erreur de distribution et de la destruction du
> message.
> > > > > Merci.
> > > > > This transmission (including any attachments) is intended solely for
> the
> > > > > use of the addressee(s) and may contain confidential information
> including
> > > > > trade secrets which are privileged, confidential, exempt from
> disclosure
> > > > > under applicable law and/or subject to copyright. If you are not an
> intended
> > > > > recipient, any use, disclosure, distribution, reproduction, review
> or
> > > > > copying (either whole or partial) is unauthorized and may be
> unlawful.
> > > > > E-mails are susceptible to alteration and their integrity cannot be
> > > > > guaranteed.Sanofi Pasteur shall not be liable for this e-mail if
> > > > > modified or falsified. If you are not the intended recipient of this
> e-mail,
> > > > > please delete it immediately from your system and notify the sender
> of the
> > > > > wrong delivery and the mail deletion. Thank you."
> > > > >
> **********************************************************************
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > kevin
> > > >
> > >
> > >
> > >
> > > --
> > > kevin
> > >
> >
>
>
>
>
> --
> kevin

Re: problem: running roller2.3 under resin 3.0

Posted by kelvin pang <ke...@gmail.com>.

Thanks! but
Still has this problem after i modified the resin.conf to :
<web-app id='/roller'     document-directory="D:\EclipseWin2003\eclipse-
SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller">

    <access-log path="logs/access.txt">
        <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
"%{User-Agent}i"</format>
        <rollover-period>1D</rollover-period>
    </access-log>

    <!-- Resin-specific JdbcAuthenticator -->
    <login-config>
        <auth-method>FORM</auth-method>
        <form-login-config>
            <form-login-page>/login.jsp</form-login-page>
            <form-error-page>/loginerror.jsp</form-error-page>
        </form-login-config>
    </login-config>
</web-app>

after click login button,ERROR:
Unexpected Exception

Roller has encountered and logged an unexpected exception.

debug info:
[20:14:57.953] Closing dangling connections.  All connections must have a
close() in a finally block.
[20:14:57.968] java.lang.IllegalStateException: Connection UserConnection[
com.caucho.sql.ManagedConnectionImpl@484c6b] was not clo
sed. Connections must have a close() in a finally block.
[20:14:57.968]  at com.caucho.jca.UserTransactionImpl.abortTransaction(
UserTransactionImpl.java:466)
[20:14:57.968]  at com.caucho.jca.UserTransactionProxy.abortTransaction(
UserTransactionProxy.java:174)
[20:14:57.968]  at com.caucho.server.webapp.WebAppFilterChain.doFilter(
WebAppFilterChain.java:198)
[20:14:57.968]  at com.caucho.server.dispatch.ServletInvocation.service(
ServletInvocation.java:229)
[20:14:57.968]  at com.caucho.server.http.HttpRequest.handleRequest(
HttpRequest.java:268)
[20:14:57.968]  at com.caucho.server.port.TcpConnection.run(
TcpConnection.java:389)
[20:14:57.968]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[20:14:57.968]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[20:14:57.968]  at java.lang.Thread.run(Thread.java:595)


2006/8/18, Matt Raible <mr...@gmail.com>:
>
> The latest version of Roller uses Acegi for Authentication so you
> shouldn't need to modify resin.conf.  The WEB-INF/security.xml has all
> the settings in it.
>
> As far as the log4j problem, you need to modify log4j.properties (in
> WEB-INF/classes) to remove the ${catalina.home} variable.
>
> Matt
>
> On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> > and the resin.conf:
> >
> > <web-app id='/roller'
> >     document-directory="D:\EclipseWin2003\eclipse-
> >
> SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> > ">
> >
> >
> >
> >     <access-log path="logs/access.txt">
> >         <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> > "%{User-Agent}i"</format>
> >         <rollover-period>1D</rollover-period>
> >     </access-log>
> >
> >     <!-- Resin-specific JdbcAuthenticator -->
> >     <authenticator type='com.caucho.server.security.JdbcAuthenticator'>
> >       <init>
> >         <data-source>jdbc/rollerdb</data-source>
> >           <password-query>
> >             SELECT passphrase FROM rolleruser WHERE username=? and
> > userenabled=1
> >           </password-query>
> >           <cookie-auth-query>
> >             SELECT username FROM usercookie WHERE cookie=?
> >           </cookie-auth-query>
> >           <cookie-auth-update>
> >             UPDATE usercookie SET cookieid=? WHERE username=?
> >           </cookie-auth-update>
> >           <role-query>
> >             SELECT rolename FROM userrole r, rolleruser u
> >             WHERE r.username=? and r.userid = u.id and u.userenabled=1
> >           </role-query>
> >           <password-digest>none</password-digest>
> >       </init>
> >     </authenticator>
> >
> >     <login-config>
> >         <auth-method>FORM</auth-method>
> >         <form-login-config>
> >             <form-login-page>/login.jsp</form-login-page>
> >             <form-error-page>/loginerror.jsp</form-error-page>
> >         </form-login-config>
> >     </login-config>
> > </web-app>
> >
> >
> >
> > 2006/8/18, kelvin pang <ke...@gmail.com>:
> > >
> > > Hi,Eric,
> > > the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
> > > however when I start the roller under Tomcat5, there's no problem.
> > >
> > > 2006/8/18, Eric.Bardoux@sanofipasteur.com <
> Eric.Bardoux@sanofipasteur.com
> > > >:
> > >
> > > > Hi Kevin,
> > > > We need to know more about your config : tomcat? Weblo? Other?
> > > > Mysql? Oracle? Other?
> > > > Hibernate version.
> > > > Eric
> > > >
> > > > -----Message d'origine-----
> > > > De : kelvin pang [mailto: kevindig@gmail.com]
> > > > Envoyé : vendredi 18 août 2006 06:58
> > > > À : roller-user@incubator.apache.org
> > > > Objet : Re: problem: running roller2.3 under resin 3.0
> > > >
> > > > and this exception alse appears:
> > > >
> > > > java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
> > > >         at java.io.FileOutputStream.openAppend(Native Method)
> > > >         at java.io.FileOutputStream.<init>(FileOutputStream.java:177)
> > > >         at java.io.FileOutputStream.<init>(FileOutputStream.java
> :102)
> > > >         at org.apache.log4j.FileAppender.setFile(FileAppender.java
> :272)
> > > >         at org.apache.log4j.FileAppender.activateOptions(
> > > > FileAppender.java
> > > > :151)
> > > >         at org.apache.log4j.DailyRollingFileAppender.activateOptions
> (
> > > > DailyRollingFileAppender.java:206)
> > > >         at org.apache.log4j.config.PropertySetter.activate(
> > > > PropertySetter.java:247)
> > > >         at org.apache.log4j.config.PropertySetter.setProperties(
> > > > PropertySetter.java:123)
> > > >         at org.apache.log4j.config.PropertySetter.setProperties(
> > > > PropertySetter.java:87)
> > > >         at org.apache.log4j.PropertyConfigurator.parseAppender (
> > > > PropertyConfigurator.java:645)
> > > >         at org.apache.log4j.PropertyConfigurator.parseCategory(
> > > > PropertyConfigurator.java:603)
> > > >         at
> org.apache.log4j.PropertyConfigurator.configureRootCategory(
> > > > PropertyConfigurator.java :500)
> > > >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > > > PropertyConfigurator.java:406)
> > > >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > > > PropertyConfigurator.java:432)
> > > >         at
> org.apache.log4j.helpers.OptionConverter.selectAndConfigure (
> > > > OptionConverter.java:460)
> > > >         at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
> > > >         at org.apache.log4j.Logger.getLogger(Logger.java:94)
> > > >         at org.apache.commons.logging.impl.Log4jFactory.getInstance(
> > > > Log4jFactory.java:101)
> > > >         at org.apache.commons.logging.LogFactory.getLog(
> LogFactory.java
> > > > :351)
> > > >         at org.apache.roller.presentation.RollerContext.<clinit>(
> > > > RollerContext.java:81)
> > > >         at sun.reflect.NativeConstructorAccessorImpl.newInstance0
> (Native
> > > > Method)
> > > >         at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> > > > NativeConstructorAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
> > > > DelegatingConstructorAccessorImpl.java:27)
> > > >         at java.lang.reflect.Constructor.newInstance(
> Constructor.java
> > > > :494)
> > > >         at java.lang.Class.newInstance0(Class.java:350)
> > > >         at java.lang.Class.newInstance (Class.java:303)
> > > >         at com.caucho.server.webapp.Listener.init(Listener.java:82)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > NativeMethodAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > DelegatingMethodAccessorImpl.java:25)
> > > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > > >         at com.caucho.config.BeanTypeStrategy.init (
> > > > BeanTypeStrategy.java
> > > > :316)
> > > >         at com.caucho.config.NodeBuilder.configureImpl(
> NodeBuilder.java
> > > > :255)
> > > >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > > > NodeBuilder.java
> > > > :299)
> > > >         at com.caucho.config.BeanTypeStrategy.configure (
> > > > BeanTypeStrategy.java:195)
> > > >         at com.caucho.config.SetterAttributeStrategy.configure(
> > > > SetterAttributeStrategy.java:91)
> > > >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > > NodeBuilder.java :377)
> > > >         at com.caucho.config.NodeBuilder.configureBeanImpl(
> > > > NodeBuilder.java
> > > > :337)
> > > >         at com.caucho.config.TypeStrategy.configureBean(
> > > > TypeStrategy.java
> > > > :103)
> > > >         at com.caucho.config.BeanTypeStrategy.configureBean (
> > > > BeanTypeStrategy.java:226)
> > > >         at com.caucho.config.EnvironmentTypeStrategy.configureBean(
> > > > EnvironmentTypeStrategy.java:70)
> > > >         at com.caucho.config.NodeBuilder.configureBean(
> NodeBuilder.java
> > > > :193)
> > > >         at com.caucho.config.Config.configureBean(Config.java:272)
> > > >         at com.caucho.config.Config.configureBean(Config.java:243)
> > > >         at com.caucho.config.core.ResinImport.init(ResinImport.java
> :134)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > NativeMethodAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > DelegatingMethodAccessorImpl.java:25)
> > > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > > >         at com.caucho.config.BeanTypeStrategy.init(
> BeanTypeStrategy.java
> > > > :316)
> > > >         at com.caucho.config.NodeBuilder.configureImpl (
> NodeBuilder.java
> > > > :255)
> > > >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > > > NodeBuilder.java
> > > > :299)
> > > >         at com.caucho.config.EnvironmentAttributeStrategy.configure(
> > > > EnvironmentAttributeStrategy.java:56)
> > > >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > > NodeBuilder.java:377)
> > > >         at com.caucho.config.TypeStrategy.configureAttribute(
> > > > TypeStrategy.java:112)
> > > >         at
> com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> > > > EnvironmentTypeStrategy.java:89)
> > > >         at com.caucho.config.NodeBuilder.configureAttribute(
> > > > NodeBuilder.java
> > > > :226)
> > > >         at com.caucho.config.NodeBuilderChildProgram.configureImpl(
> > > > NodeBuilderChildProgram.java :54)
> > > >         at com.caucho.config.BuilderProgramContainer.configureImpl(
> > > > BuilderProgramContainer.java:62)
> > > >         at com.caucho.config.BuilderProgram.configure(
> > > > BuilderProgram.java
> > > > :60)
> > > >         at
> > > >
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance (
> > > > EnvironmentDeployController.java:416)
> > > >         at
> > > >
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
> > > > EnvironmentDeployController.java:80)
> > > >         at com.caucho.server.deploy.DeployController.startImpl (
> > > > DeployController.java:585)
> > > >
> > > > 2006/8/18, kelvin pang <ke...@gmail.com>:
> > > > >
> > > > > when I try to login,the following exception occur:
> > > > >
> > > > > java.sql.SQLException : Unknown column 'userenabled' in 'where
> clause'
> > > > >         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java
> :1997)
> > > > >         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
> > > > >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java
> :1278)
> > > > >         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> > > > >         at com.mysql.jdbc.PreparedStatement.executeQuery(
> > > > > PreparedStatement.java:1586)
> > > > >         at com.caucho.sql.UserPreparedStatement.executeQuery (
> > > > > UserPreparedStatement.java:108)
> > > > >         at com.caucho.sql.UserPreparedStatement.executeQuery(
> > > > > UserPreparedStatement.java:108)
> > > > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > > > JdbcAuthenticator.java:394)
> > > > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > > > JdbcAuthenticator.java:322)
> > > > >         at com.caucho.server.security.AbstractAuthenticator.login(
> > > > > AbstractAuthenticator.java:212)
> > > > >         at com.caucho.server.security.FormLoginServlet.service(
> > > > > FormLoginServlet.java:76)
> > > > >         at com.caucho.server.dispatch.ServletFilterChain.doFilter(
> > > > > ServletFilterChain.java:106)
> > > > >         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> > > > > NamedDispatcherImpl.java:119)
> > > > >         at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
> > > > > ForwardFilterChain.java:74)
> > > > >         at com.caucho.server.cache.CacheFilterChain.doFilter (
> > > > > CacheFilterChain.java:188)
> > > > >         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > > > > WebAppFilterChain.java:178)
> > > > >         at com.caucho.server.dispatch.ServletInvocation.service(
> > > > > ServletInvocation.java:229)
> > > > >         at com.caucho.server.http.HttpRequest.handleRequest(
> > > > > HttpRequest.java :268)
> > > > >         at com.caucho.server.port.TcpConnection.run(
> TcpConnection.java
> > > > > :389)
> > > > >         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> :492)
> > > > >         at com.caucho.util.ThreadPool.run (ThreadPool.java:425)
> > > > >         at java.lang.Thread.run(Thread.java:595)
> > > > > [12:38:52.375] Closing dangling connections.  All connections must
> > > > > have a
> > > > > close() in a finally block.
> > > > > [12:38:52.375 ] java.lang.IllegalStateException: Connection
> > > > > UserConnection[ com.caucho.sql.ManagedConnectionImpl@8b1323] was
> not
> > > > > clo sed. Connections must have a close() in a finally block.
> > > > > [12:38:52.375]  at
> com.caucho.jca.UserTransactionImpl.abortTransaction
> > > > > (
> > > > > UserTransactionImpl.java:466)
> > > > > [12:38:52.375]  at
> > > > > com.caucho.jca.UserTransactionProxy.abortTransaction(
> > > > > UserTransactionProxy.java:174)
> > > > > [12:38:52.375]  at
> > > > > com.caucho.server.webapp.WebAppFilterChain.doFilter (
> > > > > WebAppFilterChain.java :198)
> > > > > [12:38:52.375]  at
> > > > > com.caucho.server.dispatch.ServletInvocation.service(
> > > > > ServletInvocation.java:229)
> > > > > [12:38:52.375]  at
> com.caucho.server.http.HttpRequest.handleRequest (
> > > > > HttpRequest.java:268)
> > > > > [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> > > > > TcpConnection.java:389)
> > > > > [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(
> ThreadPool.java
> > > > > :492)
> > > > > [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java
> :425)
> > > > > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> > > > >
> > > > > --
> > > > > kevin
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > kevin
> > > >
> -------------------------------------------------------------------------------------------
> > > >
> > > > "Cette communication (y compris les pieces jointes) est reservee a
> > > > l'usage exclusif du destinataire (des destinataires) et peut
> contenir des
> > > > informations privilegiees, confidentielles, exemptees de divulgation
> selon
> > > > la loi ou protegees par les droits d'auteur. Si vous n'etes pas un
> > > > destinataire, toute utilisation, divulgation, distribution,
> reproduction,
> > > > examen ou copie (totale ou partielle) est non-autorisee et peut etre
> > > > illegale. Tout message electronique est susceptible d'alteration et
> son
> > > > integrite ne peut etre assuree. Sanofi Pasteur decline toute
> responsabilite
> > > > au titre de ce message s'il a ete modifie ou falsifie. Si vous
> n'etes pas
> > > > destinataire de ce message, merci de le detruire immediatement et
> d'avertir
> > > > l'expediteur de l'erreur de distribution et de la destruction du
> message.
> > > > Merci.
> > > > This transmission (including any attachments) is intended solely for
> the
> > > > use of the addressee(s) and may contain confidential information
> including
> > > > trade secrets which are privileged, confidential, exempt from
> disclosure
> > > > under applicable law and/or subject to copyright. If you are not an
> intended
> > > > recipient, any use, disclosure, distribution, reproduction, review
> or
> > > > copying (either whole or partial) is unauthorized and may be
> unlawful.
> > > > E-mails are susceptible to alteration and their integrity cannot be
> > > > guaranteed.Sanofi Pasteur shall not be liable for this e-mail if
> > > > modified or falsified. If you are not the intended recipient of this
> e-mail,
> > > > please delete it immediately from your system and notify the sender
> of the
> > > > wrong delivery and the mail deletion. Thank you."
> > > >
> **********************************************************************
> > > >
> > > >
> > >
> > >
> > > --
> > > kevin
> > >
> >
> >
> >
> > --
> > kevin
> >
>



-- 
kevin

Re: problem: running roller2.3 under resin 3.0

Posted by Matt Raible <mr...@gmail.com>.

The latest version of Roller uses Acegi for Authentication so you
shouldn't need to modify resin.conf.  The WEB-INF/security.xml has all
the settings in it.

As far as the log4j problem, you need to modify log4j.properties (in
WEB-INF/classes) to remove the ${catalina.home} variable.

Matt

On 8/18/06, kelvin pang <ke...@gmail.com> wrote:
> and the resin.conf:
>
> <web-app id='/roller'
>     document-directory="D:\EclipseWin2003\eclipse-
> SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
> ">
>
>
>
>     <access-log path="logs/access.txt">
>         <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
> "%{User-Agent}i"</format>
>         <rollover-period>1D</rollover-period>
>     </access-log>
>
>     <!-- Resin-specific JdbcAuthenticator -->
>     <authenticator type='com.caucho.server.security.JdbcAuthenticator'>
>       <init>
>         <data-source>jdbc/rollerdb</data-source>
>           <password-query>
>             SELECT passphrase FROM rolleruser WHERE username=? and
> userenabled=1
>           </password-query>
>           <cookie-auth-query>
>             SELECT username FROM usercookie WHERE cookie=?
>           </cookie-auth-query>
>           <cookie-auth-update>
>             UPDATE usercookie SET cookieid=? WHERE username=?
>           </cookie-auth-update>
>           <role-query>
>             SELECT rolename FROM userrole r, rolleruser u
>             WHERE r.username=? and r.userid = u.id and u.userenabled=1
>           </role-query>
>           <password-digest>none</password-digest>
>       </init>
>     </authenticator>
>
>     <login-config>
>         <auth-method>FORM</auth-method>
>         <form-login-config>
>             <form-login-page>/login.jsp</form-login-page>
>             <form-error-page>/loginerror.jsp</form-error-page>
>         </form-login-config>
>     </login-config>
> </web-app>
>
>
>
> 2006/8/18, kelvin pang <ke...@gmail.com>:
> >
> > Hi,Eric,
> > the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
> > however when I start the roller under Tomcat5, there's no problem.
> >
> > 2006/8/18, Eric.Bardoux@sanofipasteur.com <Eric.Bardoux@sanofipasteur.com
> > >:
> >
> > > Hi Kevin,
> > > We need to know more about your config : tomcat? Weblo? Other?
> > > Mysql? Oracle? Other?
> > > Hibernate version.
> > > Eric
> > >
> > > -----Message d'origine-----
> > > De : kelvin pang [mailto: kevindig@gmail.com]
> > > Envoyé : vendredi 18 août 2006 06:58
> > > À : roller-user@incubator.apache.org
> > > Objet : Re: problem: running roller2.3 under resin 3.0
> > >
> > > and this exception alse appears:
> > >
> > > java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
> > >         at java.io.FileOutputStream.openAppend(Native Method)
> > >         at java.io.FileOutputStream.<init>(FileOutputStream.java :177)
> > >         at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
> > >         at org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
> > >         at org.apache.log4j.FileAppender.activateOptions(
> > > FileAppender.java
> > > :151)
> > >         at org.apache.log4j.DailyRollingFileAppender.activateOptions(
> > > DailyRollingFileAppender.java:206)
> > >         at org.apache.log4j.config.PropertySetter.activate(
> > > PropertySetter.java:247)
> > >         at org.apache.log4j.config.PropertySetter.setProperties(
> > > PropertySetter.java:123)
> > >         at org.apache.log4j.config.PropertySetter.setProperties(
> > > PropertySetter.java:87)
> > >         at org.apache.log4j.PropertyConfigurator.parseAppender (
> > > PropertyConfigurator.java:645)
> > >         at org.apache.log4j.PropertyConfigurator.parseCategory(
> > > PropertyConfigurator.java:603)
> > >         at org.apache.log4j.PropertyConfigurator.configureRootCategory(
> > > PropertyConfigurator.java :500)
> > >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > > PropertyConfigurator.java:406)
> > >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > > PropertyConfigurator.java:432)
> > >         at org.apache.log4j.helpers.OptionConverter.selectAndConfigure (
> > > OptionConverter.java:460)
> > >         at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
> > >         at org.apache.log4j.Logger.getLogger(Logger.java:94)
> > >         at org.apache.commons.logging.impl.Log4jFactory.getInstance (
> > > Log4jFactory.java:101)
> > >         at org.apache.commons.logging.LogFactory.getLog(LogFactory.java
> > > :351)
> > >         at org.apache.roller.presentation.RollerContext.<clinit>(
> > > RollerContext.java:81)
> > >         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > > Method)
> > >         at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> > > NativeConstructorAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (
> > > DelegatingConstructorAccessorImpl.java:27)
> > >         at java.lang.reflect.Constructor.newInstance(Constructor.java
> > > :494)
> > >         at java.lang.Class.newInstance0(Class.java:350)
> > >         at java.lang.Class.newInstance (Class.java:303)
> > >         at com.caucho.server.webapp.Listener.init(Listener.java:82)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > >         at com.caucho.config.BeanTypeStrategy.init (
> > > BeanTypeStrategy.java
> > > :316)
> > >         at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java
> > > :255)
> > >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > > NodeBuilder.java
> > > :299)
> > >         at com.caucho.config.BeanTypeStrategy.configure (
> > > BeanTypeStrategy.java:195)
> > >         at com.caucho.config.SetterAttributeStrategy.configure(
> > > SetterAttributeStrategy.java:91)
> > >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > NodeBuilder.java :377)
> > >         at com.caucho.config.NodeBuilder.configureBeanImpl(
> > > NodeBuilder.java
> > > :337)
> > >         at com.caucho.config.TypeStrategy.configureBean(
> > > TypeStrategy.java
> > > :103)
> > >         at com.caucho.config.BeanTypeStrategy.configureBean (
> > > BeanTypeStrategy.java:226)
> > >         at com.caucho.config.EnvironmentTypeStrategy.configureBean(
> > > EnvironmentTypeStrategy.java:70)
> > >         at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java
> > > :193)
> > >         at com.caucho.config.Config.configureBean(Config.java:272)
> > >         at com.caucho.config.Config.configureBean(Config.java:243)
> > >         at com.caucho.config.core.ResinImport.init(ResinImport.java:134)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > >         at java.lang.reflect.Method.invoke(Method.java:585)
> > >         at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> > > :316)
> > >         at com.caucho.config.NodeBuilder.configureImpl (NodeBuilder.java
> > > :255)
> > >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > > NodeBuilder.java
> > > :299)
> > >         at com.caucho.config.EnvironmentAttributeStrategy.configure(
> > > EnvironmentAttributeStrategy.java:56)
> > >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > > NodeBuilder.java:377)
> > >         at com.caucho.config.TypeStrategy.configureAttribute(
> > > TypeStrategy.java:112)
> > >         at com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> > > EnvironmentTypeStrategy.java:89)
> > >         at com.caucho.config.NodeBuilder.configureAttribute(
> > > NodeBuilder.java
> > > :226)
> > >         at com.caucho.config.NodeBuilderChildProgram.configureImpl(
> > > NodeBuilderChildProgram.java :54)
> > >         at com.caucho.config.BuilderProgramContainer.configureImpl(
> > > BuilderProgramContainer.java:62)
> > >         at com.caucho.config.BuilderProgram.configure(
> > > BuilderProgram.java
> > > :60)
> > >         at
> > > com.caucho.server.deploy.EnvironmentDeployController.configureInstance (
> > > EnvironmentDeployController.java:416)
> > >         at
> > > com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
> > > EnvironmentDeployController.java:80)
> > >         at com.caucho.server.deploy.DeployController.startImpl (
> > > DeployController.java:585)
> > >
> > > 2006/8/18, kelvin pang <ke...@gmail.com>:
> > > >
> > > > when I try to login,the following exception occur:
> > > >
> > > > java.sql.SQLException : Unknown column 'userenabled' in 'where clause'
> > > >         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
> > > >         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
> > > >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:1278)
> > > >         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> > > >         at com.mysql.jdbc.PreparedStatement.executeQuery(
> > > > PreparedStatement.java:1586)
> > > >         at com.caucho.sql.UserPreparedStatement.executeQuery (
> > > > UserPreparedStatement.java:108)
> > > >         at com.caucho.sql.UserPreparedStatement.executeQuery(
> > > > UserPreparedStatement.java:108)
> > > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl (
> > > > JdbcAuthenticator.java:394)
> > > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > > JdbcAuthenticator.java:322)
> > > >         at com.caucho.server.security.AbstractAuthenticator.login (
> > > > AbstractAuthenticator.java:212)
> > > >         at com.caucho.server.security.FormLoginServlet.service(
> > > > FormLoginServlet.java:76)
> > > >         at com.caucho.server.dispatch.ServletFilterChain.doFilter (
> > > > ServletFilterChain.java:106)
> > > >         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> > > > NamedDispatcherImpl.java:119)
> > > >         at com.caucho.server.dispatch.ForwardFilterChain.doFilter (
> > > > ForwardFilterChain.java:74)
> > > >         at com.caucho.server.cache.CacheFilterChain.doFilter (
> > > > CacheFilterChain.java:188)
> > > >         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > > > WebAppFilterChain.java:178)
> > > >         at com.caucho.server.dispatch.ServletInvocation.service(
> > > > ServletInvocation.java:229)
> > > >         at com.caucho.server.http.HttpRequest.handleRequest(
> > > > HttpRequest.java :268)
> > > >         at com.caucho.server.port.TcpConnection.run(TcpConnection.java
> > > > :389)
> > > >         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
> > > >         at com.caucho.util.ThreadPool.run (ThreadPool.java:425)
> > > >         at java.lang.Thread.run(Thread.java:595)
> > > > [12:38:52.375] Closing dangling connections.  All connections must
> > > > have a
> > > > close() in a finally block.
> > > > [12:38:52.375 ] java.lang.IllegalStateException: Connection
> > > > UserConnection[ com.caucho.sql.ManagedConnectionImpl@8b1323] was not
> > > > clo sed. Connections must have a close() in a finally block.
> > > > [12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction
> > > > (
> > > > UserTransactionImpl.java:466)
> > > > [12:38:52.375]  at
> > > > com.caucho.jca.UserTransactionProxy.abortTransaction(
> > > > UserTransactionProxy.java:174)
> > > > [12:38:52.375]  at
> > > > com.caucho.server.webapp.WebAppFilterChain.doFilter (
> > > > WebAppFilterChain.java :198)
> > > > [12:38:52.375]  at
> > > > com.caucho.server.dispatch.ServletInvocation.service(
> > > > ServletInvocation.java:229)
> > > > [12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest (
> > > > HttpRequest.java:268)
> > > > [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> > > > TcpConnection.java:389)
> > > > [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> > > > :492)
> > > > [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > > > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> > > >
> > > > --
> > > > kevin
> > > >
> > >
> > >
> > >
> > > --
> > > kevin
> > > -------------------------------------------------------------------------------------------
> > >
> > > "Cette communication (y compris les pieces jointes) est reservee a
> > > l'usage exclusif du destinataire (des destinataires) et peut contenir des
> > > informations privilegiees, confidentielles, exemptees de divulgation selon
> > > la loi ou protegees par les droits d'auteur. Si vous n'etes pas un
> > > destinataire, toute utilisation, divulgation, distribution, reproduction,
> > > examen ou copie (totale ou partielle) est non-autorisee et peut etre
> > > illegale. Tout message electronique est susceptible d'alteration et son
> > > integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite
> > > au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas
> > > destinataire de ce message, merci de le detruire immediatement et d'avertir
> > > l'expediteur de l'erreur de distribution et de la destruction du message.
> > > Merci.
> > > This transmission (including any attachments) is intended solely for the
> > > use of the addressee(s) and may contain confidential information including
> > > trade secrets which are privileged, confidential, exempt from disclosure
> > > under applicable law and/or subject to copyright. If you are not an intended
> > > recipient, any use, disclosure, distribution, reproduction, review or
> > > copying (either whole or partial) is unauthorized and may be unlawful.
> > > E-mails are susceptible to alteration and their integrity cannot be
> > > guaranteed.Sanofi Pasteur shall not be liable for this e-mail if
> > > modified or falsified. If you are not the intended recipient of this e-mail,
> > > please delete it immediately from your system and notify the sender of the
> > > wrong delivery and the mail deletion. Thank you."
> > > **********************************************************************
> > >
> > >
> >
> >
> > --
> > kevin
> >
>
>
>
> --
> kevin
>

Re: problem: running roller2.3 under resin 3.0

Posted by kelvin pang <ke...@gmail.com>.

and the resin.conf:

<web-app id='/roller'
    document-directory="D:\EclipseWin2003\eclipse-
SDK-3.1.2-win32\eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps\roller
">



    <access-log path="logs/access.txt">
        <format>%h %l %u %t "%r" %>s %b "%{Referer}i"
"%{User-Agent}i"</format>
        <rollover-period>1D</rollover-period>
    </access-log>

    <!-- Resin-specific JdbcAuthenticator -->
    <authenticator type='com.caucho.server.security.JdbcAuthenticator'>
      <init>
        <data-source>jdbc/rollerdb</data-source>
          <password-query>
            SELECT passphrase FROM rolleruser WHERE username=? and
userenabled=1
          </password-query>
          <cookie-auth-query>
            SELECT username FROM usercookie WHERE cookie=?
          </cookie-auth-query>
          <cookie-auth-update>
            UPDATE usercookie SET cookieid=? WHERE username=?
          </cookie-auth-update>
          <role-query>
            SELECT rolename FROM userrole r, rolleruser u
            WHERE r.username=? and r.userid = u.id and u.userenabled=1
          </role-query>
          <password-digest>none</password-digest>
      </init>
    </authenticator>

    <login-config>
        <auth-method>FORM</auth-method>
        <form-login-config>
            <form-login-page>/login.jsp</form-login-page>
            <form-error-page>/loginerror.jsp</form-error-page>
        </form-login-config>
    </login-config>
</web-app>



2006/8/18, kelvin pang <ke...@gmail.com>:
>
> Hi,Eric,
> the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
> however when I start the roller under Tomcat5, there's no problem.
>
> 2006/8/18, Eric.Bardoux@sanofipasteur.com <Eric.Bardoux@sanofipasteur.com
> >:
>
> > Hi Kevin,
> > We need to know more about your config : tomcat? Weblo? Other?
> > Mysql? Oracle? Other?
> > Hibernate version.
> > Eric
> >
> > -----Message d'origine-----
> > De : kelvin pang [mailto: kevindig@gmail.com]
> > Envoyé : vendredi 18 août 2006 06:58
> > À : roller-user@incubator.apache.org
> > Objet : Re: problem: running roller2.3 under resin 3.0
> >
> > and this exception alse appears:
> >
> > java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
> >         at java.io.FileOutputStream.openAppend(Native Method)
> >         at java.io.FileOutputStream.<init>(FileOutputStream.java :177)
> >         at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
> >         at org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
> >         at org.apache.log4j.FileAppender.activateOptions(
> > FileAppender.java
> > :151)
> >         at org.apache.log4j.DailyRollingFileAppender.activateOptions(
> > DailyRollingFileAppender.java:206)
> >         at org.apache.log4j.config.PropertySetter.activate(
> > PropertySetter.java:247)
> >         at org.apache.log4j.config.PropertySetter.setProperties(
> > PropertySetter.java:123)
> >         at org.apache.log4j.config.PropertySetter.setProperties(
> > PropertySetter.java:87)
> >         at org.apache.log4j.PropertyConfigurator.parseAppender (
> > PropertyConfigurator.java:645)
> >         at org.apache.log4j.PropertyConfigurator.parseCategory(
> > PropertyConfigurator.java:603)
> >         at org.apache.log4j.PropertyConfigurator.configureRootCategory(
> > PropertyConfigurator.java :500)
> >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > PropertyConfigurator.java:406)
> >         at org.apache.log4j.PropertyConfigurator.doConfigure(
> > PropertyConfigurator.java:432)
> >         at org.apache.log4j.helpers.OptionConverter.selectAndConfigure (
> > OptionConverter.java:460)
> >         at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
> >         at org.apache.log4j.Logger.getLogger(Logger.java:94)
> >         at org.apache.commons.logging.impl.Log4jFactory.getInstance (
> > Log4jFactory.java:101)
> >         at org.apache.commons.logging.LogFactory.getLog(LogFactory.java
> > :351)
> >         at org.apache.roller.presentation.RollerContext.<clinit>(
> > RollerContext.java:81)
> >         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> >         at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> > NativeConstructorAccessorImpl.java:39)
> >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (
> > DelegatingConstructorAccessorImpl.java:27)
> >         at java.lang.reflect.Constructor.newInstance(Constructor.java
> > :494)
> >         at java.lang.Class.newInstance0(Class.java:350)
> >         at java.lang.Class.newInstance (Class.java:303)
> >         at com.caucho.server.webapp.Listener.init(Listener.java:82)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:585)
> >         at com.caucho.config.BeanTypeStrategy.init (
> > BeanTypeStrategy.java
> > :316)
> >         at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java
> > :255)
> >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > NodeBuilder.java
> > :299)
> >         at com.caucho.config.BeanTypeStrategy.configure (
> > BeanTypeStrategy.java:195)
> >         at com.caucho.config.SetterAttributeStrategy.configure(
> > SetterAttributeStrategy.java:91)
> >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > NodeBuilder.java :377)
> >         at com.caucho.config.NodeBuilder.configureBeanImpl(
> > NodeBuilder.java
> > :337)
> >         at com.caucho.config.TypeStrategy.configureBean(
> > TypeStrategy.java
> > :103)
> >         at com.caucho.config.BeanTypeStrategy.configureBean (
> > BeanTypeStrategy.java:226)
> >         at com.caucho.config.EnvironmentTypeStrategy.configureBean(
> > EnvironmentTypeStrategy.java:70)
> >         at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java
> > :193)
> >         at com.caucho.config.Config.configureBean(Config.java:272)
> >         at com.caucho.config.Config.configureBean(Config.java:243)
> >         at com.caucho.config.core.ResinImport.init(ResinImport.java:134)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:585)
> >         at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> > :316)
> >         at com.caucho.config.NodeBuilder.configureImpl (NodeBuilder.java
> > :255)
> >         at com.caucho.config.NodeBuilder.configureChildImpl(
> > NodeBuilder.java
> > :299)
> >         at com.caucho.config.EnvironmentAttributeStrategy.configure(
> > EnvironmentAttributeStrategy.java:56)
> >         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> > NodeBuilder.java:377)
> >         at com.caucho.config.TypeStrategy.configureAttribute(
> > TypeStrategy.java:112)
> >         at com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> > EnvironmentTypeStrategy.java:89)
> >         at com.caucho.config.NodeBuilder.configureAttribute(
> > NodeBuilder.java
> > :226)
> >         at com.caucho.config.NodeBuilderChildProgram.configureImpl(
> > NodeBuilderChildProgram.java :54)
> >         at com.caucho.config.BuilderProgramContainer.configureImpl(
> > BuilderProgramContainer.java:62)
> >         at com.caucho.config.BuilderProgram.configure(
> > BuilderProgram.java
> > :60)
> >         at
> > com.caucho.server.deploy.EnvironmentDeployController.configureInstance (
> > EnvironmentDeployController.java:416)
> >         at
> > com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
> > EnvironmentDeployController.java:80)
> >         at com.caucho.server.deploy.DeployController.startImpl (
> > DeployController.java:585)
> >
> > 2006/8/18, kelvin pang <ke...@gmail.com>:
> > >
> > > when I try to login,the following exception occur:
> > >
> > > java.sql.SQLException : Unknown column 'userenabled' in 'where clause'
> > >         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
> > >         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
> > >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:1278)
> > >         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> > >         at com.mysql.jdbc.PreparedStatement.executeQuery(
> > > PreparedStatement.java:1586)
> > >         at com.caucho.sql.UserPreparedStatement.executeQuery (
> > > UserPreparedStatement.java:108)
> > >         at com.caucho.sql.UserPreparedStatement.executeQuery(
> > > UserPreparedStatement.java:108)
> > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl (
> > > JdbcAuthenticator.java:394)
> > >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > > JdbcAuthenticator.java:322)
> > >         at com.caucho.server.security.AbstractAuthenticator.login (
> > > AbstractAuthenticator.java:212)
> > >         at com.caucho.server.security.FormLoginServlet.service(
> > > FormLoginServlet.java:76)
> > >         at com.caucho.server.dispatch.ServletFilterChain.doFilter (
> > > ServletFilterChain.java:106)
> > >         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> > > NamedDispatcherImpl.java:119)
> > >         at com.caucho.server.dispatch.ForwardFilterChain.doFilter (
> > > ForwardFilterChain.java:74)
> > >         at com.caucho.server.cache.CacheFilterChain.doFilter (
> > > CacheFilterChain.java:188)
> > >         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > > WebAppFilterChain.java:178)
> > >         at com.caucho.server.dispatch.ServletInvocation.service(
> > > ServletInvocation.java:229)
> > >         at com.caucho.server.http.HttpRequest.handleRequest(
> > > HttpRequest.java :268)
> > >         at com.caucho.server.port.TcpConnection.run(TcpConnection.java
> > > :389)
> > >         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
> > >         at com.caucho.util.ThreadPool.run (ThreadPool.java:425)
> > >         at java.lang.Thread.run(Thread.java:595)
> > > [12:38:52.375] Closing dangling connections.  All connections must
> > > have a
> > > close() in a finally block.
> > > [12:38:52.375 ] java.lang.IllegalStateException: Connection
> > > UserConnection[ com.caucho.sql.ManagedConnectionImpl@8b1323] was not
> > > clo sed. Connections must have a close() in a finally block.
> > > [12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction
> > > (
> > > UserTransactionImpl.java:466)
> > > [12:38:52.375]  at
> > > com.caucho.jca.UserTransactionProxy.abortTransaction(
> > > UserTransactionProxy.java:174)
> > > [12:38:52.375]  at
> > > com.caucho.server.webapp.WebAppFilterChain.doFilter (
> > > WebAppFilterChain.java :198)
> > > [12:38:52.375]  at
> > > com.caucho.server.dispatch.ServletInvocation.service(
> > > ServletInvocation.java:229)
> > > [12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest (
> > > HttpRequest.java:268)
> > > [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> > > TcpConnection.java:389)
> > > [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> > > :492)
> > > [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> > >
> > > --
> > > kevin
> > >
> >
> >
> >
> > --
> > kevin
> > -------------------------------------------------------------------------------------------
> >
> > "Cette communication (y compris les pieces jointes) est reservee a
> > l'usage exclusif du destinataire (des destinataires) et peut contenir des
> > informations privilegiees, confidentielles, exemptees de divulgation selon
> > la loi ou protegees par les droits d'auteur. Si vous n'etes pas un
> > destinataire, toute utilisation, divulgation, distribution, reproduction,
> > examen ou copie (totale ou partielle) est non-autorisee et peut etre
> > illegale. Tout message electronique est susceptible d'alteration et son
> > integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite
> > au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas
> > destinataire de ce message, merci de le detruire immediatement et d'avertir
> > l'expediteur de l'erreur de distribution et de la destruction du message.
> > Merci.
> > This transmission (including any attachments) is intended solely for the
> > use of the addressee(s) and may contain confidential information including
> > trade secrets which are privileged, confidential, exempt from disclosure
> > under applicable law and/or subject to copyright. If you are not an intended
> > recipient, any use, disclosure, distribution, reproduction, review or
> > copying (either whole or partial) is unauthorized and may be unlawful.
> > E-mails are susceptible to alteration and their integrity cannot be
> > guaranteed.Sanofi Pasteur shall not be liable for this e-mail if
> > modified or falsified. If you are not the intended recipient of this e-mail,
> > please delete it immediately from your system and notify the sender of the
> > wrong delivery and the mail deletion. Thank you."
> > **********************************************************************
> >
> >
>
>
> --
> kevin
>



-- 
kevin

Re: problem: running roller2.3 under resin 3.0

Posted by kelvin pang <ke...@gmail.com>.

Hi,Eric,
the web server is Resin3.0.18, windows 2003, mysql5,hibernate3.
however when I start the roller under Tomcat5, there's no problem.

2006/8/18, Eric.Bardoux@sanofipasteur.com <Er...@sanofipasteur.com>:
>
> Hi Kevin,
> We need to know more about your config : tomcat? Weblo? Other?
> Mysql? Oracle? Other?
> Hibernate version.
> Eric
>
> -----Message d'origine-----
> De : kelvin pang [mailto:kevindig@gmail.com]
> Envoyé : vendredi 18 août 2006 06:58
> À : roller-user@incubator.apache.org
> Objet : Re: problem: running roller2.3 under resin 3.0
>
> and this exception alse appears:
>
> java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
>         at java.io.FileOutputStream.openAppend(Native Method)
>         at java.io.FileOutputStream.<init>(FileOutputStream.java:177)
>         at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
>         at org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
>         at org.apache.log4j.FileAppender.activateOptions(FileAppender.java
> :151)
>         at org.apache.log4j.DailyRollingFileAppender.activateOptions(
> DailyRollingFileAppender.java:206)
>         at org.apache.log4j.config.PropertySetter.activate(
> PropertySetter.java:247)
>         at org.apache.log4j.config.PropertySetter.setProperties(
> PropertySetter.java:123)
>         at org.apache.log4j.config.PropertySetter.setProperties(
> PropertySetter.java:87)
>         at org.apache.log4j.PropertyConfigurator.parseAppender(
> PropertyConfigurator.java:645)
>         at org.apache.log4j.PropertyConfigurator.parseCategory(
> PropertyConfigurator.java:603)
>         at org.apache.log4j.PropertyConfigurator.configureRootCategory(
> PropertyConfigurator.java:500)
>         at org.apache.log4j.PropertyConfigurator.doConfigure(
> PropertyConfigurator.java:406)
>         at org.apache.log4j.PropertyConfigurator.doConfigure(
> PropertyConfigurator.java:432)
>         at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(
> OptionConverter.java:460)
>         at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
>         at org.apache.log4j.Logger.getLogger(Logger.java:94)
>         at org.apache.commons.logging.impl.Log4jFactory.getInstance(
> Log4jFactory.java:101)
>         at org.apache.commons.logging.LogFactory.getLog(LogFactory.java
> :351)
>         at org.apache.roller.presentation.RollerContext.<clinit>(
> RollerContext.java:81)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(
> NativeConstructorAccessorImpl.java:39)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
> DelegatingConstructorAccessorImpl.java:27)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
>         at java.lang.Class.newInstance0(Class.java:350)
>         at java.lang.Class.newInstance(Class.java:303)
>         at com.caucho.server.webapp.Listener.init(Listener.java:82)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> :316)
>         at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java
> :255)
>         at com.caucho.config.NodeBuilder.configureChildImpl(
> NodeBuilder.java
> :299)
>         at com.caucho.config.BeanTypeStrategy.configure(
> BeanTypeStrategy.java:195)
>         at com.caucho.config.SetterAttributeStrategy.configure(
> SetterAttributeStrategy.java:91)
>         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> NodeBuilder.java:377)
>         at com.caucho.config.NodeBuilder.configureBeanImpl(
> NodeBuilder.java
> :337)
>         at com.caucho.config.TypeStrategy.configureBean(TypeStrategy.java
> :103)
>         at com.caucho.config.BeanTypeStrategy.configureBean(
> BeanTypeStrategy.java:226)
>         at com.caucho.config.EnvironmentTypeStrategy.configureBean(
> EnvironmentTypeStrategy.java:70)
>         at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java
> :193)
>         at com.caucho.config.Config.configureBean(Config.java:272)
>         at com.caucho.config.Config.configureBean(Config.java:243)
>         at com.caucho.config.core.ResinImport.init(ResinImport.java:134)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
> :316)
>         at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java
> :255)
>         at com.caucho.config.NodeBuilder.configureChildImpl(
> NodeBuilder.java
> :299)
>         at com.caucho.config.EnvironmentAttributeStrategy.configure(
> EnvironmentAttributeStrategy.java:56)
>         at com.caucho.config.NodeBuilder.configureAttributeImpl(
> NodeBuilder.java:377)
>         at com.caucho.config.TypeStrategy.configureAttribute(
> TypeStrategy.java:112)
>         at com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
> EnvironmentTypeStrategy.java:89)
>         at com.caucho.config.NodeBuilder.configureAttribute(
> NodeBuilder.java
> :226)
>         at com.caucho.config.NodeBuilderChildProgram.configureImpl(
> NodeBuilderChildProgram.java:54)
>         at com.caucho.config.BuilderProgramContainer.configureImpl(
> BuilderProgramContainer.java:62)
>         at com.caucho.config.BuilderProgram.configure(BuilderProgram.java
> :60)
>         at
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
> EnvironmentDeployController.java:416)
>         at
> com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
> EnvironmentDeployController.java:80)
>         at com.caucho.server.deploy.DeployController.startImpl(
> DeployController.java:585)
>
> 2006/8/18, kelvin pang <ke...@gmail.com>:
> >
> > when I try to login,the following exception occur:
> >
> > java.sql.SQLException: Unknown column 'userenabled' in 'where clause'
> >         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
> >         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
> >         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
> >         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
> >         at com.mysql.jdbc.PreparedStatement.executeQuery(
> > PreparedStatement.java:1586)
> >         at com.caucho.sql.UserPreparedStatement.executeQuery(
> > UserPreparedStatement.java:108)
> >         at com.caucho.sql.UserPreparedStatement.executeQuery(
> > UserPreparedStatement.java:108)
> >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > JdbcAuthenticator.java:394)
> >         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> > JdbcAuthenticator.java:322)
> >         at com.caucho.server.security.AbstractAuthenticator.login (
> > AbstractAuthenticator.java:212)
> >         at com.caucho.server.security.FormLoginServlet.service(
> > FormLoginServlet.java:76)
> >         at com.caucho.server.dispatch.ServletFilterChain.doFilter(
> > ServletFilterChain.java:106)
> >         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> > NamedDispatcherImpl.java:119)
> >         at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
> > ForwardFilterChain.java:74)
> >         at com.caucho.server.cache.CacheFilterChain.doFilter (
> > CacheFilterChain.java:188)
> >         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java:178)
> >         at com.caucho.server.dispatch.ServletInvocation.service(
> > ServletInvocation.java:229)
> >         at com.caucho.server.http.HttpRequest.handleRequest(
> > HttpRequest.java:268)
> >         at com.caucho.server.port.TcpConnection.run(TcpConnection.java
> > :389)
> >         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
> >         at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> >         at java.lang.Thread.run(Thread.java:595)
> > [12:38:52.375] Closing dangling connections.  All connections must
> > have a
> > close() in a finally block.
> > [12:38:52.375] java.lang.IllegalStateException: Connection
> > UserConnection[ com.caucho.sql.ManagedConnectionImpl@8b1323] was not
> > clo sed. Connections must have a close() in a finally block.
> > [12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction
> > (
> > UserTransactionImpl.java:466)
> > [12:38:52.375]  at
> > com.caucho.jca.UserTransactionProxy.abortTransaction(
> > UserTransactionProxy.java:174)
> > [12:38:52.375]  at
> > com.caucho.server.webapp.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java :198)
> > [12:38:52.375]  at
> > com.caucho.server.dispatch.ServletInvocation.service(
> > ServletInvocation.java:229)
> > [12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest(
> > HttpRequest.java:268)
> > [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> > TcpConnection.java:389)
> > [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> > :492)
> > [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> > [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
> >
> > --
> > kevin
> >
>
>
>
> --
> kevin
>
> -------------------------------------------------------------------------------------------
> "Cette communication (y compris les pieces jointes) est reservee a l'usage
> exclusif du destinataire (des destinataires) et peut contenir des
> informations privilegiees, confidentielles, exemptees de divulgation selon
> la loi ou protegees par les droits d'auteur. Si vous n'etes pas un
> destinataire, toute utilisation, divulgation, distribution, reproduction,
> examen ou copie (totale ou partielle) est non-autorisee et peut etre
> illegale. Tout message electronique est susceptible d'alteration et son
> integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite
> au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas
> destinataire de ce message, merci de le detruire immediatement et d'avertir
> l'expediteur de l'erreur de distribution et de la destruction du message.
> Merci.
> This transmission (including any attachments) is intended solely for the
> use of the addressee(s) and may contain confidential information including
> trade secrets which are privileged, confidential, exempt from disclosure
> under applicable law and/or subject to copyright. If you are not an intended
> recipient, any use, disclosure, distribution, reproduction, review or
> copying (either whole or partial) is unauthorized and may be unlawful.
> E-mails are susceptible to alteration and their integrity cannot be
> guaranteed.Sanofi Pasteur shall not be liable for this e-mail if modified
> or falsified. If you are not the intended recipient of this e-mail, please
> delete it immediately from your system and notify the sender of the wrong
> delivery and the mail deletion. Thank you."
> **********************************************************************
>
>


-- 
kevin

RE: problem: running roller2.3 under resin 3.0

Posted by Er...@sanofipasteur.com.

Hi Kevin,
We need to know more about your config : tomcat? Weblo? Other? 
Mysql? Oracle? Other?
Hibernate version.
Eric 

-----Message d'origine-----
De : kelvin pang [mailto:kevindig@gmail.com] 
Envoyé : vendredi 18 août 2006 06:58
À : roller-user@incubator.apache.org
Objet : Re: problem: running roller2.3 under resin 3.0

and this exception alse appears:

java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
        at java.io.FileOutputStream.openAppend(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:177)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
        at org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
        at org.apache.log4j.FileAppender.activateOptions(FileAppender.java
:151)
        at org.apache.log4j.DailyRollingFileAppender.activateOptions(
DailyRollingFileAppender.java:206)
        at org.apache.log4j.config.PropertySetter.activate(
PropertySetter.java:247)
        at org.apache.log4j.config.PropertySetter.setProperties(
PropertySetter.java:123)
        at org.apache.log4j.config.PropertySetter.setProperties(
PropertySetter.java:87)
        at org.apache.log4j.PropertyConfigurator.parseAppender(
PropertyConfigurator.java:645)
        at org.apache.log4j.PropertyConfigurator.parseCategory(
PropertyConfigurator.java:603)
        at org.apache.log4j.PropertyConfigurator.configureRootCategory(
PropertyConfigurator.java:500)
        at org.apache.log4j.PropertyConfigurator.doConfigure(
PropertyConfigurator.java:406)
        at org.apache.log4j.PropertyConfigurator.doConfigure(
PropertyConfigurator.java:432)
        at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(
OptionConverter.java:460)
        at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
        at org.apache.log4j.Logger.getLogger(Logger.java:94)
        at org.apache.commons.logging.impl.Log4jFactory.getInstance(
Log4jFactory.java:101)
        at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
        at org.apache.roller.presentation.RollerContext.<clinit>(
RollerContext.java:81)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(
NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.caucho.server.webapp.Listener.init(Listener.java:82)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
:316)
        at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java:255)
        at com.caucho.config.NodeBuilder.configureChildImpl(NodeBuilder.java
:299)
        at com.caucho.config.BeanTypeStrategy.configure(
BeanTypeStrategy.java:195)
        at com.caucho.config.SetterAttributeStrategy.configure(
SetterAttributeStrategy.java:91)
        at com.caucho.config.NodeBuilder.configureAttributeImpl(
NodeBuilder.java:377)
        at com.caucho.config.NodeBuilder.configureBeanImpl(NodeBuilder.java
:337)
        at com.caucho.config.TypeStrategy.configureBean(TypeStrategy.java
:103)
        at com.caucho.config.BeanTypeStrategy.configureBean(
BeanTypeStrategy.java:226)
        at com.caucho.config.EnvironmentTypeStrategy.configureBean(
EnvironmentTypeStrategy.java:70)
        at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java:193)
        at com.caucho.config.Config.configureBean(Config.java:272)
        at com.caucho.config.Config.configureBean(Config.java:243)
        at com.caucho.config.core.ResinImport.init(ResinImport.java:134)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
:316)
        at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java:255)
        at com.caucho.config.NodeBuilder.configureChildImpl(NodeBuilder.java
:299)
        at com.caucho.config.EnvironmentAttributeStrategy.configure(
EnvironmentAttributeStrategy.java:56)
        at com.caucho.config.NodeBuilder.configureAttributeImpl(
NodeBuilder.java:377)
        at com.caucho.config.TypeStrategy.configureAttribute(
TypeStrategy.java:112)
        at com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
EnvironmentTypeStrategy.java:89)
        at com.caucho.config.NodeBuilder.configureAttribute(NodeBuilder.java
:226)
        at com.caucho.config.NodeBuilderChildProgram.configureImpl(
NodeBuilderChildProgram.java:54)
        at com.caucho.config.BuilderProgramContainer.configureImpl(
BuilderProgramContainer.java:62)
        at com.caucho.config.BuilderProgram.configure(BuilderProgram.java
:60)
        at
com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
EnvironmentDeployController.java:416)
        at
com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
EnvironmentDeployController.java:80)
        at com.caucho.server.deploy.DeployController.startImpl(
DeployController.java:585)

2006/8/18, kelvin pang <ke...@gmail.com>:
>
> when I try to login,the following exception occur:
>
> java.sql.SQLException: Unknown column 'userenabled' in 'where clause'
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
>         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
>         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
>         at com.mysql.jdbc.PreparedStatement.executeQuery(
> PreparedStatement.java:1586)
>         at com.caucho.sql.UserPreparedStatement.executeQuery(
> UserPreparedStatement.java:108)
>         at com.caucho.sql.UserPreparedStatement.executeQuery(
> UserPreparedStatement.java:108)
>         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> JdbcAuthenticator.java:394)
>         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> JdbcAuthenticator.java:322)
>         at com.caucho.server.security.AbstractAuthenticator.login (
> AbstractAuthenticator.java:212)
>         at com.caucho.server.security.FormLoginServlet.service(
> FormLoginServlet.java:76)
>         at com.caucho.server.dispatch.ServletFilterChain.doFilter(
> ServletFilterChain.java:106)
>         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> NamedDispatcherImpl.java:119)
>         at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
> ForwardFilterChain.java:74)
>         at com.caucho.server.cache.CacheFilterChain.doFilter (
> CacheFilterChain.java:188)
>         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> WebAppFilterChain.java:178)
>         at com.caucho.server.dispatch.ServletInvocation.service(
> ServletInvocation.java:229)
>         at com.caucho.server.http.HttpRequest.handleRequest(
> HttpRequest.java:268)
>         at com.caucho.server.port.TcpConnection.run(TcpConnection.java
> :389)
>         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
>         at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
>         at java.lang.Thread.run(Thread.java:595)
> [12:38:52.375] Closing dangling connections.  All connections must 
> have a
> close() in a finally block.
> [12:38:52.375] java.lang.IllegalStateException: Connection 
> UserConnection[ com.caucho.sql.ManagedConnectionImpl@8b1323] was not 
> clo sed. Connections must have a close() in a finally block.
> [12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction 
> (
> UserTransactionImpl.java:466)
> [12:38:52.375]  at 
> com.caucho.jca.UserTransactionProxy.abortTransaction(
> UserTransactionProxy.java:174)
> [12:38:52.375]  at 
> com.caucho.server.webapp.WebAppFilterChain.doFilter(
> WebAppFilterChain.java :198)
> [12:38:52.375]  at 
> com.caucho.server.dispatch.ServletInvocation.service(
> ServletInvocation.java:229)
> [12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest(
> HttpRequest.java:268)
> [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> TcpConnection.java:389)
> [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> :492)
> [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
>
> --
> kevin
>



--
kevin
-------------------------------------------------------------------------------------------
"Cette communication (y compris les pieces jointes) est reservee a l'usage exclusif du destinataire (des destinataires) et peut contenir des informations privilegiees, confidentielles, exemptees de divulgation selon la loi ou protegees par les droits d'auteur. Si vous n'etes pas un destinataire, toute utilisation, divulgation, distribution, reproduction, examen ou copie (totale ou partielle) est non-autorisee et peut etre illegale. Tout message electronique est susceptible d'alteration et son integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur de l'erreur de distribution et de la destruction du message. Merci.
This transmission (including any attachments) is intended solely for the use of the addressee(s) and may contain confidential information including trade secrets which are privileged, confidential, exempt from disclosure under applicable law and/or subject to copyright. If you are not an intended recipient, any use, disclosure, distribution, reproduction, review or copying (either whole or partial) is unauthorized and may be unlawful. E-mails are susceptible to alteration and their integrity cannot be guaranteed.Sanofi Pasteur shall not be liable for this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and the mail deletion. Thank you."
**********************************************************************

Re: problem: running roller2.3 under resin 3.0

Posted by kelvin pang <ke...@gmail.com>.

and this exception alse appears:

java.io.FileNotFoundException: \logs\roller.log (系统找不到指定的路径。)
        at java.io.FileOutputStream.openAppend(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:177)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
        at org.apache.log4j.FileAppender.setFile(FileAppender.java:272)
        at org.apache.log4j.FileAppender.activateOptions(FileAppender.java
:151)
        at org.apache.log4j.DailyRollingFileAppender.activateOptions(
DailyRollingFileAppender.java:206)
        at org.apache.log4j.config.PropertySetter.activate(
PropertySetter.java:247)
        at org.apache.log4j.config.PropertySetter.setProperties(
PropertySetter.java:123)
        at org.apache.log4j.config.PropertySetter.setProperties(
PropertySetter.java:87)
        at org.apache.log4j.PropertyConfigurator.parseAppender(
PropertyConfigurator.java:645)
        at org.apache.log4j.PropertyConfigurator.parseCategory(
PropertyConfigurator.java:603)
        at org.apache.log4j.PropertyConfigurator.configureRootCategory(
PropertyConfigurator.java:500)
        at org.apache.log4j.PropertyConfigurator.doConfigure(
PropertyConfigurator.java:406)
        at org.apache.log4j.PropertyConfigurator.doConfigure(
PropertyConfigurator.java:432)
        at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(
OptionConverter.java:460)
        at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
        at org.apache.log4j.Logger.getLogger(Logger.java:94)
        at org.apache.commons.logging.impl.Log4jFactory.getInstance(
Log4jFactory.java:101)
        at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
        at org.apache.roller.presentation.RollerContext.<clinit>(
RollerContext.java:81)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(
NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at com.caucho.server.webapp.Listener.init(Listener.java:82)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
:316)
        at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java:255)
        at com.caucho.config.NodeBuilder.configureChildImpl(NodeBuilder.java
:299)
        at com.caucho.config.BeanTypeStrategy.configure(
BeanTypeStrategy.java:195)
        at com.caucho.config.SetterAttributeStrategy.configure(
SetterAttributeStrategy.java:91)
        at com.caucho.config.NodeBuilder.configureAttributeImpl(
NodeBuilder.java:377)
        at com.caucho.config.NodeBuilder.configureBeanImpl(NodeBuilder.java
:337)
        at com.caucho.config.TypeStrategy.configureBean(TypeStrategy.java
:103)
        at com.caucho.config.BeanTypeStrategy.configureBean(
BeanTypeStrategy.java:226)
        at com.caucho.config.EnvironmentTypeStrategy.configureBean(
EnvironmentTypeStrategy.java:70)
        at com.caucho.config.NodeBuilder.configureBean(NodeBuilder.java:193)
        at com.caucho.config.Config.configureBean(Config.java:272)
        at com.caucho.config.Config.configureBean(Config.java:243)
        at com.caucho.config.core.ResinImport.init(ResinImport.java:134)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.config.BeanTypeStrategy.init(BeanTypeStrategy.java
:316)
        at com.caucho.config.NodeBuilder.configureImpl(NodeBuilder.java:255)
        at com.caucho.config.NodeBuilder.configureChildImpl(NodeBuilder.java
:299)
        at com.caucho.config.EnvironmentAttributeStrategy.configure(
EnvironmentAttributeStrategy.java:56)
        at com.caucho.config.NodeBuilder.configureAttributeImpl(
NodeBuilder.java:377)
        at com.caucho.config.TypeStrategy.configureAttribute(
TypeStrategy.java:112)
        at com.caucho.config.EnvironmentTypeStrategy.configureAttribute(
EnvironmentTypeStrategy.java:89)
        at com.caucho.config.NodeBuilder.configureAttribute(NodeBuilder.java
:226)
        at com.caucho.config.NodeBuilderChildProgram.configureImpl(
NodeBuilderChildProgram.java:54)
        at com.caucho.config.BuilderProgramContainer.configureImpl(
BuilderProgramContainer.java:62)
        at com.caucho.config.BuilderProgram.configure(BuilderProgram.java
:60)
        at
com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
EnvironmentDeployController.java:416)
        at
com.caucho.server.deploy.EnvironmentDeployController.configureInstance(
EnvironmentDeployController.java:80)
        at com.caucho.server.deploy.DeployController.startImpl(
DeployController.java:585)

2006/8/18, kelvin pang <ke...@gmail.com>:
>
> when I try to login,the following exception occur:
>
> java.sql.SQLException: Unknown column 'userenabled' in 'where clause'
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
>         at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1167)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
>         at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
>         at com.mysql.jdbc.PreparedStatement.executeQuery(
> PreparedStatement.java:1586)
>         at com.caucho.sql.UserPreparedStatement.executeQuery(
> UserPreparedStatement.java:108)
>         at com.caucho.sql.UserPreparedStatement.executeQuery(
> UserPreparedStatement.java:108)
>         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> JdbcAuthenticator.java:394)
>         at com.caucho.server.security.JdbcAuthenticator.loginImpl(
> JdbcAuthenticator.java:322)
>         at com.caucho.server.security.AbstractAuthenticator.login (
> AbstractAuthenticator.java:212)
>         at com.caucho.server.security.FormLoginServlet.service(
> FormLoginServlet.java:76)
>         at com.caucho.server.dispatch.ServletFilterChain.doFilter(
> ServletFilterChain.java:106)
>         at com.caucho.server.webapp.NamedDispatcherImpl.forward(
> NamedDispatcherImpl.java:119)
>         at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
> ForwardFilterChain.java:74)
>         at com.caucho.server.cache.CacheFilterChain.doFilter (
> CacheFilterChain.java:188)
>         at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> WebAppFilterChain.java:178)
>         at com.caucho.server.dispatch.ServletInvocation.service(
> ServletInvocation.java:229)
>         at com.caucho.server.http.HttpRequest.handleRequest(
> HttpRequest.java:268)
>         at com.caucho.server.port.TcpConnection.run(TcpConnection.java
> :389)
>         at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
>         at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
>         at java.lang.Thread.run(Thread.java:595)
> [12:38:52.375] Closing dangling connections.  All connections must have a
> close() in a finally block.
> [12:38:52.375] java.lang.IllegalStateException: Connection UserConnection[
> com.caucho.sql.ManagedConnectionImpl@8b1323] was not clo
> sed. Connections must have a close() in a finally block.
> [12:38:52.375]  at com.caucho.jca.UserTransactionImpl.abortTransaction (
> UserTransactionImpl.java:466)
> [12:38:52.375]  at com.caucho.jca.UserTransactionProxy.abortTransaction(
> UserTransactionProxy.java:174)
> [12:38:52.375]  at com.caucho.server.webapp.WebAppFilterChain.doFilter(
> WebAppFilterChain.java :198)
> [12:38:52.375]  at com.caucho.server.dispatch.ServletInvocation.service(
> ServletInvocation.java:229)
> [12:38:52.375]  at com.caucho.server.http.HttpRequest.handleRequest(
> HttpRequest.java:268)
> [12:38:52.375]  at com.caucho.server.port.TcpConnection.run(
> TcpConnection.java:389)
> [12:38:52.375]  at com.caucho.util.ThreadPool.runTasks(ThreadPool.java
> :492)
> [12:38:52.375]  at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
> [12:38:52.375]  at java.lang.Thread.run(Thread.java:595)
>
> --
> kevin
>



-- 
kevin