[vox-tech] ssh tunnel setup

2006-04-11 Thread Alex Mandel
So I'm following this page to figure out how to do ssh tunneling and it works great. http://souptonuts.sourceforge.net/sshtips.htm The problem is the command ssh -N -f -q work;ssh http takes away the command line prompt. 1. How do I get that to be included(3rd concurrent session?) 2. More importa

Re: [vox-tech] puzzling over MySQL query: joining aggregated values in a single query

2006-04-11 Thread Chris Jenks
On Tue, 11 Apr 2006, Dylan Beaudette wrote: [...] I am able to select out the soil depth, excluding certain horizons with the following query: select pedon_id, max(bottom) as depth from horizon where name REGEXP '.?C.?| R|.b.?' != 1 group by pedon_id ; a simple result for the above example wo

[vox-tech] puzzling over MySQL query: joining aggregated values in a single query

2006-04-11 Thread Dylan Beaudette
Hi! I have a simple table with multiple records per id number: soil horizons from numerous pits. the top and bottom of each horizon or layer is defined in the fields 'top' and 'bottom' a quick example of a single pit's records would like like this: +-+---+--+

Re: [vox-tech] unzip producing output that is garbage

2006-04-11 Thread Jeff Newmiller
Dylan Beaudette wrote: Howdy, downloaded some data from the seamless.usgs.gov website, only to find that the ZIP archives that it delivered expanded to garbage! running `file` on all of the contents returned "data", when other types should have been recognized. Also, a tiff file that was inc

Re: [vox-tech] Re:mail server config question

2006-04-11 Thread David Rosenstrauch
Whoops - I think I confused you here. I assumed something about your setup that apparently isn't correct and so gave you the wrong advice. As you're obviously aware, an SMTP server can both receive incoming mail and send outgoing mail. However, very often someone will configure their network