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 <[EMAIL PROTECTED]>:
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 <[EMAIL PROTECTED]> 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
> [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
--
kevin
