#archiveteam-bs 2013-05-06,Mon

↑back Search

Time Nickname Message
01:57 πŸ”— godane so i scanned 2 new magazines tonight
02:07 πŸ”— SketchCow Thank you!
02:10 πŸ”— godane i have 4 magazines that i can upload in total
02:11 πŸ”— godane i found out there was a setting to repeat the scan
10:30 πŸ”— ersi http://i.imgur.com/BnJSXsr.jpg Jason, is that you?
10:42 πŸ”— BlueMax yes.
10:42 πŸ”— omf_ In the beginning of episode 3 of Lois & Clark: The New Adventures of superman, Clark asks Lois if she backed up her work to floppy disk. Even superman is an Archivist
12:16 πŸ”— godane uploaded: https://archive.org/details/g4tv-video-xml-20130131
13:05 πŸ”— Smiley :D
13:19 πŸ”— godane first new scan: https://archive.org/details/pc-novice-1995-04
13:19 πŸ”— godane I'm using magazine media setting this time
13:20 πŸ”— godane the images look alot better now
13:20 πŸ”— godane less dots in them
13:26 πŸ”— godane so i was just looking at zdnet.com today
13:26 πŸ”— godane i may have figure a quick way to back up articles
13:27 πŸ”— godane the number that the end of story title can be used like this: www.zdnet.com/7000012360/
13:27 πŸ”— godane it will redirect to the story
13:29 πŸ”— omf_ ( Ҁ’_Ҁ’)σ Smiley or ( Ҁ’_Ҁ’)σ GLaDOS
13:29 πŸ”— GLaDOS Something about anarchive?
13:30 πŸ”— omf_ kinda
13:30 πŸ”— GLaDOS Go on..
13:31 πŸ”— Smiley uhoh
13:31 πŸ”— GLaDOS Smiley: nothing bad.
13:31 πŸ”— Smiley ah cool
13:47 πŸ”— omf_ godane, Why do you think zdnet needs a backup? The IA has hundreds of grabs of it every year going back at least 13 years
13:50 πŸ”— godane just was thinking how would grab it in a panic download
13:50 πŸ”— godane thats all
13:51 πŸ”— Famicoman I need a bigger scanner
13:51 πŸ”— Famicoman or one where the scanning element actual goes to all the borders of the glass
13:55 πŸ”— godane so looks like i got that american pages ads right in 1995-05 issue of pc novice
13:56 πŸ”— godane there was a copy in i think 1996-06 or 1996-07 where i couldn't get all of it cause of the text being right at the binder of the magazine
13:57 πŸ”— godane uploaded: https://archive.org/details/pc-novice-1995-05
14:01 πŸ”— godane my item derive saids 97 pages when there is only 96
14:02 πŸ”— godane weird
14:08 πŸ”— godane ok now ftp is not working
14:09 πŸ”— godane getting a 421 too many connections (10) from the IP
14:11 πŸ”— godane it looks like i can get check if my pc-novice-1995-06 item is fully uploaded with ftp right now
14:30 πŸ”— godane can anyone tell why i'm getting this error?
19:27 πŸ”— ersi Anyone around and could help me with some SQL?
19:28 πŸ”— alard Depends on the type.
19:28 πŸ”— ersi How would I replace the statistics.infohash with the torrents.name in this query? SELECT DISTINCT statistics.infohash, MAX(statistics.uploaded_bytes) FROM statistics GROUP BY statistics.infohash ORDER BY uploaded_bytes DESC; -- schema at http://pastie.org/private/hqrpad4a1irzq1zvpk546g
19:30 πŸ”— alard Doesn't the GROUP BY already make it DISTINCT?
19:30 πŸ”— ersi Hmmm, maybe. It doesn't complain about it at least
19:30 πŸ”— alard SELECT torrents.name, MAX(statistics.uploaded_bytes) FROM statistics, torrents GROUP BY statistics.infohash WHERE statistics.infohash = torrents.infohash
19:30 πŸ”— alard perhaps?
19:31 πŸ”— ersi Yeah, GROU BY will make it DISTINCT already (just tried)
19:31 πŸ”— antomatic select torrents.name FROM statistics JOIN torrents on torrents.infohash = statistics.infohash GROUP BY torrents.name ORDER BY whateverfieldyouwant ?
19:32 πŸ”— antomatic depends what other fields you wanted and whether the group or distinct were necessary
19:32 πŸ”— antomatic I think.
19:33 πŸ”— antomatic no need for the group if you don't need/want a sum/max/min of another field - e.g. uploaded_bytes
19:34 πŸ”— ersi Well, what I want is the highest uploaded_bytes per infohash/name
19:34 πŸ”— alard I think both of these queries should work.
19:35 πŸ”— antomatic select torrents.name, max(uploaded_bytes) FROM statistics JOIN torrents on torrents.infohash = statistics.infohash GROUP BY torrents.name ORDER BY name
19:36 πŸ”— ersi Seems to work
19:38 πŸ”— ersi Thanks :)
19:38 πŸ”— godane does any one know of a mirror of cbc podcats?
19:38 πŸ”— godane *podcasts
19:39 πŸ”— godane i ask cause even thought wayback machine did a good job it doesn't have all of them
19:39 πŸ”— godane example of dead link: http://podcast.cbc.ca/mp3/podcasts/spark_20081118_9315.mp3
19:41 πŸ”— godane very funny that spark talks alot about backup stuff then they lose like every past 2011-09
19:44 πŸ”— chronomex hah :|
19:45 πŸ”— godane i now wished i downloaded all of it when jason scott first came on
19:46 πŸ”— godane now my crazy archiving is now not crazy
20:39 πŸ”— omf_ Load average: 24.88 24.76 24.70 for my server ;)
21:48 πŸ”— nico_ writting parsing tools
21:49 πŸ”— nico_ for generating a big url list is not fun
21:50 πŸ”— nico_ (destroyed some part of my encrypted fs, need to remake local copy of some comics)
21:50 πŸ”— Smiley o_O
21:51 πŸ”— nico_ yeah
21:51 πŸ”— nico_ never trust the debian installer to not fuck up luks
21:51 πŸ”— Smiley :D
21:51 πŸ”— nico_ the oh sh* moment
21:51 πŸ”— norbert79 Interesting... Debian Installer was so far the only tool with which I could build upa PROPER LUKS based LVM layout
21:52 πŸ”— nico_ then the how old are my backup
21:52 πŸ”— nico_ 2 month ago ?!?
21:52 πŸ”— Smiley :O
21:52 πŸ”— nico_ rebuilding is time consuming
21:52 πŸ”— Smiley drwxr-xr-x 4 root root 4.0K Apr 26 03:16 daily.10
21:52 πŸ”— Smiley drwxr-xr-x 4 root root 4.0K May 5 03:16 daily.1
21:52 πŸ”— Smiley drwxr-xr-x 4 root root 4.0K May 6 03:16 daily.0
21:53 πŸ”— Smiley 30 daily backups ftw
21:53 πŸ”— omf_ what fs are you using
21:53 πŸ”— nico_ my backup =~ 4GByte
21:53 πŸ”— norbert79 Differential backups as I see
21:53 πŸ”— nico_ norbert79: i wanted to import an existing lvm over luks layout
21:54 πŸ”— norbert79 nico_: Oh, I see... I saw some sort of description on that regarding Mint
21:54 πŸ”— omf_ only 4gb, lucky guy
21:54 πŸ”— norbert79 as Linux Mint not supporting LUKS
21:54 πŸ”— norbert79 in default
21:54 πŸ”— nico_ norbert79: i was running the debian installer of debian 7.0
21:54 πŸ”— nico_ fedora 18 & fedora 19 are nogo on this machine
21:54 πŸ”— nico_ instant crash in some pango libs
21:55 πŸ”— nico_ look like debian 7.0 is working
21:55 πŸ”— nico_ (but i really miss the updated graphic stack)
21:55 πŸ”— Smiley rrsnapshot -c /etc/rsnapshot.d/daily.conf daily || echo "Backup failure"
21:55 πŸ”— Smiley bang
21:56 πŸ”— Smiley However I do need to fix up my router with rsnapshot too
21:56 πŸ”— nico_ Smiley: i store my backup on a computer that is powered off when i am not backuping to it
21:56 πŸ”— Smiley Ah
21:56 πŸ”— nico_ you cannot hack sometime that is not running
21:56 πŸ”— Smiley wakeonlan ftw.
21:56 πŸ”— Smiley I've not been hacked yet.
21:56 πŸ”— Smiley :/
21:57 πŸ”— omf_ I miss ZFS. Having the filesystem take care of backups is better
21:57 πŸ”— nico_ (look like my buggy script worked)
21:57 πŸ”— nico_ 529 experiment/image_to_dl
21:57 πŸ”— nico_ nico@Gallifrey:~/Images$ wc -l experiment/image_to_dl
21:57 πŸ”— Smiley omf_: someone I know i working on bringing it to linux properly.
21:57 πŸ”— * nico_ is happy
21:58 πŸ”— Smiley I really need to get my QoS working on my router however D:
21:58 πŸ”— * Smiley ponders @just loading it@
21:58 πŸ”— Smiley wtf is up with my locale :<
21:58 πŸ”— nico_ wget -e robots=off --user-agent="Mozilla/5.0 (Photon; U; QNX x86pc; en-US; rv:1.6) Gecko/20040429" -i ./image_to_dl
21:58 πŸ”— omf_ (Γ―ΒΌΒΓ’Β€ΒΈΓ‘ΒƒΒš)
21:59 πŸ”— nico_ let's do it :)
21:59 πŸ”— omf_ yeah I facepalmed you
21:59 πŸ”— norbert79 omf_: ZFS is ready for Linux use...
21:59 πŸ”— Smiley but utf works again :D
21:59 πŸ”— norbert79 omf_: Not in 'experimental' anymore
21:59 πŸ”— nico_ norbert79: i didn't find how to monitor the state of the harddrive
21:59 πŸ”— nico_ aka knowing when the hdd is going to die
22:00 πŸ”— norbert79 nico_: You mean smarttools?
22:00 πŸ”— omf_ smartctl
22:00 πŸ”— norbert79 that
22:00 πŸ”— norbert79 smartmontools - control and monitor storage systems using S.M.A.R.T.
22:02 πŸ”— nico_ nevermind it is in zpool status
22:03 πŸ”— nico_ look like it need a cronjob to do a zpool scrub mypool
22:08 πŸ”— Coderjoe yes, zpool scrub will verify checksums (and repair), and zpool status will show health. smartctrl is still useful for checking the raw drive info, however
22:34 πŸ”— Smiley Hmmm no godane
23:24 πŸ”— Coderjoe "Creative Clown Went Down" - to the tune of Merry Go Round Broke Down?
23:27 πŸ”— Smiley what is creative clown anyay...
23:27 πŸ”— Smiley joke on cloud?
23:27 πŸ”— Coderjoe s/cloud/clown/
23:27 πŸ”— omf_ It is this shitastic product - https://www.adobe.com/products/creativecloud.html
23:28 πŸ”— omf_ Adobe is clowing up
23:34 πŸ”— Smiley Ooooh just saw that on slashdot, heh
23:34 πŸ”— Smiley didn't connect the dots
23:34 πŸ”— omf_ We have now seen how Adobe will fail
23:38 πŸ”— Coderjoe omf_: you mean the many flash and reader vulns were not enough of a fail?
irclogger-viewer