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
