Root Access

djsmiley2k

12:00

tcp6 0 0 :::80 :::* LISTEN

so it's listening on ipv6 but not 4 ::D

Burgi

12:18

check the apache config?

djsmiley2k

12:32

urgh it was vbox being

Burgi

so... turns out that the customer service agent told me to upload a CSV into the wrong table on the database

djsmiley2k

.... ouch

you got backups... right?

2

Burgi

for this, no as the changes were made too long ago

djsmiley2k

ouch

Burgi

i made the changes on to our staging server first

asked the customer service agent to check the data and get the customer to do the same

djsmiley2k

12:42

ah heh

so they either didn't

or they lied

or their testing didn't hit the required data?

Burgi

correct

djsmiley2k

\o/

Still ends up being your fault some how?

Burgi

either of the first 2 is correct

anyway they came back and said it was all good so I deployed the changes to live and moved on

our back ups are daily and retained for 14 days for "reasons"

djsmiley2k

wut, all of em o_O

i hope the important business ones are longer than that :/

14 days is nothing...

Burgi

this is our biggest client

djsmiley2k

12:54

wat

!!wat

like yearly backups are common

Burgi

i wanted 30 days

djsmiley2k

I've been places with 10+ years worth

M.A.R.

@Burgi 6'8''?

Burgi

heh

djsmiley2k

Also there's all the legal stuff of certain data you've gotta keep for 5+ 10+ years anyway

Burgi

12:55

this isn't a transactional site

arstechnica.co.uk/tech-policy/2017/02/…

DavidPostill

@Burgi You want 30 days jail?

satibel

make a permanent full backup before you push changes.

even if they say they have it.

or at least keep it 3-5 years.

helps avoiding a lot of headache.

Burgi

13:11

permanent snapshots wouldn't work in our architecture

my company wouldn't foot the storage cost and our clients wouldn't pick up the bill either

satibel

you can have a before and after back ups, so you know what you changed.

@Burgi what is this, petabytes databases?

Burgi

no

but they are penny pinching and not technical

i have a solution

satibel

then explain to them that it's a 200$ insurance against problems in case or fuck up anywhere. that might avoid loosing a client.

Burgi

dump the tables into a spreadsheet
email to client ask them to highlight the entries they want to keep
truncate tables
reinsert data

@satibel i've tried dude

satibel

@Burgi what company is that?

Burgi

13:16

i will not name and shame while they are still paying me

satibel

I meant that rhetorically.

Burgi

you should read the transcript from the end of may 2016 until now

there are HUGE issues here

satibel

@Burgi that's like almost a year of backups. :p

Burgi

@satibel and you'll see 14 days is an improvement

djsmiley2k

@Burgi agani, run away, very fast.

how big is the db because... damn

it'd be like pence on backups

Burgi

13:22

its a fundamental lack of understanding on how this particular site works

satibel

tl;dr : chat.stackexchange.com/transcript/message/30546105#30546105

djsmiley2k

by us @Burgi ?

My old job dumped on me when shit got bad

not worth the hassle

Burgi

@satibel weirdly its the same CSA now that hasn't done her part on the quality assurance

satibel

Sep 9 '16 at 11:30, by Burgi

we paid $12 to a guy in sri lanka to video himself topless with our company name painted on himself

also wtf

M.A.R.

o.o

Anna duh

13:30

Hey @Bob, managed to make it through the day?

Bob

@Annaduh Yes! :P

Actually right now sleep sounds nice

satibel

I learned that Anna duh was named dog at some point and claimed to be a cat x)

Anna duh

@Bob heh

satibel

wonderful chat archives.

Anna duh

No new relevations on the phone front?

Bob

13:36

@Annaduh dunno if you saw, but I got Android Pay working

Anna duh

@Bob ah nice.

Bob

was easy :P (just had to get Amex to unblock it. which happened when they called me half an hour later... well, their fraud protection team)

Anna duh

Never really wanted to use it imo but like many things I tend to be behind the times

Oh lol

So basically Android pay was working all along, it was just your card that had a problem

