[GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

Fri Jan 22 10:17:01 EST 2021

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 <jtraglia at 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, <davelist at mac.com> wrote:
> 
>> Chris, do you have an M1 or Intel Mac?
>> 
> 
>>> On Jan 21, 2021, at 6:02 PM, Chris Graves mohavebaked at 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 at gnucash.org wrote:
>>>> 
> 
>>>>> On Jan 21, 2021, at 12:12 PM, John Ralls jralls at ceridwen.us wrote:
>>>>> 
> 
>>>>>> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user gnucash-user at 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 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.
> <publickey - jtraglia at pm.me - 0x04DB65EA.asc>