Thank you very much for the help. Once again, I have already download the file to test, but the problem still.Is that what I miss operation?
-keer Dave Johnson-8 wrote: > > 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. >> >> > > -- View this message in context: http://www.nabble.com/Roller-Planet-startup-failed---during-app-preparation-tp23646849s12275p23652852.html Sent from the Roller - User mailing list archive at Nabble.com.
