Hi Michael, I think "No database selected" is coming from the MySQL driver, and is indicating that your JDBC url doesn't name the database.
You specified: jdbc:mysql://remoteserver/ But you should specify something like: jdbc:mysql://remoteserver/dbname That's weird that the installer's db connection test passed, though. Maybe the MySQL JDBC driver doesn't care if no database is selected until you actually try to execute some SQL that needs one to be specified. - Chris On Tue, Aug 9, 2011 at 9:51 AM, Michael.OBrien <michael.obr...@ul.ie> wrote: > Hello all, > > I’ve hit a problem installing and configuring Fedora 3.4.2 using the > installer fcrepo-installer-3.4.2.jar > > The problem seems to be FC can’t connect using the installers provided JDBC > driver to the database even after the installer tests and passes the > database connection test. > > I have Tomcat installed and running independently of FC and also choose to > use an existing MySQL db server instead of installing a local version. > > > > The Database settings I used with the installer were > > MySQL values > > o JDBC driver: use included > > o Default JDBC driver class used > > o Jdbc url: jdbc:mysql://remoteserver/ > > The connection test passed and I was able to set the remaining values and > finish the install > > > > Would it be better to use the MySQL-connector-java and is it easy to > switchover or is there a simple fix I can make to resolve this error? > > The database user I provided during the installer has all privileges to the > db and is the only user but no tables have been created in it as yet > > > > Below is the fedora.log > > > > INFO 2011-08-09 13:48:14.810 [Thread-2] (BasicServer) Fedora Version: 3.4.2 > INFO 2011-08-09 13:48:14.810 [Thread-2] (BasicServer) Fedora Build Date: > 2011-01-20 00:34:20 UTC-0500 INFO 2011-08-09 13:48:14.812 [Thread-2] > (Server) Initializing org.fcrepo.server.storage.DefaultDOManager > > INFO 2011-08-09 13:48:14.823 [Thread-2] (Server) Initializing > org.fcrepo.server.oai.FedoraOAIProviderModule > > INFO 2011-08-09 13:48:14.824 [Thread-2] (Server) Initializing > org.fcrepo.server.security.DefaultBackendSecurity > > INFO 2011-08-09 13:48:14.826 [Thread-2] (Server) Initializing > org.fcrepo.server.access.DefaultAccess > > INFO 2011-08-09 13:48:14.831 [Thread-2] (Server) Initializing > org.fcrepo.server.storage.translation.DOTranslatorModule > > INFO 2011-08-09 13:48:15.122 [Thread-2] (Server) Initializing > org.fcrepo.server.search.FieldSearchSQLModule > > INFO 2011-08-09 13:48:15.123 [Thread-2] (Server) Initializing > org.fcrepo.server.management.ManagementModule > > INFO 2011-08-09 13:48:15.140 [Thread-2] (Server) Initializing > org.fcrepo.server.security.DefaultAuthorization > > INFO 2011-08-09 13:48:15.365 [Thread-2] (Server) Initializing > org.fcrepo.server.storage.ConnectionPoolManagerImpl > > INFO 2011-08-09 13:48:15.471 [Thread-2] (Server) Initializing > org.fcrepo.server.validation.DOValidatorModule > > INFO 2011-08-09 13:48:15.473 [Thread-2] (Server) Initializing > org.fcrepo.server.access.DynamicAccessModule > > INFO 2011-08-09 13:48:15.474 [Thread-2] (Server) Initializing > org.fcrepo.server.messaging.MessagingModule > > INFO 2011-08-09 13:48:15.475 [Thread-2] (MessagingModule) Messaging Module > is disabled. > > INFO 2011-08-09 13:48:15.475 [Thread-2] (Server) Initializing > org.fcrepo.server.storage.DefaultExternalContentManager > > INFO 2011-08-09 13:48:15.532 [Thread-2] (Server) Initializing > org.fcrepo.server.resourceIndex.ResourceIndexModule > > INFO 2011-08-09 13:48:15.536 [Thread-2] (Server) Initializing > org.fcrepo.server.storage.lowlevel.akubra.AkubraLowlevelStorageModule > > INFO 2011-08-09 13:48:15.541 [Thread-2] (Server) Initializing > org.fcrepo.server.management.BasicPIDGenerator > > INFO 2011-08-09 13:48:15.543 [Thread-2] (Server) Post-Initializing > org.fcrepo.server.storage.DefaultDOManager > > INFO 2011-08-09 13:48:15.906 [Thread-2] (SQLUtilityImpl) Creating new table > 'objectPaths' with command(s): > > CREATE TABLE objectPaths ( > > tokenDbID int(11) NOT NULL auto_increment, > > token varchar(64) NOT NULL default '', > > path varchar(255) NOT NULL default '', > > PRIMARY KEY (tokenDbID), > > UNIQUE KEY token (token) > > ); > > ERROR 2011-08-09 13:48:15.915 [Thread-2] (Server) Module > (org.fcrepo.server.storage.DOManager) failed to initialize > > org.fcrepo.server.errors.ModuleInitializationException: Error while > attempting to check for and create non-existing table(s): > java.sql.SQLException: No database selected > > at > org.fcrepo.server.storage.DefaultDOManager.postInitModule(DefaultDOManager.java:363) > [fcrepo-server-3.4.2.jar:na] > > at org.fcrepo.server.Server.<init>(Server.java:633) > [fcrepo-server-3.4.2.jar:na] > > at org.fcrepo.server.BasicServer.<init>(BasicServer.java:41) > [fcrepo-server-3.4.2.jar:na] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > [na:1.6.0_26] > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > [na:1.6.0_26] > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > [na:1.6.0_26] > > at > java.lang.reflect.Constructor.newInstance(Constructor.java:513) > [na:1.6.0_26] > > at org.fcrepo.server.Server.getInstance(Server.java:1001) > [fcrepo-server-3.4.2.jar:na] > > at > org.fcrepo.server.ServerController.init(ServerController.java:402) > [fcrepo-server-3.4.2.jar:na] > > at > javax.servlet.GenericServlet.init(GenericServlet.java:160) > [servlet-api.jar:3.0.FR] > > at > org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1216) > [catalina.jar:7.0.19] > > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1135) > [catalina.jar:7.0.19] > > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031) > [catalina.jar:7.0.19] > > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957) > [catalina.jar:7.0.19] > > at > org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284) > [catalina.jar:7.0.19] > > at > org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279) > [catalina.jar:7.0.19] > > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) > [na:1.6.0_26] > > at java.util.concurrent.FutureTask.run(FutureTask.java:138) > [na:1.6.0_26] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > [na:1.6.0_26] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > [na:1.6.0_26] > > at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] INFO > 2011-08-09 13:48:15.921 [Thread-2] (Server) Shutting down server INFO > 2011-08-09 13:48:15.921 [Thread-2] (Server) Shutting down > > > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > > ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
