roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nanren888 <nanren...@gmail.com>
Subject yet another install problem <-- ERROR: unable to obtain database connection. Likely problem: bad connection parameters or database unavailable.
Date Sat, 20 Nov 2010 21:58:26 GMT

This has got to be something simple. Can someone tell me the most likely
causes?

new J2EE install
new MySQL install (mysql-essential-5.1.52-win32.msi)
new connector (mysql-connector-java-5.1.13-bin.jar in tomcat/lib)
new mail.jar ( in tomcat/lib from javamail-1.4.3.zip)
new activation.jar (in tomcat/lib from jaf-1_0_2-upd2.zip)
new tomcat install (apache-tomcat-6.0.29-windows-x86.zip)
All exactly to guides.

New to this, lost & frustrated.

>>If you are posting a question, please try search first. Your question may
have already been answered. 
Entirely agree, but, searched this error, here & web & get 1,000s of hits,
seemingly no clear pattern to the fixes offered.
Many (old?) install suggestions/guides about endless config files, most that
simply do not talley with the install I see. References to putting contexts
in config files & such, now seems to be a separate file? Many questions
about complicated configurations; I just want the first vanila installation. 

Lost with no idea of a coherent direction!

tomcat clearly running.
examples run
admin runs
deploy does not complain about roller
reload & undeploy do not complain.

created rollerdb as per guide, granted rolleruser for both '%' & localhost
as per guide.
mysql worbench can see mysql by TCP & pipe. can see rollerdb & rolleruser
Seems to confirm mysql is on 3306
mysql seems to say it is on utf8


roller creates log as included below.

used roller-custom.properties placed separately as suggested elsewhere.

installation.type=auto
database.configurationType=jdbc
database.jdbc.driverClass=com.mysql.jdbc.Driver
database.jdbc.connectionURL=jdbc:mysql://localhost:3306/rollerdb
database.jdbc.username=rolleruser
database.jdbc.password=rollerPassword
mail.hostName=send.xtra.co.nz
mail.username=<our account name here>
mail.password=<our password here>

Specific questions, from install
Have seen reference to roller-custom.properties as an xml config file, but
it is not xml: Just as here: plain text. Can someone confirm that it is just
text as here?


if a ask for localhost:8080/roller/roller-ui it redirects to
localhost:8080/roller/roller-ui/login.rol, gives a login page & of course,
fails with

Unexpected Exception
Status Code 	500
Message 	Roller Weblogger has not been bootstrapped yet
Type 	
Exception 	Roller has encountered and logged an unexpected exception.

<Not been bootstrapped>? Search of the install & guides gave me zero hits on
bootstrapped.


My guess, lots see the same problem. Anyone let me in on the secret 3 most
likely things?

Next steps are to search for an example jsp or two that just uses mysql so I
can test connection separately to roller. Or maybe some stand-alone java
example of jdbc, is that the name?

After that it is back to randomly trying the thousand or so random
configuration tips on the web, or maybe just set the machine to format & go
watch TV?

Lost, tired, bewildered.
Any help much appreciated.




Status Code 	500
Message 	An exception occurred processing JSP page /index.jsp at line 31 28:
} else { 29: // dispatch to setup page 30: RequestDispatcher setuppage =
request.getRequestDispatcher("/roller-ui/setup.rol"); 31:
setuppage.forward(request, response); 32: } 33: 34: %> Stacktrace:
Type 	
Exception 	Roller has encountered and logged an unexpected exception.

roller.log starts

INFO  2010-11-21 07:58:48,234 DatabaseProvider:successMessage - SUCCESS: Got
parameters. Using configuration type JNDI_NAME
INFO  2010-11-21 07:58:48,234 DatabaseProvider:successMessage - -- Using
JNDI datasource name: java:comp/env/jdbc/rollerdb
INFO  2010-11-21 07:58:48,234 DatabaseProvider:successMessage - SUCCESS:
located JNDI DataSource [java:comp/env/jdbc/rollerdb]
ERROR 2010-11-21 07:58:48,250 DatabaseProvider:errorMessage - ERROR: unable
to obtain database connection. Likely problem: bad connection parameters or
database unavailable.
FATAL 2010-11-21 07:58:48,265 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:171)
	at
org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:138)
	at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
	at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
	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:546)
	at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
	at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
	at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
	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:785)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
	at org.apache.catalina.core.StandardService.start(StandardService.java:519)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
	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:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
--- ROOT CAUSE ---
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
	at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)

-- 
View this message in context: http://old.nabble.com/yet-another-install-problem-%3C---ERROR%3A-unable-to-obtain-database-connection.-Likely-problem%3A-bad-connection-parameters-or-database-unavailable.-tp30268237s12275p30268237.html
Sent from the Roller - User mailing list archive at Nabble.com.


Mime
View raw message