I don't know which MySQL driver is ultimately best, but we routinely test with the one that's bundled with the installer.
After installation, you can change the jdbc url by editing your config/fedora.fcfg file (just search for "jdbc" in that file and you'll find where it's set). Note that if you change databases after starting Fedora for the first time, you'll also have to do one of two things in order to make sure the database content is in sync with the files on disk: 1) Clear out the $FEDORA_HOME/data directory and restart Fedora. This will ensure you start with only the auto-ingested system objects and nothing else. 2) Run fedora-rebuild.sh or .bat and select the option to rebuild the SQL indexes. This will crawl the files on disk and populate the new database with their information. - Chris On Tue, Aug 9, 2011 at 12:05 PM, Michael.OBrien <michael.obr...@ul.ie> wrote: > Hi Chris, > > Thanks for getting back to me. I think you are on the right track about the > connection URL plus I would like to edit it anyway to specify > useUnicode=true&characterEncoding=UTF-8&autoReconnect=true (default) > > How would I make the change to the connection url after running the install > and would it be wiser in the long run to use MySQL Connection/J instead? > > Michael > > -----Original Message----- > From: Chris Wilper [mailto:cwil...@duraspace.org] > Sent: 09 August 2011 15:47 > To: Support and info exchange list for Fedora users. > Subject: Re: [fcrepo-user] org.fcrepo.server.storage.DOManager Error Fedora > 3.4.2 "Error while attempting to check for and create non-existing table on > fedora initialization" > > 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(DefaultDOMan >> ager.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(NativeConstructo >> rAccessorImpl.java:39) >> [na:1.6.0_26] >> >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo >> nstructorAccessorImpl.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.j >> ava:1216) >> [catalina.jar:7.0.19] >> >> at >> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.j >> ava:1135) >> [catalina.jar:7.0.19] >> >> at >> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:103 >> 1) >> [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:5 >> 284) >> [catalina.jar:7.0.19] >> >> at >> org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5 >> 279) >> [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(ThreadPoolExecu >> tor.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 > ------------------------------------------------------------------------------ > 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
