Re: [PLUG] Removing Duplicate Rows from SQL Dump

2011-08-15 Thread Neal
Try uniq: http://unixhelp.ed.ac.uk/CGI/man-cgi?uniq NealS ___ PLUG mailing list PLUG@lists.pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug

[PLUG] Removing Duplicate Rows from SQL Dump

2011-08-15 Thread Rich Shepard
My brain's stuck trying to figure out a way to automate removing duplicate (and triplicate) rows from a database table that's been exported as a .sql file. Here's the situation: The file has 12.5K rows of duplicate and triplicate data. These data have the same loc_name, sample_date, and para

[PLUG] Build a tarpit in perl...

2011-08-15 Thread Michael C. Robinson
#!/usr/bin/perl # # Purpose: Slow down the spammers by delaying the smtp transaction when # a recognized problem IP connects. use strict; use Net::PcapUtils; use NetPacket::Ethernet qw(:strip); use NetPacket::IP; use IPTables::IPv4::IPQueue; use Net::EasyTCP; Can someone explain why I

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread wes
On Mon, Aug 15, 2011 at 4:51 PM, Galen Seitz wrote: > wes wrote: > > yeah, I can't get that to work either. not sure why. so then my solution > > would be: > > > > touch blankfile; find -type f -exec cp blankfile {} \; > > Doesn't that count as UUOT? Why not use /dev/null? > > I didn't think tha

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread Galen Seitz
wes wrote: > yeah, I can't get that to work either. not sure why. so then my solution > would be: > > touch blankfile; find -type f -exec cp blankfile {} \; Doesn't that count as UUOT? Why not use /dev/null? -- Galen Seitz gal...@seitzassoc.com ___ P

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread wes
yeah, I can't get that to work either. not sure why. so then my solution would be: touch blankfile; find -type f -exec cp blankfile {} \; -wes On Mon, Aug 15, 2011 at 4:18 PM, Jameson Williams < jameson.h.willi...@intel.com> wrote: > That one doesn't work on my end. It echos (literally) lines l

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread Jameson Williams
That one doesn't work on my end. It echos (literally) lines like > filename instead of executing the above in bash. On 08/15/2011 04:15 PM, wes wrote: > My solution would have been: > > find -type f -exec echo "" \> {} \; > > -wes > > On Mon, Aug 15, 2011 at 3:48 PM, Jameson Williams< > jameso

[PLUG] Building an IP server in perl...

2011-08-15 Thread Michael C. Robinson
So far, I have a perl script that pulls the originating IP from email and another perl script that uses the file created by it to serve that information. Question is, should I implement an IP whitelist and if so, how do I do partial pattern matches? For example, 192.168. could represent private c

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread wes
My solution would have been: find -type f -exec echo "" \> {} \; -wes On Mon, Aug 15, 2011 at 3:48 PM, Jameson Williams < jameson.h.willi...@intel.com> wrote: > On 08/15/2011 03:47 PM, Sam Hart wrote: > > On Mon, Aug 15, 2011 at 6:22 PM, Jameson Williams > > wrote: > >> I haven't been able to

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread Jameson Williams
On 08/15/2011 03:47 PM, Sam Hart wrote: > On Mon, Aug 15, 2011 at 6:22 PM, Jameson Williams > wrote: >> I haven't been able to get this one yet. >> >> Challenge: A one-line statement (pipes okay, but explicit loops not) >> that empties all found files (as for debugging with /var/log, perse). >> >

Re: [PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread Sam Hart
On Mon, Aug 15, 2011 at 6:22 PM, Jameson Williams wrote: > I haven't been able to get this one yet. > > Challenge: A one-line statement (pipes okay, but explicit loops not) > that empties all found files (as for debugging with /var/log, perse). > > This is close, but has a loop: > >     find -type

[PLUG] One-liners to empty all files in a directory?

2011-08-15 Thread Jameson Williams
I haven't been able to get this one yet. Challenge: A one-line statement (pipes okay, but explicit loops not) that empties all found files (as for debugging with /var/log, perse). This is close, but has a loop: find -type f | while read file; do :>$file; done This seems like it might work

Re: [PLUG] Preferred rackmount server brands?

2011-08-15 Thread Russell Johnson
I've not had too many problems with any of the major manufactures in the 12 years I've been doing linux system administration. I've run servers from Dell, HP, IBM, Supermicro and DEC. I've run Redhat from RH 5.0 through RHEL 5. SuSE, Debian, Ubuntu, Yellowdog and derivitives. It's not that the

Re: [PLUG] Preferred rackmount server brands?

2011-08-15 Thread Tim Wescott
On Mon, 2011-08-15 at 12:16 -0700, plug...@martinconsulting.com wrote: > I need to buy a new rackmount server to run Linux. I want to stay away from > vendors who use proprietary hardware with difficult-to-find Linux drivers > (e.g. Dell, at least in the past). What brands do the fine folks at PL

Re: [PLUG] Preferred rackmount server brands?

2011-08-15 Thread Roderick A. Anderson
plug...@martinconsulting.com wrote: > I need to buy a new rackmount server to run Linux. I want to stay away from > vendors who use proprietary hardware with difficult-to-find Linux drivers > (e.g. Dell, at least in the past). What brands do the fine folks at PLUG > think I should consider? pogo

Re: [PLUG] Preferred rackmount server brands?

2011-08-15 Thread Paul Heinlein
On Mon, 15 Aug 2011, plug...@martinconsulting.com wrote: > I need to buy a new rackmount server to run Linux. I want to stay > away from vendors who use proprietary hardware with > difficult-to-find Linux drivers (e.g. Dell, at least in the past). > What brands do the fine folks at PLUG think

Re: [PLUG] Preferred rackmount server brands?

2011-08-15 Thread Matt McKenzie
It has been a while since I was involved directly with rackmount kit, but I seem to remember whitebox stuff such as SmithMicro worked well, if you weren't looking for the big ticket name brand stuff with support contracts etc. You could also try some of the vendors that specialize in Linux, such a

[PLUG] Preferred rackmount server brands?

2011-08-15 Thread plugng3
I need to buy a new rackmount server to run Linux. I want to stay away from vendors who use proprietary hardware with difficult-to-find Linux drivers (e.g. Dell, at least in the past). What brands do the fine folks at PLUG think I should consider? -Brian Martin ___

[PLUG] August PLUG AT Cancelled: Consider the Android Workgroup

2011-08-15 Thread Michael Dexter
Hello all, With the speaker unavailable and lots of roundtable activities at each meeting, I am cancelling the August PLUG Advanced Topics meeting and invite people to consider going to the Android Workgroup meeting mere blocks away at the Lucky Lab: http://calagator.org/events/1250461210 An