2018-10-27 GnuCash IRC logs

08:34:41 *** gncbot has joined #gnucash
08:35:06 <warlord> Okay, so clearly gncbot doesn't properly restart on a cold boot..
08:38:03 *** ChanServ sets mode: +qo warlord warlord
08:38:04 *** warlord sets mode: +o gncbot
08:42:55 <gjanssens> warlord: anything we can do about the irc spam we're getting today ?
08:43:23 <warlord> gjanssens: well, luckily I dont think gncbot was here to record it...
08:43:44 <warlord> But I dont know how to block the spam unless it's coming from a stable address (range) and we can kick/ban the offenders.
08:43:51 <gjanssens> yes, that's at least one thing...
08:44:17 <warlord> going forward, I DO try to purge the IRC logs when I see it, but it wouldn't hurt to point it out to me if/when it occurs.
08:45:10 <gjanssens> ok
08:46:52 <warlord> and of course the banning doesn't hurt, either.
08:47:49 *** esc has joined #gnucash
08:47:56 *** boldstripe has joined #gnucash
08:47:58 *** esc has quit IRC
09:05:04 *** idimmu has joined #gnucash
09:05:52 *** idimmu has quit IRC
09:06:08 *** ncv has joined #gnucash
09:15:53 *** ca-on-adam has joined #gnucash
09:26:05 *** aeSee5eiqu has joined #gnucash
09:26:54 *** aeSee5eiqu has quit IRC
09:28:34 *** mazzen0 has joined #gnucash
09:31:50 *** mazzen0 has quit IRC
09:33:00 *** tacco has joined #gnucash
09:33:14 *** gjanssens sets mode: +b tacco!*@*
09:33:31 *** fabior has joined #gnucash
09:34:40 *** chirps has joined #gnucash
09:35:21 *** chirps has quit IRC
09:35:41 *** chirps has joined #gnucash
09:36:38 <gjanssens> warlord: we had a few more spam lines unfortunately.
09:36:50 *** tacco has quit IRC
09:38:42 *** chirps has quit IRC
09:49:01 *** jeandet has joined #gnucash
09:49:53 *** jeandet has quit IRC
10:08:21 *** fabior has quit IRC
10:13:36 *** colints has joined #gnucash
10:14:38 *** colints has quit IRC
10:25:31 *** sixwheeledbeast has quit IRC
10:26:31 *** sixwheeledbeast has joined #gnucash
10:40:07 *** tms has left #gnucash
11:22:23 *** msekar has joined #gnucash
11:33:55 *** msekar has quit IRC
12:21:44 *** gncbot sets mode: +o fell
12:22:01 *** User_ has joined #gnucash
12:24:18 *** Frostar has joined #gnucash
12:24:32 *** Frostar was kicked by fell (User terminated!)
12:25:51 <fell> Warlord, we need a spamfilter here
12:28:04 *** User_ has quit IRC
12:31:01 <fell> euirc.net filters against a dns blacklist
12:33:06 <gjanssens> warlord: in case you didn't notice fell's ping ^
12:49:39 <fell> Usually it is a task for the server, but probably a plugun for supybot existsß
12:49:46 <fell> ?
12:55:04 <fell> https://github.com/Supybot/Supybot has it's last real commit in 2015.
12:56:22 <fell> They suggest https://github.com/ProgVal/Limnoria
13:04:33 *** fell has quit IRC
13:09:17 *** fell has joined #gnucash
13:09:17 *** gncbot sets mode: +o fell
13:20:04 <jralls> fell: Do you think that the blacklist is likely to know about the compromised machines in this botnet?
13:21:35 <jralls> Interestingly they're not targetting #gnome, the other list on this server I'm joined to ATM.
13:22:56 <fell> Did they pay him?
13:23:19 *** gjanssens has quit IRC
13:24:31 <jralls> Huh?
13:24:33 <fell> I have no idea to filter IPs of bot nets. At liast on could filter typical strings from his freenode fight.
13:25:44 <jralls> Yeah, ISTR there's a way to ban phrases. I used that the last time we got one of these spam-storms. I don't remember the spell, so I'm looking now.
13:26:49 <warlord> fell: I have no idea how to install a spam filter here. We should talk to the operators.
13:27:12 <warlord> fell: yeah, I am switching to limnoria at the next major code update.
13:27:24 <fell> Somewhere I read, somebody talked to him and got his net spared out.
13:30:51 <warlord> I wonder if it's due to us having a forwarding link from #gnucash on freenode?
13:32:46 <fell> May be. IIRC jsled created that for users mixing up the nets.
13:33:21 <warlord> Yeah. So there's a "link" to here, which might be why we're getting freenode spam
13:43:11 * warlord is playing with AWS for work. It's funny -- the interface is very similar to ovirt!
13:43:56 *** finster has joined #gnucash
13:44:48 <jralls> It probably *is* ovirt, just tarted up with different chrome.
13:45:00 <Simon> aiui it's not a botnet, it's just lots of open proxies and compromised hosts
13:45:35 <jralls> And a botnet differes from a collection of compromised hosts under central command how?
13:45:40 <Simon> you'd need to write code to normalise their unicode mess into something that can be checked against a list, because they're still pushing the same URLs
13:46:07 <Simon> they're not independently sending messages; it's one single host using multiple proxies, that's why they're never overlapping
13:46:42 <Simon> a botnet implies something running on each of those hosts, I think they're literally just vulnerable hosts with ssh open to the world
13:49:01 <jralls> It takes more than ssh open to the world: At least one ssh key has to be compromised as well in order to be able to do anything. And there obviously is some sort of IRC relay program running on the compromised hosts.
13:49:13 <Simon> there may be a DNS blacklist that uses data collected from https://github.com/kaniini/antissh
13:49:23 <Simon> you don't need any kind of relay program
13:49:35 <Simon> tunnelling TCP is built-in to SSH
13:50:01 <jralls> Ah, didn't think of that.
13:50:24 <Simon> and they're just using default usernames and passwords
13:51:33 <Simon> 159.192.247.30 has port 22 open
13:52:02 <Simon> there's not so much you can do at the individual channel level except ban them by IP address automatically on the first message
13:52:13 <Simon> unless you want to require registration to join the channel
13:52:38 <finster> seems like a sensible thing to do, require registration
13:53:54 <Simon> you could also make the channel +s
13:56:36 <jralls> I doubt that that would have any effect on the spammers while making it hard for new users.
13:57:17 <jralls> Registration might help but again raises a bar to new users looking for help.
14:06:04 <finster> It works pretty good in other channels to have forced registration, imo.
14:16:28 <Simon> +s shouldn't be too much of a problem
14:18:47 <warlord> jralls: could be ;)
14:20:38 <warlord> (could be ovirt with new chrome)
14:21:42 <jralls> warlord: Can we delete the freenode link or at least make it secret?
14:27:21 <fell> Probably jsled granted warlord rights. We other seem to young,
14:38:13 *** dfgg has joined #gnucash
14:46:22 *** chris has joined #gnucash
14:51:26 *** bertbob has quit IRC
14:55:16 *** bertbob has joined #gnucash
14:58:19 *** bertbob has quit IRC
14:59:59 *** bertbob has joined #gnucash
15:00:10 *** Tin_man has joined #gnucash
15:14:26 *** marusich has joined #gnucash
15:27:44 *** finster has quit IRC
16:17:12 <warlord> I honestly don't recall or know.
16:32:49 *** aanm has joined #gnucash
16:33:28 <aanm> hello, probably this question was asked multiple times. Is it possible to get the XIRR of my investments?
16:37:24 *** buoyantair has quit IRC
16:51:45 <jralls> aanm: Not in any report that GnuCash has.
16:52:21 <aanm> jralls, thanks for the reply. Are all reports written in Scheme?
17:08:08 *** boldstripe has quit IRC
17:11:41 *** Mechtilde has quit IRC
17:13:05 <jralls> aanm: Yes.
17:14:16 *** k1804 has joined #gnucash
17:16:33 *** User_ has joined #gnucash
17:16:40 <k1804> Does the age datafile have anything to do with the way Gnucash handles Mysql gnclock?
17:16:44 *** aanm has quit IRC
17:21:05 <k1804> 2 databases: 1 from from 04 to 12 , 2 from 13 to current, version 2.6.19 does not delete the lock from database 1 but does on database2
17:21:56 *** carwynnelson has joined #gnucash
17:23:11 *** chirps has joined #gnucash
17:25:40 *** User_ has quit IRC
17:25:44 <k1804> if I delete the gnclock table - databse opens , If I only delete table data, I get this error CRIT <gnc.backend.dbi> [gnc_dbi_lock_database()] Error 1050: Table 'gnclock' already exists creating lock table
17:28:14 <k1804> database 2 runs just fine, gnclock table data gets dropped and no problems if the table gnclock exists.
17:30:27 <k1804> both databases have the same user permissions
17:48:37 <jralls> k1804: That's pretty weird.
17:49:45 <jralls> No, GnuCash shouldn't care about the timespan in the database.
17:49:56 <k1804> yeah, I agree
17:50:40 <jralls> So there must be (have been?) something about the gnclock table in db1. That should only be there if GnuCash disconnects without closing itself down properly.
17:51:42 <k1804> I thought so to then dropped the table so gnucash would rebuild it
17:52:57 <jralls> And...?
17:53:21 <k1804> table data remains on close
17:53:56 <k1804> could it be something with Mysql?
17:56:17 <jralls> I don't know enough yet. The table should be present but empty when GnuCash isn't connected. If you drop it, GnuCash should write a warning to the tracefile and recreate it.
17:58:11 <k1804> I don't get a warning that the table does not exists
17:58:34 <jralls> So comparing db1 and db2, GnuCash is leaving the lock record in db1 even when it seems to quit normally, but when it quits from db2 it's removing the lock?
17:59:20 <k1804> correct
18:03:24 <k1804> I just thought it was strange behavior, didn't know what else to do, not a bug, db2 runs just fine.
18:06:27 <jralls> So either it's failing to shut down correctly or it's failing to remove the lock record. There are no errors at the end of the db1 session in the tracefile? What about the MySQL server logs?
18:08:43 <k1804> using the trace log timestamp, nothing in mysql/error.log
18:10:29 <jralls> When you reconnect to db1 I trust that you get the "already in use by another session" dialog. Does "Open Anyway" work?
18:11:39 <k1804> no, I don't. I get an error occured bad or corupt data
18:12:32 <jralls> Oh, that's interesting. But if the gnclock table isn't there it opens OK?
18:12:45 <k1804> yes
18:12:47 <jralls> Curiouser and curiouser.
18:13:37 <k1804> error: The server at URL mysql://opt755@10.0.0.221/pnar04-12 experienced an error or encountered bad or corrupt data.
18:14:18 <jralls> But the MySQL server logs say nothing about that error?
18:15:42 <k1804> I moved the db to a new machine using mysqldump, I can try everything again
18:20:22 <k1804> no I don't
18:20:28 <jralls> That's probably not going to change anything. The "experienced an error..." dialog corresponds to an error written to the tracefile that gives a little more detail about what actually faild.
18:20:41 <jralls> err, failed.
18:25:19 *** pyrtsa has joined #gnucash
18:25:47 <jralls> Hmm. In most cases. Failing to delete the lock record is one of the cases that doesn't, it uses another mechanism.
18:33:44 <k1804> I'll keep messing with it, If I find something I'll drop a line back here. thank you for your time... cheers!
18:34:38 <k1804> I'm going to load the xml backup file and resave to a new db...see what happens :)
18:35:19 <jralls> OK, that sounds like it might help.
19:02:05 *** carwynnelson has quit IRC
19:10:55 <jralls> @tell stummi: That's perhaps overreacting. I laid out my concerns here with warlord yesterday and echoed those on your PR and on https://bugs.gnucash.org/show_bug.cgi?id=427948 earlier. But GnuCash is a consensus anarchy, so we need to see what reaction we get, particularly on the bug comments.
19:10:55 <gncbot> jralls: The operation succeeded.
19:23:47 *** marusich has quit IRC
20:03:28 *** oozer has quit IRC
20:56:00 *** boldstripe has joined #gnucash
20:56:33 <chris> I think Carsten did a XIRR-type report called asset-performance.scm
21:09:06 *** gour_ has quit IRC
21:09:41 <jralls> chris: Do you know where it is?
21:19:20 <chris> christopherlam/maint-asset-performance I try to fix/cleanup
21:19:58 <chris> one of his bug reports
21:20:38 <chris> ive also cleaned phil longstaff's budget-ytd report
21:28:25 *** skaji has joined #gnucash
21:30:04 <chris> christopherlam/master-ytd (rebased on maint)
21:34:23 *** bookworm has joined #gnucash
22:17:25 <chris> https://bugs.gnucash.org/show_bug.cgi?id=696575
22:24:29 <k1804> after many tries, save as mysql was sucsessful to where the db gnclock table functions as designed. all is well. thank you. note: several attempts created only the gnclock table which I promptly deleted and performed save as mysql again.
22:27:45 <k1804> common error in the trace file is
22:27:46 <k1804> WARN <> Invalid borders specified for theme pixmap:
22:27:48 <k1804> /usr/share/themes/Breeze/gtk-2.0/../assets/line-h.png,
22:27:50 <k1804> borders don't fit within the image
22:30:49 <k1804> Kubuntu 18.04, KDE plasma 5.12.6
22:53:12 *** chris has quit IRC
22:59:10 *** chris has joined #gnucash
23:08:19 *** fell has quit IRC
23:11:38 <chris> 2 ideas brewing: (1) Transaction Report separate subtotals for Debit/Credit in dual-amount mode, (2) I think I know how to code 'monthly end-of-month intervals' eg asset-barchart end-of-day 31-jan, 28-feb, 31-mar etc... because the current asset-barchart does end-of-day 1-jan 1-feb 1-mar etc
23:19:13 *** Agfarmer18 has joined #gnucash
23:22:40 *** k1804 has quit IRC