Bob

@Annaduh ya

Anna duh

I should probably try it. Just for the novelty of waving my phone at McDonald's or some shit

Bob

13:37

@Annaduh yeaaaa... Iprobably own't actually use it -_-

was just curious if it worked

it's actually ... really easy/responsive

satibel

@Annaduh it's called a feature.

Bob

phone basically works as the card does

Anna duh

Oddly enough the transaction limit on contactless seems to be determined by the country of the POS and not the card

Aka in the UK most cards do £30 but my Amex is limited to £20. In Aus my Amex does $99 AUD

satibel

in france it's 20€

Anna duh

@satibel ~~it's a feature~~ I was a cat I just got renamed to dog by the moderati

Bob

13:39

awwwwww i.imgur.com/RmFNP1O.gifv

10 hours ago, by Bob

@Annaduh maccas just accepted my android/amex pay :)

Anna duh

Also my VoLTE is all over the place now, no consistency at all. So basically still no reliable 4G only mode.

Bob

I quite literally tested at a mcdonalds -_-

Anna duh

@Bob omigod that's painfully cute

Bob

oh yea, @Annaduh, can you test this out if you use gmail? chat.stackexchange.com/transcript/118?m=36381184#36381184

Anna duh

@Bob :-D

Bob

13:41

@Annaduh It came up as an amex transaction.

Anna duh

@Bob hmm need to get me an email

Bob

I just wish my other card worke but that bank has their own NFC app

Anna duh

@Bob I wonder how it shows up on your statement

Yeah I had some painful early experiences with NFC payments on Android which might be why I've been avoiding them for a while

Too much broken proprietary crap.

Bob

@Annaduh comes up as mcdonalds

been a while since I last went there, lemme check my old statements

Anna duh

@Bob hmm nice

Bob

13:44

yea, no indication of android/google

Anna duh

As long as it contributes to my Amex bonuses like regular spending I'm good

Bob

apparently amex generates a unique ID that's used instead of the actual card number

but otherwise it's effectively an amex card, on both ends

Anna duh

I suspect that might be why it only supports certain banks/issuers

Bob

so the store has to support amex too

@Annaduh yea it's a proper backend link, which makes sense since it's probably emulating the more secure modes.

Anna duh

Needs some sort of propriety backend hook directly into their systems instead of just charging the card as Google (like PayPal for example)

Bob

13:45

not the dumb one (which just stores card number and cvv)

satibel

Once I was in Switzerland and the only place I could eat was McDonald's because I forgot my card, and they don't accept checks, so I payed by paypal x).

Bob

@Annaduh and yea not that either :P

Anna duh

Downside however is you can't use it to get around places that don't accept Amex

Bob

> they don't accept checks

do people actually carry chequebooks around?!

and who on earth trusts one o.O

satibel

french people.

Bob

13:46

to me, it's worth about as much as the paper it's written on, at least until some months after deposit

never know when a cheque might bounce

there's no verification at the PoS

@Annaduh yea, my other card is mastercard but not accepted cause bank. maybe that's a good excuse to change banks :P

but tbh I rather like that bank's app/internet banking

and they don't care about root as much as google seems to

I've not tried pay with root enabled yet

but then I only use root like once every other month

Anna duh

@Bob what is this, 1996?

Even my parents have evolved past cheques

@Bob actually... :-P

Bob

@Annaduh ?

satibel

@Annaduh 1997, it's well known France is always 20 years late.

Anna duh

In the UK they sometimes can verify checks at payin if it's a bank with the same group, since it had the bank account codes at the bottom they can basically just EFT it

Bob

@Annaduh yea, but hard for some random shop to do it

Anna duh

13:50

But yeah the system is decidedly archaic

Bob

debit cards serve basically the same purpose, only electronic

satibel

they take about 3 days for verification.

the good thing is that you can write them on any paper.

Anna duh

I'm tempted to try set up android pay now and go to McDonald's just to see if it works. Also I just had an embarrassingly bad breakfast

Bob

that's a bug, not a feature :P

