Re: [GNC] Linux. Mysql and Gnucash 4.1
On Tue, Apr 26, 2022 at 08:47:04PM -0500, Adrien Monteleone wrote: > On 4/26/22 3:28 AM, Chris Green wrote: > > On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote: > > > So I have rebuilt my laptop, recovered my databases and installed Gnucash > > > 4.1 but I cannot connect to mysql databases. When I click file, open there > > > is no option for mysql. This is under Fedora 35Sent from my Galaxy > > > > I don't believe GnuCash works with mysql (or the equivalent mariadb), > > the only database storage option that I'm aware of is sqlite. > > > > It offers 4 backends: > > XML (default) > SQLite > MySQL/MariaDB > PostgreSQL > > You have to install the desired backend libs in most cases to be offered the > option of using it. > > The default requires no special effort. > > Many Linux distros also come with SQLite support by default, so mileage > varies. > > MySQL/Maria & Postgres almost always require intentional lib installation > and if I'm not mistaken, specific build flags. > > Check the wiki for more specific and up to date info. > Yes, absolutely right, my 'sqlite only' view was simply because, on most Linux distributions sqlite is already there. Thus GnuCash offers both XML and sqlite 'out of the box' as it were. -- Chris Green ___ 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] Linux. Mysql and Gnucash 4.1
See my previous reply to Chris Green, and also check the Wiki. Plenty of users are on various backends under various OS. Regards, Adrien On 4/26/22 1:36 AM, grant wrote: So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 but I cannot connect to mysql databases. When I click file, open there is no option for mysql. This is under Fedora 35Sent from my Galaxy ___ 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] Linux. Mysql and Gnucash 4.1
It offers 4 backends: XML (default) SQLite MySQL/MariaDB PostgreSQL You have to install the desired backend libs in most cases to be offered the option of using it. The default requires no special effort. Many Linux distros also come with SQLite support by default, so mileage varies. MySQL/Maria & Postgres almost always require intentional lib installation and if I'm not mistaken, specific build flags. Check the wiki for more specific and up to date info. Regards, Adrien On 4/26/22 3:28 AM, Chris Green wrote: On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote: So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 but I cannot connect to mysql databases. When I click file, open there is no option for mysql. This is under Fedora 35Sent from my Galaxy I don't believe GnuCash works with mysql (or the equivalent mariadb), the only database storage option that I'm aware of is sqlite. ___ 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] Linux. Mysql and Gnucash 4.1
> On Apr 25, 2022, at 11:36 PM, grant wrote: > > So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 > but I cannot connect to mysql databases. When I click file, open there is no > option for mysql. This is under Fedora You probably need to install the libdbd-mysql package. 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] Linux. Mysql and Gnucash 4.1
I worked it out in the end. Had to install the perl-DBI library etc and I am away. Gnucash also works with postgres. Sent from my Galaxy Original message From: Chris Green Date: 26/04/22 20:29 (GMT+12:00) To: gnucash-user@gnucash.org Subject: Re: [GNC] Linux. Mysql and Gnucash 4.1 On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote:> So I have rebuilt my laptop, recovered my databases and installed Gnucash > 4.1 but I cannot connect to mysql databases. When I click file, open there > is no option for mysql. This is under Fedora 35Sent from my Galaxy I don't believe GnuCash works with mysql (or the equivalent mariadb),the only database storage option that I'm aware of is sqlite.-- Chris Green___gnucash-user mailing listgnucash-user@gnucash.orgTo update your subscription preferences or to unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-userIf 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] Linux. Mysql and Gnucash 4.1
On Tue, Apr 26, 2022 at 06:36:30PM +1200, grant wrote: > So I have rebuilt my laptop, recovered my databases and installed Gnucash > 4.1 but I cannot connect to mysql databases. When I click file, open there > is no option for mysql. This is under Fedora 35Sent from my Galaxy I don't believe GnuCash works with mysql (or the equivalent mariadb), the only database storage option that I'm aware of is sqlite. -- Chris Green ___ 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] Linux. Mysql and Gnucash 4.1
So I have rebuilt my laptop, recovered my databases and installed Gnucash 4.1 but I cannot connect to mysql databases. When I click file, open there is no option for mysql. This is under Fedora 35Sent from my Galaxy ___ 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.