Red Hat Bugzilla – Bug 101571
The URL postgres://... is not supported by this version of GnuCash
Last modified: 2014-03-16 22:37:56 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
Description of problem:
I followed the instructions in
postgres was started and both a user and database were set up, I followed these
steps: from the README
How To Use This Thing
a) Open your favorite datafile in the usual fashion.
b) Click on 'Save As'
c) enter the following URL instead of a filename in the file picker:
As soon as the ok button was pressed on the save as dialog box I received the
error message listed in the summary. The full URL was postgres://localhost/myuser.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
2.su - postgres
6.select file>new and follow the wizard selecting all accounts and press finish
7.select file>save as> postgres://localhost/myuser > press ok button
Actual Results: Received the error message "The URL postgres://localhost/myuser
is not supported by this version of GnuCash"
Expected Results: The title bar should change to "Accounts - GnuCash
(posgres://localhost/myuser)" and I could query the data with psql.
I also installed the SRPM file for gnucash. the gnucash-1.6.spec file had
# automake is fun.
make || :
The --enable-sql is correct. I compiled the SRPM with this and the application
worked as expected. Is there any reason why this feature is not enabled? I
would like this enabled in the next release of Red Hat, if possible. It looks
like RH intended to enable this but didn't. Is this a bug then?
Do you have gnucash-backend-postgres installed?
I believe yes. Since I wanted to use gnuCash with postgresql, I rpmed the
source package. Next I configured/compiled gnuCash source with --enable-sql.
So I have a working copy gnuCash with postgresql support.
Are you sure your rebuild went correctly, and it included the postgres backend
I am sure it worked. I went into psql and queried the data from gnuCash.
Let me back peddle here for a moment. The default rpm that Red Hat shipped with
8.0 does not have the postgres backend. What I am asking for is that Red Hat
would ship gnuCash with %configure --enable-sql. Otherwise I have to compile it
that way. The error message above is from the stock rpm not my compiled
version. I am providing customer feedback as to how I would like to be able to
use gnuCash on RH. If you don't use the postgres:// URL, then gnuCash uses the
normal XML backend and the postgres backend is inert. I am not an RPM expert,
but it looks like the .spec file has the --enable-sql compile instruction, but
the binary shipped does not have the support. This is what I tried to point out
in the Additional Information section of the original bug report. I also tried
to show that I followed all the correct steps in setting up postgresSQL, etc.
Does this information clear up what I was driving at?
Yes, that clears it up.
The postgres backend is shipped in the gnucash that comes with Red Hat Linux 9
and later. :)
Well I guess it is finally time to install version 9. Thanks for already making
this feature available.