2019-12-06 GnuCash IRC logs
00:17:15 *** omnireq has quit IRC
00:17:25 *** omnireq has joined #gnucash
00:17:25 *** ChanServ sets mode: +v omnireq
00:38:29 *** mattcen has quit IRC
00:38:45 *** omnireq has quit IRC
00:38:55 *** omnireq has joined #gnucash
00:38:55 *** ChanServ sets mode: +v omnireq
00:57:28 *** Gerd has joined #gnucash
01:05:43 *** o01eg has quit IRC
01:13:09 *** Gerd has quit IRC
01:17:32 *** Mechtilde has joined #gnucash
01:23:20 *** Mechtilde has quit IRC
01:29:03 *** obscurans has quit IRC
01:29:04 *** Mechtilde has joined #gnucash
01:30:12 *** fell has joined #gnucash
01:30:12 *** ChanServ sets mode: +o fell
01:37:43 *** sbluhm has joined #gnucash
01:37:43 *** ChanServ sets mode: +v sbluhm
01:44:27 *** obscurans has joined #gnucash
01:45:37 *** epi has joined #gnucash
01:49:15 *** pohly1 has joined #gnucash
01:50:01 <epi> Hi, I am trying to connect GnuCash with a MySQL database. Without SSL (require_secure_transport) I am able to do that just fine. With SSL I get an Error like this: "INFO <gnc.backend.dbi> [error_handler] DBI error: 3159: Connections using insecure transport are prohibited while --require_secure_transport=ON." Do I have to configure GnuCash specially? I can open a connection via command line with SSL.
01:55:59 *** Mechtilde has quit IRC
03:14:42 *** gjanssens has joined #gnucash
03:14:42 *** gncbot sets mode: +o gjanssens
03:14:42 *** ChanServ sets mode: +o gjanssens
03:17:44 *** Unhammer has joined #gnucash
03:29:40 *** Gerd has joined #gnucash
03:37:29 <gjanssens> .
03:39:46 <obscurans> hi all, new user, interested in contributing code
03:44:41 <gjanssens> obscurans: great we can always use more help
03:45:47 <obscurans> I'm finding pain points on reconciliation, so I'm happy to dig into that
03:46:06 <obscurans> filed bug 797514 on unreconciliation behaviour itself inconsistent
03:51:35 <gjanssens> I saw those. I'll try to add my comments later (no time right now). I can already say the general idea looks ok though, but needs some polishing/adapting to the current code realities of gnucash.
04:20:26 *** Gerd has quit IRC
04:24:02 *** bertbob has quit IRC
04:26:22 *** gggg has joined #gnucash
04:28:51 *** bertbob has joined #gnucash
04:28:52 *** ChanServ sets mode: +v bertbob
04:38:00 *** epi has quit IRC
04:52:40 *** omnireq has quit IRC
05:03:57 *** gggg has quit IRC
05:22:16 *** KevinDB has quit IRC
05:23:14 *** epi has joined #gnucash
05:23:54 *** KevinDB has joined #gnucash
05:23:54 *** ChanServ sets mode: +v KevinDB
05:35:57 *** epi has quit IRC
05:36:02 *** epi has joined #gnucash
05:46:25 *** chris has joined #gnucash
05:46:25 *** ChanServ sets mode: +v chris
05:56:27 <epi> Hi all, I am not sure whether my previous message got lost so repeat it once more: I am trying to connect GnuCash with a MySQL database. Without SSL (require_secure_transport) I am able to do that just fine. With SSL I get an Error like this: "INFO <gnc.backend.dbi> [error_handler] DBI error: 3159: Connections using insecure transport are prohibited while --require_secure_transport=ON." Do I have to configure GnuCash specially? I can open a connec
05:56:27 <epi> tion via command line with SSL.
06:34:24 *** User has joined #gnucash
06:36:11 *** Jimraehl1 has joined #gnucash
06:37:40 *** Jimraehl1 has quit IRC
06:59:32 *** User has quit IRC
07:02:28 *** sbluhm has quit IRC
07:04:09 *** oozer has joined #gnucash
07:16:51 *** karelk has quit IRC
07:17:07 *** puck has quit IRC
07:19:13 *** puck has joined #gnucash
07:40:51 *** epi has quit IRC
08:08:20 *** fell has quit IRC
08:08:47 *** Mechtilde has joined #gnucash
08:26:06 *** oozer has quit IRC
08:52:12 *** omnireq has joined #gnucash
09:04:38 *** warlord has quit IRC
09:04:42 *** warlord has joined #gnucash
09:05:23 *** oozer has joined #gnucash
09:12:54 *** omnireq_ has joined #gnucash
09:14:07 *** omnireq has quit IRC
09:27:33 <gjanssens> I saw those. I'll try to add my comments later (no time right now). I can already say the general idea looks ok though, but needs some polishing/adapting to the current code realities of gnucash.
09:27:41 <gjanssens> Oops, wrong window...
09:34:40 <chris> fwiw my list->pair branch does work well... could optimize numerous calls, eg xaccAccountGetSplitList, qof_query_run when they return a list of splits...
09:35:08 <chris> they can return a null-terminated pointer to a lispy pair instead
09:35:31 <chris> avoids a lot of long splitlist traversals at the cost of slightly uglier code
09:36:14 <chris> perhaps gjanssens would not object to augmenting it, in bindings/guile for example ;)
09:47:58 *** sbluhm has joined #gnucash
09:47:58 *** ChanServ sets mode: +v sbluhm
09:59:12 *** sbluhm has quit IRC
10:00:01 *** User has joined #gnucash
10:02:56 *** jervin has joined #gnucash
10:03:05 *** User has quit IRC
10:21:25 *** storyjesse has quit IRC
10:22:12 *** omnireq_ has quit IRC
10:22:22 *** omnireq_ has joined #gnucash
10:27:29 *** omnireq_ has quit IRC
10:27:40 *** oozer has quit IRC
10:34:23 *** storyjesse has joined #gnucash
10:38:24 *** o01eg has joined #gnucash
10:44:15 *** jervin has quit IRC
10:45:09 *** guak has joined #gnucash
10:45:19 *** Mechtilde has quit IRC
10:53:07 *** Agfarmer18 has joined #gnucash
10:58:04 *** Robert8471 has joined #gnucash
10:58:08 *** Robert8471 has left #gnucash
10:58:43 *** Agfarmer18 has quit IRC
10:58:52 *** Agfarmer18 has joined #gnucash
10:59:45 *** omnireq has joined #gnucash
10:59:45 *** ChanServ sets mode: +v omnireq
11:08:38 *** ArtGravity has joined #gnucash
11:08:39 *** ChanServ sets mode: +v ArtGravity
11:12:05 *** Gerd has joined #gnucash
11:35:14 *** Agfarmer18 has quit IRC
11:36:36 *** Robert847 has joined #gnucash
11:36:36 *** ChanServ sets mode: +v Robert847
11:36:54 *** Robert847 has left #gnucash
11:41:21 *** oozer has joined #gnucash
11:51:27 *** Agfarmer18 has joined #gnucash
12:01:56 *** storyjesse has quit IRC
12:04:19 *** Agfarmer18 has quit IRC
12:09:51 <jralls> @tell epi GnuCash doesn't know how to connect to MySQL over SSL.
12:09:51 <gncbot> jralls: The operation succeeded.
12:13:01 <jralls> chris: You've gone off in the wrong direction with list traversal, there's no need to copy the list or allocate a phony cons cell. A list node is already a cons cell.
12:13:38 <jralls> chris I thought that I'd explained that yesterday but I guess it didn't make sense to you.
12:19:20 <jralls> gjanssens when you have time we need to discuss when to release 4.0. We've already missed out on January if we're going to have a significant amount of beta testing. I've got a few more days of work on load/save, then integration into dialog-options.c and modifying all of the report code for the new API and writing shims for backward compatibility.
12:20:31 <gjanssens> I was wondering about that as well recently.
12:20:42 <gjanssens> How much beta time do we want ?
12:20:55 <gjanssens> I think it was 3 months in the original planning
12:21:12 <warlord> My main UPS batteries are dead (they *are* over 7 years old now). I'm working on getting a quote to replace them all.
12:22:01 <gjanssens> Or more accurately our release page suggests we would start with beta releases in October
12:22:13 <gjanssens> with a release "early 2020"
12:23:18 <gjanssens> As we missed that October deadline, I'd propose to do a first beta in December with feature freeze in February ?
12:23:27 <gjanssens> That's tw o months of beta testing.
12:23:59 <gjanssens> Give it another month for stabilizing and we should be able to release beginning of March ?
12:24:17 <gjanssens> What do you think of this ?
12:24:42 *** karelk has joined #gnucash
12:28:52 *** karelk has joined #gnucash
12:38:25 <jralls> gjanssens, It's only one month of testing after feature freeze. That's OK for minor new features but I think we need more testing for major changes like dropgml and c++options. I think you're close to being ready with dropgml, but I'm not at all confident of having c++options ready to merge by say the end of January.
12:39:46 <gjanssens> Ok, what do you propose ?
12:40:27 <gjanssens> If we want c++options in 4.0 I think it's best to wait for its merge before doing the first beta release
12:42:24 <jralls> I agree. I'm reasonably sure that it will be mergeable by March, which would set us up for a June release.
12:43:12 <gjanssens> Ok. Let's do that then. I prefer doing things right rather than in a hurry.
12:44:02 <jralls> We'll wind up being in a hurry anyway, that's just the way of the world. But more time for doing things right first is better.
12:46:09 *** karelk has joined #gnucash
12:47:57 <gjanssens> :)
13:13:12 *** sbluhm has joined #gnucash
13:13:12 *** ChanServ sets mode: +v sbluhm
13:13:30 <jralls> OK, I've updated https://wiki.gnucash.org/wiki/Release_Schedule.
13:24:20 *** Gerd has quit IRC
13:28:20 *** obscurans has quit IRC
13:32:51 *** kael has joined #gnucash
13:32:51 *** ChanServ sets mode: +v kael
13:34:07 <gjanssens> looks good
13:43:44 *** obscurans has joined #gnucash
13:50:50 *** sbluhm has quit IRC
14:00:38 *** karelk has quit IRC
14:04:59 <warlord> jralls, gjanssens, where *is* the tip jar policy? I thought it was on the wiki but I couldn't find it.
14:05:26 <gjanssens> warlord: I linked to it in my email reply
14:05:35 <gjanssens> https://wiki.gnucash.org/wiki/Decision_process
14:06:03 <gjanssens> It's more general than tip jar use, perhaps that's why you didn't find it.
14:08:27 <warlord> Maybe..
14:10:31 <warlord> Of course I am literally $72 over the threshold for a high impact decision which means I have to wait for 3 weeks instead of 10 days. Blah.
14:14:03 *** frakturfreak has joined #gnucash
14:15:36 <warlord> gjanssens, FYI, haven't seen your email reply.
14:15:57 *** Robert847 has joined #gnucash
14:16:24 *** sbluhm has joined #gnucash
14:16:24 *** ChanServ sets mode: +v sbluhm
14:17:28 <gjanssens> warlord: it did make it to the gnucash-core list, is it in your spam folder ?
14:18:07 <warlord> Nope.
14:18:33 *** karelk has joined #gnucash
14:19:29 <warlord> Let me check my server logs.
14:20:07 *** FH_thecat has joined #gnucash
14:20:54 <warlord> Aha...
14:20:57 <warlord> Dec 6 14:15:33 mail2 postfix/smtpd[17092]: NOQUEUE: reject: RCPT from mail.kobaltwit.be[81.82.192.49]: 450 4.1.7 <geert.gnucash@kobaltwit.be>: Sender address rejected: unverified address: Address verification failed; from=<geert.gnucash@kobaltwit.be> to=<derek@ihtfp.com> proto=ESMTP helo=<mail.kobaltwit.be>
14:21:27 <warlord> failing the 'sender-verify' test, for some reason.
14:21:43 <warlord> But not sure why the gnucash-core version didn't make it to me.
14:21:56 *** FH_thecat has quit IRC
14:22:49 *** FH_thecat has joined #gnucash
14:25:21 <gjanssens> Probably because I had you in cc ?
14:25:31 <warlord> Maybe..
14:25:43 <warlord> Still, I should unblock you ;)
14:25:55 <gjanssens> :)
14:26:05 *** FH_thecat has quit IRC
14:26:10 *** Mechtilde has joined #gnucash
14:26:16 * gjanssens wonders why sender address verification failed...
14:26:40 <warlord> Dunno.
14:26:54 <warlord> Check your logs at ~14:15?
14:26:58 <warlord> (us/et)
14:28:12 *** karelk has quit IRC
14:29:28 <gjanssens> Apparently sav and greylist are competing on my system
14:29:42 <gjanssens> Your SAV request is being greylisted.
14:29:50 <gjanssens> Not sure how to deal with that
14:30:20 *** Gerd has joined #gnucash
14:30:48 <warlord> hahaha
14:31:10 <warlord> Well, I've just whitelisted you
14:31:19 <warlord> So next retry should get through
14:38:19 *** ChanServ sets mode: +v obscurans
14:38:54 <warlord> gjanssens, made it through.
14:39:05 <gjanssens> yay
14:48:01 *** calvinct has joined #gnucash
14:55:40 *** pohly1 has quit IRC
15:16:47 *** Mechtilde has quit IRC
15:34:27 *** Robert847 has quit IRC
15:58:54 *** gjanssens has quit IRC
15:59:06 *** fell has joined #gnucash
15:59:06 *** ChanServ sets mode: +o fell
16:00:09 *** splat has joined #gnucash
16:01:14 *** splat has quit IRC
16:04:35 *** fabior has joined #gnucash
16:12:38 *** sbluhm has quit IRC
16:14:01 *** jralls has quit IRC
16:33:25 *** zipppy has quit IRC
16:48:09 *** calvinct has quit IRC
16:56:52 *** fabior has quit IRC
16:59:25 *** MAK has joined #gnucash
17:06:28 *** jervin has joined #gnucash
17:13:12 *** MAK has quit IRC
17:13:16 *** frakturfreak has quit IRC
17:35:47 *** calvinct has joined #gnucash
17:57:23 *** calvinct has quit IRC
18:02:56 *** jervin has quit IRC
18:03:06 *** jervin has joined #gnucash
18:25:55 <chris> jralls: (1) I agree there's no need to g_list_copy (2) a phony cons cell...?
18:26:23 <chris> FWIW the branch SplitPair kinda works, but I am not happy it is 1000% right
18:26:55 *** ArtGravity has quit IRC
18:27:17 <chris> I just wished to avoid GList<->SCM_list O(2N) list-traversals; I think my idea has merit
18:28:00 <chris> I can imagine a splitpairs.[ch] to set up the data structure
18:30:36 <chris> https://github.com/christopherlam/gnucash/blob/maint-pairs/libgnucash/engine/Account.cpp#L3825
18:32:26 <chris> https://github.com/christopherlam/gnucash/blob/maint-pairs/gnucash/report/report-system/report-utilities.scm#L502 to use it
18:32:51 <chris> I could understand your C code but don't know how it would get called from SCM
18:40:55 <chris> I think you understand that the purpose of this branch is to keep calls like xaccAccountGetSplitList and qof_query_run (for splits) useful
18:41:26 <chris> but as soon as it's called, the whole GList is traversed to create a SCM list
18:42:06 <chris> so, instead of exposing the GList, we expose the phony cons cell with car/cdr accessors
18:42:21 <chris> and walk the list via cons pair accessors from SCM
18:43:47 <chris> this means, for example, xaccAccountSplitPair is essentially a simple phony-cons to walk the account->splits, and is O(1) rather than O(2N)
18:57:25 <chris> I suspect you'd want me to convert functions like gnc:account-accumulate-at-dates to C but I'm not that keen yet :)
19:06:54 *** omnireq has quit IRC
19:21:41 *** KaiForce has quit IRC
20:01:57 *** omnireq has joined #gnucash
20:08:09 *** Gerd has quit IRC
20:23:06 *** kael has quit IRC
20:31:57 *** Gerd has joined #gnucash
20:36:57 *** fell has quit IRC
20:43:57 *** Gerd has quit IRC
20:56:56 *** omnireq has quit IRC
21:19:48 *** oozer has quit IRC
22:01:58 *** omnireq has joined #gnucash
22:31:12 *** jervin has quit IRC
22:33:33 <chris> because gnc:account-accumulate-at-dates needs to call an scm lambda account->splits
22:40:00 *** guak has quit IRC
22:53:03 *** oliver has quit IRC
22:54:45 *** oliver has joined #gnucash