[GNC] Error running gnucash-cli --quote dump

[John Ralls]

Somebody else mentioned the MySql problem a couple of weeks ago. I haven’t had time to look into it yet. If you’re not using the MySQL backend you can ignore it, otherwise you’ll want to roll back to 5.9.

“Not enough information for quotes dump” is because you didn’t tell it a quote to dump. You probably want to say

  flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump currency USD AUD

My guess is that the failure to get an exchange rate was either a transient or that you’d used up your Alphavantage quota of 25 prices for the day.

Regards,
John Ralls



> On Dec 28, 2024, at 8:03 PM, Justin Smith <justin at smithpolglase.com> wrote:
> 
> I have GnuCash 5.10 installed via flatpak on an Ubuntu 24.04 PC.
> 
> When running (from the command line):
> flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump
> 
> I get the following error:
> /app/lib/dbd/libdbdmysql.so: undefined symbol: mysql_ping
> libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so
> Not enough information for quotes dump
> 
> BTW I ran into this error while trying to troubleshoot another issue when
> updating quotes. I get a pop-up window with the text:
> 
> Quotes for the following commodities owere unavailable or unusable:
> * CURRENCY:USD Finance::Quote reported failure set no error
> 
> I have GnuCash set up with AUD as the default currency but one of the
> securities is quoted in USD.
> 
> Does anyone know how to fix either of these issues?
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.