« first day (1722 days earlier)      last day (3288 days later) » 

nhinkle
nhinkle
12:27 AM
Anybody else suddenly having to hit enter twice or click the search button when typing google queries directly into the address/search bar?
 
Bob
Bob
12:37 AM
@nhinkle You're going to have to be more specific. There's a lot of address bars out there.
I'm not even using the vanilla FF one.
 
nhinkle
nhinkle
Sorry, meant to specify Chrome
The chrome unimagicallinonebar
 
Bob
Bob
Ah. I don't actually use Chrome, soooo :P
gimme a sec
@nhinkle norepro, search term "test".
Disable any addons and try again?
 
nhinkle
nhinkle
Hmm
Odd thing is it's on two computers, though I do have chrome sync. I'll try without addons.
OK well it works in incognito mode right so it probably is an addon.
O_o
wtf
it just started working again...
I swear I'm not crazy!
 
Bob
Bob
@nhinkle That's what they all say :P
 
nhinkle
nhinkle
wtf now it's broken again
:'(
 
Journeyman Geek
Journeyman Geek
12:46 AM
superuser.com/questions/905419/… horrible question - but the funny thing is I'm pretty sure its an asus and MS airbrushed out the logo
hm
@nhinkle: someone on irc is reporting having issues with instant search
 
HackToHell
HackToHell
1:26 AM
@DragonLord I am using pool.ntp.org and my time was 6 seconds behind :
My phone was only 0.2 seconds off
 
Bob
Bob
> Your clock is 16.1 seconds ahead.
Work computer. That's actually pretty good, considering it was a full 5 mins ahead last year.
(part of a domain so it syncs time from the DC)
 
Bob
Bob
1:45 AM
heh
 
Michael Frank
Michael Frank
2:27 AM
@JourneymanGeek It is a bad question, but a nice looking Laptop. Could be a stylish EEE series.
@nhinkle You mean the omnibar?
@Bob The fact this has /b/ is the url made me giggle.
 
nhinkle
nhinkle
@MichaelFrank yes that
 
Michael Frank
Michael Frank
@nhinkle Personally, I think your name is better :P
How do I apply a transforms script to an MSI install?
 
Bob
Bob
2:54 AM
Simple answer: you don't.
MSI is a nice concept, and generally pretty great for the user... a pain in the arse for the creator though.
The tools are terrible.
You do something or other with WiXEdit, I guess.
 
Michael Frank
Michael Frank
@Bob bleh...
 
Journeyman Geek
Journeyman Geek
3:55 AM
@MichaelFrank I can see the asus airbrushed out. And the right side port layout is what I see on my HP stream
 
 
2 hours later…
Journeyman Geek
Journeyman Geek
6:17 AM
 
Boris_yo
Boris_yo
6:31 AM
OMNI is a keyword. Are they god-like? You know - omnipresense?

There were such laws in past in USA?
@Psycogeek Back then buying competition was limited to city level and as laws kept being overwritten it grew to state and now country/international level?
Nobody is smart enough to answer this question?
0
Q: Why Sometimes Playback of Music Is Slow on Flash Media?

Boris_yoI have SanDisk Sansa MP3 player, smartphone etc. all those mobile flash-based storage devices to playback music I love to listed and I always wondered one thing. Why sometimes music plays slow and sometimes which feels like at normal rate? This never happened with my desktop and laptop that uses ...

mp3-player smartphone music-streaming
 
Journeyman Geek
Journeyman Geek
OT? ;p
Tho, I'd suspect its to do with processing power.
 
Boris_yo
Boris_yo
@Psycogeek Too late for what?
@JourneymanGeek OT?
 
Journeyman Geek
Journeyman Geek
off topic
 
djsmiley2k
djsmiley2k
7:10 AM
A bug with deciding the bitrate
?
 
Journeyman Geek
Journeyman Geek
TIL - the space X landing barge is called "Just Read The Instructions" space.stackexchange.com/questions/8868/…
 
Bob
Bob
List of spacecraft in the Culture series
This is a list of spacecraft found in the Culture novels and short stories by Iain M. Banks. Most ships in this list are members of The Culture, the hybrid society featured in many of these novels. In this setting, each Culture ship, and some others, is also an artificial intelligence with a distinctive personality. Many of these ships are significant characters in the novels. == Naming == The machine intelligences called Minds (and, as a consequence, the Culture starships that they inhabit) usually bear names that do a little more than just identify them. The Minds choose their own names, and...
 
