=== leon__ is now known as CodeRunner [07:51] morning all [07:51] moo! [07:51] :) [07:52] Morning all [07:54] hah AlanBell, just saw your myysql query comment, bad code or mounted the db's in memory now ? [08:15] indexes! [08:19] bless you ;) [08:19] PostgreSQL ;) === kabads_ is now known as kabads === michelle is now known as Guest69762 === Guest69762 is now known as michelle_ [08:28] diplo: changing the query to not have subqueries in it [08:28] so it can use the indexes as far as I can tell [08:29] http://pastebin.com/GADK2DQk is what it looked like [08:32] the problem was the two bits like this: (SELECT vtiger_account.* FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid AND vtiger_crmentity.deleted=0) AS vtiger_account [08:33] which just replaces vtiger_account in the query with the content of vtiger_account without deleted items in it, I flattened this bit out so it isn't a subquery [08:37] Good morning peeps :) [08:47] guys, is anyone runnign 3.5 kernel on 12.04? [08:48] Linux wolk 3.5.0-26-generic #42~precise1-Ubuntu SMP Mon Mar 11 22:17:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux [08:48] Apparently, I am 8-) [08:48] I'm running 3.5 on 12.10 if that helps [08:48] how did you do it MartijnVdS ? [08:49] mungbean: I installed 12.04.2 :) [08:49] there's an askubuntu page but seems to be missing a certain detail [08:49] yeah, i upgraded to 12.04.2 so no new kernel [08:49] mungbean: there's a way.. let me find it for you [08:49] merci [08:50] https://wiki.ubuntu.com/Kernel/LTSEnablementStack [08:50] sudo apt-get install linux-generic-lts-quantal xserver-xorg-lts-quantal [08:50] \o/ [08:50] Some packages could not be installed. This may mean that you have [08:50] requested an impossible situation or if you are using the unstable [08:50] distribution that some required packages have not yet been created [08:50] or been moved out of Incoming. [08:50] My Bytemark VPS is running 12.04.2 but the kernel is stuck at 3.2 I think because they use KVM [08:51] bigcalm: nah, it's because you haven't upgraded to BigV yet :) [08:51] bigcalm: http://bigv.io/ = bytemark's new vps platform [08:51] MartijnVdS: you think I have money for BigV? [08:51] bigcalm: (I switched last weekend) [08:51] bigcalm: A single VM on BigV costs the same as on the regular platform :) [08:51] MartijnVdS: oh, I actually never looked at the prices :D [08:52] mungbean: you might need to enable the "updates" repository in sources.list [08:52] mungbean: but I'm not sure [08:52] MartijnVdS: what was the move like? [08:52] MartijnVdS: do they do everything for you and you get to keep your current IP address? [08:52] bigcalm: no, and no [08:53] bigcalm: I made a new VM, rsync'ed /home, installed apache (and copied the config over) [08:53] Ug [08:53] bigcalm: then fixed DNS and asked them to disable the old VM [08:53] took me about an hour [08:53] MartijnVdS: had a problem with lib-mesa-glx [08:53] have to install a quantal version [08:53] if you don't hear from my, it's cos my machine is shagged [08:54] mungbean: that's not in the LTS stack is it? [08:54] mungbean: shagged, is that a technical term ;) [08:54] udo apt-get install libgl1-mesa-glx-lts-quantal [08:54] is required [08:56] MartijnVdS: thanks for the pointer, I'll consider it when I don't have a head full of bees [08:56] http://i.eho.st/pgnxf8lp.gif [08:57] relevant bigcalm [08:57] mungbean: love that gif [08:58] recommended viewing 10x per month [08:58] And Nicholas Cage version of Wicker Man [08:58] someone put a lot of work in, and it paid off [09:00] Morning [09:05] does df [09:05] df [09:06] woops sorry [09:08] ok now on 3.5 [09:09] scary as i saw loads of important libraries removed ..then i noticed they were 9386 ones [09:09] i386 [09:10] suspend now works again \o/ [09:13] Good morning, and happy Barbershop Quartet Day! http://www.youtube.com/playlist?list=PL9DE5C985C6ECE35B [09:14] Silly: http://rrrrrrrroll.tumblr.com/ [09:15] hey guys, using my ssh config like Host * !spring.mydomain.net with ProxyCommand to as I want to proxy all my ssh connections through a gateway [09:15] but i dont want to proxy any ssh connections to github [09:15] how could I do this? [09:15] Host * "!spring.mydomain.net,*.github.com" [09:15] doesnt work [09:16] JamesTait, have a barbershop quartet, whilst still remaining relevant to my interests as a gamer! http://www.youtube.com/watch?v=4coaEB4tabU [09:16] j0sh_: define *.github.com and "spring.mydomain.net" first [09:16] then * won't match them [09:17] I thought that...but it does [09:17] I have put github above * in myconfig [09:17] but * still seems to get applied [09:17] ok, silly question... is there a way I can make apt forget what's marked for upgrade? [09:17] directhex, I happen to really like that song, too. :) [09:17] morning [09:17] * popey has moved to mother in laws house today, vm connection has been down since 2am, projected fixed by 4pm [09:17] I'm not talking about holding, just meaning that I have to force an update first [09:18] I say force, I mean perform [09:23] popey: it's always a 4pm projection, just the day varies. Hope they sort themselves out soon [09:24] popey: same router as me, you could use your phone's 3g connection and share it across your LAN :) [09:26] No, i wouldn't do that [09:26] it would cost me very quickly [09:26] i hope you took flowers [09:29] oh, and fun last night while debugging stuff. my disk filled up - 55GB log file in /var/log [09:29] that was _fun_ [09:30] /o\ [09:30] anyone know why youtube-dl might refuse to download a video that is watchable on youtube? [09:30] Hi everyone. I've got a bit of a challenge for you all. I'm running 13.04 and unity has just crashed and I'm in the middle of running something I can't quit. [09:30] cliftonts: don't quit it ;) [09:30] Does anyone know of any gui I could install and switch to without logging out? [09:31] gnome shell won't let me, it comes up with some sort of authentication error [09:31] you can restart unity [09:31] alt-f2, unity, enter [09:31] unity just seg faults [09:32] well thats a bit of a worry [09:32] I can't alt-f2 without unity though [09:32] we should fix that [09:32] ctrl+alt+t should open a terminal [09:32] you're right, sorry [09:32] ctrl+alt+f1 login, unity [09:32] Bare in mind I have something running in a terminal window. I don't want to lose 15+ hours work [09:33] open another terminal [09:33] and leave that one running [09:33] AlanBell, unity is not in a workable state [09:33] I'd like to see why its not working [09:33] I have a suspicion why [09:33] if you have pastebinit installed, can you pastebin your ~/.xsession-errors [09:34] popey: I can use one window at a time, can't Alt-Tab. Yes I can load a second terminal and had to do so in order to load xchat [09:34] pastebinit .xsession-errors [09:34] like that [09:34] you can move windows about using alt+mouse [09:34] ah, fixed my own problem with youtube-dl -U [09:34] popey, I have no window management capability at all, without quitting xchat you guys is all I've got [09:34] also, in a new terminal window, run "compiz --replace --debug ccp &" [09:35] cliftonts: ctrl+alt+t should bring a new window up on top of xchat [09:35] popey: I could do that, but have no real way to get the output of it to you [09:35] yes, you do. pastebinit [09:35] compiz --replace --debug ccp | pastebinit [09:37] what is pastebinit? It didn't seem to do anything. And now I have the terminal window that owns xchat stuck in my way [09:38] you should be able to move windows about by holding alt, clicking on them and moving them? [09:38] nope [09:38] I <3 alt moving. Wish all OSes did that [09:38] ok, you can do as AlanBell suggests... [09:38] ctrl+alt+F1, to move to the first tty, login.. [09:38] then sudo apt-get install pastebinit [09:39] then you can compiz --replace --debug ccp | pastebinit [09:39] I have installed it and this is the output [09:39] You are trying to send an empty document, exiting. [09:39] so we can see what's causing compiz / unity to fail to load [09:39] hmm, okay [09:39] try without the | pastebinit [09:39] and see what errors you see [09:39] any errors about libraries or somesuch [09:39] I'm looking at them now, they came up on screen anyway [09:39] excellent [09:39] compiz (core) - Debug: dlopen failed: /home/gareth/.compiz-1/plugins/libunityshell.so: cannot open shared object file: No such file or directory [09:40] thats cool [09:40] the next line? [09:40] compiz (core) - Debug: Trying to load unityshell from: /usr/lib/compiz/libunityshell.so [09:40] ok, did that work or is the next line an error? [09:40] compiz (core) - Debug: dlopen failed: /usr/lib/libunity-core-6.0.so.5: undefined symbol: unity_protocol_music_preview_pause_uri [09:40] excellent! [09:40] I know the fix for this [09:40] that's a start lol [09:41] ok, in the terminal do this:- [09:41] is it something I can do with window decorations tied behind my back? [09:41] sudo apt-get update [09:41] yes [09:41] updating [09:42] sudo apt-get install libunity9/raring [09:42] see if that tries to downgrade or otherwise change the version of libunity9 you have installed [09:42] 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. [09:43] apt-cache policy libunity9 [09:43] what version is next to "Installed" ? [09:44] Selected version '6.90.2daily13.04.05-0ubuntu1' (Ubuntu:13.04/raring [amd64]) for 'libunity9' [09:45] thats not the output I would expect from apt-cache policy libunity9 [09:45] sorry, my mistake [09:45] good morning everyone, [09:45] Installed: 6.90.2daily13.04.05-0ubuntu1 [09:45] Installed: 6.90.2daily13.04.05-0ubuntu1 [09:45] same here.. [09:45] ok [09:45] sudo apt-get install --fix-policy [09:45] I'm dying of man flu and it's starting to show [09:45] ^^ do that [09:45] sudo apt-get install lemsip [09:46] cryptsetup ecryptfs-utils keyutils libatm1 libecryptfs0 python-serial [09:46] being installed [09:46] thats not much [09:46] apt-cache policy unity [09:46] no, all looks very unrelated [09:46] what version is installed? [09:46] Installed: 7.0.0daily13.04.10-0ubuntu1 [09:47] Installed: 7.0.0daily13.04.10-0ubuntu1 [09:47] hmm [09:47] hmm [09:47] sudo apt-get dist-upgrade [09:47] anything change? [09:47] already tried that [09:48] ok, so, lets try the next thing [09:48] interestingly compiz --replace is no longer crashing, but it's stopped at loading unityshell [09:48] did you by any chance enable the experimental ppa? [09:48] until I pushed a button [09:49] yes but that ppa just broke my dash completely so I got bored with looking at an empty page and removed it. I figured it would either fix it, or break it totally [09:49] I now know the answer [09:49] ah good [09:49] dpkg -l | grep experimental.certified [09:49] I figured I could just hop to gnome shell if that happened, I was wrong [09:49] that will list packages which came from that ppa [09:50] a ha! [09:50] ii libunity-protocol-private0:amd64 6.91.9daily13.04.09ubuntu.unity.experimental.certified-0ubuntu1 amd64 [09:50] Goodness compiz is greedy. Never dipping below 73% CPU [09:50] bingo [09:50] ii unity-scope-gdocs 0.8daily13.04.09ubuntu.unity.experimental.certified-0ubuntu1 all [09:50] sudo apt-get install libunity-protocol-private0/raring [09:51] y [09:51] bigcalm: rebooting usually fixes that for me [09:51] or sudo apt-get install libunity-protocol-private0=6.90.2daily13.04.05-0ubuntu1 [09:51] ali1234: rebooting wouldn't help the very important program I have been running for 15 hours [09:51] And we have lift off!! [09:51] well another way to fix it is to revert to compiz 0.8 [09:51] ali1234: with an i7 I don't really notice it much. Just the fan noise can be annoying [09:52] if you need to reboot less often than twice a day that is [09:52] cliftonts: once you remove all the experimental stuff you should be able to run unity and get a desktop back [09:52] Thanks popey. It would've been a major headache losing access to my laptop for days [09:52] np [09:53] bigcalm: i only get those issues with compiz. elementary/gala for example doesn't have that problem and stil has swishy effects [09:53] I've even got the dash back now. I don't need to have 3 million things pinned to the launcher any more! [09:53] oh btw for future reference [09:53] sudo apt-get install metacity gnome-panel [09:53] killall -KILL unity && metacity & [09:53] Right then. I'm off to get some actual work done. [09:53] oh and gnome-panel [09:54] gnome panel? that would've been an idea. Thanks ali [09:54] bye all [09:54] if the display is completely unresponsive then you can run DISPLAY=:0 metacity && gnome-panel & from vt [09:56] 2nd time Spotify has frozen this morning. I don't think it likes compiz (or the other way around). Reboot time :( [09:58] spotify freezes because it doesn't like pulseaudio [09:58] compiz makes it shrink to a 10x10 window 1000 pixels past the right edge of the display [09:58] Takes out all mouse input. Only using alt to get to the hud can I type in 'exit' and get things going again [09:59] not seen that with spotify [09:59] well thats a new one on me too [09:59] I'm special :) === leon__ is now known as CodeRunner [10:00] 11am already? Ug [10:00] Morning all [10:01] popey: so no virgin for you today then :( [10:01] bigcalm: yeap [10:01] bigcalm: I make a good time gauge I guess :) [10:01] davmor2: ah, no. I just saw @big_ben_clock's tweet [10:01] Yes, I'm still following the clock [10:02] davmor2: yeah, moved to inlaws house, they have vm too [10:02] davmor2: but good morning to you in any case [10:03] mornig davmor2 [10:14] gwibber wakes up and I suddenly get a slew of OSD spam [10:15] one day I'll remember to use my tea strainer and not drink a cup full of bits [10:16] Laney: tea infusers ftw [10:16] yeah I have one of those somewhere [10:16] it's fiddly though, especially to top the pot up [10:16] * bigcalm skips off to make a cup of lapsang souchong [10:16] Ah, not really meant for pots [10:17] Hayley and me are a proper couple at last. We recently bought a tea cosy [10:17] i have a big ball thingy that you can put in there [10:17] fishing it out and adding more tea when it's wet though, nah thanks [10:18] my dad got me a tea cosy for my birthday last year :3 [10:18] Never thought of adding more tea to an existing brew [10:18] Aww, you've a good dad there :) [10:18] yeah, extra spoon will get you another pot [10:19] * bigcalm remembers to rinse out the sulphuric acid from the kettle this time [10:19] O_O [10:19] tasty [10:20] Main ingredient of descaler [10:20] popey: personal question, so feel free to sad the second word is off, Why would move to the inlaws? [10:20] my internet connection is down [10:20] theirs isnt [10:21] popey: ah sorry I thought you meant you had moved there and their vm was down [10:21] bigcalm: vinegar. I buy it in big containers (10l) from asian shop [10:23] use as fabric conditioner for clothes that shouldnt be washed with normal one and kitchen/bathroom disinfectant/cleaner/delimescale [10:24] you wash clothes in vinegar? [10:24] davmor2: no because that would be silly, and you know I'm not silly ☻ [10:25] of course I dont. nobody washes their clothes in fabric conditioner either [10:25] popey: not silly? did you want me to dig out the extreame ironing photo ;) [10:25] popey: I've seen you in a Hawaiian shirt and you have the nerve to say that :P [10:25] noted [10:25] usually fabric conditioner is added to the water of the last rinse cycle of a wash [10:26] conditioner is the last thing that gets put on the clothes though innit? [10:26] so vinegar would be bit stinky [10:26] it evaporates. [10:26] i dont think she puts a full litre in to the wash ☻ [10:27] i would be paranoid as vingar and BO have similar smell [10:27] doesnt leave any scent in the clothes. and the amounts are small. [10:27] not really [10:30] aw I forgot I promised Id go to.get a parcel from the post office... wonder where the cycle tyre pump is [10:30] you can borrow mine [10:31] dsample ordered a BusPirate [10:32] Thanks for the keyboard link popey - sadly a little pricey for an impulse purchase today - Rod [10:32] hey mardi [10:32] yeah, company bought mine [10:32] zero chance mine would for me [10:32] (well, the company being the one I owned) [10:32] although my 1995 one, was company supplied - guess times change [10:33] I'm going to have a real problem, the day you can no longer get laptop/keyboards with TrackPoint [10:33] ditto, hence buying 3 ☻ [10:33] what's trackpoint? nipple mouse? [10:34] yes [10:34] this does make it easier when i come to renew laptop [10:34] I'm banking on me skipping over the whole trackpad fad and going straight to full touch/speech [10:34] :-| [10:35] oh there's another option for model m lovers [10:35] unicomp do a model-m like with a trackpoint [10:35] http://www.pckeyboard.com/ [10:36] might get one when I'm out there at the end of the month [10:36] Gave away my old M recently, now loving the DAS [10:37] my spacesaver is for KVM/Servers - looking like your version is a little bigger than I would like [10:38] My M4 spacesaver . http://www.clickykeyboards.com/index.cfm/fa/items.main/parentcat/10943/subcatid/0/id/236283 [10:38] thats nice [10:39] the one thing i hate about tp keyboards is the back/forward buttons above left/right cursors [10:39] quite insane [10:40] I *love* that [10:40] I'm really not liking the more recent Lenovo layout - http://techreport.com/r.x/2012_4_23_Future_ThinkPads_may_all_have_chiclet_keys/new-kbd.jpg [10:41] * mardi hates change [10:41] honestly, the key action is good on recent lenovo keyboards [10:41] why do people hate chiclet keys? [10:41] the fact it still has a middle mouse button is good [10:41] mungbean, because they're often dreadful [10:42] they seem more hygeininc [10:42] I distrust them, but I've also never used thrm [10:42] their new ones don't have middle button [10:42] razer's chiclet keyboard is absolute bong [10:42] it's a £125 piece of poo [10:42] i like the idea of backlit keyboards [10:42] i moaned at lenovo and they told me the touchpad had multiple buttons [10:42] lies [10:42] but I dislike the idea of a lack of nipple or middle mouse button. I don't get along with trackpads [10:42] backlit is a must for me. [10:42] nah, thinklight! [10:42] thinklight is also bong [10:43] it's a moronic thing that only works at one exact screen tilt angle [10:43] thank $deity recent lenovo keyboards are backlit [10:43] i bought some new keyboards for the office yesterday from pc world [10:43] "bong" [10:43] £60 a piece [10:43] wat [10:43] what do they do [10:43] builtin trackpad? [10:44] are they made of unobtanium? [10:44] mechanical [10:44] steampubk? [10:44] nothing but cherry mx black switches. no membrane stuff [10:44] s/b/n/ [10:45] mechanical keyboards are the "in" thing in gamer keyboards these days. curiously enough, coming from the model m legacy [10:45] but without, y'know, being terrible keyboards [10:45] model m would be good if it wasn;t so LOUD [10:45] and also massive but i have a miniature one [10:45] yeah, I'm completely over model ms with my £18 cherry [10:45] it's perfectly nice to type on and I can afford to have one at each computer [10:46] keyboard pr0n is overatted [10:46] I'm not sure if it's a good keyboard or I've just stopped caring [10:46] model m gets very confused by things like "typing". the key action is something people still like, but the actual matrix controller on a model m is dreadful [10:46] really dreadful [10:46] model m is too mainstream these days [10:46] try the fox test on a model m [10:46] i only notice terrible keyboards and painful ones [10:46] yeah mine drops 's' 50% of the time and inserts 2 of them 25% of the time [10:46] however i think this is because the capacitors inside it are dying [10:46] easy test for the quality of a keyboard's matrix scan and multiplexing: hold down both shift keys, and type the quick brown fox jumps over the lazy dog [10:47] it's not a speed test, you can type it slowly [10:47] but on most keyboards, some keys will be missed [10:47] worst kb i ever used in the eee pc 701 [10:47] often doesn't detect keypresses [10:47] because the keyboard scan matrix isn't physically cpable of reading both shift keys, plus some number of other keys, at once. e.g. on this lenovo, it can't do X [10:47] directhex: this does fairly badly at that, but has been fine everywhere else [10:47] HE QUIK BROWN FO JUPS OER HE LA DOG [10:48] i remember my acorn electron had a max mutplie key press [10:48] HE QUIK BROWN FO JUPS OER HE LA DOG [10:48] i thought things had moved on [10:48] mungbean, yes and no. [10:48] hah, identical [10:48] HE QUIK BRON FO JUPS OER HE LA DOG [10:48] oh, you bought some cherries, this is a cherry [10:48] mungbean, there's two things - a maximum number of simultaneous keypresses possible when using usb (even usb3), which is around 10 keys iirc [10:49] mungbean, and the keyboard scan matrix determines which specific combinations of keys are possible or not [10:49] i lol at all your terrible keyboards [10:49] TEQUICKBRONOXUMSOVERTEAZYOG [10:49] BigRedS, almost all mechanical keyboards use cherry switches. the ones i bought were steelseries 6Gv2 [10:49] which are mostly great, but gnome shell doesn't like them much [10:49] why not? [10:50] gnome shell seems happy with mine [10:50] they don't have a left windows key. gnome shell by default only shows the launcher overlay thing on the left windows key. you can change it to the right windows key, but then you can't launch it with your laptop's left windows key [10:51] basically gnome shell only works with ONE launcher key, and dies if you have more than one [10:51] even if you change your keyboard map so the right windows key emits a left key scancode [10:51] oh! it doesn't like steelseries kbs. I'll get some coffee.. [10:51] well, it doesn't like *any* right windows key. it just so happens that steelseries keyboards only have right, not left [10:51] oh yeah that [10:52] this is primarily a failing of gnome shell, not of the keyboard [10:52] heh, what isn't? [10:53] what's the fastest way to compare strings against a wordlist in python? [10:55] haha http://www.eurogamer.net/articles/2013-04-11-microsoft-creative-director-adam-orth-no-longer-with-microsoft [10:56] i find that whole incident very stupid [10:57] well indeed [10:57] politics [10:58] "#dealtwithit" [10:58] Doesn't everybody have their TVs and games consoles on remote power switches to save energy? [10:59] i do now [10:59] not my pvr tho ☻ [10:59] less for saving energy for me, more convenience [10:59] Only thing that is "always on" in the sitting room is the V+ box [10:59] same here [10:59] * SuperMatt spies popey's new similie [10:59] Actually have the V+ box on a UPS :D [10:59] wut [10:59] how are you remembering all the commands for these things? [10:59] they mean "always on the internet" [11:00] not "always powered on" [11:00] yes they do [11:00] If it's switched off at the mains, it's not on the internet [11:00]