|Summary:||The URL postgres://... is not supported by this version of GnuCash|
|Product:||[Retired] Red Hat Linux||Reporter:||Greg Morgan <drkludge>|
|Component:||gnucash||Assignee:||Bill Nottingham <notting>|
|Status:||CLOSED CURRENTRELEASE||QA Contact:|
|Fixed In Version:||Doc Type:||Bug Fix|
|Doc Text:||Story Points:||---|
|Last Closed:||2003-08-06 16:00:43 UTC||Type:||---|
|oVirt Team:||---||RHEL 7.3 requirements from Atomic Host:|
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: postgres://localhost/some_dbname_you_pick 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): gnucash-1.6.6-7 How reproducible: Always 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 ... autoconf-2.13 %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? Thanks, 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 plugin?
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.