Re: [vox-tech] Converting to Kubuntu

2009-05-04 Thread David Hummel
On Sun, May 3, 2009 at 5:47 PM, Bob Scofield  wrote:
>
> Recently I had a bad experience with Debian.
> Because I detest KDE 4.x, I decided to switch from
> Debian testing to Debian 5.0 in order to freeze KDE at 3.5.  For some reason
> my HPLIP toolbox doesn't work.  But the big surprise is that this Debian
> stable release hangs every 5 or 6 boots.  It hangs where the startup messages
> state that the kernel modules are being loaded.

Take with a grain of salt.  This is most likely a mis-configuration or
hardware-specific issue.  I've had no problems with Debian 5.0 on 4
different systems.  I actually went back to Debian from Ubuntu since
it was starting to feel like Ubuntu was suffering from bloat and
feature creep...
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Blu-ray: How crazy would I be if...

2009-04-21 Thread David Hummel
On Tue, Apr 21, 2009 at 11:32 AM, Chris Jenks  wrote:
>
> Maybe I've been extremely unlucky, but I've found optical media to be
> extremely unreliable when the whole disk has to read perfectly. It may be
> OK to have a few frames missing from a movie, but even just yesterday I
> had to finish an Ubuntu install by hand because the desktop files were
> corrupted on the CD.

I would suspect a problem with your burner.  Also, you should verify
the integrity of the newly burned disc by comparing the contents to
the source data.  If you do this and use name-brand media (memorex,
maxell, tdk, sony, verbatim etc.), the contents should be reliable for
at least a few years barring any physical damage to the discs...
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Corrupted root files

2007-12-21 Thread David Hummel
On Dec 21, 2007 12:31 PM, Carl Boettiger <[EMAIL PROTECTED]> wrote:
> So, what is smartctl?

http://en.wikipedia.org/wiki/Self-Monitoring,_Analysis,_and_Reporting_Technology
http://smartmontools.sourceforge.net/

$ sudo aptitude install smartmontools
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Sandisk sansa view review (from a linux perspective)

2007-12-20 Thread David Hummel
On Dec 20, 2007 2:32 AM, Bill Broadley <[EMAIL PROTECTED]> wrote:
>
> > I'm partial to the iAudio stuff from Cowan, in large part because they're
>
> How does the Cowan interact with linux?  Via libmtp?

No.

> Just as a storage device?

Yes.

> Do the artist/album tags work?

Yes.

> Can you rate music on the cowan
> and sync it back to you library?

No.

> Playlists?  Album art?

Yes.

I can tell you that the Cowon iAudio players beat the Sandisk players
(and most other players, including iPods) hands-down in terms of sound
quality, plus many of them support FLAC (X5, U3, I7).  I'd recommend
the I7 and Sony MDR-EX90LP headphones.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] base-config is gone

2006-02-06 Thread David Hummel
On Mon, Feb 06, 2006 at 08:59:20AM -0800, Bob Scofield wrote:
> 
> 1)  Is there an easy way to add sources without base-config?

I suggest you take a look at the sources.list man page.
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Firefox File Associations

2006-01-12 Thread David Hummel
On Thu, Jan 12, 2006 at 12:40:37PM -0800, Bob Scofield wrote:
> 
> Firefox in my SuSE system will not bring up Microsoft Word documents
> in Open Office if I click on Word documents on a web page.  In my
> Debian system Firefox does bring Open Office up for Word documents.
> I'd like to fix Firefox in SuSE to do the same.
> 
> When I type "about:config" in the Firefox URL box I get all the
> configuration information, but I don't see what it is that I'm
> supposed to change to get Firefox to start Open Office.  

You should have entries like these in ~/.mailcap:

application/msword; oowriter2 '%s'; edit=oowriter2 '%s'; test=test "$DISPLAY" 
!= ""; nametemplate=%s.doc; description="Microsoft Word Document"
application/vnd.ms-word; oowriter2 '%s'; edit=oowriter2 '%s'; test=test 
"$DISPLAY" != ""; nametemplate=%s.doc; description="Microsoft Word Document"
application/msexcel; oocalc2 '%s'; edit=oocalc2 '%s'; test=test "$DISPLAY" != 
""; nametemplate=%s.xls; description="Microsoft Excel Document"
application/vnd.ms-excel; oocalc2 '%s'; edit=oocalc2 '%s'; test=test "$DISPLAY" 
!= ""; nametemplate=%s.xls; description="Microsoft Excel Document"
application/mspowerpoint; ooimpress2 '%s'; edit=ooimpress2 '%s'; test=test 
"$DISPLAY" != ""; nametemplate=%s.ppt; description="Microsoft PowerPoint 
Document"
application/vnd.ms-powerpoint; ooimpress2 '%s'; edit=ooimpress2 '%s'; test=test 
"$DISPLAY" != ""; nametemplate=%s.ppt; description="Microsoft PowerPoint 
Document"

[ from an ubuntu breezy system, adjust yours accordingly ]

You should see the following Firefox preference settings in
about:config:

helpers.global_mailcap_file/etc/mailcap
helpers.private_mailcap_file   ~/.mailcap

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Linux to Linux printing

2006-01-04 Thread David Hummel
On Wed, Jan 04, 2006 at 07:44:02AM -0800, Henry House wrote:
> 
> The traditional way to share printers under Unix and Linux is lpd (the
> daemon half of lpr, which together with the lp* utilities for users
> constitutes the BSD printing system). I use this at my office because
> it is simple to configure (at least for me --- all my printers are
> postscript lasers) and does not require lots of support packages like
> CUPS.

What packages are you referring to?  The necessary packages (like
cupsys-bsd for the BSD commands) will already be installed on Ubuntu
systems.  CUPS is arguably just as easy to configure so installing LPRng
may be more trouble than its worth at this stage.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Linux to Linux printing

2006-01-03 Thread David Hummel
On Wed, Jan 04, 2006 at 01:16:11AM -0600, Ken Bloom wrote:
> 
> On the print server, look for something that looks like this in
> /etc/cups/cupsd.conf
> 
> 
> Order Deny,Allow
> Deny From All
> Allow From 127.0.0.1
> 
> 
> and add this line just before the  line
> Allow From 192.168.1.*

Oh yeah and that too ;^)  Thanks, Ken.
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Linux to Linux printing

2006-01-03 Thread David Hummel
On Tue, Jan 03, 2006 at 10:07:58PM -0800, Alex Mandel wrote:
> 
> I've been looking into Cups but I can never figure out the ipp 
> connection string.
> Tonight I tried ipp://192.168.1.105:631/printers/HL-5150D
> but that just gave me an unable to connect message.

First you need to configure the printer in CUPS, and then try:

ipp://192.168.1.105/ipp/port1

 (but see below first)

> I also read that I should get a web interface if I browse to 
> http://192.168.1.105:631

If cupsd is running and you are on 192.168.1.105 then yes you should.
The default is to listen only on the localhost, so you won't be able to
connect from another machine.  Add a Listen directive in
/etc/cups/cupsd.conf on 192.168.1.105:

Listen hostname:631

> I'm pretty sure I'm not running a firewall on that machine

Check again and make sure port 631 is open.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Linux to Linux printing

2006-01-03 Thread David Hummel
On Mon, Jan 02, 2006 at 11:47:16PM -0800, Alex Mandel wrote:
> 
> I'm thinking that maybe for *nix to *nix I should maybe use something
> other than samba, but I'm not quite sure how to go about that?

CUPS.

file:///usr/share/doc/cupsys/README.txt.gz
http://cups.org/documentation.php
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Wireless Encryption Issue

2005-10-11 Thread David Hummel
On Tue, Oct 11, 2005 at 01:27:16AM -0700, Trevor M. Lango wrote:
> 
> I have encountered a rather odd issue at school.  In my department
> there are two available wireless networks.  One has a 64 bit
> encryption key and one has a 128 bit encryption key.  I can connect to
> the higher encryption key network without incident but dhcp times out
> on the other.  Any ideas?

Is it possible that either WPA or some kind of EAP is being used?
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] e2fsprogs

2005-09-23 Thread David Hummel
On Fri, Sep 23, 2005 at 07:30:43PM -0700, Richard Harke wrote:
> 
> I thought it might be a good idea to update firefox. So I did:
> apt-get update
> apt-get -s install mozilla-firefox
> 
> I get a rather long list of packages to be updated, installed
> and even removed. But also I get the message;
> E: This installation run will require temporarily removing the
> essential package e2fsprogs due to a Conflicts/Pre-Depends loop. This is 
> often 
> bad, but if you really want to do it, activate the APT::Force-LoopBreak 
> option.
> E: Internal Error, Could not early remove e2fsprogs
> 
> I have done a lot of googling and all the sites I have found agree
> that this can cause "bad things to happen" But nothing more specific
> or any other way to proceed. My only ext2 file system is /boot so
> maybe my odds are better?? But one site indicated that this message is
> the result of a bug in the dependencies. If that was so, maybe I could
> just wait until it is fixed at Debian.

Undoubtedly an apt bug, or issue on your system.  The mozilla-firefox
package doesn't depend on e2fsprogs.  But _do not_ remove e2fsprogs.
Most likely you're other partitions are ext3, which is just ext2 with a
journal, in which case you need e2fsprogs.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Sid amd64 on a Compaq v2310us (status report)

2005-09-19 Thread David Hummel
On Mon, Sep 19, 2005 at 11:40:30PM -0500, Ken Bloom wrote:
> 
> David Hummel wrote:
> > On Mon, Sep 19, 2005 at 08:50:07PM -0500, Ken Bloom wrote:
> > 
> >>I have previously posted to vox-tech@lists.lugod.org about attempts
> >>to install Linux on my Turion64 based Compaq Presario v2310us
> >>laptop. I'm posting this as a howto to both vox-tech, and also
> >>debian-amd64, so that there should be an internet record of how to
> >>get a successful system working.
> > 
> > [snip]
> > 
> > Perhaps you should post this to these sites as well:
> > 
> >   http://www.linux-laptop.net/
> >   http://tuxmobil.org/
> 
> That's the idea. I just find it *really* easy to do it as an email,
> and then give them the archive address.

Definitely.  I for one appreciate your efforts.  Setting up Linux
on a laptop can be tricky, so the more resources the better.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Sid amd64 on a Compaq v2310us (status report)

2005-09-19 Thread David Hummel
On Mon, Sep 19, 2005 at 08:50:07PM -0500, Ken Bloom wrote:
> 
> I have previously posted to vox-tech@lists.lugod.org about attempts to
> install Linux on my Turion64 based Compaq Presario v2310us laptop. I'm
> posting this as a howto to both vox-tech, and also debian-amd64, so
> that there should be an internet record of how to get a successful
> system working.
[snip]

Perhaps you should post this to these sites as well:

  http://www.linux-laptop.net/
  http://tuxmobil.org/
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] mysql 4.0 query help

