« first day (984 days earlier)      last day (4194 days later) » 
01:00 - 18:0018:00 - 23:00

01:10
@AviD I think the performance issue I'm having with the formula is kind of inherent to the way the arrays are being used. Each portion of the array formula has to be run against the entire column (or, at least, all of the populated cells in the given column). To say this is sub-optimal is a massive understatement.
If I were working with similar data in PowerShell, I'd optimize it by using one command to select the largest set of relevant cells (All the cells with UIDs matching the one I'm looking up) and then pipe that subset to a command or series of commands that will pick out the data out of the newest row. This way, the entire data set only needs to be processed once and the rest of the processing is limited to just the interesting information.
Of course, since Excel isn't a database or a command shell, I'm guessing there's no good way to do this where I need to?
01:31
Oh, this is giving me an idea. A nasty PowerShell idea.
Just one or two commands I'd need to find, if they exist...
It's hacky, and it goes further out of Excel than I'd rather do for this, but if the commands exist it should do the job.
@Iszi You dirty dirty boy....
 
2 hours later…
03:28
@Simon Heh, I mostly liked it because of my comment. :P
 
2 hours later…
 
2 hours later…
08:12
@Iszi right, each array - of ALL rows in the original sheet - needs to be created for each UID / row in the new sheet.
thats the main reason I commented to use rows notation instead of full column - it makes a huge difference. And yes, the performance would suck, even with the final simplified version I gave you.... but does it really matter? How often are you doing this?
btw while my answer is awesome and correct, @Rhys' answer there seems to be the betterer way.
I actually considered suggesting you import the whole dataset into a database, do the filtering, then export to Excel, but I restrained myself... ;-)
why would somebody flag an ISA question as SU material....??
why would FOUR someones... four someones who SHOULD REALLY KNOW BETTER.
@AviD ISA question?
@LucasKauffman ISA is/was MS' enterprise firewall. not really SU....
but you werent one of the illustrious four, so you're off the hook.
haha @RoryAlsop that fellow that is flagged for repeated crap q's... oh lordy his comments are just hysterical.
@AviD Name and shame!
1) Terry China
08:25
0
Q: Why client with Basic auth cannot work via ISA proxy server

Kaponir Client application supports only Basic authentication When client application runs from machine in the same domain with the ISA - it's Ok. When client application runs from machine that not belongs to the ISA server's domain - client cant access to internet. I know that ISA server can be confi...

if you rrreeeeaaaallly want to know
@AviD I can't see who flagged.
@LucasKauffman Bitch.
@TerryChia you can see who closed.
@AviD Nope, only shows that it was migrated from over here.
@TerryChia ohhhh
and if you click on the "migrated from security"....?
@AviD Ahh, that works.
08:28
1 min ago, by Terry Chia
@LucasKauffman Bitch.
Anyone has a list of search terms they would like to query GitHub for? :P I almost got my script up and running, just have to iron out a few bugs.
@TerryChia Boobies.
@TerryChia 'ùµ£
and ofcourse boobies, password.txt, secret.txt, .pk
boobies.txt, secretboobies.txt, passwordtoboobies.txt
08:57
@AviD this would not be the first time. I think it's because there's no flag to migrate to SF...
0
Q: ASA5520 CPU Utilization in 98%

Mohammad Reza YousufiCPU utilization of The ASA 5520 in my company suddenly increased to 98% for 2 hour. In this time, I have checked the logs: Logs Deny TCP reverse path check from 121.65.98.4 to 180.85.66.54 on interface inside I canceled download in a PC, then the problem is resolved. Could you please tel me ...

