| --- Log opened Tue Sep 26 00:00:03 2006 |
| 00:08 | <@Vornicus> | blarg |
| 00:17 | <@Vornicus> | message=`cat $errorfile | awk 'BEGIN { flag=0 } flag >= 2 { print $0 } flag == 1 || /^-+ -+ -+$/ { ++flag }' | egrep -vi "^Testcase"` |
| 00:18 | <@ToxicFrog> | I recognize that awk script~ |
| 00:19 | <@ToxicFrog> | Except for the bit where it doesn't work. |
| 00:19 | <@ToxicFrog> | Oh, wait. |
| 00:19 | <@ToxicFrog> | Yes it does. |
| 00:19 | <@ToxicFrog> | Nvm. |
| 00:19 | <@Vornicus> | I think you wrote that awk script. |
| 00:19 | <@ToxicFrog> | Too much mad science, not enough baguette. |
| 00:19 | <@ToxicFrog> | Most of it. You've modified it slightly since. |
| 00:20 | <@Vornicus> | have i? |
| 00:21 | <@ToxicFrog> | I'm fairly sure it used to be /--- --- ---/ and not /^-+ -+ -+$/ |
| 00:22 | <@Vornicus> | nah, it was always - or as long as I've been using it - been -+, because it's more like a dozen dashes and I didn't feel like counting. |
| 00:23 | <@ToxicFrog> | Aah. |
| 00:23 | <@ToxicFrog> | In that case, maybe you haven't modified it. |
| 00:27 | <@Vornicus> | but either it or something very near it is broken. |
| 00:34 | <@Vornicus> | and that's the only line i don't completely understand. |
| 00:34 | <@Vornicus> | so. |
| 00:39 | <@ToxicFrog> | Broken how? |
| 00:39 | <@Vornicus> | script hangs up, doesn't get any further. |
| 00:39 | <@ToxicFrog> | "hangs up" how? |
| 00:39 | <@Vornicus> | it... hangs. |
| 00:40 | <@Vornicus> | I don't know. |
| 00:40 | <@ToxicFrog> | Oh. |
| 00:40 | <@Vornicus> | It just sits there. |
| 00:40 | <@ToxicFrog> | So, not SIGHUP or close(). |
| 00:40 | <@Vornicus> | no. |
| 00:40 | <@ToxicFrog> | Well, it looks perfectly fine to me. |
| 00:40 | <@Vornicus> | as far as I can tell it /is/ perfectly fine. but. |
| 00:41 | | ThaquiSleep is now known as ThaquiWork |
| 00:57 | | ReivZzz is now known as Reiver |
| 01:14 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has quit [Ping Timeout] |
| 01:21 | | Syloqs-AFH [Syloq@NetAdmin.Nightstar.Net] has quit [Ping Timeout] |
| 01:25 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has joined #code |
| 01:50 | | MahalOut is now known as Mahal |
| 01:53 | | Vornicus [~vorn@Nightstar-18307.slkc.qwest.net] has quit [Quit: ] |
| 01:57 | | Reiver is now known as ReivClass |
| 02:05 | | Mahal is now known as MahalAFK |
| 02:47 | | MahalAFK is now known as Mahal |
| 03:13 | <@Mahal> | Question. |
| 03:13 | <@Mahal> | Excel spreadshet. |
| 03:13 | <@Mahal> | How can I export it in a format I cna import into MySQL? |
| 03:13 | | * Chalcedon eyes |
| 03:13 | <@ToxicFrog> | Ummmmm. |
| 03:13 | <@ToxicFrog> | No idea. |
| 03:13 | <@Chalcedon> | I don't know anything about SQL at all, but I'd suggest starting by looking at csv |
| 03:14 | <@ToxicFrog> | (well, I mean, "export to CSV, use awk to process into .sql", but that's probably too general) |
| 03:14 | <@Mahal> | See, Frog, I didn't even know that much :) |
| 03:16 | <@Vornicus-Latens> | MySQL has a particular dump format; if you can't find an example, use mysql's dump tool to create a dump, and then format your text accordingly, and then use mySQL's import tool to import the data. |
| 03:17 | <@Mahal> | I know what a MySQL dump looks like. |
| 03:17 | <@Mahal> | The issue is that the excel sheet has ~600 entries. |
| 03:17 | | * Mahal was hoping that csv can be done in a roughly dump-like format, somehow. |
| 03:18 | | * Mahal notes her customer will happily pay through the nose for this to be done, so it is no problem. |
| 03:18 | <@Mahal> | I just DO NOT WANT to do any of it by hand. |
| 03:19 | <@Vornicus-Latens> | That's why you use awk (or python or ruby or perl) |
| 03:19 | | * Mahal has never used awk. |
| 03:19 | | * Mahal is not a real geek ;) |
| 03:20 | <@ToxicFrog> | Awk is made of love and kittens. |
| 03:20 | <@ToxicFrog> | It is the god of text processing. |
| 03:20 | | * Chalcedon will vouch for python being easy to pick up |
| 03:20 | | * Mahal has heard this. |
| 03:20 | <@Mahal> | It is one of the many tools I want to know how to use. |
| 03:21 | <@Mahal> | but time/etc/etc/etc to start learning these things has been in short supply |
| 03:21 | <@ToxicFrog> | And I'm not sure how closely csv resembles a SQL dump, but it's v. v. v. easy to parse. |
| 03:21 | <@ToxicFrog> | And to process with awk. |
| 03:21 | <@Mahal> | Yeah, I knw. |
| 03:21 | <@Mahal> | I've done /that/ before. |
| 03:21 | <@Mahal> | Er. |
| 03:21 | <@Mahal> | Export to csv, I've done before. |
| 03:21 | <@Mahal> | Not the rest. |
| 03:21 | | * Chalcedon eyes |
| 03:21 | | * Mahal really should set up a linux box. |
| 03:22 | <@Chalcedon> | you can export mySQL files to csv? |
| 03:22 | <@Mahal> | er, no. |
| 03:22 | <@Vornicus-Latens> | My experience with PostgreSQL was that its dump was primarily a bunch of tables as CSV with some SQL commands at the start of each table. |
| 03:22 | <@Chalcedon> | ok, sorry, misread in that case |
| 03:22 | <@Mahal> | Loosely correct, Vorny |
| 03:22 | | * Mahal just wondered if there was a Quick Clever Way to do it. |
| 03:22 | <@Vornicus-Latens> | There are some minor issues along the way, but it's what it looks like. |
| 03:23 | <@ToxicFrog> | Mahal: I can probably give you an account on Orias to play around with once I finish its brain transplant. |
| 03:23 | <@Mahal> | Frog, I have =counts= four boxen doing exactly zero, and one that needs a rebuilt. |
| 03:24 | <@Mahal> | It is laziness preventing me settting up my own box, not lack of access to hardware/software :) |
| 03:24 | <@ToxicFrog> | Aah. |
| 03:24 | <@Mahal> | Also the fact I keep telling myself i /will/ get to grips with ubuntu, and then immediately deciding I hate it |
| 03:24 | <@Mahal> | I'm /used/ to redhat, dammit! |
| 03:25 | <@Mahal> | So I keep installing ubuntu and going "arrgh" and ignoring that box for a month until i try it over again. |
| 03:25 | <@ToxicFrog> | Try Fedora 5? |
| 03:25 | | * Mahal <3 fedora. |
| 03:25 | <@ToxicFrog> | Eeee, I love the disk activity lights on this box. |
| 03:25 | <@Mahal> | The point is that I feel like I /should/ learn ubuntu too. |
| 03:25 | <@ToxicFrog> | Every time I alter the partition tables, they each light up in sequence as it rereads each drive's boot sector. |
| 03:26 | <@Mahal> | :) |
| 03:27 | <@ToxicFrog> | Hah! We have X11! |
| 03:27 | <@ToxicFrog> | ...we don't have mouse, though. |
| 03:27 | <@ToxicFrog> | Did Anaconda drop serial mouse support in FC5 or something? |
| 03:27 | | ReivLab [~82d94c4d@Nightstar-16835.oasis-open.org] has joined #Code |
| 03:27 | <@Chalcedon> | hello Reivy |
| 03:27 | < ReivLab> | hihi |
| 03:27 | <@Mahal> | hihi |
| 03:28 | <@ToxicFrog> | Noooooooo! Why is my serial mouse not working ;.; |
| 03:28 | <@Mahal> | nuuuu! |
| 03:28 | | Schlock [~schlock@Nightstar-6915.hsd1.or.comcast.net] has joined #code |
| 03:28 | | mode/#code [+v Schlock] by ChanServ |
| 03:28 | < ReivLab> | !roll 12082/60 |
| 03:28 | <+Schlock> | Dice Rolled For ReivLab: 12082/60 = 201 |
| 03:29 | < ReivLab> | So TheWatcher's been idle... three hours. Hokay. |
| 03:29 | | * ReivLab lets the man sleep. |
| 03:34 | <@ToxicFrog> | Keh. |
| 03:35 | <@ToxicFrog> | I wish I knew what FSID Linux uses for software RAID partitions. |
| 03:35 | | * Mahal eyes. |
| 03:35 | <@ToxicFrog> | Then I could do this in fdisk rather than (mouseless) X11. |
| 03:55 | <@ToxicFrog> | "Formatting / filesystem" |
| 03:55 | <@ToxicFrog> | And all eight drive activity lights go on! squeeeeeeeeeeeeee |
| 03:55 | | * Mahal ponders. |
| 03:55 | | * Mahal have a bordeaux dvd. |
| 03:55 | | * Mahal do not have a dvd reader int he machine she wish to use. |
| 03:55 | | * Mahal do not wish to download fc5 agin. |
| 03:55 | | * Mahal poop. |
| 03:56 | <@ToxicFrog> | Mahal: I note that you can do a pure-network install with FC5. |
| 03:56 | <@Mahal> | ... how? |
| 03:56 | | * Mahal eyes. |
| 03:56 | <@Mahal> | If you mean via the internet, bugger that. |
| 03:56 | <@ToxicFrog> | Admittedly, you're still downloading it, but at least you're only downloading the bits you need rather than ~3.5GB of ISO9660 images. |
| 03:56 | <@Mahal> | I only /have/ 2mb down. |
| 03:56 | <@ToxicFrog> | You can also do it over a LAN. |
| 03:56 | <@Mahal> | How would I do so via lan? |
| 03:56 | <@ToxicFrog> | You'll need a local http or ftp server with a complete set of FC5 install files, though. |
| 03:57 | <@ToxicFrog> | (you can copy them off the DVD if you have one handy) |
| 03:57 | <@Mahal> | would the bordeaux dvd files count as it? |
| 03:57 | <@Mahal> | Ah. |
| 03:57 | | * Mahal ponder. |
| 03:57 | | * Mahal have a local http server. |
| 03:57 | <@ToxicFrog> | I have no idea, what's Bordeaux? |
| 03:57 | <@Mahal> | fc5 |
| 03:57 | <@Mahal> | (Sorry) |
| 03:57 | <@ToxicFrog> | Aah. |
| 03:57 | <@ToxicFrog> | Anyways, the general idea is: |
| 03:57 | | * Mahal goes to poke her computer |
| 03:58 | <@ToxicFrog> | - create HTTP, FTP or NFS mirror. The "Fedora" directory (containing "RPMS" and "base" is the important one) |
| 03:58 | | * Mahal hrmmmmmmmmmmmmmmmmm. |
| 03:58 | | * Mahal wonder where in the goodness fc5 disc IS. |
| 03:58 | <@ToxicFrog> | - boot into the minimal installer. Either burn http://less.cogeco.net/pub/fedora/linux/core/5/i386/os/images/boot.iso (7MB, there should also be a copy on your DVD) and boot that, or simply boot the kernel and initrd for the minimal installer directly with the bootloader of your choice. |
| 03:59 | <@ToxicFrog> | - select "NFS mount", "FTP mirror" or "HTTP mirror" as the installation method when prompted |
| 03:59 | <@ToxicFrog> | - configure NIC |
| 03:59 | <@ToxicFrog> | - point it at the right place |
| 03:59 | <@ToxicFrog> | - go |
| 03:59 | <@ToxicFrog> | Note that this /only/ supports the tty interface. |
| 03:59 | <@ToxicFrog> | No X11 installer. |
| 03:59 | <@ToxicFrog> | So if for some reason the tty installer doesn't work right on your box, you're doomed. |
| 04:00 | | * Mahal decides to try it! |
| 04:00 | | * Mahal is going to need tofind the frelling CD first. |
| 04:00 | <@Mahal> | *dvd |
| 04:03 | | * MahalWork hooray, found it. |
| 04:03 | | * MahalWork idly wonder why her desktop is using 69% of it's ram. |
| 04:04 | <@ToxicFrog> | # top and find out. |
| 04:04 | | * MahalWork wonder WHERE, more importantly. |
| 04:04 | | * MahalWork is on windows. |
| 04:04 | <@ToxicFrog> | Ctrl+shift+backspace and find out, then. |
| 04:04 | <@ToxicFrog> | (after appropriate fiddling so that it actually shows you memory usage) |
| 04:04 | | * MahalWork is doing this. |
| 04:04 | | * MahalWork is just puzzled. |
| 04:05 | <@ToxicFrog> | Anyways. Anaconda (the FC5 installer) has gone blooey, providing me with an incredibly detailed stack trace, but not actually telling me what the original exception was. |
| 04:05 | <@MahalWork> | :( |
| 04:05 | <@ToxicFrog> | I think I can work around this, but it's 2310, so I'm going to sleep instead. |
| 04:05 | <@ToxicFrog> | 'night! |
| 04:05 | | * MahalWork hug. |
| 04:05 | <@MahalWork> | Night! |
| 04:05 | <@MahalWork> | Also thankyou for help.\ |
| 04:06 | <@ToxicFrog> | Let me know how it goes! |
| 04:06 | <@MahalWork> | :) |
| 04:06 | <@MahalWork> | I will! |
| 04:07 | <@MahalWork> | .... |
| 04:07 | <@MahalWork> | I need to set up a monitor. |
| 04:07 | <@MahalWork> | BAH. |
| 04:07 | <@MahalWork> | :) |
| 04:08 | | MahalWork [~Mahal@Nightstar-4219.worldnet.co.nz] has quit [Connection reset by peer] |
| 04:08 | | Chalcedon is now known as ChalcyWork |
| 04:08 | | MahalWork [~Mahal@Nightstar-4219.worldnet.co.nz] has joined #Code |
| 04:08 | | mode/#code [+o MahalWork] by ChanServ |
| 04:12 | < ReivLab> | What is Mahal doing to her computar? |
| 04:13 | <@MahalWork> | Playing! |
| 04:13 | < ReivLab> | Games, or Linuxen? :p |
| 04:14 | <@MahalWork> | LInuxen. |
| 04:15 | < ReivLab> | Ooh. |
| 04:16 | < ReivLab> | Have fun! |
| 04:17 | | ChalcyWork [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has quit [Ping Timeout] |
| 04:18 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has joined #code |
| 04:18 | | mode/#code [+o Chalcedon] by ChanServ |
| 04:25 | | * Mahal SQUEEZEPET the frog, gives him alcohol or chocolate of choice!!!!! |
| 04:25 | < ReivLab> | (It worked?) |
| 04:25 | <@Mahal> | YES |
| 04:25 | < ReivLab> | woo! |
| 04:25 | | * ReivLab hug Mahal, yays! |
| 04:27 | <@Mahal> | and and - it's a graphical installer o.O |
| 04:29 | < ReivLab> | Fedora? |
| 04:29 | < ReivLab> | Yus. |
| 04:29 | < ReivLab> | Shiny, no? :) |
| 04:30 | < ReivLab> | (Have you done the HD rearrangements yet?) |
| 04:30 | <@Mahal> | Yes! |
| 04:30 | <@Mahal> | (no) |
| 04:30 | < ReivLab> | (So not gonna bother, or...?) |
| 04:30 | <@Mahal> | Er. |
| 04:30 | <@Mahal> | >.< |
| 04:31 | <@Mahal> | eventually? |
| 04:31 | | * Mahal want a bigger hard drive still... |
| 04:32 | <@Mahal> | Also! |
| 04:32 | < ReivLab> | Pff. |
| 04:32 | <@Mahal> | VNC server. |
| 04:32 | | * Mahal can thus control from laptop if wanting graphical, not command line :) |
| 04:32 | | * ReivLab patpat. |
| 04:32 | < ReivLab> | (Set up irssi.) |
| 04:32 | < ReivLab> | (You knwo you want to.) |
| 04:33 | <@Mahal> | Hrmm. |
| 04:33 | | * Mahal might. |
| 04:33 | | * Mahal ooohhhh.... |
| 04:33 | | * Mahal could have DynDNS forwarding her SSH to this box. |
| 04:33 | <@Mahal> | and the other stuff to the other box like it still does! |
| 04:33 | | * Mahal hrmm! |
| 04:34 | | * Mahal vaguely pet Fedora! |
| 05:47 | | * ReivLab stabs bioinformatics. |
| 05:47 | | * Mahal hug Reiv |
| 05:58 | | ReivLab [~82d94c4d@Nightstar-16835.oasis-open.org] has quit [Quit: Enough of this. Home!] |
| 06:12 | | Shemhazai [~Shemhazai@Nightstar-8502.ds1-ba.adsl.cybercity.dk] has quit [Quit: Don't try to read the quit message, that is impossible. Instead only realize the thruth; "there is no quit message" and you will see it is not you who read the quit message but the quit message who reads you.] |
| 06:29 | | ReivClass is now known as Reiver |
| 07:11 | | EvilDarkLord is now known as Jo}{n |
| 07:35 | | McMartin is now known as McMartin[legendaryjourneys] |
| 07:36 | | ptsman [~ptsman@216.249.5.ns-12483] has joined #Code |
| 07:36 | < ptsman> | hey people i have quite a few items i want gone immediately, 2 nvidia geforce 7900gtx overclocked video cards, 1 pentium D 3.6 ghz processor with motherboard, dvd writer, SB Audigy X-fi and 2 portble notebooks. shipment is included and pay pal is accepted message if interested on aim at laptopmike1981 or msn at thisisjustmike@telusmail.net or yahoo at mbogdenn or icq at 372048073 |
| 07:37 | <@Mahal> | Hooray for spam |
| 07:37 | | mode/#code [+b *!*@216.249.5.ns-12483] by Mahal |
| 07:37 | | ptsman was kicked from #Code by Mahal [Mahal] |
| 07:37 | | mode/#code [-b *!*@216.249.5.ns-12483] by Mahal |
| 08:41 | | Mahal [~Mahal@Nightstar-4219.worldnet.co.nz] has quit [Quit: brb.] |
| 08:42 | | Mahal [~Mahal@Nightstar-4219.worldnet.co.nz] has joined #Code |
| 08:42 | | mode/#code [+o Mahal] by ChanServ |
| 08:57 | | Mahal is now known as MahalAFK |
| 09:03 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has quit [Ping Timeout] |
| 09:10 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has joined #code |
| 09:24 | | MahalAFK [~Mahal@Nightstar-4219.worldnet.co.nz] has quit [Quit: reboot] |
| 09:29 | | Mahal [~Mahal@Nightstar-4219.worldnet.co.nz] has joined #Code |
| 09:30 | | mode/#code [+o Mahal] by ChanServ |
| 09:33 | | You're now known as TheWatcher[wr0k] |
| 10:20 | | Chalcedon is now known as ChalcyZzz |
| 10:29 | | Mahal is now known as MahalDishes |
| 10:46 | | MahalDishes is now known as Mahal |
| 11:10 | | Mahal is now known as MahalZzz |
| 11:29 | | ThaquiWork is now known as Thaqui |
| 12:47 | | Reiver [~reaverta@IRCop.Nightstar.Net] has quit [Ping Timeout] |
| 13:37 | | Schlock [~schlock@Nightstar-6915.hsd1.or.comcast.net] has left #Code [] |
| 13:41 | | ChalcyZzz [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has quit [Ping Timeout] |
| 14:55 | | Thaqui is now known as ThaquiSleep |
| 15:03 | | SOrMyGy [sul4r@Nightstar-25296.dsl.bell.ca] has joined #Code |
| 15:05 | | SOrMyGy [sul4r@Nightstar-25296.dsl.bell.ca] has quit [Quit: New game started, http://sre.servegame.com : This is a webgame based on SOLAR REALMS ELITE, a famous BBS game back in 1992 (Earth2025/BRE fans are welcome)] |
| 15:10 | | Jo}{n is now known as EvilDarkLord |
| 15:15 | <@ToxicFrog> | Mahal: do tell how you got the X11 install. |
| 15:23 | | You're now known as TheWatcher |
| 15:51 | <@ToxicFrog> | Hmm. |
| 15:52 | <@ToxicFrog> | So, anaconda does "transferring install image to hard drive", then dies somewhere in software RAID (Anaconda's, not mdd's) with an arrayindexoutofbounds. |
| 16:44 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has quit [Ping Timeout] |
| 16:56 | | EvilDarkLord [althalas@Nightstar-17046.a80-186-184-83.elisa-laajakaista.fi] has joined #code |
| 17:21 | | You're now known as TheWatcher[afk] |
| 17:24 | | Vornicus [~vorn@Nightstar-18307.slkc.qwest.net] has joined #code |
| 17:24 | | mode/#code [+o Vornicus] by ChanServ |
| 18:37 | | You're now known as TheWatcher |
| 19:22 | | Chalcedon [~Chalceon@Nightstar-869.bitstream.orcon.net.nz] has joined #code |
| 19:22 | | mode/#code [+o Chalcedon] by ChanServ |
| 20:10 | | Ev3 [~Shemhazai@Nightstar-8502.ds1-ba.adsl.cybercity.dk] has joined #Code |
| 20:27 | <@jerith> | Evening. |
| 20:36 | | MahalZzz is now known as Mahal |
| 21:01 | <@jerith> | Any databasey people around at all? |
| 21:03 | <@TheWatcher> | Yesish |
| 21:03 | | * Vornicus is databasey. |
| 21:04 | <@jerith> | This may seem liek a silly question, but how do I do a one-to-many relationship? |
| 21:04 | <@Vornicus> | in, what, SQL? |
| 21:04 | <@jerith> | I have a bunch of users and a bunch of packages. |
| 21:04 | | * jerith nods. |
| 21:05 | <@jerith> | And each user can have a bunch of packages he's being billed for, |
| 21:05 | <@jerith> | some more than once. |
| 21:05 | < EvilDarkLord> | You have fields userID and packageID. |
| 21:05 | <@Mahal> | Frog! |
| 21:05 | < EvilDarkLord> | And one row for each user-package combination. |
| 21:05 | <@Vornicus> | CREATE TABLE the_one (id INTEGER PRIMARY KEY); CREATE TABLE the_many (id INTEGER PRIMARY KEY, one_id INTEGER FOREIGN KEY REFERENCES the_one); |
| 21:05 | <@jerith> | (Multiple "basic website" packages for different websites, for example.) |
| 21:05 | <@Mahal> | If you are around, I did not do anything to get the x11 installer. |
| 21:05 | <@Mahal> | I told it where my network location was. |
| 21:05 | <@Mahal> | And it gave me a graphical installer. |
| 21:07 | <@Vornicus> | BUt what you've just described is /not/ one-to-many |
| 21:07 | <@Vornicus> | so |
| 21:07 | <@jerith> | What is it, then? |
| 21:08 | <@jerith> | (Sorry for bad typing, laptop in bed is not conducive to comfortable wrist positioning.) |
| 21:08 | <@Vornicus> | CREATE TABLE package (id INTEGER PRIMARY KEY); CREATE TABLE user (id INTEGER PRIMARY KEY); CREATE TABLE user2package (package_id INTEGER FOREIGN KEY REFERENCES package, user_id INTEGER FOREIGN KEY REFERENCES user); |
| 21:08 | <@Vornicus> | It's many to many |
| 21:09 | <@jerith> | Umm, so it is. Sorry, I was focusing a little to tightly on individual users. |
| 21:09 | <@Vornicus> | erp, missed one |
| 21:10 | <@Vornicus> | CREATE TABLE package (id INTEGER PRIMARY KEY); CREATE TABLE user (id INTEGER PRIMARY KEY); CREATE TABLE user2package (%Bid INTEGER PRIMARY KEY, %Bpackage_id INTEGER FOREIGN KEY REFERENCES package, user_id INTEGER FOREIGN KEY REFERENCES user); |
| 21:10 | <@Vornicus> | ...dammit I keep doing that. |
| 21:11 | <@jerith> | "%B"? |
| 21:13 | <@TheWatcher> | (although if you'r eusing mysql you may as well ignore the "foreign key references $key" bit, IIRC it ignores them |
| 21:13 | <@TheWatcher> | ) |
| 21:14 | <@jerith> | I'm not sure what I'm using, but it'll probably be sqlite. |
| 21:14 | <@jerith> | All I'm really looking for here is structure. |
| 21:16 | < EvilDarkLord> | I think foreign keys work with MySQL as long as you use MyISAM tables. |
| 21:19 | <@Vornicus> | "%B", the symbol to begin or end bold in X-Chat |
| 21:19 | <@Vornicus> | does precisely jack in mIRC. |
| 21:20 | <@jerith> | Ah. |
| 21:20 | <@jerith> | Or, apparently, in irssi. |
| 21:22 | <@TheWatcher> | Yeah, irssi needs a proper ctrl-B |
| 21:31 | < Ev3> | :p |
| 21:33 | | * Mahal ponders setting up irssi on the fedora box. |
| 21:34 | <@jerith> | Yay for irssi! |
| 21:35 | <@jerith> | (I just wish I could script it in a labguage other than perl.) |
| 21:36 | <@TheWatcher> | it'd probably be possible to plonk lua into it actually, although I can't say I've really looked at how hard it'd be |
| 21:37 | <@jerith> | I'd rather have python or ruby. |
| 21:37 | <@jerith> | But it's not really worth the effort, really. |
| 21:37 | <@jerith> | Perl's not too bad if you're only writing it. |
| 21:37 | <@jerith> | It's /reading/ it that's tricky. |
| 21:37 | <@Vornicus> | heh |
| 21:38 | <@jerith> | All those declensions and subjunctive clauses. |
| 21:38 | <@TheWatcher> | meh |
| 21:38 | <@jerith> | 'Swhat happens when you let a linguist loose on a computer. |
| 21:38 | <@TheWatcher> | I've spent a week or something hacking othe rpeople's php code and, frankly, give me perl any day |
| 21:39 | <@jerith> | Yeah, php is nasty. |
| 21:39 | | * Mahal eyes. |
| 21:39 | <@jerith> | Right up there with VB, only painful in less obvious ways. |
| 21:39 | <@Mahal> | Depends how badly it's written in the first place.. |
| 21:39 | <@TheWatcher> | (idly Mahal - I ende dup having to completely reqrite the moodle database enrolment code) |
| 21:39 | | * Mahal :( |
| 21:39 | <@jerith> | There's about as much good php out there as there is good perl. |
| 21:40 | <@Mahal> | (I am not surprised, however.) |
| 21:40 | <@TheWatcher> | (for a start, it knew about adding students to courses, fine. But it knew nothing about teachers. And didn't even attempt to go near groups) |
| 21:40 | <@jerith> | I quite enjoyed hacking on drupal. |
| 21:41 | <@Mahal> | TW, indeed. |
| 21:41 | <@Mahal> | It's not really designed well for ... predesigned? courses. |
| 21:41 | <@jerith> | But I won't go near the code for ISPConfig again. |
| 21:42 | <@TheWatcher> | Mahal: this was for our new first-year project. 150 students, 20 groups, 20 tutors |
| 21:42 | <@TheWatcher> | Not huge, but too big to manage easily by hand |
| 21:42 | | * Mahal nod |
| 21:43 | <@TheWatcher> | All of the students have to be on the course, split into the groups so that they each get different forums, wikis and other things as well as shared resources. I've ended up hacking the enrolment and bits of login code about nastily (and I think I found a bug too - seems moodle escapes characters in passwords and doesn't unescape them befor epassing them to the auth backend...) |
| 21:44 | <@Mahal> | Actually, that's true, that bug. |
| 21:45 | | * Mahal noticed it too at one point. |
| 21:45 | | * Mahal didnt care enough about it though. |
| 21:45 | <@TheWatcher> | Well, I fixed it easy enough, but eesh. moodle system in a CS department where all the new students are having Good PAssword Technique drilled into them? >.< |
| 21:46 | | * Mahal nodnod |
| 21:48 | <@jerith> | Bedtime for me. |
| 21:48 | <@jerith> | G'night all. |
| 21:48 | <@Mahal> | Ni |
| 21:48 | <@jerith> | Thanks for your help. |
| 21:48 | <@Vornicus> | "moodle"? |
| 21:49 | <@TheWatcher> | Open source CMS/VLE |
| 21:49 | <@Vornicus> | ah |
| 21:49 | <@TheWatcher> | written in php |
| 21:49 | <@Mahal> | with mysql or postgresql backend |
| 21:49 | <@TheWatcher> | of varying qualities from "ooh, nicely written" to OMGNOESTHEPAINARGH |
| 21:50 | | * Mahal nods. |
| 21:50 | | * jerith squeaks the Vorn, gives him a cookie and bolts for doodoosland. |
| 21:50 | <@Mahal> | Some of it is really /nicely/ written. |
| 21:50 | <@TheWatcher> | Indeed |
| 21:50 | <@Mahal> | Other bits, I looked at and went dear god what monkey on crack put this section together. |
| 21:50 | | * Vornicus remains unsqueaked. |
| 21:50 | <@TheWatcher> | Other parts appearto have ben scraped from satan's bottom |
| 21:51 | <@ToxicFrog> | Mahal: how did you boot it, then? |
| 21:51 | <@Mahal> | From the disk. |
| 21:51 | <@Mahal> | er. |
| 21:51 | <@ToxicFrog> | Hard drive? |
| 21:51 | <@Mahal> | the boot.iso thats in theimages foldre. |
| 21:51 | <@ToxicFrog> | Aah. |
| 21:51 | <@Mahal> | burned that to a disc. |
| 21:51 | <@Mahal> | booted from there. |
| 21:51 | <@ToxicFrog> | I haven't tried that. |
| 21:51 | <@Mahal> | did a network install from my local http server |
| 21:51 | <@Mahal> | Ahh. |
| 21:52 | <@ToxicFrog> | I've tried booting from CD 1 (gives you an X11 install unless you specifically request text), and from the hard drive (gives you text no matter what you ask for) |
| 21:52 | <@Mahal> | Rightoh. |
| 21:52 | <@Mahal> | So I was basically doing the former. |
| 21:52 | | * ToxicFrog nods. |
| 21:52 | <@Mahal> | I wasn't going to dick around with the hard drive. |
| 21:52 | <@Mahal> | Couldn't be bothered. :) |
| 21:52 | <@ToxicFrog> | In this case the CD was necessary because the text-mode installer DFW on a 6000. |
| 21:53 | <@ToxicFrog> | Normally, I just whack the kernel and initrd from the installer into /boot, add an entry in /boot/grub/grub.conf, and reboot. |
| 21:53 | | * Mahal notes the machine was windows at the time. |
| 21:53 | <@ToxicFrog> | That does somewhat complicate matters, yes. |
| 21:53 | <@Mahal> | And thus, CD was quickest :) |
| 21:53 | <@Mahal> | Plus I still have around 100 blank cd's. |
| 21:54 | <@Mahal> | About all I ever use them for is mailing music to my mum. |
| 21:54 | <@Mahal> | (Who does not have a comoputer, but does appreciate my access to Entirely Legitimate Music, No Really from the 'net.) |
| 21:54 | <@ToxicFrog> | Anyways, I finally got it installed. <3 |
| 21:54 | <@Mahal> | :) |
| 21:54 | <@Vornicus> | so now you have a dangscary machine? |
| 21:54 | <@ToxicFrog> | It fills me with bubbling joy to look at top and see it reporting 3,880MB of memory free. |
| 21:56 | <@ToxicFrog> | And /boot is now on a RAID1 mirrored on all the SCSI drives except sdb (which is an older model and thus 300MB smaller than the others). |
| 21:56 | <@ToxicFrog> | / is on a RAID6 taking up the rest of the SCSI space. |
| 21:57 | <@ToxicFrog> | I have to say, though, that even when everything's working properly, the software RAID startup is frickin' scary. |
| 21:57 | <@ToxicFrog> | So, IOW, yes, Vorn, I do. |
| 21:57 | | * Mahal has no scary machines :( |
| 21:58 | <@ToxicFrog> | Aaaw. |
| 21:58 | | * ToxicFrog offers Mahal cookies and a CA-2000. |
| 21:59 | <@Mahal> | yay! |
| 21:59 | <@ToxicFrog> | It's not very scary, but it has an awesome case! |
| 21:59 | | * Mahal is currently using three machines as a footrest under her desk. |
| 21:59 | <@Mahal> | >.< |
| 21:59 | <@TheWatcher> | Well, at least it'll keep your feet warm |
| 21:59 | <@Mahal> | Nono. |
| 21:59 | <@Mahal> | Inactive machines. |
| 21:59 | <@Mahal> | I need to strip the parts. |
| 21:59 | <@Mahal> | and make one semi-decent box. |
| 21:59 | <@Mahal> | Then sell it. |
| 22:00 | <@Mahal> | Or something. |
| 22:00 | <@TheWatcher> | Ah, woe |
| 22:00 | | * Mahal er. |
| 22:00 | <@Mahal> | One of them actually belongs to OldJob. |
| 22:00 | <@Mahal> | I wonder if I should return it. |
| 22:00 | <@Mahal> | It doesn't work. |
| 22:00 | <@ToxicFrog> | Strip the parts, make one semi-decent machine, and bend it your nefarious will. |
| 22:00 | <@ToxicFrog> | Selling it is a waste of good hardware. |
| 22:00 | <@Mahal> | Yeah... |
| 22:01 | <@Mahal> | I note I have a small apartment, and an impending person with extra hardware of his own to contend with too. |
| 22:01 | <@ToxicFrog> | Oh? |
| 22:01 | <@ToxicFrog> | You have a pet human now? |
| 22:04 | | You're now known as TheWatcher[afk] |
| 22:04 | <@ToxicFrog> | (hardware-wise, I have the advantage that I can install stuff in the laundry room) |
| 22:04 | <@Mahal> | I could conceivably do so. |
| 22:04 | <@Mahal> | But I need the power in there for the washer and dryer. |
| 22:04 | <@ToxicFrog> | (sharing a bedroom with this thing would be ;.;. Nine fans!) |
| 22:05 | <@Mahal> | augh |
| 22:05 | <@ToxicFrog> | Two above the drive cage, three between the drive cage and the motherboard enclosure, and two on each CPU. |
| 22:05 | <@Vornicus> | ...crimeny |
| 22:05 | <@ToxicFrog> | Having eight drives, all spinning at 10000RPM, doesn't help. |
| 22:06 | < EvilDarkLord> | What are you running on that monster? |
| 22:06 | <@ToxicFrog> | Fedora 5. |
| 22:06 | <@ToxicFrog> | Which, despite it being custom designed for CacheOS, works fine. |
| 22:07 | <@ToxicFrog> | (apart from the fact that the front panel LCD display doesn't show anything and the drive status lights are permanently stuck on "drive failure", but I always knew I'd have to write my own drivers for those if I wanted them to work) |
| 22:08 | <@ToxicFrog> | Now I just have stupidly large amounts of setup to do. @.@ |
| 22:08 | <@ToxicFrog> | Have to copy over my data from the IDE drives, have to install an assload of daemons, have to configure mdadm to send me mail if a drive explodes... |
| 22:08 | < EvilDarkLord> | Okay. But what manner of foul programs shall you be running that require that kind of power? |
| 22:09 | <@ToxicFrog> | ...what, I need an excuse now? |
| 22:10 | < EvilDarkLord> | ...good point. Better is always better, as it were. |
| 22:10 | | ThaquiSleep is now known as Thaqui |
| 22:10 | <@Vornicus> | HOw much storage does this creature have? |
| 22:11 | <@ToxicFrog> | Well, ok. The 200GB of SCSI RAID6 is for the OS itself, my personal projects, important documents and my music collection. The 360GB of ATA LVM is for stuff I'd be somewhat more sanguine about losing like partially-downloaded torrents. The dual 800MHz CPUs and 4GB of memory are because I got tired of compiling things on a 400MHz Celeron with 192MB. |
| 22:13 | <@ToxicFrog> | Vornicus: 8x36GB + 160GB + 200GB. Works out to around 510GB total because (1) these are in lying bastard base-10 units and (2) the 8x36 is being used for RAID1 and RAID6 arrays. |
| 22:13 | | * fhtagncaps will be impressed when TF's machine is sourcing a 100 TB storage system over iSCSI. |
| 22:13 | <+fhtagncaps> | But that's just me~ |
| 22:13 | <@ToxicFrog> | iSCSI? |
| 22:14 | <+fhtagncaps> | SCSI over IP, essentially. |
| 22:14 | <@ToxicFrog> | Holy shit |
| 22:14 | <@ToxicFrog> | Ok, that's impressive. |
| 22:14 | <@ToxicFrog> | (I actually have the ISCSI daemon installed, I think.) |
| 22:15 | <@ToxicFrog> | Anyways. No ISCSI, but at least all the SCSI stuff is SCA. |
| 22:15 | <+fhtagncaps> | In this case, I sort-of refer to the University of Edinburgh's new storage system for their cluster. |
| 22:15 | <+fhtagncaps> | Which is a little less than 100TB, but roughly that. |
| 22:15 | <@ToxicFrog> | But is it All Yours (ahahahahahahahahahahahha)? |
| 22:16 | | * fhtagncaps finds it hard to fill even one TB of storage, frankly. |
| 22:16 | <+fhtagncaps> | Although this is because I'm not a particle physicist. |
| 22:16 | | * ToxicFrog nods. |
| 22:16 | | * Vornicus could use a bigass drive. |
| 22:17 | <@ToxicFrog> | I find I have no problem at all filling half a terabyte, and based on the number of DVDs I've cooked since getting a burner I wouldn't have much trouble with a full terabyte either. |
| 22:17 | <@Vornicus> | I'm down to 7G out of 80. |
| 22:17 | <@ToxicFrog> | I'd probably be comfy with 4TB, though. |
| 22:17 | <@ToxicFrog> | Ow, Vorn. |
| 22:17 | <+fhtagncaps> | LCG (the computational Grid for processing stuff from the Large Hadron Collider) is projected to have to cope with 12 PB / year. |
| 22:17 | <@ToxicFrog> | Whee, new kernel installed. Let's see if it still boots. |
| 22:18 | <+fhtagncaps> | Storing about 1/2 that. |
| 22:18 | <@ToxicFrog> | Daaaamn. |
| 22:18 | <@ToxicFrog> | On the other hand, does it show you as it spins up each drive individually on a cold boot?~ |
| 22:18 | <+fhtagncaps> | Strangely, no. |
| 22:19 | <@Vornicus> | Fortunately I don't download much |
| 22:19 | <@Vornicus> | so 80G has lasted me about 4 years. |
| 22:20 | <@ToxicFrog> | This is possibly one of the most awesome thing about having all these SCSI drives. |
| 22:20 | | * Mahal needs more space, badly. |
| 22:20 | | * Mahal has 160gig. |
| 22:21 | <@ToxicFrog> | When I start it up, the SCSI controller goes "Spinning up the device! Bus 0, ID #, LUN 0" for each drive, and I hear it come up to speed and then sweep heads. |
| 22:26 | | * fhtagncaps has 40gig, incidently. |
| 22:26 | <+fhtagncaps> | I've not filled it yet; although this is partly due to offloading some data onto 2 DVDs and a quintet of CDs. |
| 22:34 | | Syloq [Syloq@NetAdmin.Nightstar.Net] has joined #code |
| 22:35 | | You're now known as TheWatcher |
| 22:47 | <@ToxicFrog> | I had (80+120+160+200) 560GB prior to this, although that doesn't take into account lying bastard base-10 units or filesystem overhead. |
| 22:50 | <+fhtagncaps> | ..GiB, then? |
| 22:55 | | * Vornicus eyes Google. |
| 22:56 | <@Vornicus> | well, not exactly the response I expected... |
| 22:56 | <@Mahal> | ? |
| 22:56 | <@Vornicus> | [15:18:28] <ToxicFrog> Daaaamn. |
| 22:56 | <@Vornicus> | [1 |
| 22:56 | <@Vornicus> | ...dammit |
| 22:56 | <@Vornicus> | http://www.google.com/search?q=560+gigabytes+in+gibibytes |
| 22:58 | <@ToxicFrog> | !caps: I don't recall, is GiB base-10 lying-bastard units, or true base-2 units used by people who inexplicably don't want to use GB? |
| 22:58 | <@Vornicus> | GiB is the latter |
| 22:58 | <@ToxicFrog> | Aha. |
| 22:59 | <@ToxicFrog> | I'm not sure what it was in GB(2), apart from "not enough" |
| 23:00 | <@Vornicus> | 521.36 GiB |
| 23:01 | <@ToxicFrog> | That's odd. My svn repo appears to have vanished. |
| 23:01 | | Ev3 [~Shemhazai@Nightstar-8502.ds1-ba.adsl.cybercity.dk] has quit [Connection reset by peer] |
| 23:02 | | Ev3 [~Shemhazai@Nightstar-8502.ds1-ba.adsl.cybercity.dk] has joined #Code |
| 23:05 | <@ToxicFrog> | Oh, wait. |
| 23:05 | <@ToxicFrog> | I'm looking on the wrong LV. |
| 23:05 | <@ToxicFrog> | Oopsies. |
| 23:06 | | You're now known as TheWatcher[T-2] |
| 23:08 | <@Vornicus> | heh |
| 23:10 | | You're now known as TheWatcher[zZzZ] |
| 23:13 | <@ToxicFrog> | Awesome. |
| 23:13 | <@ToxicFrog> | I SSHed in halfway through the copy of my old home directory onto the RAID, and it must have copied over ~/.ssh, because it did a key login rather than a keyboard-interactive one. |
| 23:32 | <@ToxicFrog> | Aaaaugh. |
| 23:32 | <@ToxicFrog> | This is going to take hours and hours (and hours). |
| 23:32 | <@Mahal> | Oops. |
| 23:32 | <@Mahal> | :( |
| 23:32 | <@ToxicFrog> | No oops, I just have to move a few hundred gigabytes of data around. |
| 23:33 | <@ToxicFrog> | And having SCSI drives that can talk 80MBps doesn't really help when the data is always coming off of, or going on to, ATA drives. |
| 23:37 | <@ToxicFrog> | I figure that minimum is moving ~100GB off the LVM, pvmove'ing /dev/hda4, then recreating /dev/hda as a single PV, adding it back to the VG, and moving most of that 100GB back. |
| 23:37 | <@ToxicFrog> | (the music is staying on the RAID, tho~) |
| 23:50 | | Chalcedon is now known as ChalcyFood |
| --- Log closed Wed Sep 27 00:00:03 2006 |