You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by djeddyg <ed...@mredd.co.uk> on 2006/03/20 19:55:38 UTC
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.
Re: Roller Deployment Issue (WinXP Pro/MySQL/Glassfish)
Posted by djeddyg <ed...@mredd.co.uk>.
I've fixed it so thought I would share my fix...
After quite a lot of trying to debug stack traces, knowing very little about
Java and JDBC I tried installing the latest Beta of Connector/J (v5.0.0
Beta). This seemed to fix all of my problems and Roller is now up and
running fine.
Thought I'd share the info in case it helps fix any future bugs or points
towards a bug in Connector/J.
Many thanks for all the help.
Edd
--
View this message in context: http://www.nabble.com/Roller-Deployment-Issue-%28WinXP-Pro-MySQL-Glassfish%29-t1313152c12275.html#a3554090
Sent from the Roller - User forum at Nabble.com.
Re: Roller Deployment Issue (WinXP Pro/MySQL/Glassfish)
Posted by djeddyg <ed...@mredd.co.uk>.
Thanks Anil,
I have checked and corrected the jdbc url, you were right as that was the
cause of the problem.
So I've now got the app deployed and executing to the main page, dstest.jps
not confirms that the connection is successful. but then... I tried
registering a first user (following the user guide to do this).
I can register fine and I can see that the the details are being committed
to the DB. However when I try and log in with the credentials I have just
registered I get the error 'Wrong username and password combination' and the
following stack trace is written to the server log: Any ideas?
Again in case it is relevant here, I'm running the following:
GlassFish: Build 40 08-Mar-06
MySQL: v5.0.16-nt
Connector/J: v3.2.0-alpha
Roller: v2.1.1 - Modified web.xml, sun-web.xml and taglibs.jsp taken from
Amy Roh's Roller v2.1 war file. As I understand it these modifications just
address a 1.3 vs 1.4 dtd problem that occurs on GlassFish.
[#|2006-03-21T20:29:01.546+0000|WARNING|sun-appserver-pe9.0|javax.enterprise.resource.resourceadapter|_ThreadID=18;_ThreadName=httpWorkerThread-8080-2;_RequestID=76a7cdd2-030c-400c-9f95-23e7f245227d;|RAR7093
: Error while cleaning up ManagedConnection
javax.resource.ResourceException: The isolation level for this connection
could not be retrieved
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:223)
at
com.sun.enterprise.resource.AbstractConnectorAllocator.cleanup(AbstractConnectorAllocator.java:134)
at
com.sun.enterprise.resource.PoolManagerImpl.putbackResourceToPool(PoolManagerImpl.java:413)
at
com.sun.enterprise.resource.PoolManagerImpl.resourceClosed(PoolManagerImpl.java:393)
at
com.sun.enterprise.resource.LocalTxConnectionEventListener.connectionClosed(LocalTxConnectionEventListener.java:69)
at
com.sun.gjc.spi.ManagedConnection.connectionClosed(ManagedConnection.java:618)
at com.sun.gjc.spi.ConnectionHolder.close(ConnectionHolder.java:163)
at
org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:277)
at
org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:238)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:491)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:114)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:201)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:209)
at
org.acegisecurity.userdetails.jdbc.JdbcDaoImpl.loadUserByUsername(JdbcDaoImpl.java:175)
at
org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:88)
at
org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:134)
at
org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:208)
at
org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49)
at
org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:90)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:228)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:181)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
at
com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
at
com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
at
com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
Caused by: java.sql.SQLException: Error during query: Unexpected Exception:
java.lang.ArrayIndexOutOfBoundsException message given: 3
Nested Stack Trace:
** BEGIN NESTED EXCEPTION **
java.lang.ArrayIndexOutOfBoundsException
MESSAGE: 3
STACKTRACE:
java.lang.ArrayIndexOutOfBoundsException: 3
at com.mysql.jdbc.ByteArrayBuffer.readFieldLength(ByteArrayBuffer.java:196)
at
com.mysql.jdbc.ByteArrayBuffer.fastSkipLenString(ByteArrayBuffer.java:102)
at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:595)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:423)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1952)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1400)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1720)
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 com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:795)
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:219)
at
com.sun.enterprise.resource.AbstractConnectorAllocator.cleanup(AbstractConnectorAllocator.java:134)
at
com.sun.enterprise.resource.PoolManagerImpl.putbackResourceToPool(PoolManagerImpl.java:413)
at
com.sun.enterprise.resource.PoolManagerImpl.resourceClosed(PoolManagerImpl.java:393)
at
com.sun.enterprise.resource.LocalTxConnectionEventListener.connectionClosed(LocalTxConnectionEventListener.java:69)
at
com.sun.gjc.spi.ManagedConnection.connectionClosed(ManagedConnection.java:618)
at com.sun.gjc.spi.ConnectionHolder.close(ConnectionHolder.java:163)
at
org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:277)
at
org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:238)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:491)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:114)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:201)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:209)
at
org.acegisecurity.userdetails.jdbc.JdbcDaoImpl.loadUserByUsername(JdbcDaoImpl.java:175)
at
org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:88)
at
org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:134)
at
org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:208)
at
org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49)
at
org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:90)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:228)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:216)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:184)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:277)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:181)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
at
com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
at
com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
at
com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
at
com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
** END NESTED EXCEPTION **
at com.mysql.jdbc.Connection.execSQL(Connection.java:2345)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2228)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159)
at com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:795)
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:219)
... 58 more
|#]
--
View this message in context: http://www.nabble.com/Roller-Deployment-Issue-%28WinXP-Pro-MySQL-Glassfish%29-t1313152c12275.html#a3520559
Sent from the Roller - User forum at Nabble.com.
Re: Roller Deployment Issue (WinXP Pro/MySQL/Glassfish)
Posted by Anil Gangolli <an...@busybuddha.org>.
Wild guess.
Can you include the database url you have configured? This looks like
it may be a problem with the jdbc url. I know that you tried the ping
test on the pool, but I'm not sure that would surface this. Make sure
that the jdbc url includes the name of the db holding the roller schema
(in the right place in the url).
--a.
djeddyg wrote:
> Thanks for the idea. I tried adding 'roller.database.version', '211' to the
> roller_properties table but I still get the same error.
>
> I have also tried accessing 'dstest.jsp' but I still get the same 404 error
> 'The requested resource () is not available.' I get this error even when I
> try and access the Roller context root e.g. 'http://localhost:8080/roller/'
>
> I have also tried using an older version of Connecor/J v3.0.17 as I read in
> the installation guide that v3.1.x upwards isn't recommended due to an
> acknowledged bug in the connector. This didn't help.
>
> Anyone got any further ideas for things I can try? I'm getting a bit
> desperate now!
>
> Cheers,
>
> Edd
>
>
> --
> View this message in context: http://www.nabble.com/Roller-Deployment-Issue-%28WinXP-Pro-MySQL-Glassfish%29-t1313152c12275.html#a3502487
> Sent from the Roller - User forum at Nabble.com.
>
>
>
Re: Roller Deployment Issue (WinXP Pro/MySQL/Glassfish)
Posted by djeddyg <ed...@mredd.co.uk>.
Thanks for the idea. I tried adding 'roller.database.version', '211' to the
roller_properties table but I still get the same error.
I have also tried accessing 'dstest.jsp' but I still get the same 404 error
'The requested resource () is not available.' I get this error even when I
try and access the Roller context root e.g. 'http://localhost:8080/roller/'
I have also tried using an older version of Connecor/J v3.0.17 as I read in
the installation guide that v3.1.x upwards isn't recommended due to an
acknowledged bug in the connector. This didn't help.
Anyone got any further ideas for things I can try? I'm getting a bit
desperate now!
Cheers,
Edd
--
View this message in context: http://www.nabble.com/Roller-Deployment-Issue-%28WinXP-Pro-MySQL-Glassfish%29-t1313152c12275.html#a3502487
Sent from the Roller - User forum at Nabble.com.
Re: Roller Deployment Issue (WinXP Pro/MySQL/Glassfish)
Posted by To...@persgroep.be.
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 <ed...@mredd.co.uk>
20/03/2006 19:55
Please respond to
roller-user@incubator.apache.org
To
roller-user@incubator.apache.org
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.