mircea_popescu: heh.
mircea_popescu: trinque re http://logs.minigame.bz/2017-04-06.log.html#t00:05:55 any eta on the thing ?
mircea_popescu: i ~utterly hate~ having to tell noobs that.
mircea_popescu: in other lulz, https://www.youtube.com/watch?v=9X-cP7lPNPI
asciilifeform: wassat
mircea_popescu: (ro poliwhore (romanians send the http://btcbase.org/log/2017-04-04#1637413 to politics, as opposed to runt of sons litter) reading english in rwandan at un meeting)☝︎
a111: Logged on 2017-04-04 22:32 mircea_popescu: think in terms of that cartoon re final cs class at stanford : "and you are the idiots who didn't get hired in 2nd or 3rd year". same deal, whoring is a fine plan for cut-above-rest 16yo. by the time she's 30 she's either married or too rich to care.
mircea_popescu: asciilifeform here's a thought : some ssh rsa keys appear on VERY MANY different C (and B, and A) ip blocks. like say randomly http://phuctor.nosuchlabs.com/gpgkey/BB80CEE8E532296E5361984A0209C5DE0169809EA68E6D2F8DE43F7A3DC4443A and friends.
mircea_popescu: this'd be a fine indication of infection/nsaization/extremely sloppy opsec corp/whatever.
mircea_popescu: may be worth digging into
asciilifeform: mircea_popescu: they're all, so far, examples of http://www.loper-os.org/?p=1733
asciilifeform: ( identifiable embedded crapola )
asciilifeform: tropos, huawei, hiveap, a few others.
mircea_popescu: using the same ssh key ?!
asciilifeform: there's at least 1 that actually copied the key aha
mircea_popescu: this is prolly worth of a qntra or something. who the fuck copies ssh keys across the field.
asciilifeform: also lol!! >>
asciilifeform: check this out.
mircea_popescu: ffs.,
asciilifeform: btw,
asciilifeform: admin / admin
asciilifeform: logs in.
mircea_popescu: ah looks like tiny powerplant, maybe solar on someone's house ?
asciilifeform: 'These settings should only be adjusted by a licensed solar professional'
asciilifeform: lol
asciilifeform: poor idiots
mircea_popescu: "Use Enlighten or contact Enphase Energy customer support for a profile change token Serial number: 110939095462 Authorization number: 95477310"
mircea_popescu: genius.
phf: asciilifeform: do you have a set of high dpi (150/200) bitmap fonts for x11 that you use by any chance?
mircea_popescu: so if i change the settings now re eg voltage ima start a battery fire.
asciilifeform: mircea_popescu: you can -- it looks -like -- switch'em all off ,at least.
mircea_popescu: anyway. the new password is now phuctor.
asciilifeform: if you felt like.
asciilifeform: lol!
mircea_popescu: let 'em learn by typing.
asciilifeform: !$ ssh
scriba: ssh banner of as seen on 2016-06-13: SSH-2.0-OpenSSH_5.1p1 Debian-5
asciilifeform: aaaaha.
CompanionCube: I would say 'what if the owner finds out'...but since they left it at admin/admin...
mircea_popescu: CompanionCube the owner should find out.
shinohai: (- ___ -)
CompanionCube: mircea_popescu: so you're planning to turn the batteries of or something then
asciilifeform: tomorrow's noose: 'nadia henninger and hanno boeck rescue ten thousand insecure solar...'
mircea_popescu: nope.
mircea_popescu: asciilifeform hey, it was published in the princeton review!!1
asciilifeform: princetonischer beobachter.
CompanionCube wonders how they would find out. It's not like they'd *notice* a changed password
mircea_popescu: hey, ineptitude is not an excuse from duty. they shouyld find out.
mircea_popescu: not like it's not published.
phf: CompanionCube: they will most likely go and change something 10 months from now, then will spend couple of days searching for "that paper with password"
asciilifeform: i once changed a neighbour's router admin pw to 'pigfucker'
phf: *try and change
asciilifeform: 7 yrs and he never knew.
asciilifeform: never reset it..
mircea_popescu: "it just works"
asciilifeform: on the day i moved away -- it worked still.
asciilifeform: phf: pw is usually trivially reset, with a button. which is why the humane thing to do is to wipe his firmware.
asciilifeform: and when unit is replaced, wipe it again. until learns.
asciilifeform: but who the hell has the patience for this.
CompanionCube: also, shitty web UIs generally do not have that option.
asciilifeform: << even buggier
mircea_popescu: asciilifeform if the item is anything like empire made, the reset button is up on the roof shimmied next to the chimney
asciilifeform: mircea_popescu: actually there's a bunch of similar boxes near where i live
asciilifeform: they are usually close to the electric meter.
mircea_popescu: so basically, the idea here is "enphase energy" simply stamps the same (broken!) ssh key on all its boxes ?
asciilifeform: << univ. of chicago ip range.
asciilifeform: mircea_popescu: seems like it.
asciilifeform: and default www creds.
asciilifeform: mircea_popescu: this find is yours, qntra it if you feel like
asciilifeform: System has been live since Wed May 30, 2012 08:47 AM CDT Currently 0 W Today 14.6 kWh Past Week 63.0 kWh Since Installation 169 MWh
asciilifeform: ^ above. notbad.
asciilifeform: 'Device Conditions and Controls' shows 126 ! sub-boxes.
asciilifeform: apparently you can slave them.
asciilifeform: << view all.
asciilifeform: looks like we just made henninger a tenured prof
asciilifeform: and boeck, a герой советского союза or sumthing.
asciilifeform: incidentally this find can also be used to demonstrate the massive -ev of solar scamola.
asciilifeform: ( compare 169MWh over 5 yrs, cost from ordinary grid, to whatever 126 of these things cost... )
asciilifeform: this is data you couldn't beat out the vendor with any sized stick.
shinohai reset all their DNS servers to google's
asciilifeform: *out of the
asciilifeform: shinohai: waste of time
shinohai: meant "resets"
asciilifeform: not all have default creds. ( , does not )
mircea_popescu: asciilifeform eh, hardly much of a find.
mircea_popescu: i just linked a link from phuctor stats page.
asciilifeform: it's a find. betcha the earlier link is whole uni. of chicago solar scamatron.
asciilifeform: and betcha it cost'em millions in payola.
mircea_popescu: prolly.
asciilifeform: some of it maybe even went to obummer himself.
asciilifeform: (whoknows)
mircea_popescu: well, "cost them". obama gave them 48 mn or some shit, of which they kept 3, the obama-contractor kept 11, the obama-producer kept 16, and the end result was 100ish MW (wthose thigs aren't accurate) over 5 years ie about 5 grand worth of "Clean" power.
mircea_popescu: except it produced so much solid waste it'll take a few GW to clean up to some storable state.
asciilifeform: well yes.
asciilifeform: ( and we had a thread re cost of refining si, etc )
mircea_popescu: http://trilema.com/2016/heres-where-you-forget-about-wind-power-as-an-alternative-source-of-power/ in picrelated.
asciilifeform: ^ that's for when we find the windmill ssh key...
asciilifeform: http://wotpaste.cascadianhacker.com/pastes/c09Lh/?raw=true << convenient list.
asciilifeform: ^ all Framedragger-scan ips having this modulus.
asciilifeform: << also uni of c.
asciilifeform: buncha these.
asciilifeform: ^ 92 (!) subunits.
asciilifeform: if mircea_popescu dun feel like qntra -- BingoBoingo , then ?
asciilifeform: solar3.uchicago.edu << lol!!
mircea_popescu just chopped up a coupla vanilla beans to sit in rum for eventual rompope
mircea_popescu: BingoBoingo shinohai whover's awake.
asciilifeform: the lifetime wattage statistic is what really melts asciilifeform's brain
asciilifeform: we now have solid proof that the thing is -- beyond any possible doubt -- minus-ev
mircea_popescu: for srs. this is actual data, as opposed to the bs that someone publishes.
asciilifeform: oh mircea_popescu will like this:
asciilifeform: https://archive.is/6xYvj
asciilifeform: worx great
asciilifeform: anybody wanna submit whole list ?
asciilifeform: who is a top perlist
asciilifeform: mod6 ?
asciilifeform: ( dun need login !! to work )
asciilifeform: they ALL expose wattage, plain.
asciilifeform: lists : when installed, how many kW/h now, how many -- lifetime.
asciilifeform: and how many panels.
asciilifeform: (4th line in table.)
asciilifeform: from this , and with a bit of legwork, could find out how much chump -- and u.s. treasury -- paid for this nonsense.
asciilifeform: simply submit http://IP_ADDRESS/home?locale=en for ea.
mircea_popescu: "chump". it's all paid by unfunded future payments which ain't fucking happening.
asciilifeform: the chumper pays upfront, iirc 1/4 of cost.
mircea_popescu: asciilifeform working on list.
asciilifeform: aite.
asciilifeform: oh and betcha they all have debianized ssh ~login~ keys also.
mircea_popescu: asciilifeform only 28 items on your pastebin, was supposed to bne more ?
asciilifeform: 28 for this mod.
asciilifeform: is all.
asciilifeform: but these oughta be trivial to scan for, they load plain http wherever exposed on the next.
asciilifeform: *net
asciilifeform: if all you want is wattage stats.
asciilifeform: https://www.google.com/search?q="Number+of+Microinverters+Online"&source=lnt&tbs=li:1&sa=X << moar.
asciilifeform: a decent botnet could probably find all of them.
asciilifeform: that currently exist.
asciilifeform: or at least such that were plugged into external ip (why?! -- i have nfi)
hanbot: http://btcbase.org/log/2017-04-06#1638497 << hahahaha. i can imagine w/e princeton folks flipping out between this (if reading logs, and/or chicago cronies panic at them) and the earlier email☝︎
a111: Logged on 2017-04-06 00:26 mircea_popescu: anyway. the new password is now phuctor.
asciilifeform: http://www.pjm.com/about-pjm/learning-center/price-ticker.aspx << prices of megawatt-hour in different regions of usa.
asciilifeform: baltimore : 26 $.
mircea_popescu: sounds about right
CompanionCube: wait, you changed the password on multiple ones?
asciilifeform: shows when installed panels.
mircea_popescu: nope.
asciilifeform: apr 26, 2011
mircea_popescu: asciilifeform interestingly some don't respond.
asciilifeform: 79.8 MWh produced since !!!
asciilifeform: mircea_popescu: some probably dead. or -- most likely -- dynamic ip
mircea_popescu: yeah.
asciilifeform: a fresh scan will find'em.
mircea_popescu: i dunno we care enough to actually bother. will see what this list tallies up to.
asciilifeform: 80 MW/h is fiddybux!!
asciilifeform: can you picture what 90 panels cost?
asciilifeform: in 2011.
mircea_popescu: certainly much more valid survey than what the pantsuit tribe customarily passes for "research"
mircea_popescu: asciilifeform i can't imagine anyone paid for this.
asciilifeform: the inverters ain't cheap, either.
mircea_popescu: tax breaks.
asciilifeform: 'anyone'
asciilifeform: i can't speak re serious inner-party (above box is 1 of the 3 uni of chicago found so far) but for proles, house owner is expected to front 1/4 - 1/2 of the cost.
asciilifeform: the rest, yes, taxbreak.
mircea_popescu: hanbot lulz.
asciilifeform: mircea_popescu -- maybe worth a trilema piece ?
mircea_popescu: yeah ima write it.
mircea_popescu: pretty lulzy.
asciilifeform: if you're archiving, archive the http://IP_ADDR/inventory?locale=en also -- it has the panel install dates.
mircea_popescu: i am.
asciilifeform: neato.
asciilifeform awaits the delectable butthurts
asciilifeform: http://btcbase.org/log/2017-04-06#1638494 << not one, phf☝︎
a111: Logged on 2017-04-06 00:25 phf: asciilifeform: do you have a set of high dpi (150/200) bitmap fonts for x11 that you use by any chance?
asciilifeform: i wish !!
asciilifeform: phf: do you ?
asciilifeform: meanwhile, on the ethertard planet : https://archive.is/0Ypri
phf: i think i'm going to not do computers anymore. i'm done.
asciilifeform: finally landed that coveted lighthouse keeper job phf ?
phf: i'm going to become this guy instead http://farm6.staticflickr.com/5292/5561497850_c1f42f470a.jpg
doppler: sign me up too
mod6: <+asciilifeform> mod6 ? << need some perl? <+mircea_popescu> asciilifeform working on list. << looks like mp is on it.
mircea_popescu: i am ya
mod6: werd
asciilifeform: 'I regret to announce as cofounder of Matchpool that I am leaving this project. I was involved in architecting Matchpool, writing the white paper and writing the first draft of the smart contracts. I was not involved in the implementation of the ICO. I have asked internally what is going on with the funds you sent to Matchpool, but have not received a satisfactory answer....
asciilifeform: Over the last two days 37500 ETH has been withdrawn from the multisig wallet by the CEO, Yonatan Ben Shimon without any explanation or announcement due to the need for "hedging". Yonatan keeps claiming he's working with Bitcoin Suisse and it's all okay, but so far I haven't seen any evidence of this. I suggest you all demand an explanation and keep a close watch. In all likelihood your guppies are worthless- the terms and conditions
asciilifeform: seem deliberately designed to prevent contributors having legal recourse in the case of misuse of your money. In either event, I believe the standards of transparency and integrity in this organization are well below what is needed for a blockchain project, which is why I can no longer a part of it.'
asciilifeform: ^ pasted for tehl0gz.
asciilifeform had never heard of this particular set of heathens prior, but it is lulzy.
asciilifeform: what, for instance, were 'guppies' ?
asciilifeform brb, pet
shinohai: Guppies are food for the sharks yo!
BingoBoingo: <asciilifeform> if mircea_popescu dun feel like qntra -- BingoBoingo , then ? << I can/will qntra, but in the future when you are lulzing about the details of a thing and are unsure if editor is awake/digging-liming holes/trying to get older sober lady to 13th step him, maybe consider writing a qntra while you have and are playing with the details? Makes for more timely publication when editor is awake? Publication can happen faster when
BingoBoingo: editor is verifying details in submission lulzed at in logs than when reconstructing them...
mircea_popescu: give it a moment.
BingoBoingo: cool
shinohai was awake, but is rather unsure about Qntra submissions of late
BingoBoingo: <mircea_popescu> anyway, no explaining, ridiculous move. << perhaps move to lure pantsuits into self hanging? Either that or clog fake news circuit.
BingoBoingo: With media favorite Katie Stewart out of whiteouse and fundraising, media has to eat intrigue actually generated by Trump
BingoBoingo: In other news, Trumpreich endorsed by King of Jordan.
deedbot: http://qntra.net/2017/04/trump-annouces-end-to-hussein-bahamas-era-policy-of-announcing-military-plans-months-in-advance/ << Qntra - Trump Annouces End To Hussein Bahamas Era Policy Of Announcing Military Plans Months In Advance
mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
BingoBoingo: In still further lulz, professionally black people criticize black people of Ferguson https://archive.is/yqwEV
asciilifeform: mircea_popescu: http://btcbase.org/log/2017-04-06#1638665 >>> http://btcbase.org/log/2017-04-06#1638599☝︎☝︎
a111: Logged on 2017-04-06 02:27 mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
a111: Logged on 2017-04-06 01:13 asciilifeform: https://www.google.com/search?q="Number+of+Microinverters+Online"&source=lnt&tbs=li:1&sa=X << moar.
mircea_popescu: ridoinculous.
mircea_popescu: well my stab at it is published.
mircea_popescu: ample room for more people to dig more lulz if so inclined.
asciilifeform: no mention of how most of'em belong to uni of chicago
asciilifeform: put footnote ?
asciilifeform: imho it is a deep lol
BingoBoingo: Or comment...
mircea_popescu: comment worx
shinohai: BingoBoingo: http://wotpaste.cascadianhacker.com/pastes/k35HX/?raw=true (Actually I do have a lulzy Qntra for this evening)
BingoBoingo: Sometimes when you lol at a deeptail, it is easiest to write up the lollercoaster yourself.
asciilifeform: BingoBoingo: writing is hardwork!
mircea_popescu has revised some numbers, it turns out microinverters are generally about 200W rather than the more kw style stuff he remembered from youth
BingoBoingo: Loading bricks is hard work. Writing is disciplined work.
asciilifeform: also http://trilema.com/2017/the-incidental-humiliation-of-obamas-clean-energy-policies-marc-andreessens-internet-of-farts-and-other-such-comedic-gold-bricks/#comment-121750
asciilifeform: mircea_popescu: these are per-panel
asciilifeform: so 200W is correct
asciilifeform: (generally biggest you can buy is 200)
mircea_popescu: apparently 180 to 220W is 90% of the market.
mircea_popescu: anyway, so 200W unit produced 731 Wh/day on 5year average
deedbot: http://qntra.net/2017/04/prudes-attack-pence-security-detail/ << Qntra - Prudes Attack Pence Security Detail
BingoBoingo: fxd
trinque: "though no word was available as to whether the agent and his female companion explored a full range of disciplinary actions on their own before the tryst was interrupted." << top kek
asciilifeform: mircea_popescu: 731 Wh is approx enough to run.. a pogo.
deedbot: http://trilema.com/2017/the-incidental-humiliation-of-obamas-clean-energy-policies-marc-andreessens-internet-of-farts-and-other-such-comedic-gold-bricks/ << Trilema - The incidental humiliation of Obama's "clean energy" policies ; Marc Andreessen's Internet of Farts and other such comedic gold bricks.
asciilifeform: for 24h.
shinohai: !~tyvm
jhvh1: shinohai: Error: "tyvm" is not a valid command.
shinohai: D:
BingoBoingo: ty shinohai
shinohai: !~ty
jhvh1: You are very welcome Daddy
shinohai: and u BingoBoingo
BingoBoingo did add not on Pence's own prudishness
asciilifeform: mircea_popescu: phun phakt, solar cells quickly disappear under grime, dead leaves, bird shit, unless regularly cleaned (~nobody cleans.)
asciilifeform: typical american residential roof is not 'user friendly', not flat.
mircea_popescu: aha
mircea_popescu: also added some clarification footnotes etc.
asciilifeform: thing is apparently ~exactly~ like led light bulb.
asciilifeform threw out 7th one this year, not long ago.
mircea_popescu: phf asciilifeform to make you both feel better : sat i'm going to a "russian rock concert" at this massage parlour slash blinyi restaurant run by a buncha russian chicks.
asciilifeform: lol!
shinohai hopes mircea_popescu 's Russian chicks aren't anti-semitic
mircea_popescu: why ? i'm no joo.
shinohai: They might read trilema, see mircea_popescu in earlier days with joofro and start pogrom
asciilifeform: also http://trilema.com/2017/the-incidental-humiliation-of-obamas-clean-energy-policies-marc-andreessens-internet-of-farts-and-other-such-comedic-gold-bricks/#comment-121751
mircea_popescu: lel
mircea_popescu: asciilifeform answer't.
mircea_popescu: http://trilema.com/wp-content/uploads/2017/04/solar-lulz.txt << this is the dump
asciilifeform: aah neato
mircea_popescu: only 660 or so mIs, say about half mil total worth or so
mircea_popescu: mebbe a whole mil.
asciilifeform: betcha so much as the installation of a new ~table leg~ at, e.g., univ. of chicago, costs moar than that.
asciilifeform: (and they have, what, 400 of the panels)
asciilifeform: in other lulz, gzipped (individually) blox 0 ... 459205 take up:
asciilifeform: 82G .
shinohai: trb blocks, now individually wrapped for your convenience.
asciilifeform: that's 11 double-sided dvd.
mircea_popescu: hefty
asciilifeform: not so hefty.
mircea_popescu: let's argue about it!
asciilifeform: lel
asciilifeform: about 1 $ worth of pressed disk, is the point.
shinohai: or 8200 5.25 floppies
shinohai: *3.5
asciilifeform: 59710578 .
asciilifeform: you misplaced some zeroes somewhere, shinohai .
asciilifeform: or nm, 58311.
asciilifeform: at any rate, it'd cost same to press these as to press typical bloatmonster game
asciilifeform: or winblowz 'msdn' collection.
mircea_popescu: i've not yet had an 11 dvd game.
asciilifeform: mircea_popescu: one of the flying sims i leeched on warez , for winblows box, was 40G or so
mircea_popescu: prolly lotta maps.
asciilifeform: so the day of 11 disk game, has probably come some time ago
asciilifeform: maps, textures, aha
asciilifeform: also betcha that when compressed ~properly~ (i.e. as asciilifeform described 2wks ago) it'll be not even 40G.
asciilifeform: (replace sha256 hashes with indices on disk, for instance; record 'sequence number' in tx only if differs from default; ditto locktime)
asciilifeform: possibly will fit on 1 dvd, then.
asciilifeform: while remaining properly unzippable to classical form.
asciilifeform: (i.e. it is legitimately isomorphic to the traditional form, there is nothing 'lossy' about this 'compressor')
asciilifeform: gzip gives us ~20% shrink btw.
asciilifeform: and that is ~per block~, rather than collectively
Framedragger: http://trilema.com/2017/the-incidental-humiliation-of-obamas-clean-energy-policies-marc-andreessens-internet-of-farts-and-other-such-comedic-gold-bricks/ << amazing morning megalol
Framedragger: http://btcbase.org/log/2017-04-06#1638486 << lol #2☝︎
a111: Logged on 2017-04-06 00:23 asciilifeform: admin / admin
Framedragger: that didn't work till i read that the password is now phuctor. omg lmao
Framedragger: > Today 14.6 kWh Past Week 63.0 kWh
Framedragger: very energy
Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
Framedragger: (in compsci no less)
Framedragger: sent query to n-gate (in the sense of reducing meaning to a tweet and pretending that's communication)
Framedragger: !!up DaSancho
deedbot: DaSancho voiced for 30 minutes.
Framedragger: DaSancho: what brings ye here?
Framedragger: http://btcbase.org/log/2017-03-29#1634033 << that's all i have: http://imgur.com/a/SPFBI (stuff that was stickied on the parcel). i had unfortunately thrown out the 'postcard' from royal mail, but it was a single slip which literally only said "we can't post you this because this got held up. go online and put in a reference number". the latter opened a "PAY NOW" form, and that's it.☝︎
a111: Logged on 2017-03-29 16:25 mircea_popescu: if you find it within yoruself to post forms you were issued that'd be grand.
Framedragger: (again, i may have gotten more info by physically presenting myself at a particular delivery office, showing ID and so on, but i wasn't up for that.)
Framedragger: (i do believe this is a simple instance of VAT being charged for overseas 'valuable imports', but then this never happened before when shipping via legal retailers etc.)
Framedragger: rehosted here: http://fd.mkj.lt/stuff/import-1.jpg && http://fd.mkj.lt/stuff/import-2.jpg
deedbot: http://phuctor.nosuchlabs.com/gpgkey/1B1B58577EC085775FD320B460F7C3DC6B08E6FFB2EBE04B7A162C5F609F0E9D << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to ' (ssh-rsa key from (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/D33126663C8161A8EF4DCCEAA5321D0CBF95441A3D35C0BAC2BAF6D2F4397C40 << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to ' (ssh-rsa key from (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/71AF9594F2393F6AB85B14C1C615C449E8833966B1FA30A198C98FC36750B4C5 << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to ' (ssh-rsa key from (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/1B1B58577EC085775FD320B460F7C3DC6B08E6FFB2EBE04B7A162C5F609F0E9D << Recent Phuctorings. - Phuctored: 1120...4129 divides RSA Moduli belonging to ' (ssh-rsa key from (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
mircea_popescu: dat day when ben_vulpes 's pastatron allocates you UriNe as an identifier...
mircea_popescu: holy shit they got some kefir in this country that'll melt your heart.
mircea_popescu: http://btcbase.org/log/2017-04-06#1638757 << awww.☝︎
a111: Logged on 2017-04-06 10:05 Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
mircea_popescu: now tell me she wouldn't be happier as a declared slave for a republican lord ; rather than a doublespoken slave for nobody-in-particular in the stupid empire.
mircea_popescu: i teach some basic mechanical engineering to ~all~ my girls. just because i can.
Framedragger: she had a particular unpleasant unhappy look so yeah i think i agree lol
Framedragger: "this is not my kind of place" "what am i doing with my life" "also i can't answer these questions"
mircea_popescu: whoa, so they want VAT, AND a "royal mail intl handling fee" that's 10 bux.
mircea_popescu: incredible. this is even legal ?
Framedragger: admin fee for collecting the customs fee and mediating between customer and her majesty's revenue and customs. very legit
mircea_popescu: "queries should be sent to the address above, where you will helpfully be informed they can not say anything else besides reading this notice to you."
Framedragger: i dunno. re. VAT from overseas, yeah it's 'teh law', but yknow.
Framedragger: that is exactly what it means mircea_popescu lol
mircea_popescu: a sad little country.
mircea_popescu: does that stamp say "redeliver on MUM" ?
Framedragger: at least the currency will inflate now so that they can export ugly girls cheaper
mircea_popescu: i don't think i ever saw anyone pay for a brit.
mircea_popescu: even at a time people couldn't be arsed to ~physically inspect~ russkis anymore, just paid for the cargo whole.
Framedragger: mircea_popescu: ahahahaha it does say "MUM" (should be "Mon" of course)
mircea_popescu: Framedragger maybe they're serious, and intend to redeliver on your mum!!11
Framedragger: :o
mircea_popescu: aaaanyway
mircea_popescu: http://btcbase.org/log/2017-04-06#1638766 <<< i expect the legal retailers have the common decency to ship from jurisdictions where there's some kind of vat countermeasure in place.☝︎
a111: Logged on 2017-04-06 11:28 Framedragger: (i do believe this is a simple instance of VAT being charged for overseas 'valuable imports', but then this never happened before when shipping via legal retailers etc.)
mircea_popescu: let's drive alfie up the wall a little
mircea_popescu: asciilifeform https://www.google.com/search?q=phuctor&channel=fs&tbas=0&tbs=qdr:m&* << notice anything missing ?
Framedragger: heh. well http://nosuchlabs.com/robots.txt does have "Disallow: /gpgkey/" but phuctor.nosuchlabs.com itself should still be indexed i think?
mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
Framedragger: ah, hrm.
mircea_popescu: and the root is not NOVEL.
mircea_popescu: it's indexed alright but not in the past month
mircea_popescu: now if someone were to make static multipage stats...
Framedragger: hrm. :) what's the cheapest way to do it.. automate a long-timeout-and-also-retry downloader for /stats and then just re-host the cached downloaded copy? any use in that?
mircea_popescu: lel. the cheapest is for the site to support it natively!
Framedragger: notes! support!
mircea_popescu: just got a 504 timeout on long term browser lel
mircea_popescu: thing is, it doesnt' crash, it always comes up but you gotta know to retry.
Framedragger: yeah.
asciilifeform: http://btcbase.org/log/2017-04-06#1638798 << aha☝︎
a111: Logged on 2017-04-06 12:29 mircea_popescu: asciilifeform https://www.google.com/search?q=phuctor&channel=fs&tbas=0&tbs=qdr:m&* << notice anything missing ?
asciilifeform: http://btcbase.org/log/2017-04-06#1638799 << i put this in ~year ago, noticed that ~nobody respects 'robots.txt', and promptly forgot about it...☝︎
a111: Logged on 2017-04-06 12:32 Framedragger: heh. well http://nosuchlabs.com/robots.txt does have "Disallow: /gpgkey/" but phuctor.nosuchlabs.com itself should still be indexed i think?
asciilifeform: http://btcbase.org/log/2017-04-06#1638800 << entirely possible☝︎
a111: Logged on 2017-04-06 12:33 mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
mircea_popescu: prolly should take it out.
asciilifeform: yeah
asciilifeform: http://btcbase.org/log/2017-04-06#1638806 << whole thing needs rewrite; we had the thread.☝︎
a111: Logged on 2017-04-06 12:43 mircea_popescu: lel. the cheapest is for the site to support it natively!
asciilifeform: ( it is not, however, obvious to asciilifeform ~how~ . so not yet rewrote. )
mircea_popescu: ima publish a snapshot on trilema, for nao.
mircea_popescu: ease some of teh pressure i'm guessing ?
asciilifeform: sure why not
asciilifeform: there's one on my www also
asciilifeform: (from a few mo ago)
asciilifeform: http://btcbase.org/log/2017-04-06#1638757 << why does mechanical engineer get fed java ?☝︎
a111: Logged on 2017-04-06 10:05 Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
mircea_popescu: anyone got an idea as to how i turn
mircea_popescu: <tr><td> (ssh-rsa key from (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) &lt;sshscan-queries+;; </td></tr>
Framedragger: 'MEng' is just diploma title, you get master of engineering for software engineering, too (because reasons)
mircea_popescu: into a more reasonable (ssh-rsa key from 13-14 June 2016 extraction) ?
asciilifeform: mircea_popescu: yes, 1s
mircea_popescu: shave like a megabyte off this turd
Framedragger: yes in retrospect i did not expect for there to be so many pops lol.
Framedragger: result is large turd
Framedragger: asciilifeform: MEng here means 'master of engineering' (which can include software engineering, yesyes), not mech
asciilifeform: http://btcbase.org/log/2016-12-08#1579779 << mircea_popescu☝︎
a111: Logged on 2016-12-08 15:43 asciilifeform: e.g., for ip in `curl -s http://phuctor.nosuchlabs.com/phuctored | grep "ssh-rsa key from" | cut -d' ' -f23 | sort | uniq`; do ...something with $ip..... done
mircea_popescu: asciilifeform i want the whole tabke is the issue.
asciilifeform: what means 'whole table'
asciilifeform: modulus ?
mircea_popescu: i am taking the entire table as found on stats page and putting it on trilema.
mircea_popescu: whole table. html tags and all.
mircea_popescu: i just made the urls absolute
asciilifeform: why not just include the html you get from the above curl ?
mircea_popescu: because it'd exclude non ssh keys for instance.
asciilifeform: http://www.loper-os.org/pub/snap/ph_snap.html << example
asciilifeform: aaah
mircea_popescu: whole table. see ?
asciilifeform: want a csv ?
mircea_popescu: nope. ideally i just want to... copy... teh table :D
mircea_popescu: now, how do i tell awk to turn the blather quoted above into the intended result ? hm ? HM ?
Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/
asciilifeform: neato Framedragger
asciilifeform: does it mirror the sub-pages also ?
Framedragger: i sed'ed the relative urls, as in "<a href="/">Submit GPG Key</a>", to point them to phuctor, etc
Framedragger: not yet!
mircea_popescu: /phuctored would be good.
Framedragger: yah.
asciilifeform: aseriousgogetta (~Kimberley@ip-64-134-144-245.public.wayport.net) has joined #trilema << hey mircea_popescu , can haz hammer ? every time that monkey's connection cycles, i feel like a chimp is throwing shit in my face
Framedragger: mircea_popescu: if you're planning to rehost, maybe useful (very simplistic, i've just put this into cron for now): http://siphnos.mkj.lt/phuctor-stats/download-stats.sh
asciilifeform: Framedragger: i think he wants ~only~ the ssh keys
Framedragger: ah right right, ok
mircea_popescu: what ?
mircea_popescu: no i don't. i want... omfg 4th time.. THE WHOLE TABLE
asciilifeform: ah so just lift the html you get from /phuctored . problem solved ?
asciilifeform: what's missing ?
mircea_popescu: consider the string : "hurr\n1-1-1-1\ndurr\n2-2-2-2\nfoo54-54-54-54". the job is to turn it into "hurr\n1\ndurr\n2\nfoo\n54"
mircea_popescu: now then.
mircea_popescu: asciilifeform it's not missing, it has an extra 1 megabyte of Framedragger 's hello world
asciilifeform: aaaaaah
mircea_popescu: (which is very good and useful as it is, not the problem there. but gotta fix it here)
Framedragger: http://btcbase.org/log/2016-12-25#1590428☝︎
a111: Logged on 2016-12-25 16:02 phf: http://btcbase.org/log/2016-12-25#1590416 << http://www.youtube.com/watch?v=lIpev8JXJHQ&t=0m53s
asciilifeform: meanwhile, in monkeystan, https://archive.is/z8x2c >> 'You don't handle sarin-saturated bodies *without gloves* - unless you're a Syrian rebel trying to pull off yet another hoax.'
asciilifeform: all the while, mr.t read official speech 'i changed my mind...' etc, is poised to fight the clitler wars.
mircea_popescu: changed what mind ?
asciilifeform: e.g. https://archive.is/V5zbs
asciilifeform: 'These heinous actions by the Assad regime cannot be tolerated' etc.
mircea_popescu: heh.
mircea_popescu: well, old man lasted almost half a year.
asciilifeform: mircea_popescu finally cured of 'maga' ?
mircea_popescu: ahem ?
asciilifeform: well of 'apparatchiks won't pay their mortgages', 'berkeley starves', etc
mircea_popescu: ah, no.
mircea_popescu: that's not something i, or anyone else, can be "cured" of.
Framedragger: http://btcbase.org/log/2017-04-06#1638854 << k found time to improve this, /phuctored is now being hosted/cached as well (and link to /phuctored on the index stats page links to the cached version)☝︎
a111: Logged on 2017-04-06 13:28 Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/
Framedragger: will keep an eye on this in case the hasty cron job screws up at some point.
Framedragger: i guess it could host /sadmods and /dupes as well - attempt redownload every few hours? (it will only update the linked cached html in case new download is in fact successful)
Framedragger: !#s tmsr wiki
a111: 7 results for "tmsr wiki", http://btcbase.org/log-search?q=tmsr%20wiki
mircea_popescu: aaaand in other lulz...trilema can't actually hold a 3mb data dumb.
Framedragger: mircea_popescu: you're putting it in mysql aren't you, and making php generate a table or sth?
mircea_popescu: yep.
Framedragger: maybe just some shitty limit in webserver/php/wherever, modifiable
shinohai: Heh, shocking move: http://archive.is/ZMfJe
shinohai: I too can pun arstechnica
Framedragger: so on account of that n-gate guy being reachable via twitter only, and me not wanting to miss any replies, i've actually had to visit twitter lately. my homepage now is http://imgur.com/a/aTcpY and fuck this shit
phf: "i'm what's known as `twitter funny`. -- what does that mean? -- not funny"
mircea_popescu: Framedragger mught as well tell him where to show up an' thassat.
Framedragger: i did! i managed to compliment him, direct him to #trilema, and (hopefully) not appear as an idiot in one tweet
mircea_popescu is undeterred, created sql file, is importing it, which apparently takes A WHILE
mircea_popescu is steeling self for discovering mysql dosn't allow over x bytes in any one column or such closely managed nonsense
Framedragger: what's the column data type mircea_popescu
mircea_popescu: lel apparently i crashed the db.
mircea_popescu: nice.
Framedragger: apparently mysql recommends storing large data/text blobs in separate table
trinque: ahaha
mircea_popescu: oy vey.
trinque: and good morning!
Framedragger: another pleasant morning of kicking DBs
mircea_popescu: # service mysql status
mircea_popescu: SUCCESS! MySQL running (2421)
mircea_popescu: hurr
mircea_popescu: o check it out, amanged to trash the articvles table!
shinohai: This is why shinohai decided that if were to update wp-mo, it would use plain txt files and completely burn mysql to the ground.
shinohai: *wp-mp
mircea_popescu: well apparently trilema's going to be offline for a while for reasons of unexpected explosion.
shinohai: Thanks Obama
mircea_popescu: in other lulz : mysql use db; results in... the process simply hanging. > 1 minue by now.
mircea_popescu: because why ? because OH MY FUCKING GOD SOMEONE RAN A 2MB SQL an hour ago!!1
Framedragger: hmh it should at least fail, or sth. is it still running mircea_popescu? can you do `show processlist` with separate mysql client session? (NB, am not a mysql guy)
mircea_popescu: it is still running.
Framedragger: there's a KILL QUERY
Framedragger: but mebbe you want to keep it running
mircea_popescu: there's a "repair by sorting" going and five billion agents waiting for metadata lock
mircea_popescu: which holy shit.
Framedragger: i wonder if it's due to data type misuse, or just mysqlol
mircea_popescu: why is there a metadata lock and how do i turn it off
Framedragger: oh god
trinque: mysql's kinda notorious for this shit
mircea_popescu: ERROR 1040 (HY000): Too many connections
mircea_popescu: apparently mysql will refuse CONNECTIONS FROM ROOT
mircea_popescu: on the basis of too many dorks hammering it on the www!
asciilifeform: woah
asciilifeform: welcome to sql hell mircea_popescu
asciilifeform has lived there for a while, knows where the good beaches and restaurants are.
mircea_popescu: o yeah ? how do you turn "metadatalock" off lelz.
trinque: the meat's all dancing cat
mircea_popescu: turns out this whole "read while dirty" thing is "implemented" except notrly.
asciilifeform: mircea_popescu: you don't , http://btcbase.org/log/2016-12-30#1593662☝︎
a111: Logged on 2016-12-30 17:16 mircea_popescu: it really should be up to operator wtf, if i want to read dirty let me read dirty what sort of decision is this for designer to make.
mircea_popescu: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mircea_popescu: # service mysql status
mircea_popescu: ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
asciilifeform: i suffered with this on postgres, and continue to.
mircea_popescu: so i take it it croaked.
asciilifeform: and looks like you gotta rm the lock file.
Framedragger: do you still have a running mysql cli session mircea_popescu?
Framedragger: i guess it's dead-dead, tho
mircea_popescu: yes.
mircea_popescu: no it's fine, trying to figure out how to rescue the table.
Framedragger: there are ways to list/remove locks but i reeeeally dunno if it's a good idea
Framedragger: ftr, useful SO answer (yes, SO): http://stackoverflow.com/a/13155778
mircea_popescu: table isn't innodb.
Framedragger: just curious, what is it then, myisam?
mircea_popescu: yes
mircea_popescu: insanely, i am still getting a lot of www requests, so i guess i incidentally found some other issue here as well.
asciilifeform: lol, hey, nobody told the crawlers that the box is down
mircea_popescu: but the box doesn't deliver, theoretically, anything but a text line now
Framedragger: mircea_popescu: well you can still kill the particular mysql process which is handling the query, `show processlist` (may show "Waiting for table metadata lock" under "State" column; "Info" column should display the query in question), then `Kill IDGOESHERE`
mircea_popescu: why'd i want to kill 150 processes by hand. let them timeout.
Framedragger: (then `FLUSH TABLES` should remove any outstanding locks if still any; but don't take my word for it)
mircea_popescu: so far the table is crashed, and the repair thing seems to take forever.
Framedragger: 150? no just the one which is still trying to import large blob (if still running)
Framedragger: ok ugh.
mircea_popescu: Framedragger you trying to tell me that process'd have somehow survived a mysql restart ?
Framedragger: mircea_popescu: sorry i forgot or didn't know that you actually in fact restarted it.
mircea_popescu: but no, they';re all selects.
mircea_popescu: weirdly enough, also not timing out. how the fuck long can a thing waiot for a lock ?
Framedragger: (aok. oh well then, light cigar while making DB destruction plans)
mircea_popescu: i can't comprehend what'd possibly take this long to repair it.
lobbes: Testing minigame.bz log quoting: http://logs.minigame.bz/2017-04-06.log.html#t00:05:55
lobbesbot: Logged on 2017-04-06 00:05:55: <mircea_popescu> until trinque's deedbot payment is on i dunno what lightweight to recommend you
lobbes: Odd it didn't quote earlier
Framedragger: nice
lobbes: Mp must've been faster than it inserted into database
mircea_popescu: hm ?
Framedragger: asciilifeform: phuctor.nosuchlabs.com timing out, do you think this could be related to the cron cacher? (GET /stats every 5min, GET /phuctored every 60min)
lobbes: mircea_popescu: Nah nothing really. I noticed you pasted that link earlier but bot didn't quote. I think you were just too fast for it
asciilifeform: Framedragger: it dun load no moar...
asciilifeform: and i have no means for discovering why
lobbes: Or rather, my process too slow heh
mircea_popescu: lel.
asciilifeform: Framedragger: i recommend to turn off the hammerer.
Framedragger: okay :D
Framedragger: done
asciilifeform: i will remind everyone that http://btcbase.org/log/2017-02-19#1615434 .☝︎
a111: Logged on 2017-02-19 03:54 asciilifeform: (iirc we had a thread where i described how corporate ameritards, if given a problem like phuctor, would happily soak up a few $mil and megawatt of iron)
asciilifeform: thing runs on the very edge of the possible.
asciilifeform: the 'database' is an evil concept.
mircea_popescu: if only. 99% of db is crud and causing the problem.
mircea_popescu: entirely not fucking iron-bound problem in trilema case for instance. wtf can "repair table" need >1200 s !
asciilifeform: that's what 'db' is, a massive pile of shit that pretends to be 'one size fits all' data structure
Framedragger: anyway http://siphnos.mkj.lt/phuctor-stats/ will continue to rehost phuctor stats (including http://siphnos.mkj.lt/phuctor-stats/phuctored.html), and will see about more lenient update times (5min is excessive anyway)
mircea_popescu: and i am STILL, somehow, getting fucking agent loads.
mircea_popescu: "every thing you do will resolve 99% of the problem at the most". always a little bit left. gah.
Framedragger: maybe it's going thru full mysql tx log if you have one
mircea_popescu: eh what tx. this is mysql.
Framedragger: in mysql it's called 'binary log'. dunno if on by default tho
mircea_popescu: load average: 0.01, 0.05, 0.21 <<< meanwhile i am... waiting... for it to... repair.
mircea_popescu: how. the fuck. is this supposed to be sane
mircea_popescu: 0 indication of what this is. will it take another 6 weeks ? "maybe". how do i tell ? what do i do ?
mircea_popescu: fucking bs.
Framedragger: i'm waiting for the day that freenode goes down while datacenters with logotrons are experiencing issues. everyone's gonna freak out, there will be a new more urgent push for gossipd, it's gonna be great!
asciilifeform: Framedragger: for some reason i am reminded of a cartoon i saw when i was very small, incidentally iirc it was made in some baltic country, where an eagle decides that frog is his son and threatens constantly to 'teach him to fly' by throwing from a cliff
Framedragger: heh :) pretty soviet
phf: it's pretty tmsr too. "if it can't fly, it doesn't deserve to live anyway"
mircea_popescu: meh. in which we find trilema's posts data is 40g somehow.
mircea_popescu: how the fuck ?!
asciilifeform: mircea_popescu: i seem to recall ~200MB last time you tallied it and posted here (6 mo ago ?)
mircea_popescu: just about.
mircea_popescu: 40439263232 Apr 6 11:12 tril_posts.MYD
asciilifeform: that's several lifetimes worth of text, even if it consists of 1MB pastes...
asciilifeform: something is off
mircea_popescu: i have nfi.
mircea_popescu: but mah disk is also full nao.
mircea_popescu: last i saw MySQL Disk Space 596.29 MB, so evidently mysql "repair table" corrupted the table to shit.
mircea_popescu: 39491524 /var/lib/mysql/trilema_blog/tril_posts.MYD << reported by du | 40439263232 Apr 6 11:12 tril_posts.MYD << reported by ls -l
mircea_popescu: im guessing this disk is fucked ?
asciilifeform: du -h
asciilifeform: 39491524*512 == 20219660288 however
asciilifeform: what's your sector size, mircea_popescu ?
mircea_popescu: 38G
asciilifeform: looks like 1024 :
mircea_popescu: ah
asciilifeform: 39491524*1024 == 40439320576
asciilifeform: still not == 40439263232 tho, lol
mircea_popescu: myeah.
asciilifeform: (that du does not default to -h is one of the titanic retardations of the standard userland)
mircea_popescu: well, ima reboot the machine.
asciilifeform: (who the FUCK cares how many sectors!! something uses)
phf: i usually pipe du through sort or awk >n. i kind of wish there was an "h" command instead that would take a column number an humanize that column
asciilifeform: phf: ANYTHING defaulting to martian rather than human units, is unspeakable braindamage
asciilifeform: just ditch the martian units.
asciilifeform: if i want them, i can... divide the byte counts.
hanbot: !~ticker
jhvh1: hanbot: Bitfinex BTCUSD ticker | Best bid: 1174.7, Best ask: 1174.8, Bid-ask spread: 0.10000, Last trade: 1174.7, 24 hour volume: 29477.80773128, 24 hour low: 1120.3, 24 hour high: 1179.3, 24 hour vwap: None
BingoBoingo: <mircea_popescu> incredible. this is even legal ? << O hai I R the packet interceptor. Pls to pay again for delivery.
mircea_popescu: sooo... i have 1.6 tb available du shows 38g.
mircea_popescu: this is like the day of lulz.
asciilifeform: what's the disjunction here ?
asciilifeform: du shows occupied space, not free
Framedragger: (mk /stats now updated every 30min, will see how that one goes. http://siphnos.mkj.lt/ updated to include link to the cached copy. will see if this gets indexed by google (main index page already is)) :)
asciilifeform: in other lulz from upstack : Enphase Energy, Inc. (NASDAQ:ENPH) .
asciilifeform: didjaknow.
mircea_popescu: yeah.
mircea_popescu: anyway, turns out the myslq files are stored on a tiny partition for some incomprehensible reason. fancy that wonder.
asciilifeform: ( aug. 3, 2016 : 'Enphase entered into a $25 million loan agreement with a lender specializing in "rescue financing" that furnishes capital "to avoid a restructuring or insolvency.'"' )
mircea_popescu: heh
asciilifeform: ( their spamola : https://archive.is/UjMhq << for expert entomologists only )
shinohai: "Enphase's storage technology is optimal for the masses." <<< Indeed!
Framedragger: mebbe you had a separate /var partition from linux install long ago, mircea_popescu.. this can bite
mircea_popescu: Framedragger for some reason root gets 50G and mysql for everything is stored in there.
mircea_popescu: i still have nfi elephantiazis hit that poor file that it ended up 40g, but anyway, im moving the whole shebang on a tb partition and will see wtf myisamchk does.
mircea_popescu: a superficial cat | strings | grep yielded a bunch of old stuff so it doesn't appear dataloss is guaranteed.
Framedragger: well the default for DBs is to store things under /var. /var is under root unless specifically separate partition; or you tell db to store under /home/mircea/dbdata or sth.
mircea_popescu: yes, i'm aware. now.
Framedragger: not a boring day!
mircea_popescu: my first time using any of these shits. prior to this morning i had nfi what /var/lib/mysql/ is or how you repair crashed mysql db or anything of the sort.
mircea_popescu: this is also the first time a mysql db crashed in my personal experience.
asciilifeform: i recall, we had a thread where mircea_popescu: 'it never once crashed'
mircea_popescu: well now ++
scriba: Restarting for new command
mircea_popescu: in fairness it's entirely my fault, i got bored with sql import and interrupted it. didn't work so well seeing how it was a write op.
asciilifeform: fwiw since phuctor went form sqlite to postgres, i have not yet managed to crash the latter
Framedragger: !$ phuctor
scriba: Phuctor - main site: http://phuctor.nosuchlabs.com/ ; stats: http://siphnos.mkj.lt/phuctor-stats/ (cached) / http://phuctor.nosuchlabs.com/ (main source) ; ssh scanner - data: http://siphnos.mkj.lt/datadrop/
asciilifeform: (though to grind it to an ~unusable halt, for a long time -- is quite easy)
Framedragger: ^ new (trivial) command. a bunch of URLs so may be useful
asciilifeform: neato Framedragger
Framedragger: pete_dushenski: plox to update bot commands at some point, ty! :)
asciilifeform: *went from
Framedragger: asciilifeform: i also wonder if phuctor site my come under additional stress now that you removed those 'Disallow' entries from robots.txt :/
mircea_popescu: guaranteed.
asciilifeform: Framedragger: theoretically
mircea_popescu: google will definitely slurp 5mn pages in the next week-ish
asciilifeform: mircea_popescu: the odd thing is, it did anyway -- until somewhat recently
mircea_popescu: you (all of you, really) are very well linked since all the trilema mentions and etc. we've built like a coven
Framedragger: in which case, may not want to do that till caching is in place, or sth. main thing is to have stats be accessible which is now cached anyway
mircea_popescu: asciilifeform possibly those were just fake user agents ?
asciilifeform: mircea_popescu: and they also stole the ip range of google corp ?
mircea_popescu: a that no
mircea_popescu: but i get tons of idiots trying to you know, spam trilema claiming to be googlebot.
asciilifeform: these don't spam, no. they just crawl.
asciilifeform: the folx throwing random rubbish into the submit box, are actually quite uncommon.
asciilifeform: i suppose they can tell that there isn't actually a wordpress installed.
asciilifeform: ( once in a while some exceptionally poorly written spamatron shows up, which ~can't~ tell, on first try)
mircea_popescu: aaanyway, seems it's cooking with gas now. we'll see.
scriba: Restarting for URL fix
jhvh1: I, jhvh1, am a wrathful bot
mircea_popescu: lmao
trinque: aw fuck that's what I get for typing a privmsg by hand
asciilifeform: 'February 16, 2017 ... Enphase Energy, Inc. (ENPH), a global energy technology company, today announced that it has refinanced and extended its term loan facility with certain funds managed by Tennenbaum Capital Partners ("TCP") from $25 million to $50 million.'
asciilifeform: the miracle of printolade.
asciilifeform: hey shinohai et al : they have a twatter! https://twitter.com/enphase
shinohai will tweet them the trilema article along with tranny porn when trilema is back online ....
BingoBoingo: shinohai: Be classy, amputee midgets
shinohai: !~google amputee midgets
jhvh1: shinohai: ' amputee midgets ' Search - XVIDEOS.COM: <http://www.xvideos.com/%3Fk%3Damputee%2Bmidgets>; midget amputee super hot - YouTube: <https://www.youtube.com/watch%3Fv%3DhOfG1qUYadU>; Urban Dictionary: interracial midget amputee necro-bestiality: <http://www.urbandictionary.com/define.php%3Fterm%3Dinterracial%2520midget%2520amputee%2520necro-bestiality>
asciilifeform: https://archive.is/k58t9 >> gourmet liquishit, e.g., 'The energy tech company with 350 employees has reported annual losses every year since it went public in 2012, including nearly $67.5 million worth of red ink last year. Since September, it has gone through two rounds of layoffs and raised about $26 million by issuing new stock and bringing in two major investors. Enphase officials say with confidence that a turnaround is underway
asciilifeform: and the company is on track to make a profit in the second half of 2017. Its employees have worked to significantly cut the cost of producing its signature devices, microinverters that take DC, or direct current, power from solar panels and transform it into AC, or alternating current, power for homes.'
shinohai: Damn, first results XVIDEOS
asciilifeform: the way i currently understand the 'microinverter' nonsense, is that enphase found a further chineseification of the solar scamatron, by replacing the traditional massive dc-ac inverter with a multitude of small chinese turds, made for use in autos
asciilifeform: idea is that schmuck won't notice when they fail
mircea_popescu: asciilifeform obamafinance.
mircea_popescu: but yes, that's pretty much exactly it.
asciilifeform: pretty lulzy inversion of the usual corporate dynamic, where there are shareholders and they want growing profits; instead there is a printolade supplier, who wants manageable (or -- optimistically -- slowing!) bleed
asciilifeform: at no point, interestingly, is there much of any kind of pressure to make a widget that ~actually works~
asciilifeform: !!up gabriel_laddel_p
deedbot: gabriel_laddel_p voiced for 30 minutes.
gabriel_laddel_p: https://docs.google.com/document/d/1tQ8nHp2wWD-U4c7l8FbZgW3GJfhni78hDZJH4ihKSpI/edit?usp=sharing
gabriel_laddel_p: mircea_popescu: no wrap(80) for the archiver.
gabriel_laddel_p: if someone has a problem with it, speak now
gabriel_laddel_p: personally, I prefer the wrapping, but w/e
asciilifeform: whatever it is, why does it HAVE to live on liquishithost
asciilifeform: can haz human host ?
gabriel_laddel_p: asciilifeform: nope.
asciilifeform: wainot
gabriel_laddel_p: because I go broke ~every week at least?
asciilifeform: didn't somebody finally buy the gabriel_laddel_p box ..?
gabriel_laddel_p: asciilifeform: people have offered, but unless I physically own the boxes, I'm not interested
trinque: because you own your google cloud whatevers
Framedragger: or kiwiirc.com
CompanionCube has always preferred postgres to mysql
gabriel_laddel_p: Framedragger: trinque: I'm interested in ditching the web & eventually x86 as a whole, not somuch in sanitizing my crappy setup.
trinque: looks someday I'll take the longest bath anyone ever took.
asciilifeform: lol
gabriel_laddel_p: Oh, and the archiver will save both the text version & the previously posted rich webpage version with js, images & whatnot.
mircea_popescu: ftr Framedragger : type was longtext
asciilifeform: gabriel_laddel_p: where do you host this ? also google ?
gabriel_laddel_p: asciilifeform: SF. I have a Masamune that will sit on here as a bot, archive all links that show up & git push them to github.
Framedragger: mircea_popescu: hm.. okay. wonder why it failed. (i guess in the future consider LONGBLOB for this (and encode/decode as needed), but it wasn't..that large, even.. huh.)
mircea_popescu: aha
Framedragger: gabriel_laddel_p: ideally it would also save a full 'rich' version (whole DOM) but without JS, the way archive.is does
Framedragger: !#s dump dom
a111: 3 results for "dump dom", http://btcbase.org/log-search?q=dump%20dom
trinque: gabriel_laddel_p: why the FUCK would you spend any time whatsoever on doing it that way?
Framedragger bbl
ben_vulpes: buenos diiiiaaaaas
trinque: in this thread we listen to how gabriel_laddel_p is very special, and you don't understand me mom
gabriel_laddel_p: ben_vulpes: hello!
shinohai: buenas tardes ben_vulpes, listo para cojer putas?
trinque: and portage is seriously one coke bump from being ported to lisp.
ben_vulpes: siempre, shinohai
gabriel_laddel_p: Framedragger: I saw the discussion, and will not be doing a DOM dump because I'm not going to spend any time in the browser internals.
shinohai: :D
gabriel_laddel_p: Framedragger: and for future reference, I read all the logs, everytime.
gabriel_laddel_p: trinque: by you?
Framedragger: k.
gabriel_laddel_p: trinque: ported to lisp at what level? Could you please describe in more detail? Eg, is there a new ebuild format, do you interpret the old one, do you have lisp that translates shell scripts...
ben_vulpes: relevantly shinohai i was out at this performance of baroque french choral set, chamber music scale, and in between songs (which were very well done), there was much woke angsting about el pussy grabber in chief
trinque: fucks sake kid I'm mocking you
ben_vulpes could not refrain from grabbing the pussy with which he arrived
ben_vulpes: i think that i may have been one of like 3 straight doods in the room; high lez factor
asciilifeform: next day ben_vulpes went to a boar hunt, could not resist eating the bacon he brought in a bag himself...
trinque: whatever, gay guys will grab titties all the time
gabriel_laddel_p: trinque: oic. ftr I looked into doing this & decided against it.
ben_vulpes: asciilifeform: well hey the singer i went to see wasn't in stripper mode during the choral performance
shinohai: It's the sad part of enjoying any form of culture here too it seems, full of speshul snowflakes and sjw's
ben_vulpes: shinohai: ask them what they think about menstrual leave
ben_vulpes: feign total socialistoid embeddment
shinohai: I want time off for male menopause, like a sabbatical.
trinque: ben_vulpes: compulsory leave?
ben_vulpes: "so i'm all for maternity and paternity leave, i have kids, it's just fantastic. and i've been thinking about other things that people should get state-sponsored leave for, and like aren't some women struck by totally debilitating menses? they should totally have time off for that."
ben_vulpes: trinque: "TO THE BACK OF THE CARAVAN WITH YE"
trinque: weew
asciilifeform misread - 'male menses'
ben_vulpes: "but then from a justice perspective it's just inherently gender inequitable, so i don't know! i just don't know."
ben_vulpes: next to ubi menstrual leave is clear in the middle of the overton window.
mircea_popescu: !~ud ubi
jhvh1: mircea_popescu: Error: "ud" is not a valid command.
trinque: http://p.bvulpes.com/pastes/rTF18/?raw=true << in other "help you in my own way"
shinohai: toppest of keks
mircea_popescu has recovered his db, is now fighting with monstrous conspiracy that swears on all voices "no dude it's legit, 40gb!"
trinque: mircea_popescu: universal basic income
mircea_popescu: ah
ben_vulpes: everything must be free
CompanionCube: I don't think that's the idea of UBI
ben_vulpes: everything must be a pale simalacrum of something that existed as a real item at some point
asciilifeform: CompanionCube: http://btcbase.org/log/2017-03-24#1632313☝︎
a111: Logged on 2017-03-24 13:31 asciilifeform: Framedragger: aka landlord payola, lol
ben_vulpes: CompanionCube: just try it some day
asciilifeform: CompanionCube: and http://btcbase.org/log/2017-03-29#1634398 .☝︎
a111: Logged on 2017-03-29 21:56 asciilifeform: ( the other funny detail, it certainly ain't ~everyone~ who'd get payola. certainly not dirty kulaks. )
ben_vulpes: "you know i really like this ubi idea; imagine the cambrian explosion of art and culture that would happen if people didn't have to work to eat, right? well imagine if *everything* were free, not just food internet and housing. it's not like we need tax receipts to pay for it, just increase the national debt a little! i doubt it would even come close to the cost of an f35 to make everything free."
trinque: !~ticker
mircea_popescu: i thought it's obvious ubi is for the incompetent sluts that are "going to college" and the assorted ghetto scum "tryna make it in dis game"
jhvh1: trinque: Bitfinex BTCUSD ticker | Best bid: 1195.4, Best ask: 1195.5, Bid-ask spread: 0.10000, Last trade: 1195.4, 24 hour volume: 29527.58713279, 24 hour low: 1123.0, 24 hour high: 1197.0, 24 hour vwap: None
trinque: no, please do
ben_vulpes: ubi is a statal self-crit
ben_vulpes: i think it's awesome
ben_vulpes: also everything must be free
mircea_popescu: not really avoidable.
trinque 100% in favor of ben_vulpes' p-peddle to the metal m-morty approach to end of the state
ben_vulpes: trinque: w-what?! i just want to make life better for historically disadvantaged groups!
mircea_popescu: trinque i certainly don't see anything wrong with teaching the stupid how to be even stupider until the time they're actually ready to hands and knees.
shinohai: Turned !~ud bqck on mircea_popescu ... cheers!
mircea_popescu: a cool
mircea_popescu: !~ud woke whore
jhvh1: mircea_popescu: ERROR: 'woke whore' not defined on UrbanDictionary.
shinohai had forgotten it twas disabled
mircea_popescu: imagine.
shinohai: !~ud Lemon party
jhvh1: shinohai: Lemon party :: One of the unholy trinity of internet pictures which all must witness to be 'jaded internet users' (tubgirl, goatse, and lemonparty), lemonparty is probably the tamest of the three by just being hardcore old man gay orgy sex. Believe me, the other two are worse. [ex:] *upon seeing lemonparty* OH GOD MY EYES!!! [/ex] | Closly related to the infamous "[tubgirl]" site. If one goes to (6 more messages)
ben_vulpes: what lemon party is jading now?
ben_vulpes: how are sarin death videos not in that list
asciilifeform: !~ud haskell
jhvh1: asciilifeform: haskell :: 1 -- A general purpose, polymorphicly typed, lazy functional programming language largely based on lambda calculus. 2 -- A constant source of frustration for those who have been brainwashed by the OO paradigm. [ex:] You: How do I write a 'while' loop with Haskell?Me: You can't, freshman. [/ex] | A town in Northern New Jerse located between Ringwood and Pompton Lakes, smaller district of (5 more messages)
ben_vulpes: whatever, thanks urban pricktionary
asciilifeform: damn, i was quite certain i recalled it read 'sad coke hell'
ben_vulpes: someone got butthurt no doubt
mircea_popescu: what's the while loop to do with the "oo paradigm" ?
ben_vulpes: not an erudite enough critique
mircea_popescu: !~ud obama
jhvh1: mircea_popescu: obama :: The Messiah for brain-dead Democrats. [ex:] No matter what he says, no matter what he does, they'll worship the great Obama. [/ex] | An acronym standing for One BigAss Mistake,America! [ex:] Q: What was the result of the 2008 election?A: OBAMA [/ex] | Has no real experience, because most of his time as "senator" was spent campaigning for his own election to President. Is praised (10 more messages)
mircea_popescu: !~ud trump
jhvh1: mircea_popescu: trump :: 1. To have superior power over.2. To surpass or outdo.3. When a person says "trump," you are required to do whatever you just claimed you would do, no matter how exaggerated it was. If you don't do it, you get a [spartan kick] to the chest. [ex:] 1. Bob: The president's word trumps yours, Joe, you homeless piece of shit. When he says something it must be done.2. Joe: Man, I'll trump your ass (5 more messages)
mircea_popescu: !~ud bannon
jhvh1: mircea_popescu: bannon :: When a person or animal gets high on a substance, often in unexpected places. This usually ends in chaos for everyone. [ex:] At school all my friends bannoned on sharpies. [/ex]
asciilifeform: lol!!
mircea_popescu: this is remarkably better than wikipedia.
shinohai: "obama :: The Messiah for brain-dead Democrats. " <<< Accurate
asciilifeform: in other noose, phuctor stats now ~unloadable
asciilifeform: the rewrite might have to happen sooner rather than later.
mircea_popescu: any ideas on probing and cutting large files ? dd freezes.
asciilifeform: 'ddrescue'
mircea_popescu: i dun have it ;/
asciilifeform: (or 'dd_rescue', they are -- perversely -- separate proggies by separate people, that do ~same thing )
mircea_popescu: neither\
asciilifeform: it is similar to dd but will show progress, and retry bad reads/writes (showing you if your drive is hosed)
mircea_popescu: i guess i'm naive to imagine standard tools can do the job of fixing the mess standard tools created huh
asciilifeform: mircea_popescu: if you want 'what box came with', that means standard retarded unixland
asciilifeform: and aha, mno.
mircea_popescu: what i want is non-freezing tools.
mircea_popescu: i dunno why this is such a tall order.
asciilifeform: because unix.
asciilifeform: it doesn't even have a concept of sane process interruption + resumption.
asciilifeform: can stop literally anywhere.
asciilifeform: (nor of sanely organized state)
mircea_popescu: head doesn't work on a large file.
mircea_popescu: explain this to me. however long it may be, IT STILL STARTS IN THE SAME PLACE.
mircea_popescu: head must takle THE SAME TIME whether reading 1kb or 1pb file.
asciilifeform: worx fine on 100+GB file here.
mircea_popescu: i am plagued by cursed bs.
asciilifeform: sounds like rotting disk
mircea_popescu: i checked it and it's fine
asciilifeform: ( any signs thereof in, e.g., dmesg ? )
mircea_popescu: nope
mircea_popescu: 0 bad sectors also. smart looks good, whatever.
mircea_popescu: copied multiple 100s of gb past hours, none failed anything.
asciilifeform: if this is anything like past cases, mircea_popescu's box is peculiar in some way literally nobody else could possibly guess
asciilifeform: and this caused it.
mircea_popescu: i suppose.
mircea_popescu: anyway, im dumping teh table as a sql and will be wanting to hack it up. but i have no tools with which to identify the CUT HERE spot
asciilifeform: also mircea_popescu how didja know that 'dd hanged' rather than merely taking long time
mircea_popescu: there is no "taking long time"
asciilifeform: 100G of dd takes ~hour here
mircea_popescu: if it took longer than my refresh interval it hung.
mircea_popescu: and in other lulz : apparently tail -n+x | head -n10 takes 4 times less than tail -nx+1 | head -n10
CompanionCube: also, modern dd also has progress reporting
CompanionCube: when using status=progress
mircea_popescu: is 8.4 modern ?
CompanionCube: Doubt it, considering my gentoo is on 8.25
mircea_popescu: 111119289 tril_posts.sql << that took ~5 minutes of wc time.
CompanionCube: mircea_popescu: it seems the feature was introduced in this release: https://git.savannah.gnu.org/cgit/coreutils.git/tree/NEWS#n355
CompanionCube: 8.24
mircea_popescu: apparently if you send it usr1 sig it will spit stats to stderr
Framedragger: http://btcbase.org/log/2017-04-06#1639243 << this doesn't seem right. `tail` should work fine, too (it seeks to end of file and then rewinds, should be superfast on arbitrary sized files)☝︎
a111: Logged on 2017-04-06 19:05 mircea_popescu: head doesn't work on a large file.
mircea_popescu: im clocking MINUTES of cpu time.
mircea_popescu: i can see the theoretical "benchmarks" online too. the problem is they're bs, "test file generated by seq 100mn". hurr. how about generate a file with lines of random length between 1kb and 1mb, then benchmark it.
asciilifeform: is something hogging the disk ?
asciilifeform: how long does it take to, e.g., touch foo.bar ?
mircea_popescu: ~0
asciilifeform: then hm.
Framedragger: mircea_popescu: recently had to tail multigb files, it was *instant* (because, seeks to end of file). seems like a disk prob to me
mircea_popescu: meanwhile 0:29.14 tail <
Framedragger: what does iotop (under root) say?
Framedragger: (ah it's not installed by default i'm afraid)
mircea_popescu: command not found
Framedragger: should be in repo as `iotop`
mircea_popescu: hoooly shit.
mircea_popescu: tail -n+150000 tril_posts.sql | head -n5 > hurr.txt produces empty file ; meanwhile wc -l claims 111119289
Framedragger: i am very interested in i/o of `tail` while it's running. wtf. would apt-get install iotop
mircea_popescu: -- Dump completed on 2017-04-06 15:10:30 << at least i know for a fact i got an integral mysqldump. sadly it's 40.9 gb.
mircea_popescu: and the mystery starts to unravel : the first 52mb of this file consist of ... one line of ^@
Framedragger: oof
mircea_popescu: sed 's/^@//g' actually crashes :D
asciilifeform: mircea_popescu: is it really ^@ or is that just what you get out of the terminal
asciilifeform: what's the hexdump look like ?
mircea_popescu: and what am i, mafalda ?
mircea_popescu: how will i hexdump ?
asciilifeform: yourthing | hexdump -C
mircea_popescu: you're new here aren't you.
mircea_popescu: here's a heads-up : head has been going for ~4 minutes. i expect it to crash without output.
Framedragger: head -c 1000 | hexdump -C
Framedragger: bytes, not lines
mircea_popescu: ah that's an idea.
mircea_popescu: lessee
asciilifeform: simply pointing out, '^@' is terminal barf, not contents
mircea_popescu: no im aware asciilifeform
mircea_popescu: Framedragger bingo, "00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00"
asciilifeform: ( it suggests that mircea_popescu's sql dump isn't 7bit clean )
asciilifeform: aaaha
Framedragger: mysqlol
mircea_popescu: myeah.
mircea_popescu: now then : how do i wipe null chars from file ?
mircea_popescu: looks like i got about 40mb of them
mircea_popescu: gb*
mircea_popescu: mebbe tr halps.
asciilifeform: sed -i 's/\x0//g' file
mircea_popescu: tryin tr -d '\000' because sed crashed once already
Framedragger: sed is only supposed to work on text files but hm.. also, one clunky way would be to hexdump whole file into hex.bin, then work with that
mircea_popescu: (i suspect /g doesn't work well with mb lines)
asciilifeform: cat file.foo | tr -d '\000' > new_file.foo
mircea_popescu: \s what im doing
mircea_popescu: sadly the output is over 8gb already. apparently i got more crap in there.
Framedragger: wait how did you end up with that large ass file? sql dump?
mircea_popescu: Framedragger myisamchk'd the extant MYI/MYD pair, got a db file which works but is too large, had mysqldump drop it as a .sql
mircea_popescu: trying to clean it up and put it back in now.
mircea_popescu: holy shit it returned! we're down to 25 gb now!
asciilifeform: !!up gabriel_laddel_p
deedbot: gabriel_laddel_p voiced for 30 minutes.
gabriel_laddel_p: http://btcbase.org/log/2017-04-06#1639114 < I didn't realize that this "sharing" link would open in google drive. Here is a link to the same file that you can open in emacs, curl etc https://raw.githubusercontent.com/gabriel-laddel/masamune/master/slate-star-codex-no-wrap80.txt☝︎
a111: Logged on 2017-04-06 18:16 gabriel_laddel_p: https://docs.google.com/document/d/1tQ8nHp2wWD-U4c7l8FbZgW3GJfhni78hDZJH4ihKSpI/edit?usp=sharing
Framedragger: mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so that in itself is alarming.. weird
asciilifeform: Framedragger: it strongly suggests disk rot, imho
asciilifeform: gabriel_laddel_p: what am i looking at
asciilifeform: seems like a massive reddit paste ?
mircea_popescu: Framedragger how do you figure ?
gabriel_laddel_p: asciilifeform: http://btcbase.org/log/2017-02-14#1613716☝︎
a111: Logged on 2017-02-14 00:14 mircea_popescu: gabriel_laddel_p if it could detect and wipe the idiotic wrap(80) thing that'd be great.
gabriel_laddel_p: asciilifeform: in that conversation I dropped "rich webpage" & "text" archives into the log, which were OK'd, given that word-wrapping was removed.
asciilifeform: aah
mircea_popescu: o yeah check that out
Framedragger: mircea_popescu: .sql is a set of statements which you can run on db to put it back into the state which produced the .sql in question, no? but, if there's mysql specific convention bullshit tho, i wouldn't know :/
gabriel_laddel_p: having both text & the js/images/etc prevents lizardhitler from "unhappening" headlines, while ensuring that DOM dumping and other crazy nonsense doesn't have to be implemented.
mircea_popescu: Framedragger and if i store a jpeg the dumper is supposed to do what, base64 it ?
mircea_popescu: asciilifeform i'm reasonably happy with the format tbh.
Framedragger: i don't know how it would encode it, but in general, yes. more like, escape nonprintable chars with "\0" i guess
Framedragger: but i'll check lest i'm talking out of ass
mircea_popescu: i wasn't aware .sql is supposed to be a text file.
Framedragger: seems mysql does not have a 'binary dump' option. so basically, yes
Framedragger: typical small .sql is usually just a set of "INSERT INTO .. VALUES ..", but mircea_popescu is running a large escher megasite, so i'm less certain..
mircea_popescu: normally it'd be all text, but because it got fucked it got filled with crap. which the dumper can't discern from legit stuff.
Framedragger: (i don't know about that "db" file, tho, i mean, that one's binary)
mircea_popescu: notrly, mostly text also.
mircea_popescu: MYD i mean
Framedragger: (but output of mysqldump is *supposed* to be a set of sql statements.)
Framedragger: i don't know what that is
mircea_popescu: mysql stores mysiam rows as a myd / myi pair of files
mircea_popescu: very much like our dear bitcoin really.
CompanionCube can't speak for mysql but knows that postgres dumps can be a mixture of text and binary data
CompanionCube: unless you specify the 'plaintext' format
Framedragger: mysqldump appears to support text-only
mircea_popescu: holy shit.
Framedragger: but actually, i haven't run mysqldump in forever and not 100% certain about docs, so i don't know
mircea_popescu: i don't imagine anyone can actually intuit what i in fact did.
Framedragger: mircea_popescu: by text-only i meant the *output*, it can certainly handle binary blobs
mircea_popescu: get a load of this :
mircea_popescu: UPDATE table SET content field = '(the 2mb content of the post i wanted ADDED goes here)'
Framedragger: (one internet says "No, it is not always reliable when you have binary blobs. In that case you MUST use the "--hex-blob" flag to get correct results." << untrusted source)
mircea_popescu: which is how one ends up with a multi-gb db. apparently it got executed even though no ; at end or anything
CompanionCube: why not just restore from previous DB backup if any
mircea_popescu: aha.
shinohai snickers
gabriel_laddel_p: Oh, and I learned the price of lispworks - 4.5k
asciilifeform: hah, only 30% up in 7y
shinohai: https://pbs.twimg.com/media/C8n4cyrWAAQ_MIt.jpg
trinque: texan as hell.
asciilifeform: faek?
trinque: probably
trinque: https://www.state.gov/secretary/remarks/2017/04/269465.htm << wahahaha
trinque: no, real.
Framedragger: notbad.jpg
shinohai: "We choose not to become involved with N. Korea's ongoing war with the sea" would have been more lulzy
trinque: well, not everybody can snark on a qntra level.
shinohai: This is why I am not Secretary of State.
asciilifeform: lol @ 'Parental Child Abduction' page.
asciilifeform: ( where, one wonders, is the 'surplus sarin for ModerateRebels' page, order form)
shinohai: So I noticed thestringpuller has changed his location on twitter from "La Serenissima" to " Wakanda "
shinohai: Which begs the question, wtf is a Wakanda
CompanionCube: https://en.wikipedia.org/wiki/Wakanda_(comics)
CompanionCube: 'Wakanda is a fictional nation appearing in American comic books published by Marvel Comics.[1] It is the most prominent of several fictional African nations in the Marvel Universe, and it is home to the superhero Black Panther. Wakanda first appeared in Fantastic Four #52 (July 1966), and was created by Stan Lee and Jack Kirby.'
shinohai: A fictional cargo cult.
shinohai goes back to remotely setting up a lovense ....
mircea_popescu: oook... trilema is back online.
mircea_popescu: please check your favourite articles for any upset! ty for your patience!
CompanionCube: mircea_popescu: do you plan to write an article about mysql being a shit?
mircea_popescu: how is mysql a shit ?
CompanionCube: in the sense that it/the dump tool produced a overly-large 40gb file?
CompanionCube doesn't think he phrased it correctly
Framedragger: i mean even if mircea_popescu aborted a db write, it shouldn't have forked into gigs of crap?..
Framedragger: congrats on emerging alive on the other side
mircea_popescu: Framedragger i dun think you've grokked the depths of my idiocy
Framedragger: oh, ah
Framedragger: wowwwww
Framedragger: :D
Framedragger: wow even more congrats on emerging alive
mircea_popescu: and then it crashed because suddenly turning 10s of ks of article into a 3mb turd inflated the db.
mircea_popescu: and THEN i interrupted it so it lost its indexes too.
Framedragger: not a bad eventual outcome at all
mircea_popescu: the moral being that db engineers are made not born, and this is how. so unless you're willing to burn dbs, don't hire noobs to engineer your storage
mircea_popescu: even if the noobs are yourself.
ben_vulpes: utterly unrelated: https://68.media.tumblr.com/51e9183a4ac0ca21bb22fb702e5b6bc9/tumblr_oo0ak4Cl321w7wz67o1_400.gif
Framedragger: mircea_popescu: so you went through every row checking if it has turd at start, and removing that turd? or found binary log to roll back the transaction (which should have aborted and rolled back, something something)
shinohai: Hot as fuck ben_vulpes
shinohai likes brunettes
mircea_popescu: Framedragger i whined at person actually in charge of this who gave me the backup.
Framedragger: hey backup&restore process tested successfully
trinque: mircea_popescu: the fucking syntax though eh? cut all dicks off all males, then you back it down to particulars!
trinque: I by way of a sad life always write the where clause first
trinque: hell actually, cut the dicks off the females too!
trinque: (wherein phf gets mad at me re: that's how set theory works and I scratch at my left stump)
Framedragger considers linking to godel's ontological proof of god in Coq
trinque: you keep your coq to yourself
trinque wrenches his troll-switch back to off
Framedragger: (apparently some couple of russians had a fight and one shot the other over a dispute regarding kant. i can believe that)
asciilifeform: oh hey congrats mircea_popescu
asciilifeform: in other new lulz, - - [06/Apr/2017:21:12:20 +0000] "GET /cgi-bin/php?-d+allow_url_include%3Don+-d+safe_mode%3Doff+-d+suhosin.simulation%3Don+-d+max_execution_time%3D0+-d+disable_functions%3D\x22\x22+-d+open_basedir%3Dnone+-d+auto_prepend_file%3Dhttp:// HTTP/1.1"
CompanionCube: O.o
asciilifeform: elsewhere, Number of Microinverters 126 Number of Microinverters Online 110 << lel
asciilifeform: (univ. of chicago)
deedbot: http://www.contravex.com/2017/04/06/tesla-model-3conomics/ << » Contravex: A blog by Pete Dushenski - Tesla Model 3conomics.
ben_vulpes: for my subros: http://68.media.tumblr.com/19b8e0d81c0a3baa31395cdf09f11326/tumblr_oh8zmoG4nG1r9640po1_1280.jpg
mircea_popescu: trinque apparently.
ben_vulpes: !!up fromloper
deedbot: fromloper voiced for 30 minutes.
ben_vulpes: fromloper: interested in factoring rsa keys?
ben_vulpes: may have missed the window of opportunity/interest there...
mircea_popescu: huh ?
ben_vulpes: > 22:39:07, fromloper joins
ben_vulpes: > 22:51:27 ben_vulpes ups fromloper to great crickets
ben_vulpes: fromloper likely not even looking at browser tab anymore
mircea_popescu: ah, whatevs
shinohai just now noticed that comic sans "trilema" font that made him think of dogecoinz
doppler: I didn't even notice it was comic sans until I happened to browse on my windows box
fromloper: it's alive
asciilifeform: wat
ben_vulpes: ohey fromloper
ben_vulpes: what brings ye by
shinohai: Is it recent lulz?
mircea_popescu: doppler it's only comic on windows.
fromloper: I was hungry and I smelled smores.
mircea_popescu: http://trilema.com/2017/phuctor-checkpoint/ << finally, the much belated article.
asciilifeform: oh hey.
mircea_popescu: to think i nearly lost trilema over this bitch!
ben_vulpes: no...backups?
fromloper: actually, I found sweet rants on clojure, and followed the crumbs.
mircea_popescu: sure, backups.
mircea_popescu: fromloper get a key, get a name, stuff.
fromloper: thank you. I will.
shinohai: I'm actually impressed some fromloper finally speaks
shinohai: *someone
mircea_popescu: not the first is it ?
fromloper: someplurality.
shinohai: First one I am privy to in recent memory.
asciilifeform: !!up fromloper
deedbot: fromloper voiced for 30 minutes.
fromloper: fromloper studies his marshmallow, admiring its gentle bronzing in the crackling fire.
asciilifeform: in other vintage finds, http://phuctor.nosuchlabs.com/gpgkey/233AA111786036F5FC0A4D9B780E25E18670BAE5AAB7A1A2EDF1F7BB9E1BB338 >> e.g., >> http://www.itfm.de/BNetz/index.html << 'Das Bürgernetz: Schnelles Internet auch in Ihrem Ort.' << all same key
mircea_popescu: schnellerer that way.
asciilifeform: clearly.
asciilifeform: in other lulz, http://phuctor.nosuchlabs.com/gpgkey/F54008AE3FADA22531547A33562B62FD88ED9B238DF439A7ECD9DE2D1A1D8E2C >> http://www.schmid-telecom.com << all same key.
deedbot: http://trilema.com/2017/phuctor-checkpoint/ << Trilema - Phuctor checkpoint
fromloper: fromloper quietly pulls his poncho around himself and quietly retreats into the saguaro darkness, but his eyes are friendly, and he has been grateful for the warmth.
mircea_popescu: guy sounds like a roguelike
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/95BDC824F4603F27A029994EC048F1762845C33589B600720973BE2B93269201 >> SonicWALL << all same key.
asciilifeform: and afaik not listed anywhere as 'cve' or whatnot.
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/6A15537F612C3FD8268F8B468FD49CB09F81C56EE35DA5A7DA0AE05A1F9FCC19 >> 'OpenWrt Backfire 10.03' << all same key
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/12E33F9E49E155F1A0FC54B92E8D60A589DE15017A5D4FC9B6F1D9E3046E615E << i'd still luvvv to know what these are, 111 modulus dupes, but none seem to ping.
asciilifeform: ^ << cable modems, apparently.
asciilifeform: mostly asia.