| Subject: | system error retrieving currency quotes with 1.15/1.13 on Ubuntu 8.04 -- ssl libraries path bad? |
| Date: | Fri, 21 Nov 2008 14:15:05 +0700 |
| To: | bug-finance-quote [...] rt.cpan.org |
| From: | Nate Jones <nate_jones [...] sil.org> |
Hello,
I am running fq 1.15 on Ubuntu 8.04 with Gnucash 2.2.4. I am running
Perl 5.8 and I have attached the system readout for uname, perl -v etc.
to this message. I have imported my set of accounts from Windows, where
I ran Gnucash 2.2.7 with fq 1.15 and Perl 5.10. Using Windows, with the
exception of currency IDR, which always seemed to be unavailable, I was
able to look up all these securities with no problems using the Get
Quotes function in Gnucash Price Editor dialog. Using Ubuntu with the
same accounts, I get a System Error when I press Get Quotes for the same
set of accounts. I also am unable to obtain the quotes by running fq
from the command line.
Here is the list of securities I need to look up on a daily basis:
Currency:
IDR
SGD
THB
NYSE:
AGTHX
ANWPX
AWSHX
SMCWX
Originally, I installed gnucash, fq and ssleay perl libraries using the
synaptic package manager in ubuntu. As I remember, fq worked at my first
test (using SGD). I then installed some other packages and imported my
regular set of accounts the next day, expecting fq to work properly.
Suddenly, Get Quotes produced a system error when attempting to retrieve
quotes. I tried gnc-fq-check and gnc-fq-dump and fq seemed to work
properly. I tried to look up GOOG and AMZN using fq from the command
line and had no trouble. I was unable to obtain GOOG from the Get Quotes
button in GnuCash, though. FQ would not retrieve SGD or EURO currency
quotes from the command line. I have attached the gnc-fq-dump and
gnc-fq-dump -v readouts to this email.
I ran gnc-fq-update and the update could not find my SSL libraries,
though I had installed the package. The update asked me to specify a
path to my ssl libraries and I guessed that the folder libssl0.9.8 was
the correct folder. I specified the path to the folder but not inside
the folder. The update could not find SSL and installed 1.15 anyways. I
have attached this portion of the gnc-fq-update readout to this email.
After 1.15 was installed, I verified that gnucash was using 1.15 using
gnc-fq-check. I then tried gnc-fq-dump but had the same problems with
the SGD currency. When I tried to push the Get Quotes button in Gnucash,
I received a System Error again.
I think that for some reason the default install path for the SSL
libraries in Ubuntu is not recognized by the gnc-fq-update process and
that somehow fq is not accessing the SSL libraries. I noted that the
update asked me to file a bug report if my file path was standard and
not recognized. I did not alter the file path when I installed ssleay
from the Ubuntu repositories, so I assume it is a standard path.
Is there a way to specify the correct path to the SSL libraries? If so,
which SSL folder or file is correct and where do I specify that path? I
can't think of anything else that could be wrong, but perhaps you can
find another problem via these readouts.
Thanks for your help! I really hope I can get this working.
Nate
~$ perl -v
This is perl, v5.8.8 built for i486-linux-gnu-thread-multi
Copyright 1987-2006, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
nate@dell-desktop:~$ uname -a
Linux dell-desktop 2.6.24-21-generic #1 SMP Tue Oct 21 23:43:45 UTC 2008 i686 GNU/Linux
nate@dell-desktop:~$ gnc-fq-dump yahoo AMZN
Finance::Quote fields Gnucash uses:
symbol: AMZN <=== required
date: 11/20/2008 <=== required
currency: USD <=== required
last: 35.03 <=\
nav: <=== one of these
price: 35.03 <=/
timezone: <=== optional
nate@dell-desktop:~$ gnc-fq-dump yahoo USD
Finance::Quote fields Gnucash uses:
symbol: USD <=== required
date: 11/20/2008 <=== required
currency: USD <=== required
last: 10.50 <=\
nav: <=== one of these
price: 10.50 <=/
timezone: <=== optional
nate@dell-desktop:~$ gnc-fq-dump yahoo SGD
Finance::Quote fields Gnucash uses:
symbol: SGD <=== required
date: ** missing ** <=== required
currency: <=== required
last: 0.00 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
** This stock quote cannot be used by gnucash!!
nate@dell-desktop:~$ gnc-fq-dump -v yahoo SGD
Finance::Quote fields Gnucash uses:
symbol: SGD <=== required
date: ** missing ** <=== required
currency: ** missing ** <=== required
last: 0.00 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
** This stock quote cannot be used by gnucash!!
All fields returned by Finance::Quote for stock SGD
stock field value
----- ----- -----
SGD ask:
SGD avg_vol: 0
SGD bid:
SGD cap:
SGD close:
SGD date:
SGD day_range: N/A - N/A
SGD div:
SGD div_date:
SGD div_yield:
SGD eps:
SGD errormsg: Stock lookup failed
SGD ex_div:
SGD last: 0.00
SGD name: SGD
SGD net:
SGD open:
SGD p_change:
SGD pe:
SGD success: 0
SGD symbol: SGD
SGD time:
SGD volume:
SGD year_range: N/A - N/A
Message body is not shown because it is too large.