Anna duh

Urgh wtf is it with swiftkey, it's as if the autocorrect has just given up on life now with the new Android. Might be the screen scaling but the buttons also look a bit off

@Bob lol

Bob

13:52

I mean, I can make up some numbers and say that's a promise to pay you $1000, but good luck getting the money...

Anna duh

There is an nfc payment app that sorta proxies payments but it doesn't support Amex

@Bob technically that's how all bank notes work here

Bob

@Annaduh it'll probably fail and then you need to call amex

Anna duh

@Bob erf.

I'm pretty sure I've already had to go through the anti fraud shit with Amex when adding it to my Google account before

Bob

@Annaduh yea my old copy of swype broke a bit and now the change button doesn't work

Anna duh

Oh well there's one way to find out

Burgi

13:54

@satibel i'd forgotten about that

Bob

the up to date swype sucks

Anna duh

Ah shit i forgot my discount book at home/Australia/Italy/somewhere

Bob

can't capitalise by swiping up anymore

who decided to take that out??

Anna duh

Dammit my email to myself hasn't generated a notification on my nougat yet

@Bob err yeah, bug reproduced here

Bob

ow

Anna duh

13:56

Yknow I should just stop manually correcting my typing just to show you how bad swiftkey autocorrect has become

Bob

yea, I've already emailed the address listed on Play

but not really expecting a response

it's Google -_-

Anna duh

But you're smart! Google should learnt o signed to smart enough eole

Bob

@Annaduh I could go the same... maybe it's still be legible, woo knows

@Annaduh downgrading yo 6.10 by uninstalling Play updates Sun's to work

if I've disaster I probably seek also

...

if I disappear, I probably fell asleep

Anna duh

Lololol

Gonna try restore Gmail 7.2 from pre nougat to see if that changes anything

djsmiley2k

does swyft key use like a word cloud of everyones typing or something?

so at first, only good typists used it, it got good

then the masses came...

Anna duh

14:03

Still there, sorta. If I open the notification twice in a row if goes away...

@djsmiley2k err nah, it does use a personal word cloud of your typing though

djsmiley2k

yeah

Anna duh

But in this case it suddenly got terrible literally overnight, when I updated my phone (again)

djsmiley2k

i remember the samsung one importanted my words... from twitter -_-

Anna duh

Yeah this one wants to import my words from SMS, Gmail, and Facebook.

Except almost none of my typing is done in any of the above.

I have a third party sms app, and don't really write emails cause I use chat and messenger instead

djsmiley2k

yup, most of my email is one way too

Anna duh

14:05

It does still analyse my typing to determine my personality traits though which is pretty creepy

djsmiley2k

personality traits?!

lol wut?

Anna duh

djsmiley2k

ah, ok

Anna duh

There we go, restored backup agaon.

djsmiley2k

so not like actual personality

Anna duh

14:07

What's exceptionally annoying is Samsung's default keyboard with no personalisation and default prediction is working a lot better than swiftkey now

djsmiley2k

Markov chains work especially well

Anna duh

As you cam see from the complete lack of typos in my last message

djsmiley2k

:)

Anna duh

Alsp this seems uber laggy for some reason

As in the word completion/prediction bar only updates 2 seconds after the word is typed

Argh my phone is borked and needs resetting

@Bob did you try the stock keyboard at all at and point ?

Ah, keyboard proportions are back to normal now, I wonder if the predictions have started working properly again...

Yup. That's a definite improvement.

So the process to restore application data after an upgrade is basically: factory reset, then log in and allow Google to auto restore everything, then go to titanium backup and manually overwrite Google restore, wait for Google to auto sync and re-break your restored settings, then go to tib and restore everything again. Then it works.

djsmiley2k

Soooooo why doesn't the google restore work in the first place?

just outta interest

I know it doesn't for me - it'll miss things like background images etc

Anna duh

14:13

@djsmiley2k Google attitude is your app data is expendable and doesn't bother backing it up properly

djsmiley2k

I'd be really really happy if I could just login to a phone, and have it replicate from my old/expendable phone