would seem more like serverfault to me than superuser as an example...
09:18
@RoryMcCune yeah well, waddaya expect from a @Rory...
;-)
@AviD well combination of his age and @LucasKauffman kind of an inevitable result I guess...
@RoryMcCune hehe, yes combining @Lucas always messes things up...
in entirely unrelated news the popularity/controversy about this blurred lines song keeps making me want to listen to white lines
no idea what you on about.
in other unrelated news, I'm putting together the regional OWASP IL conference...
too damn short notice, imo.
but it already looks like its going to be awesome.
oo! forgot to request the swag package.
@AviD singer makes song with dodgy lyrics and a video with naked chicks, it gets to number one and gets performed at the MTV VMA's with Hannah Montana wearing a flesh coloured plastic bikini, in some segments of the news it's a big thing.. I only found out about it from a youtube react video..
09:34
meh
@AviD cool when's it going to be? I've thought about putting on something for Scotland but need to get the time as it seems like a lot of work
she wears less than that in her own videos.
from the conference organisers that I spoke to
seems she's working hard at breaking her "good little girl" image.
volunteers not necessary...
@RoryMcCune Oct 1.
@AviD yeah but thing I can't work out is what's the thing with these people and sticking their tongue out at an odd angle
09:35
and we're just getting it set up now... several months late since our usual venue was delayed in organizing a date for us.
@AviD that is soon
and yeah, it is a bunch of work... you need a group to back you up.
how many tracks/days are you doing?
@RoryMcCune I know, right?? its stupid. supposed to look either sexy or cute, fails on both. Hits the mark on "stupid" though.
@RoryMcCune it's just one day here, Israelis can never be bothered going to something two days in a row... :-)
we usually do a full day, two tracks, plus a couple of keynotes.
@RoryMcCune btw if you are looking for a foreign speaker (and have budget for airfare) I might be able to be convinced to make it out there... ;-)
@AviD cool. you getting some Sec.SE goodies for it?
09:38
@RoryMcCune filling out the form now.
they seem to have cut back, though...
@AviD that would be cool, will need to see what I can do.
hmm, cant do that this year, but perhaps next time if we get enough sponsors, we might try and fly a @rory out....
on principle, the OWASP here is always 100% free, costs are always covered by sponsors only.
hmm, the swag form is limited to 100 people? wtf?
Morning everyone - normal @RoryA service will now be resumed
@AviD Hahahaha - yes
@RoryAlsop aaaaaahhh yeaaaaahhhh
@RoryAlsop I think we should be getting at least an intern's salary from him.
@AviD erm...guilty...sorry
09:44
@RoryAlsop hehe
well, at your velocity, you're bound to make a few missteps.
@AviD was my velocity Continental? I forget....
@RoryAlsop nyeeeer. Sorry, I missed that?
@AviD A few days back - I think someone made a scurrilous remark about my age...probably @Terry again :-P
@RoryAlsop it's already been a few days...?
@AviD pfft
09:47
heehee
10:14
excellent. i wasn't sure if the post could be decrypted with the public key alone. thanks! — mulllhausen 43 mins ago
@LucasKauffman Planning to do something about that?
@Adnan @LucasKauffman I daaaaaaare ya
@AviD Well, somebody should do something about that.
10:48
@Adnan sorry was out for lunch ^^
@Adnan what's wrong with it o.O?
> excellent. i wasn't sure if the post could be decrypted with the public key alone. thanks!
@Lucas Fix it before the bear sees it. Remember what happened to me the last time I implied that?
11:10
@LucasKauffman yeah, @Adnan still walks funny since then.
aaah
@Adnan alright fixed
11:45
Random girl approached me in a coffee store and asked for an iPhone recharger, because she needs to phone. "Yeah of course here."
12:07
@AviD So can I assume you saw my flag and fixed it?
@ScottPack Indeed.
@AviD This is the second time in as many weeks that this has happened.
Good
I blame the new close system
ahhh... coin just dropped, thats why you didnt VTC, cuz then the (stupid) majority would have forced it over to SU.
@ScottPack I blame @Adnan.
Yuppers
so just consider me - The Stupid Majority Antidote!
no, wait, that doesnt sound right....
12:09
Sounds right to me.
So here's the problem.
We don't have a migrate to SF option, and if you're not careful it's not hard to assume that option 3 would go there.
@AviD Why me?!
@ScottPack I agree.
@Adnan cuz its fun! and you're easy!
oh damn, that doesnt sound right, again... :-(
No, sounds perfectly fine.
@ScottPack +1
dammit, new allergy medicine, I'm all fuzzy
MY HEAD is fuzzy, my head.
12:11
Seriously, a lot of questions we get need to be migrated to SF. It's just confusing.
Plus, we're all too lazy to write a custom closure reason.
@AviD you're fuzzy @Adnan is easy, sounds like we've got the start of the DMZ 7 dwarves :)
2
whats up
@ScottPack yeah, I agree with that meta.so post that @gilles linked, the close system is good except that everything is lumped under "offtopic".
12:12
@Adnan The close destinations we get are based on some kind of psuedo-statistical analysis of where we have mods migrate stuff.
@AviD You got that link handy? I'd like to see it.
@Dave Yarr.
101
Q: Shouldn't "off-topic" be only about... off-topic?

TheTerribleSwiftTomatoA related question/discussion point to this one posted just now, but with a completely different rationale. Whenever a question is closed because it doesn't contain SSCCE, or specific code, it also gets marked as "off-topic". I would argue that this is confusing, especially to new users, since t...

