whaack: diana_coman: EOD Report: 6.5hr done of saltmines, I wound up spending closer to 3h today on researching/ordering parts. I used an extra 1hr 15min to read/study Spanish. I investigated the 0000 gmt datetime bug. The problem I am almost certain arose after I revived my dead sql process. mpwp uses the 0000 to signify a null date, and my new sql process has a setting that makes the date invalid and rejects the insert. The new time cons
whaack: uming item I have is I must make trips to the atm (1h by taxi each way) to acquire cash to pay rent and have enough cash to be able to make bank deposits to order the computer parts. I am trying to speed the cash acquiring process up by doing a btc-buy in the us and a btc-sell locally.
diana_coman: whaack: mpwp has 0000 set as default for dates indeed; does the insert rely on default values though? it sounds rather surprising because you'd end up with those 0000 everywhere then, hm; what happened to the "sql process" that it had to be revived anyway?
diana_coman: the btc-buy/sell locally will be useful anyway.
diana_coman: asciilifeform: atm whaack doesn't really have the luxury of figuring out how to build an UPS from scratch too, on top of everything else; yes, a working APC UPS is not ideal nor best nor anything else; it still is a working UPS.
whaack: diana_coman: I am not sure what killed the mysql process. 9 days ago digitalocean sent out an email saying they, "rolled out mitigation efforts across our entire fleet" to address Intel's statement regarding a vulnerability, "Machine Check Error Avoidance On Page Size Change." It may be that they restarted my machine and my mysql process is not set to run on startup.
diana_coman: whaack: eurgh; such "service".
whaack: diana_coman: Well recall digitalocean was the lifeboat from the TMSR fire. I think that I should find a new provider and use them as a test for recovering my backups.
diana_coman: sounds like a plan.
whaack: I found a solution to Incorrect datetime value bug. I edited the /etc/mysql/mysql.conf.d/mysqld.cnf file and added the line sql-mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ALLOW_INVALID_DATE' . The change from my original sql_mode was I removed NO_ZERO_IN_DATE,NO_ZERO_DATE and added ALLOW_INVALID_DA
whaack: TES. Note that although in the client the variable is SQL_MODE in the cnf file you must assign the variable sql-mode with a hyphen. If you need to see your current sql mode you can run "SHOW VARIABLES LIKE 'sql_mode' ;" in the mysql client.
ossabot: Logged on 2019-11-26 00:12:53 whaack: For tomorrow's unexpected task list: I have a strange error that prevents me from saving drafts of articles on ztkfg. The error is some datetime value is getting set to 0000-00-00 00:00:00. My servers clock / date function seem to be working, and in the error log it shows some fields with the date/time set correctly.
diana_coman: whaack: do the dates end up now invalid in db though?
whaack goes to check
whaack: The dates end up as 0000-00-00 00:00:00 as I understand is intended. But I am going to see if I can remove the ALLOW_INVALID_DATES flag since that may not be necessary having already removed "NO_ZERO_DATE" and "NO_ZERO_IN_DATE".
diana_coman: whaack: uhm, dunno if intended; afaik in my db the dates are properly set really, for both post_date and post_date_gmt
diana_coman: the default values are 000 but I don't think it's meant to insert without setting it
diana_coman: hence my q yesterday and hint to go and look at the insert because it's not as much that it should allow bogus dates but rather WHY does it try to enter bogus dates to start with?
diana_coman: the trouble with unexpected resets and "updates" is that they might have fucked whatever versions of anything and therefore who knows how long it takes to track this down
whaack: diana_coman: The post_date is set correctly, but the post_date_gmt gets set to 0000. I will take a look as to why.
diana_coman: so yeah, can probably leave it at whatever non-breaking thing for now if it's not obvious, but should find a less time-consuming place for your blog indeed, by the looks of it
whaack: Also I did not need to set the flag ALLOW_INVALID_DATES, and I removed it. I also can keep the NO_ZERO_IN_DATE flag. I just needed to remove the NO_ZERO_DATE flag.
diana_coman: gotta love the 3 flags for same thing approach, myeah.
whaack: diana_coman: Okay I did a small investigation. The sql schema has the 0000 date as the defaults. The post_date_gmt gets left at the default, 0000, to represent that the article has not been posted yet (because one is saving a draft). That said, the other date variable "post_date" is being set when one saves a draft.
diana_coman: whaack: ah, so it's set fine when you publish it, then?
diana_coman: (I don't really keep drafts so yeah, I wouldn't notice that case)
whaack: diana_coman: yes.
diana_coman: ok then.
whaack bootstraps
BingoBoingo: jfw: It's just about a week until you hop on the plane. Any loose ends outstanding for your Montevideo trip?
dorion_road: hiya #o, good afternoon/evening. any one around willing and able to !!up me in #t ?
diana_coman: dorion_road: done.
jfw: Well it looks like I got two days of writing in there in the effort to not leave that series hanging.
diana_coman: jfw: heh, so you need... more pressure? :D
jfw: heh, idk, still need mein laufrichtung andern perhaps
diana_coman: vielleicht.
jfw: http://logs.ossasepia.com/log/ossasepia/2019-11-27#1011517 - nice, reads better to me.
ossabot: Logged on 2019-11-27 07:32:17 diana_coman: jfw: how's this: http://ossasepia.com/2010/05/11/mica-fabula-de-kafka/#comment-7096
jfw: can't comment as to the mouse's gender, afaik it's ambiguous in the German. There's a Clemens quote here, if I can find...
diana_coman: eh, that's because she's no lady, just a madchen
diana_coman: but it's die Maus, isn't it?
diana_coman: das Madchen
jfw: yes, so unclear if the 'sie' is because of the mouse or just the word, is what I mean.
diana_coman: ah, well, it's a generic mouse, lol.
diana_coman: dorion_road: nice to see your action in #t but mind actually updating me on your obviously-but-rather-left-unspecified new plans for the week as well?
dorion_road: diana_coman shall I leave a comment on my plan for the week with the updated plan for the remaining days ? sorry for the weak communication there.
diana_coman: dorion_road: works, yes.
jfw: http://logs.ossasepia.com/log/ossasepia/2019-11-27#1011542 - thanks for asking. I've asked around about old blankets and such for padding material but nothing's turned up yet; I'm assuming worst case I can buy a bunch of bubble wrap and pillows down there.
ossabot: Logged on 2019-11-27 11:40:53 BingoBoingo: jfw: It's just about a week until you hop on the plane. Any loose ends outstanding for your Montevideo trip?
BingoBoingo: jfw: Well, got any clean beach towels?
jfw: BingoBoingo: sure, just not many.
BingoBoingo: I have some bubble wrap after preparing diana_coman's server, but the place to get more bubble wrap is a trip.
dorion_road: diana_coman another !!up in #t would be appreciated.
BingoBoingo: Anyways, I don't see how having a variety of things padding machines could hurt
diana_coman: dorion_road: done.
jfw: BingoBoingo: good to know, then I'll bring the bubble wrap along if needed.
BingoBoingo: jfw: Well, It's just a ride to the local Home Depot equivalent. Probably best to avoid too much bubble wrap if other things are available
asciilifeform: will cross-post here for FG owners : http://logs.nosuchlabs.com/log/asciilifeform/2019-11-27#1002772
snsabot: (asciilifeform) 2019-11-27 asciilifeform: attn all FG owners : the legacy documentation, incl. all sources/sigs, is henceforth preserved here.
dorion_road: ty asciilifeform
asciilifeform: diana_coman: the link to your fg page no longer resolves. lemme know plz if that article still on your www and you'd like it fixed.
diana_coman: asciilifeform: mind running a replace of dianacoman.com with ossasepia.com?
asciilifeform: diana_coman: ty, worx. will fix in 1s.
diana_coman: that's the trouble there; when I get a break I'll set up again the redirect for dianacoman.com > ossasepia.com too but atm it's not done.
asciilifeform: fixed.
diana_coman: thanks
asciilifeform verified, all links to FG user www's presently result. even that of esthlos, who sank into sea.
asciilifeform: *resolve
diana_coman: myeah, I rather wish esthlos made it back.
jfw: http://logs.ossasepia.com/log/ossasepia/2019-11-27#1011570 - sorry, missed ack'ing this. Def still on the lookout for other things, just that time is tight.
ossabot: Logged on 2019-11-27 15:58:08 BingoBoingo: jfw: Well, It's just a ride to the local Home Depot equivalent. Probably best to avoid too much bubble wrap if other things are available
jfw to grab a bite then write up some updates on wallet.
diana_coman: thimbronion: mind setting a znc somewhere? it's getting rather annoying.
thimbronion: diana_coman: apologies. I am actually connected via a znc via a machine at a colo. I can /part until I figure out why my colo's connection is so bad.
diana_coman: huh, that's a weird connection at colo then; what colo is that?
diana_coman: thimbronion: and btw, how's it going? it's been quite a while.
thimbronion: diana_coman: datanoc.com is ther colo.
diana_coman: well, now datanoc.com is in the logs for poor connection, lolz.
thimbronion: diana_coman: In terms of getting to figuring out what's next, my blog is in much better shape - backups working, weird redirect bug fixed, text selection linking working. Also I wrote an image upload script that works well. I updated the pics in the hawaii post with it. Now I just need to do the hard part ... which is to start writing an article about how to move on and be useful.
diana_coman: thimbronion: sounds good; looking forward to that article then.
thimbronion: diana_coman: I have contacted my colo about the disconnections. If I don't get a satisfactory answer from them today, I will leave this channel until I can get a better connection somewhere.
diana_coman: all right.
whaack: diana_coman: mid/EOD report : Today's saltmine grind got interrupted because surfpal sold the car and wanted to buy some btc. I took the opportunity to go meet him and got a wad of cash so I can order my computer parts tomorrow. I have 3.5hrs left of saltmines for today/the week, I am going to spend the rest of the day finishing those hours and revising my orders so I can make all the necessary deposits when I go to town tomorrow.