2020-06-02 GnuCash IRC logs
00:15:03 *** Mechtilde has joined #gnucash
01:14:50 *** marusich has quit IRC
01:17:05 *** sbluhm has joined #gnucash
01:17:11 *** fell_laptop has joined #gnucash
01:17:12 *** ChanServ sets mode: +o fell_laptop
01:18:54 *** fell has quit IRC
01:28:32 *** suukim has joined #gnucash
01:31:20 *** sbluhm has quit IRC
01:45:46 *** Mechtilde has quit IRC
01:49:28 *** sbluhm has joined #gnucash
03:26:23 *** Mechtilde has joined #gnucash
03:52:30 *** gjanssens has joined #gnucash
03:52:30 *** ChanServ sets mode: +o gjanssens
04:20:06 *** immae has quit IRC
04:23:19 *** immae has joined #gnucash
05:09:19 *** User_ has joined #gnucash
05:23:32 *** Gerd has left #gnucash
05:33:08 <gjanssens> .
05:33:47 *** Unhammer has quit IRC
05:44:32 <chris> gjanssens est un vrai polyglotte :)
06:12:36 *** Hamaryns has joined #gnucash
06:12:36 *** ChanServ sets mode: +v Hamaryns
06:20:54 *** FH_thecat has joined #gnucash
06:40:22 *** Aussie_matt has quit IRC
06:48:04 *** Jimraehl1 has joined #gnucash
06:48:54 *** Jimraehl1 has quit IRC
06:55:32 <gjanssens> chris: :)
06:56:06 <gjanssens> French is one of the official national languages in Belgium, so I have a decent notion...
07:00:36 *** Hamaryns has quit IRC
07:45:55 <chris> Microsoft's AppGet looks interesting ...
08:13:12 *** chf has quit IRC
08:16:16 *** chf has joined #gnucash
08:19:36 <chris> not really-->Microsoft's AppGet looks interesting ...
08:21:30 <warlord> GM_Books, File -> Save As and choose MySQL
08:39:22 <chris> warlord: is the bugzilla database ok? "Bugs changed in the last 24 hours" giving an unusual list
08:42:30 *** Hamaryns has joined #gnucash
08:42:30 *** ChanServ sets mode: +v Hamaryns
08:54:36 <warlord> chris, let me check.
08:55:15 <GM_Books> warlord: Thanks for the feedback! Any suggestions what to try if it can't connect to the database?
08:56:23 <warlord> chris, mysql log was complaining about needing to run mysql_upgrade, so I did. Not sure if that was "it" or not.
08:56:42 <warlord> GM_Books, try using the standard mysql client, first, from your gnucash host?
08:57:00 <warlord> If you want to use MySQL we assume you're a DBA and know how to use and maintain a database.
08:58:29 *** fell_laptop is now known as fell
08:58:33 *** FH_thecat has quit IRC
08:58:43 *** FH_thecat has joined #gnucash
09:00:57 <GM_Books> warlord: Thanks, while I have used databases some I have not done a lot of setup. The database does seem to be accessible from Excel using the same credentials.
09:04:10 <warlord> GM_Books, Not sure how Excel talks to MySQL
09:04:21 <warlord> Are you on Windows?
09:23:47 <GM_Books> warlord: I use Windows 10 primarily, although I also recently installed on Ubuntu 20.04.
09:25:45 <warlord> Where is MySQL running?
09:31:03 <GM_Books> warlord: on Windows I installed the basic mySQL products. When I tried on my Ubuntu machine, I installed DBeaver as the database management tool. I feel less certain that the database is working at all correctly on Ubuntu. (To avoid confusion, I should clarify that my goal so far has been to get GnuCash talking with the database hosted on the same machine.)
09:32:21 <warlord> Let's step back a minute -- why do you want to use a Mysql backend?
09:35:37 *** jervin has joined #gnucash
09:37:15 *** jervin has quit IRC
09:38:22 <Mechtilde> I'm interested getting GnuCash running with a database backend like MySQL/MariaDB too
09:42:40 *** keiffer has joined #gnucash
09:49:28 *** sbluhm has quit IRC
09:53:14 *** Hamaryns has quit IRC
10:08:22 *** Hamaryns has joined #gnucash
10:08:23 *** ChanServ sets mode: +v Hamaryns
10:12:06 *** Gerd has joined #gnucash
10:18:29 *** omnireq_ has quit IRC
10:26:38 <GM_Books> warlord: It's a good question. Ultimately, I would have some interest in setting it up to run Justin Hunt's GnuCash mobile app for Android, although I realize that would take a whole different level of savvy. So if I would be able to query the database from mySQL, and do pivot reports directly in Excel, my thought is that might also be quite worthwhile potentially.
10:29:00 *** Gerd has quit IRC
10:31:50 *** Gerd has joined #gnucash
10:32:30 *** jervin has joined #gnucash
10:35:09 *** jervin has quit IRC
10:40:16 <warlord> GM_Books, fair enough. I've never run Mysql on Windows, so I can't help you there. I can certainly help you from the Ubuntu side (although I'm a RedHat/fedora guy myself).
10:40:21 *** Mechtilde has quit IRC
10:40:31 <warlord> I've never tried DBeaver. But I can walk you through the MySQL command-line tools.
10:40:38 <warlord> (at least on Ubuntu)
10:40:59 <warlord> On Windows I don't know if there is a firewall issue or something else going on.
10:41:01 *** jervin has joined #gnucash
10:41:04 *** jervin has quit IRC
10:55:35 <GM_Books> warlord, thanks for those ideas. Would you favor Fedora for running mySQL? I'm not opposed to giving it a try, although my preference would certainly be to stay in Windows if possible. In Windows I did temporarily try disabling the firewall, but it did not seem to change anything. I would appreciate some guidance, but work constraints are a bit of a problem currently. I'd like to try to check back when I have a little more time
10:55:35 <GM_Books> to dedicate to this, if that's okay.
10:55:47 <chris> is https://bugs.gnucash.org/show_bug.cgi?id=797739 a safe change to the Transaction Report? (I think so: changes the default options)
10:58:48 <chris> (what's sqlite3test.c doing in python?)
11:02:01 *** ecdhe has quit IRC
11:02:06 *** ecdhe has joined #gnucash
11:03:13 <warlord> GM_Books, I definitely think you should run your mysql server on a Linux platform and not windows.
11:04:21 *** ecdhe has quit IRC
11:04:23 <warlord> Like I said, we assume you're a DBA so we don't support the mysql side of the setup, only the gnucash side. We assume you can reach the mysql database and set it up properly before gnucash connects.
11:06:17 *** ecdhe has joined #gnucash
11:08:02 *** Hamaryns has quit IRC
11:08:37 *** ecdhe has quit IRC
11:08:44 *** ecdhe has joined #gnucash
11:16:31 *** ecdhe has quit IRC
11:16:59 *** ecdhe has joined #gnucash
11:18:54 *** ArtGravity has joined #gnucash
11:18:54 *** ChanServ sets mode: +v ArtGravity
11:20:14 *** ecdhe has quit IRC
11:20:17 *** ecdhe has joined #gnucash
11:22:20 *** omnireq has joined #gnucash
11:30:15 <jralls> chris, warlord, the changes in BZ were mine. I collapsed the individual 2.6.... version bugs into a single 2.6.x to shorten the version list.
11:33:18 <jralls> chris, 777739 seems reasonable and minor enough not to be a new feature.
11:52:08 <fell> While pushing, I got "warning: refname 'master' is ambiguous."
11:54:58 <jralls> fell, I see that too from time to time. I haven't been able to find the ambiguity.
12:05:07 *** guak has joined #gnucash
12:05:32 *** ramontjunior has quit IRC
12:20:50 <gjanssens> GM_Books: your reference to Justin Hunt's GnuCash mobile app for android caught my attention
12:21:11 <gjanssens> I had never heard of that one before so I searched for it in the google play store.
12:21:23 <gjanssens> I don't know what to think of it.
12:21:47 <gjanssens> There's almost no information on that page and the link to the app's website is dead.
12:23:10 <gjanssens> There's a free and a paid version.
12:25:16 <gjanssens> And just for the sake of clarity, Justin Hunt is a not gnucash developer and he never that I can find communicated with any of the gnucash devs about his plans for a gnucash mobile app.
12:25:58 <gjanssens> I guess he doesn't have to, but it all makes me a bit uneasy.
12:27:13 <ArtGravity> Google Play identifying the developer as GnuCash seems questionable.
12:29:15 <ArtGravity> I used a previous version with satisfaction some years back.
12:33:38 <jralls> ArtGravity, I think you're looking at https://play.google.com/store/apps/details?id=org.gnucash.android&hl=en. Justin Hunt's is https://play.google.com/store/apps/details?id=com.huntservicesllc.mobilegnucash&hl=en.
12:33:51 <ArtGravity> Yes
12:34:15 <ArtGravity> Haven't used it in quite some time, but it was a very good app during the time I used it.
12:36:02 <ArtGravity> I found the Mobile GnuCash by Justin Hunt that you are talking about.
12:36:07 <jralls> I think the GnuCash one is Ngewi Fett's. That one started as a Google Summer of Code project with GnuCash. Ngewi seems to have lost interest in maintaining it. It's a bit disappointing though that he's pointing users back to us.
12:36:22 *** Mechtilde has joined #gnucash
12:37:44 *** lmat has quit IRC
12:38:42 *** lmat has joined #gnucash
12:55:41 *** jethrogb has quit IRC
12:58:59 *** gjanssens has quit IRC
13:04:34 *** suukim has quit IRC
13:06:08 *** jervin has joined #gnucash
13:07:32 *** jervin has quit IRC
13:37:19 *** jethrogb has joined #gnucash
13:48:27 *** marusich has joined #gnucash
13:48:27 *** ChanServ sets mode: +v marusich
13:51:24 *** sbluhm has joined #gnucash
13:51:24 *** ChanServ sets mode: +v sbluhm
14:15:23 *** frakturfreak has joined #gnucash
14:15:23 *** ChanServ sets mode: +v frakturfreak
14:22:09 *** sbluhm has quit IRC
14:37:00 *** sbluhm has joined #gnucash
14:37:00 *** ChanServ sets mode: +v sbluhm
14:39:20 <GM_Books> warlord, I think ill try to look into getting Fedora and setting up a database that way. Would you have any suggestions for a management program or do you tend to rely on command line?
14:41:52 <Mechtilde> GM_Books, I prefer adminer
14:42:08 <warlord> I just use the cmd line.
14:43:47 <jralls> GM_Books, there's generally no operational difference between Ubuntu and Fedora except the package managers.
14:46:32 <GM_Books> Okay, thanks for the tips, Mechtilde, jralls, and warlord. Warlord, I'll probably need to be in touch.
14:46:50 <warlord> I'm here. :)
14:47:22 <GM_Books> warlord: :)
14:47:33 <Mechtilde> I use GnuCash with MySQl as the backend
14:48:20 <jralls> warlord, I encountered a reference to a QSF backend in qofsession.h Do you remember anything about it?
14:52:39 <warlord> jralls, yeah, it was supposed to be a generic way to serialize QOF objects
14:53:03 <warlord> IIRC the goal was a https/xml/soap-based backend (client/server)
14:56:06 * jralls had to go to wikipedia to remember what soap was.
14:59:34 *** Han has joined #gnucash
15:39:50 *** Mechtilde has quit IRC
15:56:43 *** Mechtilde has joined #gnucash
15:57:16 *** sbluhm has quit IRC
15:59:44 *** Mechtilde has quit IRC
16:24:49 *** waeking has joined #gnucash
16:24:49 *** ChanServ sets mode: +v waeking
16:29:39 *** sbluhm has joined #gnucash
16:29:39 *** ChanServ sets mode: +v sbluhm
16:36:00 *** Han has quit IRC
17:12:05 *** frakturfreak has quit IRC
17:18:24 *** keiffer has quit IRC
17:28:14 *** jervin has joined #gnucash
17:28:47 *** Mechtilde has joined #gnucash
17:31:48 *** Mechtilde has quit IRC
17:34:25 *** User_ has quit IRC
17:49:26 *** jervin has quit IRC
17:52:58 *** jervin has joined #gnucash
18:02:39 *** sbluhm has quit IRC
18:08:30 *** tmetro has joined #gnucash
18:13:21 *** Mechtilde has joined #gnucash
18:16:22 *** Mechtilde has quit IRC
18:26:31 *** jervin has quit IRC
18:33:01 *** Gerd1 has joined #gnucash
18:33:19 *** Gerd has quit IRC
18:33:19 *** Gerd1 is now known as Gerd
18:38:01 *** jervin has joined #gnucash
18:39:17 *** jervin has quit IRC
18:49:36 *** jervin has joined #gnucash
19:12:10 *** FH_thecat has quit IRC
19:13:11 *** Aussie_matt has joined #gnucash
19:19:12 *** jervin has quit IRC
19:19:24 *** omnireq has quit IRC
19:30:19 *** chf has quit IRC
19:49:20 *** chf has joined #gnucash
19:51:46 *** guak has quit IRC
20:15:28 *** omnireq has joined #gnucash
20:15:28 *** ChanServ sets mode: +v omnireq
20:16:10 *** jervin has joined #gnucash
20:16:46 *** jervin has joined #gnucash
20:17:03 *** jervin has quit IRC
20:19:32 *** ArtGravity has quit IRC
21:36:08 *** FH_thecat has joined #gnucash
21:39:14 *** chf has quit IRC
21:39:40 *** chf has joined #gnucash
21:46:55 *** Gerd has quit IRC
21:55:16 *** Gerd has joined #gnucash
22:35:20 *** jervin has joined #gnucash
22:40:52 *** jervin has quit IRC
22:47:42 *** omnireq_ has joined #gnucash
22:48:51 *** omnireq has quit IRC
22:49:16 *** Gerd has quit IRC
22:50:06 *** Gerd has joined #gnucash
23:36:43 *** Mechtilde has joined #gnucash
23:39:44 *** Mechtilde has quit IRC
23:41:56 *** omnireq_ has quit IRC
23:43:33 *** omnireq_ has joined #gnucash
23:56:02 *** FH_thecat has quit IRC
23:56:19 *** FH_thecat has joined #gnucash