2005-08-29 Thread David Hummel
On Mon, Aug 29, 2005 at 10:13:31AM -0600, timriley wrote:
> 
> I've been following this thread with interest as there are quite
> creative query suggestions. However, I can't help but to see the
> straight forward group-by as what will work.
> 
> select muid, max( total_pct )
> from ca_subgroups
> group by muid;
> 
> I don't think this would return the first associated record.
> What am I missing?

I believe Dylan needs the codename associated with max(total_pct).  If
you add codename to the select in the above query, you will be selecting
the codename from the first row of the rows grouped by muid.  This will
not be the codename associated with max(total_pct) unless total_pct in
the first row of the muid group happens to be the max(total_pct).  So
using Bruce's trick or a sub-select allows the unambiguous selection of
the correct codename value.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] mysql 4.0 query help

2005-08-28 Thread David Hummel
On Sun, Aug 28, 2005 at 10:05:52AM -0700, Bruce Wolk wrote:
> 
> Dylan Beaudette said the following:
> >
> >I am interested only in the record which contains the highest
> >total_pct value for a given muid value.
> >
> >I was just hoping for something a little more elegant.
> 
> SELECT a.* from ca_subgroups as a left join ca_subgroups as b on 
> a.muid=b.muid and a.total_pct If two records have the same muid and maximum total_pct, both will be
> selected. Your statement of your problem didn't deal with this issue.

To avoid this you can group the resulting rows:

select a.*
from ca_subgroups as a
left join ca_subgroups as b on a.muid=b.muid and a.total_pcthttp://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] mysql 4.0 query help

2005-08-27 Thread David Hummel
On Sat, Aug 27, 2005 at 10:04:52PM -0500, Ken Bloom wrote:
> 
> On 8/27/05, Dylan Beaudette <[EMAIL PROTECTED]> wrote:
> > 
> > I am interested only in the record which contains the
> > highest total_pct value for a given muid value.
> 
> In ECS165a we learned to do this using a subquery:
> 
> select muid, total_pct, codename
> from ca_subgroups outer
> group by muid 
> having total_pct=(
>select max(total_pct) from ca_subgroups 
>where muid=outer.muid
> );

Not quite.  Use this instead:

select a.*
from ca_subgroups as a
where a.total_pct = (
  select max(total_pct)
  from ca_subgroups as b
  where b.muid = a.muid
)

But this doesn't help Dylan much since he's on MySQL 4.0.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] USB-DVD burner

2005-08-15 Thread David Hummel
On Thu, Aug 11, 2005 at 02:04:06PM +, Bill Kendrick wrote:
> 
> On Wed, Aug 10, 2005 at 05:16:33PM -0700, Mark K. Kim wrote:
> > Google shows, though, the "ub" kernel module conflicts with
> > "usb-storage", so it looks like you want to disable "ub" somehow and
> > use "usb-storage" instead.  Maybe try moving "ub.o" somewhere the
> > kernel can't find it and re-run `depmod -a`?
> 
> I know under Debian there's a way to blacklist hotplug stuff. (I don't
> recall offhand how or why, but I'm sure Googling for "blacklist" would
> help.) Other distros might do something similar.  (Or hey, maybe it's
> just a hotplug thing. :^) )

To blacklist a module I believe you just add it to
/etc/hotplug/blacklist.  But in the case of ub vs. usb-storage, simply
blacklisting or hiding the ub module won't do.  You actually have to
rebuild your modules after disabling CONFIG_BLK_DEV_UB.

Here's the excerpt from menuconfig (2.6.11 kernel):

CONFIG_BLK_DEV_UB:
This driver supports certain USB attached storage devices such as flash keys.
Warning: Enabling this cripples the usb-storage driver.
If unsure, say N.
Symbol: BLK_DEV_UB [=n]
Prompt: Low Performance USB Block driver
Defined at drivers/block/Kconfig:367
Depends on: USB
Location:
   -> Device Drivers
   -> Block devices

I was experiencing some strangeness (random freezes, i/o errors, etc.)
with ub while using a USB hard drive together with a USB DVD burner.
When I switched to usb-storage, the problems went away and the
read/write performance of the hard drive was much better.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Recomendation? USB Flash software

2005-08-10 Thread David Hummel
On Wed, Aug 10, 2005 at 12:31:09PM -0700, Donald Greg McGahan wrote:
> 
> I'm Looking for software to encrypt files on USB Flash devices (as
> well as USB HDs) that will work both under XP and Linux.

  http://www.gnupg.org/
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] sshd_config and PasswordAuthentication

2005-07-22 Thread David Hummel
On Fri, Jul 22, 2005 at 12:02:41PM -0700, Karsten M. Self wrote:
> 
> on Fri, Jul 22, 2005 at 10:01:32AM -0500, Jay Strauss ([EMAIL PROTECTED]) 
> wrote:
> >
> > I thought you were telling me that when this is set to "no" then I
> > still type my password, then some magic happens, and I login to the
> > remote box but I never send my password down the line.
> 
> No.  If "PasswordAuthentication no" is set in /etc/ssh/sshd_config, on
> the remote host, then you *must* use another method, and my
> understanding is that this limits you to SSH-passkey.  Your remote
> password (tunneled and encrypted or not) *won't* work.

If you want to fully disable password auth, it is still necessary to set
ChallengeResponseAuthentication to no.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] WiFi Part II

2005-07-21 Thread David Hummel
On Thu, Jul 21, 2005 at 09:45:59AM -0700, William Andrew wrote:
> 
> So I have tried lots of places and messed with lots of settings to no
> avail.  That brings up Jonathan's comment : "you may need to get a
> different card."
> 
> Now if I were to look for the Ideal WiFi card for a ThinkPad T22
> running FedoraCore what would I go looking for? What is the best Linux
> interface?

There really isn't a "best".  There are varying degrees of support for
different cards.  Some cards "just work".  I've always prefered Orinoco
(Lucent/Agere) cards, or Prism-based cards.  If you want I have an
Orinoco Silver I'd be willing to part with.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] cpan and botched installation of Image::Timeline

2005-07-21 Thread David Hummel
On Thu, Jul 21, 2005 at 09:07:51AM -0700, Dylan Beaudette wrote:
> 
> Being my first time using CPAN to install a new perl module, I thought 
> that it would be a piece of cake...

I would suggest using CPANPLUS instead.

> I attempted to install the module Image::Timeline like this:
> 
> $ cpan
> 
> cpan> install Image::Timeline
> 
> ... it downloaded and installed GD first, and then started compiling 
> the Image::Timeline module
> ...however one of the tests failed, and would not install. I forced the 
> install to see if it would work anyways, but alas a simple script that 
> calls this module always fails.
> 
> here is the low down on the module:
> http://search.cpan.org/~kwilliams/Image-Timeline-0.11/Timeline.pm
> 
> Right now I am stuck as to what I need to do in order to
> 1. remove this module from my local machine

If the module installed a packlist, it should be somewhere like:

/usr/local/lib/perl/5.8.4/auto/Image/Timeline/.packlist

Just rm the files in this list.

CPAN doesn't directly provide an uninstall method (CPANPLUS does).

The ExtUtils::Packlist module contains a command for uninstalling from a
packlist.

> 2. re-install and save the error messages for further help from some 
> kind soul

"script" is useful for this.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] [getting OT] R statistics language (and Beamer)

2005-07-14 Thread David Hummel
On Thu, Jul 14, 2005 at 02:56:13PM -0700, Mark K. Kim wrote:
> 
> On Thu, 14 Jul 2005, Norm Matloff wrote:
> >
> >http://heather.cs.ucdavis.edu/~matloff/r.html
> 
> From scanning through the tutorial, it looks like R does things for
> which I use MATLAB.  What are the strengths and weaknesses of R and
> MATLAB in comparison to each other besides the price?

I've been using R extensively with Bioconductor (bioinformatics
libraries for R).  Never used MATLAB, but I work with several
statisticians and mathematicians who are experts at both, and they all
use R for any kind of statistical analysis.

And then there is the price =)

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Re: vox-tech Digest, Vol 14, Issue 12

2005-07-14 Thread David Hummel
On Thu, Jul 14, 2005 at 12:38:25PM -0700, Norm Matloff wrote:
> 
> On Thu, Jul 14, 2005 at 12:00:03PM -0700, [EMAIL PROTECTED] wrote:
> 
> > Date: Wed, 13 Jul 2005 13:45:00 -0700
> > From: Bill Kendrick <[EMAIL PROTECTED]>
> > Subject: [vox-tech] [getting OT] R statistics language
>  
> > On Wed, Jul 13, 2005 at 12:31:04PM -0700, Norm Matloff wrote:
> 
> > > R/S+ is multiplatform (the various Unixes, Windows, Macs).
> 
> > So, anyone want to do a talk on this language at LUGOD some time!? :)
> 
> Seems like this question was asked a few months ago. :-)
[snip]

If you are replying to a digest message, please change the Subject line
to that of the specific message you are replying to.  Setting your
In-Reply-To header to the Message-ID would also be nice.

Thanks,

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] sshd_config and PasswordAuthentication

2005-07-07 Thread David Hummel
On Thu, Jul 07, 2005 at 10:57:53AM -0500, Jay Strauss wrote:
>
> Henry House wrote:
> >
> >With PasswordAuthentication set to no, SSH-key authentication must be
> >used instead of a password. This method uses public/private key pairs
> >created by ssh-keygen(1) to authenticate. This is generally
> >considered more secure than tunneled-password authencation for
> >reasons than someone else can explaim better than I can.
> 
> This is what I thought that option did, but I have
> PasswordAuthentication no on most of my boxes but don't use a key pair
> to log in.  I get prompted for a password and I type that in, and I'm
> logged on.

That's correct.  Setting PasswordAuthentication to no does not disable
password auth.  You can still fall back on it if you aren't using public
key auth.  If you really want to disable password auth, you need to set
ChallengeResponseAuthentication to no.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] OT external disk for backup

2005-06-02 Thread David Hummel
On Thu, Jun 02, 2005 at 01:07:39PM -0700, Dylan Beaudette wrote:
> 
> I am looking into getting an external hard disk for backing up my 
> system (simple stuff with rsync).

If you're willing to consider a complete package, these are nice:

  http://www.lacie.com/products/product.htm?pid=10655

They're small, work nicely with Linux, both USB and Firewire,
bus-powered, and they come with a USB power-sharing cable.

I've had a number of Lacie external drives over the years (hard and
optical) and they've always been reliable.

-David

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] grub not finding root partition

2005-05-20 Thread David Hummel
On Fri, May 20, 2005 at 11:38:35AM -0400, Peter Jay Salzman wrote:
> 
> I really wish grub used standard device names.  :(

GRUB can be used to boot a bunch of different OSes, some of which do not
share the same device naming schemes.  For instance, BSD has partitions
and slices.

> root filesystem is on /dev/hda6
> boot partition is on /dev/hdb1
> 
>title  Debian GNU/Linux, kernel 2.6.11
>root   (hd1,0)
>kernel /vmlinuz-2.6.11 root=/dev/hda6 ro 
>savedefault
>boot
> 
> So I take it that "root (hd1,0)" doesn't mean "where to find root
> filesysetm", but rather, "where to find the kernel".
> 
> And I'm guessing that "root=/dev/hda6 ro" must be kernel arguments,
> which would mean "root=/dev/hda6" gives the location of the root
> filesystem.

Exactly.

-David

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] grub not finding root partition

