Bugzilla will be upgraded to version 5.0 on December 2, 2018. The outage period for the upgrade will start at 0:00 UTC and have a duration of 12 hours
Bug 101571 - The URL postgres://... is not supported by this version of GnuCash
The URL postgres://... is not supported by this version of GnuCash
Product: Red Hat Linux
Classification: Retired
Component: gnucash (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Bill Nottingham
Depends On:
  Show dependency treegraph
Reported: 2003-08-04 02:56 EDT by Greg Morgan
Modified: 2014-03-16 22:37 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2003-08-06 12:00:43 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Greg Morgan 2003-08-04 02:56:47 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
http://www.gnucash.org/lxr/gnucash/source/src/backend/postgres/README. After
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):

How reproducible:

Steps to Reproduce:
1./etc/init.d/postgresql start
2.su - postgres
3.createuser myuser
4.createdb myuser
5.run gnucash
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.

Additional info:

I also installed the SRPM file for gnucash.  the gnucash-1.6.spec file had
%configure --enable-sql
# automake is fun.
make || :
cd src/engine

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?

Greg Morgan
Comment 1 Bill Nottingham 2003-08-04 10:55:51 EDT
Do you have gnucash-backend-postgres installed?
Comment 2 Greg Morgan 2003-08-05 04:25:47 EDT
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.
Comment 3 Bill Nottingham 2003-08-05 10:49:08 EDT
Are you sure your rebuild went correctly, and it included the postgres backend
Comment 4 Greg Morgan 2003-08-06 01:10:07 EDT
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?
Comment 5 Bill Nottingham 2003-08-06 12:00:43 EDT
Yes, that clears it up.

The postgres backend is shipped in the gnucash that comes with Red Hat Linux 9
and later. :)
Comment 6 Greg Morgan 2003-08-07 02:33:05 EDT
Well I guess it is finally time to install version 9.  Thanks for already making
this feature available.

Note You need to log in before you can comment on or make changes to this bug.