|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
|
|
Apache Roller 5.0 beta 1 build availableThe 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 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 |
|
|
Re: Apache Roller 5.0 beta 1 build availableI 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 <snoopdave@...> 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 > |
|
|
Re: Apache Roller 5.0 beta 1 build availableAlso noticed a lot of these in my logs.
WARN 2009-10-28 11:07:06,720 CommonsLogger:warn - Error setting expression 'users.themes.path' with value '[Ljava.lang.String;@675940' ognl.OgnlException: source is null for getProperty(null, "themes") at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2203) at ognl.ASTProperty.getValueBody(ASTProperty.java:114) at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at ognl.SimpleNode.getValue(SimpleNode.java:258) at ognl.ASTChain.setValueBody(ASTChain.java:222) These are caused by Struts 2. We should figure out a way to show them in development and suppress in production. I have the same issue in AppFuse and will be looking for a solution sometime this week. Matt On Wed, Oct 28, 2009 at 11:09 AM, Matt Raible <matt@...>wrote: > 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.com to "" 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 <snoopdave@...> 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 >> > > |
|
|
|
|
|
Re: Apache Roller 5.0 beta 1 build availableOn Wed, Oct 28, 2009 at 10:09 AM, Matt Raible <matt@...>wrote:
> 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.com to "" 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. > I've entered a JIRA issue for the major cosmetic issue I'm experiencing: https://issues.apache.org/jira/browse/ROL-1845 I'll submit a patch after I'm done waiting for SVN to download all the JARs. ;-) There are a number of other enhancements to weblog.vm, mostly consisting of adding id's and classes to elements so they can be styled easier. Should I create an issue for this as well, or continue merging my .vm before I upgrade? Thanks, Matt > > Thanks, > > Matt > > > On Sat, Oct 24, 2009 at 5:17 PM, Dave <snoopdave@...> 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 >> > > |
|
|
Re: Apache Roller 5.0 beta 1 build availableOne time in band camp Matt Raible <matt@...> said:
> > I've entered a JIRA issue for the major cosmetic issue I'm experiencing: > > https://issues.apache.org/jira/browse/ROL-1845 > > I'll submit a patch after I'm done waiting for SVN to download all the JARs. > ;-) > > There are a number of other enhancements to weblog.vm, mostly consisting of > adding id's and classes to elements so they can be styled easier. Should I > create an issue for this as well, or continue merging my .vm before I > upgrade? I think that's up to you. I'd be happy either way. - Dave |
|
|
Re: Apache Roller 5.0 beta 1 build availableI'll test my changes against other themes soon and if there aren't any
issues, I'll commit the patch attached to the issue below. Thanks, Matt On Thu, Nov 5, 2009 at 8:26 AM, Dave <snoopdave@...> wrote: > One time in band camp Matt Raible <matt@...> said: > > > > I've entered a JIRA issue for the major cosmetic issue I'm experiencing: > > > > https://issues.apache.org/jira/browse/ROL-1845 > > > > I'll submit a patch after I'm done waiting for SVN to download all the > JARs. > > ;-) > > > > There are a number of other enhancements to weblog.vm, mostly consisting > of > > adding id's and classes to elements so they can be styled easier. Should > I > > create an issue for this as well, or continue merging my .vm before I > > upgrade? > > I think that's up to you. I'd be happy either way. > > - Dave > |
| Free embeddable forum powered by Nabble | Forum Help |