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