2005-05-20 Thread David Hummel
On Fri, May 20, 2005 at 11:08:19AM -0400, Peter Jay Salzman wrote:
> 
> On Fri 20 May 05, 11:03 AM, David Hummel <[EMAIL PROTECTED]> said:
> > On Fri, May 20, 2005 at 10:45:32AM -0400, Peter Jay Salzman wrote:
> > > 
> > > Grub seems to work for my Debian kernels:
> > > 
> > >title  Debian GNU/Linux, kernel 2.6.8-2-686 
> > >root   (hd1,0)
> > >kernel /vmlinuz-2.6.8-2-686 root=/dev/hda6 ro 
> > >initrd /initrd.img-2.6.8-2-686
> > >savedefault
> > >boot
> > > 
> > > But not for a home compiled kernel:
> > > 
> > >title  Debian GNU/Linux, kernel 2.6.11
> > >root   (hd1,0)
> > >kernel /vmlinuz-2.6.11 root=/dev/hda6 ro 
> > >savedefault
> > >boot
> > > 
> > > When I try to boot 2.6.11, the kernel can't find the root filesystem and
> > > panics.
> > 
> > If the root filesystem is on /dev/hda, then the drive should be hd(0,0).
^^^
 should be: (hd0,0)
>  
> But then how is the Debian stock kernel finding the root filesystem?  That
> entry was installed by Debian.  How is it working if it points to (hd1,0)?

Good question.  Do you have a separate /boot partition?  Where is it?
This configuration indicates that its the first partition on /dev/hdb,
which seems odd, since your / is on /dev/hda6.  For instance, if your
/boot is on /dev/hda5, the root line should be (hd0,4).

-David

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] grub not finding root partition

2005-05-20 Thread David Hummel
On Fri, May 20, 2005 at 10:45:32AM -0400, Peter Jay Salzman wrote:
> 
> Grub seems to work for my Debian kernels:
> 
>title  Debian GNU/Linux, kernel 2.6.8-2-686 
>root   (hd1,0)
>kernel /vmlinuz-2.6.8-2-686 root=/dev/hda6 ro 
>initrd /initrd.img-2.6.8-2-686
>savedefault
>boot
> 
> But not for a home compiled kernel:
> 
>title  Debian GNU/Linux, kernel 2.6.11
>root   (hd1,0)
>kernel /vmlinuz-2.6.11 root=/dev/hda6 ro 
>savedefault
>boot
> 
> When I try to boot 2.6.11, the kernel can't find the root filesystem and
> panics.

If the root filesystem is on /dev/hda, then the drive should be hd(0,0).

http://www.gnu.org/software/grub/manual/html_node/Naming-convention.html#Naming%20convention

-David

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Installing Linux from within Linux

2005-05-17 Thread David Hummel
On Tue, May 17, 2005 at 03:34:57PM -0700, Bill Kendrick wrote:
> 
>   "Install GNU/Linux without any CD, floppy, USB-key, nor any other
>   removable media"
> 
> http://marc.herbert.free.fr/linux/win2linstall.html

That doc mentions loadlin, which used to be the way to start linux on
the install media from DOS/Windows:

  http://elserv.ffm.fgan.de/~lermen/

-David

___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] re-installing a boot loader, post windows install

2005-05-16 Thread David Hummel
On Mon, May 16, 2005 at 10:52:09AM -0700, Dylan Beaudette wrote:
> 
> I know that windows will clobber my bootloader (grub) and i would like
> to know ahead of time how to get it back once i reboot the machine.

http://www.gnu.org/software/grub/manual/html_node/Installation.html#Installation

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] xmms shoutcast lists

2005-05-13 Thread David Hummel
On Fri, May 13, 2005 at 06:17:00PM -0400, Peter Jay Salzman wrote:
> 
> Does xmms have a utility to manage Shoutcast stations?  As it stands,
> it looks like I need to keep a personal webpage of links.  Instead,
> I'd like for xmms to remember stations it gets pointed to and let me
> pick and choose between stations I've already listened to.

It actually does remember visited locations.  If you "Open Location"
(CTRL-L), the visited locations are available in a drop-down menu.  They
are editable in ~/.xmms/config.  I'm not sure how many locations it will
remember, or how to control this parameter.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] browser and mimetypes (I think)

2005-05-08 Thread David Hummel
On Sun, May 08, 2005 at 02:58:38PM -0700, Bill Kendrick wrote:
> 
> On Sun, May 08, 2005 at 05:20:00PM -0400, David Hummel wrote:
> > >$ locate wget. | grep man
> > >/usr/share/man/man1/wget.1.gz
> > 
> > $ man -w wget
> > /usr/share/man/man1/wget.1.gz
> 
> Ah, but without having the path to the man page (in my case here on
> sonic, /opt/extra/wget-X.XX/man/) in my $MANPATH environment variable,
> "man" still doesn't know where the man page is, even if I give it "-w"
> ;^)

Right, I suppose that would help wouldn't it ;-)  Revert back to locate
or find then...

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] browser and mimetypes (I think)

2005-05-08 Thread David Hummel
On Sun, May 08, 2005 at 04:18:35PM -0400, Peter Jay Salzman wrote:
> 
> On Sun 08 May 05,  1:07 PM, Bill Kendrick <[EMAIL PROTECTED]> said:
> > 
> > For some reason, Sonic doesn't have the "wget" man page (at least
> > not in my $MANPATH),
> 
> For this kind of thing, you can use locate, which locates a file on
> your hard drive by name:
> 
>$ locate wget. | grep man
>/usr/share/man/man1/wget.1.gz

$ man -w wget
/usr/share/man/man1/wget.1.gz

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] GUI mail client recommendation

2005-04-26 Thread David Hummel
On Tue, Apr 26, 2005 at 12:57:32PM -0400, Peter Jay Salzman wrote:
> 
> On Tue 26 Apr 05,  9:18 AM, Rod Roark <[EMAIL PROTECTED]> said:
> > On Tuesday 26 April 2005 08:29, Peter Jay Salzman wrote:
> > > Any recommendations?
> > 
> > I suspect the best bet is either KMail or Thunderbird.  I use KMail
> > but sometimes get annoyed with its quirks.  Would love to hear from
> > anyone who has tried both.
> 
> Thanks, guys.  It looks like Thunderbird or Kmail it is.  I'll start
> with Thunderbird just because I don't run KDE everywhere.

Some people like Sylpheed:

  http://sylpheed.good-day.net/

Never used it myself, but it looks fairly capable.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] dvd and strange filenames

2005-04-21 Thread David Hummel
On Thu, Apr 21, 2005 at 02:52:23PM -0400, Peter Jay Salzman wrote:
> 
> I burned a DVD on Linux.  When the DVD is mounted on Linux, it looks
> fine.  When the DVD is mounted on Win2k, everything is capitalized,
> spaces get converted to _ and filename length appears to be cut.
> 
> [SNIP]
> 
> I'm vaguely familiar with the terms "rockridge" and "Joliet", but I
> *thought* I burned the DVD using rockridge extensions...

If you did not burn the DVD with Joliet records, that is your problem.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Changing the print resolution of JPEG images by script

2005-04-08 Thread David Hummel
On Fri, Apr 08, 2005 at 03:12:38PM -0700, Henry House wrote:
> 
> One of the more common operations that I need to do with JPEG images
> is to change their print resolution so that when printed (e.g., as
> included figures in a LaTeX document) they print at 300 dpi (for
> example) instead of 72 dpi. I have been doing this in the Gimp. This
> causes the JPEGs to be recompressed with loss of quality when the Gimp
> saves the files.
> 
> - Is there any ways to change the print resolution, short of editing
> the JPEGs by hand, without recompressing them?
> 
> - Is there any utility in existance that could do this from the
> command line? I tried the jpegtran program from libjpeg-progs in
> Debian, but it does not seem to have this capability.

The "convert" program in the imagemagick package might do what you want.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Forwarding SMB through SSH

2005-04-06 Thread David Hummel
On Wed, Apr 06, 2005 at 08:41:09AM -0700, Henry House wrote:
> 
> På onsdag, 06 april 2005, skrev Richard Crawford:
> > On my Solaris server at work, I'm running Samba and sharing the web
> > directory over it so that it can be viewed by the Windows computers
> > at work.  I'd like to be able to access this share via SSH on my
> > Linux computer at home; is this possible?
> > 
> > I've tried:
> > 
> > # ssh -f -L2001:localhost:139 xxx.xxx.xxx.xxx sleep 2
> 
> I think that the sleep command after the arguments to ssh is
> unnecessary.

Right, if all you are doing is forwarding a port, executing a command is
not necessary.  Just use the -N switch to ssh.  Sorry this speaks more
to the ssh part than your actual question.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Getting KDE 3.4 in Debian Testing

2005-04-02 Thread David Hummel
On Sat, Apr 02, 2005 at 06:03:27PM -0800, Bill Kendrick wrote:
> 
> On Sat, Apr 02, 2005 at 11:54:42AM -0800, Bob Scofield wrote:
> > On Saturday 02 April 2005 01:02, Bill Kendrick wrote:
> > >
> > > However, KDE 3.4 has been packaged for Testing, and can be reached
> > > via the following line in /etc/apt/sources.list:
> > >
> > >   deb http://pkg-kde.alioth.debian.org/kde-3.4.0/ ./
> > 
> > Here's a question.  If one does nothing but wait, isn't it true that
> > KDE 3.4 will eventually come at some point just by an ordinary
> > apt-get upgrade?
> 
> Yes, but if you're currently sticking with Stable, it looks like you
> won't get it for some time.  (Someone correct me if I'm wrong!)
> 
> I'm deducing this based on the comment I heard that said KDE 3.4 won't
> even get into _"sid"_ (Unstable) until after the current Testing
> ("sarge") 'graduates' into a Stable branch.
> 
> Then, after KDE 3.4 hits "sid," it will no doubt linger there for at
> least a few weeks, and then eventually make its way into Testing
> (which at that point will be called "etch").

KDE 3.4 is included in Kubuntu:

  http://www.kubuntu.org.uk/

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] mysql

2005-03-24 Thread David Hummel
On Thu, Mar 24, 2005 at 10:08:04AM -0500, Peter Jay Salzman wrote:
> 
> Do varchars in MySQL need to have the (n) specifier?

Yes.
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] BSD versus Linux (and SQL/PHP/magic quoting)

