Based on this: ----------begin planet-custom.properties---------------------- installation.type=auto database.configurationType=jdbc database.jdbc.driverClass=com.mysql.jdbc.Driver database.jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/rollerdb database.jdbc.username=root database.jdbc.password=6yh7ujk
And on this: INFO 2009-05-21 09:39:01,656 PlanetConfig:<clinit> - successfully loaded custom properties file from classpath INFO 2009-05-21 09:39:01,656 PlanetConfig:<clinit> - no custom properties file specified via jvm option INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JNDI_NAME INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - -- Using JNDI datasource name: java:comp/env/jdbc/rollerdb INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - SUCCESS: located JNDI DataSource [java:comp/env/jdbc/rollerdb] ERROR 2009-05-21 09:39:01,656 DatabaseProvider:errorMessage - ERROR: unable to obtain database connection. Likely problem: bad connection parameters or database unavailable. It appears that Roller is able to find your planet-custom.properties file, but is unable to read it properly for some unknown reason. Could there be some formatting problem in the file? - Dave On Wed, May 20, 2009 at 10:26 PM, keer <[email protected]> wrote: > > I've read through nearly all of the previous roller-install-guide, blogs and > WIKI > entries out there, but I can't seem to find out what's causing my > specific issue. > > The system is normal and I log in before we set up planet. > > I'm using: > > Tomcat 6.0.18 > MySQL 5.0.77 > Java 1.5.18 > > This is my settings > > ----------begin roller-custom.properties---------------------- > > installation.type=auto > database.configurationType=jdbc > database.jdbc.driverClass=com.mysql.jdbc.Driver > database.jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/rollerdb > database.jdbc.username=root > database.jdbc.password=6yh7ujk > mail.configurationType=properties > mail.hostName=localhost > > planet.aggregator.enabled=true > planet.aggregator.cache.dir=${user.home}/roller_data/planet-cache/ > cache.dir=${user.home}/roller_data/planet-cache/ > planet.aggregator.guice.module=\ > org.apache.roller.weblogger.planet.business.jpa.RollerPlanetModule > > # Tasks which are enabled. Only tasks listed here will be run. > tasks.enabled=ScheduledEntriesTask,ResetHitCountsTask,\ > TurnoverReferersTask,PingQueueTask,RefreshRollerPlanetTask,SyncWebsitesTask > > # Set of page models specifically for site-wide rendering > rendering.siteModels=\ > org.apache.roller.weblogger.ui.rendering.model.SiteModel,\ > org.apache.roller.weblogger.ui.rendering.model.PlanetModel > > ----------end roller-custom.properties---------------------- > > ----------begin planet-custom.properties---------------------- > > installation.type=auto > database.configurationType=jdbc > database.jdbc.driverClass=com.mysql.jdbc.Driver > database.jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/rollerdb > database.jdbc.username=root > database.jdbc.password=6yh7ujk > > planet.aggregator.enabled=true > planet.aggregator.cache.dir=${user.home}/roller_data/planet-cache/ > cache.dir=${user.home}/roller_data/planet-cache/ > planet.aggregator.guice.module=\ > org.apache.roller.weblogger.planet.business.jpa.RollerPlanetModule > > # Tasks which are enabled. Only tasks listed here will be run. > tasks.enabled=ScheduledEntriesTask,ResetHitCountsTask,\ > TurnoverReferersTask,PingQueueTask,RefreshRollerPlanetTask,SyncWebsitesTask > > # Set of page models specifically for site-wide rendering > rendering.siteModels=\ > org.apache.roller.weblogger.ui.rendering.model.SiteModel,\ > org.apache.roller.weblogger.ui.rendering.model.PlanetModel > > ----------end planet-custom.properties---------------------- > > > create a custom weblog template cloning frontpage, change two lines > in Weblog.vm (cange also <id> and <name> in theme.xml): > ## 1) SITE-WIDE entries (the default) > ##set($pager = $site.getWeblogEntriesPager($since, $maxResults)) > > ## 2) PLANET-entries > #set($pager = $planet.getAggregationPager($since, $maxResults)) > ## The below pager code should work against either: > > > but planet raises errors > > ----------------------------------------------------------- > INFO 2009-05-21 09:38:57,625 WebloggerFactory:bootstrap - Bootstrapping > Roller Weblogger business tier > INFO 2009-05-21 09:38:57,625 WebloggerFactory:bootstrap - Weblogger > Provider = org.apache.roller.weblogger.business.GuiceWebloggerProvider > INFO 2009-05-21 09:38:57,640 DatabaseProvider:successMessage - SUCCESS: Got > parameters. Using configuration type JDBC_PROPERTIES > INFO 2009-05-21 09:38:57,640 DatabaseProvider:successMessage - -- Using > JDBC driver class: com.mysql.jdbc.Driver > INFO 2009-05-21 09:38:57,640 DatabaseProvider:successMessage - -- Using > JDBC connection URL: jdbc:mysql://127.0.0.1:3306/rollerdb > INFO 2009-05-21 09:38:57,640 DatabaseProvider:successMessage - -- Using > JDBC username: root > INFO 2009-05-21 09:38:57,640 DatabaseProvider:successMessage - -- Using > JDBC password: [hidden] > INFO 2009-05-21 09:38:57,656 DatabaseProvider:successMessage - SUCCESS: > loaded JDBC driver class [com.mysql.jdbc.Driver] > INFO 2009-05-21 09:38:57,687 JPAPersistenceStrategy:<init> - openjpa.Log: > commons > INFO 2009-05-21 09:38:58,375 IndexManagerImpl:<init> - search enabled: true > INFO 2009-05-21 09:38:58,375 IndexManagerImpl:<init> - index dir: > C:\Documents and Settings\user\roller_data\search-index > INFO 2009-05-21 09:38:58,406 ReferrerQueueManagerImpl:<init> - > Instantiating Referrer Queue Manager > INFO 2009-05-21 09:38:58,406 ReferrerQueueManagerImpl:<init> - Asynchronous > referrer processing = false > INFO 2009-05-21 09:38:58,406 ThreadManagerImpl:<init> - Instantiating > Thread Manager > INFO 2009-05-21 09:38:58,421 WebloggerFactory:bootstrap - Roller Weblogger > business tier successfully bootstrapped > INFO 2009-05-21 09:38:58,421 WebloggerFactory:bootstrap - Version: 4.0.1 > INFO 2009-05-21 09:38:58,421 WebloggerFactory:bootstrap - Revision: > 729109 > INFO 2009-05-21 09:38:58,421 WebloggerImpl:initialize - Initializing Roller > Weblogger business tier > INFO 2009-05-21 09:39:01,359 ThemeManagerImpl:initialize - Loaded 5 themes > from disk. > INFO 2009-05-21 09:39:01,359 ThreadManagerImpl:initialize - Initializing > task: ScheduledEntriesTask > INFO 2009-05-21 09:39:01,453 ThreadManagerImpl:initialize - Initializing > task: ResetHitCountsTask > INFO 2009-05-21 09:39:01,468 ThreadManagerImpl:initialize - Initializing > task: TurnoverReferersTask > INFO 2009-05-21 09:39:01,500 ThreadManagerImpl:initialize - Initializing > task: PingQueueTask > INFO 2009-05-21 09:39:01,515 ThreadManagerImpl:initialize - Initializing > task: RefreshRollerPlanetTask > INFO 2009-05-21 09:39:01,546 ThreadManagerImpl:initialize - Initializing > task: SyncWebsitesTask > INFO 2009-05-21 09:39:01,640 WebloggerImpl:initialize - Roller Weblogger > business tier successfully initialized > INFO 2009-05-21 09:39:01,656 PlanetConfig:<clinit> - successfully loaded > default properties. > INFO 2009-05-21 09:39:01,656 PlanetConfig:<clinit> - successfully loaded > custom properties file from classpath > INFO 2009-05-21 09:39:01,656 PlanetConfig:<clinit> - no custom properties > file specified via jvm option > INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - SUCCESS: Got > parameters. Using configuration type JNDI_NAME > INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - -- Using > JNDI datasource name: java:comp/env/jdbc/rollerdb > INFO 2009-05-21 09:39:01,656 DatabaseProvider:successMessage - SUCCESS: > located JNDI DataSource [java:comp/env/jdbc/rollerdb] > ERROR 2009-05-21 09:39:01,656 DatabaseProvider:errorMessage - ERROR: unable > to obtain database connection. Likely problem: bad connection parameters or > database unavailable. > FATAL 2009-05-21 09:39:01,656 RollerContext:contextInitialized - Roller > Planet startup failed during app preparation > org.apache.roller.planet.business.startup.StartupException: ERROR: unable to > obtain database connection. Likely problem: bad connection parameters or > database unavailable. > at > org.apache.roller.planet.business.DatabaseProvider.<init>(DatabaseProvider.java:147) > at > org.apache.roller.planet.business.startup.PlanetStartup.prepare(PlanetStartup.java:86) > at > org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:173) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4342) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) > at > org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) > at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) > at > org.apache.catalina.core.StandardService.start(StandardService.java:516) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:710) > at org.apache.catalina.startup.Catalina.start(Catalina.java:578) > 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:288) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) > --- ROOT CAUSE --- > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of > class '' for connect URL 'null' > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > at > org.apache.roller.planet.business.DatabaseProvider.getConnection(DatabaseProvider.java:178) > at > org.apache.roller.planet.business.DatabaseProvider.<init>(DatabaseProvider.java:140) > at > org.apache.roller.planet.business.startup.PlanetStartup.prepare(PlanetStartup.java:86) > at > org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:173) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4342) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) > at > org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) > at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) > at > org.apache.catalina.core.StandardService.start(StandardService.java:516) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:710) > at org.apache.catalina.startup.Catalina.start(Catalina.java:578) > 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:288) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143) > ... 29 more > WARN 2009-05-21 09:39:02,843 Settings:getLocale - Settings: Could not parse > struts.locale setting, substituting default VM locale > > ---------------------------------------------------------- > > I tried many times,while I put the sentence “planet.aggregator.enabled=true” > into “roller-custom.properties”,then log in , it tips that your password is > wrong, if I remove this sentence the system is OK. > > > thank you > -keer > > -- > View this message in context: > http://www.nabble.com/Roller-Planet-startup-failed---during-app-preparation-tp23646849s12275p23646849.html > Sent from the Roller - User mailing list archive at Nabble.com. > >
