asciilifeformtherealbitcoinagriculturalsupremacyossasepiaspykedtrilemaalethepedia
9h 42m1d 8h 40m16h 41m3d 5h 57m9h 42m196d 1h 7m15h 43m

Show Idle (>14 d.) Chans


diana_coman: what a great #o log to start the day to! BingoBoingo draft looks good, I'd probably just add a comma after "to take shape"; and congrats to jfw on a straight-to-the-point quote!
diana_coman: meh, wrong chan, sorry.
bvt: diana_coman: i got it, the preview of how it will look like now: http://paste.deedbot.org/?id=iEDJ
diana_coman: bvt: that looks good indeed.
feedbot: http://qntra.net/2020/03/cross-process-cache-sidechannel-found-in-recent-amd-processors/ << Qntra -- Cross Process Cache Sidechannel Found In Recent AMD Processors
feedbot: http://qntra.net/2020/03/as-tmsr-os-project-gains-momentum-it-begins-leaving-legacy-project-devs-behind/ << Qntra -- As TMSR OS Project Gains Momentum It Begins Leaving Legacy Project Devs Behind
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959219 << the functioning i'm looking for is that given some inputs (such as a privkey and txids) your program spits out a tx as is broadcast on the network.
ossabot: Logged on 2020-03-09 22:26:10 jfw: mp_en_viaje: do you have a specific goal in mind for Thursday's wallet work? Do you also want to use the online part (I would imagine so but could technically be done without)? If so, note that it takes about a day to scan the present blockchain once fed the address(es) of interest, and requires a TRB node. If you wish to also send the rawtx using it, as would be most proper, we'll also need that
mp_en_viaje: if this isn't what it does, i suspect i might deeply misunderstand wtf it actually does.
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959221 << well, do you have the item currently working somewhere ?
ossabot: Logged on 2020-03-09 22:57:28 lobbes: mp_en_viaje: In preparation of our next attempt at getting this project done, I've been going through my faff-fest from last time.. and trying to figure out how we should pick back up
ericbot: Logged on 2019-12-04 04:37:32 mircea_popescu: lobbes wtf dude, you set ALL of these to 2019-12-03 22:03:06 time ?! didn't we go through an entire discussion of how it should increase monotonically ? gah.
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959225 << well, afternoon is what i had in mind, but yes, sure.
ossabot: Logged on 2020-03-09 22:57:45 lobbes: Also, are you good for tomorrow night or were you looking for doing this during the day? I'm slaving in the mines tomorrow but my night is clear. If need be I may be able to weasel a work-from-home day though, so I'll check back when I wake up tomorrow
billymg: hola from sunny costa rica
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-10#1020533 << isn't selecting for me either. the reason is that the text isn't "that, Well" but "that. <a href=blabla>Well". select dun work well with a href boundaries.
ossabot: (ossasepia) 2020-03-10 dorion: BingoBoingo, http://trilema.com/2017/remember-the-security-hole-automattic-refused-to-fix-back-in-2014?b=that.%20Well..&amp;e=able#select isn't selecting for me.
mp_en_viaje: billymg, same to you!
billymg: mp_en_viaje: gracias!
mp_en_viaje is checking out what's so great bout them o logs!
billymg: i've got a temporary internet solution now as well (cellular LTE via Movistar) as we work on getting the real thing
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020381 << if that.
ossabot: (ossasepia) 2020-03-09 diana_coman: spyked: well, no boost dep is certainly a gain; and yeah, I'm sure that the earlier the version the less of a monster it is; that being said, I'm either really getting old or something but I can hardly see the point of >10k LOC for what can be done precisely as wanted through <1k lines of cmd line tools, huh.
billymg will bbl - irl chores for the day
mp_en_viaje: billymg, talk to hanbot, she found some pretty cool radio people that sold me a backup thing really fucking solid.
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020383 << funny, because... BONES WORK THE SAME WAY. kekekekex
ossabot: (ossasepia) 2020-03-09 diana_coman: ftr re clock, my scripts don't bother with "end of task" - there's no end to anything, only start of next thing whether that's break or whatever; since time is spent anyway, the start of a new thing is by definition the end of the previous.
billymg: mp_en_viaje: yup, she put us in touch with american data which has been the best lead so far http://logs.ossasepia.com/log/trilema-hanbot/2020-03-03#1001505
ossabot: (trilema-hanbot) 2020-03-03 billymg: http://logs.ossasepia.com/log/trilema-hanbot/2020-02-08#1001053 << update: my girl has been corresponding with american data through this contact and they are now putting together a proposal for a supposedly dedicated 10/10 connection at $150 a month (proposal will be to determine cost/timeline of install)
mp_en_viaje: a cool.
mp_en_viaje: dude that's cheap.
billymg: yeah, compared to the ~$375 / mo for Kolbi's enterprise fiber offering it seemed like a good deal
mp_en_viaje: they dug fiber where you are ?!
billymg: they are willing to put together a proposal for doing so
billymg: (i need to get on my lawyer here about filling out the RFP)
billymg: so will be at my expense. whaack talked to one of their customer support agents who didn't really know what it would cost but thought roughly $2-5k for the laying of the cable
billymg: i then followed up with one of their technicians who visited the property and he said it was doable and we just need to go through the RFP / proposal process
mp_en_viaje: from experience the best way these things go is if a large-ish group of landowners around a geographically reasonable node point ask them for it. maybe see if your neighbours wanna join ?
mp_en_viaje: in fact optic fiber infrastructure does help land value.
billymg: http://logs.ossasepia.com/log/trilema/2020-03-10#1959266 << this is how i saw it as well
ossabot: Logged on 2020-03-10 12:40:11 mp_en_viaje: in fact optic fiber infrastructure does help land value.
billymg: http://logs.ossasepia.com/log/trilema/2020-03-10#1959265 << that's a good idea, and gives me a chance to meet the neighbors
ossabot: Logged on 2020-03-10 12:39:58 mp_en_viaje: from experience the best way these things go is if a large-ish group of landowners around a geographically reasonable node point ask them for it. maybe see if your neighbours wanna join ?
mp_en_viaje: so you got a perfect in, don't even need whaack 's proverbial gift basket. just go knocking on doors explain what you're tying to do, organize a fiber club
billymg: sounds like a plan
mp_en_viaje: internet is shockingly crappy in everman's costa rica ; especially after muh infinitybw euro interfaces.
billymg wonders if it would be rude to present this ask to neighbors on first introduction..
billymg: though it's almost more of an offer than an ask..
mp_en_viaje: if you get it going, can defo be on your sale list. "none of those crappy 5kbps netlinks, we here have fiber. come do some work undisturbed while the sluts splash in the pool", sell to execs.
mp_en_viaje: billymg, i don't get it, what are you asking ?
billymg: their support / commitment to subscribe to fiber (the collecting signatures bit)
mp_en_viaje: that can be follow-up. "hi, i got this property right next to yours, and we're thinking of pushing the x to draw optic fiber close. would this be something you'd like to get into ?"
mp_en_viaje: you're doing them a fucking favour, wtf.
billymg: http://logs.ossasepia.com/log/trilema/2020-03-10#1959276 << this for sure. almost lost business of a tour group that wanted to book all the units for two weeks in late march because no decent internet (ended up losing the business because zomg coronavirus instead)
ossabot: Logged on 2020-03-10 12:44:07 mp_en_viaje: if you get it going, can defo be on your sale list. "none of those crappy 5kbps netlinks, we here have fiber. come do some work undisturbed while the sluts splash in the pool", sell to execs.
mp_en_viaje: "even if you don't personally use the internet, it's like having electricity. you can go a whole life without electricity too! but from experience, a) you won't once it's there ; and moreover b) if you ever sell, it sells for more."
mp_en_viaje: find out what sorta troglodytes you livr with in any case, ie whether they'll shoot any roamning dogs for instance.
mp_en_viaje: billymg, fucktards, how the fuck are they getting coronavirus in nicoya, from what, the cows ?
billymg: this group was hilariously, offensively ustardian
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020423 << let's not get silly, since when is approximate spelling a virtue!
ossabot: (ossasepia) 2020-03-09 diana_coman: jfw: the minds that discard the message because of less than perfect spelling though might be better off enjoying their fence.
billymg: their first request was, get this, empty the pool because we don't want the risk of the kids (college) drowning
billymg: to which i said fuck off, and they then said, find just dun let em swim
mp_en_viaje: is this an older female "running" things ?
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020424 << i dunno how much you recall of the 90s, ie back when mailing lists was a thing ; but almost nobody will even read some agitated flailing of some dude who subbed to post it.
ossabot: (ossasepia) 2020-03-09 dorion: jfw you subscribe to it first so you can then reply ? is that how it works ?
billymg: probably, i'm interfacing through a nice and capable tico who's been organizing these groups of americans and doing business with this property / previous owner for years now
mp_en_viaje: mailing lists are very primitive wot things.
diana_coman: mp_en_viaje: eh, read the whole, approx spelling is not a virtue, no; neither is a disqualifier esp online
mp_en_viaje: billymg, ah. so build your backchannel with him. "wtf is this about, can you explain it to me ? i spend money to build pool so they have fun, they want it epty ?!"
mp_en_viaje: have people explain things to do, it's a great tool.
billymg: mp_en_viaje: not to mention, empty pool == break neck on fall
mp_en_viaje: diana_coman, i kinda think it is. typos aside, but anyways.
billymg: it made no sense to me
mp_en_viaje: billymg, if the concept is "drunk kid wanders in at night", which is what seems the least-dumb construction available, it's still indeed the case empty pool more dangerous.
billymg: mp_en_viaje: yeah, the conversation with the tico was productive, he was also throwing up his hands in disbelief at their request. i coached him into telling them to walk after realizing they really have no other options (other hotels aren't gonna empty pools / don't have lifeguards on duty, and tour group dun have the budget themselves to hire the lifeguard)
billymg: he said he's never heard of this before, in his years of organizing these visits. but it was some "new policy" to "eliminate risk"
mp_en_viaje: so hacve them explain it.
mp_en_viaje: dumb cows sitting on their cheesy taco all day long coming up with "standards"
billymg: mp_en_viaje: yeah, we had them explain it. and it was just: need lifeguard on duty or else no swimming. didn't press them enough re: dangers of empty pool because by then they had backed down
mp_en_viaje: aha
mp_en_viaje: i wonder when they're gonna start pestering bars, "we want to come and spittle in a beerbotle for three hours, but you gotta have driver."
mp_en_viaje: "bitch, you want ME to designate your driver for you ?" "yes, we're really awkward."
mp_en_viaje: da fuck tour group dun have their own lifeguard.
billymg: that's what i was telling the local: they are making demands without willing to pay. if they want lifeguard on duty they'll be at a luxury resort paying 5x
billymg: without being*
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020467 << apache probably.
ossabot: (ossasepia) 2020-03-09 jfw: My plan is to start next week with creating a 'gypsy code signing' key then I suppose get the list together and into some kind of order.
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020476 << this is quite how this is intended to work. havign a "use" and a "read" key perfectly sensible
ossabot: (ossasepia) 2020-03-09 jfw: I think it's the right sort of bother: given all the code I ~have~ read or written it seems an important distinction as far as which category someone chooses to trust from me.
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020491 << iirc it was unrelated, dudes were just squatting the place with their spaghetti-crapola.
ossabot: (ossasepia) 2020-03-09 jfw: ah there was also Eucrypt, part of which was a liberation of gcrypt from Werner Koch & co. right?
mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020492 << two things. in the positive, the sort of non-improvements like "supporting unicode" ; discussion with such a moron recently in trilema. in the negative, actually adding useful things that the pantsuit do not add, for whatever reason ("other priorities", "hateful to protected groups", "illegal", whatever nonsense).
ossabot: (ossasepia) 2020-03-09 BingoBoingo: jfw dorion: What does it mean that these things have been liberated? What have they been saved from?
mp_en_viaje: they're liberated from having Brawndo poured on top "because it's what plants need", and they're also liberated from NOT having water poured on top, because "the secretary of energy" ahs "never seen no plants grow out of no toilet."
mp_en_viaje is pondering this wonder. wtf are you idiots doing over there ? srsly tryina come up with all this shit on your own, who knows, maybe it works, maybe it doesn't, then i go read it on qntra and what, maybe i agree, maybe i don't, in any case ~after the fact~, at which point as chance dictates, either i sever the link or not ?
mp_en_viaje: pretty fucking weird.
mp_en_viaje leaves off reading #ossasepia ; i guess in principle there's nothing all that wrong with it.
mp_en_viaje: diana_coman, i guess you're stuck with a much larger chunk than originally contemplated, unexpectedly enough.
mp_en_viaje: on the other hand, it doth offer quite the neat solution to the "wtf are you going to do with that lordship thing THIS time" conundrum.
mp_en_viaje shall bbl.
jfw: mp_en_viaje: does the idiot list include me this time? I could try to be more mindful of when a discussion should be moved or started here
jfw: http://logs.ossasepia.com/log/trilema/2020-03-10#1959234 - this is approximately what it does; the delta is that a bit more than just txids is required.
ossabot: Logged on 2020-03-10 12:26:36 mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959219 << the functioning i'm looking for is that given some inputs (such as a privkey and txids) your program spits out a tx as is broadcast on the network.
diana_coman: http://logs.ossasepia.com/log/trilema/2020-03-10#1959326 - for a moment I thought this was re the graphics work, keks.
ossabot: Logged on 2020-03-10 13:23:21 mp_en_viaje: diana_coman, i guess you're stuck with a much larger chunk than originally contemplated, unexpectedly enough.
jfw: As best I could determine for my spec, this is an unavoidable consequence of the design of bitcoin transactions. Specifically what's required: address (as an identifier for the private key from a set of multiple; if you just have one then of course this is trivial); txid, output index within that tx, and value,
jfw: for each previous output being spent.
diana_coman: mp_en_viaje: to my mind there wasn't anything new/unknown/controversial in there really; (or I'd have moved it to #t earlier anyway).
diana_coman will bbl too
jfw: The function of the 'online' code I referenced is to index this information and get it in the required format; you could instead use block explorers or whatever you please to get the information and it's none of my business. Or I could provide it, since you gave the address.
jfw: The consequences of its being incorrect are mostly that the tx won't validate - EXCEPT (I recently realized) for the value field, which could be used to subvert the fee and change computation.
jfw: As for the private key, since as I understand you want to spend from an existing one imported from some other wallet implementation, I should note that it can be imported in hex or WIF format, however, as in TRB, "compressed" keys aren't presently distinguished. It's possible to use them through some code tweaks, though it's presently all one or all the other.
jfw: mp_en_viaje: is that all clear?
jfw: **The consequences if it were incorrect are mostly that the tx wouldn't validate ...
dorion: http://logs.ossasepia.com/log/trilema/2020-03-10#1959292 - I don't recall for not having been there, but makes sense they operate with a wot.
ossabot: Logged on 2020-03-10 12:50:01 mp_en_viaje: http://logs.ossasepia.com/log/ossasepia/2020-03-09#1020424 << i dunno how much you recall of the 90s, ie back when mailing lists was a thing ; but almost nobody will even read some agitated flailing of some dude who subbed to post it.
dorion: hey trinque, minding the previous point and earlier point and questions, why don't we set a time to discuss where you're at and what the next steps are ?
ossabot: Logged on 2020-03-10 13:12:20 mp_en_viaje: is pondering this wonder. wtf are you idiots doing over there ? srsly tryina come up with all this shit on your own, who knows, maybe it works, maybe it doesn't, then i go read it on qntra and what, maybe i agree, maybe i don't, in any case ~after the fact~, at which point as chance dictates, either i sever the link or not ?
ossabot: Logged on 2020-03-02 09:13:50 mp_en_viaje: trinque, the problem with your proposal is that the article isn't yet loaded at that point.
ossabot: Logged on 2020-03-03 00:22:13 dorion: http://logs.ossasepia.com/log/trilema/2020-03-01#1958692 - you had said the next would how V enters the picture. Is that still the plan ? did you expand and roll the spec you had in mind in there ?
lobbes: http://logs.ericbenevides.com/log/trilema/2020-03-10#1959236 << I have the actual bot working, yes. However I do not any type of trustworthy process to backfill the historical logs. I mean, I *do* have my python mess from last time, but I'm proposing we forgo that mess this time
ericbot: Logged on 2020-03-10 15:18:55 mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959221 << well, do you have the item currently working somewhere ?
ossabot: Logged on 2020-03-09 22:57:28 lobbes: mp_en_viaje: In preparation of our next attempt at getting this project done, I've been going through my faff-fest from last time.. and trying to figure out how we should pick back up
ericbot: Logged on 2019-12-04 04:37:32 mircea_popescu: lobbes wtf dude, you set ALL of these to 2019-12-03 22:03:06 time ?! didn't we go through an entire discussion of how it should increase monotonically ? gah.
lobbes: To lay it out, my convoluted process last time of getting you the data you needed was: 1) Pulling logs from my Postgres database to a flatfile 2) importing that into mp-wp's MySQL database 3) getting a mysql dump of *that* 4) altering said dump with e.g. sed escapes, etc. then finally 5) I give it to you
ericbot: Logged on 2019-12-02 16:41:29 mircea_popescu: ima try putting the first few in and we see (i hope for eg you do the sed 's%"%\\"%g' | sed 's%*%\&ast;%g' escapings, yes ?)
lobbes: Instead, I figure why don't I just cut out 2,3,4,5 and instead I just alter my 1) to pull logs from my Postgres database in the same format of your input into your backfill process (which has already been proven to function to spec)?
lobbes: http://logs.ericbenevides.com/log/trilema/2020-03-10#1959239 << Okay. I'm about to run out for a quick errand but will be back in about an hour. I'll be free now for the rest of night afterwards
ericbot: Logged on 2020-03-10 15:20:02 mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-09#1959225 << well, afternoon is what i had in mind, but yes, sure.
ossabot: Logged on 2020-03-09 22:57:45 lobbes: Also, are you good for tomorrow night or were you looking for doing this during the day? I'm slaving in the mines tomorrow but my night is clear. If need be I may be able to weasel a work-from-home day though, so I'll check back when I wake up tomorrow
lobbes: s/free now/free
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-10#1959329 << mindful nothing. look, if it works work it, there's nothing wrong with that.
ossabot: Logged on 2020-03-10 13:38:48 jfw: mp_en_viaje: does the idiot list include me this time? I could try to be more mindful of when a discussion should be moved or started here
mp_en_viaje: there ~is~ of course substantial cost involved in i dunno, keeping a capitalized company on the books while alf derps about re-doing the same mistakes on the chickenfeed he's found in his couch cushions. there's similarily a substantial cost involved in maintaining all these trilema herramientas
mp_en_viaje: this is of course my problem ; you can do it elsewhere cheaper / better / whatever, i'm the last dood to get in the way of any such a thing.
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-10#1959341 << really, there's no value in this prequel. we sit down thurs see.
ossabot: Logged on 2020-03-10 14:02:20 jfw: mp_en_viaje: is that all clear?
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-10#1959336 << i dunno, all i saw was BingoBoingo continuing the tradition of derp whereby he's gonna ad-hoc some nonsense. at least he's moved on from doing it in gpgballs.
ossabot: Logged on 2020-03-10 13:51:09 diana_coman: mp_en_viaje: to my mind there wasn't anything new/unknown/controversial in there really; (or I'd have moved it to #t earlier anyway).
mp_en_viaje: lobbes, so you want a sample of the logstory file ? lesee here
lobbes: mp_en_viaje, yeah that'd be great. Ty!
mp_en_viaje: lobbes, im digging through the stuff here, because i suspect there might;ve been more to it all than just that, so a sec
mp_en_viaje: lobbes, so listen, you talking about this discussion http://trilema.com/2019/introducing-the-logs/#comment-132410 ?
lobbes: mp_en_viaje, yeah that was the discussion. I think the script that ended up working for you was in this comment
mp_en_viaje: but the point is : the whole logstory thing was simply me wranglin gwith the xchat historical format most of the early logs were in.
mp_en_viaje: there's entirely no point in reproducing that.
lobbes: mp_en_viaje, ahh okay.
mp_en_viaje: now, what you really want is a look at say log8.txt, which is what in the end was finally used,
mp_en_viaje: no ?
lobbes: mp_en_viaje, hm, I can't find a reference to a log8.txt in that discussion, but if that was what you used for your input file then yeah definitely I'd want to see that
mp_en_viaje: http://trilema.com/2019/introducing-the-logs/#comment-132537 < reference
mp_en_viaje: the ~problem~ is though that these are 1-logday-per-line humongo files. can you even meaningfully process it ?
lobbes: mp_en_viaje, ah I see what you mean. Yeah I guess that may be a bit of a pain trying to produce something in that format. Hm
mp_en_viaje: lobbes, http://trilema.com/wp-content/uploads/2019/11/ << item's always been avaialble there, since nov. logs8.txt say
lobbes: mp_en_viaje, ah ty
mp_en_viaje: i for one'd have expected the structural definition in the comments'd be more useful than the actual dump file ; but in any case, there's more problems even higher up.
mp_en_viaje: specifically, until we have the process such that the bot actually produces logs, reliably, for each day, it makes 0 sense imo to even start this discussion. because what, so we do it YEY AGAIN, and then there's yet another gap once we're done ?
lobbes: mp_en_viaje, this is a point. You mean we ought to just get the bot up and producing logs first and worry about the history later?
mp_en_viaje: omfg, the coffee in this country. idiot germans come in and buy all the best sorts anyone can be arsed to sell them ; then you go to germany and can't have a decent cup of coffee. i just can't set it down.
mp_en_viaje: lobbes, it seems unavoidable, otherwise we'll just be doing this chasing gaps forver, like achilles.
mp_en_viaje: what's the bot called, anyways ?
lobbes: mp_en_viaje, agreed (btw if I ever do make it to CR real coffee will be one of the first things I try)
lobbes: mp_en_viaje, pizdi
mp_en_viaje: it's not in chan ?
lobbes: I could bring it in now even, it just is logging to my test site
mp_en_viaje: oh i see. so yeah, bring it in
lobbes: k
lobbes: !!up pizdi
deedbot: pizdi voiced for 30 minutes.
lobbes: command is '!y' for the time-being
lobbes: !y version
pizdi: lobbes: I am MP-WP bot version 598170.
lobbes: currently logging to: http://test.ericbenevides.com/2020/03/forum-logs-for-10-mar-2020/
mp_en_viaje: quite the number
mp_en_viaje: lobbes, did you do a buncha testing on this then ? all sorta lines, changes in say topic, etc ?
lobbes: I just incremented the old one from the stanlogger
lobbes: mp_en_viaje: I don't think it'll record line changes. Though I honestly did not test if it would break it
mp_en_viaje: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
lobbes: *record topic changes
mp_en_viaje: ----- 20:00 ----- << oh it's still doing that thing, iirc we wanted it out eventually.
lobbes: ah shit, I must've missed that. Well easy enough to remove in any case
mp_en_viaje: honestly, the stuff pizdi's dumping in the test blog is perfectly fine. why can't you just dump the missing logs into her ?
lobbes: that's what I tried to do last time; ended up faffing about. I'm a little hesitant to try again but I guess I'll need to at some point
mp_en_viaje re-reads the init of this convo to figure out wth the problem was
lobbes: it seemed simple: instead of eating IRC lines live just eat lines from Postgres. But you know, looking back I used way too many middleman steps
mp_en_viaje: http://logs.ossasepia.com/log/trilema/2020-03-10#1959355 << but the format i use is as you can see, mysql insert statements, one line per day.
ossabot: Logged on 2020-03-10 19:08:58 lobbes: Instead, I figure why don't I just cut out 2,3,4,5 and instead I just alter my 1) to pull logs from my Postgres database in the same format of your input into your backfill process (which has already been proven to function to spec)?
lobbes: yeah, I was misunderstanding your process there
mp_en_viaje: now that said, i'm still thinking about how the fuck to get mp-wp working on two machines best.
mp_en_viaje: technically there exists mysql "federated" tables ; but everyone seems to hate them. prolly for no reason.
mp_en_viaje: on the other hand there exists the obvious "have logs category on trilema.net, have trilema.net use trilema.com for everything (including comment post say). which is about as derpy as it sounds.
mp_en_viaje: there could be a sync script, but then how often does it run
lobbes: hm, I am not familiar with federated tables myself. I'd need to look into them a bit.
lobbes: as for the sync script, yeah that would be interesting. As for the frequency does mysql do triggers on database changes?
mp_en_viaje: honestly i think what i'll go for will be : (using trilema.com for current trilema and trilema.net for pizdi's box), hve a mysql server run on both, have t.com update both rather than just its own, and have it read the day's logs at some point tomorrow. this way people can use t.net for any purpose except write a comment.
lobbes: makes sense.
mp_en_viaje: perhaps easier said than done ; but we see
lobbes: mp_en_viaje: okay, sounds like a plan then. So, I guess for my part I'll go back and see what I can do about a sane history-backfill process.
mp_en_viaje: yeh.
lobbes: k. And I guess just let me know whenever / however you wanna try to get that t.com > t.net update process going. I'll try to find time where needed
lobbes: http://logs.ericbenevides.com/log/trilema/2020-03-11#1959403 << as an aside for log posterity, I mis-stated this: the version number represents the block height at the time of the vpatch
ericbot: Logged on 2020-03-11 01:03:20 lobbes: I just incremented the old one from the stanlogger
mp_en_viaje: lobbes, get the history in, complete from http://trilema.com/2019/forum-logs-for-27-mar-2016 onwards first, then we sort the rest out.
lobbes: mp_en_viaje, roger that

Random(trilema) | Download hourly DB snapshot | Get Source Code