I took a look at this today, extracting my database and attempting to import and use with Roller 5.
I did find the following error in the apache-roller-5.0-beta/webapp/roller/META-INF/context.xml-example It has /user/local/apache-roller-4.0/webapp/roller, when it should probably be 5.0. I created my roller database, installed roller in webapps, configured its context.xml appropriately, copied my roller-custom.properties from production, copied my "andreas08" theme into the themes directory and started things up. When I went to http://localhost:8080, I received the following exception: Onverwachte Fout Status Code 500 Message Roller Weblogger has not been bootstrapped yet Type Exception Roller is tegen een onverwachte fout aangelopen. De fout is gelogd. I have no idea why the exception is in German (??). My $CATALINA_HOME/logs/roller.log contains the reason: INFO 2009-10-28 10:55:04,271 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JNDI_NAME INFO 2009-10-28 10:55:04,278 DatabaseProvider:successMessage - -- Using JNDI datasource name: java:comp/env/jdbc/rollerdb INFO 2009-10-28 10:55:04,280 DatabaseProvider:successMessage - SUCCESS: located JNDI DataSource [java:comp/env/jdbc/rollerdb] ERROR 2009-10-28 10:55:04,282 DatabaseProvider:errorMessage - ERROR: unable to obtain database connection. Likely problem: bad connection parameters or database unavailable. FATAL 2009-10-28 10:55:04,289 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:169) at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:139) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) 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:526) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) 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:592) 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 load JDBC driver class 'com.mysql.jdbc.Driver' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.apache.roller.weblogger.business.DatabaseProvider.getConnection(DatabaseProvider.java:179) at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabaseProvider.java:141) at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:169) at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:139) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) 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:526) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) 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:592) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:316) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:374) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) ... 29 more We should probably have a specific error message for this. To fix, I ran "cp ~/.m2/repository/mysql/mysql-connector-java/5.1.10/mysql-connector-java-5.1.10.jar $CATALINA_HOME/lib" and restarted Tomcat. This time (on Tomcat 6.0.20), I got: WARNING: A docBase /opt/tools/apache-tomcat-6.0.20/webapps/ROOT inside the host appBase has been specified, and will be ignored Roller Weblogger: Successfully loaded custom properties file from classpath Oct 28, 2009 11:00:05 AM org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart Oct 28, 2009 11:00:05 AM org.apache.catalina.core.StandardContext start SEVERE: Context [] startup failed due to previous errors This time (found in logs/localhost*.log), I found: Oct 28, 2009 11:00:02 AM org.apache.catalina.core.ApplicationContext log INFO: Initializing Spring root WebApplicationContext Oct 28, 2009 11:00:05 AM org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class org.apache.roller.weblogger.ui.core.RollerContext java.lang.NoClassDefFoundError: javax/mail/Authenticator at org.apache.naming.factory.MailSessionFactory.getObjectInstance(MailSessionFactory.java:105) Copy mail.jar and activation.jar to my $CATALINA_HOME/lib from my local Maven repo, try again. Now I get: Sorry! We couldn't find your document Status Code 404 Message Type Exception The file that you requested could not be found on this server. In roller.log, it has the following error: Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown column 't3.creator' in 'field list' {prepstmnt 16668330 SELECT t0.id, t0.about, t0.isactive, t0.allowcomments, t0.blacklist, t1.id, t1.description, t1.image, t1.name, t2.id, t2.description, t2.image, t2.name, t2.path, t2.websiteid, t1.path, t3.id, t3.about, t3.isactive, t3.allowcomments, t3.blacklist, t3.bloggercatid, t3.creator, t3.customstylesheet, t3.datecreated, t3.defaultallowcomments, t3.defaultcatid, t3.defaultcommentdays, t3.defaultpageid, t3.defaultplugins, t3.description, t3.editorpage, t3.editortheme, t3.emailaddress, t3.emailcomments, t3.emailfromaddress, t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, t3.locale, t3.commentmod, t3.name, t3.pagemodels, t3.showalllangs, t3.timeZone, t3.weblogdayid, t0.creator, t0.customstylesheet, t0.datecreated, t0.defaultallowcomments, t4.id, t4.description, t4.image, t4.name, t4.parentid, t4.path, t4.websiteid, t0.defaultcommentdays, t0.defaultpageid, t0.defaultplugins, t0.description, t0.editorpage, t0.editortheme, t0.emailaddress, t0.emailcomments, t0.emailfromaddress, t0.enablebloggerapi, t0.enablemultilang, t0.isenabled, t0.displaycnt, t0.handle, t0.icon, t0.lastmodified, t0.locale, t0.commentmod, t0.name, t0.pagemodels, t0.showalllangs, t0.timeZone, t0.weblogdayid FROM website t0 LEFT OUTER JOIN weblogcategory t1 ON t0.bloggercatid = t1.id LEFT OUTER JOIN weblogcategory t4 ON t0.defaultcatid = t4.id LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN website t3 ON t1.websiteid = t3.id WHERE (t0.handle = ?) [params=(String) rd]} [code=1054, state=42S22] Then I remember, I'm supposed to upgrade my database first. cd $CATALINA_HOME/webapps/ROOT/WEB-INF/classes/dbscripts/mysql mysql -u root -p roller < 400-to-500-migration.sql Restart Tomcat Whoo hoo - it works! Go to Site Administration and change site URL from http://raibledesigns.comto "" and start playing. The first thing I notice is my menu has a bit of CSS issues. This is likely because I've had to customize the Velocity templates in the past. I'll play around with it a bit and try to figure out the differences between my templates and Roller's templates and report back, hopefully in the next couple days. Thanks, Matt On Sat, Oct 24, 2009 at 5:17 PM, Dave <[email protected]> wrote: > The Roller 5.0 code base is ready for wider testing and so we are > making available a beta build. This build is not an Apache release, > will not be supported and should not be used for anything other than > testing. It's not a good idea to try to upgrade your existing Roller > site yet. If you choose to try Roller 5.0 beta1 please make sure you > do it on copy of your existing database, uploaded files and search > index. > > You can download the build and the updated user and installation > documentation from Dave Johnson's personal web space at Apache.org; > this build will not be made available via Apache mirrors. > > I'll prepare a nice and friendly "What's New in Roller 5.0 page" > sometime before the final release. For now, the best sources for > information about what's in Roller are the documentation at download > links below, the Roller 5.0 proposal page and the change list in our > JIRA issue tracker: > > Roller 5.0 binaries, source and docs > > http://people.apache.org/~snoopdave/apache-roller-5.0<http://people.apache.org/%7Esnoopdave/apache-roller-5.0> > > Roller 5.0 proposal: > > http://cwiki.apache.org/confluence/display/ROLLER/Apache+Roller+5.0+Release > > Roller 5.0 JIRA change list: http://bit.ly/3CUxm0 > > https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12310906&styleName=Html&version=12313828 > > > I'll notify the user list a little later, once I know beta 1 is > working for folks. > > Thanks, > - Dave >
