So... it doesn't actually work quite yet, but GnuCash does recognize it. Attempting to get quotes via the GnuCash-cli program results in a "unable to retrieve quotes for these items" message, followed by all of my securities.
The following will not work. It shows a bunch of missing dependency errors. This is because I installed F::Q manually, and its dependencies were not installed. > echo '(yahoo_json "FSKAX")' | perl -w gnc-fq-helper So I reinstalled perl (and wiped all of the modules). Then tried to install F::Q via the Perl shell. If I do: > sudo perl -MCPAN -e shell > > install Finance::Quote It will fail with the following error messages: > Result: PASS > > ECOCODE/Finance-Quote-1.49.tar.gz > > Tests succeeded but one dependency not OK (LWP::Protocol::https) > > ECOCODE/Finance-Quote-1.49.tar.gz > > [dependencies] -- NA > > Failed during this command: > > CHRISN/Net-SSLeay-1.90.tar.gz : make NO > > SULLR/IO-Socket-SSL-2.068.tar.gz : make_test NO one dependency not OK > (Net::SSLeay); additionally test harness failed > > OALDERS/LWP-Protocol-https-6.10.tar.gz : make_test NO 2 dependencies missing > (IO::Socket::SSL,IO::Socket::SSL::Utils); additionally test harness failed > > ECOCODE/Finance-Quote-1.49.tar.gz : make_test NO one dependency not OK > (LWP::Protocol::https) Net::SSLeay fails because it cannot find the "openssl/err.h" header. I've installed openssl (with brew) and added the include directory to $LIBRARY_PATH, but it still doesn't find it. This is the root of the problem. I'm pretty sure if Net::SSLeay could be installed, everything else would fall in place. If anyone knows how to get this working, please let me know. I'll probably spend a little more time trying to figure it out tomorrow. Regards, Justin ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, January 22nd, 2021 at 5:17 PM, Justin <jtrag...@pm.me> wrote: > Woo. I've made progress. So I manually installed the latest F::Q from there > GitHub release (following their instructions): > https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 > > This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q > v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by > itself, it still prints F::Q v1.49. > > Next, I tried running GnuCash from the ApplicationLauncher (or whatever it's > called) but alas, F::Q didn't work. Then, I tried running GnuCash from the > terminal. This **does** work! The GUI application shows F::Q v1.50. > > I'm going to mess around with it a little more. I'm unsure why there's a > discrepancy. > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > On Friday, January 22nd, 2021 at 5:07 PM, Justin <jtrag...@pm.me> wrote: > > > Alright. I think I might have found part of the issue. > > > > According to this line in GnuCash source, gnc-fq-check is run as an > > argument to perl: > > https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 > > > > So I tried that out and it says F::Q is not installed. > > > > > $ perl -w gnc-fq-check > > > You need to install the following Perl modules: > > > Finance::Quote > > > Use your system's package manager to install them, > > > or run 'gnc-fq-update' as root. > > > missing-lib > > > > So I re-run what it says, but it doesn't make a difference: > > > > > $ sudo ./gnc-fq-update > > > Password: > > > Reading '/Users/jtraglia/.cpan/Metadata' > > > Database was generated on Fri, 22 Jan 2021 00:41:03 GMT > > > Date::Manip is up to date (6.83). > > > Finance::Quote is up to date (1.49). > > > > Lemme try installing F::Q another way. > > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > On Friday, January 22nd, 2021 at 4:41 PM, Justin <jtrag...@pm.me> wrote: > > > > > John, sorry I forgot to check if launching GnuCash from the terminal > > > makes a difference. F::Q does not work if I run GnuCash from the > > > terminal. Good idea though. > > > > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > > On Friday, January 22nd, 2021 at 4:38 PM, David H <hell...@gmail.com> > > > wrote: > > > > > > > I think that's what John meant in the second message he posted in this > > > > thread re running under Rosetta2 ..... > > > > > > > > >> BigSur absolutely is supported. What's not yet available yet is a > > > > >> native build for Apple Silicon, but I've found so far that the Intel > > > > >> build of GnuCash works fine with Rosetta2. > > > > > > > > >> The BigSur upgrade seems to have messed up perl; I had to reinstall > > > > >> F::Q to get it working after I upgraded, but one could also set > > > > >> $PERL5LIB in the environment to include > > > > >> the old /Library/perl/5.18 as a workaround. If you did that in a > > > > >>shell rc file it would make gnc-fq-helper work from terminal but not > > > > >>from GnuCash when run from LaunchServices. > > > > > > > > >> Does F::Q work when starting GnuCash from the terminal? > > > > > > > > >> Regards, > > > > >> John Ralls > > > > > > > > Cheers David H. > > > > > > > > > > > > On Sat, 23 Jan 2021 at 07:54, Chris Graves <mohaveba...@gmail.com> > > > > wrote: > > > > > > > > > John Ralls, have you had success running F::Q on an M1 Mac (I seem to > > > > > recall that you had a dev kit)? > > > > > > > > > > > On Jan 22, 2021, at 1:11 PM, Justin <jtrag...@pm.me> wrote: > > > > > > > > > > > > Chris, this did not fix my issue. > > > > > > > > > > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > > > > > > > > > > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves > > > > > > <mohaveba...@gmail.com> wrote: > > > > > > > > > > > >> I reinstalled (on my Intel Mac) by running: > > > > > >> > > > > > > > > > > > >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > > > > >> > > > > > > > > > > > >>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > > > > > >>> > > > > > > > > > > > >>> Hello all, thank you for replying. I'm new to this email list. > > > > > >>> > > > > > > > > > > > >>> Dave, I do have an M1 Mac. Maybe that's part of the problem. > > > > > >>> > > > > > > > > > > > >>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" > > > > > >>> doesn't have an uninstall option. I did manually upgrade F::Q > > > > > >>> though, no change. Gnucash-cli still thinks it's installed > > > > > >>> improperly. > > > > > >>> > > > > > > > > > > > >>> Thanks, > > > > > >>> > > > > > > > > > > > >>> Justin > > > > > >>> > > > > > > > > > > > >>> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > > > > >>> > > > > > > > > > > > >>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com > > > > > >>> wrote: > > > > > >>> > > > > > > > > > > > >>>> Chris, do you have an M1 or Intel Mac? > > > > > >>> > > > > > > > > > > > >>>>> On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com > > > > > >>>>> wrote: > > > > > >>> > > > > > > > > > > > >>>>> Just another point of information, I had the same issue, but it > > > > > >>>>> was resolved after reinstalling F::Q as John mentions below. > > > > > >>> > > > > > > > > > > > >>>>>> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > > > > > >>>>>> gnucash-user@gnucash.org wrote: > > > > > >>> > > > > > > > > > > > >>>>>>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us > > > > > >>>>>>> wrote: > > > > > >>> > > > > > > > > > > > >>>>>>>> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user > > > > > >>>>>>>> gnucash-user@gnucash.org wrote: > > > > > >>> > > > > > > > > > > > >>>>>>>> Hello everyone, > > > > > >>> > > > > > > > > > > > >>>>>>>> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) > > > > > >>>>>>>> on macOS Big Sur (11.0). Despite not being officially > > > > > >>>>>>>> supported, GnuCash itself works great, with the exception of > > > > > >>>>>>>> Finance::Quote. The "get quotes" button in the Price > > > > > >>>>>>>> Database is grayed out and the Security Editor has the > > > > > >>>>>>>> warning "Finance::Quote isn't installed properly." When > > > > > >>>>>>>> running Gnucash-cli, there is a similar error: > > > > > >>> > > > > > > > > > > > >>>>>>>>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > > > > > >>>>>>>>> --quotes get > > > > > >>>>>>>>> /Users/username/Documents/Finances/Tracking/finances.gnucash > > > > > >>>>>>>>> --debug > > > > > >>> > > > > > > > > > > > >>>>>>>>> Application Path > > > > > >>>>>>>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > > > > > >>> > > > > > > > > > > > >>>>>>>>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: > > > > > >>>>>>>>> [mac_set_languages()] Language list: en:en_US:C > > > > > >>> > > > > > > > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.backend.dbi> > > > > > >>>>>>>>> [gnc_module_init_backend_dbi] 3 DBD drivers found > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.backend.dbi> > > > > > >>>>>>>>> [gnc_module_init_backend_dbi] Driver: pgsql > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.backend.dbi> > > > > > >>>>>>>>> [gnc_module_init_backend_dbi] Driver: sqlite3 > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.backend.dbi> > > > > > >>>>>>>>> [gnc_module_init_backend_dbi] Driver: mysql > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.gui> [Gnucash::CoreApp::start] > > > > > >>>>>>>>> System locale returned (null) > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.gui> [Gnucash::CoreApp::start] > > > > > >>>>>>>>> Effective locale set to en_US.UTF-8. > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.app-utils.gsettings> > > > > > >>>>>>>>> [gnc_gsettings_register_cb] schema: general, key: > > > > > >>>>>>>>> retain-days, settings_ptr: 0x7fde7e839430, handler_id: 1 > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.app-utils.gsettings> > > > > > >>>>>>>>> [gnc_gsettings_register_cb] schema: general, key: > > > > > >>>>>>>>> retain-type-never, settings_ptr: 0x7fde7e839430, > > > > > >>>>>>>>> handler_id: 2 > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.app-utils.gsettings> > > > > > >>>>>>>>> [gnc_gsettings_register_cb] schema: general, key: > > > > > >>>>>>>>> retain-type-days, settings_ptr: 0x7fde7e839430, handler_id: > > > > > >>>>>>>>> 3 > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.app-utils.gsettings> > > > > > >>>>>>>>> [gnc_gsettings_register_cb] schema: general, key: > > > > > >>>>>>>>> retain-type-forever, settings_ptr: 0x7fde7e839430, > > > > > >>>>>>>>> handler_id: 4 > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.app-utils.gsettings> > > > > > >>>>>>>>> [gnc_gsettings_register_cb] schema: general, key: > > > > > >>>>>>>>> file-compression, settings_ptr: 0x7fde7e839430, handler_id: > > > > > >>>>>>>>> 5 > > > > > >>> > > > > > > > > > > > >>>>>>>>> No quotes retrieved. Finance::Quote isn't installed > > > > > >>>>>>>>> properly. > > > > > >>>>>>>>> > > > > > > > > > > > >>>>>>>>> - 22:01:17 INFO <gnc.engine> [gnc_hook_lookup] no hook > > > > > >>>>>>>>> lists > > > > > >>> > > > > > > > > > > > >>>>>>>> The error message above isn't particularly useful. It gets > > > > > >>>>>>>> printed here: > > > > > >>> > > > > > > > > > > > >>>>>>>> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91 > > > > > >>> > > > > > > > > > > > >>>>>>>> I'm pretty sure that Finance::Quote itself is installed > > > > > >>>>>>>> properly. I'm not really sure why GnuCash does not recognize > > > > > >>>>>>>> it. > > > > > >>> > > > > > > > > > > > >>>>>>>>> $ sudo gnc-fq-update > > > > > >>> > > > > > > > > > > > >>>>>>>>> Reading '/Users/username/.cpan/Metadata' > > > > > >>> > > > > > > > > > > > >>>>>>>>> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT > > > > > >>> > > > > > > > > > > > >>>>>>>>> Date::Manip is up to date (6.83). > > > > > >>> > > > > > > > > > > > >>>>>>>>> Finance::Quote is up to date (1.49). > > > > > >>> > > > > > > > > > > > >>>>>>>> A basic query shows that it does work: > > > > > >>> > > > > > > > > > > > >>>>>>>>> $ echo '(yahoo_json "CSCO")' | > > > > > >>>>>>>>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper > > > > > >>> > > > > > > > > > > > >>>>>>>>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 > > > > > >>>>>>>>> 12:00:00") (last . #e45.19) (currency . "USD"))) > > > > > >>> > > > > > > > > > > > >>>>>>> BigSur absolutely is supported. What's not yet available yet > > > > > >>>>>>> is a native build for Apple Silicon, but I've found so far > > > > > >>>>>>> that the Intel build of GnuCash works fine with Rosetta2. > > > > > >>> > > > > > > > > > > > >>>>>>> The BigSur upgrade seems to have messed up perl; I had to > > > > > >>>>>>> reinstall F::Q to get it working after I upgraded, but one > > > > > >>>>>>> could also set $PERL5LIB in the environment to include the > > > > > >>>>>>> old /Library/perl/5.18 as a workaround. If you did that in a > > > > > >>>>>>> shell rc file it would make gnc-fq-helper work from terminal > > > > > >>>>>>> but not from GnuCash when run from LaunchServices. > > > > > >>> > > > > > > > > > > > >>>>>>> Does F::Q work when starting GnuCash from the terminal? > > > > > >>> > > > > > > > > > > > >>>>>>> Regards, > > > > > >>> > > > > > > > > > > > >>>>>>> John Ralls > > > > > >>> > > > > > > > > > > > >>>>>> I can confirm the same issue - quotes work from the command > > > > > >>>>>> line (after re-installing finance quote) but in gnucash, the > > > > > >>>>>> "get quotes" button is disabled. I am running this on an M1 > > > > > >>>>>> Mac (so obviously Big Sur). My old Mac (where quotes work) is > > > > > >>>>>> running Catalina (and the M1 Mac was set up from a Time > > > > > >>>>>> Machine backup of the old Maco) so I don't know if it's a M1 > > > > > >>>>>> issue or a Big Sur issue. > > > > > >>> > > > > > > > > > > > >>>>>> Justin, are you using an M1 Mac? > > > > > >>> > > > > > > > > > > > >>>>>> Thanks, > > > > > >>> > > > > > > > > > > > >>>>>> Dave > > > > > >>> > > > > > > > > > > > >>>>>> 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. > > > > > >>>>>> > > > > > > > > > > > >>>>>> <publickey - jtrag...@pm.me - 0x04DB65EA.asc> > > > > > > <publickey - jtrag...@pm.me - 0x04DB65EA.asc> > > > > > > > > > > _______________________________________________ > > > > > 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.
publickey - jtraglia@pm.me - 0x04DB65EA.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature
_______________________________________________ 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.