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[
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>:
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>:
> >
> > 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, [EMAIL PROTECTED] <
[EMAIL PROTECTED]
> > >:
> >
> > > 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: [EMAIL PROTECTED]
> > > Envoyé : vendredi 18 août 2006 06:58
> > > À : [email protected]
> > > 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 <[EMAIL PROTECTED]>:
> > > >
> > > > 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[ [EMAIL PROTECTED] 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
