Re: [GNC] Brand new and lost...
Johnathon, A database is not necessary to use GnuCash. GnuCash has an XML text file, which may be compressed as an option, as its default storage. That file can be located in a cloud storage. I keep my data files in a dropbox account so that I can access them from several computers. Note however that this does not support concurrent access from multiple computers, only single access and that when one computer has the file open another computer can normally only open the file in read-only mode. This can be overridden, but in normal circumstances should not be, for the fairly obvious reason that you can end up not knowing which computer has the most up to date version of the file. Closing the files in the wrong order is likely to lead to a loss of data. The database backend is an optional extra for GnuCash. The database backends also currently don't support concurrent access from multiple computers although this is a future longer term objective. You can choose one of either SQLite3, PostGreSQL or MYSQL for the database backend. If you have limited database experience using the XML backend is probably the best choice. Backing up and maintaining databases requires some considerable investment in developing the necessary skill set. You can always open the XML file and write it to a database (if your version of GnuCash is compiled with database support which is the default option) at a later time of your choosing. A Google search will provide you with tutorials on database support, setup etc. Customers and Vendors in GnuCash are associated and accessed with the business features which support Invoices/Bills/Credit Notes and the associated Accounts Receivable and Accounts Payable accounts. Similar restrictions apply to the use of the Tax features in GnuCash. If you want to use them you will need to use the business features which can be a bit cumbersome for dealing with cash sales subject to VAT/GST type taxes for example as you have to create an Invoice/Bill even though the sale is not a credit sale. The default accounts for Invoices and Bills are Accounts Receivable and Accounts Payable respectively. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Brand new and lost...
I can keep a checkbook, but know really nothing of databases. Apparently I have to acquire a SQL database to run Gnucash? Can I keep it in the cloud, for access by 2 separate computers, or is it safe? I grew tired of Quickbooks, want to reach accounting program on Mac as well as Windows (Sierra/Win 10) -- and importantly, access and edit lists. The Gnucash manual indicates early on the need for one of three databases, and just leaves it at that. I can grasp the idea of a container for the data, but cannot imagine the linking up. I am also considering getting Filemaker, an older version. Is it possible to embed Gnucash customers and their financial status within Filemaker tables? By someone ignorant of coding? Does setting up and linking system require a STEM background, or is there a source for requisite basic DB understanding? The most confusing thing, other than the database question, is how Accounts and Customers interact -- in QB customers ARE accounts. So are they a sort of sub-account in Gnucash? Thanks Jonathan Ames, PhD Clinical Psychologist 415 N. Tioga Street Ithaca NY 14850 607-319-5118 - Office 607-227-4792 - Cell jnthn.a...@gmail.com www.whatnowconnect.com Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message included in this email is for the sole use of the intended individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and you may be subject to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from all computers. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
Check credentials in MySQL. Specifically permissions for Root@Localhost On Sat, Nov 17, 2018 at 5:38 PM Colin Law wrote: > On Sat, 17 Nov 2018 at 22:31, Peter Holck wrote: > > > > Thanks for your suggestion. No, with only my new instance of MySQL > running (8.13 running, 5.6 stopped) when I use the GnuCash API to create a > new shell database (shelldb) and try to save as mysql, I get the same > error: "The server at URL mysql://root@localhost/shelldb experienced an > error or encountered bad or corrupt data". It seems to me the GnuCash API > is looking for an instance of my old version of MySQL (5.6) and if it's not > running, then it fails. > > You haven't told us what you found when you looked in the trace file. > > Colin > > > > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: > >> > >> Are you able to Save As mysql with the new server? > >> Also have a look in the trace file and see what it says, often it will > >> give more information in the case of db problems. > >> > >> Colin > >> On Sat, 17 Nov 2018 at 22:07, Peter Holck > wrote: > >> > > >> > I recently installed an updated version of MySQL Server (8.13) on my > >> > machine. I have an established GnuCash database under an instance of > MySQL > >> > 5.6. I copied all GnCash db/tables from that older version of MySQL > to an > >> > identically named database/tables in MySQL 8.13. > >> > > >> > How do I get the GnuCash API to connect to my new instance of MySQL > (8.13) > >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 > running, > >> > and then attempt to start GnuCash it asks for username and password > (also > >> > identical for the two different MySQL versions) but then gives the > standard > >> > error that the server encountered bad or corrupt data. > >> > > >> > Thanks in advance. > >> > ___ > >> > gnucash-user mailing list > >> > gnucash-user@gnucash.org > >> > To update your subscription preferences or to unsubscribe: > >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >> > - > >> > Please remember to CC this list on all your replies. > >> > You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
> On Nov 18, 2018, at 9:20 AM, John Griessen wrote: > > On 11/17/18 5:50 PM, John Ralls wrote: >> not enough of the error block to show what object file has a bad header. > > This is an excerpt of the message stream for every startup of: > > /home/john/.local/gnucash-3.3/bin/gnucash > > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/balance-sheet.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm > ;;; compiled > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/equity-statement.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm > ;;; gnucash/report/standard-reports/equity-statement.scm:278:9: warning: > non-literal format string > ;;; gnucash/report/standard-reports/equity-statement.scm:345:31: warning: > non-literal format string > ;;; compiled > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/price-scatter.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm > ;;; compiled > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/budget-barchart.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm > ;;; compiled > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/account-piecharts.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm > ;;; compiled > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm.go That’s telling you that the compiled guile files from your build are defective for some reason and that guile is rebuilding them in the location listed. While that’s a bunch of noise it’s not what’s crashing GnuCash. It does suggest that there’s something wrong with Guile on your machine and it’s possible that the rebuilt .go files are also invalid. What OS/Distro and version are you running? How did you set up the build environment? Do you have more than one version of Guile installed? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
> On Nov 18, 2018, at 9:23 AM, John Griessen wrote: > > On 11/17/18 5:50 PM, John Ralls wrote: >> Your earlier message showed things being installed in /usr/local and that >> shouldn’t happen when you’ve set CMAKE_INSTALL_PREFIX to >> ~/.local/gnucash-3.3. > > I did not get a complete compile with /usr/local so I tried compile to > install in > /home/john/.local/gnucash-3.3 > after deleting all libgnc* files /usr/local/lib and /usr/local/gnucash > Please remember to copy the list on all replies. Then you want to delete all of /usr/local/lib/gnucash and /usr/local/share/gnucash. That said, your earlier message did show a complete compile and anyway installation prefix has no effect on compilation. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
These .go files are precompiled .scm files (and they're in a .cache directory) and usually rebuilt on demand. Try deleting/renaming the whole .cache folder and retry. On Sun., 18 Nov. 2018, 09:21 John Griessen On 11/17/18 5:50 PM, John Ralls wrote: > > not enough of the error block to show what object file has a bad header. > > This is an excerpt of the message stream for every startup of: > > /home/john/.local/gnucash-3.3/bin/gnucash > > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/balance-sheet.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm > ;;; compiled > > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/equity-statement.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm > ;;; gnucash/report/standard-reports/equity-statement.scm:278:9: warning: > non-literal format string > ;;; gnucash/report/standard-reports/equity-statement.scm:345:31: warning: > non-literal format string > ;;; compiled > > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/price-scatter.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm > ;;; compiled > > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/budget-barchart.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm > ;;; compiled > > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm.go > ;;; WARNING: loading compiled file > /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/account-piecharts.go > failed: > ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm > ;;; compiled > > /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm.go > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column labels in Credit Card accounts
On Sat, 17 Nov 2018 11:05:18 -0800 Diane Trefethen wrote: > First: I apologize for asking here without checking the Archives but > the search function isn’t working yet and I don’t see any way to look > through the FAQs except to eyeball each month (there seem to be > about 100 of them) to find my question. That is a bridge too far. > However, if there is an efficient way to scan the FAQs, I will gladly > use it first. There are links which show how to search the archives using Google and Nabble, they are from the gnucash-user page On this page https://lists.gnucash.org/mailman/listinfo/gnucash-user the line which says "Or you can search the gnucash-user Archives." links to https://lists.gnucash.org/search/?idxinfo=gnucash-user which has the links to Google and Nabble search, and some plain English instructions. Is there some way this could have been clearer for you? Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column labels in Credit Card accounts
On Saturday, 17 November 2018 19:05:18 GMT Diane Trefethen wrote: > Dear Fellow Users, > > > Second: My Credit Card type account registers display Debits and > Credits, not Charges and Payments. Why? > Hi, Edit -> Preferences -> Accounts -> Use Formal Accounting labels HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
On 11/17/18 5:50 PM, John Ralls wrote: not enough of the error block to show what object file has a bad header. This is an excerpt of the message stream for every startup of: /home/john/.local/gnucash-3.3/bin/gnucash ;;; WARNING: loading compiled file /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/balance-sheet.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm ;;; compiled /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/balance-sheet.scm.go ;;; WARNING: loading compiled file /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/equity-statement.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm ;;; gnucash/report/standard-reports/equity-statement.scm:278:9: warning: non-literal format string ;;; gnucash/report/standard-reports/equity-statement.scm:345:31: warning: non-literal format string ;;; compiled /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/equity-statement.scm.go ;;; WARNING: loading compiled file /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/price-scatter.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm ;;; compiled /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/price-scatter.scm.go ;;; WARNING: loading compiled file /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/budget-barchart.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm ;;; compiled /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/budget-barchart.scm.go ;;; WARNING: loading compiled file /home/john/.local/gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/standard-reports/account-piecharts.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm ;;; compiled /home/john/.cache/guile/ccache/2.0-LE-8-2.0/home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/account-piecharts.scm.go ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Column labels in Credit Card accounts
Dear Fellow Users, I have GNUcash 2.6, and Raspbian GNU/Linux, v9 First: I apologize for asking here without checking the Archives but the search function isn’t working yet and I don’t see any way to look through the FAQs except to eyeball each month (there seem to be about 100 of them) to find my question. That is a bridge too far. However, if there is an efficient way to scan the FAQs, I will gladly use it first. Second: My Credit Card type account registers display Debits and Credits, not Charges and Payments. Why? Thank you. Diane ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
> On Nov 18, 2018, at 4:12 AM, John Griessen wrote: > > I used this cmake line > > cmake -D CMAKE_INSTALL_PREFIX=/home/john/.local/gnucash-3.3 /mosource/gnucash > make > sudo make install > > and get a complete compile, but many many error messages during first run of > /home/john/.local/gnucash-3.3/bin/gnucash > . > > The errors are all similar to this one: > > > ERROR: In procedure make_objcode_from_file: bad header on object file: > "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" > ;;; compiling > /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/cash-flow.scm > > > Is this normal? > No, but it’s also not enough of the error block to show what object file has a bad header. Your earlier message showed things being installed in /usr/local and that shouldn’t happen when you’ve set CMAKE_INSTALL_PREFIX to ~/.local/gnucash-3.3. As for the question in the earlier mail about the gwenhywfar run path, it’s correct: It’s a search path, a colon-separated list of file paths used to find files. The most familiar example is $PATH that the shell uses to find executable files. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
On Sat, 17 Nov 2018 at 22:31, Peter Holck wrote: > > Thanks for your suggestion. No, with only my new instance of MySQL running > (8.13 running, 5.6 stopped) when I use the GnuCash API to create a new shell > database (shelldb) and try to save as mysql, I get the same error: "The > server at URL mysql://root@localhost/shelldb experienced an error or > encountered bad or corrupt data". It seems to me the GnuCash API is looking > for an instance of my old version of MySQL (5.6) and if it's not running, > then it fails. You haven't told us what you found when you looked in the trace file. Colin > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: >> >> Are you able to Save As mysql with the new server? >> Also have a look in the trace file and see what it says, often it will >> give more information in the case of db problems. >> >> Colin >> On Sat, 17 Nov 2018 at 22:07, Peter Holck wrote: >> > >> > I recently installed an updated version of MySQL Server (8.13) on my >> > machine. I have an established GnuCash database under an instance of MySQL >> > 5.6. I copied all GnCash db/tables from that older version of MySQL to an >> > identically named database/tables in MySQL 8.13. >> > >> > How do I get the GnuCash API to connect to my new instance of MySQL (8.13) >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, >> > and then attempt to start GnuCash it asks for username and password (also >> > identical for the two different MySQL versions) but then gives the standard >> > error that the server encountered bad or corrupt data. >> > >> > Thanks in advance. >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > - >> > Please remember to CC this list on all your replies. >> > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
Thanks for your suggestion. No, with only my new instance of MySQL running (8.13 running, 5.6 stopped) when I use the GnuCash API to create a new shell database (shelldb) and try to save as mysql, I get the same error: "The server at URL mysql://root@localhost/shelldb experienced an error or encountered bad or corrupt data". It seems to me the GnuCash API is looking for an instance of my old version of MySQL (5.6) and if it's not running, then it fails. On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: > Are you able to Save As mysql with the new server? > Also have a look in the trace file and see what it says, often it will > give more information in the case of db problems. > > Colin > On Sat, 17 Nov 2018 at 22:07, Peter Holck wrote: > > > > I recently installed an updated version of MySQL Server (8.13) on my > > machine. I have an established GnuCash database under an instance of > MySQL > > 5.6. I copied all GnCash db/tables from that older version of MySQL to an > > identically named database/tables in MySQL 8.13. > > > > How do I get the GnuCash API to connect to my new instance of MySQL > (8.13) > > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 > running, > > and then attempt to start GnuCash it asks for username and password (also > > identical for the two different MySQL versions) but then gives the > standard > > error that the server encountered bad or corrupt data. > > > > Thanks in advance. > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
Are you able to Save As mysql with the new server? Also have a look in the trace file and see what it says, often it will give more information in the case of db problems. Colin On Sat, 17 Nov 2018 at 22:07, Peter Holck wrote: > > I recently installed an updated version of MySQL Server (8.13) on my > machine. I have an established GnuCash database under an instance of MySQL > 5.6. I copied all GnCash db/tables from that older version of MySQL to an > identically named database/tables in MySQL 8.13. > > How do I get the GnuCash API to connect to my new instance of MySQL (8.13) > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, > and then attempt to start GnuCash it asks for username and password (also > identical for the two different MySQL versions) but then gives the standard > error that the server encountered bad or corrupt data. > > Thanks in advance. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
I recently installed an updated version of MySQL Server (8.13) on my machine. I have an established GnuCash database under an instance of MySQL 5.6. I copied all GnCash db/tables from that older version of MySQL to an identically named database/tables in MySQL 8.13. How do I get the GnuCash API to connect to my new instance of MySQL (8.13) ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, and then attempt to start GnuCash it asks for username and password (also identical for the two different MySQL versions) but then gives the standard error that the server encountered bad or corrupt data. Thanks in advance. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] compiling 3.3
I used this cmake line cmake -D CMAKE_INSTALL_PREFIX=/home/john/.local/gnucash-3.3 /mosource/gnucash make sudo make install and get a complete compile, but many many error messages during first run of /home/john/.local/gnucash-3.3/bin/gnucash . The errors are all similar to this one: ERROR: In procedure make_objcode_from_file: bad header on object file: "\x7fELF\x02\x01\x01ÿ\x00\x00\x00\x00\x00\x00\x00\x00" ;;; compiling /home/john/.local/gnucash-3.3/share/gnucash/scm/gnucash/report/standard-reports/cash-flow.scm Is this normal? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] compiling 3.3
I'm using hints such as Do sudo rm -rf /usr/local/lib/gnucash sudo rm -f /usr/local/lib/libgnc* clean your build directory and try again. I get a completion of make ending like this: Scanning dependencies of target scm-test-load-report-gnome-module Scanning dependencies of target scm-test-load-report-stylesheets-module [100%] Generating ../../../../lib/gnucash/scm/ccache/2.0/gnucash/reports/test-load-report-gnome-module.go [100%] Generating ../../../../lib/gnucash/scm/ccache/2.0/gnucash/report/test-load-report-stylesheets-module.go wrote `/mosource/build-gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/reports/test-load-report-gnome-module.go' [100%] Built target scm-test-load-report-gnome-module wrote `/mosource/build-gnucash-3.3/lib/gnucash/scm/ccache/2.0/gnucash/report/test-load-report-stylesheets-module.go' [100%] Built target scm-test-load-report-stylesheets-module sudo make install ends like: -- Installing: /usr/local/share/glib-2.0/schemas/org.gnucash.window.pages.account.tree.gschema.xml -- Installing: /usr/local/share/glib-2.0/schemas/org.gnucash.window.pages.gschema.xml Compiling gschema files in /usr/local/share/glib-2.0/schemas Part way through install there is a suspicious message: -- Set runtime path of "/usr/local/lib/libgwengui-gtk3.so" to "/usr/local/lib:/usr/local/lib/gnucash" All lines like that have a list of two with colon between. Should this just be /usr/local/lib/gnucash? (After running make install, there are libgncmod* files in /usr/local/lib and /usr/local/lib/gnucash Do I need more detail in my cmake command? Here's how I build in a build dir: The code is in /mosource/gnucash with the repository set to tag maint git log shows: commit 7706fff3c94143f93030db167c5b51f146a0 (HEAD -> maint, origin/master, master) Author: John Ralls Date: Sat Sep 29 16:49:35 2018 -0700 cd /mosource if not done yet, mkdir /mosource/build-gnucash-3.3 cd /mosource/build-gnucash-3.3 cmake -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash make make install ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.