Bug 101571 - The URL postgres://... is not supported by this version of GnuCash
Summary: The URL postgres://... is not supported by this version of GnuCash
Alias: None
Product: Red Hat Linux
Classification: Retired
Component: gnucash
Version: 8.0
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: Bill Nottingham
QA Contact:
URL: http://www.gnucash.org/lxr/gnucash/so...
Depends On:
TreeView+ depends on / blocked
Reported: 2003-08-04 06:56 UTC by Greg Morgan
Modified: 2014-03-17 02:37 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2003-08-06 16:00:43 UTC

Attachments (Terms of Use)

Description Greg Morgan 2003-08-04 06:56:47 UTC
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 14:55:51 UTC
Do you have gnucash-backend-postgres installed?

Comment 2 Greg Morgan 2003-08-05 08:25:47 UTC
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 14:49:08 UTC
Are you sure your rebuild went correctly, and it included the postgres backend

Comment 4 Greg Morgan 2003-08-06 05:10:07 UTC
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 16:00:43 UTC
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 06:33:05 UTC
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.