Ah, thank you, I see my mistake. I followed the instructions from the Wiki to get the sources from SVN, and I didn't think about the fact that I would get something later than 4.0.1.
I did this: svn checkout https://svn.apache.org/repos/asf/roller/trunk roller_trunk I will now try to check out with the roller_4.0.1 tag, and see whether that fixes my problem. Thanks Stephan > -----Ursprüngliche Nachricht----- > Von: "Anil Gangolli" <[email protected]> > Gesendet: 16.01.09 23:05:30 > An: [email protected] > Betreff: Re: Upgrade from 4.0 to 4.0.1 fails with glassfish and Derby > > Hmm. > > There's something a bit weird about your build. The 4.0.1 source tree > does not have any version of 400-to-410-migration.sql. It has > 400-to-401-migration.sql. Your build somehow has this, which is at > least an indication that something isn't quite right with it. > > Did you pull your sources from roller/tags/roller_4.0.1/ ? Did you > pull to a clean directory? Did you install the webapp to a clean directory? > > --a. > > Stephan Mühlstrasser wrote: > > Hi, > > > > I just tested an upgrade from roller 4.0 to roller 4.0.1 which fails. > > > > My environment: > > > > Ubuntu 8.10 > > glassfish-v2-b58g > > Derby 10.2.2 > > JDK 1.6.0_03-b05 > > roller 4.0.1 built from SVN source (I have to add a fix for defect > > ROL-1694 which is not yet fixed 4.0.1) > > > > This is my roller-custom.properties: > > > > installation.type=auto > > > > database.configurationType=jndi > > database.jndi.name=jdbc/rollerdb > > > > mail.configurationType=properties > > mail.hostname=<removed> > > mail.username=<removed> > > mail.password=<removed> > > > > After uploading the new roller.war and going to the roller URL, I saw > > the message that the database tables need to be upgraded, which I > > confirmed. After a while the following was displayed: > > > > > >> Error upgrading tables > >> Error upgrading tables, possibly due to an error in the database > >> creation script or because you are using an unsupported database. You > >> will have to fix this problem and then restart or redeploy Roller > >> before you can proceed. Below are the success/error messages issued > >> during the upgrade process: > >> > >> Running database upgrade script: derby/400-to-410-migration.sql > >> create table roller_permission ( id varchar(48) not null > >> primary key, username varchar(255) not null, actions > >> varchar(255), objectid varchar(48), objecttype varchar(255), > >> pending smallint default 1, datecreated timestamp not null ) > >> insert into roller_permission > >> (id,username,actions,objectid,objecttype,pending,datecreated) select > >> w.id || u.username , u.username, 'edit_draft', w.handle, 'Weblog', 0, > >> current_timestamp from rolleruser as u, website as w, > >> roller_user_permissions as p where p.user_id = u.id and p.website_id = > >> w.id and permission_mask = 1 > >> insert into roller_permission > >> (id,username,actions,objectid,objecttype,pending,datecreated) select > >> w.id || u.username , u.username, 'author', w.handle, 'Weblog', 0, > >> current_timestamp from rolleruser as u, website as w, > >> roller_user_permissions as p where p.user_id = u.id and p.website_id = > >> w.id and permission_mask = 2 > >> insert into roller_permission > >> (id,username,actions,objectid,objecttype,pending,datecreated) select > >> w.id || u.username , u.username, 'admin', w.handle, 'Weblog', 0, > >> current_timestamp from rolleruser as u, website as w, > >> roller_user_permissions as p where p.user_id = u.id and p.website_id = > >> w.id and permission_mask = 3 > >> alter table userrole alter column userid null > >> alter table website alter column userid null > >> alter table website add column creator varchar(255) default null > >> update website as w set lastmodified = lastmodified, datecreated = > >> datecreated, creator = (select u.username from rolleruser as u where u.id > >> = w.userid) > >> alter table weblogentry alter column userid null > >> alter table weblogentry add column creator varchar(255) default null > >> update weblogentry as w set pubtime = pubtime, updatetime = updatetime, > >> creator = (select u.username from rolleruser as u where u.id = w.userid) > >> alter table roller_weblogentrytag alter column userid null > >> alter table roller_weblogentrytag add column creator varchar(255) default > >> null > >> update roller_weblogentrytag as w set time = time, creator = (select > >> u.username from rolleruser as u where u.id = w.userid) > >> create table roller_userattribute( id varchar(48) not null > >> primary key, username varchar(255) not null, attrname varchar(255) not > >> null, attrvalue varchar(255) not null ) > >> create index ua_username_idx on roller_userattribute( username ) > >> create index ua_attrname_idx on roller_userattribute( attrname ) > >> create index ua_attrvalue_idx on roller_userattribute( attrvalue ) > >> > > > > I can see no error message here. > > > > These are the roller.log messages: > > > > > >> INFO 2009-01-15 20:58:58,356 ContinuousWorkerThread:run - > >> HitCountQueueProcessor Started. > >> INFO 2009-01-15 20:58:58,358 HitCountQueue:shutdown - stopping worker > >> HitCountQueueProcessor > >> INFO 2009-01-15 20:58:58,464 ContinuousWorkerThread:run - > >> HitCountQueueProcessor INTERRUPT: sleep interrupted > >> INFO 2009-01-15 20:59:09,701 DatabaseProvider:successMessage - SUCCESS: > >> Got parameters. Using configuration type JNDI_NAME > >> INFO 2009-01-15 20:59:09,704 DatabaseProvider:successMessage - -- Using > >> JNDI datasource name: java:comp/env/jdbc/rollerdb > >> INFO 2009-01-15 20:59:09,708 DatabaseProvider:successMessage - SUCCESS: > >> located JNDI DataSource [java:comp/env/jdbc/rollerdb] > >> INFO 2009-01-15 20:59:10,013 RollerContext:contextInitialized - > >> -------------------------------------------------------------- > >> Roller Weblogger startup INCOMPLETE, user interaction required > >> -------------------------------------------------------------- > >> INFO 2009-01-15 20:59:10,014 RollerContext:initializeSecurityFeatures - > >> Remember Me enabled: true > >> INFO 2009-01-15 20:59:10,019 RollerContext:initializeSecurityFeatures - > >> Password Encryption Algorithm set to 'SHA' > >> INFO 2009-01-15 20:59:10,019 RollerContext:setupVelocity - Initializing > >> Velocity > >> INFO 2009-01-15 20:59:10,694 IPBanFilter:init - INIT IPBanFilter > >> INFO 2009-01-15 20:59:11,995 RequestMappingFilter:init - Request mapping > >> filter initialized, 1 mappers configured. > >> WARN 2009-01-15 20:59:13,102 Settings:getLocale - Settings: Could not > >> parse struts.locale setting, substituting default VM locale > >> INFO 2009-01-15 20:59:13,641 PageServlet:init - Initializing PageServlet > >> INFO 2009-01-15 20:59:13,644 WeblogPageCache:<init> - > >> {id=cache.weblogpage, enabled=true, timeout=3600, size=400} > >> INFO 2009-01-15 20:59:13,648 CacheManager:<clinit> - Cache Manager > >> Initialized. > >> INFO 2009-01-15 20:59:13,649 CacheManager:<clinit> - Cache Factory = > >> org.apache.roller.weblogger.util.cache.ExpiringLRUCacheFactoryImpl > >> INFO 2009-01-15 20:59:13,654 SiteWideCache:<init> - {id=cache.sitewide, > >> enabled=true, timeout=1800, size=50} > >> INFO 2009-01-15 20:59:13,655 PageServlet:init - Referrer processing > >> enabled = true > >> INFO 2009-01-15 20:59:13,658 FeedServlet:init - Initializing FeedServlet > >> INFO 2009-01-15 20:59:13,660 WeblogFeedCache:<init> - > >> {id=cache.weblogfeed, enabled=true, timeout=3600, size=200} > >> INFO 2009-01-15 20:59:13,663 SearchServlet:init - Initializing > >> SearchServlet > >> INFO 2009-01-15 20:59:13,665 ResourceServlet:init - Initializing > >> ResourceServlet > >> INFO 2009-01-15 20:59:13,668 CommentServlet:init - Initializing > >> CommentServlet > >> INFO 2009-01-15 20:59:13,697 CommentValidationManager:<init> - Configured > >> CommentValidator: Blacklist Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.BlacklistCommentValidator > >> INFO 2009-01-15 20:59:13,699 CommentValidationManager:<init> - Configured > >> CommentValidator: Excess Links Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessLinksCommentValidator > >> INFO 2009-01-15 20:59:13,700 CommentValidationManager:<init> - Configured > >> CommentValidator: Excess Size Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessSizeCommentValidator > >> INFO 2009-01-15 20:59:13,704 CommentValidationManager:<init> - Configured > >> 3 CommentValidators > >> INFO 2009-01-15 20:59:13,708 CommentServlet:init - Comment Throttling > >> DISABLED > >> INFO 2009-01-15 20:59:13,712 CommentValidationManager:<init> - Configured > >> CommentValidator: Blacklist Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.BlacklistCommentValidator > >> INFO 2009-01-15 20:59:13,712 CommentValidationManager:<init> - Configured > >> CommentValidator: Excess Links Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessLinksCommentValidator > >> INFO 2009-01-15 20:59:13,713 CommentValidationManager:<init> - Configured > >> CommentValidator: Excess Size Comment Validator / > >> org.apache.roller.weblogger.ui.rendering.plugins.comments.ExcessSizeCommentValidator > >> INFO 2009-01-15 20:59:13,713 CommentValidationManager:<init> - Configured > >> 3 CommentValidators > >> INFO 2009-01-15 20:59:13,717 RSDServlet:init - Initializing RSDServlet > >> INFO 2009-01-15 20:59:13,720 PlanetFeedServlet:init - Initializing > >> PlanetRssServlet > >> INFO 2009-01-15 20:59:13,722 PlanetCache:<init> - Planet cache = > >> {id=cache.planet, enabled=true, timeout=1800, size=10} > >> INFO 2009-01-15 20:59:13,726 PreviewResourceServlet:init - Initializing > >> PreviewResourceServlet > >> INFO 2009-01-15 20:59:13,729 PreviewThemeImageServlet:init - Initializing > >> PreviewThemeImageServlet > >> INFO 2009-01-15 20:59:13,735 PreviewServlet:init - Initializing > >> PreviewServlet > >> INFO 2009-01-15 20:59:55,270 DatabaseInstaller:upgradeDatabase - Database > >> is old, beginning upgrade to version 410 > >> > > > > I can see no error messages here. The glassfish log file also does not > > contain any error messages. > > > > How can I find out what went wrong? > > > > Thanks > > Stephan > > > > > __________________________________________________________________ Deutschlands größte Online-Videothek schenkt Ihnen 12.000 Videos!* http://entertainment.web.de/de/entertainment/maxdome/index.html
