Hi John, Sorry if I was unclear: the sudo cpan -i Finance::Quote install seemed to have succeeded without error messages, but execution still fails as before.
I upgraded Xcode to 10.2 and there seems no longer an option to add command line tools from Preferences. My Library/Developer only contained /PrivateFrameworks/CoreSimulator.framework and /ROCKit.framework. So I followed instructions from the link https://donatstudios.com/MojaveMissingHeaderFile <https://donatstudios.com/MojaveMissingHeaderFile> to install /CommandLineTools, where I found and installed the macOS_SDK_headers_for_macOS_10.14.pkg you suggested. I would not know where to look if this fixed ExtUtils::MakeMaker, as other than for the /CommandLineTools my /Library/Developer and /Library/Perl folders looked unchanged. So I deleted Finance-Quote* and Date-Manip* again in Library/Perl and ~/.cpan/build, and reinstalled Date::Manip and Finance::Quote from clan. Now my Library/Perl/5.18 contains: /CPAN, /Date, /Devel, /ExtUtils, /Finance, /HTML, /JSON, /Mozilla, /Parse, /Pod, /Test, /Darwin-thread-multi-2level, as well as AppendToPath and JSON.pm, butno /LWP /DateTime (still at 10.14.3, but like your new 10.14.4 install) or a /Perl/Extras/5.18 folder. Unfortunately, again no success: /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json aapl Still fails and returns: .. All fields returned by Finance::Quote for stock aapl stock field value ----- ----- ----- aapl errormsg: Error retrieving quote for aapl. Attempt to fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in HTTP response 500 (Internal Server Error) aapl last: **missing** aapl nav: **missing** aapl price: **missing** aapl success: 0 aapl symbol: aapl Interestingly though, calling the same URL from the Safari browser instantly returns successful quotes.. I am still stuck with the fact that selecting “Get Quotes” from the "Price Editor” in Gnucash worked fine one week, and not a week later from the same Gnucash instance still open and running on my desktop, without closing the program, installing any software, or modifying my system, other than installing a new router… Does that not point to something outside the OSX and Perl installation? Thanks and Best, Bruno > On Mar 25, 2019, at 10:44 PM, John Ralls <jra...@ceridwen.fremont.ca.us> > wrote: > > Bruno, > > It turns out that Apple decided to put the perl headers exclusively in the > Xcode SDK but their perl patch doesn't quite work. Gory details may be read > at https://rt.cpan.org/Public/Bug/Display.html?id=127028. > > The work-around in the last post to that bug, installing command-line tools > and then installing > /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg > got me a clean ExtUtils::MakeMaker install without the whining about > EXTERNAL.h. With that in place Date::Manip will also install correctly. > > I just found /System/Library/Perl/Extras/5.18/. It has DateTime and LWP, > explaining why F::Q doesn't complain about not finding them when they're not > in /Library/Perl. In fact in the course of installing Command Line Tools I > also got a system upgrade (from 10.14.4beta to 10.14.4) and that removed > DateTime and LWP from /Library/Perl/5.18 on my system. It didn't break > Finance::Quote, so I guess LWP is ruled out as the source of your problem. > > When you say that Finance::Quote seems to work without problem does that mean > that stockdump.pl works but gnc-fq-dump still reports a 500 error? > > Regards, > John Ralls > > > >> On Mar 25, 2019, at 4:37 PM, Bruno Acklin <back...@gmail.com> wrote: >> >> Hi John, >> >> I was referring to MacHD/Library/Perl, so proceeded following your >> suggestions. >> >> The rm commands worked. >> Tried installing Date::Manip, as you suggested, which generated a long log >> (attached in full), but seems to have failed for the following reasons (I >> noticed): >> 'YAML' not installed, will not store persistent state >> .. >> # Test.xs:1:10: fatal error: 'EXTERN.h' file not found >> # #include "EXTERN.h" >> # ^~~~~~~~~~ >> # 1 error generated. (several times) >> .. >> Test Summary Report >> ------------------- >> t/02-xsdynamic.t (Wstat: 3072 Tests: 72 Failed: 12) >> Failed tests: 4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64 >> 70 >> Non-zero exit status: 12 >> Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr 0.15 sys + 25.66 cusr >> 9.00 csys = 35.15 CPU) >> Result: FAIL >> Failed 1/67 test programs. 12/1335 subtests failed. >> make: *** [test_dynamic] Error 255 >> BINGOS/ExtUtils-MakeMaker-7.34.tar.gz >> /usr/bin/make test -- NOT OK >> //hint// to see the cpan-testers results for installing this module, try: >> reports BINGOS/ExtUtils-MakeMaker-7.34.tar.gz >> Running make install >> make test had returned bad status, won't install without force >> Running make for S/SB/SBECK/Date-Manip-6.76.tar.gz >> Warning: Prerequisite 'ExtUtils::MakeMaker => 6.67_01' for >> 'SBECK/Date-Manip-6.76.tar.gz' failed when processing >> 'BINGOS/ExtUtils-MakeMaker-7.34.tar.gz' with 'make_test => NO'. Continuing, >> but chances to succeed are limited. >> >> CPAN.pm: Building S/SB/SBECK/Date-Manip-6.76.tar.gz >> >> 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.76.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. >> >> sudo cpan -i Finance::Quote seems to work fine and complete w/o errors, but >> gc-fnc-helper and -dump keep failing with same results as before. >> >> I may have screwed up this sandbox installation, but checked contents of my >> desktop which worked before but fails now as well and has not been changed >> to the best log my knowledge: (It contains date Date, Finance, but >> apparently lacks DateTime, LWP, LWP.pm) >> >> 5.18 >> CPAN >> Darwin-thread-multi-2level >> Date >> ExtUtils >> Finance >> HTML >> JSON >> Mozilla >> Parse >> Test >> AppendToPath >> JSON.pm >> Updates >> 5.18.2 >> Darwin-thread-multi-2level >> >> Best, Bruno >> >>> On Mar 24, 2019, at 3:08 PM, John Ralls <jra...@ceridwen.fremont.ca.us> >>> wrote: >>> >>> Bruno, >>> >>> No, there's no reason to install a fake-linux package manager. >>> >>> You said "Library/Perl", does that mean /Users/backlin/Library/Perl or >>> /Library/Perl? It should be the latter. If it's the former, what's in >>> /Library/Perl? >>> >>> Assuming that it *is* /Library/Perl, there are several packages that should >>> be there and aren't. I suggest >>> sudo rm -rf /Library/Perl/5.18/Finance >>> sudo rm -rf ~/.cpan/build/Finance-Quote* >>> sudo rm -rf -/.cpan/build/Date-Manip* >>> sudo cpan -i Date::Manip >>> sudo cpan -i Finance::Quote >>> >>> Check the output of those last two to make sure that they complete >>> successfully. Reinstalling Finance::Quote should pull in the other >>> packages. After it's done /Library/Perl/5.18 should contain Date, DateTime, >>> Finance, LWP, and LWP.pm in addition to the modules already there. >>> >>> Regards, >>> John Ralls >>> >>> >>>> On Mar 24, 2019, at 2:36 PM, Bruno Acklin <back...@gmail.com> wrote: >>>> >>>> Hi John, >>>> >>>> Sorry for the omission and delay. >>>> >>>> No, I have none of these “fake-Linux package managers”(?) installed - >>>> should I? >>>> >>>> The reply to backlin$ which perl is >>>> /usr/bin/perl >>>> >>>> In usr/bin I find two entries: >>>> perl and >>>> perl5.18 >>>> >>>> The directory Library/Perl contains >>>> /5.18 >>>> /Darwin-thread-multi-2level >>>> /Finance >>>> /HTML >>>> /JSON >>>> /Mozilla >>>> /AppendToPath >>>> /JSON.pm >>>> /Updates >>>> /5.18.2 >>>> /Darwin-thread-multi-2level >>>> >>>> Looking up contents of >>>> ~/.cpan/build/ : >>>> Date-Manip-6.75-JzZ9Wt ExtUtils-MakeMaker-7.34-_6iXcq >>>> Date-Manip-6.76-9mWyaN Finance-Quote-1.47-_BUlzK >>>> Date-Manip-6.76-NE8c76 Finance-Quote-1.47-nChsgf >>>> Date-Manip-6.76-QNnn65 HTML-TableExtract-2.15-dP4w2A >>>> ExtUtils-MakeMaker-7.34-695wh2 JSON-4.02-RrPsdw >>>> ExtUtils-MakeMaker-7.34-DVwu8U Mozilla-CA-20180117-TgJL7x >>>> ExtUtils-MakeMaker-7.34-U01uzs >>>> >>>> Trying your suggestion with /stockdump.pm for both fnq builds I get a >>>> delayed, identical result, even if I misspell aap(l) for a non-existing >>>> ticker: >>>> >>>> backlin$ ~/.cpan/build/Finance-Quote-1.47-_BUlzK/Examples/stockdump.pl >>>> yahoo_json aapl >>>> $VAR1 = { >>>> 'aaplsymbol' => 'aapl', >>>> 'aaplsuccess' => 0, >>>> 'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt to fetch >>>> the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl >>>> resulted in HTTP response 500 (Internal Server Error)' >>>> >>>> and >>>> backlin$ ~/.cpan/build/Finance-Quote-1.47-nChsgf/Examples/stockdump.pl >>>> yahoo_json aap >>>> $VAR1 = { >>>> 'aapsymbol' => 'aap', >>>> 'aapsuccess' => 0, >>>> 'aaperrormsg' => 'Error retrieving quote for aap. Attempt to fetch >>>> the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aap >>>> resulted in HTTP response 500 (Internal Server Error)' >>>> }; >>>> >>>> I am hoping this might give you a clue. I have no idea what could have >>>> gone wrong. Just that finance quote stopped working on my desktop and my >>>> laptop the same week, when I did not do anything on my system, not even >>>> reboot, other than changing the network access updating the router >>>> configuration. >>>> >>>> Thanks, and best, Bruno >>>> >>>> >>>>> On Mar 22, 2019, at 7:46 PM, John Ralls <jra...@ceridwen.fremont.ca.us> >>>>> wrote: >>>>> >>>>> Please remember to copy the list on all replies. >>>>> >>>>> Curl and your browser working exonerates your router. >>>>> >>>>> *Re*-installing perl would I think be challenging; it's provided as part >>>>> of MacOS so I'd think that the only safe way to do it would be to >>>>> reinstall the OS. >>>>> >>>>> That said, do you have any of the fake-Linux package managers--Homebrew, >>>>> MacPorts, or Fink--installed? >>>>> >>>>> What's the output of running >>>>> which perl >>>>> from the command line? >>>>> How about >>>>> ~/.cpan/build/Finance-Quote-1.47-XXXXXX/Examples/stockdump.pl yahoo_json >>>>> aapl >>>>> (the XXXXXX bit is random characters that depends on the installation). >>>>> >>>>> Regards, >>>>> John Ralls >>>>> >>>>>> On Mar 22, 2019, at 3:31 PM, Bruno Acklin <back...@gmail.com> wrote: >>>>>> >>>>>> No, I get an instant reply with content: >>>>>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq >>>>>> Real Time Price","currency":"USD","regularMarketPrice":191.05,.. >>>>>> >>>>>> Same if I use the fnc query from my browser: >>>>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl >>>>>> >>>>>> Any other ideas, especially related to the router change? >>>>>> >>>>>> Is there a point and safe way in reinstalling all of PERL on MacOS >>>>>> Mojave? >>>>>> >>>>>> Best, Bruno >>>>>> >>>>>>> On Mar 22, 2019, at 12:05 PM, John Ralls >>>>>>> <jra...@ceridwen.fremont.ca.us> wrote: >>>>>>> >>>>>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl >>>>>> >>>>> >>>> >>>> _______________________________________________ >>>> gnucash-user mailing list >>>> gnucash-user@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@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@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.