Danke
By definition anything that we want to migrate should almost always be off-topic.
there are actually some good contradictory answers there - different solutions proposed, each an improvement over what we have now.
@ScottPack migrate - yes. the others - not so much.
when I have some free time - gonna meta post about what our custom OT reasons should be.
no time to get into it now...
unless somebody else does first (hint, hint)
@RoryMcCune @RoryAlsop can be oldie.
@TerryChia actually thinking about it fuzzy is doubly appropriate for @AviD given his avatar...
12:24
@Lucas What the what?! You're now in front of @RoryM
@Adnan yeah it was inevitable really.. You, him and @TerryChia are likely to overtake me I'd guess (although @TerryChia seems to have slowed a bit...)
@RoryMcCune Yeah, I got the 10k lethargy.
Not much real goals after 10k.
0
Q: Custom Close Reasons (August 2013)

Scott PackWith the recent change to the Close system we have some more control over what some of our messages say. We are now allowed to craft our own custom close messages, up to 3. This question is intended to act as a mechanism for gathering proposals and determining which ones the community likes the...

@TerryChia Duuuude, 20K!
So we can actually start trusting you
@Adnan That's soooo far away though.
12:31
@Terry For example, currently, I cannot be comfortable getting naked in front of you
@Adnan I thought we had something special. :(
@TerryChia Well, as long as you mention the word 'sauna', you can get anybody in Finland to get naked.
It's a national duty to go sauna naked whenever invited. You just cannot turn it down.
@Terry So just mention sauna, and we'll have something special.
0
A: Custom Close Reasons (August 2013)

Terry ChiaWe need a close reason for RTFM or RTFWA or just Google that damn thing. Kidding aside, I don't think we need a custom close reason really. Most of the default ones we have will work just fine. We could do with a few more migrate options to sites like SF though, if that's an option.

There. I seeded the list with the defaults.
Please help craft our close vote messages over here.
6
@AviD Doing it at least weekly, if not more often.
3
12:42
So hey. Any of you guys have any experience with btrfs?
@ScottPack good on ya!
@ScottPack That's another copy-on-write file system like ZFS right?
@Iszi heehee. Ah, I assumed it was a one time thing.
Can I suggest, if thats the case, to whip up a small proggie that will do this for you, scheduled and efficiently?
@ScottPack you should go for ReiserFS, it's a real killer.
@TerryChia Yeah, except it was intended to be a native Linux one instead of a port from Solaris.
12:52
@ScottPack Wasn't it still in beta? If would be awesome news if it's stable now.
@TerryChia So right now I've got two 1TB disks that I'm using as a JBOD with LVM as the storage for my media center. I've just purchased 2 2TB disks to swap them out. I'm thinking I may have better options now.
@TerryChia From what I remember of ZFS it natively supports what I'm doing with LVM, but from what I understand it's still pretty buggy on linux.
@ScottPack Yeah, I wouldn't trust ZFS on Linux right now...
@TerryChia I hear @ewwhite has had some fantastic experiences with it on RHEL.
It looks like btrfs is out of beta now.
@ScottPack Any writeups? I would love to ditch BSD/Solaris and just use RHEL/CentOs for my NAS-in-planning.
@TerryChia I dunno yet. That's kind of why I was asking first. :)
12:56
@ScottPack Ooooh nice. Hmm, I wonder if it will be the default FS for the upcoming RHEL 7.
It's just about the right timing.
Ugh, RHEL 7 is really gonna suck. Huge changes from RHEL 6 in terms of all the configuration stuff....
so what are the advantages of BRTFS compared to for instance LVM?
@TerryChia Right now I've got two PVs, both added to the same VG, then running XFS on top of that. It works well enough, and I've actually only had one failure in 6 years.
@TerryChia Full on transition to systemd will probably be the biggest thing.
@LucasKauffman I think it has all the self-healing capabilities like ZFS so you don't need RAID.
@ScottPack Yeah, it's gonna take me some unlearning.
12:58
@LucasKauffman As near as I can understand lots of the features that we use LVM for are natively baked into the filesystem.
@TerryChia Think about poor old me. I have nearly decades of muscle memory for SysV
@ScottPack Hehe.
The new firewalld thing seems interesting though, slightly less confusing than iptables.
@TerryChia I still think pf is better than iptables
@LucasKauffman I have zero experience with BSD so... :P
I was using system-config-firewall during my RHCE test. Can't be arsed to memorize the iptables format. :P
@TerryChia <showing Age> I remember back when iptables first came out and before that it was ipchains, that was when I started getting into firewalls, was good way to learn about TCP/IP writing the rulesets...
@TerryChia Lamer
@RoryMcCune Why in my day netfilter was good enough for anyone!
13:07
@TerryChia pf allows you to use tables with addresses to assign to rules, which iptables doesn't have natively
@TerryChia Furry muff. I think systemd and firewalld are the two things I need to figure out.
@RoryMcCune Hahaha! I can write iptables rulesets. I just need a few hours of no pressure time to test it out as well as reference to better documentation (google).
@ScottPack At least for Fedora 19, service blahblahblah start | stop | restart still redirects you to systemd. I wonder if RHEL 7 will retain that.
That could ease the transition slightly.
@TerryChia I'm not sure.
They'll probably also get rid of ifconfig. Fuckers.
@ScottPack will you need to use ip for everything?
@LucasKauffman Probably. That's what the kids these days want us to do.
"ifconfig is out of touch and inconsistent with other applications." Or some shit like that.
13:12
@ScottPack Dirty open source hippies, wanting to change everything
God save us is they see find.
@ScottPack you could just make an allias for ifconfig which is just ip addr
I imagine the rest of the syntax is wrong.
@LucasKauffman Probably a good time to fork RHEL and start up Scott Pack Enterprise Linux.
You know, it's funny. I went to a LOPSA event last week.
13:14
@TerryChia lucas@ThePack
There were about 10 people there. 3 people were older, like 50s and up. The rest were all about my age.
I was 1) The only one with a beard. 2) Without question the crustiest in the room.
There was an old cranky looking guy with pure white hair who started going on about AWS zones, mongodb failover weirdnesses, and message queues.
Woah. He was a dead ringer for a Solaris admin.
@ScottPack crazy
13:47
@ScottPack What is the world coming to?
@Xander I know, right?
14:04
How do you join the Sec.SE CTF Team? I want to participate in some CTF events, but I have trouble finding people to play on my team.
@RodMacPherson Ping @gilles
Read this first:
21
Q: A Security Stackexchange CTF team

