In version 2.0 of roller I had the problem that the database version could not be read from the DB, you can however manually insert a value there ... This is the field roller.database.version in the roller_properties table.
For version 2.1.1 this value is 211 ... You can also try to run the dstest.jsp to check if you datasource is configured correctly ... djeddyg <[EMAIL PROTECTED]> 20/03/2006 19:55 Please respond to [email protected] To [email protected] cc Subject Roller Deployment Issue (WinXP Pro/MySQL/Glassfish) (Apologies, I previously posted this in the dev group without realising...) Hi, Using: Windows XP Pro (Athlon XP2400, 1.5GB Ram, 900GB SATA Disks) GlassFish: Build 40 08-Mar-06 MySQL: v5.0.16-nt Connector/J: v3.2.0-alpha Roller: v2.1 (the version from Amy Roh's blog) I have followed Amy Roh's instructions to the letter and have installed GlassFish, configured MySQL and configured and deployed Roller exactly as instructed. Roller deploys successfully but when I check the Roller.log file I see the following error: INFO 2006-03-17 19:39:52,000 RollerConfig:<clinit> - successfully loaded default properties. INFO 2006-03-17 19:39:52,000 RollerConfig:<clinit> - no custom properties file found in classpath INFO 2006-03-17 19:39:52,000 RollerConfig:<clinit> - no custom properties file specified via jvm option ERROR 2006-03-17 19:39:52,375 UpgradeDatabase:upgradeDatabase - Couldn't lookup current database version java.sql.SQLException: No database selected at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1584) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1675) at com.mysql.jdbc.Connection.execSQL(Connection.java:2295) at com.mysql.jdbc.Connection.execSQL(Connection.java:2228) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159) at org.roller.business.utils.UpgradeDatabase.upgradeDatabase(UpgradeDatabase.java:65) at org.roller.presentation.RollerContext.upgradeDatabaseIfNeeded(RollerContext.java:342) at org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:150) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4236) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4762) at com.sun.enterprise.web.WebModule.start(WebModule.java:292) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:833) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:817) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:659) at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1462) at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1131) at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:171) at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:265) at com.sun.enterprise.admin.event.AdminEventMulticaster.invokeModuleDeployEventListener(AdminEventMulticaster.java:954) at com.sun.enterprise.admin.event.AdminEventMulticaster.handleModuleDeployEvent(AdminEventMulticaster.java:941) at com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:448) at com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:160) at com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:296) at com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:201) at com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStartEvent(ServerDeploymentTarget.java:285) at com.sun.enterprise.deployment.phasing.ApplicationStartPhase.runPhase(ApplicationStartPhase.java:119) at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:95) at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:848) at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:527) at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:571) at com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.start(ApplicationsConfigMBean.java:719) 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 com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:353) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:336) at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:407) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784) at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:77) at $Proxy1.invoke(Unknown Source) at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:297) at com.sun.enterprise.deployment.client.DeploymentClientUtils.startApplication(DeploymentClientUtils.java:133) at com.sun.enterprise.deployment.client.DeployAction.run(DeployAction.java:517) at java.lang.Thread.run(Thread.java:595) When I try and access the Roller URL I get a 404 error with text saying ;'The requested resource () is not available.'. As I understood it the Database that Roller uses is configured by the setting I provide when creating the Connection Pool. I have tried verifying the connection pool and it pings fine. I can also use the same settings to login to MySQL. I have also checked that the web.xml and sun-web.xml files which have been deployed use the 'jdbc/rollerdb' JDBC resource which I have set up as per Any's instructions. If anyone has any ideas of stuff I can try I would be most chuffed to hear from you. It's taken me the best part of an evening to not get this working so I'm keen to figure out what is wrong asap. Many thanks in advance. Edd -- View this message in context: http://www.nabble.com/Roller-Deployment-Issue-%28WinXP-Pro-MySQL-Glassfish%29-t1313152c12275.html#a3499695 Sent from the Roller - User forum at Nabble.com.
