Re: [vox-tech] Virus deluge
on Thu, Jan 29, 2004 at 03:49:10PM -0800, Henry House ([EMAIL PROTECTED]) wrote: P? torsdag, 29 januari 2004, skrev Karsten M. Self: [...] : *after* '0' indicates a lockfile. Any rule that writes to a file _should_ use a lockfile. Rules which invoke a program '| command' or delivery '! address' _don't_ need a lockfile. Note that no lock file is needed or desirable when delivering to a maildir (maildirs are so designed that they require no locking). Recent versions of procmail understand a trailing slash on a mailbox name to mean that it is a maildir. Procmail will create a non-existant maildir on the fly. Thanks. I was wondering as I wrote that (and understand the principle behind Maildir -- it's a qmailism), but was too lazy to check/verify. Peace. -- Karsten M. Self [EMAIL PROTECTED]http://kmself.home.netcom.com/ What Part of Gestalt don't you understand? Ceterum censeo, Caldera delenda est. SCO vs IBM Linux lawsuit info: http://sco.iwethey.org signature.asc Description: Digital signature
[vox-tech] MacOS X, terminals, and ncurses apps
I find my self frequently sshing from a MacOS X box to my Debian box using the built-in terminal and ssh applications. When I do this, it's usually to check my email using mutt or compose email using mutt or vim. Here's my problem - the arrow keys don't work, and I don't get color either (Instead, my line-number column in vim is bolded and underlined in a very ugly manner). How can I configure the connection to work correctly (either by changing MacOS X terminal options, or by changing $TERM and choosing/installing an appropriate termcap/terminfo entry)? -- I usually have a GPG digital signature included as an attachment. See http://www.gnupg.org/ for info about these digital signatures. My key was last signed 10/14/2003. If you use GPG *please* see me about signing the key. * My computer can't give you viruses by email. *** signature.asc Description: Digital signature
[vox-tech] devfs and mkisofs, don't have permission to create multisession cd's
I have a backup script that I run periodically (and I haven't run it in two whole weeks), and I was trying to run it today but since having switched to devfs, the permissions on the cd drive's device file seem to have changed (probably as a result of the switch), so that I can't read the file system. As a result, I can't add new sessions to a CD because a permissions error keeps mkisofs from reading the previous sessions on the CD. Devfs complains about /dev/sg0 [EMAIL PROTECTED] ~]% ls -l /dev/sg0 lr-xr-xr-x1 root root 36 2004-01-30 07:22 /dev/sg0 - scsi/host0/bus0/target0/lun0/generic [EMAIL PROTECTED] ~]% ls -l `readlink -f /dev/sg0` crw-r--r--1 root cdrom 21, 0 1969-12-31 16:00 /dev/scsi/host0/bus0/target0/lun0/generic Does anybody know what the correct permissions should be, or how to fix this problem? -- I usually have a GPG digital signature included as an attachment. See http://www.gnupg.org/ for info about these digital signatures. My key was last signed 10/14/2003. If you use GPG *please* see me about signing the key. * My computer can't give you viruses by email. *** signature.asc Description: Digital signature
Re: [vox-tech] MacOS X, terminals, and ncurses apps
On Fri, 30 Jan 2004, Ken Bloom wrote: I find my self frequently sshing from a MacOS X box to my Debian box using the built-in terminal and ssh applications. When I do this, it's usually to check my email using mutt or compose email using mutt or vim. Here's my problem - the arrow keys don't work, and I don't get color either (Instead, my line-number column in vim is bolded and underlined in a very ugly manner). How can I configure the connection to work correctly (either by changing MacOS X terminal options, or by changing $TERM and choosing/installing an appropriate termcap/terminfo entry)? What is $TERM on the Mac? xterm-color? ssh should pass this value through to your debian shell. Make sure you have a terminfo file on the debian box for whatever the mac $TERM is. If the terminal emulation sucks, you'll have to look into improving it by changing terminal emulation settings (on the Mac) or by obtaining a better emulator than the standard terminal window that allows such changes. --- Jeff NewmillerThe . . Go Live... DCN:[EMAIL PROTECTED]Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/BatteriesO.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...2k --- ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
[vox-tech] SQL selecting distinct from multiple index tables
I have two index tables the associate Organizations with documents and projects. I'm trying to write a query that returns all the organizations that are associated with either a project or document. To select distinct organization that are either associated with a Document or a Project, I'm using SQL that looks like this. select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , Organizations where OrgDocs.OrgID = Organizations.OID select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgProjects , Organizations where OrgProjects.OrgID = Organizations.OID Any suggestions on how to combine this into a single query? thx, -- David ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
Re: [vox-tech] SQL selecting distinct from multiple index tables
select distinct O.OID, O.Name, O.Acronym from Organizations O, OrgDocs D, OrgProjects P where D.OrgID = O.OID or P.OrgID = O.OID I think this will result in two full table scans though.. -- Mitch On Friday, Jan 30, 2004, at 21:24 US/Pacific, David Siedband wrote: I have two index tables the associate Organizations with documents and projects. I'm trying to write a query that returns all the organizations that are associated with either a project or document. To select distinct organization that are either associated with a Document or a Project, I'm using SQL that looks like this. select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , Organizations where OrgDocs.OrgID = Organizations.OID select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgProjects , Organizations where OrgProjects.OrgID = Organizations.OID Any suggestions on how to combine this into a single query? thx, -- David ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
Re: [vox-tech] SQL selecting distinct from multiple index tables (solution)
ahh, I just got this to work. Here's the query I used (MySQL 3.x) select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , OrgProjects , Organizations where (OrgDocs.OrgID = Organizations.OID) or (OrgProjects.OrgID = Organizations.OID) still interested in other ways of doing this though -- Dave ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
Re: [vox-tech] SQL selecting distinct from multiple index tables
On Fri, 30 Jan 2004, Mitch Patenaude wrote: select distinct O.OID, O.Name, O.Acronym from Organizations O, OrgDocs D, OrgProjects P where D.OrgID = O.OID or P.OrgID = O.OID I think this will result in two full table scans though.. Actually, it will probably result in Count(P.*) passes through P... very inefficient. I think you were on the right track originally ... probably dump the results of both queries to a temporary table and retrieve distinct rows. -- Mitch On Friday, Jan 30, 2004, at 21:24 US/Pacific, David Siedband wrote: I have two index tables the associate Organizations with documents and projects. I'm trying to write a query that returns all the organizations that are associated with either a project or document. To select distinct organization that are either associated with a Document or a Project, I'm using SQL that looks like this. select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , Organizations where OrgDocs.OrgID = Organizations.OID select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgProjects , Organizations where OrgProjects.OrgID = Organizations.OID Any suggestions on how to combine this into a single query? thx, -- David ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech --- Jeff NewmillerThe . . Go Live... DCN:[EMAIL PROTECTED]Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/BatteriesO.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...2k --- ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