Lucas KauffmanUpdates: Added first challenge to prepare We now have an IRC channel! Join us in #SecSE-CTF on Freenode: chat.freenode.net:6667 We have a CTFTime team, secse. Please join this. We have a chat room on chat.se which will be closed during competitions to all but team members then re-opened when w...

14:27
0
A: How is wireless WiFi password cracked?

Lucas KauffmanFirst of all that would entirely depend on the encryption used by the access point. There are several types of possible encryption. Mostly on consumer wireless access points these are: WEP WPA WPA2 WPS WEP Let's first dive into WEP. WEP was the first algorithm used to secure wireless acce...

@ManisEarth Thanks.
@RodMacPherson It's a long and complex journey
@RodMacPherson Also I approve of your hair and beard, it's cool :p
14:44
@LucasKauffman you did your homework there I see :)
@ManishEarth That list of CTF team members is ancient, I don't even remember seeing some of them in the last half a year of thereabouts
I should probably take myself off. I had grand dreams of getting involved, but haven't kept up with it and seem to never hae the time.
@ScottPack +1
@LucasKauffman It is not "Berkley"; it is "three researchers who happened at that time to work at the university of Berkeley (mind the 'E'), and who also happen to have names of their own".
@ThomasPornin aha I shall edit that out
@ThomasPornin Also I just tried to find more info on WPA2-AES vs WPA-AES, basically WPA-AES just uses AES instead of RC4, but still uses TKIP-MIC instead of CCMP, which is used by WPA2
is this correct?
15:00
@LucasKauffman It's been a while since I last looked at it, but yeah, that matches what I remember.
@LucasKauffman Thanks for the compliment. The last pentester we had come through here said he was nervous when he saw my beard, and got really worried about how tough an assignment it was going to be when I brought up cons and mentioned some names when we were chatting in the hallway. :)
WPA initially reuses RC4 hardware with some additional protections, including a custom MAC (Michael) which, as MAC goes, is pathetic, but not as much as no MAC at all.
Then AES can be used instead of RC4 but you still have the poor MAC instead of something decent like CCM (which you have in WPA2).
15:20
Is my answer bear-approved :p?
@LucasKauffman I'll have to read it whole before approving it.
Ah, Nigerian scams are sometimes quite fun:
> I have an important issue I will like to share with you concerning my inheritance and character of my wicked Uncles that wants to kill me to enrich themselves
Through a Google Calendar event invitation (that's kinda creative).
@LucasKauffman Your answer is fine. Upvoted.
@ThomasPornin It sure is. That's one I haven't seen before.
LOL they did a good scam the scammers here in Belgium which involved a meeting with a Nigerian to buy gold. They even threw in a midget on a pony dressed as a cop
15:54
@Lucas I see you've reptrained
16:19
Chou Chou
17:18
Hwahahahahahaha! I ninjad the bear!
@Adnan Yeah, but you forgot half of the answer.
You pointed out that it was stupid; you did not say that it was dangerous.
@ThomasPornin True, that's why I upboated yours.
@ThomasPornin Do you think I should edit that part in the answer? (saying it's dangerous)
Hmm.. I think your answer will eventually get most of the votes anyway.
@Adnan Because that's my answer, because it is a better answer, or because that's the way the Universe works in general ?
@ThomasPornin Because it's a better answer.
Plundering other answers is considered acceptable warfare. I would not mind.
17:25
that Notes question brought back memories from the days when I used it
@GreenFly Oh, I see you wrote an answer as well.
@GreenFly Did you like it?
@Adnan I think it was horrible
@GreenFly I used it before it was Notes, back when it was Lotus ccMail. It was just as horrible then.
An amazing waste of god damn time.
It took 3h30 for the ownership change for the car.
Just came in at work (it's 13h30)
@Xander I cannot agree more. that product is awful
17:34
@Simon So you tell the time the same way you tell periods of time?
@Xander It was worse.
When you received a signed email with S/MIME, you got a cryptic popup with a non-understandable sentence (the kind of English you get after three or four layers of Google-translate). If you say no, you don't see the email. If you say yes, the signer's certificate is registered as trusted unconditionally, forever.
@ThomasPornin Well that's exciting. I didn't ever run into that, but even for the unencrypted every day use, it was only slightly more fun than poking your eye out with a stick.
@Adnan <seriousFace>Are you being funny?</seriousFace>
@Simon No. I think it's ridiculous that you said "It took 3h30" and then "it's 13h30"
I can accept xxhxx to denote periods of time. "We stood there for 1h30".
But using the same format to tell time is weird
@ThomasPornin Hmm, I just got a Nigerian scam via Google Calendar too.
17:44
@Adnan Human languages are weird. Deal with it.
@Rod wpa aes still uses tkip, it just replaces the rc4 with aes
@RodMacPherson With the wicked Uncles, too ?
@ThomasPornin Yup, here we go. French Canadians standing together
"We stood there until 1h30" is confusing.
@Adnan It is confusing if you do not speak English, yes. Otherwise it is quite clear.
No, this was mine:
"RELIABLE PARTNER NEEDED

Hello Sir/Ma,
PLEASE REPLY ME WITH THIS EMAIL ADDRESS [email protected]
I need your assistance to validate your name in our Bank System to enable the Bank transfer the sum of $10.5Million unclaimed fund into your nominated bank account to your account for onward investment ( Hotel industries and Estate building management) or any profitable business in your country and I will give you 40%, for your assistance.
My questions are?

1. Can you handle this project?
17:46
We stood there for 1h30: duration.
We stood there until 1h30: instant.
@ThomasPornin So people actually use that? Today is the first time I see it.
@Adnan There are a lot of representations for times: 1h30, 1:30, 1h30m,...
@Simon So, why did it take that long?
@Adnan You get to a certain age...
We stood there until 1h30 to mea means we stood there until 1:00 am
sorry 1:30 am
17:49
In "correct" English we would write: "we stood there until half past thirteen".
ALRIGHT ALRIGHT. It took a shitload of time and I arrived at work at ONE PAST THIRTY
@Adnan A lot of misunderstanding/confusion.
@ScottPack What takes so long when one becomes your age! TELL ME!
@Simon So now you're officially a car owner?
The ex-owner (woohoo, I'm the owner!) didn't specify exactly what was his plan to the dealer.
So, we paid up in time.
one past thirty??? What planet are you on? my clocks don't go to 30:01
@Simon Now THAT is an achievement. Not everybody can reach the hour 30 on a planet with 24 hours per day.
17:51
@Simon CONGRATS!!!!!
EFUIHSUIFHDSIUFSDHF
@Simon To celebrate, wanna see a picture of my legs?
I'M GONNA HAVE LUNCH AND THEN START HAVING A DISCUSSION IN HERE.
@Adnan It's my second car actually but yes!
@Adnan Sure.
Although I heard of a lawyer would once could bill 29 hours in a single day of work, because he took a plane from London to New York that day, and worked in the plane.
17:52
@Adnan Is that a shark on the right?
@Simon After seeing that, now go have your lunch!
@Simon No, it's not a shark. I'm just happy to see you.
Hmm.. not many fans of hairy legs, I see.
I'm so hungry that I'd eat a bear.
@Adnan You call that "hair" ?
01:00 - 18:0018:00 - 23:00

« first day (984 days earlier)      last day (4194 days later) »