2005-03-18 Thread David Hummel
On Fri, Mar 18, 2005 at 02:20:53PM -0800, Ken Bloom wrote:
> 
> On Fri, 18 Mar 2005 15:08:47 -0500
> David Hummel <[EMAIL PROTECTED]> wrote:
> 
> > On Fri, Mar 18, 2005 at 04:01:13PM +, Ken Bloom wrote:
> > > 
> > > On Fri, 18 Mar 2005 10:57:34 -0500
> > > [EMAIL PROTECTED] (Peter Jay Salzman) wrote:
> > > > 
> > > >http://www.dirac.org/linux/sql_quoting.html
> > > 
> > > Does PHP not have ?-parameter substitution (so you can say SELECT
> > > * FROM table WHERE stringattribute=?  and substitute the ? with a
> > > string that is properly quoted according to the language
> > > conventions?
> > 
> > Also known as placeholders (?) and bind values (the substituted
> > value). But the way you've written it does not account for binding
> > undefined values (which are usually bound as NULL):
> > 
> > SELECT * FROM table WHERE stringattribute = NULL
> > 
> > This will not select stringattribute's that are NULL.  To do that
> > you would say:
> > 
> > SELECT * FROM table WHERE stringattribute IS NULL
> > 
> > Unless you know for certain that you are never binding undefined
> > values, you can use the following to avoid this problem:
> > 
> > SELECT * FROM table WHERE ((? IS NULL AND stringattribute IS NULL)
> > OR stringattribute = ?)
> > 
> > and then bind the same value to both placeholders.
> 
> Binding a NULL to a ? is no different from putting the NULL right in
> the string - it still has the same problem with the = operator,

That is correct, which is why the above construct is preferable.

> and that is completely orthagonal to my discussion of placeholders and
> bind values.

I don't agree.  You asked if the PHP APIs allow placeholders and bind
values.  I don't know and I don't care, but a discussion of their
_proper_ use is relevent and worth mentioning.  Why?  Because someone
not familiar with placeholders and bind values might read this and get
the idea that the construct you presented is OK, when in fact there is a
more robust way.  Better to prevent things like this from proliferating
IMHO.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] BSD versus Linux (and SQL/PHP/magic quoting)

2005-03-18 Thread David Hummel
On Fri, Mar 18, 2005 at 04:01:13PM +, Ken Bloom wrote:
> 
> On Fri, 18 Mar 2005 10:57:34 -0500
> [EMAIL PROTECTED] (Peter Jay Salzman) wrote:
> > 
> >http://www.dirac.org/linux/sql_quoting.html
> 
> Does PHP not have ?-parameter substitution (so you can say
> SELECT * FROM table WHERE stringattribute=?
> and substitute the ? with a string that is properly quoted according
> to the language conventions?

Also known as placeholders (?) and bind values (the substituted value).
But the way you've written it does not account for binding undefined
values (which are usually bound as NULL):

SELECT * FROM table WHERE stringattribute = NULL

This will not select stringattribute's that are NULL.  To do that you
would say:

SELECT * FROM table WHERE stringattribute IS NULL

Unless you know for certain that you are never binding undefined values,
you can use the following to avoid this problem:

SELECT * FROM table WHERE ((? IS NULL AND stringattribute IS NULL) OR 
stringattribute = ?)

and then bind the same value to both placeholders.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] BSD versus Linux (and SQL/PHP/magic quoting)

2005-03-18 Thread David Hummel
On Fri, Mar 18, 2005 at 10:57:34AM -0500, Peter Jay Salzman wrote:
> 
>   http://www.dirac.org/linux/sql_quoting.html

The PHP magic quote thing seems rather retarded, but I think that you've
basically arrived at the correct conclusion:

  Always use the database API's method for escaping special characters

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] YAST equivalent on Debian?

2005-03-18 Thread David Hummel
On Fri, Mar 18, 2005 at 07:50:13AM -0600, Jay Strauss wrote:
> 
> > - Kurumin.  As Ubuntu, but KDE desktop default.
> 
> Too bad the site is in Spanish (maybe Portugese), I'd like to read
> about this distro

There's also Kubuntu:

  http://www.kubuntu.org.uk/

A preview of Hoary Hedgehog was just released yesterday.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Exporting displays

2005-03-17 Thread David Hummel
On Thu, Mar 17, 2005 at 01:28:27PM -0800, Karsten M. Self wrote:
> 
> on Wed, Mar 16, 2005 at 10:42:41PM -0800, Mark K. Kim ([EMAIL PROTECTED]) 
> wrote:
> >
> > But this works only if the remote computer has a ssh server with X
> > forwarding enabled, which it is by default on most systems I've
> > seen.  
> 
> Not, FYI, Debian.  Not sure of Ubuntu, haven't checked yet.

On Warty Warthog:

$ grep X11Forwarding /etc/ssh/sshd_config
X11Forwarding yes

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Changing Debian Screen Resolution

2005-03-04 Thread David Hummel
On Fri, Mar 04, 2005 at 10:34:10AM -0800, Bill Kendrick wrote:
> 
> It's actually xrandr (like Rest & Relaxation, except the R&R here is
> Rotation and Resolution... or vice-versa)
> 
> KDE's got a systray applet to do R&R stuff, too.  We've finally caught
> up to Mac OS 7.5! ;^)  (And we're still ahead of Windows... heh heh)

Speaking of "Rotation", this seems like a very cool hack for new
PowerBooks:

  http://www.kernelthread.com/software/ams/

  (See "The Perturbed Desktop")

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Changing Debian Screen Resolution

2005-03-03 Thread David Hummel
On Thu, Mar 03, 2005 at 05:27:18PM -0800, Robert G. Scofield wrote:
> 
> My Debian screen resolution defaults to a bothersome 800x600.  I'm
> trying to get it to 1024x768.
> 
> So, can anybody tell me how to make the 1024x768 screen resolution
> permanent?

You're /etc/X11/XF86Config[-4] should look like:

Section "Screen"
Identifier  "screen"
Device  "device"
Monitor "monitor"
DefaultDepth24
SubSection "Display"
Depth   24
Modes   "1024x768"
EndSubSection
EndSection
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] /var/log/messages Mystery

2005-03-01 Thread David Hummel
On Tue, Mar 01, 2005 at 09:21:08PM -0800, Robert G. Scofield wrote:
> 
> Because I don't have my computer on for 24 hours a day, I always
> modify /etc/crontab to fire at a time when I will likely be on my
> computer.  So in my Debian partition crontab fires during the 8:00 pm
> hour, and in my SuSE partition crontab fires during the 9:00 pm hour.

This is what anacron is for.  Is anacron running on your system?  This
may account for the /var/log/messages strangeness.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


[vox-tech] Linux-friendly 802.11b/g mini-PCI card

2005-02-07 Thread David Hummel
In case you're looking for a compatible mini-PCI 802.11b/g card for you
laptop, this store has the Xterasys XG600 for $39 shipped:

  http://store.mrtechus.com/mipciinie80w1.html

It's got the Prism GT chipset and is well supported by the prism54
driver, which is included in kernel >= 2.6.5.  It should also work
directly with tools like kismet and xsupplicant.

I wanted something internal for my behemoth of a laptop (Dell Inspiron
8200).

Just thought I'd pass this along.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Password: prompts freeze up