Journeyman Geek
Journeyman Geek
Ahh, yeah.
 
djsmiley2k
djsmiley2k
rofl
 
Journeyman Geek
Journeyman Geek
7:26 AM
I shoulda been aware of that. The culture series is on the list
 
Bob
Bob
7:41 AM
@JourneymanGeek The list?
 
Oliver Salzburg
Oliver Salzburg
So I heard back from the client for whom I bought the Cinch-USB cable
He connected his camera to his laptop, using the cable, and Windows actually popped up a warning regarding voltage
And then the machine froze
 
XKCD
XKCD
 
djsmiley2k
djsmiley2k
8:12 AM
heh :D
@OliverSalzburg I googled that because I don't know what it is, and it came up with the easycap adapters I use for my pi.... what exactly is up with them, drawing too much voltage?
 
Journeyman Geek
Journeyman Geek
@Bob: The list ;p
(movies games and videos I need to play/read/watch. Not always in that order)
 
Oliver Salzburg
Oliver Salzburg
@djsmiley2k We're pretty sure that whoever made the cable just put a USB plug on one end to save space. It has nothing to do with standard USB
 
Journeyman Geek
Journeyman Geek
Nope ;p
And so they could buy standard connectors ;p
 
Oliver Salzburg
Oliver Salzburg
Also, I can't get my additional mouse buttons to work with the vertical mouse at work either :\
 
djsmiley2k
djsmiley2k
ah, lol, not the same as my easycap then :D
 
Journeyman Geek
Journeyman Geek
8:21 AM
Do they get detected?
 
Oliver Salzburg
Oliver Salzburg
@JourneymanGeek How can I tell?
The mouse only installs as an HID-compliant mouse
 
Journeyman Geek
Journeyman Geek
hmm
I know how to do this in linux ;p
 
Oliver Salzburg
Oliver Salzburg
The buttons also don't work on another computer
Maybe they just broke
 
Journeyman Geek
Journeyman Geek
or were never wired up
 
djsmiley2k
djsmiley2k
was gonna say
they aren't even buttons. you sure they arent' painted on? ;)
 
Oliver Salzburg
Oliver Salzburg
8:26 AM
Heheh
 
Journeyman Geek
Journeyman Geek
 
Oliver Salzburg
Oliver Salzburg
Yeah, they worked fine when I originally installed the mouse at home
They stopped working at some point. I thought that was related to installing additional software for another device
 
Journeyman Geek
Journeyman Geek
could have broken ;p
 
Oliver Salzburg
Oliver Salzburg
Alright, they're sending out a replacement
Pretty cool
 
djsmiley2k
djsmiley2k
\o/
 
Oliver Salzburg
Oliver Salzburg
8:34 AM
I call them: "Hey, my mouse buttons don't work" Answer: "Yeah, we'll send you another one. No charge."
A lesser me would take advantage of that
 
Journeyman Geek
Journeyman Geek
lol
 
djsmiley2k
djsmiley2k
:D
 
Journeyman Geek
Journeyman Geek
Are you going to take apart the old one to see what's wrong? ;p
 
Oliver Salzburg
Oliver Salzburg
8:49 AM
@JourneymanGeek I guess I could
But I doubt I'll be able to see anything. Or open it without breaking it
 
Journeyman Geek
Journeyman Geek
;p
 
Bob
Bob
9:07 AM
@OliverSalzburg That would be extremely weird.
 
Oliver Salzburg
Oliver Salzburg
@Bob Yeah, I know
But it's a made-in-China product with a, I assume, 90% markup. It's not unheard of that it's not the highest quality
It's not often that I'm presented with a "We send you a new one, throw the old one in the trash" mentality when there are high quality products involved
 
Bob
Bob
@OliverSalzburg Made in China itself doesn't necessarily mean anything, considering most products at any quality are made there now.
It's up to the company to perform QC.
 
Oliver Salzburg
Oliver Salzburg
 
Bob
Bob
@OliverSalzburg I said perform QC, not purchase a roll of stickers and slap them on.
 
Oliver Salzburg
Oliver Salzburg
:D
 
Bob
Bob
9:13 AM
> Mouse Wireless, optical
> Works reliably on most surface
Ok, when a company can't be bothered hiring someone to properly translate and proofread labels, then there's a problem.
It's not that expensive, especially for so little text...
 
Oliver Salzburg
Oliver Salzburg
The German translation on amazon.de is better
The "often purchased together" seems like bullshit though
People bought the wireless and the wired one
 
