[06:37] :YawwwwN: [06:37] herro ubuntu-za [07:02] o/ [07:07] morning nlsthzn and others [07:10] how are you uncle Kilos? [07:10] ok ty nlsthzn and you? [07:10] always good uncle Kilos:) [07:10] you clever, can one wget http://www.youtube.com/watch?v=Ov17bRbtCxU [07:11] I never tried to use wget for youtube vids... I installed minitube to do that... [07:11] sis wants it but i dont wanna go there, data min atm [07:12] if you want I can rip it and give you a link to use wget with? [07:12] please nlsthzn [07:13] what bitrate would you prefer, normal or HD (will effect size) [07:14] how much diffs? [07:14] dunno.. let me see [07:15] ah that an old song... reminds me of growing up :) [07:15] hd is high definition hey? its audio i want not a video [07:16] yeah very catchy song too. play it loud and now now everyone is singing it [07:17] well the HD will also have better audio ... so what I will do is get the vid, rip the audio and make a link for you... [07:17] ty so much [07:19] i go feed sheep quick [07:19] no hd available... so got 360p file is 21mb [07:27] nlsthzn: Could you perhaps provide insight into http://stackoverflow.com/questions/19331550/database-change-with-software-update? [07:28] wow [07:28] zeref: wow... way above my paygrade... [07:28] isnt the audio only about 4m [07:28] Kilos: that is the size of the video... busy installing a converter... will have a smaller file soon :) [07:28] ah cool ty [07:29] nlsthzn: lol [07:30] hello there [07:30] morning kbmonkey [07:31] morning Kilos [07:33] just busy uploading... link will be forthcoming shortly... file size 4.2mb [07:33] * Kilos hates youtube i dont want videos of everything [07:33] thats great ty nlsthzn [07:33] why then go to a site dedicated to videos [07:33] lol Kilos - I agree man :) [07:33] that is like going to the bank and complaining cause you hate money :p [07:33] its the only link i found for that song nlsthzn [07:34] i bang to just go to other places [07:34] zeref, you can either use a migration tool, that requires some setup. or you can write the sql to do the upgrade and run it during an upgrade process. [07:34] but every thing nowadays is youtube/watch [07:39] You can extract the sound from youtube videos. It's a bit involved, but it's possible. And it's often impossible to find really really obscure songs anywhere. [07:39] (...else.) [07:40] kbmonkey: thanks, how would the sql do it? could you perhaps send linky or example? [07:40] You download it with youtube-dl, and then use some app related to mplayer. I can't remember what it is; it has changed recently (the old one became obsolete). [07:40] Oh, snap. I see nlsthzn already mentioned this. :) [07:41] I think there are howtos on the intertubes. [07:41] you can use youtube-dl, a command line tool to download yt videos [07:41] Yes. [07:41] I also use videotop instead [07:42] also, you can play a youtube link directly through mplayer, and possibly pipe it through to extract the audio, all without downloading [07:42] the trick is to rip the audio from there without having to see the whole video too [07:42] yup... video was 20mb [07:42] audio rip only 4mb [07:42] it will need to download the entire stream regardless of what you do with it, unfortunately [07:43] thats why it helps to have friends with uncapped [07:43] I used minitube to get the vid and soundkonverter for the audio... both which are just gui front-ends to all the decoders already on the system (ffmpeg etc) [07:43] +1 [07:44] Maaz, nlsthzn == [07:44] ai! [07:44] :'( [07:44] Maaz, nlsthzn ++ [07:44] Maaz, karma [07:44] Kilos: Sorry... [07:44] ai! i forgot that too [07:45] lol [07:45] zeref, I cant help you there. the script is totally dependant on your database structure [07:45] Maaz, karma nlsthzn [07:45] Kilos: nlsthzn has karma of 2 [07:45] you will need to learn how to do database alters, and script those by hand [07:45] whoohoo... [07:45] what is karma? [07:45] stuff you can give in for toys [07:45] at the end of your life [07:46] :p [07:46] lol! [07:46] its like a gauge of how helpfull a person has been [07:46] my karma ran over my dogma [07:47] >.< [07:48] but peeps have forgotten to do the ++ when someone has been helped [07:48] Maaz, karma superfly [07:48] Kilos: superfly has karma of 23 [07:48] hes the leader methinks [07:49] oh nlsthzn kbmonkey weird things here, my 500g drive that was so crashed that bios didnt even see it is working again but with power from another psu outside pc [07:49] and fsck -f from maverick [07:50] diskutility shows it has 3 bad sectors [07:50] weird [07:50] i think my m/board is corrupt [07:51] sounds like the PSU [07:51] perhaps [07:52] Kilos: that mp3 may have some adds of other songs at the end it seems... perhaps you might need to edit it slightly... if you have audacity [07:54] np ty nlsthzn , nice song though hey? [07:54] well it does bring back a lot of memories :) [07:54] when I was a wee lad :p [07:55] oh I don't think anyone was here when I mentioned it last time... I am going to be a dad again :D [07:55] oh my congrats nlsthzn [07:58] but the child will be an arab [07:58] mommy must come home for birthing or then you got visa probs again [08:01] zeref, I'll write you a reply on SO. Do you have a sample code that connects/creates a sqlite db in python I can play with? [08:03] oh that is weird Kilos, best to not use the psu again in case it damages something for good! [08:03] wow nlsthzn congrats on the new little one :) [08:04] i just put it in here a week or so ago kbmonkey because the other one was giving probs [08:08] thanks all... and yes, visa's and passports are going to be a PITA... but what to do [08:08] thats part of the reason im stretching data so i can maybe upgrade the pc [08:09] what system you got now uncle Kilos? [08:09] nlsthzn, maybe its easier to get the child registered there and then sort visa stuff with za [08:10] Kilos: we won't be going home for the birth etc so it will have to happen that way [08:10] im on unity 12.04 here now but have another drive with kubuntu 12.04 and an old one with maverick [08:10] I meant hardware... [08:11] oh a p4 dual core by gigabyte [08:11] I have a mobo / cpu /ram here that I can get sent to SA with the next oppertunity... [08:11] it is a core 2 quad Q6600... [08:11] was the first quad out there but still rock solid... [08:11] whew that sounds good [08:12] any quad is better than dual [08:12] let me see what I can arange ... no promises on when however... [08:12] these old ones that use ddr ram you battle to get ram [08:12] I won't sent the cpu cooler, that to big and heavy... will need to arrange for one inside SA [08:12] np ty [08:12] this one uses DDR2... it has 4gb [08:13] wonderful ddr2 is easily available [08:15] kbmonkey: http://pastebin.com/NrtmvGVM [08:15] cool, because more memory is always good :) [08:16] yeah the drr comes only in 1g and smaller and i tried 2 1g's here but they clashed [08:16] hehe [08:16] murphy-as jy kan sukkel sal jy [08:18] Maaz, karma kbmonkey [08:18] Kilos: kbmonkey has karma of 2 [08:19] Maaz, karmaladder [08:19] Kilos: 0: superfly (23), 1: cocooncrash (19), 2: tumbleweed (16), 3: maiatoday (11), 4: drubin (10), 5: Vhata (8), 6: morgs (8), 7: Kilos (8), 8: highvoltage (7), 9: confluency (6), 10: inetpro (4), 11: nuvolari (3), 12: Symmetria (3), 13: ubuntu-za (2), 14: russell (2), 15: |3o|3 (2), 16: yusuf (2), 17: nlsthzn (2), 18: queery (2), 19: maverick (2), 20: magespawn [08:19] (2), 21: kbmonkey (2), 22: sars (1), 23: youtube-dl (1), 24: ScorpKing (1), 25: Web Afric… [08:19] thanks zeref, I am having a look :] [08:24] hi Mezenir [08:24] hi kilos [08:25] how are you? [08:26] good ty and you? [08:27] what a schlep tablets are [08:28] android same as everything else, each manufacturer has to change things [08:30] android is the awesome [08:30] yeah but too much for old heads to figure [08:30] keeps sis busy though [08:31] good thanks [08:31] android is easier than learning ubuntu ;) [08:31] no there aint a help channel on irc [08:32] ubuntu was a lekker experience for me [08:32] found help and friends [08:32] * nlsthzn wonders if Kilos has actually looked for help... there is IRC channels for everything [08:33] haha [08:33] there are channels >.< [08:33] stupid grammer [08:33] she needs the help not me [08:34] i see andchat is the app for them [08:36] for IRC... [08:36] there are many apps that can be used... [08:36] the trick is to get one that has a way to autocomplete nicks cause it is always annoying writitng them out and getting them wrong [08:36] lemme see if she can work out how to find the song onna stick first [08:36] hehe [08:37] needs a file browser [08:37] her model doesnt have a nice user guide yet [08:37] * nlsthzn needs to get his phone to see what he uses ;p [08:37] so i got her some common android userguide [08:38] and she has her daughters fone book as well [08:38] es file explorer is good and powerful [08:39] works well to browse files [08:39] copy/paste etc. [08:39] lemme see what she has [08:45] zeref, I updated my answer with your code sample. I hope that helps! [08:45] this is kinda fun, I always wanted to try sqlite in python, now I have :] [08:46] ahhh, thanks kbmonkey, that was what I was looking for :) [08:50] just one thing. After each make_* statement, shouldnt you connection.commit()? [08:51] noo problem. you should let me know if you put your program on github or somewhere, it sounds interesting [08:52] it does not matter to commit each time, it works the same [08:53] k cool [08:53] it's on github atm [08:53] https://github.com/zerefs/letmenotifyu [08:53] it looks like alters or any ddl statement (data definition schema change) is not put in transactions, so they happen even without any commit :/ [08:54] which is strange, buy ya [08:55] o0o0 [08:55] but you need the commit to save the new version insert row XD [08:55] true. [09:18] Maaz, kbmonkey ++ [[For doing geek stuff]] [09:19] hmm... he didnt complain [09:24] kbmonkey: [09:25] good morning [09:25] Maaz: coffee on [09:25] * Maaz flips the salt-timer [09:25] hi charl [09:25] hi Kilos [09:26] how's it going [09:26] Maaz, coffee please [09:26] Kilos: Sure [09:26] good ty and there? [09:26] pretty good thanks [09:26] i'm finally starting to get over this cold [09:26] it's one of those colds that lasts for a while [09:26] eish [09:27] eat lotsa raw onion on sarmies [09:27] ooh raw onion, i think i'll stick to orange juice :) [09:28] eish they dont make men like they used to [09:28] :D [09:28] onion is a natural cold/flu blocker fighter [09:28] i should actually eat more onion [09:28] it's nice to eat finely chopped onion on mash potato [09:29] yeah thats good too [09:29] Coffee's ready for charl and Kilos! [09:29] Maaz: thanks [09:29] charl: Sure [09:29] Maaz, danke [09:29] Bitteschön [09:55] so i was trying manjaro linux through the week inside virtualbox [09:56] looks quite good and is very fast [09:56] takes a while to get used to pacman and different packages but it's rather fast too [09:56] looks very promising [09:57] i took a look at setting up arch "plain vanilla" but to have to do an entire manual install in 2013 feels a little too ridiculous [10:04] morning charl [10:05] hey kilos you giving me more karma? he he [10:05] ya [10:05] thanks man. I can cash it in for toys later... [10:05] might encourage you to be here more often [10:05] hehe [10:06] you gotta help peeps to get karma though [10:06] hi kbmonkey [10:06] hey kbmonkey: [10:07] hi zeref [10:07] sorry Kilos - I prepared some roast veg I put in the oven. I can't wait [10:08] say user upgrades from 0.1.0 to 0.1.3, they will miss the changes for 0.1.1 and 0.1.2, so the database_verions variable needs to be updated :) [10:08] hi charl [10:09] yummy [10:09] zeref, it will upgrade each version they missed [10:09] ah... yes I see what you are saying. good catch zeref :] [10:10] :) [10:35] good day all [10:35] hi there magespawn [10:35] hello magespawn [10:36] hey Kilos kbmonkey [10:37] hi magespawn [10:37] wb Snowy2 [10:37] woohoo, the oven veg are done, I think I am going to have a chow today XD [10:37] howdy charl [10:37] how's the new job magespawn [10:37] hectic, lots of learning [10:38] what technology are you learning about magespawn ? [10:41] asterisk and sip [10:42] learning how to integrate a sip door phone into a asterisk server [10:42] that is some exciting stuff [10:43] sup [10:43] so from the first of november I will officially have a new job title [10:43] ;p [10:43] indeed, and the door phone runs over a wifi network that is about 5kms away from the reception [10:43] hey Symmetria [10:44] <== head of IP Strategy - Liquid Telecommunications [10:44] so no more freelance set your own hours [10:45] kbmonkey, one of these http://ipdoorphones.com/ [10:45] magespawn reality is, not much will change in that department [10:45] and one of these too http://www.ads-worldwide.net/products/10-6208-c07_jedia_jpa_1240_-_240w_100v_line_4_zone_public&address_mixer_amplifier.php [10:50] the asterisk is running on centos [11:06] hi Symmetria [11:06] congrats on your new job [11:06] is that an international company? http://www.liquidtelecom.com/ [11:23] yeah [11:24] largest fiber network on the continent [11:24] and growing all the time :) [11:26] well good for you, sounds like an exciting job [11:26] lol, its a challenging one which is why I took it :) I love the difficult ones [11:26] keeps me on my toes [11:27] are you going to be in kenya all the time now? [11:27] or at least, most of the time :) [11:29] well, moving to Kenya just because its easier to travel to all the other places I work in outta there [11:30] yeah kenya is more central [11:30] south africa is on the one point and it's hard to get around [11:31] if you need to travel frequently kenya is best [11:33] hi space [11:35] heh Im about to put down a giant gaming server [11:35] in east africa [11:35] the really cool thing about it, people who wanna game off it from south africa, will still get < 80ms latency to it [11:36] isn't that a lot, 80ms? [11:36] i'm not really a gamer so i don't know what the expectations are [11:36] that is good ping [11:36] < 100ms nice [11:36] oh ok [11:37] when I game on servers in US you sometimes go > 200ms... that sucks for anything fast paced like FPS [11:39] even working on servers via ssh in the us is painful [11:39] heh, we've specced a server that can handle virtually any load you can throw at it as well [11:41] 10 packets transmitted, 10 packets received, 0% packet loss [11:41] round-trip min/avg/max/stddev = 64.110/73.713/86.091/9.468 ms [11:41] thats pinging kenya from bloemfontein [11:41] for such a long distance that's quite good i guess [11:41] that's half a big continent [11:42] actually would be curious to know what someone on a dsl link in joburg would get pinging kenya, someone ping 41.191.224.202 and then tell me the latency and which za ISP you're behind [11:45] i'm not in south africa but i'll ping it for comparison [11:46] letting it run for a while [11:50] PING 41.191.224.202 (41.191.224.202) 56(84) bytes of data. [11:50] 64 bytes from 41.191.224.202: icmp_req=1 ttl=55 time=932 ms [11:50] 64 bytes from 41.191.224.202: icmp_req=2 ttl=55 time=391 ms [11:50] 64 bytes from 41.191.224.202: icmp_req=3 ttl=55 time=388 ms [11:50] 64 bytes from 41.191.224.202: icmp_req=4 ttl=55 time=384 ms [11:50] hi Symmetria [11:50] thats via 8ta [11:52] phew that's high [11:52] --- 41.191.224.202 ping statistics --- [11:52] 425 packets transmitted, 425 received, 0% packet loss, time 424239ms [11:52] rtt min/avg/max/mdev = 163.115/165.054/174.425/1.564 ms [11:53] that's also pretty high compared to bloemfontein [11:53] i don't think we are so much further away geographically speaking [11:54] although, if you have to go all around the cost, i am indeed significantly further away than south africa [11:54] looking at google maps now [11:57] tracepath http://paste.ubuntu.com/6226522/ [14:13] exit [14:41] who are these peeps http://www.acc.umu.se/technical/hosts/linux.html [14:42] i see them on iftop here [14:42] well this is what iftop shows leguin.acc.umu.se [14:52] or are they one of the irc servers? [15:04] hello again [15:04] it is raining here, it is nice. [15:10] so I try to view google plus again, its been a while, and it just never stops loading. [15:10] I am glad that irc works much better! [15:30] lo kbmonkey [15:30] send the rain here [15:33] will do Kilos ! [15:33] ty [15:34] Maaz, do a rain dance [15:34] kbmonkey: What? [15:34] haha [16:15] weo weo [16:32] whats that zeref ? [16:32] Maaz, defiine weo weo [16:32] Kilos: Sorry... [16:33] ai! [16:33] Maaz, define weo weo [16:33] Kilos: I don't have a definition for that. Is it even a word? [16:36] pew pew [16:36] :D [16:36] oh that [16:36] whew [16:37] i wonder how one spells that [16:37] phew [16:38] nope not that either [16:38] use sjoe in afrikaans [16:40] pew pew <<----- sound the guns in star wars make :) [16:40] oh that [16:40] hehe [16:43] hi superfly [16:45] hi Kilos [17:07] zeref, you are as bad as me [17:07] bloep=bell.ogg [17:33] o/ [17:33] hi oom Kilos, lo superfly, zeref [17:33] lo nuvolari [17:33] and kbmonkey [17:34] hi oom :) Gaan dit goed? [17:34] ja dankie seun en self? [17:34] :-) [17:34] dit gaan oraait dankie oom [17:35] bietjie afgepie by die werk want ek moet nou sukkel met software wat ek nie kan uitfigure nie [17:35] ai! [17:36] kry hulp man [17:38] daar is 'n wiki vir die sagteware maar dit is die basics [17:38] niks in die lyn van wat ek mee moet sit nie [17:38] ai! [17:39] as ek hare gehad het, het ek hulle een vir een uitgepluk [17:39] hahaha [17:39] watse safteware [17:39] sagteware [17:43] inetpro, slaap jy nog? [17:46] Kilos: ETL, Extract, Transform, List. Dis 'n tipe datamining [17:47] ai! [18:02] hi nuvolari [18:57] night all. sleep tight [19:56] Hi peeps [19:57] could someone tell me what ports to open on my web server in the DMZ so i can pull updates and packages from ubuntu repository [19:58] port 80 [19:58] uh, your web server? [19:58] yup [19:58] I presume you're talking actual server machine, not software [19:59] bajayi: how do you browse the net normally? [19:59] updates for packages et al stuffs like apt-get ..... [19:59] do you use a proxy? [19:59] yes, you said that [20:00] the web server is placed on the DMZ and we have port 80 and 443 opened [20:00] but i still cant get updates or packages to install on the web server when i run apt-get [20:00] bajayi: when you say, "web server" is this the box you're trying to update? [20:00] what does apt-get say? [20:00] yes superfly [20:02] unable to retrieve packages ...something along those lines [20:02] which tells me everything, of course. [20:03] how about you give me the actual error message... or better yet, the entire output you get from the moment you type "sudo apt-get update" [20:03] and then explain how you browse the web from inside your DMZ [20:03] i cant provide that now....i'm home [20:04] i'll revert back with e specific error messages on monday when i'm at work [20:04] report back [20:04] to revert is to put back to what it was [20:07] i hear you! [20:07] :) [20:07] hang in there [20:10] here you go! [20:10] connected via my vpn [20:10] Last login: Fri Oct 11 17:44:07 2013 from 192.168.140.1 root@web1:~# apt-get update Err http://ng.archive.ubuntu.com precise Release.gpg Temporary failure resolving 'ng.archive.ubuntu.com' Err http://security.ubuntu.com precise-security Release.gpg Temporary failure resolving 'security.ubuntu.com' 0% [Connecting to ng.archive.ubuntu.com] [20:10] so you have a DNS issue [20:11] ok [20:11] and why are you connecting to ng.archive.ubuntu.com ? [20:11] thats my location [20:11] Nigeria [20:11] ah [20:11]