Menu
▾
▴
Re: [VuFind-Tech] Why can't VuFind talk to Voyager?
|
From: Andrew I. [aai] <aa...@ab...> - 2009-06-19 10:03:32
|
Hi Greg
Great idea for debugging the Ajax. I tried your suggestion and it seemed to be generating a reasonable URL, when I put the URL into the browser I got the following, interesting sounding error (I've replace username and password):
<?xml version="1.0" encoding="UTF-8"?>
<AJAXResponse>
<br />
<b>Fatal error</b>: Uncaught exception 'PDOException' with message 'could not find driver' in /usr/local/vufind/web/Drivers/Voyager.php:51
Stack trace:
#0 /usr/local/vufind/web/Drivers/Voyager.php(51): PDO->__construct('oci:dbname=(DES...', 'xxxxx', 'xxxxx')
#1 /usr/local/vufind/web/CatalogConnection.php(64): Voyager->__construct()
#2 /usr/local/vufind/web/services/Search/AJAX.php(69): CatalogConnection->__construct('Voyager')
#3 /usr/local/vufind/web/services/Search/AJAX.php(33): AJAX->getItemStatuses()
#4 /usr/local/vufind/web/index.php(102): AJAX->launch()
#5 {main}
thrown in <b>/usr/local/vufind/web/Drivers/Voyager.php</b> on line <b>51</b><br />
I'm somewhat mystified as to what's causing this. Line 51 in Voyager.php is where it creates a new PDO object for the connection to Oracle. I've tried echoing the $tns string to the screen to check it's being formed correctly but it doesn't seem to be being displayed.
Any thoughts anyone?
Cheers
Andrew
> > -----Original Message-----
> > From: Greg Pendlebury [mailto:Gre...@us...]
> > Sent: 19 June 2009 00:49
> > To: vuf...@li...
> > Subject: Re: [VuFind-Tech] Why can't VuFind talk to Voyager?
> >
> > Also Andrew, you can debug a little easier by replicating the ajax
> call
> > in your browser.
> >
> > To make life easy, open /services/Search/ajax.js and edit the
> > doGetStatuses() function. One of the first few lines is:
> >
> > http.open("GET", url, true);
> >
> > and you change it to:
> >
> > document.write(url);
> > http.open("GET", url, true);
> >
> > after a refresh (look out for the .js being cached) it will drop a
> url
> > into your document at the end of the search results which you copy
> and
> > paste to a new window.
> >
> > If the ajax call is working properly you get XML back, otherwise
> you'll
> > get an error message (you might need to view page source though
> > depending on the browser), indicating the problem under the hood.
> >
> > I hate debugging ajax ;)
> >
> >
> > Greg Pendlebury
> > Electronic Services Officer (Systems Team) Division of Academic
> > Information Services University of Southern Queensland
> > Phone: +61 7 4631 1501
> > Fax: +61 7 4631 1841
> >
> >
> >
> > ________________________________
> >
> > From: Ken Herold [mailto:kh...@ha...]
> > Sent: Friday, 19 June 2009 7:08 AM
> > To: vuf...@li...
> > Cc: vuf...@li...
> > Subject: Re: [VuFind-Tech] Why can't VuFind talk to Voyager?
> >
> >
> > Hi Andrew,
> > We moved to Voyager 7.1 while running an instance of Vufind and as I
> > recall, because of the upgrade to Oracle 10g, I changed our ini file
> > to:
> >
> > [Catalog]
> > host = lib.hamilton.edu
> > port = 1521
> > service = VGER
> > user = xxxxx
> > password = xxxxx
> > database = HAMILTONDB
> > pwebrecon = http://lib.hamilton.edu/cgi-bin/Pwebrecon.cgi
> >
> > If I am not mistaken, the Voyager.php file will construct your sql
> > environment from tns:
> >
> > function __construct()
> > {
> > // Load Configuration for this Module
> > $this->config = parse_ini_file('conf/Voyager.ini', true);
> >
> > // Define Database Name
> > $this->dbName = $this->config['Catalog']['database'];
> >
> > $tns = '(DESCRIPTION=' .
> > '(ADDRESS_LIST=' .
> > '(ADDRESS=' .
> > '(PROTOCOL=TCP)' .
> > '(HOST=' . $this->config['Catalog']['host'] .
> ')'
> > .
> > '(PORT=' . $this->config['Catalog']['port'] .
> ')'
> > .
> > ')' .
> > ')' .
> > '(CONNECT_DATA=' .
> > '(SID=' . $this->config['Catalog']['service'] .
> ')'
> > .
> > ')' .
> > ')';
> > try {
> > $this->db = new PDO("oci:dbname=$tns",
> > $this->config['Catalog']['user'],
> > $this-
> >config['Catalog']['password']);
> > } catch (PDOException $e) {
> > throw $e;
> > }
> > }
> >
> > which actually informs the interactive part and not the
> Pwebrecon.cgi.
> > If you fiddle with the service variable perhaps you will get
> connected.
> >
> > Best of luck,
> > Ken
> >
> > ----- Original Message -----
> > From: "Andrew Isherwood [aai]" <aa...@ab...>
> > Date: Thursday, June 18, 2009 7:15 am
> > Subject: [VuFind-Tech] Why can't VuFind talk to Voyager?
> > To: vuf...@li...
> >
> > > I've been fighting with this one for a while and have decided
> > > it's time to look to the list for help.
> > >
> > > When displaying search results, none of the call number or
> > > location information is displayed, the text "Loading" simply
> > > remains. I'm assuming this means that VuFind is unable to talk
> > > to our Voyager 7 server.
> > >
> > > I have configured config.ini with "driver = Voyager" and this is
> > > what my Voyager.ini file looks like (I've removed user and
> password):
> > >
> > > [Catalog]
> > > host = voyager.aber.ac.uk
> > > port = 1521
> > > service = VGER.voyager.aber.ac.uk
> > > user = xxx
> > > password = xxx
> > > database = ABERDB
> > > pwebrecon = http://voyager.aber.ac.uk:8088/cgi-
> > > bin/Pwebrecon.cgi
> > > Although we are on Voyager 7, I have put a URL to Pwebrecon.cgi,
> > > but I didn't know if VuFind even uses it as it's not used in
> > > Voyager 7.x.x.
> > >
> > > While investigating this problem, I noticed that phpinfo()
> > > wasn't showing any support for OCI8 despite me following the
> > > install instructions. I eventually tracked the problem down to
> > > libaio1 needing installing also, once I had done that phpinfo()
> > > showed support for OCI8.
> > >
> > > Next I created a small test script on the VuFind server that
> > > made an OCI connection to our Voyager server and performed a
> > > select, this worked fine.
> > >
> > > So, it seems PHP can connect to our Voyager server, so I'm
> > > mystified as to what the problem might be.
> > >
> > > Any suggestions?
> > >
> > > Many thanks
> > > Andrew
> > > --
> > > Library Systems Team
> > > Information Services / Gwasanaethau Gwybodaeth
> > > Aberystwyth University/ Prifysgol Aberystwyth
> > > Aberystwyth, Ceredigion, SY23 3DZ, UK
> > > Tel./Ffôn: (+44) 01970 62 1851
> > > E-mail/E-bost: aa...@ab...
> > >
> > >
> > >
> > > -----------------------------------------------------------------
> > > -------------
> > > Crystal Reports - New Free Runtime and 30 Day Trial
> > > Check out the new simplified licensing option that enables
> unlimited
> > > royalty-free distribution of the report engine for externally
> > > facing
> > > server and web deployment.
> > > http://p.sf.net/sfu/businessobjects
> > > _______________________________________________
> > > Vufind-tech mailing list
> > > Vuf...@li...
> > > https://lists.sourceforge.net/lists/listinfo/vufind-tech
> >
> > Ken Herold
> > Library IS Director
> > Hamilton College
> > 198 College Hill Road
> > Clinton, NY 13323
> > 315-859-4487
> > kh...@ha...
> >
> >
> > ________________________________
> >
> > This email (including any attached files) is confidential and is for
> > the intended recipient(s) only. If you received this email by
> mistake,
> > please, as a courtesy, tell the sender, then delete this email.
> >
> > The views and opinions are the originator's and do not necessarily
> > reflect those of the University of Southern Queensland. Although all
> > reasonable precautions were taken to ensure that this email contained
> > no viruses at the time it was sent we accept no liability for any
> > losses arising from its receipt.
> >
> > The University of Southern Queensland is a registered provider of
> > education with the Australian Government (CRICOS Institution Code
> No's.
> > QLD 00244B / NSW 02225M)
|