[GNC] MySQL backend disappeared after update of GC (flatpak) under Ubuntu 24.04.1 LTS
Hi All Today flatpak updated GnuCash to 5.10. But can not open existence account @ MySQL as follows. [image: 圖片.png] Translation: Didn't find a suitable back-end engine And File -> Open, format of MySQL disappear, only File and Postgres. Can I repair it? -- Thanks Regards, Wei-Jen Chang ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] MySQL backend
https://bugs.gnucash.org/show_bug.cgi?id=798992 Reports that after upgrading to MariaDB 11 on their servers, two Windows users are unable to work with their GnuCash databases. GnuCash appears to connect but DBI thinks that numeric variables are strings and, since it's expecting numbers, declines to read them. Has anyone using GnuCash on macOS or Linux experienced this problem? 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 - 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 Backend on Amazon AWS?
Having problems Server setup in AWS When 'save as' the Local host Version into the AWS endpoint Msgbox becomes non responsive and eventually crashes GnuCash The tables in cloud db are setup but I can excess any data. And I can open the cloud db in the Gnucash UI but no accounts (as expected) Has anybody got AWS MySQL server successfully working as GnuCash backend yet? -- 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.
Re: [GNC] mysql backend, second user (lock, for example)
That may work fine for a single instance of gnucash. However, it this is 2 instances of gnucash on 2 separate computers, does libdbi provide any notification mechanism to notify gnucash on computer #2 that computer #1 has written to the db? On Mon, Nov 5, 2018 at 2:39 AM craigarno wrote: > Geert Janssens-4 wrote > > Op zondag 4 november 2018 14:49:22 CET schreef craigarno: > >> Geert Janssens-4 wrote > >> > > Whether it can work depends on > > whether the db layer we rely on has a notification mechanism for db > > changes we > > can hook into. The current db layer is provided by libdbi, which is not > > managed by the gnucash team and I haven't looked into this yet. > > If your call to libdbi is in the same thread and is a blocking call for > synchronous operation, then there shouldn't be a problem with updating > views > after successful return from the libdbi call. Otherwise you may have to > look for semaphors to signal. > > > > -- > 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. > ___ 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 backend, second user (lock, for example)
Geert Janssens-4 wrote > Op zondag 4 november 2018 14:49:22 CET schreef craigarno: >> Geert Janssens-4 wrote >> > Whether it can work depends on > whether the db layer we rely on has a notification mechanism for db > changes we > can hook into. The current db layer is provided by libdbi, which is not > managed by the gnucash team and I haven't looked into this yet. If your call to libdbi is in the same thread and is a blocking call for synchronous operation, then there shouldn't be a problem with updating views after successful return from the libdbi call. Otherwise you may have to look for semaphors to signal. -- 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.
Re: [GNC] mysql backend, second user (lock, for example)
Op zondag 4 november 2018 14:49:22 CET schreef craigarno: > Geert Janssens-4 wrote > > > Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > > The only part I have no idea about at this stage is how to tell all views > > to refresh when one user makes a change. > > If you are headed toward C++, the "Observer" Design Pattern may be able to > get the "refresh views" job done for you. > > Where observer pattern is used? > Observer pattern is used when there is one-to-many relationship between > objects such as if one object is modified, its dependent objects are to be > notified automatically. Observer pattern falls under behavioral pattern > category. Thanks for naming it. The concept is good. Whether it can work depends on whether the db layer we rely on has a notification mechanism for db changes we can hook into. The current db layer is provided by libdbi, which is not managed by the gnucash team and I haven't looked into this yet. That's where my "I have no idea" came from :) Geert ___ 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 backend, second user (lock, for example)
Geert Janssens-4 wrote > Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > The only part I have no idea about at this stage is how to tell all views > to refresh when one user makes a change. If you are headed toward C++, the "Observer" Design Pattern may be able to get the "refresh views" job done for you. Where observer pattern is used? Observer pattern is used when there is one-to-many relationship between objects such as if one object is modified, its dependent objects are to be notified automatically. Observer pattern falls under behavioral pattern category. Hope that helps. Sounds like a lot of work. Thank you for your insight. Craig -- 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.
Re: [GNC] mysql backend, second user (lock, for example)
Op zondag 4 november 2018 04:36:30 CET schreef craigarno: > My application is similar, except two of my users will be outside of my > local network, working from the Internet. I'm a tiny one man SOHO > operation who is off-site a lot of the time and may also be accessing my > GnuCash database remotely and concurrently from a job site providing client > invoices/expenses as needed/requested. > > *Usecase*: > /Myself/: Day to day entry of expenses, income, travel receipts, tax > info. > /Bookkeeper/: weekly cleanup of my efforts, will potentially be using the > database at the same time as I am. > /Accountant/: Annual tax time work, will be using the database concurrent > with myself + bookkeeper, updating chart of accounts with changing tax law > information, Income tax preparation, etc. Packaging up the previous year > while we're inputting the current year. > > Ideally the internet side will use MySQL+SSL for secure connection. And > ideally active records would be momentarily locked for update, then released > after update, and both other concurrent screens notified and updated as > required for correct visual data presentation. Given the tiny size of my > organization, daily database transaction load will be very low, and most of > the time each of the three of us will effectively have exclusive access to > the database. But there will be times when concurrency will be important. > This is also why we need a centralized accounting database. > > Is there a roadmap for GnuCash database development? > Concurrent multi-user access is on the roadmap. There is no ETA on this however. The team is currently almost fully occupied with fixing regressions introduces by our force move to Gtk3. This has taken time away from our next primary goal, converting to C++. This conversion also includes reviewing historical design decisions and laying the groundwork for true concurrency. I think our current vision does cover most of the use case you describe. The only part I have no idea about at this stage is how to tell all views to refresh when one user makes a change. Additional hands to realize this vision are of course very welcome. Regards, Geert ___ 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 backend, second user (lock, for example)
My application is similar, except two of my users will be outside of my local network, working from the Internet. I'm a tiny one man SOHO operation who is off-site a lot of the time and may also be accessing my GnuCash database remotely and concurrently from a job site providing client invoices/expenses as needed/requested. *Usecase*: /Myself/: Day to day entry of expenses, income, travel receipts, tax info. /Bookkeeper/: weekly cleanup of my efforts, will potentially be using the database at the same time as I am. /Accountant/: Annual tax time work, will be using the database concurrent with myself + bookkeeper, updating chart of accounts with changing tax law information, Income tax preparation, etc. Packaging up the previous year while we're inputting the current year. Ideally the internet side will use MySQL+SSL for secure connection. And ideally active records would be momentarily locked for update, then released after update, and both other concurrent screens notified and updated as required for correct visual data presentation. Given the tiny size of my organization, daily database transaction load will be very low, and most of the time each of the three of us will effectively have exclusive access to the database. But there will be times when concurrency will be important. This is also why we need a centralized accounting database. Is there a roadmap for GnuCash database development? Warnings of data loss using current versions of GnuCash noted. I realize GnuCash isn't there yet, but excited to see GnuCash is potentially headed in this direction. Thanks, Craig -- 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.
Re: [GNC] mysql backend, second user (lock, for example)
Gnucash will put a lock on the database as long as it's in use by one user. If
a second user tries to open it that user will be presented with a warning tje
db is still in use by ssomeone else. So you can't accidentally be working on an
open db with two users at once. If you ignore the warning you may end up with
data loss though.
Regards
Geert
Jeff Abrahamson schreef op 19 augustus 2018 07:32:08 CEST:
>I'd like to understand if gnucash + mysql supports avoiding
>simultaneous
>editors (e.g., via locks).
>
>In more detail:
>
>I want to keep accounts for a small organisation in which we've decided
>several people should have access to the books for transparency and
>distribution of work. One possibility seems to be gnucash, which would
>suit me because I already know it among other reasons. With a mysql
>backend, it's easy enough to set up for us.
>
>Gnucash has long (very long) noted that simultaneous editors is a
>wishlist item. Now the chances of simultaneous editors is really small
>for us, so even a simple lock-out ("sorry, Sara is editing now, want to
>wait a few minutes?") is enough. Even anonymous, because we know each
>other and can message to figure out who. But I haven't found anything
>written here about whether gnucash with the mysql back end leaves
>behind
>a breadcrumb so that other instances know not to edit. (Or maybe
>there's a compile-time option to support this, for example. So just
>testing isn't quite good enough here.)
>
>I've seen that James Nylen has written a (possibly moribund) django
>interface, which could sort the multi-user access issue by actually
>being only a single user. I'm not overly inclined, however, as the
>project smells of "good enough for the author but not fully production
>ready". And I don't want to maintain a django application as well.
>
> https://github.com/nylen/gnucash-django
>
>--
>
>Jeff Abrahamson
>+33 6 24 40 01 57
>+44 7920 594 255
>https://www.p27.eu/jeff/
>
>purple.com -> p27.eu
>
>___
>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.
Sent from my smartphone. Please excuse my brevity.
___
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 backend, second user (lock, for example)
I'd like to understand if gnucash + mysql supports avoiding simultaneous
editors (e.g., via locks).
In more detail:
I want to keep accounts for a small organisation in which we've decided
several people should have access to the books for transparency and
distribution of work. One possibility seems to be gnucash, which would
suit me because I already know it among other reasons. With a mysql
backend, it's easy enough to set up for us.
Gnucash has long (very long) noted that simultaneous editors is a
wishlist item. Now the chances of simultaneous editors is really small
for us, so even a simple lock-out ("sorry, Sara is editing now, want to
wait a few minutes?") is enough. Even anonymous, because we know each
other and can message to figure out who. But I haven't found anything
written here about whether gnucash with the mysql back end leaves behind
a breadcrumb so that other instances know not to edit. (Or maybe
there's a compile-time option to support this, for example. So just
testing isn't quite good enough here.)
I've seen that James Nylen has written a (possibly moribund) django
interface, which could sort the multi-user access issue by actually
being only a single user. I'm not overly inclined, however, as the
project smells of "good enough for the author but not fully production
ready". And I don't want to maintain a django application as well.
https://github.com/nylen/gnucash-django
--
Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255
https://www.p27.eu/jeff/
purple.com -> p27.eu
___
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.