Bob
Bob
@OliverSalzburg If they can't put the effort into the translation on the physical mouse, I don't really care how polished the website is.
 
Oliver Salzburg
Oliver Salzburg
Someone rated it 1 star because "it doesn't glow blue like on the product photo"
 
Journeyman Geek
Journeyman Geek
That's important!
 
djsmiley2k
djsmiley2k
It could be...
 
Bob
Bob
9:46 AM
@allquixotic @JourneymanGeek ^
Interesting results. Especially the benchmarks.
They went eMMC...
 
Oliver Salzburg
Oliver Salzburg
@Bob The front-facing camera picture sells the whole article
 
Bob
Bob
lol
 
Michael Frank
Michael Frank
front facing cameras never give a good angle...
 
Bob
Bob
(benchmarks are on the second page)
 
djsmiley2k
djsmiley2k
that picture scared me ;)
On another note.... if you can't read a language, how do you valid the ability of a translator?
@Bob in response to
 
Oliver Salzburg
Oliver Salzburg
10:04 AM
So I'm currently deploying Sophos Endpoint Protection for a client, which is already creating a stream of WTFs
Obviously, not even the setup would complete without errors. SQL Server Express wouldn't install, had to do it manually
Now I got the fucking console running and I try to install the client components on a test workstation and, obviously, it fails
So I'm being directed to a knowledgebase article, which results in a 404 O___o
And I only get the 404 on my desktop. On the management server itself, the result is even better
But I guess that's to blame on IE and/or policies
 
Michael Frank
Michael Frank
@OliverSalzburg Not even slightly related... But I had to oversee a Fuji Xerox tech while he installed and SQL Server and set up two client PCs so one of our departments could get their document scanning workflow back up and running after a building change... It took a week and a half.
Literally me just sitting there making sure he wasn't messing with our network.
 
Oliver Salzburg
Oliver Salzburg
Jeeze
I bet it took him so long because he didn't want to mess up in front of you ;D
 
Nick
Nick
10:22 AM
Mhh guys, I'm trying to install PHP and I'm getting an error, "msvcr110.dll not found". What's the easiest fix for this? (without breaking my computer)
 
Michael Frank
Michael Frank
msvcr110.dll is part of a Microsoft Redistributable... Should be fairly easy to find.
 
Nick
Nick
@MichaelFrank I've always wondered, why do I need Visual Studio files when I'm not making any applications. Isn't Visual Studio just an IDE for GUI apps?
 
Michael Frank
Michael Frank
@Nick It's so you can run programs created with VS.
Like when you install a game and it requries a specific version of DirectX.
If you have a rather large Steam library, you get LOADS.
 
djsmiley2k
djsmiley2k
yey I answered something \o/
 
Nick
Nick
@MichaelFrank Mhh, interesting. Maybe one day in the future, end users wouldn't need to concern themselves with this.
 
Michael Frank
Michael Frank
10:29 AM
@Nick Normally you shouldn't need to worry about it...
I didn't install any of those Redists. That was all handled by the software installers.
 
Nick
Nick
@MichaelFrank I downloaded the missing .dll file individually but I'm unsure where to put it. System32?
 
Michael Frank
Michael Frank
I... wouldn't download the .dll directly. Get the entire redist install.
 
Oliver Salzburg
Oliver Salzburg
Heh, seconds too late ;D
 
Nick
Nick
@MichaelFrank ohk :( I'm running at a really slow connection here though. Thankfully these files aren't that large.
 
Michael Frank
Michael Frank
@Nick Yea, downloading random DLL files is not a great idea unless you know exactly what you're doing.
Could be all sorts of nasties in there
 
Nick
Nick
10:34 AM
@MichaelFrank I never know what I'm doing but recently since I came to this room, I've started learning.
@MichaelFrank This seems so redundant. Why have so many of those?
 
Michael Frank
Michael Frank
@Nick It all depends on what version of Visual Studio the software was created with.
Anyway... Sleep time for me. Gotta be up in 7 hours for a dawn service.
 
Nick
Nick
@MichaelFrank eep. So, vs2012 won't support vs2008 guys. what is that? Some kind of de-appreciation of the old?
@MichaelFrank Goodnight, buddy :D
 
Oliver Salzburg
Oliver Salzburg
11:15 AM
That moment in a support chat/call when you realize the guy on the other end of the line has less of a clue than you do :\
> Here's a knowledgebase article I just pulled out of my ass from Google, does that solve your problem?
 
Journeyman Geek
Journeyman Geek
Lol.
 
djsmiley2k
djsmiley2k
11:29 AM
that moment you realise teh guy on the otehr end of the phone knows more than you do
wait. what
D:
 
djsmiley2k
djsmiley2k
11:47 AM
never mind :(
 
Bob
Bob
@Nick 2010/2012/2013 share a solution format. older versions will require a solution upgrade
it's a fairly seamless process - just load it up and hit go
oh, you're talking about the runtime library
that's a different matter
 
Oliver Salzburg
Oliver Salzburg
12:06 PM
The pleasures of internationalized software :\
In case you're thinking, "I can't read German". It doesn't really matter, I'm guessing myself
 
Journeyman Geek
Journeyman Geek
lol
 
HackToHell
HackToHell
12:26 PM
Blah this WMI refuses to change the IP
Doesn't work from Powershell wither
 
Oliver Salzburg
Oliver Salzburg
So I'm installing that Sophos Endpoint Protection remotely on a workstation and it disables RDP
Sweet
Because security
Is crap like this only happening to me or is this by-design?
 
djsmiley2k
djsmiley2k
lol
 
Journeyman Geek
Journeyman Geek
yes
 
Adrian Frühwirth
Adrian Frühwirth
12:53 PM
not just you, but since I'm a Linux guy primarily Windows enjoys mocking me whenever I have to fix crap on a Windows box :-)
the fact that it says "Sicherungspriorität" on the left but "something something - Priorität" on the right is mildly infuriating. Should read "Sichern - Priorität" or "Wdhst./Vergleichspriorität" to account for us with OCD ...
just another reason not to use shitty German localizations
 
Journeyman Geek
Journeyman Geek
lol
 
Adrian Frühwirth
Adrian Frühwirth
or "Wdhstgs.", rather :D
 
Journeyman Geek
Journeyman Geek
bless you ;p
(cause that sounds like something I'd sneeze out when i have a runnier nose than usual)
 
Adrian Frühwirth
Adrian Frühwirth
1:10 PM
which is why localized software is bad. it makes German look like a non-language/Finnish :P
 
Oliver Salzburg
Oliver Salzburg
1:21 PM
In this one menu, they have an item that has the German word for "encryption" on it. I open it up and it becomes immediately apparent that the original word was "encoding"
"Oh, you want to encrypt in UTF-8?" Yes, please!
And when you have to call support and you get some Indian guy who gets assigned to you because he knows German as a third or forth language and you have a horribly localized software…
That's the jackpot
 
Adrian Frühwirth
Adrian Frühwirth
oh gawd
well to be fair, it doesn't really matter if you communicate in English or German with Indian support ...
it's a mess either way
only 768 results, would have expected worse to be honest :)
 
Journeyman Geek
Journeyman Geek
2:03 PM
The stuff a 10K user sees...
 
Adrian Frühwirth
Adrian Frühwirth
2:20 PM
I...wat
care to link the question?
now I'm curious :)
 
Journeyman Geek
Journeyman Geek
0
Q: Why does “U0001f60e” come up in various online text?

user425969I’ve seen this a worrying number of times as of late, people will write a comment and it'll end in U0001f60e or I’ll just be reading an article and U0001f60e appears in it at seemingly random points. I can only speculate this is some sort of Unicode decoding thing, but I can’t seem to find any ...

html text unicode
 
Oliver Salzburg
Oliver Salzburg
The day is nearing its end and I have a working SQL Server transaction log backup strategy and I can remotely install Sophos Endpoint Protection to the clients workstations
 
Journeyman Geek
Journeyman Geek
(Well, I'm a mod so I see everything there is to be seen, other than the stuff that I can't see, but..)
 
Hennes
Hennes
@JourneymanGeek You have done the NSA backdoor ?
 
Oliver Salzburg
Oliver Salzburg
Is this old? Search for "Takht Pari Forest" on Google Maps
 
That Brazilian Guy
That Brazilian Guy
2:47 PM
halp HALP HALP HhHhAaAaAlLlLpPpPp!!!!111111one
0
Q: MySQL connection works on CLI , but not on Workbench

That Brazilian GuyI can connect to a running MySQL instance just fine if I use the command line. [user@local ~]$ ssh [user]@[host] -p [port] [user@host ~]$ mysql -u [db-user] -h 192.168.x.x -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is [i...

mysql mysql-workbench mariadb
 
HackToHell
HackToHell
What's a good data structure to store a list of <number,string> mappings ?
The list is large (>5k) entries and has to be sorted at every insertion
 
allquixotic
allquixotic
@HackToHell A Java HashMap (Dictionary in C#, Hash in Ruby, etc.) should suffice; you can manually sort it when you need it to be sorted. If you're reading from it from multiple threads while it's being written to, you'll need to use a thread-safe variation, or else it might not be sorted when you read from it.
 
HackToHell
HackToHell
I was thinking SortMap
 
allquixotic
allquixotic
A TreeMap in Java is always sorted so you don't have to manually call a sort on it after adding, but if you're adding a lot of individual items and you don't have to have it sorted in between, that's costlier than a HashMap
 
HackToHell
HackToHell
@allquixotic Any advantages of HashMap over normal map ?
 
allquixotic
allquixotic
2:57 PM
@HackToHell what language are you using?
 
HackToHell
HackToHell
Java
 
allquixotic
allquixotic
there is no such thing as a "normal map" in Java; Map is an interface, not an implementation. You can't instantiate Map.
 
HackToHell
HackToHell
646
Q: How to sort a Map<Key, Value> on the values in Java?

AbeI am relatively new to Java, and often find that I need to sort a Map<Key, Value> on the values. Since the values are not unique, I find myself converting the keySet into an array, and sorting that array through array sort with a custom comparator that sorts on the value associated with the key. ...

java collections map
 
allquixotic
allquixotic
Map doesn't do anything; it's just a specification of an API.
SortedMap is an interface, too.
 
HackToHell
HackToHell
Oh ... right facepalm
 
allquixotic
allquixotic
2:59 PM
you have to look for a concrete implementation of one of those interfaces, such as HashMap or TreeMap or ConcurrentSkipListMap.
ConcurrentSkipListMap is only recommended if you have multiple (>2) reader and writer threads, because it imposes some overhead that makes it very inefficient in a single-threaded case
if you are single-threaded then you should be able to use HashMap (which is not sorted unless you sort it), and then manually sort it before you start reading from it.
TreeMap is simpler because in the single-threaded case it's always sorted (.put() blocks until the sorting is complete), so you don't have to sort it with an additional method call, but it's pretty slow if you're calling put() many thousands of times, compared to a HashMap.
 
HackToHell
HackToHell
Okay, HashMap it is
I'll switch to tree map after putting in all the values
Since I'll only be using it after all values are inserted
 
allquixotic
allquixotic
funny fact: I took a 400-level computer science class with the man who invented the Skip List, which is the data structure that's key to the ConcurrentSkipListMap
nah, don't "switch to a TreeMap"
actually, that's probably fine
I think when you do new TreeMap<K,V>(Map<K,V>) the TreeMap will internally call putAll(), which first inserts all the elements, and then sorts them, for a slightly better runtime than inserting each element and sorting individually
you just want to avoid iterative sorting because a sort with log(n) complexity then becomes n*log(n) if you're sorting each time
HashMap has an expected complexity of O(1) on put(), whereas TreeMap has a complexity of O(log(n)) for put().
 
HackToHell
HackToHell
Oh
I'll check the timings with each implementation
Should be fun :D
 
allquixotic
allquixotic
3:20 PM
William Pugh
For the 17th century Welsh poet, see Gwilym Puw. William Worthington "Bill" Pugh Jr. (born 1960) is an American computer scientist who invented the skip list and the Omega test for deciding Presburger arithmetic. He was the co-author of the static code analysis tool FindBugs, and was highly influential in the development of the current memory model of the Java language together with his PhD student Jeremy Manson. He is currently a professor emeritus of computer science at the University of Maryland, College Park, and also sits on the technical advisory board for Fortify Software. == External... ==
nice guy; fun class
 
HackToHell
HackToHell
Blah JSOUP isn't handling a 30mb html page well :/
 
allquixotic
allquixotic
30 MB of HTML? what in the actual fuck
 
HackToHell
HackToHell
Tell that to facebook
Exporting data from facebook gets you that
 
allquixotic
allquixotic
@_@
anandtech.com/show/9177/the-gigabyte-p35x-v3-review I'll probably get the next generation after this one with Skylake and Maxwell+1 (hopefully DDR4). @Bob Could it be that the Skylake generation could be the convergence I've been wanting for years? NO desktop; just a laptop I can carry with me anywhere?
(referring to the one that is likely to come after that one linked above): I'll throw 32 GB of DDR4 in it, and have them ship it with the cheapest possible storage options, then replace the base storage with 4 x 1 TB Samsung 850 Pros, which should be down in price by then
 
Bob
Bob
@allquixotic o.O
 
allquixotic
allquixotic
3:35 PM
should have faster memory and CPU than my desktop, and maybe about the same perf from a single mobile GPU as my two HD7970s combined, and way faster storage system
for capacity, I'll just have to suck it up and delete some of those huge video captures, or connect up a 4 TB USB-C external drive for bulk storage of video
but seriously, I'm pretty sure the 980M can run Star Citizen well, and whatever comes after it will be able to run it really well
 
HackToHell
HackToHell
Blah for some reason map.put doesn't take in all the values
map.put it called 292 times but it has only 112 elements
 
Bob
Bob
keys must be unique
 
HackToHell
HackToHell
ooooh
right
Why doesn't it throw an exception :/
 
Bob
Bob
either use a list of pairs/tuples and sort between insert and queries
 
allquixotic
allquixotic
@HackToHell because it replaces the value with the value you put -- some people actually want that behavior
 
Bob
Bob
3:41 PM
or use a priority queue of pairs/tuples, which will maintain sorted order
@allquixotic "some people" => the primary use of a map
 
HackToHell
HackToHell
Java doesn't seem to have anything for that
Blah
 
allquixotic
allquixotic
if you want it throw an exception, write something like this: 
class AnalDuplicateKeysMap<K,V> extends TreeMap<K,V> {
public V put(K key, V val) {
if(this.containsKey(key)) { throw new IllegalArgumentException("Key " + key.toString() + " already exists in the map!"); }
else { super.put(key, val); }
}
}
 
HackToHell
HackToHell
> AnalDuplicateKeysMap
#k
 
allquixotic
allquixotic
if you need the ability to have a Map-like data structure where the keys are not unique, you can use something like TreeMap<Integer, List<String>> and maintain a new LinkedList<String>() for each unique key being added
 
HackToHell
HackToHell
Hmm i'll just add a random number to the keys that are not unique
Easier
 
allquixotic
allquixotic
3:49 PM
O_o
what is the meaning of the numbers?
 
HackToHell
HackToHell
Nothing ;p
It's just to make sure it gets inserted
 
allquixotic
allquixotic
you could use that if you're too lazy to code but not lazy enough not to pull in dependencies
 
HackToHell
HackToHell
4:15 PM
I should convert this html into something easier to hadle
@allquixotic Okay thanks !
hmm JSON or CSV ?
 
allquixotic
allquixotic
did you figure it out @ThatBrazilianGuy ?
you can try manually doing the SSH port forward to your local system, then diagnose the SSH tunnel from there
 
That Brazilian Guy
That Brazilian Guy
@allquixotic No, I didn't.
 
allquixotic
allquixotic
why did you delete it then?
 
That Brazilian Guy
That Brazilian Guy
I honestly don't remember.
The question is still up
@allquixotic That's a great idea
 
allquixotic
allquixotic
try ssh -L 3306:192.168.x.x:3306 blah blah on your local system, then after you're logged in, try both workbench and the mysql client, to localhost:3306
(the workbench config in that case will have to be direct connection)
 
That Brazilian Guy
That Brazilian Guy
4:27 PM
@allquixotic Hm. The ssh host IP and the DB IP are different. I can't SSH to the DB IP.
 
allquixotic
allquixotic
don't ssh to the DB IP; ssh to the SSH host like normal
-L 3306:192.168.x.x:3306 means that on your local system, localhost:3306 will be routed through SSH, to the SSH server, which will then in turn contact the server remote to it, 192.168.x.x and forward packets back and forth on 3306
the difference between -L and -R is that, in the case of -L, the port being bound is on your SSH client's computer, and the the forward destination is relative to the SSH server
 
That Brazilian Guy
That Brazilian Guy
@allquixotic I suspect (not 100% sure) the db server only accepts tcp packets from the ssh server. Wouldn't that be an obstacle?
 
allquixotic
allquixotic
with -R, the port being bound is on your SSH server's computer, and the forward destination is relative to your SSH client
@ThatBrazilianGuy no, because the DB will see the packets originating from the SSH server
it's routed at layer 3, so the routing goes (assuming TCP):
if "A" is the computer you're typing on, "B" is the server you SSH to, and "C" is the server running mysql:
A -> B; B -> A; B -> C; C -> B; B -> A; A -> B
the back and forth is the TCP "acknowledgement" system -- overcomplicates it a bit in the diagram but that's how it works
if you simplify the ACKs then the path is simpler: A->B, then B->C, then C->B, then B->A
the mysql server C will see the source IP of all the incoming packets as the IP of your SSH server; it will have no idea that the person who originally composed the first packet was the computer you're typing on
indeed, no data within the packet would reveal that fact
 
That Brazilian Guy
That Brazilian Guy
> bind: Address already in use
 
allquixotic
allquixotic
you must be running a MySQL server locally then
 
That Brazilian Guy
That Brazilian Guy
4:34 PM
I have already a local mysql server using the defaulkt port
yeah
 
allquixotic
allquixotic
use a different local port
just change it
 
That Brazilian Guy
That Brazilian Guy
can I use a different local port?
ok
 
allquixotic
allquixotic
ssh -L 33000:192.168.x.x:3306
the first number before the colon is the port that's going to be bound on the computer you're typing on
since 3306 is taken, choose another
 
That Brazilian Guy
That Brazilian Guy
I assumed so, just wanted to check
 
allquixotic
allquixotic
of course, once you have the tunnel set up, you're going to have to connect the workbench and the mysql client using -p 33000
e.g.: mysql -u db-user -h localhost -P 33000 -p
capital -P means port; lowercase -p means I'm going to type a password
note, that mysql command should be run from your local computer, not in the ssh session
 
That Brazilian Guy
That Brazilian Guy
4:36 PM
YAY, workbench connection test works! \o/
 
allquixotic
allquixotic
yay.
 
That Brazilian Guy
That Brazilian Guy
@allquixotic I got that, at least :p
 
allquixotic
allquixotic
answer posted
I deal with SSH tunnels pretty much constantly; they are a key prerequisite of sanity when you work in an environment that requires an HTTP (80 or 443 only) filtering proxy which blocks tons of useful sites that are needed to get work done, and pops up an intercepting webpage when you download files over HTTP
basically when I need to work around IT preventing me from getting my work done, I use SSH tunnels (and other... techniques) to solve everyday problems, like, oh I dunno, installing a Ruby gem
 
That Brazilian Guy
That Brazilian Guy
@allquixotic But on CLI, I get an error: ERROR 1045 (28000): Access denied for user '[DB-USER]'@'localhost' (using password: YES). WTF is going on here?
 
allquixotic
allquixotic
if you need this ssh tunnel a lot, I would recommend that you wrap it in a script at the least, and maybe put it in a screen session
@ThatBrazilianGuy yup, because unfortunately MySQL keeps track of users by username and hostname
 
Vinayak
Vinayak
4:42 PM
user image
2
Avast knows nobody likes to restart their computers. Haha.
 
allquixotic
allquixotic
'newbie'@'localhost' is a different user (with different permissions, different password, etc.) than 'newbie'@'ssh-server'
@Vinayak awesome - I love that - "next century"
I wonder if they actually tested that by waiting a century and see if it would nag them
 
Vinayak
Vinayak
Haha. I doubt that :D
 
That Brazilian Guy
That Brazilian Guy
@allquixotic But why doest it work when I fill the workbench details using "localhost"? Isn't workbench just a GUI on top of a "mysql client of sorts"?
 
allquixotic
allquixotic
@ThatBrazilianGuy yes, but if you look under users, you'll probably see that you're logged in as 'newbie'@'%', or as 'newbie'@'ssh-server', because Workbench is using the MySQL client libs, and not specifying an IP address as part of your username; it's letting the MySQL server infer that from the source IP of the packets.
basically, if you tell the MySQL server "my name is 'newbie'@'localhost'", it will look for an account named 'newbie'@'localhost' -- and fail authentication if it doesn't exist or has a different password
if you tell the MySQL server "my name is 'newbie' and I'll be sneaky and let you figure out the host", it will look at the source IP of the IPv4/IPv6 packet and go from there
the source IP of the packet will be the SSH server of course, because that's where the packets originate from (regardless of whether it's the CLI or workbench)
 
That Brazilian Guy
That Brazilian Guy
> SELECT * FROM information_schema.USER_PRIVILEGES;
> '\'db-user\'@\'192.168.122.221\'', 'def', 'USAGE', 'NO'
 
allquixotic
allquixotic
4:52 PM
yep, so your user is @ the IP of the SSH server.
 
That Brazilian Guy
That Brazilian Guy
@allquixotic So how come this works?
Doesn't Workbench tries to transmit the "localhost" part?
(I used port 7777 instead of 33000)
Damn, I have to import an .SQL file. The "import" feature is just a frontend for mysql... That fails with the same error I see on the CLI.
> 13:53:52 Restoring /home/user/wp_security.sql.gz
Running: /usr/libexec/mysql-workbench/mysql --defaults-file="/tmp/tmpzycOGk/extraparams.cnf" --host=localhost --user=db-user --port=7777 --default-character-set=utf8 --comments --database=db-name < "/home/user/wp_security.sql.gz"
ERROR 1045 (28000): Access denied for user 'db-user'@'localhost' (using password: YES)

Operation failed with exitcode 1
That happens after I successfully logged in via the workbench GUI
;____________;
 
That Brazilian Guy
That Brazilian Guy
You know what? F!@# it, it's 2pm of a Friday, my boss told all the team to leave at 12:30, and it's been a week-long holiday holidays on tuesday and thurstay so offices are empty all week.
I really want to troubleshoot that, but I guess I'll have to go home play videogames instead
 
Bob
Bob
I haven't slept in 43 hours...
 
HackToHell
HackToHell
5:10 PM
!! tell bob sleep
 
ChatBot John Cavil
ChatBot John Cavil
@HackToHell Command sleep does not exist. (note that /tell works on commands, it's not an echo.)
 
HackToHell
HackToHell
!! define sleep
 
ChatBot John Cavil
ChatBot John Cavil
@HackToHell [sleep](http://en.wiktionary.org/wiki?curid=7442) (uncountable) The state of reduced consciousness during which a human or animal rests in a daily rhythm.
I really need some sleep.
We need to conduct an overnight sleep test to diagnose your sleep problem.
 
yilduz
yilduz
Seems like a very common thing for IT people to not sleep very well.
3
At my last job one of my primary functions was to wake up SysAdmins and CTI Admins in the middle of the night. They didn't like me very much.
 
Michael Frank
Michael Frank
@HackToHell You were trying to change an IP by WMI or Powershell earlier, what went wrong?
 
HackToHell
HackToHell
5:20 PM
@MichaelFrank No idea, it simply would not change
Even netsh interface ip .... command didn't work
 
Michael Frank
Michael Frank
Huh.. strange.
 
allquixotic
allquixotic
5:34 PM
@ThatBrazilianGuy I think you can specify --user=db-user@192.168.x.x on mysql cli
 
Oliver Salzburg
Oliver Salzburg
6:02 PM
@CanadianLuke Did you get xnph05q for your One yet?
Because it's not installing for me
 
Canadian Luke
Canadian Luke
6:19 PM
@OliverSalzburg yup, a while ago actually
 
Oliver Salzburg
Oliver Salzburg
@CanadianLuke Just got the update notification, but it's not working for me :\
 
Canadian Luke
Canadian Luke
Restart in safe mode and try out?
 
Oliver Salzburg
Oliver Salzburg
@CanadianLuke I'm downloading it manually now and I'll try and install it through recovery to get more details
 
Canadian Luke
Canadian Luke
Good luck, post your findings
 
Oliver Salzburg
Oliver Salzburg
> Hi Oliver,

Thanks for reaching out! We are terribly sorry about the inconvenience we've caused you. The CM12 update is currently on hold for system upgrade purpose.

You may ignore the prompt for the mean time as we update the system with our best.
 
Canadian Luke
Canadian Luke
6:59 PM
That's all?
 
Oliver Salzburg
Oliver Salzburg
7:54 PM
@CanadianLuke So far
 
Luke
Luke
8:10 PM
How bad is it when HDD fails SMART self-test?
 
Canadian Luke
Canadian Luke
@Luke Replace. Now. Backup your files, and replace. Now. Yesterday. Period
 
Luke
Luke
Files are safe
I usually don't have any extra-sensitive data on disk, because of reasons like that, and now I've managed to extract almost everything
Only reason I can think of is that since I upgraded my GPU, the PSU was struggling (it didn't seem to be 500W as it said on the label), and I could hear HDD spinning down now and then. But I don't remember doing any extra-heavy or long work since then and I don't think I've even turned on the PC in the past 7 days
 
Canadian Luke
Canadian Luke
8:38 PM
Interesting observation..
 
Luke
Luke
I expected to hear at least the head of the disk and the noise it should make before failing (idk how to say it in English)
 
Canadian Luke
Canadian Luke
If it has the "click of death", you wouldn't be able to read it, at all
 
 
3 hours later…
Journeyman Geek
Journeyman Geek
11:22 PM
humans are wierd
 
Psycogeek
Psycogeek
11:58 PM
they are really missing out on . . . the triangle
 

« first day (1722 days earlier)      last day (3288 days later) »