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

[Justin Smith]

Thanks John.

I am running a new install of GnuCash (not an upgrade) and I had forgotten
to set the Alphavantage key. That fixed it.

I'm not using MySql so I'll ignore the library error.

Cheers,
Justin.

On Wed, 1 Jan 2025 at 06:25, John Ralls <jralls at ceridwen.us> wrote:

> 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.
>
>