--- Day changed --- Log opened Fri Jun 13 23:59:02 2008 23:59 -!- Schroeder [1000@kntpin04-nas-02-s247.cinergycom.net] has quit [Ping timeout: 480 seconds] 00:22 -!- Schroeder [1000@kntpin04-nas-02-s238.cinergycom.net] has joined #linode 00:32 -!- kassah-lappy [~kassah@66-232-76-197.ctcweb.net] has joined #linode 00:32 -!- ^GaveUp^ [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode 00:38 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has joined #linode 00:39 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds] 00:57 -!- irgeek is now known as Guest573 00:57 -!- irgeek_ [~irgeek@166.128.99.159] has joined #linode 00:57 -!- irgeek_ is now known as irgeek 00:57 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has joined #linode 01:01 -!- Guest573 [~irgeek@166.128.150.70] has quit [Ping timeout: 480 seconds] 01:06 -!- Schroeder [1000@kntpin04-nas-02-s238.cinergycom.net] has quit [Ping timeout: 480 seconds] 01:14 * internat85 returns from work with goodies.. Well more like goodie, but all the same :) 01:14 * internat85 scored a 1/3rd height rack that work no longer needed 01:17 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has quit [Quit: Into the dark I fade..] 01:17 < irgeek> mysqldump + binary column = completely screwed terminal. 01:17 < irgeek> reset didn't even fix it. 01:18 < internat85> ouchies 01:19 < irgeek> Luckily, screen is more awesomer than reset and did fix it. 01:20 < internat85> :D 01:21 < internat85> there throwing out so much old stuffs at work, so im gonna see what else i can possible score.. theres an oldish 1u apc ups, and a few p3 1u servers that might make a good rack mount router.. 01:21 < irgeek> And converting the column to a varbinary instead of varchar makes --hex-blob work so it doesn't hose the terminal. 01:24 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has joined #linode 01:30 < irgeek> Methinks I don't really need MySQL. Dumping every db results in a 144K gzipped file. 01:38 < internat85> lol 01:38 < mikegrb> lolz 01:39 < internat85> i figure even for most small things im better off usingmysql.. buggered if iw ant to try and convert it later 01:39 -!- Alucard [Hellsing@c-76-24-50-134.hsd1.nh.comcast.net] has quit [Ping timeout: 480 seconds] 01:39 -!- Alucard [Hellsing@c-76-24-50-134.hsd1.nh.comcast.net] has joined #linode 01:40 -!- kupesoft [~dave@CPE003018b02a53-CM0018c0c44e76.cpe.net.cable.rogers.com] has quit [Ping timeout: 480 seconds] 01:42 < irgeek> Yeah, compatibility is the big problem. Not many of the systems I use work on anything but MySQL. Or PoasgreSQL which is about as heavyweight. Too bad everything can't use SQLite. 01:46 < irgeek> Then again, most of this is configuration data. Maybe I should move it to LDAP. 01:51 -!- kupesoft [~dave@CPE003018b02a53-CM0018c0c44e76.cpe.net.cable.rogers.com] has joined #linode 01:58 -!- CyZooNiC [~Administr@c-24-34-133-64.hsd1.ma.comcast.net] has left #linode [] 02:07 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has joined #linode 02:08 -!- webPragmatist [~cleblanc@adsl-99-148-164-47.dsl.rcsntx.sbcglobal.net] has left #linode [] 02:08 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has quit [Read error: Connection reset by peer] 02:12 -!- kupesoft [~dave@CPE003018b02a53-CM0018c0c44e76.cpe.net.cable.rogers.com] has quit [Ping timeout: 480 seconds] 02:13 -!- digx [~rick@c-76-109-201-140.hsd1.fl.comcast.net] has quit [Quit: digx] 02:17 -!- lakin [~lakin@S01060013101832cd.cg.shawcable.net] has quit [Quit: Ex-Chat] 02:44 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode 02:48 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode 02:54 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Ping timeout: 480 seconds] 03:00 -!- getsmart [~getsmart@88-149-230-57.dynamic.ngi.it] has joined #linode 03:04 -!- Core2Duo [~4493097b@webuser.linode.com] has joined #linode 03:04 < Core2Duo> Please help. What is the command to install htop in centos? 03:05 < irgeek> yum install htop? 03:07 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode 03:08 < Core2Duo> Please help. What is the command to install htop in centos? 03:09 < irgeek> Did you ask Google? 03:09 < Core2Duo> says "Nothing to do" 03:09 < Core2Duo> says "Nothing to do" 03:10 < bob2> then perhaps it ist installed already 03:10 < irgeek> Perhaps. 03:10 < Core2Duo> yeah. Google says i should use rpms, but I don't know how to search for rpms, to find the correct one. 03:11 < bob2> why did you choose centos? 03:11 < Core2Duo> I can't even install irssi to chat on irc, that is why I am using the web version on linode.com. Please excude my duplicate postings. 03:11 < irgeek> I'm pretty sure if yum says "Nothing to do" the package is *already installed.* 03:12 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Ping timeout: 480 seconds] 03:12 < bob2> maybe it's crap and says that if it can't find the package, too 03:13 < Peng> Trying to run it would clear that up. 03:14 < irgeek> You're right. If it can't find the package it says "No Match for argument: " then "Nothing to do" 03:15 < bob2> lolz 03:16 < irgeek> Peng: Not necessarily on RH derivatives. RH likes to have "special" programs which are only in your path if you're root. It's fscking stupid and part of the reason I stopped using RH derivatives. 03:16 -!- Core2Duo [~4493097b@webuser.linode.com] has quit [Remote host closed the connection] 03:16 < bob2> dang 03:17 < irgeek> Security through obscurity isn't! 03:19 -!- Core2Duo [~4493097b@webuser.linode.com] has joined #linode 03:20 < Core2Duo> I was able to install htop and irssi in fedora, but not centos. 03:20 -!- Core2Duo [~4493097b@webuser.linode.com] has quit [Remote host closed the connection] 03:20 < irgeek> Fedora != CentOS 03:21 -!- Core2Duo [~Core2Duo@S0106001a70fac4b1.cg.shawcable.net] has joined #linode 03:21 < irgeek> Fedora != CentOS 03:21 < irgeek> Are you sure that CentOS has an htop package? 03:22 < Core2Duo> I was able to install them with yum in fedora, that is, htop and irssi, not Centos. 03:22 < Core2Duo> all there is i guess is rpms 03:22 < bob2> yes, so centos's repository is missing things fedora includes 03:22 < internat85> irgeek: yeah i though of running ldap but figured mysql was really just as good.. 03:22 < Core2Duo> but those are too complex for me. I don't know which rpm is compatible to which distro 03:23 < bob2> the first hit for "how do I install htop on centos" on google explains how, by the way 03:23 < irgeek> Again, why did you pick CentOS? 03:23 < irgeek> !google how do I install htop on centos 03:23 < linbot> irgeek: Search took 0.32 seconds: htop - Linux command line to invoke an inproved top | Linux ...: ; DAG: htop RPM packages for Red Hat, CentOS and Fedora: ; forget top, check out htop : Ubuntu Tutorials : Dapper - Feisty ...: ; (3 more messages) 03:23 < irgeek> And there's a link to it. 03:23 < Core2Duo> rpm -Uvh rpmforge-release-[your_release].rpm 03:24 < Core2Duo> I do not know how to tell which rpm works with Centos. 03:24 < irgeek> Again, why are you using CentOS? 03:24 < internat85> hmms.. ive never had to build/install crap into a rack.. *ponders how a network switcfh that isnt a slidy rack thing goes in.. round screws, square hole and all 03:24 < bob2> you need to know which centos release you are using 03:25 < Core2Duo> I am more inclined towards redhat install commands. I am a yum fan 03:25 < irgeek> internat85: The square holes need little inserts that have the nuts in them. 03:25 < internat85> ah! 03:25 < internat85> now i know what those are for! 03:25 -!- ^GaveUp^ [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds] 03:25 < internat85> they lookked wierd but i thought they were for something else.. 03:25 < Core2Duo> what distros do you recommend other than fedora, centos, slackware and ubuntu? 03:26 < internat85> debian 03:26 < Core2Duo> debian applies apt, right? 03:26 < internat85> yes 03:26 < internat85> well. debian contains apt 03:26 < irgeek> internat85: They usually go on the side of the hole *opposite* the gear's ear & screw. 03:26 < bob2> debian or ubuntu are a lot less newbie hostile since a) they have practically every piece of software on earth in their repositories and b) the half regulars here use them 03:27 < Core2Duo> hmmm. 03:27 < Core2Duo> I will give debian a shot then 03:27 < internat85> err ear and screws? 03:27 < Core2Duo> thank you good people. 03:27 < internat85> debian is pretty kewl. lots of help available for it and its pretty safe 03:27 < internat85> solaris on the other hand.. *mumbles* 03:27 < Core2Duo> great 03:27 < internat85> why did i decide to do my solaris certification? 03:27 < Core2Duo> take care then ood people. 03:28 < bob2> though, centos doesn't seem that bad, but you do need to know things like which version of centos you are using 03:28 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Remote host closed the connection] 03:28 -!- Core2Duo [~Core2Duo@S0106001a70fac4b1.cg.shawcable.net] has left #linode [] 03:28 -!- getsmart [~getsmart@88-149-230-57.dynamic.ngi.it] has quit [Quit: Ex-Chat] 03:29 < irgeek> He claims "I am a yum fan" but he doesn't know how to drive it? 03:29 < irgeek> WTF? 03:29 < internat85> actually on a more.. bad kind of note.. everyone remember the old round computer keys? like that hdd caddys have? and used to be the keyboard on/off switch? well anywho the rack i just aquired has them on it.. and i dont have a key that works ini t.. it fits the lock but no turny. and im trying to think of a way to open it.. without drilling out the damm locks 03:30 < exor674> internat85: buy a cylindrical lockpick? 03:30 < internat85> a what? 03:30 < irgeek> Depending on the diameter of the hole, removing the back stopper from a cheapo bic pen and wiggling it around in the hole can work. 03:30 < exor674> a lockpick that is meant to pick that kinda lock :P 03:31 < internat85> its one of those really large ones.. 03:31 < irgeek> Those locks are not highly secure. 03:31 < internat85> i will try a bic pen.. 03:32 < internat85> i was suprised actually cauyse i have a key that fits its in it.. it just wont friggen turn, but i know the locks not busted so 03:37 < irgeek> internat85: Did you understand what I meant about installing the nuts? You basically need to end up with the actual rack frame sandwiched between the head of the screw and the nut. 03:40 < irgeek> If you do it wrong, you end up with all the load on the nut's think metal wings and in the middle of the night they will fail almost destroying your $16,000 web proxy/filter. *mumble* fscking useless n00b installers *mumble* fscking think they are smarter than me *mumble* 03:40 < irgeek> s/think/thin/ 03:41 < internat85> umm.. maybe. lemme see if i can find some images on google 03:42 < irgeek> I've been looking for 10 minutes. 03:42 < irgeek> I can't find a closeup. 03:42 < internat85> oh :( 03:45 < internat85> http://images.google.com/imgres?imgurl=http://www.xrackpro.com/images/xrack-cage-nut-screw-lg.jpg&imgrefurl=http://www.xrackpro.com/accessories_screw.htm&h=696&w=1000&sz=60&hl=en&start=90&tbnid=esKvqoPZKHJ_wM:&tbnh=104&tbnw=149&prev=/images%3Fq%3Drack%2Bmount%2Bscrews%26start%3D80%26gbv%3D2%26ndsp%3D20%26hl%3Den%26sa%3DN 03:46 < irgeek> Those are the nuts. I found pictures of the nuts, I was trying to find instructions to install them. :P 03:46 < irgeek> Basically, the job of the little wings it to hold the nut in place for you and to keep it from spinning. 03:47 < internat85> sure 03:47 < irgeek> Since you want to manipulate the screwdriver from the outside of the rack, the nut goes on the inside so that the screw pulls the nut up against the rack. 03:47 < internat85> so i want the nut on the OTHER side so that the bult is going thru the actual rack 03:48 < internat85> is that what your trying to say 03:48 < irgeek> Yup. 03:48 < internat85> yeah that makes sense.. otherwise if the wings fail it falls, rather then it then resting on the bolt 03:49 < irgeek> Right. And usually the wings get pretty fscked when you really crank the screw down, so the are considered a non-reusable item in many installations. 03:50 < internat85> thats ok, i happen to know where i can grab a lot of them 03:50 -!- r3z`` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has joined #linode 03:50 -!- xitology [~xi@78.31.182.24] has quit [Quit: Ex-Chat] 03:51 < irgeek> They make like much better though. Back in the old days of threaded holes in racks, if you cross-threaded a hole, you could use it anymore. Very ugly business. Not to mention drilling and tapping a few hundred holes accurately is not cheap. 03:51 < irgeek> s/like/life/ 03:51 < internat85> yeah 03:51 < internat85> i could understand that.. *makes mental note to steal some bolts and shit from work* 03:52 -!- Dreamer3 [~Dreamer3@74-129-225-206.dhcp.insightbb.com] has quit [Quit: This computer has gone to sleep] 03:52 < irgeek> What equipment are you putting in the rack? 03:52 < irgeek> If it's heavy, you may want to think about rear-support. 03:52 < irgeek> You can find cheap right-angle brackets at the hardware store in a pinch. 03:53 < internat85> nothing yet :) i just aquired it.. im putting my old linode host into it.. probably a network switch 03:53 < internat85> if i can get my hands on a solaris netra or something simple im going to use that as well 03:54 < irgeek> If it's a basic, shallow switch it probably doesn't need rear support. The Linode host may need it though. 03:55 < irgeek> Or you can spring for a set of rails which make like much easier. 03:55 < irgeek> s/like/life/ 03:55 < internat85> the host came with rails :) 03:55 < irgeek> Oh, well that makes that simple then. 03:55 < internat85> yeah 03:57 -!- r3z` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has quit [Ping timeout: 480 seconds] 03:57 < internat85> ive done rails stuff before so im not worried about putting them in:) 03:58 < irgeek> I did an HP blade server setup earlier this year. The chassis was surprisingly easy to rack. 04:00 < Napta> HPs are lovely to rack. Especially to say, Sun 04:00 < exor674> haha... so, one side effect of only skimming the channel... I was wondering how a web framework would help physically hold a server up 04:00 < Napta> irgeek: Did your blade server need 16 AMP power? 04:02 < irgeek> HP shipped the rack with 20A cabling. But we were running 230V so really we were running about half the Amps it would have in the States. 04:02 < Napta> hehe 04:02 < Napta> Are you British, irgeek ? 04:03 < irgeek> No. I was working in Egypt at the time. 04:03 < Napta> oh right 04:08 < internat85> http://cgi.ebay.com.au/Sun-Sunfire-V240-Dual-CPU-2U-Server-2-x-36GB-2GB-RAM_W0QQitemZ320261813535QQihZ011QQcategoryZ11216QQssPageNameZWDVWQQrdZ1QQcmdZViewItem <== im tempted to buy that 04:08 < internat85> except for the lack of rails 04:09 < internat85> although im worried my power bill is going to go up substanically 04:10 < irgeek> You'd probably want some new disks too. 2 x 36GB isn't much anymore. 04:11 < internat85> yeah cept that i just want it to play with :P 04:11 < internat85> not acutally anything that would need a lot 04:15 < irgeek> I had on old Sun box floating around for a while. Very, very old. And very, very noisy. But it was the first computer I had with a C compiler. I'd only used Pascal before that. 04:15 < internat85> yeah.. im in the middle of doing my sun certification so having a sun box would be handy.. especially since im likely to be changing employeers soon and well would lose access to all the sun gear i currently have access to.. 04:20 < internat85> its either that or.. 04:20 < internat85> http://cgi.ebay.com.au/SUN-NETRA-X1-1RU-SERVER_W0QQitemZ250257968461QQihZ015QQcategoryZ11216QQssPageNameZWDVWQQrdZ1QQcmdZViewItem 04:22 < irgeek> That's a fair bit less hardware for not much less money. 04:22 < internat85> yeah i know.. thats what i was thinking.. the netras are small and compact though 04:22 < internat85> im a bit concern about my power bill :/ 04:23 < internat85> and the fact that the first one doesnt have any rails 04:23 < irgeek> Well if you're only using it to learn on, you don't need to powered on all the time. 04:24 < internat85> yeah.. cept im lazy :P 04:25 < internat85> are all rails the same? 04:26 < irgeek> Not necessarily. 04:26 < internat85> see thats unfortunate 04:27 < irgeek> The shelf type rails will work for anything the correct width, but if you get sliding rails they manufacturers don't alway put the holes in the same place. 04:27 < internat85> ah 04:28 < irgeek> Racking gear is incredibly annoying. Manufacturers make their racks and rails slightly different to everyone else's because they they have a really good margin. 04:29 < internat85> :/ 04:29 < irgeek> The HP rack I bought for the project in EG was $10,000 04:29 < internat85> so am i likely to have issues putting random gear in this rack? 04:29 -!- Dreamer3 [~Dreamer3@74-129-225-206.dhcp.insightbb.com] has joined #linode 04:31 < irgeek> The fact that it's square hole helps a lot. If you can get the right rails, you should be alright with it. 04:34 -!- spasmface [~spasm@r220-101-68-90.cpe.unwired.net.au] has joined #linode 04:41 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode 04:50 < irgeek> o_O When did 500GB 2.5" drives come you? 04:55 < irgeek> Apparently, you can now get a 2U rackmount chassis with about 7TB of disk for around $6,000. That's pretty cheap. 04:57 < internat85> where did you see that? 04:58 < internat85> although considering you can get 4x1tb hdds for 1k.. 04:59 < irgeek> http://www.pcconnection.com/ - Add items 8584653 & 8673040 to your cart. 05:00 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Quit: Navi] 05:00 < internat85> see if that had 3.5" drive bays id be happeri 05:00 -!- exor674 is now known as exor|zzz 05:01 < irgeek> Then it wouldn't be 2U tall. 05:01 < internat85> i dont care if its 3u tall to be honest 05:01 < irgeek> Well that's different, isn't it... 05:01 < internat85> can you gett things like that" 05:02 < irgeek> Of course. 05:02 < internat85> cheap? in australia? 05:06 < irgeek> pcconnection p/n 6987731 05:06 < irgeek> 16x SAS/SATA 3.5" 05:08 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode 05:08 < internat85> thats impressive.. 05:09 < irgeek> Add a 20-pack of 1TB drives for $4,300 05:09 < irgeek> So 16TB online and 4 offline backup drives. 05:10 < internat85> shit thats cheap 05:10 < internat85> i want me one 05:10 -!- agentbleubleu [~agentbleu@lns-bzn-38-82-253-119-128.adsl.proxad.net] has joined #linode 05:10 < internat85> not the 20 pack of hdds, more the case with 16 bays.. 05:10 < irgeek> Actually, $4,200 for the drives - p/n/ 7911472 05:11 < irgeek> All told, about $5,200 for the whole rig. 05:12 < internat85> i can buy those hdds at that cost here in au.. 05:12 < irgeek> Oh, and SuperMicro is awesome to the chassis comes with the HD caddies. 05:12 < internat85> ie 220$ ea 05:13 < internat85> yeah i want one 05:14 < internat85> i wonder if i can get one of those cases in au 05:16 < internat85> http://www.auspcmarket.com.au/index.php?redir=http://www.auspcmarket.com.au/show_product_info.php?input[product_code]=CA-CSPC-836TQ-R800B&input[category_id]= 05:16 < internat85> thats a bit expensive.. 05:17 < irgeek> They make a 4U chassis that takes 24 3.5" drives. It looks like it's only about $100 more. 05:17 < irgeek> That's quite a bit more. 05:18 < irgeek> It would almost be cheaper to buy a ticket to the States and take one home in your suitcase. 05:21 < irgeek> I'm not 100% sure of those come with MoBos - the specs aren't clear. 05:22 < irgeek> Although, they do list the processor they support, so they may just need processors and memory. 05:23 < internat85> yeah i was just discussing that :P 05:24 -!- spasmface [~spasm@r220-101-68-90.cpe.unwired.net.au] has quit [Ping timeout: 480 seconds] 05:25 < internat85> yeah id be interested to know if there is a mobo, cause i want to know if the damm thing actually has 16 or 24 sata ports built onto the damm thing 05:27 < irgeek> Install guide: http://www.supermicro.com/manuals/chassis/3U/SC836.pdf 05:33 < internat85> *waits for the slow thing to download* 05:37 < agentbleubleu> Hi Guys, I have a crashed table in my db but repair from phpmyadmin times out, can anyone help 05:39 < irgeek> Did you look in the logs to see if there is an error from phpmyadmin? 05:39 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has quit [Ping timeout: 480 seconds] 05:39 < agentbleubleu> not yet 05:40 < agentbleubleu> It happened bc i was trying to load in a 800Mg sql file using a program called big dump 05:40 < agentbleubleu> but the table that has crashed is not the same, table 05:41 < irgeek> I'd suggest trying mysqlcheck from the command line. 05:41 < agentbleubleu> im in shell now, and have the prompt: mysql> do i need to switch this to the right database, and how? 05:41 < irgeek> Long running processes and the web don't play nicely together. 05:42 < agentbleubleu> i see that 05:42 < irgeek> mysqlcheck is a different program 05:42 < irgeek> \q 05:43 < irgeek> mysqlcheck -u -p 05:43 < agentbleubleu> ok 05:45 < agentbleubleu> error : Table './myplaylist/playlist' is marked as crashed and should be repaired 05:45 < agentbleubleu> li6-87: 05:45 < internat85> theres a repair thingi 05:45 < internat85> repair table x 05:45 < internat85> log in a root to your database 05:46 < irgeek> mysqlcheck -u -p --auto-repair 05:46 < agentbleubleu> ok 05:47 < agentbleubleu> Repairing tables 05:48 < agentbleubleu> any suggestions for importing this large sql into the db 05:48 < agentbleubleu> 800Mg 05:48 < internat85> yeah 05:48 < internat85> dont use phpmyadmin 05:49 < agentbleubleu> i was using a program called bigdump 05:49 < internat85> why cant you use mysql's import? 05:49 < agentbleubleu> didnt know it excisted 05:50 < internat85> well the file your trying to import, is just sql statements yeah? 05:50 < agentbleubleu> yea 05:51 < irgeek> I think this will work: mysql -u [username] -p < [sql_file] 05:51 < internat85> yeah that 05:51 < irgeek> The greater than symbol there is part of the command, BTW. 05:52 < internat85> you jneed to select the database if your sql doesnt already do that 05:52 < irgeek> And make sure you have enough disk space on the partition that has the MySQL files. 05:52 < irgeek> MySQL gets very upset if it runs out of sick space. 05:52 < internat85> ive never had that happen.. and i hope to god it never does 05:53 < irgeek> I'm really glad I typo disk in two places there. 05:54 < agentbleubleu> ok im a little unsure about a few things, first how to make sure there is enough space 05:54 < irgeek> What the hell kind of data do you have that's an 800MB sql file anyway? 05:54 < internat85> imagines i imagine 05:54 < agentbleubleu> 276K lyrics 05:54 < internat85> i was thinking album/track images 05:54 < agentbleubleu> the crashed table has still not been repaied yet 05:54 < internat85> is it still repairing? 05:55 < agentbleubleu> its also a large db 05:55 < agentbleubleu> yes 05:55 < agentbleubleu> i think its about the same size 05:55 < irgeek> Now you know why phpmyadmin timed out. 05:55 < agentbleubleu> aha 05:55 < irgeek> You might want to grab a sandwich. 05:55 < agentbleubleu> cool 05:55 < irgeek> It could be a while. 05:55 < agentbleubleu> ok 05:55 < agentbleubleu> so how do you ensure there is space 05:56 < internat85> hmms a sandwich would be good.. i have no bread though :( 05:56 < irgeek> Are you running that under screen or Lish by any chance? 05:56 < agentbleubleu> i have the space on the server 05:56 < agentbleubleu> ? 05:56 < internat85> if you dont know the answer to that, then im guessing now 05:56 < internat85> no* 05:57 * irgeek hopes the ssh connection doesn't decide to drop 05:57 < agentbleubleu> im using terminal 05:57 < agentbleubleu> ssh 05:57 < agentbleubleu> mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE ... ' 05:58 < agentbleubleu> now im shitting it 05:58 < agentbleubleu> ;p; 05:59 < irgeek> You probably ran out of memory or disk space. 05:59 < irgeek> do df -h 05:59 < irgeek> * do is not part of the command 05:59 < agentbleubleu> yea 05:59 < agentbleubleu> erm its crashed terminal 05:59 < agentbleubleu> sec 06:00 < internat85> wait 06:00 < internat85> you are copying that file to the server, and running the mysql import command there right? 06:00 < agentbleubleu> no importing now 06:01 < agentbleubleu> just waiting for the terminal its back 06:01 < agentbleubleu> Filesystem Size Used Avail Use% Mounted on 06:01 < agentbleubleu> tmpfs 406M 0 406M 0% /lib/init/rw 06:01 < agentbleubleu> tmpfs 406M 0 406M 0% /dev/shm 06:01 < irgeek> There should be more than that o_O 06:01 < agentbleubleu> dev/xvda 15G 5.6G 8.8G 39% / 06:02 < irgeek> That's it I assume? 06:02 < irgeek> Doesn't look like you ran out of space. 06:02 < agentbleubleu> http://pastebin.linode.com/890 06:02 < internat85> are u running that on your computer did copy the dump to the server, and running it there? 06:03 < agentbleubleu> yea copy dump file to server and run it ther 06:03 < agentbleubleu> e 06:03 < agentbleubleu> thats what crashed it 06:03 < agentbleubleu> but this is a different table that has crashed 06:04 < irgeek> Did you try to do the import during the repair? 06:04 < agentbleubleu> no 06:04 < agentbleubleu> nothing 06:04 < irgeek> Ok, but the repair failed, right? 06:04 < agentbleubleu> yes 06:04 < irgeek> And then what happened? 06:04 < agentbleubleu> nothing 06:05 < agentbleubleu> seemed to take a long time to come back to life (terminal) 06:05 < irgeek> I'm guessing you ran out of memory. 06:05 < irgeek> Do the check again: mysqlcheck -u -p 06:05 < agentbleubleu> ok 06:05 -!- Deetz [~Paul@host185.natpool.mwn.de] has joined #linode 06:06 < agentbleubleu> error : Table './myplaylist/playlist' is marked as crashed and should be repaired 06:07 < irgeek> Ok. So MySQL is still running. Check the MySQL logs. 06:07 < irgeek> Should be somewhere in /var/log 06:07 < agentbleubleu> ok 06:10 -!- ondrej [~ondra@ip4-83-240-41-73.cust.nbox.cz] has joined #linode 06:12 < agentbleubleu> I can see some stuff in the slow log, nothing mentioning the crash 06:12 < agentbleubleu> but it was trying to switch about during 06:13 < agentbleubleu> i cannot find the actual log for general mysql seems loads of them 06:13 < irgeek> What version of MySQL are you running? 06:13 < agentbleubleu> latest 06:13 < agentbleubleu> 5.3 i think 06:15 < irgeek> Get into mysql and run status 06:15 < agentbleubleu> ok 06:15 < irgeek> Then tell me what the Server version: line prints out. 06:16 < agentbleubleu> http://pastebin.linode.com/891 06:17 < mattt> select version(); 06:17 < irgeek> I didn't think it was 5.3 since that doesn't exist ;) 06:18 < agentbleubleu> ah 06:18 < agentbleubleu> sororry 06:18 < agentbleubleu> mysql> select version(); 06:18 < agentbleubleu> +--------------------------+ 06:18 < agentbleubleu> | version() | 06:18 < agentbleubleu> +--------------------------+ 06:18 < agentbleubleu> | 5.0.32-Debian_7etch5-log | 06:18 < agentbleubleu> +--------------------------+ 06:18 < agentbleubleu> 1 row in set (0.00 sec) 06:21 < irgeek> Drop out of mysql and run dmesg 06:21 < agentbleubleu> ok 06:21 < irgeek> I want to see if the OOM killer kicked in. 06:23 < agentbleubleu> http://pastebin.linode.com/892 06:23 < internat85> what the hell is that 06:24 < internat85> oh.. the OOM killer 06:24 < internat85> yeah ok your going to have some fun with that 06:24 < irgeek> That's the OOM killer stepping in when MySQL goes berserk fixing a huge table. 06:24 < internat85> how the hell do you fix that.. 06:24 < internat85> add more swap space 06:24 < mattt> ? 06:24 < mattt> no way 06:24 < internat85> ? 06:25 < mattt> adding more swap isn't going to help 06:25 < internat85> short of adding more ram to the server, how the hell do you fix that? 06:25 < irgeek> agentbleubleu: So, um. Do you happen to have a desktop sitting around that's got the same distro as your Linode and a few GB of ram sitting around at home? 06:26 < agentbleubleu> no 06:26 < Napta> adding swap will help 06:26 < Napta> swap is used before oom kicks in 06:26 < irgeek> Ah. Well. Adding swap will help, but the repair is going to take a lot longer. 06:26 < internat85> well you could add more ram to your server 06:27 < agentbleubleu> i was monitering swap during 06:27 < agentbleubleu> it was hardle used 06:27 < internat85> especially with prorata billing these days 06:27 < agentbleubleu> i have 850mg ram 06:27 < Napta> agentbleubleu: perhaps the level of swappiness needs adjusted. but yeah, adding ram works best (I forgot it was a Xen vps!) 06:28 < agentbleubleu> yes xen 06:28 < irgeek> If you have a real machine you could transfer the MySQL files to and do the repair there, it would probably be best. 06:28 < internat85> you could just add 360mb for a day to do the repair.. 06:29 < agentbleubleu> would adding ram work 06:29 < agentbleubleu> i dont havea machine 06:29 < internat85> it may.. no garantees 06:30 < Napta> Theres always vmware and your desktop, worse case 06:30 < agentbleubleu> i could not download the file in phpmyadmin 06:31 < irgeek> Adding memory (and maybe some more swap) is probably your best bet. 06:31 < agentbleubleu> im on a mac 06:31 < agentbleubleu> ok 06:31 < agentbleubleu> 360 mg 06:31 < internat85> the only reason i said 360mb is the most it appears allow you to get 06:31 < irgeek> You don't want to download the files through phpmyadmin - you need to download the data files directly. 06:32 < irgeek> internat85: It looks that way. 06:32 < internat85> caker may be able to shead some help your way :) 06:32 < internat85> but i speak not on behalf of him :) 06:33 < irgeek> agentbleubleu: After you add the memory, you'll need to reboot to see it. 06:33 < agentbleubleu> ok 06:33 < agentbleubleu> is caker awake 06:34 < irgeek> And double check your profile to make sure it's using all the memory. 06:34 < irgeek> Unlikely. Someone should be in the office soon though. 06:35 < irgeek> And by soon I mean in about 1 1/2 hours. 06:35 < internat85> it is saturday though isnt it? 06:35 < irgeek> Oh yeah. 06:35 < irgeek> Good point. 06:36 < internat85> well atleast it is saturday here 06:37 < agentbleubleu> i added 360 mg ram 06:38 < irgeek> If the extra 360 isn't enough, you could add a Linode2880 for a day, clone your Linode over, do the repair and clone it back... 06:38 < irgeek> Check your profile then reboot. 06:38 < agentbleubleu> i ant see it in the profile 06:38 < agentbleubleu> sec 06:38 < agentbleubleu> i rebooted 06:39 < irgeek> When you log in, check free -m 06:39 < agentbleubleu> ok its loking good 06:40 < agentbleubleu> Mem: 1170 192 977 06:40 < agentbleubleu> 977 free 06:40 < irgeek> It might also help to stop other services while you do the repair. Like Apache and whatever else is running (but not ssh obviously) 06:40 < agentbleubleu> ok 06:41 < irgeek> And not MySQL either. 06:41 < agentbleubleu> apache stopped 06:41 < irgeek> Now what's free 06:42 < agentbleubleu> mysqlcheck -u -p --auto-repair 06:42 < agentbleubleu> this again 06:42 < agentbleubleu> ? 06:42 < irgeek> BTW: apt-get install screen 06:42 < irgeek> First 06:42 < irgeek> You want to run it under screen in case your ssh connection drops. 06:42 < agentbleubleu> ok 06:43 < agentbleubleu> done 06:43 < agentbleubleu> how to open screen 06:43 < irgeek> screen 06:43 < agentbleubleu> ok 06:43 < agentbleubleu> righto 06:43 < agentbleubleu> fingers crossed 06:43 < irgeek> Now do mysqlcheck with the auto repair 06:46 < agentbleubleu> ok doing now 06:46 < irgeek> BTW, how do you have 810M of memory normally? That's not a Linode plan size. 06:46 -!- Deckert [~Deckert@41.240.147.158] has quit [Quit: Leaving] 06:46 -!- Deckert [~Deckert@dsl-240-147-158.telkomadsl.co.za] has joined #linode 06:46 < agentbleubleu> i added a bit on top 06:46 < irgeek> Of a 720? 06:46 < agentbleubleu> y 06:46 < agentbleubleu> 90 06:50 < irgeek> So how much memory *does* you Mac have? 06:50 < agentbleubleu> 2g 06:51 < irgeek> You can run MySQL on natively on a Mac now. I use it for development. If the repair fails again, that may be your best option. 06:51 < agentbleubleu> ok 06:56 < irgeek> Oh shit. I didn't even think of EC2 - You can boot an EC2 instance with 15G of memory for $0.80/hour 06:56 -!- Talman [~ender@gciwifi-1.gci.net] has joined #linode 06:57 < agentbleubleu> amazon 06:57 < agentbleubleu> ? 06:57 < irgeek> Yeah. Their Elastic Compute Cloud. 06:57 < agentbleubleu> its ok the 360mg was only 11 dollars 06:57 < Talman> Mmm EC2 06:58 < agentbleubleu> as half way though the month 06:58 < irgeek> You'll get most of that back when you remove it. 06:58 < agentbleubleu> plus might need it to get the other lyrics table in] 06:58 < irgeek> That's possible. 06:59 < irgeek> Ok. Type Ctrl-a then c 06:59 < irgeek> You'll get a new shell. 07:00 < irgeek> Then do free -m 07:00 < agentbleubleu> sure we sould play with it 07:00 < agentbleubleu> while its repairing 07:00 < irgeek> I want to see how it's doing with memory. 07:00 < agentbleubleu> ok 07:00 < irgeek> And screens are *very* lightweight. 07:01 < agentbleubleu> im in top 07:01 < agentbleubleu> shall i pastebin it 07:01 < irgeek> Sure. 07:01 < agentbleubleu> http://pastebin.linode.com/893 07:01 * Talman test. 07:02 < irgeek> You can get back the the MySQL screen with Crtl-a then p 07:02 < agentbleubleu> 893004k used, 07:02 < agentbleubleu> its ok i opened a new window 07:03 < agentbleubleu> thats why it was crashing 07:04 < irgeek> Unlikely. An ssh process doesn't use much memory. 07:04 < agentbleubleu> ok 07:04 < irgeek> Should only be about 3M 07:05 < agentbleubleu> hmm went up to 920M used 07:05 < agentbleubleu> still not crashed yet 07:06 < agentbleubleu> good sign 07:06 < irgeek> Yeah. MySQL is recreating indexes and stuff, so it's going to use a bunch of memory. 07:06 < irgeek> Hopefully there's enough to let it finish. 07:07 < irgeek> But it has lasted a lot longer than the previous try. 07:08 < agentbleubleu> yes looking hopeful 07:13 < irgeek> Still going? 07:14 < mattt> anyone know of a good wordpress plugin for displaying shell output in a post? 07:14 < irgeek>
07:14 < irgeek> ;) 07:15 < mattt> heh 07:15 < mattt> yeah, might have to :) 07:16 < agentbleubleu> yes 07:16 < irgeek> You could use
with some pretty simple css to do it as well. 07:17 < Talman> That's about all a plugin would do. 07:17 < Talman> Maybe automate it a bit with a [code] tag. 07:18 < mattt> yeah, i tried wp-syntax 07:18 < mattt> looks nice, but for straight command-line stuff it doesn't look right 07:20 < irgeek> Doesn't look right how? 07:21 < mattt> for example 07:22 < mattt> 
something | something
07:22 < mattt> it doesn't pring the pipe for some reason 07:22 < mattt> doing 
# ls -al /root
then it treats the command as comment 07:24 < irgeek> I'm guessing wp-syntax is munging the 
 tag based on the lang= bit?
07:24 < mattt> yepper
07:25 < mattt> if i use lang="", works great ... no highlighting ... but then pipes don't get displayed for whatever reason
07:25 < irgeek> The pipe not displaying sounds like a problem with wp-syntax - it's a valid command.
07:25 < irgeek> As for the other, # does begin a comment in bash so...
07:26 < mattt> yep
07:26 < irgeek> Er, pipe is a valid character is what I meant to say...
07:26 < mattt> but i'm using # as a shell prompt :)
07:26 < mattt> to indicate root user
07:27 < agentbleubleu> its still going
07:27 < irgeek> Change the prompt to [root@hostname] $
07:27 < StevenK> mattt: What about if you use | instead of '|' ?
07:27 < irgeek> agentbleubleu: Has it hit swap yet?
07:27 < agentbleubleu> no
07:28 < irgeek> We might have a winner!
07:28 < mattt> StevenK: nope, that doesn't work :/
07:29 < agentbleubleu> cool, im hoping
07:29 < mattt> StevenK: and if i just put a | in the html source it says  ... wtf?  :)
07:30 < irgeek> mattt: What about 
\# ls -al /root

07:30 < jadoba> that might be stupid enough to work
07:37 < irgeek> Or 
# ls -al /root

07:37 < mattt> nope
07:37 < mattt> the backslash doesn't work
07:37  * fred tidies his room and finds a Q6600 in the process.... neat :)
07:38 < jadoba> congratulations!
07:38 < irgeek> And Q6600 would be what now?
07:38 < fred> An Intel EM64T quad-core
07:38 < mattt> ># doesn't work either :)
07:38 < irgeek> Oh.
07:38 < mattt> err #
07:38 < jadoba> fred: i can help do some housework
07:39 < jadoba> need a basement or a garage sorted?
07:40  * fred guesses you're on the wrong continent :p
07:40 < irgeek> Ah ha! #
 ls -al /root

07:41  * irgeek bets that works, bitches!
07:41 < mattt> not even close
07:41  * fred passes irgeek some "SCIENCE!"
07:41 < mattt> wp-syntax uses these nice css boxes
07:41 < irgeek> o_O
07:41 < mattt> so the # would sit outside the box :)
07:42 < Alucard> Jun 13 07:03:27 lucidchat sshd[27113]: refused connect from li25-164.members.linode.com (::ffff:70.87.222.164)
07:42 < Alucard> hmmm
07:42 < irgeek> Ah fsck. They make it display: block, don't they. :\
07:43 < mattt> irgeek: yeah, looks nice ... 
07:45 < mattt> i guess i'll just use 
, but then i have to fix all my >'s and <'s
07:46 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has quit [Quit: Into the dark I fade..]
07:47 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has joined #linode
07:48 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode
07:52 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Read error: Connection reset by peer]
07:52 -!- binel_ [~h00s@78-1-169-32.adsl.net.t-com.hr] has joined #linode
07:54 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Ping timeout: 480 seconds]
07:55 -!- Levia [~Levia@ipd50a5801.speed.planet.nl] has joined #linode
07:56 < irgeek> agentbleubleu: Is the repair still running? I need to head to bed soon.
07:56 < agentbleubleu> yes
07:56 < agentbleubleu> shit
07:56 < agentbleubleu> ok
07:57 < agentbleubleu> could you tell me how to import the new sql
07:57 < agentbleubleu> the 800Mg one
07:57 < agentbleubleu> using shell
07:58 < irgeek> mysql -u [username] -p < [sql_file]
07:58 < mattt> thanks for your help guys
07:58 < agentbleubleu> [sql_file]? is this a file path
07:58  * mattt is afk
07:58 -!- binel [~h00s@78-1-188-11.adsl.net.t-com.hr] has quit [Ping timeout: 480 seconds]
07:58 < irgeek> Yeah.
07:59 < agentbleubleu> so -p < home/myplaylist/etc
07:59 < irgeek> From inside the mysql program you would use: source [sql_file]
07:59 < irgeek> Yes.
07:59 < agentbleubleu> ok
07:59 < agentbleubleu> how do you set mysql to the right account
07:59 < irgeek> The < tells the shell to feed the file to the program's stdin.
08:00 < agentbleubleu> ok
08:00 < irgeek> That's the -u bit
08:00 < agentbleubleu> as i have 10 db for that user
08:01 < irgeek> Actually, now that I think about it, you may have to do it from inside mysql
08:01 < agentbleubleu> ok
08:01 < irgeek> The < redirect will probably break the password prompt.
08:02 < agentbleubleu> ok
08:02 < agentbleubleu> im looking through my notes i should be able to work it out
08:03 < agentbleubleu> many thanks for all your help
08:03 < irgeek> Just use source from within mysql. That always works because you've already authenticated.
08:03 < agentbleubleu> ok
08:04 < agentbleubleu> thanks for all your time
08:05 -!- bliblok [~bjornar@ti500720a080-4044.bb.online.no] has joined #linode
08:05 < irgeek> Being inside mysql you can also do 'use db_name' to make sure the commands go to the right db if it's already created.
08:06 < irgeek> But now I'm off to sleep. Good luck.
08:06 < agentbleubleu> ok have a good nights sleep
08:06 < agentbleubleu> thansk
08:06 < irgeek> Highlight me when the repair finishes. I'll see it when I wake up.
08:06 < agentbleubleu> ok
08:19 < Alucard> the < works.
08:19 < Alucard> things like: mysql --table -u services -p < nick-counter.sql > offenders.txt
08:19 < Alucard> even work.
08:26 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
08:33 -!- josephb [~josephb@srv4.slash31.com] has quit [Quit: leaving]
08:42 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has quit [Quit: Into the dark I fade..]
08:55 -!- wgrant [~wgrant@c122-108-27-22.eburwd9.vic.optusnet.com.au] has quit [Ping timeout: 480 seconds]
09:12 -!- meff [~meff@adsl-68-90-189-116.dsl.austtx.swbell.net] has joined #linode
09:19 -!- Ontolog [~cdavaz@121.235.229.5] has quit [Ping timeout: 480 seconds]
09:29 -!- Ontolog [~cdavaz@121.235.250.184] has joined #linode
09:33 < agentbleubleu> its still repairing the table
09:33 < agentbleubleu> been repairing for 3 hours
09:49 -!- jm [~fake@c-76-113-194-7.hsd1.mn.comcast.net] has joined #linode
10:02 -!- jm [~fake@c-76-113-194-7.hsd1.mn.comcast.net] has quit [Ping timeout: 480 seconds]
10:22 -!- bob2 [rob@egads.ertius.org] has quit [Remote host closed the connection]
10:36 -!- Schroeder [1000@kntpin04-nas-02-s69.cinergycom.net] has joined #linode
10:37 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has joined #linode
10:40 -!- bob2 [rob@egads.ertius.org] has joined #linode
10:51 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Remote host closed the connection]
11:06 -!- AlexD [~56791486@webuser.linode.com] has joined #linode
11:06 < AlexD> Hello
11:07 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
11:09 < Alucard> hi
11:11 -!- AlexD [~56791486@webuser.linode.com] has quit [Remote host closed the connection]
11:16 -!- randyh [~qbasicer@fctnnbsc27w-142166207120.pppoe-dynamic.nb.aliant.net] has joined #linode
11:16 -!- randyh [~qbasicer@fctnnbsc27w-142166207120.pppoe-dynamic.nb.aliant.net] has left #linode [Raising Skinny Elephants Is Utterly Boring]
11:30 -!- Mojo1978 [~Mojo1978@ip-78-94-126-28.hsi.ish.de] has quit [Read error: Connection reset by peer]
11:40 < mwalling> agentbleubleu: you're still alive? ;)
11:46 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
11:49  * linbot is
11:50 -!- agentbleubleu [~agentbleu@lns-bzn-38-82-253-119-128.adsl.proxad.net] has quit [Read error: Connection reset by peer]
11:51 -!- agentbleubleu [~agentbleu@lns-bzn-32-82-254-55-250.adsl.proxad.net] has joined #linode
11:51 < agentbleubleu> hi
11:51 < agentbleubleu> not sure
11:52 < agentbleubleu> actually my network is pretty dead
11:52 < agentbleubleu> I crashed a large db table, by trying to import another large table, and now waiting (over 4 hours) for it to repair
11:54 -!- TrevorP [~trevorp@122-148-134-101.static.dsl.dodo.com.au] has joined #linode
12:02 < mwalling> oops
12:03 -!- lakin [~lakin@S01060013101832cd.cg.shawcable.net] has joined #linode
12:03 < agentbleubleu> yes, bit of a agentbleu special
12:15 -!- xitology [~xi@78.31.182.24] has joined #linode
12:17 < mwalling> my fs went ro!
12:17 < mwalling> er... wtf... i hit the oom killer too
12:20 < mwalling> http://p.linode.com/894
12:20 -!- mwalling [mwalling@you.dontlike.us] has quit [Quit: rebootin]
12:25 -!- mwalling [~mwalling@cpe-24-195-219-59.nycap.res.rr.com] has joined #linode
12:25 -!- mwalling is now known as Guest636
12:25 < Guest636> damn enforce
12:26 -!- Guest636 is now known as mwalling
12:32 -!- SkiddieBot [mwalling@you.dontlike.us] has quit [Ping timeout: 480 seconds]
12:34 -!- mwalling [~mwalling@cpe-24-195-219-59.nycap.res.rr.com] has quit [Quit: Ex-Chat]
12:34 -!- mwalling [mwalling@you.dontlike.us] has joined #linode
12:35 -!- SkiddieBot [mwalling@you.dontlike.us] has joined #linode
12:47 < caker> mwalling: 1k bs?
12:47 < mwalling> what ever the control panel makes the images
12:47 < mwalling> (and i dont remember how to check)
12:47 < caker> tune2fs -l /dev/xvdb | grep "Block size"
12:48 < mwalling> yeah, 1k
12:48 < caker> any idea what you did to trigger it?  Mike's been working on a thrash-fs script to try and reproduce
12:49 < mwalling> oom went off right before it according to dmesg
12:50 < mwalling> i got an email from cron with a python traceback that said /home was readonly, and saw those lines in dmesg
12:50 -!- digx [~rick@c-76-109-201-140.hsd1.fl.comcast.net] has joined #linode
13:03 < agentbleubleu> After 5 hours of trying to repair the crashed table it has given this :Read from remote host 66.160.141.87: Operation timed out
13:03 < agentbleubleu> Connection to 66.160.141.87 closed.
13:05 < agentbleubleu> in show processes it has this still, indicating it is still working? http://pastebin.linode.com/895
13:06 < agentbleubleu> and top says high memory usage is still being used : http://pastebin.linode.com/896
13:06 < agentbleubleu> any suggestions anyone?
13:13 -!- sveiss [~sveiss@host86-139-70-68.range86-139.btcentralplus.com] has joined #linode
13:13 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
13:15 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode
13:19 -!- lansti1 [~lanstin@www.austin-lane.net] has joined #linode
13:21 < caker> agentbleubleu: 100% idle?  I'd say it's not doing anything
13:22 < agentbleubleu> shit
13:22 < agentbleubleu> ok
13:22 < agentbleubleu> any idea what to do next
13:22 < caker> restart mysql?
13:23 < agentbleubleu> I have tried that but it didnt repair the table
13:23 < agentbleubleu> current memory being 899688k used,
13:23 < agentbleubleu> this is very high no?
13:24 < Napta> Not if you have an 800MB SQL database in memory
13:24 < Napta> and linux will cache all your ram anyways, for the most part
13:25 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has joined #linode
13:25 < agentbleubleu> ah
13:25 < agentbleubleu> so what should i do then
13:28 < mwalling>  buy a bighger linode?
13:28 < mwalling> :)
13:28 < agentbleubleu> I have im on a 1g2 now
13:28 < agentbleubleu> something like that
13:28 < agentbleubleu> Mem:   1198280k total,
13:28 < mwalling> !avail
13:28 < linbot> mwalling: Linode360 - 29, Linode540 - 51, Linode720 - 20, Linode1080 - 12, Linode1440 - 8, Linode2880 - 4
13:30 < agentbleubleu> what do you suggest
13:33 -!- semih_33 [~yudum@78.190.65.131] has joined #linode
13:33 -!- Kysszz [~elenur@78.179.138.136] has joined #linode
13:33 -!- Xylia26 [~ece@78.179.138.136] has joined #linode
13:33 -!- Kysszz [~elenur@78.179.138.136] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 17:33:10)]
13:33 -!- Xylia26 [~ece@78.179.138.136] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 17:33:10)]
13:33 -!- semih_33 [~yudum@78.190.65.131] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 17:33:10)]
13:33 -!- firuze [~mevlude@78.191.5.246] has joined #linode
13:33 -!- firuze [~mevlude@78.191.5.246] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 17:33:20)]
13:43 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
13:44 -!- tlogic [~user@adsl46-119.ath.forthnet.gr] has joined #linode
13:49 -!- Schroeder [1000@kntpin04-nas-02-s69.cinergycom.net] has quit [Ping timeout: 480 seconds]
13:51 -!- r3z` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has joined #linode
13:51 < agentbleubleu> caker, Im trying to repair a table, I have ungraded mem to 1g1, do you think i should upgrade it more, the table is about 800M- 1G in size
13:53 < Napta> If you have a 1GB database you may very well need up to 2GB of ram to repair it
13:53 < agentbleubleu> thanks Napta
13:53 < Napta> or 2GB of "memory"
13:54 < agentbleubleu> ok
13:54 -!- tlogic [~user@adsl46-119.ath.forthnet.gr] has quit [Ping timeout: 480 seconds]
13:54 < agentbleubleu> caker do you mind if I upgrade and then revert back when all this is over? 
13:54 < Napta> The theory being that if you feed it enough ram, it will work fine, so you should aim to atleast double it - it's only a temp measure anyways
13:54 < agentbleubleu> ok
13:56 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode
13:56 < agentbleubleu> can only add 360 at a time
13:57 -!- Navi__ [~Navi@a82-95-218-113.adsl.xs4all.nl] has joined #linode
13:57 -!- r3z`` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has quit [Ping timeout: 480 seconds]
13:59 -!- kassah-lappy [~kassah@66-232-76-197.ctcweb.net] has quit [Quit: Ex-Chat]
13:59 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has quit [Remote host closed the connection]
14:00 -!- naciye [~brandix45@78.168.103.160] has joined #linode
14:00 -!- naciye [~brandix45@78.168.103.160] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 18:00:30)]
14:00 < mwalling> what about swap?
14:01 < agentbleubleu> swap was at 256 not used
14:01 < agentbleubleu> i have added 720m ram
14:01 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Ping timeout: 480 seconds]
14:02 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
14:02 < agentbleubleu> Mem:   1935560k total,
14:04 -!- Navi_ [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Ping timeout: 480 seconds]
14:07 < agentbleubleu> Napta: how long do you think it should take, I now have about 2G ram 
14:07 < Napta> Im sorry, I do not know. As irgeek said earlier, get a sandwhich ;)
14:07 < Napta> better yet, watch the euro ;)
14:12 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has joined #linode
14:13 -!- Navi__ is now known as Navi
14:13 < HoopyCat> agentbleubleu: pastebin the output of "free" and "vmstat 1 10"?
14:13 < agentbleubleu> ok
14:13 < HoopyCat> (while stuff is running, if it is running, of course)
14:15 < agentbleubleu> http://pastebin.linode.com/898
14:16 -!- linville [~linville@sapphire.tuxdriver.com] has joined #linode
14:16 < agentbleubleu> http://pastebin.linode.com/899 this is what im doing to repair it
14:16 -!- kassah-lappy [~kassah@66-232-76-197.ctcweb.net] has joined #linode
14:18 < HoopyCat> well, you're using ~370mb of memory, not swapping actively, not doing much I/O, and not using any CPU at all really
14:19 < agentbleubleu> yes,
14:19 < agentbleubleu> so is it not repairing?
14:19 < HoopyCat> standby, emergency
14:20 < HoopyCat> PRO TIP: butter's smoke point is significantly lower than olive oil's
14:22 < HoopyCat> agentbleubleu:  best as i can tell, the repair function consists of sys.stdout.write("Repairing tables\n") then time.sleep(600) -- you might wanna see if there's a mysql IRC channel
14:23 < agentbleubleu> there is, im on it, not much luck so far
14:23 < agentbleubleu> ok thanks 
14:23 < HoopyCat> yeah, i don't do too much with mysql and haven't yet fried a db enough to need it
14:24 < agentbleubleu> ok
14:25  * HoopyCat recharges his Ron Popeil's Pocket Halotron
14:25 < Napta> Do the Loonix Xen distros have their level of 'swapiness' adjusted by default?
14:25 < HoopyCat> agentbleubleu:  btw, the vmstat command gives you a nice summary of what's going on memory, i/o, and cpu-wise... the first info line it prints is the averages since boot, then each line thereafter (at 1 second intervals for a total quantity of 10) shows you what's happened since then
14:26 -!- linville [~linville@sapphire.tuxdriver.com] has quit [Quit: Leaving]
14:26 < agentbleubleu> ok.
14:26 < agentbleubleu> btw i think that table might be about 2g 
14:26 < agentbleubleu> last back up was about 5 weeks ago and it was 1g1 then
14:27 < HoopyCat> agentbleubleu:  i usually watch swap si/so (swap in/swap out), io bi/bo (blocks in/blocks out), system in/cs (interrupts and context swaps), and cpu (user/system/idle/wait) to figure out bottlenecks
14:27 < agentbleubleu> ok
14:28 < HoopyCat> agentbleubleu:  esp. with vpses, where you can't watchen das blinkenlites
14:28 < agentbleubleu> right
14:28  * CaptObviousman blinks at HoopyCat 
14:28 < HoopyCat> Napta:  i don't believe so; every one i've done so far defaults to 60
14:28 < Napta> oh ok
14:28  * HoopyCat determines CaptObviousman is I/O-bound
14:29  * CaptObviousman thrashes HoopyCat's disc
14:29 < HoopyCat> Napta:  i usually set mine to 100
14:43 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has quit [Ping timeout: 480 seconds]
14:43 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has quit [Read error: Connection reset by peer]
14:48 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has joined #linode
15:04 -!- lansti1 [~lanstin@www.austin-lane.net] has left #linode []
15:06 -!- metaperl [~metaperl@cpe-75-187-102-204.insight.res.rr.com] has quit [Ping timeout: 480 seconds]
15:13 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has joined #linode
15:21 -!- metaperl [~metaperl@cpe-75-187-102-204.insight.res.rr.com] has joined #linode
15:37 -!- Mojo1978 [~Mojo1978@ip-78-94-126-28.hsi.ish.de] has joined #linode
15:38 -!- FloodServ [services@services.oftc.net] has quit [Service unloaded]
15:38 -!- FloodServ [services@services.oftc.net] has joined #linode
15:38 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
15:44 < agentbleubleu> Bdragon are you about?
15:49 -!- mendel [kiwi@76-10-159-31.dsl.teksavvy.com] has quit [Ping timeout: 480 seconds]
15:50 -!- kassah-lappy [~kassah@66-232-76-197.ctcweb.net] has quit [Remote host closed the connection]
15:58 < mwalling> caker: btw that happened on 2.6.18.8-domU-linode7
16:00 < path-> what you broke linode?  just great.  :(
16:01 < Alucard> not again
16:04 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
16:08 -!- LanceHaig [~lanceh@mx1.redarmour.co.uk] has quit [Ping timeout: 480 seconds]
16:13 < Napta> hmm
16:13 < Napta> I need some sort of auditing facility to monitor users
16:14 -!- Ender [~ender@gciwifi-1.gci.net] has joined #linode
16:14 -!- Talman is now known as Guest662
16:14 -!- Ender is now known as Talman
16:15 -!- Guest662 [~ender@gciwifi-1.gci.net] has quit [Read error: Connection reset by peer]
16:16 < irgeek> Napta: Cluestick!
16:17 < Peng> http://www.theregister.co.uk/2008/06/13/avg_scanner_skews_web_traffic_numbers/ <-- They've used almost 300 KB of my bandwidth!
16:18 < Napta> oh?
16:19 < Napta> I would usually use grsec and/or the linux auditing framework on a physical box, but I dare not bother patching a Xen kernel with grsec heh
16:20 < path-> get users you trust
16:21 < Alucard> invent cold fusion
16:21 < irgeek> I'm pretty sure process accounting would work under Xen. Although that's only useful if your users don't have root access.
16:21  * iggy wonders which will happend first
16:24  * Peng wanders off.
16:24 < tjfontaine> iggy: cold fusion obviously
16:25 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
16:29 < Napta> path-: hahaha
16:29 < Napta> path-: or an operating system with better auditing capabilities perhaps
16:29 < path-> you give them all root access or something?
16:30 < Napta> nah, a long time frined of mine was just caught doing some semi-nefarious activities
16:30 < agentbleubleu> irgeek you back
16:30 < Napta> A concerned administrator e-mailed me regarding odd entries in his http logs, turns out there was a port scan or two heh
16:30 < Napta> sad sad day
16:31 < irgeek> See! Cluestick was the right answer,
16:31 < irgeek> agentbleubleu: yup
16:31 < Napta> Since I neither have the time to proactively monitor the server I've just decided to delete him
16:31 < agentbleubleu> oh savour
16:31 < path-> tell him to get his own vps if he wants to do that.. if he's using your host, he should respect you
16:31 < Napta> absolutely
16:31 < irgeek> Still having problems?
16:31 < path-> if he doesn't have respect for your wishes, then you have problems
16:31 < agentbleubleu> i now got 2 g ram
16:31 < agentbleubleu> still cannot repair
16:31 < agentbleubleu> after doing repair it freezes
16:31 < irgeek> Is it failing? Or just not working?
16:31 < Napta> path-: nothing that pkill -u $LUSER && passwd -l $LUSER does not solve, though ;)
16:31 < path-> heh
16:32 < agentbleubleu> it looks like its doing nothing 
16:32 < agentbleubleu> but at the same time says it is
16:32 < agentbleubleu> 5 hours for one 
16:32 < agentbleubleu> then nothing
16:32 < agentbleubleu> dropped connection. ram looked like it was not being used 
16:33 < agentbleubleu> looking at free and vmstat
16:33 < agentbleubleu> i was just looking at http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html
16:33 < agentbleubleu> myisamchk 
16:33 < irgeek> Are they myisam tables?
16:34 < agentbleubleu> i think so, but im a bit unsure as to work out how
16:35 -!- exor|zzz is now known as exor674
16:36 < agentbleubleu> irgeek: Are they myisam tables? how do you tell
16:37 < irgeek> In mysql do: show create table [table_name];
16:37 < irgeek> At the end is will say ENGINE=whatever
16:37 < agentbleubleu> i think that is going to cause some problems
16:37 < agentbleubleu> sec
16:37 < agentbleubleu> i dont think hat command works it just hangs
16:37 < agentbleubleu> i try
16:38 < agentbleubleu> ERROR 1046 (3D000): No database selected
16:39 < agentbleubleu> use myplaylist and select myplaylist dont work
16:39 < agentbleubleu> ERROR 1054 (42S22): Unknown column 'myplaylist' in 'field list'
16:39 < agentbleubleu> mysql> select myplaylist;
16:40 < Alucard> show databases
16:40 < agentbleubleu> that shows them all
16:41 < agentbleubleu> it is therre
16:41 < agentbleubleu> | myplaylist               | 
16:41 < Alucard> and "use myplaylist;" gives "Unknown column 'myplaylist' in 'field list'" ?
16:41 < agentbleubleu> yes
16:41 < Alucard> um
16:41 < Alucard> it's broke
16:41 < agentbleubleu> i think so 
16:41 < agentbleubleu> any more ideas?
16:42 < irgeek> Is a repair running?
16:42 < agentbleubleu> no
16:43 < agentbleubleu> was i stopped it
16:43 < agentbleubleu> shall i restart server
16:43 < irgeek> Try restarting MySQL
16:43 < agentbleubleu> i did im rebooting sys
16:44 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
16:45 < agentbleubleu> mysql> use myplaylist;
16:46 < agentbleubleu> Reading table information for completion of table and column names
16:46 < agentbleubleu> You can turn off this feature to get a quicker startup with -A
16:46 < agentbleubleu> Database changed
16:46 < Alucard> reboots solve /everything/
16:46 < agentbleubleu> different error now
16:47 < irgeek> Does this work now: show create table [table_name];
16:47 < agentbleubleu> ERROR 144 (HY000): Table './myplaylist/playlist' is marked as crashed and last (automatic?) repair failed
16:47 < agentbleubleu> mysql> show create table playlist;
16:48 < HoopyCat> alrighty, my old home state is screwed; they're about to force a mandatory evacuation of Hills, Iowa due to rising flood waters
16:48 < guinea-pig> fun!
16:48 < irgeek> Are those lines swapped?
16:48 < agentbleubleu> lines swapped?
16:49 < agentbleubleu> myplaylist is the database, and playlist is the table
16:49 < irgeek> As in, did that command output the error you pasted before it?
16:49 < Alucard> you pasted the error before the command
16:49 < irgeek> basically, what was the output of show create table playlist;
16:49 -!- kupesoft [~dave@CPE003018b02a53-CM0018c0c44e76.cpe.net.cable.rogers.com] has joined #linode
16:49 < agentbleubleu> yes
16:49 < agentbleubleu> ther are swapped
16:50 < agentbleubleu> ssorry
16:50 < guinea-pig> > You have died.
16:50 < agentbleubleu> ;(
16:50 < guinea-pig> > You are likely to be eaten by a grue
16:50 < guinea-pig> confusion!
16:50 < agentbleubleu> hmm
16:51 < Alucard> > You are already dead.
16:51 < agentbleubleu> mysql> show create table playlist; after this I get : ERROR 144 (HY000): Table './myplaylist/playlist' is marked as crashed and last (automatic?) repair failed
16:51 < guinea-pig> textual memento
16:53 < agentbleubleu> come on guys i have faith in you
16:53 < agentbleubleu> cant you give me the kiss of life
16:53 < guinea-pig> ew
16:53  * tjfontaine dispenses mononucleosis
16:54 < agentbleubleu> lol
16:54 < mikegrb> lolz
16:54 < irgeek> Do: ls -l /var/lib/mysql/myplaylist/
16:55 < irgeek> Does that show playlist.MYD, playlist.MYI & playlist.frm?
16:56 < agentbleubleu> mysql> ls -l /var/lib/mysql/myplaylist/
16:56 < agentbleubleu>     -> 
16:56 < agentbleubleu> thats what i get
16:56 < agentbleubleu> this silly ->
16:56 < agentbleubleu> sign
16:56 < agentbleubleu> nothing else
16:56 < irgeek> Not inside mysql....
16:56 -!- Sputnik7 [~Sputnik7@c-71-192-5-190.hsd1.ma.comcast.net] has quit [Quit: -=SysReset 2.53=-]
16:56 < agentbleubleu> ah
16:56 < agentbleubleu> ok
16:57 -!- xitology [~xi@78.31.182.24] has quit [Quit: Ex-Chat]
16:57 < agentbleubleu> http://pastebin.linode.com/902
16:58 < Alucard> is your playlist supposed to be 740MB?
16:58 < irgeek> Ok. Those look like myisam tables.
16:58 < irgeek> Alucard: It is. That's the problem.
16:58 < Alucard> heh
16:58 < agentbleubleu> yes i think they are  myisam, i remember seeing that somewhere
16:59 < agentbleubleu> i think the playlist is bigger than 740Mg
17:00 < irgeek> Ok. To you use the myisam* tools you need to stop MySQL first.
17:00 -!- Sputnik7 [~Sputnik7@c-71-192-5-190.hsd1.ma.comcast.net] has joined #linode
17:00 < agentbleubleu> ok
17:00 < agentbleubleu> np
17:00 < agentbleubleu> mysql stopped
17:01 < irgeek> Are you on Ubuntu?
17:02 < irgeek> Well, you're on some Debian anyway, I know that much.
17:02 < irgeek> We're going to stuff a copy of the files away for later in case they get fscked.
17:03 < agentbleubleu>  Debian anyway
17:03 < agentbleubleu> good idea
17:04 < irgeek> Assuming you have free space (df -h) do this (as root): tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist
17:05 < agentbleubleu> should have loads of space
17:05 < irgeek> I typoed: tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist.*
17:05 < agentbleubleu> tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist.*
17:05 < agentbleubleu> like this
17:06 < irgeek> yes
17:06 < agentbleubleu> li6-87:~# tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist.*
17:06 < agentbleubleu> tar: playlist.*: Cannot stat: No such file or directory
17:06 < agentbleubleu> tar: Error exit delayed from previous errors
17:06 < Alucard> extra space there?
17:06 < agentbleubleu> Local disk space 	14.29 GB total, 5.27 GB used
17:07 < irgeek> Stupid shell expansion: tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist.MYD playlist.MYI playlist.frm
17:08 < agentbleubleu> ok
17:08 < agentbleubleu> doing something
17:08 < irgeek> It will take a minute to run because it's creating a huge file.
17:08 < agentbleubleu> sure
17:09 < agentbleubleu> ok seems to have done that
17:09 -!- JDLSpeedy [~joe@fl-69-34-4-219.sta.embarqhsd.net] has quit [Quit: Client exiting]
17:10 < irgeek> Now do: cd /var/lib/mysql/myplaylist
17:11 < irgeek> Then as root or the mysql user: myisamchk playlist
17:12 < agentbleubleu> done
17:12 < agentbleubleu> myisamchk: error: Recordlink that points outside datafile at 739371932
17:12 < agentbleubleu> MyISAM-table 'playlist' is corrupted
17:12 < agentbleubleu> Fix it using switch "-r" or "-o"
17:14 < irgeek> Again as root or the mysql user: myisamchk --repair playlist
17:14 < irgeek> Er: myisamchk --recover playlist
17:15 -!- sveiss [~sveiss@host86-139-70-68.range86-139.btcentralplus.com] has left #linode []
17:15 -!- sveiss [~sveiss@host86-139-70-68.range86-139.btcentralplus.com] has joined #linode
17:16 < irgeek> Did you start that yet?
17:17 < HoopyCat> !download
17:17 < linbot> http://www.linode.com/forums/viewtopic.php?t=2636
17:18 < agentbleubleu> just working it out
17:18 < agentbleubleu> so go into mysql
17:19 < irgeek> No. You need to be in the directory with the table files.
17:19 < irgeek> Also we can boost the memory usage to speed it up...
17:19 -!- Navi [~Navi@a82-95-218-113.adsl.xs4all.nl] has quit [Quit: Navi]
17:19 < agentbleubleu> hmm
17:19 < agentbleubleu> sorry irgreek 
17:19 < agentbleubleu> little lost, 
17:20 < agentbleubleu> li6-87:/var/lib/mysql/myplaylist# cd
17:20 < agentbleubleu> li6-87:~# 
17:20 < agentbleubleu> which one
17:21 < irgeek> You need to be in /var/lib/mysql/myplaylist
17:21 < agentbleubleu> ok
17:21 < irgeek> Then do: Try this: myisamchk --sort_buffer_size=64M --key_buffer_size=64M --read_buffer_size=4M --write_buffer_size=4M --recover playlist
17:21 < agentbleubleu> sec pls
17:25 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
17:25 < agentbleubleu> doing now
17:27 < irgeek> The temporary repair table will probably eat up a bunch of disk, but you have enough so it shouldn't be a problem.
17:27 < agentbleubleu> Found block that points outside data file at 739371944
17:27 < agentbleubleu> - Fixing index 2
17:27 < agentbleubleu> - Fixing index 3
17:27 < agentbleubleu> - Fixing index 4
17:27 < agentbleubleu> - Fixing index 5
17:27 < agentbleubleu> Data records: 35040
17:27 < agentbleubleu> li6-87:/var/lib/mysql/myplaylist# 
17:27 < agentbleubleu> back to prompt
17:28 -!- ang [~ang@ip24-250-16-162.ri.ri.cox.net] has quit [Ping timeout: 480 seconds]
17:29 < irgeek> Do: myisamchk playlist
17:29 < agentbleubleu> ok
17:29 < agentbleubleu> done
17:30 < irgeek> And it's ok? o_O That was too easy.
17:30 < agentbleubleu> lol
17:30 < mikegrb> lolz
17:30 < agentbleubleu> my girlfriend wants to invite you to a party
17:30 < agentbleubleu> its sat night we have drinks
17:30 < agentbleubleu> and loads more
17:31 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
17:31 < irgeek> Ok, pastebin: ls -l
17:31 < agentbleubleu> ok
17:31 < agentbleubleu> http://pastebin.linode.com/903
17:32 < irgeek> Several people have offered me money for help in here, but that's the first party invitation.
17:32 < agentbleubleu> yea ha
17:32 < agentbleubleu> its all working
17:33 < agentbleubleu> you fucking genus
17:33 < irgeek> Now run a backup ;)
17:33 < agentbleubleu> in the time that you was asleep I had a right load of nonse from that lot off the irc mysql group you wouldnt belive it
17:33 < agentbleubleu> lol
17:33 < mikegrb> lolz
17:33 < agentbleubleu> good idea
17:34 < irgeek> Quick backup is stop MySQL and tar the directory up.
17:34 < agentbleubleu> ok
17:34 < agentbleubleu> that sounds interesing
17:34 < agentbleubleu> so like before
17:35 < irgeek> tar -cf /root/bd_backup.tar -C /var/lib/mysql/ [db_name]
17:35 < irgeek> That will doe the whole db instead of just the one table.
17:36 < agentbleubleu> stop mysql then tar -cf /root/playlist.tar -C /var/lib/mysql/myplaylist/ playlist.*
17:36 < agentbleubleu> aha
17:36 < agentbleubleu> right
17:36 < agentbleubleu> wicked
17:36 < agentbleubleu> is there a way i can do all the databases 
17:36 < irgeek> But yes, stop MySQL.
17:36 < agentbleubleu> at once
17:36 < agentbleubleu> yes
17:40 < tjfontaine> ^using MySQL :)
17:40 < agentbleubleu> do i have to cd first out of that database
17:41 < irgeek> It doesn't matter.
17:41 < agentbleubleu> li6-87:/var/lib/mysql/myplaylist# tar -cf /root/bd_backup.tar -C /var/lib/mysql/myplaylist
17:41 < agentbleubleu> tar: Cowardly refusing to create an empty archive
17:41 < agentbleubleu> Try `tar --help' or `tar --usage' for more information.
17:41 < bd_> why do people keep hilighting me :|
17:42 < irgeek> You missed the space between /var/lib/mysql/ & myplaylist
17:42 < agentbleubleu> ah
17:42 < tjfontaine> bd_: you're important
17:43 < agentbleubleu> is bd = bdragon
17:43 < agentbleubleu> ok backup made
17:44 < bd_> agentbleubleu: no
17:45 < agentbleubleu> ok
17:45 < irgeek> Now restart MySQL and see if you can get the other massive DB to import.
17:46 < agentbleubleu> oh bigger i didnt shut off mysql wen i made the backup, but it seemed to work?
17:47 < bd_> agentbleubleu: no, it didn't
17:47 < agentbleubleu> ah
17:47 < agentbleubleu> ok
17:47 < agentbleubleu> buger
17:47 < bd_> agentbleubleu: There'll be random corruption in the backup
17:47 < agentbleubleu> i do it again
17:47 < agentbleubleu> ok
17:48 < mattt> agentbleubleu: jeez man, still trying to recover that db?
17:48 < agentbleubleu> yea done now
17:48 -!- kuzetsa [~changuard@69.92.6.128] has joined #linode
17:48 < agentbleubleu> u know me everything takes 20 times longer than it could
17:49 < mattt> ah, you're done ... good!
17:49 < agentbleubleu> right done another back up
17:49 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has quit [Ping timeout: 480 seconds]
17:49 < kuzetsa> greetings. I have an enthusiastic question regarding support for gentoo 2007.0, and the "roll your own distribution and upload" option
17:49 < tjfontaine> masochist ye is
17:50 < kuzetsa> mainly I'm curious about 2.6.x kernel / glibc support for native posix
17:50 < bd_> kuzetsa: NPTL you mean?
17:50 < kuzetsa> yep
17:50 < bd_> it should Just Work (unless you're on uml and choose a 2.4 kernel for some insane reason)
17:51 < agentbleubleu> irgeek: how do i import the sql, its on the server, so something like this: mysql -u uname -p dbname < path/yourfile.sql
17:51 < kuzetsa> ah... I was confused by the "portage tree" recently (been a few years since I touched gentoo) and the fact that glibc 2.5.1 explititly specifies the "nptl nptl-only" flags, but is masked for most CPU architectures
17:53 < irgeek> agentbleubleu: That should work.
17:53 < kuzetsa> then... if I got a linode today I could upload an "upgrade" tarball to insantly go from gentoo 2007.0 snapshot to the latest stable builds I'm comfortable with?
17:53 < agentbleubleu> ok
17:54 < bd_> kuzetsa: nptl-only should be fine. Newer versions of glibc only support nptl-only in fact
17:54 < bd_> kuzetsa: and, if you're just going to upload a tarball of the entire system, it's better not to use a snapshot, but instead use finnix to mount an empty filesystem, then just rsync everything up all at once
17:54 < kuzetsa> oh, so that's why there was no mention of nptl or nptl-only for 2.6.1?
17:54 < bd_> probably
17:55 < kuzetsa> I guess my glibc 2.6.1 should be fine then (it's the latest x86 stable)
17:56 -!- LadyNikon [nikon@antenora.aculei.net] has joined #linode
17:56 < LadyNikon> ah
17:56 < LadyNikon> i always forget which server til i connect to the wrong one
17:57 < kuzetsa> only other thing I'm curious about is what hardware I should have kernel support for, and weather I have any way of controlling the bootloader for testing a new 2.6.x kernel build (if it's not already using 2.6.23.17 like I want -- that's the most recent kernel that has the modules I want)
17:58 < tjfontaine> you don't get to build the kernel, just the modules
17:58 < tjfontaine> http://www.linode.com/support/kernels.cfm
17:58 < tjfontaine> what's available currently
18:01 < kuzetsa> tjfontaine: thanks so much
18:01 < kuzetsa> well there we go. 2.6.23.17 is one of the options (there are modules for that one that I need)
18:02 < kuzetsa> I love that kernel -- it even runs good on my ps-3 lol
18:02 < mikegrb> lolz
18:02 < tjfontaine> I think that might be a uml only kernel, I think xen kernels are the 2.6.18 .24 and .25
18:03 < kuzetsa> actually, yeah. I wanted uml support so... if it's already patched for that, perfect!
18:04 < tjfontaine> uml is being phased out, what exactly do you need in your custom distro?
18:05 < kuzetsa> just wanted to be able to test "sandbox" style process isolation (spawn a new uml-based kernel beneath a 2.6.23.17 kernel)
18:06 < kuzetsa> and I would be feeding the uml kernel a squashfs or similar for it's root
18:08 -!- TheFirst [gaveup@your.friendly.neighborhood.hellmouth.info] has joined #linode
18:10 < kuzetsa> just a matter of some serriously buggy stuff that sometimes crashed in an ugly way. I wouldn't want to crash my linode by running it without isolation.
18:11  * HoopyCat answers the red phone
18:11 < irgeek> I thought the UML extensions were all in the guest kernel? In which case, you could certainly compile a UML guest kernel to run under Xen or UML.
18:12 < HoopyCat> kuzetsa:  compile a kernel with ARCH=um and it'll work just fine and dandiliciously
18:12 < HoopyCat> (at least under xen; haven't tried it under uml, for the same reason i don't feed my beef cattle hamburgers)
18:12 < kuzetsa> heh
18:13  * irgeek has fed bacon to pigs
18:13 < irgeek> They like it too.
18:13 < kuzetsa> great... yeah. I do odd things like .NET <--> mono portability testing
18:13 < HoopyCat> irgeek:  me too
18:13 < tjfontaine> mono++ (mostly)
18:14  * path- feeds HoopyCat Soylet Green
18:14 < HoopyCat> irgeek:  i felt bad, and i got yelled at, but at least it kept winston from trying to impregnate my leg long enough for me to make a sandwich
18:14 < irgeek> kuzetsa: You'll probably want bigger than a Linode360 if you're going to be booting UML kernels.
18:14 < HoopyCat> irgeek:  depends on how much RAM is needed; i usually run with 64mb
18:15 < irgeek> Not much runs in 64M
18:15 < irgeek> My first Linode was a Linode64.
18:15 < irgeek> It swapped a lot.
18:15 < tjfontaine> mod_mono won't be happy with it :)
18:15 < path-> init=/usr/bin/vim
18:15 < kuzetsa> irgeek: lol sure it does, my dd-wrt router only has way less than that
18:15 < mikegrb> lolz
18:15 < agentbleubleu> irgeek: that import crashed half way through. the mysql is down again
18:16 < HoopyCat> just remember that your sub-uml will use all the memory you give it, and them's the breaks.  :-)
18:16 < irgeek> agentbleubleu: Bugger.
18:16 < agentbleubleu> thats for sure
18:17 < kuzetsa> yeah, I tried using an ugly hack once that shared memory pages with the host OS but that was a little to experimental for my tastes
18:17 < kuzetsa> heck, vmware player has that feature enabled by default
18:18 < irgeek> agentbleubleu: Is MySQL thrashed or is it living but db your were importing is thrashed?
18:18 < agentbleubleu> not sure its all thrashed
18:18 < agentbleubleu> just trying to restart mysql but thats not working
18:18 < irgeek> Oh dear.
18:19 < agentbleubleu> rebootning
18:20 -!- dvgrhl [~Jon@c-24-16-172-54.hsd1.mn.comcast.net] has quit [Ping timeout: 480 seconds]
18:20 < agentbleubleu> i think i will bring that data in another way
18:20 < internat85> so did you get the crashed tables problem fixed? or is that what your still working on?
18:21 < agentbleubleu> i have to change it anyway, from encoded to plan text anyway, (yes we managed to fix the fucked table0
18:21 < internat85> excellent.. was all you did add extra ram? that solved it?
18:22 < internat85> <== went to bed just as you were adding more ram
18:22 < irgeek> internat85: No. Shutting down MySQL and using myisamchk to repair did it.
18:22 < agentbleubleu> erm not sure that was it
18:22 < agentbleubleu> it was mainly using myisamchk --sort_buffer_size=64M --key_buffer_size=64M --read_buffer_size=4M --write_buffer_size=4M --recover playlist
18:23 < internat85> ah ok
18:23 < agentbleubleu> looks like its crashed that table again ;*(
18:23 < internat85> i think ive stopped using myisam as a database engine in just about everyplace i can
18:24 < irgeek> The same one?
18:24 < irgeek> That's weird.
18:24 < agentbleubleu> not sure looks like it
18:24 -!- Dogu_resimli [~nilifer@78.182.71.249] has joined #linode
18:24 -!- Dogu_resimli [~nilifer@78.182.71.249] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 22:24:50)]
18:24 -!- meryem [~Seinajoki@78.191.109.46] has joined #linode
18:24 -!- meryem [~Seinajoki@78.191.109.46] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 22:24:51)]
18:24 < agentbleubleu> yea both fucked
18:25 < agentbleubleu> the new one and that one
18:26 < agentbleubleu> fixing now
18:26 < irgeek> My simple answer is to drop the new one (assuming the SQL created it not added to it) and then shut down MySQL and put the backup of the other one back.
18:27 < agentbleubleu> ok, i just started a fix
18:28 < agentbleubleu> is there a problem with  MyISAM, and why has internat85: stopped using it
18:29 < irgeek> InnoDB tables have more features but are more disk and memory intensive,
18:29 < agentbleubleu> ok its repaired
18:29 < agentbleubleu> ok
18:30 < agentbleubleu> ok i think what i will do is import the data another way using code, as I have to de serlirise it anyway
18:30 < agentbleubleu> so i will do that tomorrow with a script
18:30 < agentbleubleu> irgreek what do i owe you
18:30 < agentbleubleu> geek not greek 
18:31 < agentbleubleu> lol
18:31 < mikegrb> lolz
18:32 < kuzetsa> hmm... so my kernel will already be isolated thanks to xen and sticking a UML kernel under that may not work?
18:32 < irgeek> agentbleubleu: You don't owe me anything, but donations are always appreciated: http://www.komen.org/
18:32 < agentbleubleu> ok will make another tomorrow. 
18:33 < agentbleubleu> its 12.30 now
18:33 < agentbleubleu> bit fucked.
18:33 < agentbleubleu> many thanks for you help
18:33 < irgeek> No problem.
18:34 < agentbleubleu> I will be back tomorrow, with a recipet
18:34 < agentbleubleu> thanks m8
18:34 < agentbleubleu> nite all
18:34 -!- agentbleubleu [~agentbleu@lns-bzn-32-82-254-55-250.adsl.proxad.net] has quit [Quit: agentbleubleu]
18:38 < kuzetsa> eh, nuts to all that ... I'll just use whatever kernel linode condones and then use qemu if I really have to
18:41 -!- dvgrhl [~Jon@c-24-16-172-54.hsd1.wa.comcast.net] has joined #linode
18:41 < Talman> Hmm.
18:41 < Talman> Command to rebuild postfix's virtusertable.db?
18:42 < path-> postmap
18:42 < Talman> thanks.
18:43 < path-> np
18:43 < internat85> yeah innodb has more things like transactions and referential integreity.. so thats why i like it :)
18:45 < kuzetsa> uh oh... can I use at least use the kqemu module if UML won't work under xen?
18:48 -!- kuzetsa [~changuard@69.92.6.128] has quit [Quit: meh]
18:51 -!- r3z`` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has joined #linode
18:51 -!- r3z` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has quit [Read error: Connection reset by peer]
18:52 -!- ajda-01 [mirc@adsl-62-167-54-44.adslplus.ch] has joined #linode
18:52 -!- ajda-01 [mirc@adsl-62-167-54-44.adslplus.ch] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 22:52:55)]
18:53 -!- Dave^ [~YaraLi_Ce@78.179.205.45] has joined #linode
18:53 -!- Dave^ [~YaraLi_Ce@78.179.205.45] has quit [autokilled: spammers. - Contact support@oftc.net for help. (2008-06-14 22:53:02)]
18:57 < Talman> What is a good console mode bit torrent program? My connection won't allow torrents, so I plan on using the server to grab what I'm after, then DL it via SCP.
18:57 < internat85> btdownloadcurses
18:57 < internat85> which every package that is in
18:57 < internat85> bitorrento i think
18:57 < Talman> thanks.
18:57 < internat85> np
18:58 < Talman> Bah, hate this unstable wireless.
18:59 < internat85> :(
19:02 < kupesoft> What happens if my linode freezes, crashes, panics, etc? Is there some sort of watchdog?
19:03 < Talman> Yes, lassie.
19:04 < kupesoft> of course, how does it work?
19:05 < Talman> Hmm? It works automatically, will attempt a reboot up to 5 times.
19:06 < Talman> Then give up to prevent endless loops.
19:06 < Talman> You can alter its functionality (on, off, stop telling you that Timmy fell down the well) in your Linode Control Panel.
19:06 < Talman> Under Utilities, I believe.
19:07 < Talman> Also, internat85, thanks again. I forgot how damn fast linodes are network wise.
19:07 -!- wgrant [~wgrant@c122-108-27-22.eburwd9.vic.optusnet.com.au] has joined #linode
19:07 < Talman> 300k a sec.
19:08 < kupesoft> But how does it detect a freezes crash, panic, etc?
19:09 < Talman> No clue.
19:10 < CaptObviousman> well, each linode slice is a hosted UML process
19:11 < CaptObviousman> so they can just monitor to see that the process still has a pid
19:12 -!- Schroeder [1000@kntpin04-nas-02-s186.cinergycom.net] has joined #linode
19:13 -!- brc [bruce@megarapido.cliquerapido.com.br] has quit [Ping timeout: 480 seconds]
19:13 < Talman> damn it
19:13 < Talman> [ Lag: 2.022 seconds ]
19:15 < tjfontaine> osmotic seems fine otherwise
19:23 < Talman> I always forget this. How do I create a tar.gz out of a directory?
19:23 < Talman> I remember the unzipping part fine. :)
19:23 < tjfontaine> tar *c*zf
19:23 < tjfontaine> x to extract, c to create
19:24 < tjfontaine> z is [g]zip
19:24 < tjfontaine> f is filename
19:24 < Talman> Right.
19:24 < tjfontaine> then destination filename and then source directory
19:24 < Talman> Damn you connection stay stable.
19:24 < Talman> It types a sec, then lags.
19:25 < Talman> [ Lag: 0.981 seconds ]
19:29 -!- JDLSpeedy [~joe@fl-69-34-4-219.sta.embarqhsd.net] has joined #linode
19:30 < tjfontaine> Talman: no loss between your host and the server atm according to mtr
19:31 < Talman> Its the last leg, wireless.
19:31 < tjfontaine> ah
19:31 < Talman> The local telco put a wi-fi router on a cell tower in the Marina.
19:31 < Talman> On a CELL TOWER. 500 feet up.
19:32 < Talman> So, their advertised 512k up / 256k down turns into... 10k up.
19:33 < Talman> Cause nobody can get more than 5 SNR.
19:42 < path-> climb to the top of the boat
19:42 < Talman> Tried that. No power outlets. :(
19:43 < exor674> Talman: get a longer extension cord!
19:43 < path-> philly was going to do this city-wide wireless thing, they were putting the APs in all the street lights
19:43 < path-> something like that anyhow
19:43 < Talman> lol. Next week, I'll have an AT&T 3G phone.
19:43 < mikegrb> lolz
19:43 < path-> iphone? :)
19:43 < tjfontaine> mm iphone
19:43 < Talman> Waiting for the Radio Shack in Skagway to order them.
19:44 < tjfontaine> 26days 5 hours
19:44 < path-> i wish they kept their old pricing
19:44 < Talman> Samsung A737, POS phone. All I want is the bluetooth device.
19:44 < Talman> Bluetooth DUN.
19:44 < path-> $15 more per months is like $300 more for the two year plan
19:44 < Talman> Yeah.
19:44 < Talman> Also, amusingly, the best bet for data on AT&T is their prepaid.
19:44 < path-> heh
19:44 < Talman> 20 a month GoPhone vs. 60 a month Contract.
19:45 < Talman> Same plan, same unlimited, same no-cap, etc.
19:45 < path-> i have a gophone for calling gf
19:45 < Talman> I have a gophone just for the 3G sim.
19:45 < path-> but i don't pay per month, just $1/day i make a call
19:45 < Talman> Yeah.
19:45 < Talman> I have it set to bill monthly like a regular plan.
19:45 < path-> which is less than going $70 over my vzw phone
19:45 < Talman> Yeah. :)
19:46 < Talman> Is it based on minutes or just 1 dollar == 24 hours of usage?
19:46 < path-> if i use any time on a given day, they charge $1
19:46 < Talman> I see.
19:46 < path-> but att -> att unlimited minutes
19:47 < path-> so all i pay is $1
19:47 < Talman> Yeah, to get the 20 = unlimited data, you had to use the CC option.
19:47 < Talman> Yeah.
19:47 < path-> and i don't use it every day
19:47 < Talman> I got that too. And 500 night-weekend.
19:47 < Talman> Too bad everyone switched to Cricket or T-Mobile. :)
19:47 < tjfontaine> cricket?
19:47 < Talman> I find it funny, only AT&T and T-Mobile work up here.
19:47 < path-> someone at work wants to get off t-mobile
19:47 < Talman> Regional carrier. Some south american conglomerate.
19:47 < Talman> They're heavy in the south.
19:47 < tjfontaine> I see
19:48 < Talman> Imagine a contract without a contract, and full price phones.
19:48 < Talman> That's cricket. Pay 200 bucks for an unlocked phone, and cricket will give you a unlimited everyting plan for 50 a month.
19:48 < tjfontaine> I see that, looks nice
19:50 < Talman> I want an unlocked BlackJack II.
19:51 < Talman> Gotta find one, one cheap, and one that will ship to Alaska.
19:53 < irgeek> "Pay 200 bucks for an unlocked phone, and cricket will give you a unlimited everyting plan for 50 a month." -- that doesn't roam because Cricket doesn't have roaming deals with other carriers.
20:11 -!- hfb [~hfb@cpe-76-87-170-116.socal.res.rr.com] has quit [Quit: Leaving]
20:38 -!- ondrej [~ondra@ip4-83-240-41-73.cust.nbox.cz] has quit [Quit: Leaving]
20:52 -!- Schroeder2 [1000@kntpin04-nas-02-s222.cinergycom.net] has joined #linode
20:54 -!- Schroeder [1000@kntpin04-nas-02-s186.cinergycom.net] has quit [Ping timeout: 480 seconds]
21:09 -!- brc [bruce@megarapido.cliquerapido.com.br] has joined #linode
21:13 -!- Schroeder2 [1000@kntpin04-nas-02-s222.cinergycom.net] has quit [Ping timeout: 480 seconds]
21:34 -!- Schroeder2 [1000@kntpin04-nas-02-s55.cinergycom.net] has joined #linode
21:45 -!- kupesoft [~dave@CPE003018b02a53-CM0018c0c44e76.cpe.net.cable.rogers.com] has quit [Quit: Ex-Chat]
21:46 -!- Deetz [~Paul@host185.natpool.mwn.de] has quit [Ping timeout: 480 seconds]
21:48 -!- spasmface [~spasm@r220-101-68-90.cpe.unwired.net.au] has joined #linode
21:51 -!- arooni [~arooni@c-67-168-26-198.hsd1.wa.comcast.net] has joined #linode
21:54 -!- arooni-mobile [~arooni@c-67-168-26-198.hsd1.wa.comcast.net] has joined #linode
22:00 -!- arooni [~arooni@c-67-168-26-198.hsd1.wa.comcast.net] has quit [Ping timeout: 480 seconds]
22:03 -!- jm [~fake@c-76-113-194-7.hsd1.mn.comcast.net] has joined #linode
22:08 -!- arooni-mobile [~arooni@c-67-168-26-198.hsd1.wa.comcast.net] has quit [Quit: Leaving]
22:08 -!- arooni [~arooni@c-67-168-26-198.hsd1.wa.comcast.net] has joined #linode
22:08 < path-> hi arooni!  welcome back!
22:08 -!- Alucard [Hellsing@c-76-24-50-134.hsd1.nh.comcast.net] has left #linode []
22:08 -!- Alucard [Hellsing@c-76-24-50-134.hsd1.nh.comcast.net] has joined #linode
22:09 < arooni> hi path- ;p
22:15 -!- sveiss_ [~sveiss@splinter.brokenbottle.net] has joined #linode
22:16 -!- bliblok [~bjornar@ti500720a080-4044.bb.online.no] has quit [Quit: Leaving]
22:19 < path-> arooni: i think you need a new cable modem/splitter/amp or something
22:19 < path-> :P
22:19 < path-> i heard some people setup irc proxys on linodes
22:19 < path-> :)
22:20 -!- jm [~fake@c-76-113-194-7.hsd1.mn.comcast.net] has quit []
22:21 < Peng> Is it cheating to use an IRC proxy for an iRPG?
22:21 -!- sveiss [~sveiss@host86-139-70-68.range86-139.btcentralplus.com] has quit [Ping timeout: 480 seconds]
22:21 < Alucard> no?
22:21 < path-> i guess that depends on if other people find out and reboot your linode :)
22:21 < Peng> Haha.
22:21 < Peng> Now that would be cheating.
22:21 < Alucard> is it cheating to play from the server irpg is on?
22:21 < Peng> Haha.
22:22 < Alucard> or to have a services client play?
22:22 < Peng> That'd be interesting.
22:22 < Peng> Services goes down often enough on some networks that it would be a bad idea.
22:22 < Alucard> not on mine <.<
22:23 < HoopyCat> i run irssi on my linode; i don't see why graphical clientists should be unfairly disadvantaged due to their desire to not make their IRC addiction look like mainframe programming
22:24 -!- Majes [~Majes@dialup-10.restricted.wdgaf.com] has joined #linode
22:26 < Peng> One reason I don't want to run a terminal client is that my terminals always have a dark background, and it's harder to read.
22:26 < charlie> does anyone know when more linodes will be available in texas?
22:26 < charlie> !avail-all
22:26 < linbot> Dallas360 - 0, Dallas540 - 0, Dallas720 - 0, Dallas1080 - 0, Dallas1440 - 0, Dallas2880 - 0 , Fremont360 - 0, Fremont540 - 0, Fremont720 - 0, Fremont1080 - 0, Fremont1440 - 0, Fremont2880 - 0 , Atlanta360 - 0, Atlanta540 - 0, Atlanta720 - 0, Atlanta1080 - 0, Atlanta1440 - 0, Atlanta2880 - 0 , Newark360 - 27, Newark540 - 50, Newark720 - 20, Newark1080 - 12, Newark1440 - 8, Newark2880 - 4
22:26 < Peng> irssi can be used as a proxy, though. I should look into that.
22:26 < Peng> Then I could still use X-Chat.
22:26 < charlie> Peng: irssi proxy is pretty nice
22:27 < HoopyCat> mov zig,ds forgreatjustice
22:27 < Peng> irssi is pretty nice.
22:27 < HoopyCat> oops, wrong irc client
22:27 < bd_> There's also dircproxy
22:27 < charlie> yeah, i use irssi, i know :P
22:27 -!- freelikegnu [~francisco@freelikegnu.org] has joined #linode
22:27 < freelikegnu> hello
22:27 < Peng> There isn't a GTK or Qt version of irssi, right? :D
22:27 < Alucard> HoopyCat that's not proper Intel syntax.
22:28 < HoopyCat> Peng:  i find light text on a dark background very easy to read
22:28 < charlie> Peng: there's a graphical version of Irssi for Mac os x which is really nice, but I use irssi+screen
22:28 < Alucard> ^
22:28 < Peng> HoopyCat: I keep the contrast on my monitor low; otherwise it's blindingly bright.
22:28 < Alucard> I use mIRC
22:28 < Peng> Actually, it's really not so bad.
22:28 < HoopyCat> Alucard:  it worked fine in a movie i saw once
22:28 < Majes> anyone running an SQL server in a second node to save I/O tokens?>
22:28 < Peng> It was when I was using a blurry font though... God.
22:29 < freelikegnu> I'm looking for help configuring subdomains without virtual/webmin
22:29 < Peng> X-Chat is colorful though.
22:29 < charlie> Majes: i'm still using SQLite3 on my Rails applications, I'm too lazy to move to mysql or postgresql :P
22:29 < Majes> :)
22:29 < freelikegnu> on another VPS I could just add a subdomain in my lighttpd.conf, but that does not seem to work on linode
22:29 < HoopyCat> Majes:  you might want to consider enqueuing yourself for a migration to xen; the i/o tokens are no more
22:30 < Majes> I have two nodes, just upgraded one to a 540, but I can't seem to get mysql to connect via the private IP
22:30 < Peng> freelikegnu: Why wouldn't that work on Linode?
22:30 < Peng> freelikegnu: You did set up the DNS, right?
22:30 < charlie> Majes: I had problems with private IPs also, I just gave up on it
22:30 < Majes> :)
22:30 < HoopyCat> Majes:  both are in the same datacenter and they can both ping each other, right?
22:30 < Majes> I had migrated my 360 to XEN
22:30 < freelikegnu> Peng I tried the linode DNS web tool, if thats what you mean
22:30 < charlie> freelikegnu: did you setup nameservers for your domain also?
22:31 < freelikegnu> Peng but perhaps I did it wrond
22:31 < Majes> yes, can SSH in bothin ways
22:31 < HoopyCat> Majes:  mysqld is binding to eth1 as well, through whatever way one tells it to do so, right?  by default, it is very secretive.
22:32 < Majes> yes I just bind to private IP address
22:32 < Majes> and it loads up fine
22:32 < Majes> if that address was bad it would fail
22:32 < Majes> so I understand it
22:33 < Majes> I'll read the manual again lol
22:33 < mikegrb> lolz
22:33 < HoopyCat> Majes:  hmm, does "tcpdump -n -i eth1" show anything on the server side?
22:33 < freelikegnu> Peng: do I put the subdomain "sub.mydomain.com" in the main Domain Zone list?
22:33 < freelikegnu> along side mydomain.org?
22:34 < freelikegnu> I don't have bind9 or other such daemons on my server, is that also necessary?
22:35 < irgeek> freelikegnu: No. You need to add an A or CNAME records under mydomain.com for sub
22:38 -!- lastsh [~lastsh@frog.last.sh] has joined #linode
22:39 < metaperl> I wish my dashboard displayed times in EST.
22:39 < freelikegnu> so I add a new A record like sub.mydomain.com to ip address xx.xx.xx.xx
22:39 < caker> metaperl: click on the profile link and change the timezone :)
22:39 < Majes> just the first part
22:39 < Majes> like sub
22:39 < irgeek> metaperl: Click on the "my profile" link in the right corner.
22:40 < metaperl> OK, thank you very much
22:40 < freelikegnu> irgeek: I'll wait a little while for it to resolve
22:41 < irgeek> The zonefiles are reloaded every 15 minutes.
22:41 < freelikegnu> ok
22:46 < freelikegnu> thanks for the help
22:47 < freelikegnu> is anyone else using lighttpd?
22:47 < bob2> yeah
22:47 < Alucard> yes
22:47 < freelikegnu> does it leak?
22:47 < Alucard> no
22:47 < bob2> leak what
22:47 < Alucard> fluids
22:47 < path-> oil?
22:48 < freelikegnu> I have to use a script to restart after it grows past 80mb
22:48 < freelikegnu> of ram
22:48 < bob2> it is currently using 5MB of ram
22:48 < Alucard> mine's been up since jun 8 and is using 3.24mb
22:49 < Alucard> MB*
22:49 < freelikegnu> what distro are you using?
22:49 < Alucard> debian
22:49 < freelikegnu> hmm
22:49 < freelikegnu> are you using php too?
22:49 < irgeek> Mine uses about 1.5M - I win!
22:49 < Alucard> yes
22:49  * freelikegnu scratches head
22:49 < HoopyCat> i had a '97 neon which went through a quart of oil a month before i drove it to my parents' house and abandoned it at 75,000 miles.  that'll put memory leaks in perspective.
22:50 < freelikegnu> where can I find out how to setup lightty so it does not leak as mine does?
22:50 < bob2> you have a php module loaded into lighttpd?
22:50 < irgeek> o_O
22:50 < freelikegnu> yeah I tried fastcgi
22:50 < irgeek> Was that a serious question?
22:50 < freelikegnu> and cgi
22:51 < bob2> there you go then
22:51 < path-> in '97, i had an '84 nissan sentra with the same thing.. had to use duct tape on air lines and adjust the carborator to keep it from stalling out
22:51 < freelikegnu> maybe the web script I am using is bad for lightty
22:51 < path-> but i bought it for like $500 and it lasted a year.. cheapest car i ever had even with expenses
22:51 < Alucard> if your lighty leaks I think you're doing it wrong
22:52 < irgeek> in '97 I had a Bronco that leaked sexy all over the place/
22:52 < freelikegnu> I also have max memory in php.ini set for 64 mb
22:52 < Alucard> also, lighttpd.net
22:53 < bob2> I'd just assume the php module was leaking all over the place
22:53 < bob2> or some binary module it loaded
22:53 < freelikegnu> hmm
22:57 -!- mendel [crabby@76-10-159-31.dsl.teksavvy.com] has joined #linode
22:58 -!- lakin [~lakin@S01060013101832cd.cg.shawcable.net] has quit [Ping timeout: 480 seconds]
23:07 < freelikegnu> meh still not resolving
23:07 < linbot> New news from forums: Respawn the lish screen (or disallow kill sequence) in Feature Request/Bug Report 
23:08 < freelikegnu> this is very odd
23:08 < irgeek> What is the name you are trying to get working?
23:09 < freelikegnu> droopy.freelikegnu.org
23:09 -!- spasmface [~spasm@r220-101-68-90.cpe.unwired.net.au] has quit [Ping timeout: 480 seconds]
23:09 < irgeek> droopy.freelikegnu.org. 86400   IN      A       70.87.222.215
23:10 < irgeek> It's resolving.
23:10  * freelikegnu scratches head
23:11 < irgeek> And it a Drupal page.
23:11 -!- FloodServ [services@services.oftc.net] has quit [charon.oftc.net services.oftc.net]
23:11 -!- digx [~rick@c-76-109-201-140.hsd1.fl.comcast.net] has quit [Quit: digx]
23:11 < charlie> services!
23:12 < freelikegnu> oh you see the page?
23:12 < freelikegnu> I'll be danged
23:12 < freelikegnu> wonder why I cant see it here
23:13 < exor674> mmm, thread necromanccy!
23:13 < freelikegnu> I get a server not found error in ff
23:14 < irgeek> There is probably a negative cache between you and Internet.
23:14 < freelikegnu> eew
23:15 < freelikegnu> ah now it resolves here
23:15 < freelikegnu> hmm
23:15  * freelikegnu scratches head again
23:15 < freelikegnu> seems odd to me that a subdomain would take so long
23:16 < freelikegnu> but that will work
23:19 < irgeek> It takes less than 15 minutes from when you create the record. If you've tried to look up the name from your client before the servers have reloaded, the DNS server you talk to may cache the negative result so you have to wait for that cache to expire.
23:21  * LadyNikon sighs
23:21 < LadyNikon> last BSG for awhile
23:23 < straterra> Why is that?
23:23 < straterra> Oh yeah! I'm behind
23:23 < LadyNikon> season break
23:23 < freelikegnu> ok, thanks for holding my hand :D
23:23 < LadyNikon> straterra: its good
23:23 < LadyNikon> its like.. really frakin good
23:23 < straterra> I'm finishing encoding season 3 atm
23:23 < straterra> I have 1-3 on my X-Box for immediae viewing pleasure :)
23:23 < straterra> immediate^
23:23 < bob2> freelikegnu: firefox has its' own dns caching
23:23 < bob2> hm, its
23:25 < bd_> bob2: does it do negative caching too?
23:25 < bob2> not sure
23:27 < straterra> LadyNikon: I'm like three episodes behind
23:28 -!- sveiss [~sveiss@host86-139-70-68.range86-139.btcentralplus.com] has joined #linode
23:29 < LadyNikon> then i wont say anything :S
23:29 < straterra> Go ahead..I don't mind
23:29 < straterra> I'm going to watch them anyway
23:29 < LadyNikon> someone else here might :S
23:29 < straterra> All of em..right now
23:32 -!- lakin [~lakin@S01060013101832cd.cg.shawcable.net] has joined #linode
23:33 < LadyNikon> mikegrb, caker, tasaro, jadoba either of you around?
23:34 < Talman> RDNS ... where'd it move to?
23:35 < irgeek> Talman: Under Network
23:35 -!- sveiss_ [~sveiss@splinter.brokenbottle.net] has quit [Ping timeout: 480 seconds]
23:35 < Talman> k
23:35 < Talman> ty
23:36 < Talman> Tired of it resolving to something like members...
23:36 -!- weave [~weave@li.weaverling.org] has joined #linode
23:49 -!- exor674 is now known as exor|zzz
23:51 -!- r3z` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has joined #linode
23:51 -!- r3z`` [~r3z@c-68-58-96-186.hsd1.in.comcast.net] has quit [Read error: Connection reset by peer]
23:51 -!- FloodServ [services@services.oftc.net] has joined #linode
23:51 -!- mode/#linode [-o linbot] by ChanServ
23:52 -!- Schroeder2 [1000@kntpin04-nas-02-s55.cinergycom.net] has quit [Ping timeout: 480 seconds]
23:54 -!- Solver [~robert@CPE00a0c96b79ba-CM001cea35fd4e.cpe.net.cable.rogers.com] has quit [Remote host closed the connection]
--- Log closed Sat Jun 14 23:59:00 2008