From owner-freebsd-database Tue Oct 27 14:01:41 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA29064 for freebsd-database-outgoing; Tue, 27 Oct 1998 14:01:41 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from mail.clearsail.net (mail.clearsail.net [207.252.227.3]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA29059 for ; Tue, 27 Oct 1998 14:01:39 -0800 (PST) (envelope-from jase@clearsail.net) Received: from clearsail.net (pirate.clearsail.net [207.252.222.75]) by mail.clearsail.net (8.9.1/8.8.8) with ESMTP id PAA12279 for ; Tue, 27 Oct 1998 15:46:50 -0600 (CST) Message-ID: <36364295.3956221F@clearsail.net> Date: Tue, 27 Oct 1998 16:00:54 -0600 From: Jason McNew X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: database@FreeBSD.ORG Subject: can't open a db file as 'nobody' despite 0666 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I'm using DB_File.pm which is a wrapper for db(3), and for some reason I can't open any database files if I'm the user 'nobody'. If I run it as a normal user (not owner or group member of the file in question), my program works fine. But, if I su over to 'nobody', it's instantly broken. I checked the db(3) manpage, but I diden't see anything about it in there. I also read DB_File.pm's POD docs and still no luck. The error I'm getting is "permission denied." Here is the simplest program I could write that duplicates the problem: #!/usr/local/bin/perl use DB_File; $db = '/home/jase/test.db'; tie %urldb, 'DB_File', $db, O_RDONLY, 0666, $DB_BTREE or die("coulden't open $db: $!"); whereas /home/jase/test.db is -rw-rw-rw- When I try to do this from a cgi script (apache runs as nobody) it spits out: coulden't open /home/jase/test.db: Permission denied at test.pl line 4. But the same scirpt runs just fine even when I run it as a user in a different group... except when I su to nobody.. %/usr/local/bin/perl -v This is perl, version 5.005_51 built for i386-freebsd I can work around this by making apache run as a different user, but I'd still like to know why this brakes, and better still, where it needs to be documented (provided it's not pilot error!) :) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Oct 27 14:18:02 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA01064 for freebsd-database-outgoing; Tue, 27 Oct 1998 14:18:02 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from elektra.ultra.net (elektra.ultra.net [199.232.56.13]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA01010 for ; Tue, 27 Oct 1998 14:17:59 -0800 (PST) (envelope-from syang@directhit.com) Received: from moe.directhit.com ([10.4.18.2]) by elektra.ultra.net (8.8.8/ult.n14767) with ESMTP id RAA14381; Tue, 27 Oct 1998 17:17:08 -0500 (EST) Received: by MOE with Internet Mail Service (5.0.1459.74) id ; Tue, 27 Oct 1998 17:16:32 -0500 Message-ID: <839A86AB6CE4D111A52200104B938D43080816@MOE> From: Steven Yang To: "'Jason McNew'" Cc: "'database@FreeBSD.ORG'" Subject: RE: can't open a db file as 'nobody' despite 0666 Date: Tue, 27 Oct 1998 17:16:32 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1459.74) Content-Type: text/plain Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Have you tried to chown the databse file to nobody? Steven > -----Original Message----- > From: Jason McNew [SMTP:jase@clearsail.net] > Sent: Tuesday, October 27, 1998 5:01 PM > To: database@FreeBSD.ORG > Subject: can't open a db file as 'nobody' despite 0666 > > I'm using DB_File.pm which is a wrapper for db(3), and for some reason > I > can't open any database files if I'm the user 'nobody'. If I run it > as > a normal user (not owner or group member of the file in question), my > program works fine. But, if I su over to 'nobody', it's instantly > broken. I checked the db(3) manpage, but I diden't see anything about > it in there. I also read DB_File.pm's POD docs and still no luck. > The > error I'm getting is "permission denied." > > Here is the simplest program I could write that duplicates the > problem: > > #!/usr/local/bin/perl > use DB_File; > $db = '/home/jase/test.db'; > tie %urldb, 'DB_File', $db, O_RDONLY, 0666, $DB_BTREE or > die("coulden't open $db: $!"); > > whereas /home/jase/test.db is -rw-rw-rw- > > When I try to do this from a cgi script (apache runs as nobody) it > spits > out: > > coulden't open /home/jase/test.db: Permission denied at test.pl line > 4. > > But the same scirpt runs just fine even when I run it as a user in a > different group... except when I su to nobody.. > > %/usr/local/bin/perl -v > > This is perl, version 5.005_51 built for i386-freebsd > > > I can work around this by making apache run as a different user, but > I'd > still like to know why this brakes, and better still, where it needs > to > be documented (provided it's not pilot error!) :) > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Oct 27 14:50:28 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA04959 for freebsd-database-outgoing; Tue, 27 Oct 1998 14:50:28 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from saturn.infospace.com (saturn.infospace.com [206.129.166.107]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA04952 for ; Tue, 27 Oct 1998 14:50:24 -0800 (PST) (envelope-from kmarcus@saturn.infospace.com) Received: from localhost (kmarcus@localhost) by saturn.infospace.com (8.8.7/8.8.7) with SMTP id OAA02005; Tue, 27 Oct 1998 14:47:55 -0800 Date: Tue, 27 Oct 1998 14:47:54 -0800 (PST) From: Kevin Marcus To: Jason McNew cc: database@FreeBSD.ORG Subject: Re: can't open a db file as 'nobody' despite 0666 In-Reply-To: <36364295.3956221F@clearsail.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk does nobody have a valid shell? Kevin Marcus -*- mailto:kmarcus@infospace.com -*- Sr. Software Engr -*@*- I n f o S p a c e . c o m, I n c. -*@*- "The Ultimate Directory" Redmond, WA http://www.infospace.com (425)882.1602 On Tue, 27 Oct 1998, Jason McNew wrote: > I'm using DB_File.pm which is a wrapper for db(3), and for some reason I > can't open any database files if I'm the user 'nobody'. If I run it as > a normal user (not owner or group member of the file in question), my > program works fine. But, if I su over to 'nobody', it's instantly > broken. I checked the db(3) manpage, but I diden't see anything about > it in there. I also read DB_File.pm's POD docs and still no luck. The > error I'm getting is "permission denied." > > Here is the simplest program I could write that duplicates the problem: > > #!/usr/local/bin/perl > use DB_File; > $db = '/home/jase/test.db'; > tie %urldb, 'DB_File', $db, O_RDONLY, 0666, $DB_BTREE or > die("coulden't open $db: $!"); > > whereas /home/jase/test.db is -rw-rw-rw- > > When I try to do this from a cgi script (apache runs as nobody) it spits > out: > > coulden't open /home/jase/test.db: Permission denied at test.pl line 4. > > But the same scirpt runs just fine even when I run it as a user in a > different group... except when I su to nobody.. > > %/usr/local/bin/perl -v > > This is perl, version 5.005_51 built for i386-freebsd > > > I can work around this by making apache run as a different user, but I'd > still like to know why this brakes, and better still, where it needs to > be documented (provided it's not pilot error!) :) > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Oct 27 14:52:52 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA05383 for freebsd-database-outgoing; Tue, 27 Oct 1998 14:52:52 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from mail.clearsail.net (mail.clearsail.net [207.252.227.3]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA05377 for ; Tue, 27 Oct 1998 14:52:50 -0800 (PST) (envelope-from jase@clearsail.net) Received: from clearsail.net (pirate.clearsail.net [207.252.222.75]) by mail.clearsail.net (8.9.1/8.8.8) with ESMTP id QAA15280 for ; Tue, 27 Oct 1998 16:38:04 -0600 (CST) Message-ID: <36364E98.404E0329@clearsail.net> Date: Tue, 27 Oct 1998 16:52:08 -0600 From: Jason McNew X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: database@FreeBSD.ORG Subject: [Fwd: can't open a db file as 'nobody' despite 0666] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk (Forgot to CC the list, whoops!) Jason McNew wrote: > Ah, I found the problem. The particular directory was not world readable, > and had the group set to wheel. The accounts I used to test were all in the > wheel group. So I couldn't read it as nobody because that was the only one > of those that was not in the wheel group. It was pilot error! I changed > the dir a+rX and it works fine now. Thanks, and sorry for the noise. :) > > Steven Yang wrote: > > > Have you tried to chown the databse file to nobody? > > > > Steven > > > > > -----Original Message----- > > > From: Jason McNew [SMTP:jase@clearsail.net] > > > Sent: Tuesday, October 27, 1998 5:01 PM > > > To: database@FreeBSD.ORG > > > Subject: can't open a db file as 'nobody' despite 0666 > > > > > > I'm using DB_File.pm which is a wrapper for db(3), and for some reason > > > I > > > can't open any database files if I'm the user 'nobody'. If I run it > > > as > > > a normal user (not owner or group member of the file in question), my > > > program works fine. But, if I su over to 'nobody', it's instantly > > > broken. I checked the db(3) manpage, but I diden't see anything about > > > it in there. I also read DB_File.pm's POD docs and still no luck. > > > The > > > error I'm getting is "permission denied." > > > > > > Here is the simplest program I could write that duplicates the > > > problem: > > > > > > #!/usr/local/bin/perl > > > use DB_File; > > > $db = '/home/jase/test.db'; > > > tie %urldb, 'DB_File', $db, O_RDONLY, 0666, $DB_BTREE or > > > die("coulden't open $db: $!"); > > > > > > whereas /home/jase/test.db is -rw-rw-rw- > > > > > > When I try to do this from a cgi script (apache runs as nobody) it > > > spits > > > out: > > > > > > coulden't open /home/jase/test.db: Permission denied at test.pl line > > > 4. > > > > > > But the same scirpt runs just fine even when I run it as a user in a > > > different group... except when I su to nobody.. > > > > > > %/usr/local/bin/perl -v > > > > > > This is perl, version 5.005_51 built for i386-freebsd > > > > > > > > > I can work around this by making apache run as a different user, but > > > I'd > > > still like to know why this brakes, and better still, where it needs > > > to > > > be documented (provided it's not pilot error!) :) > > > > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > > > with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Oct 27 14:56:31 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA06134 for freebsd-database-outgoing; Tue, 27 Oct 1998 14:56:31 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from talon.anteon.com ([38.181.219.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA06114; Tue, 27 Oct 1998 14:56:27 -0800 (PST) (envelope-from rhughes@anteon.com) From: rhughes@anteon.com Received: from talon.anteon.com (root@localhost) by talon.anteon.com (8.7.5/8.7.3) with ESMTP id RAA06673; Tue, 27 Oct 1998 17:58:07 -0500 (EST) Received: from spectrum.anteon.com (spectrum.anteon.com [172.30.104.223]) by talon.anteon.com (8.7.5/8.7.3) with SMTP id RAA06669; Tue, 27 Oct 1998 17:58:06 -0500 (EST) Received: from ffx.anteon.com by spectrum.anteon.com (5.x/SMI-SVR4) id AA06347; Tue, 27 Oct 1998 18:05:00 -0500 Received: from ccMail by ffx.anteon.com (ccMail Link to SMTP R6.00.01) id AA909529052; Tue, 27 Oct 98 17:57:35 -0500 Message-Id: <9810279095.AA909529052@ffx.anteon.com> X-Mailer: ccMail Link to SMTP R6.00.01 Date: Tue, 27 Oct 98 17:05:26 -0500 To: , Subject: MS Access databases on FreeBSD Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Does anyone know of a way to read/write Microsoft Access database files on a FreeBSD/Unix server? A simple DBI/DBD solution would be excellent, but so far I haven't found one. The intent here is to be able to create an Access database file on my FreeBSD box that can then be transferred to another location for processing via MS Access. I suppose at delimited file could be used in a pinch, but an MDB file would be better. I realize that MySQL or Postgres can provide client/server access, but that just isn't what's needed in this one case. Thanks for the help! --------------------------------------------------------- Ralph Hughes rhughes@anteon.com Systems Engineering Anteon, Corp. Montgomery, Al To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 11:58:01 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA18623 for freebsd-database-outgoing; Fri, 30 Oct 1998 11:58:01 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from NIH2WAAE (smtp5.site1.csi.com [149.174.183.74]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA18608 for ; Fri, 30 Oct 1998 11:57:59 -0800 (PST) (envelope-from berend@pobox.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Fri, 30 Oct 1998 14:57:50 -0500 Received: from auke.deboer (lon-c45-014-vty165.as.wcom.net [195.232.8.165]) by hil-img-ims-1.compuserve.com (8.8.6/8.8.6/IMS-1.6) with ESMTP id OAA26223 for ; Fri, 30 Oct 1998 14:57:25 -0500 (EST) Received: from bmach (bmach.deboer [192.168.33.3]) by auke.deboer (8.8.8/8.8.7) with SMTP id UAA01917 for ; Fri, 30 Oct 1998 20:53:39 +0100 (CET) (envelope-from berend@pobox.com) Received: by localhost with Microsoft MAPI; Fri, 30 Oct 1998 20:53:36 +0100 Message-ID: <01BE0447.5D565280.berend@pobox.com> From: Berend de Boer To: "'freebsd-database@freebsd.org'" Subject: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Date: Fri, 30 Oct 1998 20:53:35 +0100 Organization: NederWare X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hai All, For my first FreeBSD database implementation I want to use either DB2 or Interbase, of course the Linux versions as there is no FreeBSD version of a commercial database I believe. Has anyone experience with them? Or can someone recommend a different solution? Environment: two simultaneous users, running Win95. Client developed with Delphi 3.0. Will be traditional 2-tier system. Server: Pentium 233Mhz, 128MB, SCSI-3, 4GB disk. It's not a demanding environment. Solutions should be cheap (i.e. 250$-$1000 for db with 2 user licence). And most importantly, it should require absolutely no maintainance and be very robust. I'm a busy guy, this db should just run. Groetjes, Berend. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 15:12:12 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id PAA07579 for freebsd-database-outgoing; Fri, 30 Oct 1998 15:12:12 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from vip.consys.com (Comobabi.ConSys.COM [209.141.107.6]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id PAA07572 for ; Fri, 30 Oct 1998 15:12:05 -0800 (PST) (envelope-from rcarter@pinyon.org) Received: (from pinyon@localhost) by vip.consys.com (8.9.1/8.9.1) id QAA06776; Fri, 30 Oct 1998 16:11:45 -0700 (MST) Date: Fri, 30 Oct 1998 16:11:45 -0700 (MST) From: "Russell L. Carter" Message-Id: <199810302311.QAA06776@vip.consys.com> To: berend@pobox.com Subject: Re: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Cc: database@FreeBSD.ORG In-Reply-To: <01BE0447.5D565280.berend@pobox.com> Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk | |For my first FreeBSD database implementation I want to use either DB2 or |Interbase, of course the Linux versions as there is no FreeBSD version of a |commercial database I believe. | |Has anyone experience with them? | |Or can someone recommend a different solution? | I researched the same question over the summer and settled on MySQL. It is up and running for the last couple of months backing a few web sites, though not very heavily loaded, but has not once hiccuped. (mod_perl->DBI->mysql) www.tcx.se Russell | | |Environment: two simultaneous users, running Win95. Client developed with |Delphi 3.0. Will be traditional 2-tier system. | |Server: Pentium 233Mhz, 128MB, SCSI-3, 4GB disk. | |It's not a demanding environment. | |Solutions should be cheap (i.e. 250$-$1000 for db with 2 user licence). And |most importantly, it should require absolutely no maintainance and be very |robust. I'm a busy guy, this db should just run. | | |Groetjes, | |Berend. | | | | |To Unsubscribe: send mail to majordomo@FreeBSD.org |with "unsubscribe freebsd-database" in the body of the message | To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 17:06:57 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA19836 for freebsd-database-outgoing; Fri, 30 Oct 1998 17:06:57 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from pike.cdrom.com (pike.cdrom.com [204.216.28.222]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA19812 for ; Fri, 30 Oct 1998 17:06:53 -0800 (PST) (envelope-from rab@pike.cdrom.com) Received: from pike.cdrom.com (localhost.cdrom.com [127.0.0.1]) by pike.cdrom.com (8.9.1a/8.9.1) with ESMTP id BAA10842; Sat, 31 Oct 1998 01:08:23 GMT Message-Id: <199810310108.BAA10842@pike.cdrom.com> To: "Russell L. Carter" cc: berend@pobox.com, database@FreeBSD.ORG, rab@pike.cdrom.com Subject: Re: Database for FreeBSD 2.2.X: DB2 or Interbase possible? In-reply-to: Your message of "Fri, 30 Oct 1998 16:11:45 MST." <199810302311.QAA06776@vip.consys.com> Date: Fri, 30 Oct 1998 17:08:23 -0800 From: "Robert A. Bruce" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk "Russell L. Carter" said... >| >|For my first FreeBSD database implementation I want to use either DB2 or >|Interbase, of course the Linux versions as there is no FreeBSD version of a >|commercial database I believe. >| >|Has anyone experience with them? >| >|Or can someone recommend a different solution? >| > >I researched the same question over the summer and settled on >MySQL. It is up and running for the last couple of months >backing a few web sites, though not very heavily loaded, but >has not once hiccuped. (mod_perl->DBI->mysql) > >www.tcx.se We use MySQL for www.cdrom.com and www.freebsdmall.com, and are very happy with it. It is fast and reliable. There are some limitation, such as no rollback/commit, but that isn't a problem for us. It runs a litte better under FreeBSD 3.0 than with 2.2.7 because it can use native threads. -bob To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 21:45:12 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA15260 for freebsd-database-outgoing; Fri, 30 Oct 1998 21:45:12 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA15250 for ; Fri, 30 Oct 1998 21:45:09 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zZTFv-0001Un-00; Fri, 30 Oct 1998 21:07:19 -0800 Date: Fri, 30 Oct 1998 21:07:17 -0800 (PST) From: Tom To: Berend de Boer cc: "'freebsd-database@freebsd.org'" Subject: Re: Database for FreeBSD 2.2.X: DB2 or Interbase possible? In-Reply-To: <01BE0447.5D565280.berend@pobox.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 30 Oct 1998, Berend de Boer wrote: > Hai All, > > For my first FreeBSD database implementation I want to use either DB2 or > Interbase, of course the Linux versions as there is no FreeBSD version of a > commercial database I believe. > > Has anyone experience with them? > > Or can someone recommend a different solution? > > > > Environment: two simultaneous users, running Win95. Client developed with > Delphi 3.0. Will be traditional 2-tier system. > > Server: Pentium 233Mhz, 128MB, SCSI-3, 4GB disk. > > It's not a demanding environment. > > Solutions should be cheap (i.e. 250$-$1000 for db with 2 user licence). And > most importantly, it should require absolutely no maintainance and be very > robust. I'm a busy guy, this db should just run. > > > Groetjes, > > Berend. Solid from www.solidtech.com A version for two users will be really cheap. Low maintenance. Supports online backup (mysql for example, blocks all updates during a backup), and is fully relational (mysql is not relational because it does not support transactions). The ODBC client for Windows 95 is really nice. Mysql ODBC for Windows can be iffy. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 23:44:21 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA25048 for freebsd-database-outgoing; Fri, 30 Oct 1998 23:44:21 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from NIH2WAAE (smtp5.site1.csi.com [149.174.183.74]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA25043 for ; Fri, 30 Oct 1998 23:44:20 -0800 (PST) (envelope-from berend@pobox.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Sat, 31 Oct 1998 02:44:17 -0500 Received: from auke.deboer (lon-c45-036-vty234.as.wcom.net [195.232.19.234]) by hil-img-ims-1.compuserve.com (8.8.6/8.8.6/IMS-1.6) with ESMTP id CAA12447 for ; Sat, 31 Oct 1998 02:43:38 -0500 (EST) Received: from bmach (bmach.deboer [192.168.33.3]) by auke.deboer (8.8.8/8.8.7) with SMTP id IAA05384 for ; Sat, 31 Oct 1998 08:42:02 +0100 (CET) (envelope-from berend@pobox.com) Received: by localhost with Microsoft MAPI; Sat, 31 Oct 1998 08:42:01 +0100 Message-ID: <01BE04AA.53FCA410.berend@pobox.com> From: Berend de Boer To: "'freebsd-database@freebsd.org'" Subject: FW: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Date: Sat, 31 Oct 1998 08:42:00 +0100 Organization: NederWare X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Saturday, October 31, 1998 2:08 AM, Robert A. Bruce [SMTP:rab@pike.cdrom.com] wrote: > We use MySQL for www.cdrom.com and www.freebsdmall.com, and > are very happy with it. It is fast and reliable. There are > some limitation, such as no rollback/commit, but that isn't > a problem for us. It runs a litte better under FreeBSD 3.0 > than with 2.2.7 because it can use native threads. No rollback/commit is a real problem. I'm to spoiled with good relational databases to give that up :-) Groetjes, Berend. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Oct 30 23:46:01 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA25144 for freebsd-database-outgoing; Fri, 30 Oct 1998 23:46:01 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from NIH2WAAF (smtp6.site1.csi.com [149.174.183.75]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA25139 for ; Fri, 30 Oct 1998 23:45:59 -0800 (PST) (envelope-from berend@pobox.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Sat, 31 Oct 1998 02:45:55 -0500 Received: from auke.deboer (lon-c45-036-vty234.as.wcom.net [195.232.19.234]) by hil-img-ims-1.compuserve.com (8.8.6/8.8.6/IMS-1.6) with ESMTP id CAA12656; Sat, 31 Oct 1998 02:45:10 -0500 (EST) Received: from bmach (bmach.deboer [192.168.33.3]) by auke.deboer (8.8.8/8.8.7) with SMTP id IAA05395; Sat, 31 Oct 1998 08:43:53 +0100 (CET) (envelope-from berend@pobox.com) Received: by localhost with Microsoft MAPI; Sat, 31 Oct 1998 08:43:52 +0100 Message-ID: <01BE04AA.96136F00.berend@pobox.com> From: Berend de Boer To: "'Tom'" Cc: "'freebsd-database@freebsd.org'" Subject: RE: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Date: Sat, 31 Oct 1998 08:43:51 +0100 Organization: NederWare X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Saturday, October 31, 1998 6:07 AM, Tom [SMTP:tom@sdf.com] wrote: > Solid from www.solidtech.com A version for two users will be really > cheap. Low maintenance. Supports online backup (mysql for example, > blocks all updates during a backup), and is fully relational (mysql is not > relational because it does not support transactions). The ODBC client for > Windows 95 is really nice. Mysql ODBC for Windows can be iffy. I'll take a look at it, although I doubt I will use it. Most RDBMS take quite some time to know them well. As I don't know this product I don't know which queries work, how well the optimizer is, etc. But thanks for the tip. Groetjes, Berend. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Oct 31 00:12:35 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id AAA27396 for freebsd-database-outgoing; Sat, 31 Oct 1998 00:12:35 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from superior.mooseriver.com (superior.mooseriver.com [208.138.27.81]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id AAA27391 for ; Sat, 31 Oct 1998 00:12:33 -0800 (PST) (envelope-from jgrosch@superior.mooseriver.com) Received: (from jgrosch@localhost) by superior.mooseriver.com (8.8.8/8.8.8) id AAA22196; Sat, 31 Oct 1998 00:12:29 -0800 (PST) (envelope-from jgrosch) Message-ID: <19981031001229.A22167@mooseriver.com> Date: Sat, 31 Oct 1998 00:12:29 -0800 From: Josef Grosch To: Berend de Boer , "'freebsd-database@freebsd.org'" Subject: Re: FW: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Reply-To: jgrosch@mooseriver.com References: <01BE04AA.53FCA410.berend@pobox.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.1i In-Reply-To: <01BE04AA.53FCA410.berend@pobox.com>; from Berend de Boer on Sat, Oct 31, 1998 at 08:42:00AM +0100 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, Oct 31, 1998 at 08:42:00AM +0100, Berend de Boer wrote: > On Saturday, October 31, 1998 2:08 AM, Robert A. Bruce [SMTP:rab@pike.cdrom.com] wrote: > > > We use MySQL for www.cdrom.com and www.freebsdmall.com, and > > are very happy with it. It is fast and reliable. There are > > some limitation, such as no rollback/commit, but that isn't > > a problem for us. It runs a litte better under FreeBSD 3.0 > > than with 2.2.7 because it can use native threads. > > No rollback/commit is a real problem. I'm to spoiled with good relational > databases to give that up :-) MySQL is a very good database but it does have it's problems. No rollback/commit is just one of them. It also does not support "select into", triggers and stored procedures. The authors are working on "select into" but they do not see the value of triggers and don't seem to be much interested in stored procedures. Josef -- Josef Grosch | Another day closer to a | FreeBSD 3.0 jgrosch@MooseRiver.com | Micro$oft free world | UNIX for the masses To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Oct 31 01:04:29 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id BAA00404 for freebsd-database-outgoing; Sat, 31 Oct 1998 01:04:29 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from NIH2WAAF (smtp6.site1.csi.com [149.174.183.75]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id BAA00399 for ; Sat, 31 Oct 1998 01:04:28 -0800 (PST) (envelope-from berend@pobox.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Sat, 31 Oct 1998 04:04:24 -0500 Received: from auke.deboer (lon-c45-040-vty183.as.wcom.net [195.232.21.183]) by hil-img-ims-1.compuserve.com (8.8.6/8.8.6/IMS-1.6) with ESMTP id EAA21999 for ; Sat, 31 Oct 1998 04:04:00 -0500 (EST) Received: from bmach (bmach.deboer [192.168.33.3]) by auke.deboer (8.8.8/8.8.7) with SMTP id KAA23191 for ; Sat, 31 Oct 1998 10:01:26 +0100 (CET) (envelope-from berend@pobox.com) Received: by localhost with Microsoft MAPI; Sat, 31 Oct 1998 10:01:24 +0100 Message-ID: <01BE04B5.6AD46A50.berend@pobox.com> From: Berend de Boer To: "'freebsd-database@freebsd.org'" Subject: RE: FW: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Date: Sat, 31 Oct 1998 10:01:22 +0100 Organization: NederWare X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Saturday, October 31, 1998 9:12 AM, Josef Grosch [SMTP:jgrosch@mooseriver.com] wrote: > MySQL is a very good database but it does have it's problems. No > rollback/commit is just one of them. It also does not support "select > into", triggers and stored procedures. The authors are working on "select > into" but they do not see the value of triggers and don't seem to be much > interested in stored procedures. No triggers, no stored procs, and still getting a high performance for a 2-tier environment??? I just downloaded solid, looks nice. I'll do some tests, but I just feel more easy with a db I know. Groetjes, Berend. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Oct 31 10:18:57 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA26903 for freebsd-database-outgoing; Sat, 31 Oct 1998 10:18:57 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id KAA26884 for ; Sat, 31 Oct 1998 10:18:54 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zZf1L-0002NR-00; Sat, 31 Oct 1998 09:41:03 -0800 Date: Sat, 31 Oct 1998 09:41:03 -0800 (PST) From: Tom To: Berend de Boer cc: "'freebsd-database@freebsd.org'" Subject: RE: Database for FreeBSD 2.2.X: DB2 or Interbase possible? In-Reply-To: <01BE04AA.96136F00.berend@pobox.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 31 Oct 1998, Berend de Boer wrote: > On Saturday, October 31, 1998 6:07 AM, Tom [SMTP:tom@sdf.com] wrote: > > > Solid from www.solidtech.com A version for two users will be really > > cheap. Low maintenance. Supports online backup (mysql for example, > > blocks all updates during a backup), and is fully relational (mysql is > not > > relational because it does not support transactions). The ODBC client > for > > Windows 95 is really nice. Mysql ODBC for Windows can be iffy. > > I'll take a look at it, although I doubt I will use it. Most RDBMS take > quite some time to know them well. As I don't know this product I don't > know which queries work, how well the optimizer is, etc. You'd be surprised about Solid. Very quick to get going. SQL is very conforming. > But thanks for the tip. > > Groetjes, > > Berend. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Oct 31 10:42:30 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA29206 for freebsd-database-outgoing; Sat, 31 Oct 1998 10:42:30 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from subcellar.mwci.net (subcellar.mwci.net [205.254.160.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA29201 for ; Sat, 31 Oct 1998 10:42:28 -0800 (PST) (envelope-from jbutt@mwci.net) Received: from noc-6.dbqoffice.mwci.net (noc-6.dbqoffice.mwci.net [207.142.159.33]) by subcellar.mwci.net (8.8.8/8.8.7) with ESMTP id MAA27710; Sat, 31 Oct 1998 12:42:12 -0600 (CST) Date: Sat, 31 Oct 1998 12:42:12 -0600 (CST) From: James Butt X-Sender: jbutt@noc-6.dbqoffice.mwci.net To: Tom cc: Berend de Boer , "'freebsd-database@freebsd.org'" Subject: RE: Database for FreeBSD 2.2.X: DB2 or Interbase possible? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > > Solid from www.solidtech.com A version for two users will be really > > > cheap. Low maintenance. Supports online backup (mysql for example, > > > blocks all updates during a backup), and is fully relational (mysql is > > not > > > relational because it does not support transactions). The ODBC client > > for > > > Windows 95 is really nice. Mysql ODBC for Windows can be iffy. > > > > I'll take a look at it, although I doubt I will use it. Most RDBMS take > > quite some time to know them well. As I don't know this product I don't > > know which queries work, how well the optimizer is, etc. > > You'd be surprised about Solid. Very quick to get going. SQL is very > conforming. > Yes.. Solid == Good!! We are very happy with solid. -------------------------------------------------------------------------- James D. Butt 'J.D.' Network Engineer Voice 319-557-8463 Network Operations Center Fax 319-557-9771 MidWest Communications, Inc. Pager 319-557-6347 241 Main St. noc@mwci.net Dubuque, IA 52001 jbutt@mwci.net -------------------------------------------------------------------------- Drive defensively Buy a tank. FreeBSD: The power to serve! www.freebsd.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message