up_the_irons: ballen: should be enough ***: ballen is now known as ballen|away
nk has joined #arpnetworks nk: hello
can someone tell me if irc is allowed n the vp's up_the_irons: nk: hey nk nk: hello up_the_irons: nk: yeah, IRC is allowed, but if you get DoS'd I'll get mad ;)
and probably null route your IPs
nk: where'd you hear about us? :) nk: nah, just for my eggdrops never got ddosed on my other vp's
google it hehe
and on webhostingtalk up_the_irons: cool
nk: you should be fine then nk: :) up_the_irons: a lot of the guys in here are probably connecting from their VPS, haha nk: have to move from one of my old vps cause after 3 months they now say i cant user irc on it
i dont remember they having any restriction.. how well i move on to other
lol up_the_irons: nk: o'rly? sucks nk: yah just have to transfer all the stuff, waiting them to unsusped my account
was having 2 many downtimes also so i guess its for the best up_the_irons: it's kinda stupid not to allow IRC, but I understand it gets a bad reputation
well no one needs downtime, cancel 'em
maybe they were getting DoS'd b/c of IRC ;) nk: in like 3 months i opened at least 10 tickets about not been able to get in the vps
nah, i asked if it was anything i was running
they said no lol
now i see they didnt even looked what i was running
or they will saw the bnc and egg up_the_irons: i don't mean from you, i mean in general
maybe someone else got dos'd cuz of IRC and that is why they banned it ;)
do you mind saying what provider that was? nk: oh, yah possible
but i guess it was the package i had
that didnt allowed
santrex up_the_irons: ah
santrex? never heard of 'em
sidenote, the X7DWN+ motherboard is one bad ass board -: up_the_irons is building a new box nk: but still got lots of downtime, irc sory beside up_the_irons: gotcha nk: people calling me, gonna run bbl to sigh up with u guys as soon they unsuspend and i take off my stuff from old vps up_the_irons: nk: ok cool, ttyl ***: heavysixer has joined #arpnetworks up_the_irons: heavysixer: wudup heavysixer: up_the_irons: yo
how are things going? up_the_irons: good, u?
Nat_UB: you rebooting?:) Nat_UB: yea heavysixer: up_the_irons: good up_the_irons: Nat_UB: Nagios knows all Nat_UB: Wow...caught me
Think it's hung up... up_the_irons: vnc in Nat_UB: I'm in...want's F5 pressed...is there an option key to send F5 via VNC? up_the_irons: Nat_UB: i just hit F5
what does it want F5 for? ***: heavysixer has quit IRC () Nat_UB: Still not doing anything says Boot: F5 up_the_irons: Nat_UB: if you get out of vnc, i can take a look Nat_UB: All yours up_the_irons: Nat_UB: you just had to hit F1. it tried to boot from your 2nd volume (the non-bootable one) Nat_UB: hmmm....I tried that...
You just hit F1 or is there a CTLR-F1 needed? up_the_irons: Nat_UB: just F1 Nat_UB: thanks! up_the_irons: np! baklava: anyone happen to know VBA? up_the_irons: baklava: VBA?
visual basic... something? Nat_UB: for applications....like Excel, Access etc baklava: yea
this column is getting really annoying up_the_irons: heh ***: heavysixer has joined #arpnetworks heavysixer: up_the_irons: ping up_the_irons: heavysixer: pong baklava: uh oh, I think I got it heavysixer: up_the_irons: hey i am doing a query where i count the number of occurrences per date, and there are days where there are no occurrences at all, is there a way to get sql to return 0 for that date or do I need to just do that after i get the data back? up_the_irons: heavysixer: depends on how you do the query heavysixer: up_the_irons: i am doing a count using "between" up_the_irons: ok heavysixer: up_the_irons: SELECT count(*) AS count_all, date(created_at) AS date_created_at FROM `patient_records` WHERE (`patient_records`.`created_at` BETWEEN '2009-08-21' AND '2009-09-20') AND ((`patient_records`.`new_customer` = 0) AND (patient_records.deleted_at IS NULL OR patient_records.deleted_at > '2009-09-20 14:10:15')) GROUP BY date(created_at) ORDER BY date(created_at) -: up_the_irons shrugs heavysixer: up_the_irons: btw all that sql got generated from this: PatientRecord.new_customers.count(:conditions => { :created_at => from.to_date.to_s(:db)..to.to_date.to_s(:db) }, :group => 'date(created_at)', :order => 'date(created_at)') nice huh? up_the_irons: mapping from one language to another, doesn't really impress me ;) heavysixer: i like the hash syntax
it's very compact
up_the_irons: so i guess my question is how do i get 0's returned for those dates?
you said it depends on how i am doing the query. -: up_the_irons shrugs again up_the_irons: i don't fart SQL, so i dunno ;) heavysixer: k ;-) mike-burns: Wouldn't {:created_at => (from.to_date .. to.to_date), ...} also work? Is the #to_s required? up_the_irons: heavysixer loves to overuse .to_s()
;) heavysixer: up_the_irons: it's true
mike-burns: thx ;-) mike-burns: Ah okay. heavysixer: will fix that now mike-burns: Well I don't know if it will work, but it strikes me as something that should. heavysixer: up_the_irons: i am just creating the ranges first and adding the arrays together at the end
(3.days.ago.to_date .. Date.today).inject([]){|accum, date| accum << [date,0]} up_the_irons: ok heavysixer: mike-burns: ah i see what you are saying no I need to use to_date because the first attribute might be a Time class and then I need to call to_s to get the correct formatting.
needed by the db. mike-burns: Ah okay. heavysixer: but maybe rails will do that for free for me since i am using the hash syntax
that seems like something it should do. mike-burns: Right.
I figured you had the tests for this method and could quickly try it to see if you could reduce characters. heavysixer: mike-burns: i do have tests but in this case i might be converting something that is already converted later
so it would not break a test mike-burns: Oh okay. heavysixer: yeah it appears to work without doing the formatting cheers for the help mike-burns: Eh, still doesn't solve your original question. And I have no idea the answer to that. heavysixer: no worries i'll just use array math
after the fact. mike-burns: How many records are you loading into that array? heavysixer: yeah good point
could be thousands mike-burns: select count(id) from patients group by date(created_at);
That will give you counts including 0? heavysixer: doesn't appear to mike-burns: Oh, true, it won't.
No it'd need to iterate over existing date data. heavysixer: right. mike-burns: You could have another table with every date in it and join with that. heavysixer: mike-burns: mmm don't like that idea ;-) mike-burns: Nor do I. heavysixer: someone should have done this already :-) mike-burns: Why do you need the zeroes? What are you using that for? heavysixer: mike-burns: plotting mike-burns: When you iterate over the results, can you instead iterate over (from.to_date..to.to_date) and pull the results from a hash mapping date to result. Use Hash.new to default the value to 0. heavysixer: mmmmm mike-burns: I really cannot think of another solution. Oh, maybe instead of maintaining a table of every date you could use a subselect that creates such results.
This idea is very fuzzy in my mind and potentially impossible. heavysixer: yeah i am reading about it now
http://www.simple-talk.com/sql/t-sql-programming/find-missing-date-ranges-in-sql/ mike-burns: Yeah, that's what I meant! I didn't realize that'd be some complex though.
s/some/so/ ***: nk has quit IRC () heavysixer: i'm good at finding problems like that ;-) ***: heavysixer has quit IRC ()
heavysixer has joined #arpnetworks
ballen|away is now known as ballen
nuke^ has joined #arpnetworks
ballen is now known as ballen|away
ballen|away is now known as ballen nuke^: up_the_irons u around?
or anyone else from staff
:p ballen: doesn't look like it, anything you need specifically? nuke^: was just wondering if would be possible to customize a vps to decreace the BW and give more ips instead, i dont use barely any BW ballen: seems likely
not sure what the ratio for tradeoff will be
could just email Garry nuke^: ok ty, will wait for some anwer on the email or see if he coes online
i send on the "contact" area ballen: he'll get back to you, but since its the weekend I'm not sure what he's upto up_the_irons: hey nuke^
nuke^: it's possible to customize, i'll reply to your email nuke^: yo
im here
:) up_the_irons: nuke^: how much b/w do you need, and how many IPs? jeev: ips cost more than bandwidth! up_the_irons: nuke^: how'd you find us? :) nuke^: im nk, i talked to u earlier
:p jeev: <- not staff, just my unnecessary opinion up_the_irons: oh ok nuke^: i need 5 ips up_the_irons: so a /29 nuke^: bw like 15 will be enough up_the_irons: ok
nuke^: just replied to your email nuke^: ok
checking
cool
where do i order up_the_irons: nuke^: https://www.arpnetworks.com/order?product=vps&vps_plan_1=1
i'll know it's you
select the /29 nuke^: ok up_the_irons: under "extras"
and i'll adjust the bandwidth after
some dude wants to tunnel the VNC
ugh... time to set up that console server... ;) ballen: heh
so how bandwidth are you trading for a /29? up_the_irons: ballen: 50GB -> 25GB
basically cut in half jeev: 1 gb per /24
im down
i'll give you 100gb, i want 100 class C's
NOW nuke^: done the order up_the_irons: i have class C's, but they ain't cheap ;) ballen: cash money jeev: cash monies up_the_irons: nuke^: thanks, it'll be provisioned today (most likely at night)
nuke^: thought you needed to wait for your other host to unfreeze your account ;) nuke^: already done
i have all the stuff on me now :) up_the_irons: oh nice nuke^: can i pm u 5 hosts so u rdns the ips to them, the old ones i use on the other box up_the_irons: nuke^: sure
cd $starbucks
i lied
nuke^: didn't get your order btw
nuke^: you sure you got to the "Thank you" page?:) nuke^: hm nah i did submit order and got me all fields reseted and thats was it
guess was something wroung
doing again up_the_irons: nuke^: start from arpnetworks.com/vps, select the $10 plan. maybe there was something wrong w/ the link I sent you nuke^: done now up_the_irons: nuke^: got it, thanks!
nuke^: you're a debian guy? :) nuke^: yeah, i like debian, ubuntu, i dont mess around much on linux, only on my vps's jeev: who wants to convince me to change my vps to freebsd
i feel like i've stabbed slackware in the back up_the_irons: nuke^: cool
bbl ballen: jeev: change your vps to FreeBSD jeev: why ballen: because its better jeev: hmm
i think that's convincing enough ballen: good ***: heavysixer has quit IRC ()
ballen is now known as ballen|away
heavysixer has joined #arpnetworks
ballen|away is now known as ballen
heavysixer has quit IRC (Client Quit)
ballen is now known as ballen|away
ballen|away is now known as ballen
heavysixer has joined #arpnetworks up_the_irons: w00t, successfully installed OpenBSD 4.5 on a VM for the first time
toddf: your notes worked perfectly heavysixer: up_the_irons: n3rd up_the_irons: heavysixer: oh you don't even know heavysixer: up_the_irons: the inject method is really cool
in ruby
i just learned that today up_the_irons: heavysixer: man you're late to the game ;) heavysixer: up_the_irons: i noes up_the_irons: srsly heavysixer: up_the_irons: wow!!!!
up_the_irons: kent beck added a pledgie campaign
Kent Fucking Beck ballen: anyone around
Kent Beck just did a FLOSS weekly heavysixer: ballen: what is FLOSS? ballen: http://twit.tv/floss87
podcast mike-burns: "Free Libre Open Source Software"
Those are indeed words. ballen: indeed heavysixer: ah
cool good to know. ***: heavysixer has quit IRC ()
Limb has quit IRC ("Get MacIrssi - http://www.sysctl.co.uk/projects/macirssi/")
timburke has quit IRC ("Leaving")
timburke has joined #arpnetworks
ballen is now known as ballen|away
ballen|away is now known as ballen toddf: up_the_irons: the instructions are valid through current still, would be nice to know if latest qemu with kvm support would manage to do better than the kvm userland piece or if updating the kernel/kvm userland piece would change anything, but thats for your new box to test, right? ;-) ***: ballen has quit IRC (Read error: 113 (No route to host)) up_the_irons: toddf: yup, for a new box
i've spec'd one out, just waiting for a few more funds to collect before buying
toddf: send me your pub key when you get a chance and i'll add you to my new customer console server i'm building / testing (running OpenBSD 4.5 :)
toddf: is there something equivalent to FreeBSD's "security.bsd.see_other_uids=0" in OpenBSD? obsidieth: i imagined that being pretty universal, heh. up_the_irons: obsidieth: i don't see it in OpenBSd sysctl though