| 01:11.10 | macnewbold | g'night, all |
| 01:33.20 | *** join/#uphpu bigdog_ut (~bigdog_ut@166.70.192.70) |
| 01:33.21 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 01:39.30 | *** join/#uphpu bigdog_ut (~bigdog_ut@166.70.192.70) |
| 01:39.30 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 01:56.16 | *** join/#uphpu tbye (~tbye@69.27.4.131) |
| 02:06.40 | *** join/#uphpu wps (~wps@208.186.134.102) |
| 02:06.44 | *** mode/#uphpu [+o wps] by ChanServ |
| 03:26.13 | bigdog_ut | all hail the bigdog |
| 03:26.38 | bigdog_ut | ~slap macnewbold |
| 03:26.40 | jbot | ACTION slaps macnewbold, keep your grubby fingers to yourself! |
| 03:30.01 | dataw0lf | ~hail bigdog_ut |
| 03:30.05 | jbot | ACTION bows down to bigdog_ut and chants, "I'M NOT WORTHY!!" |
| 03:31.13 | bigdog_ut | whatz up bro? |
| 03:36.51 | dataw0lf | sup. |
| 03:37.11 | bigdog_ut | u connected to xmission via dsl? |
| 03:37.18 | dataw0lf | I'm currently drinking a gin and tonic and learning gimp |
| 03:37.23 | dataw0lf | yes indeed. |
| 03:37.43 | bigdog_ut | man i have been trying to get this actionsh*t to work right |
| 03:38.06 | bigdog_ut | i have the dns set up right i just cant get my ims to work right |
| 03:39.40 | dataw0lf | ah, I've had the same problem before on my actiontec. |
| 03:40.02 | bigdog_ut | any advice...besides throwing it away |
| 03:40.09 | dataw0lf | what are your dns name servers set as? |
| 03:40.58 | dataw0lf | for some reason, with the actiontec, it'll set your domain server (on linux anyways) as the actiontec itself. |
| 03:40.58 | bigdog_ut | 198.60.22.22 |
| 03:41.17 | bigdog_ut | do i need to set the domain |
| 03:41.48 | dataw0lf | nah, shouldn't have to, let me look at my router config, I know I fixed it somehow. |
| 03:44.08 | dataw0lf | you sure your router isn't set in there in DNS ? |
| 03:44.25 | bigdog_ut | what do you mean? |
| 03:44.33 | dataw0lf | the router ip as DNS. |
| 03:44.53 | bigdog_ut | i did have it in there |
| 03:45.05 | dataw0lf | remove it. |
| 03:45.41 | bigdog_ut | yeah i just have the 198.60.22.22,2 as the dns servers |
| 03:46.09 | dataw0lf | oh, bleh, sorry, apparently I've had too much to drink. |
| 03:46.12 | dataw0lf | yeah, you're going to have to change that. |
| 03:46.22 | bigdog_ut | add the router to the dns list? |
| 03:46.30 | dataw0lf | no, no. |
| 03:46.56 | dataw0lf | as long as the router isn't in there anymore it shouldn't be a problem, bleh. |
| 03:47.02 | dataw0lf | http://ubuntuforums.org/archive/index.php/t-5483.html |
| 03:47.07 | dataw0lf | ^-- same problem I had. |
| 03:47.08 | *** join/#uphpu mindjuju (user@207.173.210.167) |
| 03:47.27 | dataw0lf | try pinging login.oscar.aol.com |
| 03:47.42 | dataw0lf | (if you have AIM) |
| 03:47.49 | dataw0lf | and then try connecting through AIM. |
| 03:47.57 | bigdog_ut | i can ping it fine |
| 03:48.19 | dataw0lf | you've pinged it before, and then tried connecting to IM after you've pinged it? |
| 03:48.39 | bigdog_ut | no but i pinged it and now it works |
| 03:48.40 | bigdog_ut | lol |
| 03:48.52 | bigdog_ut | i did not change any settings in my actiontec |
| 03:48.53 | bigdog_ut | lol |
| 03:49.07 | dataw0lf | I know. |
| 03:49.08 | bigdog_ut | let me check yahoo |
| 03:49.09 | dataw0lf | weird, huh? |
| 03:49.13 | dataw0lf | same thing I had to do. |
| 03:49.43 | bigdog_ut | hwat is your time on your ping to scs.msg.yahoo.com? |
| 03:50.22 | dataw0lf | quick enough, 100ms or so. |
| 03:50.31 | bigdog_ut | lol...now that works |
| 03:50.53 | dataw0lf | yeah, seriously, have you tried rebooting since removing the router from the DNS list? |
| 03:51.15 | bigdog_ut | yeah...not it is all working once i ping the stuff |
| 03:51.22 | bigdog_ut | and fast now |
| 03:51.39 | dataw0lf | yeah, I had to do that, but then I just removed the router from the DNS list and didn't have anymore problems. |
| 03:51.48 | dataw0lf | I might've done something to the router also, let me try to think. |
| 03:52.03 | bigdog_ut | it works fine now |
| 03:52.32 | dataw0lf | yeah, but it'll come back. |
| 03:52.42 | dataw0lf | like, when you logout, and log back in, you'll have to ping em again to get em working. |
| 03:52.55 | bigdog_ut | so where in the router do i remove the dns entry |
| 03:53.22 | dataw0lf | I mean in Linux. |
| 03:53.50 | bigdog_ut | yeah i dont do dhcp at all w/ these things so i my dns are set in my /etc/resolv.conf |
| 03:54.10 | dataw0lf | right. |
| 03:54.27 | dataw0lf | as long as your router isn't a namserver setting in resolv.conf you should be straight from now on. |
| 03:54.47 | bigdog_ut | cool..that was my problem...i let it there from my last one |
| 03:54.49 | bigdog_ut | lol |
| 03:54.53 | bigdog_ut | thing sucks |
| 03:55.14 | bigdog_ut | i even telneted to the modem and reset the iptables and that did not work |
| 03:56.24 | dataw0lf | yeah, I know. |
| 03:56.38 | dataw0lf | I've been hacking around with it though, since it runs a linux kernel on it. |
| 03:56.46 | dataw0lf | I had the same problem, man, I was weirded out. |
| 03:57.31 | bigdog_ut | dude i was about ready to drop xmission cause i could not get out of the network |
| 03:57.31 | bigdog_ut | i called like 5 times to see and they said nothing about it |
| 03:57.43 | dataw0lf | hehe. |
| 03:57.55 | dataw0lf | X-Mission is pretty cool. It's just the craptiontec. |
| 03:57.56 | bigdog_ut | you saw me in there...dude i was pissed |
| 03:58.12 | bigdog_ut | yeah...but i would think they know that this is happening |
| 03:58.50 | dataw0lf | yeah, some of their tech support guys aren't all they should be, imho. |
| 03:59.11 | bigdog_ut | yeah i talked to a couple of them..now my email works!!! |
| 03:59.18 | bigdog_ut | ~hail dataw0lf |
| 03:59.20 | jbot | ACTION bows down to dataw0lf and chants, "I'M NOT WORTHY!!" |
| 03:59.22 | bigdog_ut | dataw0lf++ |
| 03:59.41 | bigdog_ut | dude i love the xmission gentoo mirrors though |
| 04:00.12 | dataw0lf | yeah. |
| 04:00.21 | dataw0lf | they're big supporters of linux, which is win++. |
| 04:00.33 | bigdog_ut | oh yeah |
| 04:01.30 | dataw0lf | which I should set their ubuntu and debian mirrors up in my sources list, but I'm lazy. |
| 04:01.51 | bigdog_ut | lol |
| 04:01.57 | bigdog_ut | that was the first thing i did |
| 04:02.10 | dataw0lf | hehe |
| 04:02.15 | dataw0lf | you gentoo fan boy ;) |
| 04:02.35 | bigdog_ut | oh yeah |
| 04:02.42 | bigdog_ut | gentoo rockz bro |
| 04:02.49 | bigdog_ut | gentoo++ |
| 04:03.00 | dataw0lf | psh, I'll stick with Debian / Ubuntu, and FreeBSD on rare occasions. |
| 04:03.33 | dataw0lf | you going to stick a personal server on your DSL connection? |
| 04:03.47 | bigdog_ut | i want to..have you |
| 04:04.05 | dataw0lf | yeah, that's what dataw0lf.org runs on. |
| 04:04.28 | bigdog_ut | how did you set it up? i havent look yet though |
| 04:04.42 | bigdog_ut | spent all time trying to get stuff to work |
| 04:05.17 | dataw0lf | as far as name servers, etc are concerned? |
| 04:05.59 | dataw0lf | I use afraid.org's name servers to point to my machine. |
| 04:06.11 | dataw0lf | and then I got the xmission guys to do some reverse dns magics on me. |
| 04:06.52 | bigdog_ut | oh...how do you get past the craptiontec |
| 04:06.54 | dataw0lf | I don't believe in running BIND. |
| 04:07.04 | dataw0lf | oh, just port forwarding. |
| 04:07.22 | dataw0lf | uses NAT, and then I have some iptables setup on my server to filter stuff out too. |
| 04:07.54 | bigdog_ut | oh okay...i will have to check this comming weekend |
| 04:08.03 | bigdog_ut | i might be asking some questions |
| 04:08.14 | dataw0lf | no problemo. |
| 04:08.41 | dataw0lf | eh, I think my relationship is quickly deteriorating into a no save situation. |
| 04:08.48 | bigdog_ut | lol |
| 04:09.19 | mindjuju | about that name server you guys were mentioning, did ya'll find any sites on the ins and outs of creating a domain name server? |
| 04:11.54 | dataw0lf | as far as what, running BIND? |
| 04:12.39 | dataw0lf | I'd direct any BIND questions to tierra or eco. |
| 04:13.09 | mindjuju | truth told, don't know much about creating a domain name server, have a public IP and have a domain through Godaddy.com, but have to forward the URL requests to my IP address cause I don't have a domain name server to connect it to |
| 04:13.29 | dataw0lf | afraid.org, mindjuju |
| 04:13.33 | dataw0lf | easy setup. |
| 04:13.39 | mindjuju | one of those projects I wanted to do when I have time; problem is no time, but when I saw you guys mention ... cool, thnx! |
| 04:14.15 | dataw0lf | no problemo. |
| 04:22.20 | bigdog_ut | mindjuju, setting up a dns server sucks...unless you really want to do that i would not recommend it |
| 04:22.48 | dataw0lf | there's really no need for a personal server, imho. |
| 04:22.54 | mindjuju | well, wanted to learn more of the gritty side of the web (what makes everything work) |
| 04:23.06 | mindjuju | not sure if I want to use a dynamic dns |
| 04:23.16 | dataw0lf | well, maybe you should run bind then. |
| 04:23.26 | bigdog_ut | yeah i would say go ahead and try..i ran one a couple years back |
| 04:23.27 | mindjuju | if the cost isn't crazy, i think i still might try to set something up |
| 04:23.30 | mindjuju | what is BIND? |
| 04:23.47 | bigdog_ut | bind is hte nameserver software |
| 04:28.57 | mindjuju | hey, that's exactly the info I was looking for. may not be easy but good info to know |
| 04:29.30 | bigdog_ut | if you really want to know bind i would suggest getting the bind book from oreilly |
| 04:29.33 | bigdog_ut | it is good |
| 04:49.15 | *** part/#uphpu mindjuju (user@207.173.210.167) |
| 07:55.46 | *** join/#uphpu tierra|h (~tierra@c-24-10-173-249.client.comcast.net) |
| 13:16.14 | *** join/#uphpu wps (~wps@208.186.134.102) |
| 13:16.24 | *** mode/#uphpu [+o wps] by ChanServ |
| 14:21.54 | *** join/#uphpu wps (~wps@208.186.134.102) |
| 14:28.01 | *** join/#uphpu bigdog_ut (~bigdog_ut@166.70.34.182) |
| 14:28.01 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 15:14.26 | *** join/#uphpu wps (~wps@71.32.228.158) |
| 15:14.29 | *** mode/#uphpu [+o wps] by ChanServ |
| 15:48.05 | *** join/#uphpu drewbono (~andrew@c-24-2-90-131.client.comcast.net) |
| 16:00.42 | *** join/#uphpu optikal (~optikal@67-40-118-81.slkc.uswest.net) |
| 16:05.36 | optikal | can anyone here host a 230mb file for me and a friend? its his tribes:vegenance showoff video, and we need a fourth mirror.. it will probably take up some bandwidth.. |
| 16:09.49 | optikal | well, if anyone wants to DL it.. http://optikal.org/~doubt/denied.wmv If you can rehost it, it would be greatly appreciated. =) |
| 16:13.59 | bigdog_ut | anyone here really good at postgresql? |
| 16:19.36 | optikal | Talk to the dw. |
| 16:20.02 | optikal | He knows Postgresql |
| 16:21.27 | bigdog_ut | dataw0lf, you awake...you had a fun night lastnight |
| 16:24.05 | macnewbold | optikal: is it work safe? |
| 16:24.14 | optikal | macnewbold: yep |
| 16:24.36 | optikal | macnewbold: its a recording of him playing and pulling off a ton of insanely cool kills in tribes:vegenance |
| 16:24.43 | macnewbold | I might be able to throw it on my home server, I've got plenty of avail BW on there. |
| 16:24.49 | macnewbold | cool |
| 16:24.52 | optikal | awesome! |
| 16:24.59 | optikal | what speed? |
| 16:25.08 | macnewbold | it's almost 1Mbps up |
| 16:25.16 | optikal | ok |
| 16:25.22 | macnewbold | over half-T1 speed (which we have at the office) |
| 16:25.48 | macnewbold | it is just for http, or are you doing torrent or something? |
| 16:25.57 | optikal | http |
| 16:26.14 | optikal | but it got linked to on a t:v German front page news site.. but i think the main dl surges are done |
| 16:26.45 | optikal | over 1 day, we've sent about 750gb out. lol |
| 17:05.46 | *** join/#uphpu fungus (~fungus@firebat.aros.net) |
| 17:21.39 | *** join/#uphpu alphahawk (~alphahawk@70.56.105.158) |
| 17:25.53 | alphahawk | How is everyone today? |
| 17:26.00 | macnewbold | :) |
| 17:26.04 | macnewbold | ~dance |
| 17:26.05 | jbot | ACTION does a disco dance. |
| 17:26.28 | macnewbold | it's not Monday anymore, so I'm doing better than yesterday :) |
| 17:27.25 | alphahawk | WOOOHOOOO!!!! |
| 17:27.53 | alphahawk | hey macnewbold still working on a issue with file uploads wondering if you can shed some light for me. |
| 17:28.43 | alphahawk | From what I have been able to track down is that if the php/apache cannot detect the mime type of the file it freaks out. I.E. I upload a prn file (print to file). |
| 17:30.04 | alphahawk | do you know of a way to make the system ignore the mime type?? All the documentation I have read says it ignores the file mimetypes but it doesn't from what Ican see |
| 17:39.44 | macnewbold | alphahawk: no idea. I've got a site that uploads _all_ kinds of files, and we don't have that problem at all |
| 17:39.50 | macnewbold | what versions of apache/php are you using? |
| 17:41.04 | alphahawk | Apache/1.3.31 (Unix) PHP/4.3.9 |
| 17:43.21 | macnewbold | I'm on apache2, with about the same version of PHP |
| 17:43.33 | macnewbold | so I don't know if apache2 makes a difference in this case or not |
| 17:45.06 | alphahawk | hmmm ok |
| 17:46.10 | *** join/#uphpu jakea (~jakea@byu147137wks.byu.edu) |
| 17:46.12 | macnewbold | optikal: denied.wmv is downloading right now... looks like it will take about 25 minutes to arrive |
| 17:46.21 | optikal | macnewbold: cool |
| 17:46.24 | macnewbold | you'll find it at http://www.mne-llc.com/denied.wmv when it's done |
| 17:50.35 | macnewbold | I get about 20GB per month through XM, so if it starts to go over that, I'll have to take it down :) (or is it 20Gb? don't recall, but I think the larger one) |
| 18:01.42 | optikal | hehe.. it should be fine, its settled down a whole lone |
| 18:01.45 | optikal | s/lone/lot |
| 18:05.04 | macnewbold | optikal: 7 minutes left |
| 18:05.17 | optikal | cool |
| 18:06.02 | optikal | hmm |
| 18:06.06 | optikal | [Tue Mar 01 12:49:52 2005] [error] [client 67.40.118.81] client denied by server configuration: /usr/bin/wwwroot |
| 18:06.10 | optikal | this error.. |
| 18:06.33 | optikal | there is no /usr/bin/wwwroot.. i installed awstats, and i get this error when accessing it.. so i can only assume its that doing it.. |
| 18:06.47 | optikal | apache2.conf and commonapache2.conf dont reference any /usr/bin/wwwroot, or anything close |
| 18:06.52 | optikal | and neither does the awstats.hostname.conf file.. |
| 18:06.59 | optikal | what file am i missing to check> |
| 18:07.01 | optikal | *? |
| 18:16.46 | macnewbold | optikal: I think it's got to be some other awstats config file... I've never used it, so I don't know exactly what it would be |
| 18:17.15 | optikal | aah |
| 18:17.16 | optikal | ok |
| 18:18.51 | macnewbold | btw, optikal, it finished downloading |
| 18:18.53 | macnewbold | > ls denied.wmv |
| 18:18.53 | macnewbold | -rw-rw-r-- 1 newbold www 239416672 Feb 26 23:51 denied.wmv |
| 18:19.16 | optikal | cool |
| 18:19.16 | macnewbold | (md5ing it takes a while on my old computer :) |
| 18:19.21 | macnewbold | MD5 (denied.wmv) = 422e8782eba597ca9134ef6018359b00 |
| 18:19.23 | optikal | hah |
| 18:19.32 | macnewbold | does that look right? |
| 18:20.00 | optikal | yep |
| 18:22.24 | macnewbold | somebody from 70.56.105.158 tried to hit it a while ago, but only got 6 megs :) |
| 18:26.18 | optikal | hehe |
| 18:27.15 | optikal | ive got 4 sending from my box atm.. some fast speeds going out, 4.7Mb/s |
| 18:28.39 | *** join/#uphpu fungus (~fungus@firebat.aros.net) |
| 18:33.03 | macnewbold | what's the uplink on your box optikal? |
| 18:33.07 | macnewbold | and how? |
| 18:33.15 | optikal | macnewbold: haha. |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.37 | optikal | <PROTECTED> |
| 18:33.39 | optikal | <PROTECTED> |
| 18:33.41 | optikal | <PROTECTED> |
| 18:33.43 | optikal | <PROTECTED> |
| 18:33.45 | optikal | <PROTECTED> |
| 18:34.24 | macnewbold | where at? |
| 18:34.32 | optikal | a uml, linode.com |
| 18:34.36 | macnewbold | ah |
| 18:34.39 | macnewbold | makes sense now :) |
| 18:34.50 | optikal | ;) |
| 18:34.56 | macnewbold | how much BW do you get to use with your hosting pkg, and how much does it gost? |
| 18:34.58 | optikal | Ive seen 8.2Mb/s |
| 18:34.58 | macnewbold | cost? |
| 18:35.14 | optikal | http://www.linode.com/products/linodes.cfm |
| 18:36.14 | macnewbold | I'm pulling it to my coloc'd server at XMission now.. getting over 1Mbps |
| 18:36.23 | macnewbold | sorry 1MB/s |
| 18:36.27 | macnewbold | 8Mbps |
| 18:36.47 | optikal | which one? |
| 18:36.49 | macnewbold | 1.15MB/s currently (9.2Mbps) |
| 18:36.50 | optikal | lol |
| 18:37.14 | optikal | nice |
| 18:37.19 | macnewbold | it's leveled off now at 1.17MB/s |
| 18:37.23 | optikal | so it peaked @ 9.2? |
| 18:37.40 | macnewbold | 9.36Mbps |
| 18:37.47 | optikal | nice |
| 18:38.40 | macnewbold | about 3 minutes to dl the whole 240MB file :) |
| 18:38.47 | macnewbold | 15 sec left :) |
| 18:39.12 | optikal | nice |
| 18:39.16 | macnewbold | 3 minutes and 14 seconds total |
| 18:39.24 | optikal | not too shabby for 228MB |
| 18:39.31 | optikal | =) |
| 18:39.35 | macnewbold | too bad we don't have the bw avail to let people download it from there :) |
| 18:39.42 | optikal | hehe |
| 18:45.13 | synic | bigdog_ut: you there? |
| 18:48.41 | macnewbold | so optikal, did that mne-llc link get posted anywhere as a mirror? Everybody who wanted to see it already got it, it looks like :) |
| 18:49.35 | optikal | not yet |
| 18:49.40 | optikal | its incase i run out of banwidth on my linode |
| 19:19.00 | *** join/#uphpu drip (~scoobmast@216.250.76.190) |
| 19:28.23 | bigdog_ut | synic, whatz up? |
| 19:33.24 | bigdog_ut | ~slap synic |
| 19:33.27 | jbot | ACTION slaps synic, keep your grubby fingers to yourself! |
| 19:54.54 | *** join/#uphpu alphahawk (~alphahawk@70.56.105.158) |
| 19:56.29 | dataw0lf | somebody say my name? |
| 19:57.19 | optikal | yeah |
| 19:57.32 | optikal | bigdog_ut, needed some help with postgresql |
| 19:57.40 | optikal | i recommended he speak to you. |
| 19:57.47 | optikal | i dono if he still does.. |
| 19:58.07 | optikal | @bigdog_ut anyone here really good at postgresql? |
| 19:58.08 | optikal | optikal Talk to the dw. |
| 19:58.09 | optikal | optikal He knows Postgresql |
| 19:58.09 | optikal | @bigdog_ut dataw0lf, you awake...you had a fun night lastnight |
| 19:58.34 | dataw0lf | yeah, I know pg. And, yes, I did have a fun night last night. |
| 20:06.12 | *** join/#uphpu tierra|w (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 20:12.01 | *** join/#uphpu wps (~wps@71.32.228.158) |
| 20:12.11 | *** mode/#uphpu [+o wps] by ChanServ |
| 20:27.49 | bigdog_ut | dataw0lf, are you familiar with multi arrays in pg and how to use them in stored procs |
| 20:30.18 | dataw0lf | in theory, yes, but I haven't actually used them to be honest. |
| 20:30.26 | bigdog_ut | okay |
| 20:31.04 | bigdog_ut | im just trying to figure out how to count an array in plpgsql |
| 20:32.53 | dataw0lf | array_dims(), I think. |
| 20:33.26 | bigdog_ut | that gives you the dimensions of the array |
| 20:34.37 | dataw0lf | it'll give you the number of values, which is what I assume you're looking for? |
| 20:34.56 | bigdog_ut | it gives the range of values...so [1:n] |
| 20:35.14 | bigdog_ut | i guess i could parse it out |
| 20:37.22 | bigdog_ut | oh i got i |
| 20:37.25 | bigdog_ut | it |
| 20:37.35 | dataw0lf | ? |
| 20:37.37 | bigdog_ut | i did a while loop to solve |
| 20:37.43 | bigdog_ut | check this out |
| 20:37.50 | dataw0lf | lemme see, lemme see! |
| 20:37.51 | dataw0lf | ;) |
| 20:37.52 | bigdog_ut | CREATE OR REPLACE FUNCTION update_user_sports(VARCHAR,_int4,_int4,_int4,_int4) RETURNS BOOLEAN AS' |
| 20:37.52 | bigdog_ut | DECLARE |
| 20:37.52 | bigdog_ut | <PROTECTED> |
| 20:37.52 | bigdog_ut | <PROTECTED> |
| 20:37.52 | bigdog_ut | <PROTECTED> |
| 20:37.53 | bigdog_ut | <PROTECTED> |
| 20:37.55 | bigdog_ut | <PROTECTED> |
| 20:37.59 | bigdog_ut | <PROTECTED> |
| 20:38.01 | bigdog_ut | <PROTECTED> |
| 20:38.03 | bigdog_ut | <PROTECTED> |
| 20:38.05 | bigdog_ut | <PROTECTED> |
| 20:38.09 | bigdog_ut | <PROTECTED> |
| 20:38.11 | bigdog_ut | BEGIN |
| 20:38.13 | bigdog_ut | <PROTECTED> |
| 20:38.15 | bigdog_ut | <PROTECTED> |
| 20:38.17 | bigdog_ut | <PROTECTED> |
| 20:38.19 | bigdog_ut | <PROTECTED> |
| 20:38.21 | bigdog_ut | <PROTECTED> |
| 20:38.23 | bigdog_ut | <PROTECTED> |
| 20:38.25 | bigdog_ut | <PROTECTED> |
| 20:38.28 | bigdog_ut | <PROTECTED> |
| 20:38.30 | bigdog_ut | <PROTECTED> |
| 20:38.32 | bigdog_ut | <PROTECTED> |
| 20:38.34 | bigdog_ut | END; |
| 20:38.36 | bigdog_ut | ' LANGUAGE 'plpgsql'; |
| 20:38.40 | bigdog_ut | takes multi arrays and then i will use that to create updates where the raise notice is at |
| 20:38.43 | dataw0lf | hoho |
| 20:38.54 | dataw0lf | that's slick. |
| 20:38.59 | bigdog_ut | so one query to postgres from php will create many queries all in a transaction |
| 20:39.13 | dataw0lf | man, and people wonder why I love postgres. |
| 20:39.13 | bigdog_ut | here is the select statement: |
| 20:39.25 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 20:39.31 | bigdog_ut | select update_user_sports('username','{30,29}','{1,5}','{2,1}','{3,2}'); |
| 20:39.59 | bigdog_ut | so i pass in data via that query and all the values get created to sql statements |
| 20:40.16 | bigdog_ut | on db query results in up to 75 queries all in a transaction |
| 20:40.20 | bigdog_ut | one fails it all fails |
| 20:40.43 | bigdog_ut | and it is so fast |
| 20:41.08 | dataw0lf | hehe. |
| 20:41.38 | bigdog_ut | i love doing this stuff now |
| 20:41.55 | bigdog_ut | cause in php it would suck to requery and verify and ....blah..blah |
| 20:42.10 | bigdog_ut | now i just do all the queries in that a stored proc |
| 20:42.24 | dataw0lf | that's definitely slick. |
| 20:42.56 | bigdog_ut | yeah i have been learing alot about it you can do so killer stuff with it |
| 20:43.25 | bigdog_ut | this site is going to be killer |
| 20:43.35 | bigdog_ut | i have integrated jabber into it as a chat method |
| 20:43.40 | dataw0lf | wow. |
| 20:43.48 | dataw0lf | you got a dev url ? |
| 20:44.10 | bigdog_ut | it is not done yet...but we will shortly...wps and i are working on it |
| 20:44.22 | dataw0lf | sweet. |
| 20:44.51 | bigdog_ut | i think i have like 12 plpsql functions now that do some killer stuff |
| 20:45.09 | bigdog_ut | triggers, views, domains, and rules... |
| 20:45.17 | bigdog_ut | why would you not want to use pgsql |
| 20:45.32 | bigdog_ut | oh i remember...cause they cant handle the truth |
| 20:46.04 | dataw0lf | hehe. |
| 20:46.07 | dataw0lf | views ROCK. |
| 20:46.12 | dataw0lf | so do triggers. |
| 20:46.20 | dataw0lf | I used them so much at my last job. |
| 20:58.54 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 21:06.55 | synic | bigdog_ut: sorry, I figured my question out |
| 21:07.06 | synic | which, funnily enough, had to do with pgsql |
| 21:32.24 | *** join/#uphpu tbye (~tbye@69.27.4.131) |
| 21:39.23 | drewbono | Anyone know if there's blogging software that allows people to receive updates to the blog over email? |
| 21:41.21 | drewbono | Similar to having a subscriber? |
| 22:03.52 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 22:09.51 | bigdog_ut | blog w/ rss? |
| 22:10.26 | dataw0lf | well, that'd be rather easy, with a trigger, too. |
| 22:11.21 | bigdog_ut | yes it would |
| 22:12.37 | dataw0lf | that's how I'd do it. With an insert, trigger an email to X members who are 'subscribed' |
| 22:14.52 | bigdog_ut | the only problem is that they use mysql...stupid developers |
| 22:15.10 | bigdog_ut | we should create a postgresql hosting company |
| 22:15.22 | dataw0lf | I'm down. |
| 22:15.30 | macnewbold | who needs a DB trigger when you're running the whole thing with PHP? Just do it in the PHP. |
| 22:15.46 | macnewbold | sending email doesn't belong in a RDBMS insert trigger anyway, IMHO |
| 22:15.48 | bigdog_ut | why...then you have to make tons of php calls |
| 22:15.57 | macnewbold | what, mail()? ;) |
| 22:16.29 | dataw0lf | I don't see why not to keep it in the DB. |
| 22:16.32 | macnewbold | you could get your subscriber list in a single query I bet |
| 22:16.36 | dataw0lf | if you want, I guess you could call a php script with the trigger. |
| 22:16.41 | macnewbold | what does sending email have to do with the db? |
| 22:16.52 | macnewbold | why put a trigger _in_ the db, just so it can call back out again? |
| 22:16.57 | bigdog_ut | cause it sends when a blog is updated |
| 22:17.12 | macnewbold | if the PHP is inserting, then PHP can more easily do the work |
| 22:17.16 | dataw0lf | whenever an insert comes across that specific table, you'll auto send it. |
| 22:17.34 | bigdog_ut | and you can also check stats in the database before sending the email |
| 22:17.40 | bigdog_ut | like is the user subscribed |
| 22:17.49 | macnewbold | all those things are easy to check from PHP too |
| 22:18.04 | macnewbold | and it works well with MySQL, and doesn't require PG :) |
| 22:18.04 | bigdog_ut | yeah but it depends on how many calls you want to make to the db |
| 22:18.26 | bigdog_ut | it depends where you want your bl to be |
| 22:18.29 | macnewbold | you just need one query, and it can return all the rows of subscribers |
| 22:18.54 | bigdog_ut | one query to insert and one query to select subscribers |
| 22:19.01 | bigdog_ut | 2 queries |
| 22:19.08 | macnewbold | yeah, but you'd need the insert either way |
| 22:19.20 | bigdog_ut | yeah but in the database you have only one query |
| 22:19.25 | macnewbold | the trigger internally will do one or more queries to get the subscribers anyway |
| 22:19.37 | bigdog_ut | queries yes connections no |
| 22:19.54 | macnewbold | calling out to send the email is likely to be just as expensive as calling in to get the subscriber list, or worse |
| 22:20.11 | macnewbold | you only need one connection for both queries, and you'd need it even with the trigger |
| 22:20.15 | bigdog_ut | depends, it would not be worse though |
| 22:20.35 | macnewbold | if it has to spawn a new process to send each message, then yeah, it easily could be |
| 22:20.37 | bigdog_ut | w/ trigger you dont need connections you are in the current connection |
| 22:20.44 | macnewbold | same with PHP |
| 22:20.54 | macnewbold | both queries [can] use the same connection, |
| 22:20.59 | macnewbold | at least with MySQL they can |
| 22:21.14 | macnewbold | they're persistent cnxns |
| 22:21.16 | dataw0lf | I just don't see the reason to do something in PHP when you can do some nifty DB work. |
| 22:21.25 | macnewbold | 1) easier to do it in php |
| 22:21.28 | bigdog_ut | yes, but you do not need to hit the server via network |
| 22:21.29 | macnewbold | 2) less error prone |
| 22:21.33 | dataw0lf | Obviously, if he's using MySQL and hasn't learned enough SQL to do it, do it in php. |
| 22:21.43 | macnewbold | 3) doesn't place unnecessary requirements on db engines |
| 22:21.55 | macnewbold | 4) more handy stuff avail. in php to do it |
| 22:22.07 | macnewbold | 5) php may be higher performing |
| 22:22.10 | bigdog_ut | we are just saying it is just as easy as php if you know what you are doing |
| 22:22.20 | macnewbold | that's very possible |
| 22:22.24 | bigdog_ut | 5? i would not say that |
| 22:22.36 | macnewbold | I bet a lot more people know what they're doing with PHP than PG db triggers :) |
| 22:22.47 | dataw0lf | you're totally forgetting the cool factor though. |
| 22:22.48 | bigdog_ut | yeah...that is what we are saying though |
| 22:22.51 | macnewbold | 5 depends a lot on how the callout from the trigger to send the email is implemented |
| 22:23.04 | bigdog_ut | through c most likely |
| 22:23.19 | macnewbold | dataw0lf: yeah, but does the cool factor outweigh the weird and bizarre factors? |
| 22:23.34 | dataw0lf | Of course. |
| 22:23.47 | bigdog_ut | the nice thing is that i can modify my trigger and db without touching my php code |
| 22:24.20 | dataw0lf | and it just looks cleaner. |
| 22:25.08 | macnewbold | the nice thing is that I can modify my php code without touching my db :) |
| 22:25.33 | bigdog_ut | true...either way you look at it it depends where you want the bl at |
| 22:25.37 | macnewbold | anyway, I surrender :) |
| 22:25.40 | macnewbold | bl? |
| 22:25.41 | macnewbold | ~bl |
| 22:25.42 | jbot | hmm... bl is http://cvs.handhelds.org/cgi-bin/viewcvs.cgi/apps/h3600_test/bl.c |
| 22:25.48 | bigdog_ut | business logic |
| 22:25.50 | macnewbold | ah |
| 22:25.52 | macnewbold | yeah |
| 22:26.11 | macnewbold | in the db is good if you've got a php front end, a java front end, a <your favorite here> front end |
| 22:26.13 | bigdog_ut | i can do queries in sql then in php |
| 22:26.15 | macnewbold | so they all get the same stuff |
| 22:26.29 | macnewbold | but if you've got exactly one front end, |
| 22:26.38 | macnewbold | the right place to draw the line is pretty arbitrary :) |
| 22:26.57 | bigdog_ut | also it depends on what you are doing too |
| 22:27.19 | bigdog_ut | i tend to shift more to sql cause it is easier to deal w/ then with php at times |
| 22:27.30 | macnewbold | I'd rather implement business logic in a real language than in an SQL database - _much_ better programming environment |
| 22:27.35 | macnewbold | yeah, it depends on what you're doing |
| 22:27.46 | dataw0lf | I just like doing cool stuff with pg. |
| 22:27.49 | dataw0lf | *shrug* |
| 22:28.08 | macnewbold | I might too, once I install and start using it :) |
| 22:28.20 | dataw0lf | sure, it might be easier to maintain, read, portable, etc if you do it in PHP, but I'm down for doing the sweet stuff. |
| 22:28.43 | bigdog_ut | the problem that i have with php is that it lacks in oo stuff like ruby, java, or pythong |
| 22:29.19 | dataw0lf | yeah, which I can't speak too much on, since I haven't really done much work with PHP 5. |
| 22:29.21 | bigdog_ut | i wish php would really move forward w/ their oo engine |
| 22:29.27 | dataw0lf | but, it still isn't a true OOP language like, say, Python. |
| 22:29.35 | bigdog_ut | or ruby |
| 22:29.41 | dataw0lf | yeah, Ruby is nice too. |
| 22:29.45 | bigdog_ut | php is moving forward which is good |
| 22:29.48 | dataw0lf | haven't done too much with it, just some scripts. |
| 22:34.00 | bigdog_ut | im just waiting for the day when php support function overloading |
| 22:37.47 | dataw0lf | that'd be very, very nice. |
| 22:38.45 | bigdog_ut | dataw0lf, thanks again for helping me with the craptiontec again |
| 22:42.21 | *** join/#uphpu drewbono (~andrew@c-24-2-90-131.client.comcast.net) |
| 22:47.05 | dataw0lf | bigdog_ut: no problem bro. |
| 23:19.33 | macnewbold | so what is the fix on the craptiontec's when they start doing that? |
| 23:20.38 | bigdog_ut | set the dns on the computers behind it to use a real dns and not the modem for the dns |
| 23:20.42 | macnewbold | ah |
| 23:33.10 | *** join/#uphpu wps_ (~wps@71.32.228.158) |
| 23:36.25 | *** join/#uphpu wps_ (~wps@71.32.228.158) |
| 23:41.15 | *** join/#uphpu wps_ (~wps@71.32.228.158) |
| 23:48.41 | macnewbold | wps/wps_: you're both logged in it says... and both from the same IP address |
| 23:49.14 | chuckybucky | how do I log the other out? |
| 23:49.29 | macnewbold | msg NickServ help ghost |
| 23:49.39 | macnewbold | msg NickServ ghost wps [password] |
| 23:49.47 | macnewbold | you should also do this: |
| 23:50.12 | macnewbold | msg NickServ link wps [password] |
| 23:50.23 | macnewbold | maybe also ths: |
| 23:50.34 | macnewbold | msg NickServ register wps_ [password] |
| 23:50.50 | macnewbold | chuckybucky: you still here? |
| 23:51.03 | *** mode/#uphpu [+o wps] by ChanServ |
| 23:51.03 | macnewbold | nice |
| 23:51.08 | wps | there |
| 23:51.10 | wps | sheesh |
| 23:51.19 | macnewbold | thos commands you'll need to run as wps_ I think |
| 23:51.30 | macnewbold | maybe not |
| 23:52.00 | wps | I don't want to register wps_ |
| 23:52.05 | wps | I don't want to use that |
| 23:54.49 | macnewbold | you may be able to set up your client to msg NickServ every time you log in, and kill the ghost, then /nick wps you |
| 23:55.09 | macnewbold | the bigger mystery is why your client keeps ghosting you. |
| 23:55.18 | macnewbold | how do you usually close your client? |
| 23:55.54 | wps | quit the app |
| 23:56.31 | macnewbold | hm |
| 23:56.44 | macnewbold | I wonder why it doesn't /quit or /part you... |
| 23:56.56 | macnewbold | what app is it again? Colloquy? |
| 23:57.12 | macnewbold | or why it doesn't close the connection, like bigdog's did... |
| 23:58.02 | wps | does mine not do that? |
| 23:58.56 | macnewbold | I'm not sure... wanna try it? :) |
| 23:59.02 | wps | sure |