(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.
