Re: [vox-tech] devfs and mkisofs, don't have permission to create multisession cd's
On Fri, Jan 30, 2004 at 04:04:02PM -0800, Ken Bloom wrote: 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'd set the device to 664 and make sure that the user running the backup script is in the cdrom group. -- Samuel Merritt OpenPGP key: http://meat.andcheese.org/~spam/spam_at_andcheese_dot_org.asc PGP information can be found at http://www.mindspring.com/~aegreene/pgp/ pgp0.pgp Description: PGP signature
Re: [vox-tech] SQL selecting distinct from multiple index tables
select distinct Organizations.OID, Organizations.Name, Organizations.Acronym from Organizations o where o.OID in (select OrgID from OrgDocs union select OrgID from OrgProjects); Build subqueries first, thereby avoiding the full table joins. On Fri, 30 Jan 2004, 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
Re: [vox-tech] devfs and mkisofs, don't have permission to create multisession cd's
--On Saturday, January 31, 2004 01:12:51 AM -0800 Samuel N. Merritt [EMAIL PROTECTED] wrote: On Fri, Jan 30, 2004 at 04:04:02PM -0800, Ken Bloom wrote: 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 I'd set the device to 664 and make sure that the user running the backup script is in the cdrom group. Some systems will change the ownership on various devices to match the user logged in on the console, then set the ownership back when the user logs out. The idea is to let the person sitting in front of the computer have access to the cd-roms, sound device, etc. See if you have a file named console.perms in /etc/security or some similar location. You should be able to adjust it to include the scsi generic devices. -- Ken Herron ___ 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)
On Fri, Jan 30, 2004 at 10:04:35PM -0800, David Siedband wrote: 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 If you haven't already, try prepending an explain on the front of that select query to see how expensive it's going to be. You can then examine with useful data the expense of various methods. Sometimes two queries are faster than one query (ie build an index table, then do a simple select rather than a single complex select). You might also try the query with some precalculated index tables, ie: create temporary table tmp select distinct OID from OrgDocs; replace into tmp select distinct OID from OrgProjects; // with mysql 4.x you could use UNION and do one // create...select...union...select select Organizations.OID, Name, Acronym from Organizations, tmp where (tmp.OrgID = Organizations.OID); Depending on your table sizes a 'alter table tmp add key (OID)' might help, or alternately using a left join may be faster (not sure on this though): select Organizations.OID, Name, Acronym from tmp left join Organizations using (OID); This presumes that OIDs in OrgDocs and OrgProjects always have matching keys in Organizations. -- Ted Deppner http://www.deppner.us/ ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
[vox-tech] Can YAST create a FAT32 Partition?
Thanks to those of you who told me I need a new hard drive. I'd like to create a dual boot system on the new hard disk (which I haven't purchased yet). I'd like to do all of the partitioning from YAST. According to the YAST documentation YAST can delete FAT32 partitions. YAST can resize FAT32 partitions. But the documentation doesn't say whether YAST can create a FAT32 partition. The documentation assumes that one is partitioning to add Linux to a hard drive where Windows already exists. Does anybody know if YAST can create a FAT32 partition? Thank you. Bob ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
Re: [vox-tech] Can YAST create a FAT32 Partition?
On Sat, Jan 31, 2004 at 13:28:25PM -0800, Robert G. Scofield wrote: Thanks to those of you who told me I need a new hard drive. I'd like to create a dual boot system on the new hard disk (which I haven't purchased yet). I'd like to do all of the partitioning from YAST. According to the YAST documentation YAST can delete FAT32 partitions. YAST can resize FAT32 partitions. But the documentation doesn't say whether YAST can create a FAT32 partition. The documentation assumes that one is partitioning to add Linux to a hard drive where Windows already exists. Does anybody know if YAST can create a FAT32 partition? I don't use SuSE, so I can't answer the specific YAST question...but every partition tool I've used has been able to create a FAT32 partition. You also need to be able to format it (which is different from creating a partition and marking it's type) but that is generally pretty simple too. The big gotcha comes when you decide to install Windows. It's generally best to install Windows before you install Linux on a dual boot system because Windows will blindly write to your MBR, overwriting Lilo or Grub. Keep a boot disk handy if that's the way you want to go. ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
Re: [vox-tech] Can YAST create a FAT32 Partition?
On Sat, 31 Jan 2004, Robert G. Scofield wrote: Thanks to those of you who told me I need a new hard drive. I'd like to create a dual boot system on the new hard disk (which I haven't purchased yet). I'd like to do all of the partitioning from YAST. According to the YAST documentation YAST can delete FAT32 partitions. YAST can resize FAT32 partitions. But the documentation doesn't say whether YAST can create a FAT32 partition. The documentation assumes that one is partitioning to add Linux to a hard drive where Windows already exists. Does anybody know if YAST can create a FAT32 partition? I don't know if it can, but in general, this is not really a good idea. a) Even if it can, if you plan to make a dual boot you are better off having the OS that will use the os format the partition it will run in. b) Windows tends to demolish existing partitions. Pro versions are starting to provide options for installing in arbitrary partitions, but home versions are still pretty ruthless. This means installing Windows first is almost always the best approach. --- 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
Re: [vox-tech] devfs and mkisofs, don't have permission to create multisession cd's
I don't know what was actually wrong with the permissions after all (I was in the cdrom group, and mkisofs had a devfs file entry to make it work, but it didn't regardless.) I finally made it work by changing the command I used to invoke mkisofs from the option -M0,0,0 to the option -M /dev/cdrom (which is a symlink to /dev/cdroms/cdrom0) and that made it work On 2004.01.31 07:52, Ken Herron wrote: --On Saturday, January 31, 2004 01:12:51 AM -0800 Samuel N. Merritt [EMAIL PROTECTED] wrote: On Fri, Jan 30, 2004 at 04:04:02PM -0800, Ken Bloom wrote: 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 I'd set the device to 664 and make sure that the user running the backup script is in the cdrom group. Some systems will change the ownership on various devices to match the user logged in on the console, then set the ownership back when the user logs out. The idea is to let the person sitting in front of the computer have access to the cd-roms, sound device, etc. See if you have a file named console.perms in /etc/security or some similar location. You should be able to adjust it to include the scsi generic devices. -- Ken Herron ___ vox-tech mailing list [EMAIL PROTECTED] -- 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. *** pgp0.pgp Description: PGP signature
Re: [vox-tech] Can YAST create a FAT32 Partition?
On Saturday 31 January 2004 13:59, Jeff Newmiller wrote: a) Even if it can, if you plan to make a dual boot you are better off having the OS that will use the os format the partition it will run in. This means installing Windows first is almost always the best approach. Okay then I'll do it that way. Thank you and thanks also to Rob Rogers. Bob ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
RE: [vox-tech] Can YAST create a FAT32 Partition?
Dear moderator How do I unsusbscribe from this mailing list .. it's not emailing me my password and hence I can't unsubscribe.Any way out? Guru -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert G. Scofield Sent: Sunday, February 01, 2004 11:46 AM To: [EMAIL PROTECTED] Subject: Re: [vox-tech] Can YAST create a FAT32 Partition? On Saturday 31 January 2004 13:59, Jeff Newmiller wrote: a) Even if it can, if you plan to make a dual boot you are better off having the OS that will use the os format the partition it will run in. This means installing Windows first is almost always the best approach. Okay then I'll do it that way. Thank you and thanks also to Rob Rogers. Bob ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech Scanned by SecureSynergy VirusScreen Service. For more information log on to : http://www.securesynergyonline.com or http://www.securesynergy.com ___ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech