| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Jostein: I could do some skanky women though...
<1> hehe
<2> hey kids
<0> there is a cop living in my building, so *** outside the door probably is a no-no
<1> wlfshmn: as long as you dont go raving for months when you leave them :P
<0> Jostein: raving?
<1> on irc. for months. after breaking up with your GF^Wone-night-stand :P
<0> oh -that- sort of raving
<3> hello all
<0> Jostein: I imagine I w ould be prone to that sort of raving a bit when brekaing up with one of the really good girls..
<0> Jostein: those are few and farr between though
<3> i need to forward GRE protocol on my Suse box
<3> any idea is welcome
<3> i use susefirewall2
<0> Jostein: there are three in my book that fit that description so far..
<4> exworks: www.iptables.org / "man route".
<0> Jostein: damn them for not setteling for me ;)
<4> exworks: lesson 1: Drop the gui crap.
<1> wlfshmn: heh. so far Ive successfully found one of them good girls that was good for about a year :P
<1> wlfshmn: after that the story turns about 180 degrees and I will have to use reverse smileys >:)
<5> Nanuq: yeah, i seen that last night
<0> Jostein: yeah.. last one of those was urk.. hmm. four years ago..
<0> it ought to be time for another one of these days, statistically
<1> well, yeah. same here. except I dont get out enough
<2> ****ers
<4> syn-ack: yeah!
<1> plus, it was waaay easier finding a girl while studying than working
<2> Lion-O: I love you.
<2> :)
<3> my pptp server is behind suse box
<1> working in IT really doesn't help the "meeting girls" thing
<4> syn-ack: hehe :P
<0> Jostein: I've noticed ;)
<1> ey syn-ack
<3> i've been used following rules
<3> iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 1723 -j DNAT --to SERVER_IP
<3> iptables -t nat -A PREROUTING -i eth0 -p 47 -j DNAT --to SERVER_IP
<4> exworks: don't paste crap into the channel please.
<1> exworks: pastebin for that kind of stuff
<0> Jostein: gotta get myself fired so I can go back to school ;)
<3> but no luck
<1> wlfshmn: lol
<4> exworks: iptables doesn't take care of routing.
<6> wow, gotta love a tool that uses - and -- for switches
<0> Jostein: except by now, I'm the old guy ;)
<1> heh
<1> wlfshmn: you can hit on the girls in the cafeteria or in the administration :P
<4> exworks: you /could/ use nat but why bother? Usually you'd use gre for tunneling and such.
<1> wlfshmn: theres probably a ton of secretaries too!
<1> exworks: you know PORT 47 and PROTOCOL 47 are 2 different things, right?
<3> are different..my rule user protocol not port
<3> whatch corectlly pls
<2> oooooh
<1> thus the "shuts up" part :P
<4> exworks: kindly can the attitude.
<2> Jostein: I just love how he told you to pay the **** attention. Thats funny.
<1> syn-ack: yeah
<5> Jostein: i work in i.t. and i meet plenty of girls
<5> there's ***loads of 'em runnin' around all over campus right this moment, preparing for the start of cl***es
<2> jgaddis: You're a whore and we all know it. :p
<1> jgaddis: only girls I meet at work are the useless ones, which also happen to have BFs. and old women trying to keep up in IT
<5> syn-ack: as much as i can be
<0> Jostein: no cafeteria, and virtually no secretaries or administrative staff. thats all outsourced
<2> Jostein: A boyfriend can be taken care of you know...
<1> wlfshmn: thats just plain stupid
<5> Jostein: i like the women who have boyfriends
<0> Jostein: true, but then, thats uss
<5> they already have a commitment, so they dont usually want one from me
<5> they just want to have a good time
<7> hey JJ, syn, re wlf, Jeremy
<1> jgaddis: by proxy, I hate you too :P
<7> Lion-O
<5> Jostein: heh
<5> eric
<0> Jostein: I requested new hardware today btw.. showed the boss that I was 1.25GB deep into ram, of which I only have 1.0 of, and the CPU fairly pegged as a result..
<7> now where's db2 at?
<2> Jostein: they also want the "gift that keeps on giving" too.
<4> Nanuq: he left not too long ago. Knowing him he'll be back shortly ;)
<2> Hey Eric
<1> hey Nanuq
<0> Jostein: he said they were evaluating if we needed better hardware or not and he would get back to me once the trials were complete
<0> Jostein: so yeah.. go figure
<5> y'know, for not being at work much this week, i've sure accomplished a helluva lot
<1> wlfshmn: heh. that ****s
<0> Jostein: I'm considering working from home more, where I can use my personal hardware to get work -done-
<1> wlfshmn: lol
<1> wlfshmn: thats what they want. make you pay for the hardware they need
<0> Jostein: and this more powerfull home computer is the one I'm planing on -replacing- at home ;)
<5> speaking of personal hardware, i need to "find" a floppy drive to take home
<3> is anybody that accomplish that? to forward GRE [47] protocol on a suse box, with susefirewall2 active?
<7> jgaddis: to "liberate" ?
<5> exactly
<0> Jostein: yeah, but if I work form home, I'll onyl be in the office on mondays and maybe tuesdays. other days i'll go nowhere near the place
<1> Nanuq: *grin*
<7> Jostein: Well..
<7> Jostein: I was able to run that top 20 query without postgres going ape****
<4> exworks: hopefully you /do/ realize that the susefirewall is but a frontend to iptables and iproute ? A rather crappy one at that.
<7> Jostein: well, the kernel going ape**** over postgres
<1> Nanuq: that word has so much bad karma going for it right now. I just love it!
<3> yes i do
<7> Jostein: which, liberate?
<0> anyway, I'm off to stare idely at the tv
<1> Nanuq: yeah
<4> exworks: SO, once again: this is possible, look into iptables (www.iptables.org) and route / iproute. RTFM.
<1> Nanuq: so... how long did it take?
<5> well, that was easy enough
<7> Jostein: sec
<7> Jostein: 14962 seconds :P
<5> Nanuq: damn, what was the query?
<1> Nanuq: heh. my 104 seconds beat you by magnitudes!
<7> Jostein: four hours
<1> jgaddis: SELECT Query, COUNT(Query) AS Counter FROM logs GROUP BY Query ORDER BY Counter
<1> jgaddis: on 40 million rows
<7> select count(query),query from queries group by query order by count desc limit 20;
<1> jgaddis: the AOL logs :P
<5> heh
<7> Jostein: postgres seems to use seqscans for any LIKE clause
<7> Jostein: but the = operator, it uses the index
<1> jgaddis: my 832MHz managed to do it in 104 seconds
<3> ok but this is a hint..not a solution
<5> i could run it on mysql, pgsql, and mssql
<3> i'll already read about
<4> exworks: if you think we're going to hand you a working solution you're in the wrong channel.
<1> exworks: yes, that is true. you will have to work for your solution yourself
<1> jgaddis: I did MSSQL, Nanuq Postgre
<1> jgaddis: you do MySQL
<4> exworks: sure you did. and you could only come up with 2 unrelated iptable rules? get real.
<5> Jostein: my mysql box isn't very beefy
<5> Jostein: it's only a 933mhz and it's at about 90% load 24/7
<7> LOG: statement: select * from queries where query = 'huge tits';
<7> LOG: duration: 905.805 ms
<1> jgaddis: I did it on a 832MHz P3
<1> jgaddis: ow
<5> i got a couple of new dl320 and dl385's though
<1> Nanuq: well. that is an EXACT match. no fun
<7> Jostein: yeah like I said, LIKE clauses..
<1> Nanuq: you need LIKE '%huge%tits%'
<7> I should also try Thunder Bird
<7> Jostein: hrm
<5> dl320's are dual 3.4ghz w/ 1gb and the dl385's are dual opteron 2.8's or some such with 4gb
<7> Jostein: ****in' 'ell
<5> there's a 16 way oracle box around here, but i stay the hell away from that
<3> hm...the problem is real even if you dont wanna believe
<3> i/ve been searching and found maby admins stuck on it
Return to
#linux
or
Go to some related
logs:
Lelä
#c++
#AllNiteCafe
#php
imadthemad
#MissKitten
#london
#MissKitten
#php
#mysql
|
|