Yeah, I have put roller-custom.properties at Tomcat 5.0\common\classes and
mysql-connector-java-5.0.8-bin.jar and activation.jar at Lib folder.
I'm not sure about the file you are talking in Meta-INF.. I can just see on
context.xml-example file there which has content like..
<!--
Example Tomcat Context Configuration file for Roller
If you'd like to use Tomcat provided datasource and mail sessions then:
- Set database.connetionType=jndi property in roller-custom.properties
- Set mail.connetionType=jndi property in roller-custom.properties
- Set the correct values for docBase, driverClassName, url, username,
password and mail.smtp.host in the text below.
- Rename this file to context.xml and deploy Roller directory to Tomcat.
-->
<Context path="/roller"
docBase="/user/local/apache-roller-4.0/webapp/roller" debug="0">
<Resource name="jdbc/rollerdb" auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/rollerdb?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8"
username="scott"
password="tiger"
maxActive="20" maxIdle="3" removeAbandoned="true" maxWait="3000" />
<Resource name="mail/Session" auth="Container" type="javax.mail.Session"
mail.smtp.host="smtp-server.example.com" />
</Context>
Do you want me to change something there?
On Fri, Sep 26, 2008 at 3:44 PM, Harsh Gupta
<[EMAIL PROTECTED]>wrote:
>
> Did you put roller-custom.properties file in Tomcat/lib or classes folder
> of
> Tomcat?
> Did you put the mysql database driver jar file and activation.jar under Lib
> folder of Tomcat?
>
> There is also a properties file under META-INF in roller under webapps. Try
> updating the settings over there and see if it works?
>
>
> Ambuj Tiwari wrote:
> >
> > INFO 2008-09-25 17:52:17,172 DatabaseProvider:successMessage - SUCCESS:
> > located JNDI DataSource [java:comp/env/jdbc/rollerdb]
> > ERROR 2008-09-25 17:52:17,192 DatabaseProvider:errorMessage - ERROR:
> > unable
> > to obtain database connection. Likely problem: bad connection parameters
> > or
> > database unavailable.
> > FATAL 2008-09-25 17:52:17,212 RollerContext:contextInitialized - Roller
> > Weblogger startup failed during app preparation
> > org.apache.roller.weblogger.business.startup.StartupException: ERROR:
> > unable
> > to obtain database connection. Likely problem: bad connection parameters
> > or
> > database unavailable.
> > at
> >
> org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabaseProvider.java:148)
> > at
> >
> org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:171)
> > at
> >
> org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
> > at
> >
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618)
> > at
> > org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)
> > at
> >
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
> > at
> > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> > at
> > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:880)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:843)
> > at
> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
> > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)
> > at
> >
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
> > at
> >
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
> > at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)
> > at
> > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)
> > at
> > org.apache.catalina.core.StandardService.start(StandardService.java:450)
> > at
> > org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)
> > at org.apache.catalina.startup.Catalina.start(Catalina.java:545)
> > 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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> >
> > On Fri, Sep 26, 2008 at 9:58 AM, Harsh Gupta
> > <[EMAIL PROTECTED]>wrote:
> >
> >>
> >> Please, Post your log file here.
> >>
> >>
> >> Ambuj Tiwari wrote:
> >> >
> >> > I'm using below code in roller-custom.properties file.
> >> >
> >> > installation.type=auto
> >> > database.configurationType=jdbc
> >> > database.jdbc.driverClass=com.mysql.jdbc.Driver
> >> > database.jdbc.connectionURL=jdbc:mysql://localhost:3306/rollerdb
> >> > database.jdbc.username=scott
> >> > database.jdbc.password=tiger
> >> > mail.configurationType=properties
> >> > mail.hostname=smtp-server.example.com
> >> > mail.username=scott
> >> > mail.password=tiger
> >> >
> >> > I have also given all the privileges by executing below command
> >> >
> >> > grant all privileges on rollerdb.* to [EMAIL PROTECTED] identified by
> >> > 'tiger';
> >> >
> >> > Still, i'm getting the same problem.
> >> >
> >> >
> >> >
> >> > On Thu, Sep 25, 2008 at 3:53 PM, Harsh Gupta
> >> > <[EMAIL PROTECTED]>wrote:
> >> >
> >> >>
> >> >> True, Grant proper privileges to roller-db. Use the following
> command.
> >> >>
> >> >> GRANT ALL PRIVILEGES ON roller-db.* TO 'scott'@'%' IDENTIFIED BY
> >> 'tiger'
> >> >> WITH GRANT OPTION;
> >> >>
> >> >>
> >> >> tanuja v wrote:
> >> >> >
> >> >> > You can also check roller-custom.properties file. I had
> encountered
> >> >> the
> >> >> > same exception and found out from logs that I had a bad database
> >> >> > connection.
> >> >> > This was because I had missed some necessary lines of code in
> >> >> > roller-custom.properties file.
> >> >> >
> >> >> >
> >> >> > On Wed, Sep 24, 2008 at 7:37 AM, Oscar del Rio
> >> >> > <[EMAIL PROTECTED]>wrote:
> >> >> >
> >> >> >> Ambuj Tiwari wrote:
> >> >> >>
> >> >> >>> I installed Roller and configured it but when I' trying to open
> "
> >> >> >>> http://localhost:8080/roller/"; it gives me unexpected error.
> >> >> >>>
> >> >> >>> Unexpected Exception Status Code 500 Message Roller Weblogger
> >> has
> >> >> not
> >> >> >>> been
> >> >> >>> bootstrapped yet Type
> >> >> >>> Exception Roller has encountered and logged an unexpected
> >> exception.
> >> >> >>> Can somebody tell me the reason for this?
> >> >> >>>
> >> >> >>>
> >> >> >> Check the log file, it might give you some hints of what went
> >> wrong.
> >> >> >> Last time I upgraded I had the same error and the reason turned
> out
> >> to
> >> >> be
> >> >> >> something corrupted in the database that I had to fix manually.
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://www.nabble.com/Problem-with-Start-Up-tp19645523s12275p19666859.html
> >> >> Sent from the Roller - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/Problem-with-Start-Up-tp19645523s12275p19682333.html
> >> Sent from the Roller - User mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Problem-with-Start-Up-tp19645523s12275p19685719.html
> Sent from the Roller - User mailing list archive at Nabble.com.
>
>