@Annaduh hmmm

Anna duh

Same with plug in data on Chrome. It's basically discarded unless the developer has specifically marked a certain piece of data for backup

djsmiley2k

Ah I see

so not talking about 'personal' data such a photos and such?

Anna duh

@djsmiley2k replicate? Expendable phones? Drug dealer/terrorist?

djsmiley2k

yeah I'm all of them and more

Anna duh

14:15

@djsmiley2k no, data in application/plug in storage rather than filesystem

djsmiley2k

Nod

That's what I've noticed, sadness :(

urrrgh

I still need to figure out how to pull down all my google photos on linux

no, they don't show up in drive

that's what happens when you put 40+Gb up there appently

Anna duh

:-o

Mine used to sync to Google photos before they terminated that service along with all the other good /useful ones

djsmiley2k

terminated it?

it works here...

Anna duh

Cc @Bob ^^ looks like Amex isn't supported at all in the UK

djsmiley2k

Anna duh

14:19

@djsmiley2k err I mean the old one, Picasa gizmodo.com/…

Anyway looks like no McDonald's for me :-(

djsmiley2k

ah ok

Right, you see photos yeah

in drive...

WHERE ARE THEY?!

Also lol accidental penii.

2

Some of the picasa api's etc are still live

but I got stuck trying to get access to the actual photo, as in google don't provide it in any kind of native way

Only a page displaying it, and as I'm inferiour, I couldn't figure out the rest

Anna duh

So nice having one of the few phones that can access the 30Mbps channel on 3, cause you can get 25Mbps on it instead of 8Mbps on the 110Mbps channel because everyone else is on it

Ben N

I'd guess the generated pages are all structured the same, so you could probably write a script to find the image URL and download that

djsmiley2k

@BenN yup, I did try

but I'm no programmer

please don't write something in powershell btw

3

I need at least something in python, as it's on linux :P

Ben N

A regex might be able to do it

djsmiley2k

14:25

Time to figure out in phpexcel 1. how to get the file type and 2. from the type, figure out hwo many rows in it

@BenN Pretty sure it could,

cept I kept failing :(

now the code is at home, I'm not

and my enthusism is kinda dead

So instead at work I'm working on this excel sheet.... validator

for want of a better word

Burgi

@djsmiley2k why are you taking photos of BMWs?

djsmiley2k

it was parked in the way

i needed the reg

to have it moved.

Burgi

i'm guessing the child is yours....

djsmiley2k

oui

The horse isn't xD

Burgi

you can't say that about your wife!

Anna duh

14:30

Urgh I don't like how the new notification toggles hide the text and status info

GFSE

GemsFromStackExchange: More hilariously broken help...

posted on March 30, 2017

More hilariously broken help center: https://meta.stackoverflow.com/questions/345280, this one courtesy of ɥʇǝS in chat.

Powershell for Linux

Great I've reached the electrocution phase of drug withdrawal

djsmiley2k

o_O?

@Burgi :P

i own her under Shria law, you sure I can't? XD

DavidPostill

More random name changes ...

djsmiley2k

Oh it's you

and your featured profile is ubuntu? XD

Powershell for Linux

14:38

Shia? Sharia? Syria? Shria?

djsmiley2k

/me shrugs

Shia Le Bouf

Powershell for Linux

@djsmiley2k isn't Linux Ubuntu?

djsmiley2k

Anyway, I can't get the 'last' row of data from excel, without loading the entire sheet...

Powershell for Linux

@djsmiley2k Have you tried powershell?

djsmiley2k

You bored yet?

It's all a bit stupid really

I could say to the user 'save the file as csv' and do the work from there...

however the file_ may contain new lines, and I'm unsure what they'll do in the xls -> csv conversion

Powershell for Linux

14:42

\n?

djsmiley2k

Infact, lets !!SCIENCE!!

@PowershellforLinux Maybe.

maybe it'll start a new row half way through the existing one

Powershell for Linux

As long as the last line doesn't contain newlines I don't think it matters

djsmiley2k

7®‍ §¶…F

this cell is fun

hmmm

how did someone even type a new line into a cell o_O

alt enter. wut

satibel

@djsmiley2k excel auto adds returns with auto return enabled

djsmiley2k

annnnnnnnnnnd

excel completely screws up the csv format too yey

satibel

14:48

it fucks csv up x)

welcome to my world

djsmiley2k

9,9,9,9,9,9,9,"

9",9,9,9

lol

ok it's not quite as bad as I thought

it at least points it out kind of nicely with the speech marks

satibel

also people "deleting" columns by making their size 0

djsmiley2k

i found a 150Mb xls the other day

it had workbooks of data back to 2014 that they didn't need

but instead of deleting, just hid the workbooks -_-

satibel

it's annoying, because you see something, and the program spits out something else.

djsmiley2k

So I am going to have to load the line, clean out the crap, carry on

satibel

14:51

@djsmiley2k I needed to change a policy on a file, because it took more than 2gb, and made printing impossible.

1 sheet per day for like 5 years makes excel really not happy

djsmiley2k

1500+ sheets? yeah, not supprising

Powershell for Linux

@djsmiley2k huh nice

satibel

@djsmiley2k yeah, but I spent 1 hour wondering why it wasn't printing.

djsmiley2k

@PowershellforLinux not sure anyone would expect it tho?

Right, back to my original idea then

load the excel file, filter the crap, write it out to csv

Rahul2001

15:06

Yay! Bowling!

@PowershellforLinux facepalm

djsmiley2k

yey writing out my code on paper and otimising before I even go any where near a computer :O

I R DOIN FUNCTIONs

Powershell for Linux

@djsmiley2k ~~gangnam~~ rahul style

Well that was freaking obvious... Ryzen's gaming performance deficiency... was because they simply numbered their cores differently from Intel

Journeyman Geek

@TOWMN - haven't they always?

also. I think I handled 0 flags today

or very few at least ;p

DavidPostill

15:21

@JourneymanGeek Hehe.

Journeyman Geek

(Partially my fault. Was gaming most of the day.)

DavidPostill

I've been nuking spammers as well as flag handling :)

bwDraco

@PowershellforLinux: Is there some kick you get out of constantly changing your name?

Journeyman Geek

and lol. This is totally not a backhanded way to get youu mod experience

@bwDraco meh ;p

Just keep calling him @TOWMN all the time.

;p

bwDraco

Just curious :)