2005-02-07 Thread David Hummel
On Mon, Feb 07, 2005 at 08:26:19PM -0800, Ken Bloom wrote:
> 
> I'm trying to use sudo to dist-upgrade, and whenever I get to the
> password prompt, the sudo process (but nothing else) freezes up beyond
> the point of even being killed with kill -9. This has happened to me
> last night and this night, and I recovered by doing a hard reboot
> (obviously, I cannot `sudo reboot' like ususal) and it worked for the
> rest of the evening, and most of today.
> 
> This happens with login, su, and sudo.

Can you checksum these binaries against those in the package
repositories?  Also check the PAM modules.

It seems like either major filesystem corruption, or a crack with a
rootkit / binary infection system.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Re: vox-tech Digest, Vol 9, Issue 2

2005-02-03 Thread David Hummel
On Thu, Feb 03, 2005 at 10:40:21AM -0800, Mark K. Kim wrote:
> 
> On Thu, 3 Feb 2005, Micah Cowan wrote:
> 
> > Peter Jay Salzman wrote:
> >
> > >I forgot to list another major annoyance for me: I'm so used to
> > >emacs style editing in bash, that ctrl-u is burned into my brain as
> > >"clear line".  Unfortunately, it displays the page source on FF.
> >
> > C-u is not an emacs thing (take it from an emacs user). It's a
> > terminal thing. Emacs uses C-u for something *completely* different.
> 
> It's a readline thing, no?

Yep.  readline defaults to emacs-style line editing commands, which is
augmented with additional commands like C-u.  From the man page:

unix-line-discard (C-u)
Kill backward from point to the beginning of the
line.  The killed text is saved on the kill-ring.

I usually use C-k, which is more emacs-ish.

There is also the vi-style editing mode
(put "editing-mode vi" in your ~/.inputrc).

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Re: vox-tech Digest, Vol 9, Issue 2

2005-02-03 Thread David Hummel
On Thu, Feb 03, 2005 at 05:36:06AM -0800, Micah Cowan wrote:
> 
> Daniel A. Lorca-Martinez wrote:
> 
> >Actually, the Mozilla Foundation folks are all fairly geeky-which
> >explains the vi command.  On the other hand, this same text search
> >feature is available using Control-F (Or Command-F on Macs).  Though
> >that doesn't excuse the lack of documentation you mention for this
> >particular feature...
> 
> Such is not the case with the regular Mozilla browser; just Firefox
> AFAICT (I have just recently used the latest versions of both).

What are you replying to?

If it's:

> >On the other hand, this same text search feature is available using
> >Control-F (Or Command-F on Macs).

Then no, CTRL-F does indeed produce a text search box in Mozilla (1.7.3
in my case).  The vi-style / find-as-you-type feature is also there.

If it's:

> >Though that doesn't excuse the lack of documentation you mention for
> >this particular feature...

Then yes, the Mozilla online help is fairly decent.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Sarge Printing Problem

2005-01-28 Thread David Hummel
On Fri, Jan 28, 2005 at 03:24:17PM -0500, David Hummel wrote:
> 
> In the meantime, try lp.

Which will only work if the cupsys-client package is installed ;-)
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Sarge Printing Problem

2005-01-28 Thread David Hummel
On Fri, Jan 28, 2005 at 11:32:41AM -0800, Robert G. Scofield wrote:
> 
> I can't print from the GUI (Gnome in this case.)  At first I could
> print from the command line using the command "lpr."  But after
> downloading the Cups packages "lpr" would not work.  What would work
> from the command line was "lpr -l."

I believe you need to install the cupsys-bsd package, which provides the
BSD commands for CUPS (i.e. lpr, lpq, etc.).  This may fix some of the
other issues you are having as well.  In the meantime, try lp.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Kernel compiles with a dash of debian magic

2005-01-26 Thread David Hummel
On Wed, Jan 26, 2005 at 01:54:00PM -0800, Richard Burkhart wrote:
> 
> I'm trying to learn the arcane art of kernel compiles ... my goal is to 
> get ndiswrapper compiled as a module, operational, and driving a linksys 
> wireless card.
> 
> Thanks to a guide at http://www.osnews.com/story.php?news_id=2949 I've 
> got the 'compile' part down, using make-kpkg to build the kernel image 
> as a .deb file and automagically install it.

As long as you understand the traditional way to compile the kernel, the
Debian kernel-package way is a good way to compile and manage your
kernels.  Don't be discouraged from doing it this way.

> Of *course* there's something I'll do wrong.  Last night's attempt to 
> build a trimmed 2.4.29 kernel is kernel panic'ing in the boot process.  
> Sooo ... time to try again. Except --  how do I get rid of the damaged 
> kernel & modules so I can try again? 
> 
> The guide at  http://newbiedoc.sourceforge.net/system/kernel-pkg.html 
> suggests the command "dpkg -P /boot/(kernel image name)" to uninstall 
> it.  That didn't work  

No, that document says:

# dpkg -P kernel-image-2.4.18.030309

which is correct.

> Trying to remove the kernel through 'dpkg (-r / -P) [kernel image .deb 
> name]' isn't doing anything either.  (I read the dpkg manpage and 
> guessed at that part).
> 
> - Is there a way through dpkg to clear out my damaged 2.4.29 kernel (w) 
> any of its other wreckage (modules, etc).

Yes:

$ dpkg --purge kernel-image-2.4.29-xxx

The argument to --purge is the package name, not the package file name.

> - Where on the filesystem do I need to go through to manually remove 
> the flipping thing?  (The kernel image, the modules directory, the 
> entries in GRUB, etc.)?

You shouldn't have to do this since the above command should work, but
as Pete said, everything listed by:

$ dpkg -L kernel-image-2.4.29-xxx

which will include:

/boot/config-2.4.29-xxx
/boot/vmlinuz-2.4.29-xxx
/boot/System.map-2.4.29-xxx
/lib/modules/2.4.29-xxx/
/usr/share/doc/kernel-image-2.4.29-xxx/

And of course modify your boot loader's config:

grub: /boot/grub/menu.lst
lilo: /etc/lilo.conf

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] perl - benchmark module

2005-01-06 Thread David Hummel
On Thu, Jan 06, 2005 at 12:07:25PM -0500, Peter Jay Salzman wrote:
> 
> I spent a minute playing with the benchmarking module and found some
> interesting stuff I thought others would find interesting too.
> 
> tr versus regex
> ===
> Each piece of code was run 400,000 times and the "final time" is the
> total time divided by 400,000.
> 
> This code executes 412,371 times per second:
> 
>$string = 'hello';
>$string =~ tr/hello/olleh/;

$string is now "olllh";

> This code executes 180,995 times per second:
> 
>$string = 'hello';
>$string =~ s/hello/olleh/;

$string is now "olleh";

These are different operations.  I'll let you look into why.

> tr is clearly faster than regex.  At first, I was surprised that
> single character replacements took longer than word replacements, but
> upon reconsidering it, I think it's certainly plausible.

I think this is what you would expect.  Transliterations are not as
smart as regular expressions.  The tr/// operator simply replaces one
character set with another, character by character.  The s/// operator
compiles the entire string and executes it in the regex engine.

What happens if you precompile the string with the qr// operator?

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] perl - A way to export ALL functions in a package?

2004-12-23 Thread David Hummel
On Fri, Dec 24, 2004 at 12:35:28AM -0500, Peter Jay Salzman wrote:
> 
> Is there a way of telling perl: "Hey, just export every function
> that's defined in this module".   It's kind of a drag having to keep
> @EXPORT updated everytime I write more (or delete) code.

Or just don't export anything and use object oriented lingo.  This may
or may not be easier depending on the size of your project, but I'd
recommend this especially if you end up aggregating lots of modules.

-David
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Kernel Panic

2004-12-23 Thread David Hummel
  [ Sorry if this was already mentioned ]

Avoid any update tool that replaces your working kernel.  Configure the
tool to prevent this, or use the underlying package manager to install
(rather than replace), and then add the new kernel to your existing boot
loader menu.
___
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] portable mp3 player in linux

2004-12-03 Thread David Hummel
On Fri, Dec 03, 2004 at 11:50:35AM -0500, Peter Jay Salzman wrote:
> 
> On Fri 03 Dec 04, 11:04 AM, David Hummel <[EMAIL PROTECTED]> said:
> >
> > better to hack together playlists instead.  Oh, another limitation
> > is a 52 character limit on file and directory names.
>  
> Do you feel limited by that?

Only because the firmware will ignore any file with names > 52 chars
when reading the tag database, and file/dir names > 52 chars get
truncated on the display (annoying).  Doesn't matter so much, because my
script shortens these files before they are transferred to the player
and indexed.

> Sounds like a built-in limitation of the filesystem.

Not the filesystem (it's FAT32), but the firmware.  File names can be up
to 255 chars on FAT32.

> I wonder if that could be increased with a firmware upgrade in the
> future...

I hope so ...

> I've heard that ogg sounds similar to an mp3 file at 64kbs higher in
> sampling, so that a 64kbs ogg sounds like a 128 kbs mp3.

I actually don't know, because I've never used anything below 128 kbps.
I can tell you that a 128 kbps Ogg does sound better than a 128 kbps MP3
(using lame in my case), and the Ogg file is ~4% smaller.  The bass is
more accurate and the highs more crisp.  You probably can't distinguish
this unless you have decent headphones.

> I've also read that that 192kbs ogg is indistinguishable from flac.  I
> started to collect flac, but haven't jumped on the ogg bandwagon yet.
> Perhaps it's time...

FLAC is awesome.  I would use it, except my collection is so large that
I would probably need a 400GB harddrive to carry around a significant
percentage of my collection.  This is why I restrict myself to 128 kbps
Ogg and MP3.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] portable mp3 player in linux

2004-12-03 Thread David Hummel
On Fri, Dec 03, 2004 at 10:01:32AM -0500, Peter Jay Salzman wrote:
> 
> Have you looked at the iRiver iFP 799T?  It appears to be a flash
> player with 1GB of storage.  I didn't think there were any flash
> players with that much storage around.  I've seen it at a remarkable
> $180 on amazon.   1G for under $200 sounds too good to be true.

Yep, flash capacity just keeps going up and getting cheaper.  And it
likes this one supports Ogg too!

> There also appears to be an iRiver H340, which slightly cheaper than
> the H140.  It has a color screen (say hello to more recharging), can
> display jpg and bmp images.  Unfortunately, it doesn't seem to support
> wav.

Right.  These newer models sacrifice audio features (WAV support,
digital I/O) for the imaging viewing features (which I didn't care
about).  One of my intentions is to use it as a portable sampler, so WAV
and digital I/O are important for me.

> Lastly, there were some complaints about the H140 (although I suspect
> these are all ipod lovers who are pretty low or non-tech people to
> begin with).  This is from amazon
> 
> http://www.amazon.com/exec/obidos/tg/detail/-/B0001BRITE/002-3454873-5363261?v=glance
> 
>  * playlists can't be created on the fly (dunno what that exactly means...)

I'm not sure either ;-> , but I've been hacking together playlists on
the computer (via scripts or whatever) and dumping them to the player.
Much faster than going through 40GB worth of music on the player's
interface.

In one sense it does generate playlists on the fly.  In DB mode, if you
select a group of songs by album/artist/genre, only that group will
play.  Or maybe I still don't know what on-the-fly means.

>  * it takes 4 minutes to boot in DB mode (whatever that means...)

Yes, startup in DB mode is very slow, but not 4 minutes.  Probably
better to hack together playlists instead.  Oh, another limitation is a
52 character limit on file and directory names.

>  * sound quality is said to be "OK".

Sound quality is excellent.  Better than iPod.  Better than Creative
Nomad.  These are direct comparisons with identical files, and are the
only other players I've compared.  Most of the reviews I read concur
with this.  I think most of the time people complain about sound quality
on MP3 players, it's not so much the player but the fact that they are
listening to lossy-compressed audio, and the quality varies depending on
the encoder, codec, etc.  And this will _never_ come close to being CD
quality, despite what people claim.  This situation can be helped by
using better codecs, like Ogg, and of course higher bitrates.

>  * maximum volume is not loud enough

Not true, unless you already have hearing problems.  This also depends
to a great extent on the headphones.  If you're using massive,
over-the-ear headphones with inefficient drivers, or headphones that
don't fit snuggly over the ears (allow much of the sound to escape),
then yes, it won't seem loud enough, and you'll suck the battery dry
faster.  I recommend in-the-ear style earbud headphones with a closed
design, and a high-efficiency neodymium magnet.  I use Sony MDR-EX51LP.

> What exactly is SPDIF?

Sony-Philips Digitial InterFace.  To be specific, the digital I/O on the
iRiver H140 is in the form of mini-TosLink (Sony's optical version of
SPDIF), as can be found on some portable CD and MD players.  Regular
TosLink is found on most DVD players and digital audio receivers.
mini-TosLink is an 1/8" connecter that can be shared with a line-level
analog stereo mini-jack.

> And is there any way possible to get one of these things to play in a
> car stereo?  I've been meaning on getting a new sound system in my car
> anyhow.  If I can get something that can interface with an mp3 player,
> that would be really awesome.

If the car stereo has any auxiliary line inputs, then you're all set.
You just need the right cable.

I wonder if there are any car decks that will play Ogg files on CD-ROM.
Many will play MP3 CD-ROMs.

> You've pretty much sold me on one of these things, but I wanted to ask
> a few more questions before jumping in.  :)

I hope I've answered them ;->

David Hummel
Informatics Program
Children's Hospital Boston
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] portable mp3 player in linux

2004-12-02 Thread David Hummel
  [ apologies for breaking the thread, too quick with delete ]

On Wed, 1 Dec 2004 16:48:54 -0800, Brian Richter wrote:
> 
> If I had the money, I would get a Neuros. www.neurosaudio.com

I agree that if you want to hack your player, the neuros is (possibly
the only) way to go, and could be fun if you had the time.  I don't, and
I ultimately decided against it based on the following:

Neuros HD 40GB iRiver H140 40GB
-- 
 Mass (g):  266172
 Dimensions (mm):   134x78x33  105x60x22
 I/O:   line   SPDIF+line
 Record to MP3 (kbps):  64-160 40-320
 Charge Time (hrs): 8  3
 Remote:-- Backlit LCD
 Playback Time (hrs):   10 16
 Battery Type:  Li-ion Li-polymer
 EQ:?? 6 modes

These are just the things that were obvious, and the rest of the specs
are similar between the players.  Apparently lithium polymer batteries
last as much as 3x longer than lithium ion, which is good because like
the neuros, the battery in the iRiver is not user replaceable.  I'm
guessing the iRiver battery is much more expensive to replace as a
result.

Of course the neuros has the FM broadcasting, which I'm not sure is
practical, but it's cool.  And it has a large skip protection buffer
which is nice.  The neuros is also quite a bit cheaper ($300 vs. $400),
but there are lower capacity versions of both.
 
David Hummel
Informatics Program
Children's Hospital Boston
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] portable mp3 player in linux

2004-12-01 Thread David Hummel
On Wed, Dec 01, 2004 at 01:02:00PM -0800, Jennifer Stickel wrote:
>
> I am considering getting a portable mp3 player.  I was wondering if
> anyone had suggestions on ones that work nicely in Linux.  Also what
> is the opinion on the flash memory based devices versus the hard drive
> based ones?

I wanted a Linux-friendly player with a large capacity.  After somewhat
extensive research, I ended up getting an iRiver H140 hard drive (40GB)
player for the following reasons (in order of importance):

 * USB 2.0/1.1 standard mass storage device (FAT32 file system)
 * Ogg Vorbis support
 * No digital rights management and/or copy protection
 * On-board firmware upgrade
 * WAV support
 * Record to WAV or MP3
 * SPDIF optical and line I/O
 ... and not so important, but cool:
 * Built-in mic for voice recording
 * FM Tuner
 * Fully functional remote with backlit LCD

You'll definitely want to take advantage of USB 2.0, which means you'll
need a USB 2.0 controller and a kernel > 2.4.20 (IIRC).  My laptop is
USB 1.1, so I purchased an Adaptec USB 2.0 Cardbus adapter (any adapter
with the NEC chipset should work), and the transfers are around 10x
faster than the onboard USB.

The only software you need is the program to create the binary music
info database.  But there's an open source program that compiles on
Linux (iripdb: http://www.marevalo.net/iRipDB/) that will create the
database file from ID3 tags and Ogg info (the Windoze program doesn't
index Ogg info).  This database allows you to search by
artist/album/title/genre (play all songs by this artist, in this genre,
etc.).  I've modified iripdb to fix several problems (broken genre
assignment, incompatibility with older versions of id3lib, etc.).  I
haven't gotten around to submitting the fixes to the author, but I'm
happy to share them.

Basically, this player works on any modern OS with USB and FAT32
support, so you would never have to touch a Windows machine to deal with
this player.  So far it's been great and works perfectly with Linux.  I
believe some of the lower capacity iRiver flash players are also dumb
storage devices with Ogg support, in case this one is overkill for you.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] yet another SQL question...

2004-11-22 Thread David Hummel
On Mon, Nov 22, 2004 at 02:00:59PM -0800, Dylan Beaudette wrote:
> 
> I would like to make a table that displays the dominant component
> (i.e.  comppct_r is the largest for a given larger unit) and
> associated attributes for each larger unit.

I would use CREATE TABLE ... SELECT.

I think the following SELECT will work:

  select
mukey,
max(comppct_r),
taxorder, 
taxsuborder,
taxgrtgroup 
  from component
  group by mukey;

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] What not to backup on RH9/apache

2004-11-14 Thread David Hummel
On Sun, Nov 14, 2004 at 01:02:39PM -0800, Rod Roark wrote:
> 
> On Sunday 14 November 2004 12:23 pm, Jack LaPlante wrote:
> >
> > on their internal network.  I guess I will use tar to create a local
> > archive on the root server, then ftp the compressed archive to the
> > backup server.
>
> I think you want to read up on rsync.  You can get it to copy only
> what's changed, so you don't have to worry so much about excluding
> things.

But it's easy enough to do so with the --exclude and --exclude-from
rsync options.  I usually use a single --exclude-from list with +/-
rules.  See the man page.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


[vox-tech] mutt fcc attachments

2004-11-13 Thread David Hummel
Hello,

To avoid bloating my outbox with MIME copies of attached files, I've got
"set fcc_attach=no" in my .muttrc.  However, I would still like to keep
track of what files were sent with what messages.  Is there a hook or
other mechanism I can use to simply append the filenames to the fcc'ed
messages?  No luck finding anything like this so far.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Histograms on GNU/Linux?

2004-10-26 Thread David Hummel
On Tue, Oct 26, 2004 at 01:13:04PM -0400, Peter Jay Salzman wrote:
> 
> How do people do histograms on Linux (other than than by hand?)

R will allow you to express your data in just about any way imagineable:

  http://www.r-project.org/
  http://cran.r-project.org/doc/manuals/R-intro.html#Graphics

There is a learning curve ... R is a programming language.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Export MySQL DB to flat file

2004-10-25 Thread David Hummel
On Mon, Oct 25, 2004 at 12:20:53PM -0700, Dylan Beaudette wrote:
> I was wondering if there is any such tool in the MySQL utils that will
> save something like a CSV file that represents the records in the
> DB...  something like mysqldump, but without all of the SQL code mixed
> with the data...

See the -T flag to mysqldump:

  $ mysqldump -T /path/to/dbdump mydb

This must be run on the machine where mysqld is running, and the
/path/to/dbdump must be writeable by the user running mysqld.

This will create both *.sql and *.txt files.  The *.txt files are
tab-delimited files.  You may need to change the '\N's to something M$
SQL server can understand.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] sleep/standby mode under debian?

2004-10-22 Thread David Hummel
On Fri, Oct 22, 2004 at 02:40:15PM -0400, David Hummel wrote:
> 
> On Fri, Oct 22, 2004 at 10:27:38AM -0700, ashleigh smythe wrote:
> > 
> > I was wondering if it is possible for my debian desktop (Dell
> > dimension) to power-down or go to sleep when not in use for a
> > certain amount of time?
> 
> It is possible if APM and/or ACPI is configured in your kernel, and
> you are running apmd or acpid.  I believe ACPI support is more mature
> in 2.6.  Check out the apmd and acpid packages, and related tools and
> kernel modules.

I should mention that this also depends on power management support in
your BIOS.  I'd be surprised if the machine you are talking about
doesn't have some level of APM and ACPI support, or both.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] sleep/standby mode under debian?

2004-10-22 Thread David Hummel
On Fri, Oct 22, 2004 at 10:27:38AM -0700, ashleigh smythe wrote:
> 
> I was wondering if it is possible for my debian desktop (Dell
> dimension) to power-down or go to sleep when not in use for a certain
> amount of time?

It is possible if APM and/or ACPI is configured in your kernel, and you
are running apmd or acpid.  I believe ACPI support is more mature in
2.6.  Check out the apmd and acpid packages, and related tools and
kernel modules.

There are some caveats, such as network connections, sound, etc. not
working after a suspend/resume, but there are workarounds for these
problems.  Some of these are highlighted in the documentation for
apmd/acpid.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] mysql <--> oracle function question

2004-10-14 Thread David Hummel
On Thu, Oct 14, 2004 at 09:54:19PM -0700, Dylan Beaudette wrote:
> 
> after searching about on google, and the MySQL manual ... i can't seem to find 
> an equivilent function in MySQL to Oracle's TRANSLATE() function...

You could use a nested REPLACE:

 Oracle: TRANSLATE('string','str','123') -> '123ing'

 MySQL:  REPLACE(REPLACE(REPLACE('string','s','1'),'t','2'),'r','3') -> '123ing'

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Using Knoppix to configure another distribution

2004-09-28 Thread David Hummel
On Tue, Sep 28, 2004 at 02:51:46PM -0700, Mark K. Kim wrote:
> "PCI (credit card) Slots" are actually known as "PC Card" or "PCMCIA"
> slots, and are ISA-based, not PCI-based, technology.

There are PC cards (16-bit, ISA-ish) and CardBus cards (32-bit,
PCI-ish).

>From http://www.pcmcia.org/papers/new_bus.htm:

  PC cards use an 8- or 16-bit interface that operates at ISA bus speeds
  (8 MHz) using an ISA-like asynchronous protocol.  In contrast, CardBus
  provides a 32-bit multiplexed address/data path, which operates at PCI
  local-bus speeds of up to 33 MHz, yielding a peak bandwidth of
  132MB/sec.  CardBus accomplishes this by adopting the synchronous
  burst-transfer orientation of PCI, as well as a bus protocol, which is
  essentially identical to that of PCI.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] solved puzzle: free du and df disagree about free disk space

2004-09-21 Thread David Hummel
On Tue, Sep 21, 2004 at 06:29:31PM -0700, Karsten M. Self wrote:
> 
> on Tue, Sep 21, 2004 at 08:25:20AM -0700, Henry House ([EMAIL PROTECTED]) wrote:
> > 
> > As you can see from these transcripts, 'du' told me that I had used
> > less than 1 GB on this machine's /var, but according to 'df' there
> > was still no free space.
> 
> Moral Jr:  'du' and 'df' report different statistics.
> 
> 'df' reports the free space on disk.  'du' reports the utilization (in
> blocks) of detectectable files (by definition:  files which aren't,
> say, deleted but with handles held open by running processes).  Adding
> a third mix:  'ls' reports not the size-on-disk (used blocks) but
> actual data size within the file.

Here's a quick and dirty Perl script I wrote a while back to report the
accurate size of files and directories.  It uses stat() recursively.
I'm attaching it in case someone might find it useful.  Just call it
with your file/dir arguments (or none for the current directory).  It
seems to work pretty well (I'll rely on the Perl hackers in the group to
verify).

-David


fsize.pl
Description: Perl program
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Inspiron 8100 Backlight problems

2004-09-01 Thread David Hummel
On Wed, Sep 01, 2004 at 11:49:52AM -0700, Hans W. Uhlig wrote:
> 
> Ok full details of odd behaviour, If I reset the resolution on battery
> power it turns the backlight on, If I reset the resolution while power
> is ON it turns the backlight off... Any help would be wonderful, (I
> have reset the bios, reflashed the bios, checked acpi(still a possible
> problem)

Do you have any DPMS settings configured in your XF86Config?  If so,
these should probably be disabled.  On my 8200, I configure LCD standby
in the BIOS power management section, which works well.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: Fwd: Re: [vox-tech] debian woody to sarge upgrade = dead xserver: solved

2004-08-26 Thread David Hummel
On Thu, Aug 26, 2004 at 01:36:51PM -0700, ashleigh smythe wrote:
>
> For those of you who were following and helping out with my saga of
> upgrading woody to sarge, I wanted to let you know that the problem is
> solved.  I resorted to a fresh install of sarge
[snip]

Glad you're up and running Ashleigh, but sorry you had to resort to a
fresh install.

It would be helpful to hear from others who have upgraded from woody to
sarge.  I too was under the impression that editing
/etc/apt/sources.list, and then:

$ apt-get update; apt-get dist-upgrade

would be all that's required.  Is this in fact how others have
successfully done this upgrade?  Are there any other gotchas that people
have encountered in doing this?

Thanks,

David Hummel
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] debian woody to sarge upgrade = dead xserver

2004-08-25 Thread David Hummel
On Wed, Aug 25, 2004 at 08:40:37AM -0700, Ashleigh Smythe wrote:
> 
> Not to be a major wimp and give up, but should I just install sarge 
> from scratch, rather than trying to upgrade woody?  Or maybe this 
> problem would still occur.  I really hadn't done much to my woody 
> setup so I don't see what I'd lose.

This won't solve the mystery of what happened to your X during the
upgrade, but you could try installing the current binary drivers from
Nvidia:

  http://www.nvidia.com/object/linux_display_ia32_1.0-6111.html

You could also try refreshing the X packages with "apt-get --reinstall",
but perhaps this is a stab in the dark.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] a few pre-install questions

2004-08-25 Thread David Hummel
On Tue, Aug 24, 2004 at 05:42:29PM -0700, mrp wrote:
> 
> I think this is why apple laptops have battery life of between 5 and 8
> hours, rather than the 2-3 hours typical for x86 arch processors.

In practice, even the current generation of G4 laptops get only ~2.5
hours max.  Where are you getting those numbers, and for what models?
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-14 Thread David Hummel
On Fri, Aug 13, 2004 at 08:55:39PM +, Matt Roper wrote:
> 
> Maybe the apt info in your dpkg database is from back when you first
> installed.  If this is the case, the actual package versions listed
> for your uninstalled packages are probably way out of date.

Examining this further, it appears this is not the case.  The package
versions in /var/lib/dpkg/available are synchronized with those in
/var/lib/apt/lists/*Packages.

> I know that apt-get by itself won't touch /var/lib/dpkg/available, but
> I'm not sure what other tools will.  It's not very well documented in
> the manpages.

Since I hadn't yet installed strace, I apt-get install'ed it, and
/var/lib/dpkg/available was touched.  I'm not sure if it was modified
though.  Is it possible that apt-get is maintaining this file?

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-14 Thread David Hummel
On Sat, Aug 14, 2004 at 08:15:32AM -0400, Peter Jay Salzman wrote:
> 
> What dpkg _doesn't_ seem to know (until I actually install the
> package) is -L,

For packages not installed you can use:

$ apt-file list package-name-pattern

> and similarly, it won't be able to do a -S search either.

$ apt-file search file-name-pattern

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-13 Thread David Hummel
On Fri, Aug 13, 2004 at 04:55:39PM -0700, Matt Roper wrote:
> 
> On Fri, Aug 13, 2004 at 07:39:21PM -0400, David Hummel wrote:
> > 
> > On Fri, Aug 13, 2004 at 04:17:38PM -0700, Matt Roper wrote:
> > > 
> > > I have no idea why dselect throws all the apt information into the
> > > dpkg database instead of just working from the apt database
> > > directly; it's certainly non-intuitive and breaks the whole
> > > apt/dpkg layering scheme.
> > 
> > Interesting, I've never used dselect, and the apt package info still
> > winds up in the dpkg databases.
> 
> I believe (although I'm not positive) that the Woody installers did
> the equivalent of a 'dselect update' at the end of the installation,
> even if you didn't ask to run dslect at the end of the install
> process.  Maybe the apt info in your dpkg database is from back when
> you first installed.  If this is the case, the actual package versions
> listed for your uninstalled packages are probably way out of date.

Ah I see.  Thanks for pointing this out.

> It's possible that other package managers (aptitude, synaptic, etc.)
> also have this behavior, but I've never used them so I don't know.
> Have you ever fired up one of these or have you used nothing but apt
> since installation?

Correct, nothing but apt.  I prefer to start with a minimal system and
install as needed.

> I know that apt-get by itself won't touch /var/lib/dpkg/available, but
> I'm not sure what other tools will.  It's not very well documented in
> the manpages.

I'm curious too.  If anyone can shed some light...

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-13 Thread David Hummel
On Fri, Aug 13, 2004 at 04:45:37PM -0700, Rick Moen wrote:
> 
> Quoting David Hummel ([EMAIL PROTECTED]):
> 
> > dpkg must know about available packages since:
> > 
> > $ dpkg -l package-name-pattern
> > 
> > lists available packages (apparently from /var/lib/dpkg/available)
> > regardless of whether they're installed.
> 
> Perhaps I was a bit unclear:  dpkg knows only about what's in
> /var/lib/dpkg/status.  It can glean information about uninstalled
> packages from that file only because apt puts that data there.

That's what I suspected, thanks for confirming.  It's not obvious from
the man pages.

> I was extremely vaguely aware that /var/lib/dpkg/status includes
> stanzas about uninstalled packages, but that fact tends to slip my
> mind because I don't use it:   The useful way to use "dpkg -l ..." is
> without globs, which, for reasons I haven't looked into, omits
> uninstalled packages from the return values.  Which is what I said
> before.
> 
> > Therefore, it's a bit misleading that dpkg -l with no
> > package-name-pattern only lists installed packages.
> > 
> > So how is /var/lib/dpkg/available generated if not from apt?
> 
> I'm utterly mystified as to how you could think I said otherwise.

You didn't say otherwise, you just didn't say it.  And since I wasn't
completely aware of it ...

> apt pulls down (among other things) *Packages files from the various
> sources into /var/lib/apt/lists, then merges them to form a single
> /var/lib/dpkg/available file.  _Of course_ it's generated by apt.

Again, thanks for clarifying.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-13 Thread David Hummel
On Fri, Aug 13, 2004 at 04:17:38PM -0700, Matt Roper wrote:
> 
> I have no idea why dselect throws all the apt information into the
> dpkg database instead of just working from the apt database directly;
> it's certainly non-intuitive and breaks the whole apt/dpkg layering
> scheme.

Interesting, I've never used dselect, and the apt package info still
winds up in the dpkg databases.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable - apt strangeness

2004-08-13 Thread David Hummel
On Fri, Aug 13, 2004 at 03:29:45PM -0700, Rick Moen wrote:
>
> dpkg knows nothing about available packages (as indicated in
> /var/lib/apt/lists/*Packages and /var/lib/dpkg/available).  It knows
> only about the contents of /var/lib/dpkg/status -- the "installed
> packages" database.

dpkg must know about available packages since:

$ dpkg -l package-name-pattern

lists available packages (apparently from /var/lib/dpkg/available)
regardless of whether they're installed.

Therefore, it's a bit misleading that dpkg -l with no
package-name-pattern only lists installed packages.

So how is /var/lib/dpkg/available generated if not from apt?

The output of:

$ apt-cache dumpavail

has the same package info as /var/lib/dpkg/available.

I'm sure this can be elucidated by thoroughly reading the documentation
for dpkg and apt, but it's not readily obvious, and the man pages are
not specific enough.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] LAN pcmcia card is inaccessable in socket 1

2004-08-13 Thread David Hummel
On Fri, Aug 13, 2004 at 10:50:52AM -0700, Chris Jenks wrote:
> 
> I'm still struggling to get my Thinkpad 701C (24 MB ram) set up as a
> router. It now boots with the vanilla kernel 2.6.7 from the Debian
> testing sources, but the second ethernet card (in pcmcia socket 1) is
> not accessible.

[snip]

> doesn't match the ones in /etc/pcmcia/config.opts:
> include memory 0xc-0xf
> include memory 0xa000-0xa0ff
> include memory 0x6000-0x60ff

What does the "include port" line look like?

On my Debian Dell laptops, I had to change:

include port 0x100-0x4ff, port 0x800-0x8ff, port 0xc00-0xcff

to:

include port 0x100-0x4ff, port 0xc00-0xcff

or else the system would hang when starting cardmgr.  Not sure if this
applies to your situation.  I haven't taken the time to investigate why
this is necessary.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] eth0 troubles

2004-08-12 Thread David Hummel
On Thu, Aug 12, 2004 at 03:04:22PM -0700, Karalius, Joseph wrote:
> 
> A 'close' visual inspection of the terminals and ports did not reveal
> any bent or broken pins.
> 
> 'tcpdump -i eth0' did not show any network traffic
> 
> I set eth0 to 192.168.0.5 and could successfully ping that address and
> 127.0.0.1, but got a 'Network unreachable' error when pinging the
> gateway or any other known IP on the LAN. Same when I ping with the
> broadcast option.

And you are using a "straigh-through" as opposed to a "cross-over"
ethernet cable?

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] eth0 troubles

2004-08-12 Thread David Hummel
On Thu, Aug 12, 2004 at 01:04:01PM -0700, Karalius, Joseph wrote:
> 
> Does 'No DHCPOFFERS received. No working leases in persistent
> database.' mean that there was indeed a successful connection to the
> DHCP server but no leases available to that machine or would that
> message show up in any case where there was simply no response?

Can you try to configure the interface statically with an available
addresss to rule out a DHCP problem?

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Debian Unstable: XMMS acting funny?, Mozilla keypad no work, etc.

2004-07-23 Thread David Hummel
On Fri, Jul 23, 2004 at 01:21:09AM -0700, Mark K. Kim wrote:
> 
> Is anyone else's Debian unstable system acting funny with XMMS?  My
> XMMS just goes through the playlist like it's just a list to be
> skipped around (none of the songs play, but I see the highlights
> moving through the list.)

Actually I just observed this last night, but on a Debian stable laptop
(xmms 1.2.7-1).  It also occasionally begins playing an audio CD on its
own.  Strange.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] SQL help - unions

2004-07-21 Thread David Hummel
On Wed, Jul 21, 2004 at 12:00:39AM -0700, Jeff Newmiller wrote:
> 
> A headcount is not the same as a roster... neither Peter's nor
> Michael's version was counting anything.

I assumed what Peter was after was a list of unique SSN's for "race = 0"
students in Fall_2003 and Spring_2004.

> In fact, Michael's version is just wrong.  He uses an open join,

[ SELECT distinct SSN from Fall_2003, Spring_2004 where race = 0; ]

I think you mean an INNER or CROSS join (the cartesian product).

> which is different than a union join.

A UNION is not a join, it's a combination of results from separate
queries where the number and type of columns are the same.  You actually
can prevent eliminating duplicates with UNION ALL, but that's not what
you want in this case.

> The former concatenates the columns to give two distinct "SSN" columns
> and selects all possible pairings of the values in these columns, and
> the columns must be referred to with table names to distinguish them.

You are correct, and you will get an error due to the ambiguous "SSN"
column.

> Since he isn't constraining this open join, he ends up with all
> possible pairings of SSN values (if there are 200 in the fall and 300
> in the spring, then there are 6 rows in his result).

Well not really because of the use of DISTINCT...

Maybe a NATURAL join would work, but the UNION method is the most
straightforward.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] SQL help - unions

2004-07-20 Thread David Hummel
On Tue, Jul 20, 2004 at 06:20:06PM -0700, Jeff Newmiller wrote:
> 
> The existence of separate tables with identical structures and disjoint
> data in your schema is a red flag to me.
> 
> I highly recommend putting all the data into one table with a "Season"
> column to distinguish the rows... it simplifies these kinds of queries and
> makes the data much more useful for mining.

To be proper about it, you would normalize this by putting the season
and year in respective separate tables, and place foreign keys to these
in the SSN table.  But it doesn't sound like this schema needs to be
overly complex.  Separate tables does simplify archiving etc., and
whatever works.

> As the other respondents suggested, different SQL engines have different
> levels of support for the language.
> 
> SELECT SSN from [Fall 2003] WHERE race == 1
> UNION
> SELECT SSN from [Spring 2004] WHERE race == 1

The comparison operator for equal is '=' not '=='.

> gets you a little bit closer, but there are a couple of problems with 
> this... it isn't really obtaining a headcount,

Yes it is.  As is Michael Wenk's version.

> and unions don't eliminate duplicates.

Yes they do.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] SQL help - unions

2004-07-20 Thread David Hummel
On Tue, Jul 20, 2004 at 04:44:47PM -0700, Peter Jay Salzman wrote:
> 
> I can get an unduplicated headcount for the academic year with:
> 
>SELECT SSN from [Fall 2003]
>UNION
>SELECT SSN from [Spring 2004];
> 
> There's also a field called "race".  If the race field is 0, the student
> is African American.
> 
> How would I modify the above SQL statement to list the unduplicated
> headcount of all African Americans?  I would like to do something like:
> 
>SELECT SSN from [Fall 2003]
>UNION
>SELECT SSN from [Spring 2004]
>and race == 1;

This should do the trick:

SELECT SSN from [Fall 2003] where race = 0;
UNION
SELECT SSN from [Spring 2004] where race = 0;
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Gentoo installation by NFS?

2004-07-09 Thread David Hummel
On Fri, Jul 09, 2004 at 04:44:17PM -0700, Ken Bloom wrote:
> 
> On Fri, Jul 09, 2004 at 04:37:09PM -0700, Daniel Hurt wrote:
> >
> > Alot of people make reference to tom's boot disc.  I could not get
> > it functioning with my laptop however (My laptop does not have a
> > functioning CD drive).
> 
> Tom's Root Boot is a floppy. http://www.toms.net/rb/

Which can be made into a convenient bootable CD (very cool):

  http://www.toms.net/rb/tomsrtbt.FAQ  [see item 6]

This is the CD I carry around with my laptop.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] perl: function with hash and scalar args

2004-06-24 Thread David Hummel
On Thu, Jun 24, 2004 at 02:46:39PM -0700, Peter Jay Salzman wrote:
> 
> i have a function which takes a hash and scalar arg.  how is this done
> correctly?

By passing the hash as a reference.

> why is $scalar undefined at the print statement in function()?

Because you've shifted all the arguments into function()'s %hash.

> #!/usr/bin/perl
> use strict;
> use diagnostics;
> 
> sub function(%$)

  sub function(\%$)

> {
>my (%hash, $scalar) = (shift, shift);

 my ($hashref, $scalar) = @_;

>print "hash: $hash{foo}\n";

 print "hash: $hashref->{foo}\n";

>print "scalar: $scalar\n";
> }
> 
> my (%hash, $scalar);
> 
> $hash{foo} = "hello";
> $scalar= "goodbye";
> 
> function(%hash, $scalar);

  function(\%hash,$scalar);
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Anyone running a mail server on a dynamic IP?

2004-06-16 Thread David Hummel
On Wed, Jun 16, 2004 at 10:15:18PM -0700, Rod Roark wrote:
> 
> Seems like most of the spam that I (and thus LUGOD) are not
> successfully filtering out these days is from dynamic IPs - dialup,
> cable modem, and dynamic DSL.
> 
> So I'm wondering if it's reasonable to refuse mail from servers that
> connect directly from a dynamic IP.

If you still receive legitimate mail from such servers, then no.  But I
believe most of the major service providers already started doing this
some time ago at the ISP level, so you wouldn't receive this mail to
begin with.

For consumer-grade DSL/cable services, AFAIK it's next to impossible to
convince them that any legitimate need to allow such mail would outweigh
the potential for spam.

> Is anyone here running such a server?  And if you are, are you finding
> that many sites are refusing your mail?

Lots of sites will.  People running mail servers from dynamic IPs will
have better luck configuring their MTAs to use their ISP's SMTP server
as a smart host for outgoing mail.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] question on auto-running a program

2004-06-09 Thread David Hummel
On Wed, Jun 09, 2004 at 04:47:55PM -0700, Richard Ely wrote:
> 
> I have a recent Debian Distro.
> 
> When I log onto my machine as user, I am not connected because I have
> to "ifup eth0" as su.  So I can change to su.  type "ifup", then exit
> back to user.  Not efficient.
> 
> I want my son to use this machine and I do not want him to be su.  How
> can I have the system always issue that command as su on boot-up no
> matter who logs on?

The following line should be present in /etc/network/interfaces:

auto eth0

This will bring up eth0 automatically on boot.
(see ifup(8) and interfaces(5)).

___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Changing data with awk

2004-06-04 Thread David Hummel
On Fri, Jun 04, 2004 at 04:05:43PM -0700, Foo Lim wrote:
> 
> Use perl.  =D  You can edit the file in place also:
> 
> perl -p -i -e 's/(some regex)\r(some other regex)/${1}X${2}/' test.dat

Unless you are absolutely sure of what you are doing (or you want to
play around first), I'd use:

perl -pi.bk -e ...
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Pipermail

2004-06-01 Thread David Hummel
On Tue, Jun 01, 2004 at 04:13:55PM -0700, Bill Kendrick wrote:
> 
> Does anyone here know about pipermail?  LUGOD has need to edit some
> text in the archives (munge some email addresses to help prevent spam
> harvesting), and I'm too busy and unskilled to work on it.

If you just want to re-create the archives after editing the mbox files,
mailman already has a script called "arch" that does this.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] oracle -> MySQL conversion

2004-04-30 Thread David Hummel
On Thu, Apr 29, 2004 at 11:42:34AM -0700, Michael J Wenk wrote:
> 
> Other than saying a bad query is a bad query, I know of no instance
> where postgres would outperform mysql,

And you wouldn't unless you've done direct comparisons on the same or
similar hardware and/or server loads, worked with varying types and
quantities of data, and done significant query optimization.

> Oh sure, if you have the time to evaluate a ton of software before
> making a decision, then good.

It's not that difficult to configure MySQL or PostgreSQL, particularly
on Linux.  And if you're using a database-independent API (available for
most languages/databases), it's even easier.

> But if you're trying to to a migration quickly(if their license
> agreement with oracle were to end in < a month) then do you really
> have the time?  If it were me I wouldn't.  I also would not have asked
> in the first place if I could spend the time on it. 

If time is of the essence, you also should consider what database you're
coming from and it's level of compatibility with MySQL/PostgreSQL.  If
it's Oracle, then PostgreSQL wins out as others have mentioned.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] oracle -> MySQL conversion

2004-04-29 Thread David Hummel
On Wed, Apr 28, 2004 at 07:58:13PM -0700, Michael Wenk wrote:
> 
> On Wednesday 28 April 2004 05:29 pm, David Hummel wrote:
> >
> > I do agree that the decision should be based on features that you
> > actually need (and many people aren't aware of what they need).  If
> > you need rock-solid transactions, triggers, stored procedures,
> > inheritance, etc., use Postgres.  If your main requirements are
> > speed and ease of administration, go with MySQL.
> 
> I disagree with the admin part.  MySQL is no easier IMO to run than
> postgres.

In general, I find that the client and admin tools in MySQL are a
bit easier to deal with than the equivalent Postgres ones.

> where you really get the benefit from MySQL is speed.

Yes, it seems the consensus is that MySQL is faster than Postgres, and
I've seen it first hand.  But I feel the speed issue is often
exaggerated and not necessarily true in every situation.  It really
depends on your schema design, how much data your dealing with, what
kind of queries you need to do, etc.  I've seen several cases where
Postgres performed better than MySQL for certain queries, and vice
versa.

The point is, make the decision based on the requirements of your
applications and how they need to interact with the database.  Don't
dwell too much on the speed issue.  To aid in the decision, you can
always design portable applications and test them using both systems.
Portability between MySQL and PostgreSQL is not that difficult to
accomplish if you're careful.

> Unless you need triggers or have an app that specifically and totally
> won't run on anything other than postgres, I would steer clear of it. 

Although it appears MySQL performs better in a majority of cases, it's a
bit rash to suggest steering clear of Postgres on the speed issue alone.
I suggest trying out both systems, which is the ultimate ACID test (pun
intended).

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] oracle -> MySQL conversion

2004-04-28 Thread David Hummel
On Wed, Apr 28, 2004 at 04:55:33PM -0700, Jan W wrote:
> 
> Don't interpret this as knocking Postgres, I use it and think it's
> great.  It's just not a mature codebase the way that Oracle and other
> RDBMS's are...

The Postgres codebase is very mature.  It was around long before most of
the other databases you mentioned, and has undergone many major
revisions.  If you familiarize yourself with its history, you'll learn
that Postgres pioneered many of the advanced features found in
commercial databases like Oracle, DB2, etc.  Not to mention it's object
oriented features...

I do agree that the decision should be based on features that you
actually need (and many people aren't aware of what they need).  If you
need rock-solid transactions, triggers, stored procedures, inheritance,
etc., use Postgres.  If your main requirements are speed and ease of
administration, go with MySQL.

David Hummel
Genomics & Gene Discovery
WRRC-ARS-USDA
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] SQL question (mysql)

2004-04-01 Thread David Hummel
On Wed, Mar 31, 2004 at 11:05:24PM -0800, dylan wrote:
> 
> I am having a problem getting a query to work with MySQL 3.23.49
> 
> I have 3 tables, all which share a common key (user_id):
> 
> 1. volunteer_info (contains contact information) [key = user_id]
> 2. assignment_data (contains event assignment information) [key =
> user_id] fields include: user_id, event_id
> each record represents one event that any one volunteer is assigned to
> 3. score_board (contains event participation information) [key =
> user_id] fields include: user_id, event_id, participation_status
> each record represents whether or not a person attended an event
> 
> there is a 1:1 relationship between each table, after a few 'where'
> statements are applied.
> 
> As it stands right now i can access every person who was assigned to a
> given event (denoted by the variable $event_id) with the following
> query:
> 
> select volunteer_info.*
>from assignment_data, volunteer_info
>where volunteer_info.user_id = assignment_data.user_id
>and assignment_data.event_id = $event_id

If I understand your table structure correctly, here's another version:

select volunteer_info.*
from assignment_data
inner join volunteer_info using (user_id)
where assignment_data.event_id = $event_id

> i am able to access the contact info and participation info with this
> query:
> 
> select volunteer_info.*, participation_status
>from assignment_data, volunteer_info, score_board
>where volunteer_info.user_id = assignment_data.user_id
>and volunteer_info.user_id = score_board.user_id
>and assignment_data.event_id = $event_id
>and score_board.event_id = $event_id
> 
> The score_board table may or may not contain records that match the
> second query, which causes an empty set to be returned - or worse yet
> - only some of the records that i am interested in. I have
> experimented with a left join, but am not quite sure how to accomplish
> this.

Then left join score_board onto the previous query:

select volunteer_info.*
from assignment_data
inner join volunteer_info using (user_id)
left join score_board using (user_id,event_id)
where assignment_data.event_id = $event_id

This way you'll still get contact/assignment info where score_board data
doesn't exist.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


Re: [vox-tech] Perl script help

2004-03-24 Thread David Hummel
On Wed, Mar 24, 2004 at 03:32:58PM -0800, Richard Crawford wrote:
> 
> This script is supposed to remove everything between . 

Here's another more terse version:

=
#!/usr/bin/perl -i
$/='';
$d = <>;
$d =~ s///gs;
print $d;
=

Call it with file arguments.

-David
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech


  1   2   >