From: Mitchell, E. <mit...@wf...> - 2011-05-09 20:51:56
|
Hi Raymond, We went round and round with this at WFU and (thanks to Demian's help) figured out that it had something to do with our MySQL configuration - specifically the indexer was not able to talk to the vufind database using localhost. I know it is the easy way out but we just updated our vufind config file to point to our box IP address and expanded our mysql security to allow the vufind user from that location to access the database. Best of luck, Erik On Mon, May 9, 2011 at 3:58 PM, Raymond Frohlich <rfr...@hs...> wrote: > Hello all, > > > > Having a bit of trouble importing MARC bib records into VuFind with track > changes enabled in marc_local.properties. I’ve uncommented the > first_indexed and last_indexed parameters and receive the error below when > running import-marc.sh. With these parameters commented out, I’ve been able > to load records without incident. I can verify that my MySQL settings in > web/conf/config.ini are correct. Any thoughts? > > > > 2011-05-09 14:13:58,003 [main] INFO main org.solrmarc.marc.MarcImporter - > Starting SolrMarc indexing. > > 2011-05-09 14:13:58,022 [main] INFO main org.solrmarc.tools.Utils - Opening > file: /usr/local/vufind/import/import.properties > > 2011-05-09 14:13:58,038 [main] INFO main org.solrmarc.marc.MarcImporter - > Updating to Solr index at /usr/local/vufind/solr > > 2011-05-09 14:13:58,039 [main] INFO main org.solrmarc.marc.MarcImporter > - Using Solr core biblio > > 2011-05-09 14:13:58,059 [main] INFO main org.solrmarc.marc.MarcImporter - > Using the data directory of: /usr/local/vufind/solr/biblio > > 2011-05-09 14:13:58,060 [main] INFO main org.solrmarc.marc.MarcImporter - > Using the multicore schema file at : /usr/local/vufind/solr/solr.xml > > 2011-05-09 14:13:58,060 [main] INFO main org.solrmarc.marc.MarcImporter - > Using the biblio core > > 2011-05-09 14:13:59,826 [main] INFO main org.solrmarc.marc.MarcHandler - > Attempting to open data file: > /usr/local/vufind/transform/files/bib/mrc/001.mrc > > 2011-05-09 14:14:00,009 [main] ERROR main org.solrmarc.index.VuFindIndexer - > Unable to connect to VuFind database > > 2011-05-09 14:14:00,010 [main] INFO main org.solrmarc.marc.MarcImporter - > Serious Error flagged at 1 read from file: 001.mrc > > 2011-05-09 14:14:00,010 [main] INFO main org.solrmarc.marc.MarcImporter - > Exception occurred while Indexing: Unable to connect to VuFind database > > 2011-05-09 14:14:00,010 [main] INFO main org.solrmarc.marc.MarcImporter - > Setting Solr closed flag > > > > > > Thanks very much! > > > > Raymond Frohlich > > Director of I.T. > > Historical Society of Pennsylvania > > 215-732-6200 x218 > > > > Visit us at www.hsp.org > > Sign up for HSP e-mail updates > > Become a fan on Facebook > > Follow us on Twitter @historicalpa > > > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd > _______________________________________________ > Vufind-tech mailing list > Vuf...@li... > https://lists.sourceforge.net/lists/listinfo/vufind-tech > > -- Erik Mitchell, Ph.D. Assistant Director for Technology Services Z. Smith Reynolds Library Wake Forest University http://erikmitchell.info |