DavidPostill

15:27

@JourneymanGeek I know :) But the average flag handling time is improving ...

Journeyman Geek

@DavidPostill Well, I suspect part of the longer average is flags that we can't decide on, or can't be bothered to handle

and yeah, sometimes the latter happens

(So its left for someone else. Nice part of having a mod team with a common flag queue ;p )

user226528

@JourneymanGeek Hi. There is this certain question in which people are engaged in idle chatter in the comment section. Normally, I'll flag them as too chatty. But in this case, the chatter takes place under my answer. So, is it good form that I flag comments for my own answer?

Journeyman Geek

sure

user226528

Thanks. Flagging...

Journeyman Geek

>_>

Someone might have beaten you to (some of) them

user226528

15:33

What?

user226528

Of course! It is David Postill. God bless him.

Journeyman Geek

the flags ;p

so not his fault (this time)

user226528

I don't call this a fault. So...

user226528

You CAN see the name of the person who flags them, right?

djsmiley2k

arugh

the object orintated php writing is horrible to read

Journeyman Geek

15:37

errrrr

for comments?

Maybe?

I never check

DavidPostill

@JourneymanGeek It is apparently possible only if you have an idea who flagged in the first place :)

Journeyman Geek

lol

djsmiley2k

@PowershellforLinux 1,3,2,4?

why read accross when you can read down?

1, 3
2, 4

I SOLVED IT \o/

djsmiley2k

15:52

if I define a class in another file, the file via include once, will it pull the class in? D:

stupid php classes

actually screw it

I'll just do it by hand

least then I know wtf is going on

Transcript for