Brian, It points to something getting borked with perl. After all, Safari and curl both successfully fetch the URI, so it's not a networking problem.
Date::Manip installed successfully, ergo ExtUtils::MakeMaker is now happy. The Extras/5.18 folder where DateTime and LWP live is in /System/Library/Perl not /Library/Perl. I'm out of ideas why Yahoo!'s JSON server won't talk to your perl when it has no trouble with mine. The only thing left I can think of to try is to update LWP with sudo cpan -i LWP Regards, John Ralls > On Mar 26, 2019, at 9:14 PM, Bruno Acklin <back...@gmail.com> wrote: > > 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 > 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.
