[GNC] Problem retrieving exchange rates

John Ralls jralls at ceridwen.us
Sun Oct 21 10:55:24 EDT 2018


You probably figured out that you couldn’t run gnc-fq-update directly because it’s not on $PATH. All of the gnc-fq-foo scripts are in Gnucash.app/Contents/Resources/bin.

It’s disappointing that attempting to run xcrun no longer pops up a dialog offering to install command-line tools. It’s also unfortunate that Apple hasn’t updated perl for 10 years so the installed MakeMaker is out of date.

Regards,
John Ralls

> On Oct 21, 2018, at 5:08 AM, Geoff Jankowski via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> John
> 
> I experienced similar problems with f:q.
> 
> I tired to run gnc-fq-update through the terminal but it does not recognise the command.  I re-mounted gnucash 3.2-2.dmg and ran FinanceQuote Update from there and this is the failed output I got (see yellow highlights):
> 
> Last login: Sun Oct 21 13:07:24 on ttys001
> GJJ-iMac:~ gjj$ sudo '/Volumes/Gnucash-3.2/Gnucash.app/Contents/Resources/bin/gnc-fq-update'
> Password:
> 
> CPAN.pm requires configuration, but most of it can be done automatically.
> If you answer 'no' below, you will enter an interactive dialog for each
> configuration option instead.
> 
> Would you like to configure as much as possible automatically? [yes] 
> 
> <install_help>
> 
> Warning: You do not have write permission for Perl library directories.
> 
> To install modules, you need to configure a local Perl library directory or
> escalate your privileges.  CPAN can help you by bootstrapping the local::lib
> module or by configuring itself to use 'sudo' (if available).  You may also
> resolve this problem manually if you need to customize your setup.
> 
> What approach do you want?  (Choose 'local::lib', 'sudo' or 'manual')
> [local::lib] 
> 
> Autoconfigured everything but 'urllist'.
> 
> Now you need to choose your CPAN mirror sites.  You can let me
> pick mirrors for you, you can select them from a list or you
> can enter them by hand.
> 
> Would you like me to automatically choose some CPAN mirror
> sites for you? (This means connecting to the Internet) [yes] 
> Trying to fetch a mirror list from the Internet
> Fetching with LWP:
> http://www.perl.org/CPAN/MIRRORED.BY
> Fetching with LWP:
> http://www.perl.org/CPAN/MIRRORED.BY.gz
> Fetching with LWP:
> ftp://ftp.perl.org/pub/CPAN/MIRRORED.BY
> 
> Looking for CPAN mirrors near you (please be patient)
> ........................ done!
> 
> New urllist
>  http://ftp.lip6.fr/pub/perl/CPAN/
>  http://cpan.mirror.anlx.net/
>  http://ftp.tudelft.nl/cpan/
> 
> Autoconfiguration complete.
> 
> Attempting to bootstrap local::lib...
> 
> Writing /Users/gjj/.cpan/CPAN/MyConfig.pm for bootstrap...
> commit: wrote '/Users/gjj/.cpan/CPAN/MyConfig.pm'
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/authors/01mailrc.txt.gz
> Reading '/Users/gjj/.cpan/sources/authors/01mailrc.txt.gz'
> ............................................................................DONE
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/modules/02packages.details.txt.gz
> Reading '/Users/gjj/.cpan/sources/modules/02packages.details.txt.gz'
>  Database was generated on Sat, 20 Oct 2018 17:17:03 GMT
> .............
>  New CPAN.pm version (v2.16) available.
>  [Currently running version is v2.00]
>  You might want to try
>    install CPAN
>    reload cpan
>  to both upgrade CPAN.pm and run the new version without leaving
>  the current session.
> 
> ...............................................................DONE
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/modules/03modlist.data.gz
> Reading '/Users/gjj/.cpan/sources/modules/03modlist.data.gz'
> DONE
> Writing /Users/gjj/.cpan/Metadata
> Running make for H/HA/HAARG/local-lib-2.000024.tar.gz
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/authors/id/H/HA/HAARG/local-lib-2.000024.tar.gz
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/authors/id/H/HA/HAARG/CHECKSUMS
> Checksum for /Users/gjj/.cpan/sources/authors/id/H/HA/HAARG/local-lib-2.000024.tar.gz ok
> 
>  CPAN.pm: Building H/HA/HAARG/local-lib-2.000024.tar.gz
> 
> Attempting to create directory /Users/gjj/perl5
> 
> Dispatching deprecated method 'CPAN::Config::load' to CPAN::HandleConfig
> 
> Dispatching deprecated method 'CPAN::Config::load' to CPAN::HandleConfig
> Reading '/Users/gjj/.cpan/Metadata'
>  Database was generated on Sat, 20 Oct 2018 17:17:03 GMT
> Running install for module 'ExtUtils::MakeMaker'
> Running make for B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/authors/id/B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
> Fetching with LWP:
> http://ftp.lip6.fr/pub/perl/CPAN/authors/id/B/BI/BINGOS/CHECKSUMS
> Checksum for /Users/gjj/.cpan/sources/authors/id/B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz ok
> 
>  CPAN.pm: Building B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
> 
> Using included version of CPAN::Meta (2.143240) as it is newer than the installed version (2.133380).
> Using included version of ExtUtils::Manifest (1.70) as it is newer than the installed version (1.63).
> Using included version of CPAN::Meta::Requirements (2.131) as it is newer than the installed version (2.122).
> Using included version of ExtUtils::Install (2.06) as it is newer than the installed version (1.59).
> Using included version of CPAN::Meta::YAML (0.011) as it is newer than the installed version (0.008).
> Using included version of JSON::PP (2.27203) as it is newer than the installed version (2.27202).
> Using included version of Parse::CPAN::Meta (1.4414) as it is newer than the installed version (1.4404).
> Checking if your kit is complete...
> Looks good
> Generating a Unix-style Makefile
> Writing Makefile for ExtUtils::MakeMaker
> Writing MYMETA.yml and MYMETA.json
> xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
>  BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
>  /usr/bin/make -- NOT OK
> 'YAML' not installed, will not store persistent state
> Running make test
>  Can't test without successful make
> Running make install
>  Make had returned bad status, install seems impossible
> 
> Checking if your kit is complete...
> Looks good
> Warning: prerequisite ExtUtils::MakeMaker 7.00 not found. We have 6.66.
> Writing Makefile for local::lib
> Writing MYMETA.yml and MYMETA.json
> Use of uninitialized value in pattern match (m//) at /System/Library/Perl/5.18/CPAN/Distribution.pm line 2685.
> Use of uninitialized value in pattern match (m//) at /System/Library/Perl/5.18/CPAN/Distribution.pm line 2685.
> ---- Unsatisfied dependencies detected during ----
> ----      HAARG/local-lib-2.000024.tar.gz     ----
>    ExtUtils::MakeMaker [requires]
> Running make test
>  Delayed until after prerequisites
> Running make install
>  Delayed until after prerequisites
> Can't locate local/lib.pm in @INC (you may need to install the local::lib module) (@INC contains: /Users/gjj/perl5/lib/perl5 /Library/Perl/5.18/darwin-thread-multi-2level /Library/Perl/5.18 /Network/Library/Perl/5.18/darwin-thread-multi-2level /Network/Library/Perl/5.18 /Library/Perl/Updates/5.18.2 /System/Library/Perl/5.18/darwin-thread-multi-2level /System/Library/Perl/5.18 /System/Library/Perl/Extras/5.18/darwin-thread-multi-2level /System/Library/Perl/Extras/5.18 /Users/gjj) at /System/Library/Perl/5.18/CPAN/FirstTime.pm line 1300.
> GJJ-iMac:~ gjj$ 
> 
> So I then ran sudo cpan install ExtUtils::MakeMaker
> 
> and got the following output:
> 
> GJJ-iMac:~ gjj$ sudo cpan install ExtUtils::MakeMaker
> Password:
> Reading '/Users/gjj/.cpan/Metadata'
>  Database was generated on Sat, 20 Oct 2018 17:17:03 GMT
> Running install for module 'ExtUtils::MakeMaker'
> Running make for B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
> Checksum for /Users/gjj/.cpan/sources/authors/id/B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz ok
> 
>  CPAN.pm: Building B/BI/BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
> 
> Using included version of CPAN::Meta (2.143240) as it is newer than the installed version (2.133380).
> Using included version of ExtUtils::Manifest (1.70) as it is newer than the installed version (1.63).
> Using included version of CPAN::Meta::Requirements (2.131) as it is newer than the installed version (2.122).
> Using included version of ExtUtils::Install (2.06) as it is newer than the installed version (1.59).
> Using included version of CPAN::Meta::YAML (0.011) as it is newer than the installed version (0.008).
> Using included version of JSON::PP (2.27203) as it is newer than the installed version (2.27202).
> Using included version of Parse::CPAN::Meta (1.4414) as it is newer than the installed version (1.4404).
> Checking if your kit is complete...
> Looks good
> Generating a Unix-style Makefile
> Writing Makefile for ExtUtils::MakeMaker
> Writing MYMETA.yml and MYMETA.json
> xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
>  BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
>  /usr/bin/make -- NOT OK
> 'YAML' not installed, will not store persistent state
> Running make test
>  Can't test without successful make
> Running make install
>  Make had returned bad status, install seems impossible
> GJJ-iMac:~ gjj$ 
> 
> I do not know if Harald23 got the same issues as me but for some reason xcrun is not installed on my machine.  This is part of the developer tool kit that installs with x-code, a bloated piece of development software that most users will never use or need.  However it is possible to install the command line tools separately by running the following command in terminal:
> 
> xcode-select —install
> 
> It then gives an option to just install the tools without x-code.  Takes a while to download then install.  More information and a list of the tools dowloaded and installed can be found here:
> 
> http://osxdaily.com/2014/02/12/install-command-line-tools-mac-os-x/ <http://osxdaily.com/2014/02/12/install-command-line-tools-mac-os-x/>
> 
> Once the download was completed I tested it by typing xcrun in terminal and got this (partial) output:
> 
> Usage: xcrun [options] <tool name> ... arguments ...
> 
> Find and execute the named c…(etc).
> 
> This demonstrated that it was installed so I ran FinanceQuote Update again and this time, after a lot of script in terminal I got the following message:
> 
>  ECOCODE/Finance-Quote-1.47.tar.gz
>  /usr/bin/make install  -- OK
> GJJ-iMac:~ gjj$ 
> 
> Harald23 may need to do the same.  I do not know if the FinanceQuote Update applescript can run initial tests for the developer kit tools or not but it would seem sensible if it could together with a message on what to do if they are not found?
> 
> I do not personally use f:q so cannot test it within gnucash but I am sure it will now work, perhaps harald23 could confirm if he does the same installation as me?
> 
> Geoff 
> +44 20 7100 1092
> +44 7770 58 48 38
> +33 5 46 97 13 89
> +33 6 22 93 00 53
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On 21 Oct 2018, at 07:02, John Ralls <jralls at ceridwen.us> wrote:
> 
> 
> 
>> On Oct 20, 2018, at 1:39 PM, harold <harold23 at gmail.com> wrote:
>> 
>> Hi,
>> I'm a new gnucash user running on macOS Mojave. I've installed gnucash and
>> run the finance quotes updater app.
>> 
>> When I try to "Get Quotes", gnucash returns an error message saying
>> 
>>> There was a system error when retrieving the price quotes
>> 
>> 
>> When running the finance quotes updater app it completes, but there seem to
>> be some error messages, which I don't know what to do about. Here are the
>> last few lines of the file:
>> 
>> ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at
>> Makefile.PL line 8.
>> 
>> BEGIN failed--compilation aborted at Makefile.PL line 8.
>> 
>> Warning: No success on command[/usr/bin/perl Makefile.PL]
>> 
>> SBECK/Date-Manip-6.72.tar.gz
>> 
>> /usr/bin/perl Makefile.PL -- NOT OK
>> 
>> Running make test
>> 
>> Make had some problems, won't test
>> 
>> Running make install
>> 
>> Make had some problems, won't install
>> 
>> Could not read metadata file. Falling back to other methods to determine
>> prerequisites
>> Finance::Quote is up to date (1.47).
>> 
>> Does anyone have any ideas on how to fix this?
> 
> I just ran gnc-fq-update (which is what Finance::Quote Update does, wrapped in an AppleScript) on 10.14.1 Developer Beta 18867a without any issues. It updated Date-Manip-6.72 cleanly. Digging in a bit more I find that I have an updated MakeMaker.pm as well as the 6.66 apparently distributed by Apple. You can probably fix that with 
> sudo cpan install ExtUtils::MakeMaker
> in Terminal.
> 
> That said, as long as you have some version of Date::Manip you should be OK on that front, and you do have the latest Finance::Quote. The problem you’re having is likely with the stocks you’re trying to get quotes for.
> 
> Try running GnuCash from Terminal:
> /Applications/Gnucash.app/Contents/MacOS/Gnucash --log gnc.scm=debug
> That should print each symbol as it requests it along with the result of the request. It might provide some more info about the errors.
> 
> Regards,
> John Ralls
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list