2025-10-28 GnuCash IRC logs
00:10:01 *** jonakeys has quit IRC
00:10:07 *** jonakeys has joined #gnucash
00:17:55 *** sacdrj has joined #gnucash
00:20:55 *** sacdrj has quit IRC
00:23:18 *** sacdrj has joined #gnucash
00:26:19 *** sacdrj has quit IRC
00:43:35 *** sacdrj has joined #gnucash
00:46:35 *** sacdrj has quit IRC
01:14:17 *** sacdrj has joined #gnucash
01:17:17 *** sacdrj has quit IRC
01:32:35 *** mechtilde has joined #gnucash
01:48:54 *** sacdrj has joined #gnucash
01:51:54 *** sacdrj has quit IRC
02:06:19 *** sacdrj has joined #gnucash
02:09:20 *** sacdrj has quit IRC
02:32:19 *** fell has quit IRC
02:33:38 *** fell has joined #gnucash
02:33:38 *** ChanServ sets mode: +o fell
02:40:13 *** sacdrj has joined #gnucash
02:43:13 *** sacdrj has quit IRC
03:14:24 *** sacdrj has joined #gnucash
03:18:54 *** sacdrj has quit IRC
03:39:27 *** gjanssens has joined #gnucash
03:39:27 *** ChanServ sets mode: +o gjanssens
03:48:39 *** sacdrj has joined #gnucash
03:51:39 *** sacdrj has quit IRC
04:21:38 *** sacdrj has joined #gnucash
04:24:38 *** sacdrj has quit IRC
04:55:47 *** sacdrj has joined #gnucash
04:58:47 *** sacdrj has quit IRC
05:31:37 *** sacdrj has joined #gnucash
05:34:37 *** sacdrj has quit IRC
06:04:02 *** sacdrj has joined #gnucash
06:08:32 *** sacdrj has quit IRC
06:30:32 *** sacdrj has joined #gnucash
06:33:32 *** sacdrj has quit IRC
07:05:16 *** sacdrj has joined #gnucash
07:08:16 *** sacdrj has quit IRC
07:14:00 *** warlord has joined #gnucash
07:14:00 *** gncbot sets mode: +o warlord
07:24:14 *** sacdrj has joined #gnucash
07:27:14 *** sacdrj has quit IRC
07:42:16 *** sacdrj has joined #gnucash
07:45:17 *** sacdrj has quit IRC
08:00:52 *** sacdrj has joined #gnucash
08:03:53 *** sacdrj has quit IRC
08:18:35 *** sacdrj has joined #gnucash
08:21:34 *** sacdrj has quit IRC
08:31:48 *** enviart has joined #gnucash
08:43:56 *** enviart has quit IRC
08:44:00 *** enviart has joined #gnucash
08:49:15 *** sacdrj has joined #gnucash
08:50:55 *** enviart has joined #gnucash
08:51:22 *** architectonical has joined #gnucash
08:51:33 *** enviart has left #gnucash
08:52:14 *** sacdrj has quit IRC
08:56:00 *** architectonical has left #gnucash
08:56:23 *** enviart has joined #gnucash
08:58:45 *** enviart has quit IRC
08:58:49 *** enviart has joined #gnucash
09:00:09 *** ChanServ sets mode: +v enviart
09:00:25 <enviart> Hi! 'Happy to be here. I'd like to set up gnucash in a homelab / SOHO (Small Office / Home Office) LAN. Please recommend a guide or reference for setting up shared database or another scheme to allow several client users to contribute to the same data?
09:01:08 <warlord> enviart, gnucash does not support multiple, simultaneous users. You need to ensure that only ONE person is using gnucash at a time (with the same data set)
09:02:43 <enviart> Thanks warlord! 'Yes, I've read that, no problem.
09:04:42 <enviart> I've also read that it is possible to configure GnuCash to use an external database server, such as MySQL or PostgreSQL. Since version 2.4, GnuCash has supported these SQL backends.
09:05:04 <enviart> I also understand that it is important to Enforce exclusive access
09:06:05 <warlord> Yes, GnuCash can use MySQL (or PGSQL) for its data store. You need to set up and manage the database; then you point GnuCash at it.
09:06:17 <warlord> But you need to enforce single-user access externally.
09:06:21 <enviart> Is there a guide that describes how to set-up the MySQL server backend?
09:06:50 <warlord> The MySQL Documentation
09:07:04 <enviart> Okay, that's it then...
09:07:08 <enviart> ?
09:07:29 <warlord> Yeah, we assume that if you plan to use a DB Backend, you /KNOW/ how to manage the DB.
09:07:33 <warlord> (setup and manage)
09:09:27 <enviart> How about connection settings? The default is lite / SQLite? Is there a guide to just changing the database connection from SQLite to SQL backend?
09:11:20 <warlord> For File -> Save As, it's a drop-down.
09:11:21 <enviart> Gemini AI returns a process with steps, export data, then install GnuCash database drivers.
09:11:35 <warlord> It's not the "GnuCash database drivers".
09:11:58 <warlord> Depending on your OS, you may need to install the DBI Drivers, but that's not GnuCash code.
09:13:52 <enviart> All right, thanks for the chat! I'll try to work it out. I"m actually using fedora 42. I'm building a server to host VMs using Proxmox OS, with OPNSense, and TrueNAS servers as well, three physical servers.
09:14:41 <enviart> I'm hoping to spin up a MySQL server as a KVM/VM to host the GNUCash database for a private client network
09:15:15 <warlord> What system(s) will be running GnuCash?
09:16:04 <warlord> Setting up MySQL on F42 is pretty easy, but you'll need to handle the firewall and SElinux rules to allow remote access. My suggestion is to set up the database and then use the mysql client on another (test) system to make sure you can access the DB -- before you try to connect GnUCash.
09:16:46 <warlord> Get the DB fully set up and functional, and THEN you can install the dbi mysql dbd drivers (assuming gnucash is running on LInux) and then connect GnuCash to the MySQL via the correct URI. /THAT/ should be in the GnuCash docs/wiki.
09:17:20 <enviart> The client systems will likely vary a bit, incorporating clients like mine, fedora and windows vms, maybe a few other distros? Maybe the odd Hackintosh?
09:17:52 <warlord> Different clients may have different requirements for getting the sql connectors working. YMMV.
09:22:26 *** sacdrj has joined #gnucash
09:25:27 *** sacdrj has quit IRC
09:27:27 <enviart> Thanks
09:40:26 *** sacdrj has joined #gnucash
09:43:28 *** sacdrj has quit IRC
09:50:52 *** sacdrj has joined #gnucash
09:53:52 *** sacdrj has quit IRC
09:56:07 *** sacdrj has joined #gnucash
10:06:06 *** sacdrj has quit IRC
10:08:28 *** sacdrj has joined #gnucash
10:11:18 <enviart> So, any road, mr warlord, this is exactly the user guide that I was looking for (and I can't find this in the wiki): My suggestion is to set up the database and then use the mysql client on another (test) system to make sure you can access the DB -- before you try to connect GnUCash.
10:11:18 <enviart> <warlord> Get the DB fully set up and functional, and THEN you can install the dbi mysql dbd drivers (assuming gnucash is running on LInux) and then connect GnuCash to the MySQL via the correct URI. /THAT/ should be in the GnuCash docs/wiki.
10:11:18 <enviart> <enviart> The client systems will likely vary a bit, incorporating clients like mine, fedora and windows vms, maybe a few other distros? Maybe the odd Hackintosh?
10:11:20 <enviart> <warlord> Different clients may have different requirements for getting the sql connectors working. YMMV.
10:12:00 <enviart> So, well done there warlord. And do you know the link or reference I could use to find similar advice in the wiki or elsewhere?
10:14:28 *** sacdrj has quit IRC
10:14:32 <enviart> Here's a google / ai return for the search: https://www.google.com/url?sa=i&source=web&rct=j&url=https://www.howtodoityourself.org/set-mysql-gnucash-backend.html&ved=2ahUKEwi8_N7oiceQAxX01fACHSQ-CGEQqYcPegQIFRAC&opi=89978449&cd&psig=AOvVaw3Ui7YbI3VnVR5rq___8fN-&ust=1761747181444000
10:16:25 <warlord> That advice is just obvious. GnuCash is an accounting system, not a database manager.
10:16:42 <warlord> Like I said, if a user does not know how to set up and manage a DB, they shouldn't be using it.
10:20:31 <enviart> Ha! Well thanks all the same. I've been learning new things on the fly, every day since 1967. That's why I'm a registered professional architect, and engineer, and software architect, and visual artist and web developer and etc.
10:21:09 <enviart> I've never installed Proxmox, and I dont' know how to use that, but I'm sure I can learn during the insall!
10:21:15 <warlord> The day you stop learning is the day you start dying, right? :)
10:21:39 <warlord> LOL. I've never actually used proxmox. VMware, ovirt, etc -- sure. But not proxmox. :)
10:22:53 *** sacdrj has joined #gnucash
10:23:01 <enviart> There is a guide from 2017, very similar to this discussion and you're advice, that someone posted on their personal wp blog
10:23:58 <enviart> I really appreciate those things, even if they're not perfect, they give me a starting outline to fix with new experience. Some place to start anyway
10:24:27 <warlord> You're welcome to update the wiki..
10:24:30 <enviart> Yes, I use Ovirt, but that project is dead now, I think.
10:24:51 <warlord> No, it's not dead. Just no longer being funded by Red Hat.
10:25:00 <enviart> If I make a guide from my outline / notes, then I'll share the link here an ask if it is worth contributing
10:25:13 <enviart> Yeah, I like Ovirt a lot!
10:25:19 <warlord> Me too.
10:25:54 *** sacdrj has quit IRC
10:26:28 <enviart> But, I want someting that is supported with an active user base. I want to stick with the fedora universe (redhat/REHL, CENTOS, Rocky/Alma) with RPM, KVM/Qemu virtual machines and all that
10:27:14 <enviart> That's why I picked Proxmox. We'll see how it goes. At the end of the day it manages KVM VMs so if it doesn't work for me then I will migrate the vms
10:28:28 <enviart> I also noticed that cloudstack is an apache project, which is a big backer community. and cloudstack has a proxmox addon that allows cloudstack to manage the proxmox hypervisors and/or proxmox clusters
10:29:12 <enviart> So I think proxmox, cloudstack, kvm, fedora, RHEL they are all the same "family"
10:30:40 <enviart> I don't want to learn a different cli, that's too annoying. I already have to manage windows and linux with cli. at this point, when I'm using freebsd or ubuntu I just get angry that I have to shift to app get, or whatever
10:31:45 <enviart> Got to go, thanks! I'll make an outline with notes and I'lls screen capture images so If I get a client server relationship set up, I'll have something to share later.
10:32:12 <enviart> We're coauthors now. Your suggestions are the germinal of my installation / set-up outling
10:32:15 <enviart> outline
10:32:20 <warlord> cool
10:45:40 *** sacdrj has joined #gnucash
10:48:40 *** sacdrj has quit IRC
10:56:51 *** sacdrj has joined #gnucash
11:41:52 <enviart> wow
11:42:51 <enviart> warlord, you've rocked my world. I thought Ovirt was done and dusted...I just checked back for the first time in around two years, and the project is in recovery. There's a new release! 4.5! That's a big deal actually
11:43:25 <warlord> Happy to help!
11:43:27 <enviart> I was running Ovirt four point something...and I was gutted when it was abandoned...
11:44:27 <warlord> It hurt when Red Hat stepped away,but others have stepped in (including, I believe, Oracle). Development/Releases are a bit slower now, but it's still chugging along.
11:45:28 <warlord> Me, I'm actually still running 4.3 on EL7!!! But upgrading would require taking my whole system down, re-installing, and hoping it all comes back up.. I just don't have the time or anxiety to deal with that, considering there would be no way to back out if it fails.
11:45:55 <enviart> I'll have to take another look. I'm going to proceed with proxmox because there are so many user guides on youtube, there's a lot of adoption there. but I'll be that Ovirt will play nicely with cloudstack. Ovirt and cloudstack are peers, probably. They're both IaaS servers, I think. But I'll be that cloudstack can manage an ovirt cluster / gluster. I'll check now...maybe I should rethink proxmox?
11:46:19 <enviart> Yeah, 4.3 or so was near what I was using around five years ago?
11:46:34 <warlord> note that gluster is no longer supported.
11:46:35 <enviart> I remember that upgrade path was not worked out.
11:47:16 <warlord> Yeah, upgrading from 4.3 to 4.4 required a full OS re-install..
11:47:22 <warlord> So.. "if it aint broke"...
11:47:24 <enviart> I also remember that a single server set-up was not really possible. The Ovirt that I used really wanted to be on three boxes in a gluster
11:48:16 <enviart> I was using the trial or demonstration quick set-up (for two years in production for my home office :)
11:48:27 <warlord> You could set up a single, self-hosted system with 4.3, but I do believe they removed that (or made it harder to implement). With gluster being gone now, I don't know what to do about storage.
11:48:46 <warlord> (in a 3-server cluster)
11:49:10 <enviart> There were a lot of issues to work through and not many idiot-proof guides for users like me
11:50:42 <enviart> I remember that I had used storage pools on an nfs share? or something like that, since I was using FreeNAS with PFSense (haproxy / reverse proxy with let's encrypt certificates)
11:50:56 <enviart> that was complex but proxmox is not simple
11:52:13 <enviart> I think the current approach recommended for small office / home labs is one box with proxmox os on bare metal with a hosted vm containing OPNSense as a vm with pci pass-thru for the pci sas/sata controllers
11:54:35 <enviart> I'll do that, I also have an OPNSense gateway server, and a NAS running TrueNAS for the data stores...to keep the data managed by the proxmox server hosted vm / TruNAS vm instance, that's considered the best practice for home labs...
11:55:48 <enviart> I'm pretty phyched about Ovirt though. That system had real progress and it was completely familar to me having used kvm/qemu with virtmanager and all that...I was really sad when it stopped...
11:57:40 <enviart> now the problem is faster ethernet. I've got 3gbs download ip speeds but in the lAN I'm mostly stuck with 1gbs at best. I think with new swithes then 2+gbs is well possble
11:58:53 <enviart> I have never used this HexChat or IRC before, and I'm not sure how I managed to get a voice here at #gnucash...ha! So if I can't join again, have a happy holiday season and a great new year!
12:00:06 *** sacdrj has quit IRC
12:21:43 *** sacdrj has joined #gnucash
12:22:06 <warlord> You just got voice by being registered with NickServ
12:22:12 <warlord> Good luck, enviart
12:22:29 <enviart> Thanks warlord!
12:26:14 *** sacdrj has quit IRC
12:41:52 *** enviart has quit IRC
12:52:32 *** sacdrj has joined #gnucash
12:55:32 *** sacdrj has quit IRC
13:27:39 *** sacdrj has joined #gnucash
13:30:40 *** sacdrj has quit IRC
13:53:15 *** sacdrj has joined #gnucash
13:56:16 *** sacdrj has quit IRC
14:10:25 *** sacdrj has joined #gnucash
14:13:25 *** sacdrj has quit IRC
14:46:16 *** sacdrj has joined #gnucash
15:55:41 *** sacdrj has quit IRC
16:08:49 *** sacdrj has joined #gnucash
16:11:50 *** sacdrj has quit IRC
16:32:42 *** mechtilde has quit IRC
16:54:15 *** sacdrj has joined #gnucash
16:58:46 *** sacdrj has quit IRC
17:29:57 *** sacdrj has joined #gnucash
17:32:58 *** sacdrj has quit IRC
17:47:04 *** warlord has quit IRC
17:56:05 *** gjanssens has quit IRC
18:11:28 *** sacdrj has joined #gnucash
18:14:28 *** sacdrj has quit IRC
18:23:25 *** sacdrj has joined #gnucash
19:26:49 *** sacdrj has quit IRC
19:38:46 *** sacdrj has joined #gnucash
19:41:47 *** sacdrj has quit IRC
19:41:52 *** sacdrj has joined #gnucash
19:44:53 *** sacdrj has quit IRC
19:57:08 *** sacdrj has joined #gnucash
20:43:38 *** sacdrj has quit IRC
20:48:25 *** warlord has joined #gnucash
20:48:25 *** gncbot sets mode: +o warlord
21:12:09 *** doc has quit IRC
21:17:32 *** sacdrj has joined #gnucash
21:21:16 *** doc has joined #gnucash
22:18:12 *** jralls-m1 has joined #gnucash
22:18:12 *** jralls has quit IRC
23:10:49 *** sacdrj has quit IRC
23:16:01 *** sacdrj has joined #gnucash
23:19:02 *** sacdrj has quit IRC
23:47:58 *** sacdrj has joined #gnucash
23:51:25 *** sacdrj has quit IRC