From owner-freebsd-database Tue Oct 3 8: 7:15 2000 Delivered-To: freebsd-database@freebsd.org Received: from osiris.ipform.ru (osiris.ipform.ru [212.158.165.98]) by hub.freebsd.org (Postfix) with ESMTP id AB7ED37B503; Tue, 3 Oct 2000 08:07:02 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e93F6H805884; Tue, 3 Oct 2000 19:06:19 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <00c301c02d4b$7d445040$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "xuyifeng" , "Dan Nelson" Cc: , References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929095555.A14858@dan.emsphone.com> <00dd01c02ac4$8280a740$0c00a8c0@ipform.ru> <20000930142736.A13227@dan.emsphone.com> <006201c02d3a$ddd12c00$1801a8c0@xyf> Subject: Re: Where is Berkley DB libdb? Date: Tue, 3 Oct 2000 19:06:16 +0400 Organization: IP Form MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG So, lets get to it onces again. Given: db file created with 2.7.0 os Linux Slackware FreeBSD 4.1.1-stable with 1.85 included in libc (damn it, get it out of there!) perl 5.005_03 on FreeBSD host DB_File which comes with perl Need to accomplish: read that db file on FreeBSD host Problems: cannot read that db file on FreeBSD host Solution: install db 2.7.7 from ports install DB_File 1.73 from CPAN (supposed to support db up to 3.x) try to build DB_File linked agains the 2.7.7 version of DB: 1) perl Makefile.PL complains: Note (probably harmless): No library found for -ldb 2) try a little hack and make a link from db2 to db still 'Note (probably harmless): No library found for -ldb' 3) hell with it, open generate Makefile, add -ldb2 to LDFLAGS make make test make install try to open the - no luck , which means db lib is still taken from libc I do not understand how to make DB_File use db 2.7.7 instead of 1.85 built in in libc. Result: somebody needs to do something about it Artem ----- Original Message ----- From: "xuyifeng" To: "Dan Nelson" ; "Artem Koutchine" Cc: ; Sent: Tuesday, October 03, 2000 4:54 PM Subject: Re: Where is Berkley DB libdb? > Anyway, Berkeley DB shouldn't be included in libc, it is a stupid design, > it causes problem, sucks. but I suspect it is difficult to simply split dblib > from libc, this may breaks many FreeBSD things. > > XuYifeng > > ----- Original Message ----- > From: Dan Nelson > To: Artem Koutchine > Cc: ; > Sent: Sunday, October 01, 2000 3:27 AM > Subject: Re: Where is Berkley DB libdb? > > > > In the last episode (Sep 30), Artem Koutchine said: > > > From: "Dan Nelson" > > > > In the last episode (Sep 29), Artem Koutchine said: > > > > > 3) How can i avoid all this mess and make every single executable > > > > > use the version i have installed (2.7.7). > > > > > > > > If you really want to use a single version of DB across the board, use > > > > DB 3.1.17 (it's in ports). > > > > > > >From questions (1) and (2) the conclusion is that i cannot make my system > > > use any other version but the one compiled in libc (somebody compiled > > > libdb into libc statically, sux). > > > > Sure you can. Berkeley DB versions 1, 2, and 3 all use completely > > different function calls. V1 uses dbopen(), V2 uses db_open(), v3 uses > > db_create(). They don't interfere with each other. libc provides DB > > 1.85. If you want db2 or db3, you'll need to manually link in that > > library and make sure you use either db_open() or db_create() to access > > your datbase files. > > > > > > > All this is causing me a lot of trouble, because DB_File cannot > > > > > access db files created on Linux (Mandrake 7.1 and some version of > > > > > Slackware, i think it is latest). I have multi-os development office, > > > > > so, no os wars. > > > > > > > > I'd say the answer is "don't do that" :) Rebuild your DB file from the > > > > source file on each machine you use it on, or switch to a client-server > > > > databse like mysql. > > > > > > Mysql is used here and it's ok. DB is used for low level tasks. Could > > > please explain why i shouldn't do that? > > > > I said that thinking that maybe DB files created on Linux might not > > work on FreeBSD. After looking at the docs for DB3.1, it looks like > > the database files should be portable across all systems DB3.1 > > supports. > > > > -- > > Dan Nelson > > dnelson@emsphone.com > > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > > with "unsubscribe freebsd-questions" 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 3 8:26: 2 2000 Delivered-To: freebsd-database@freebsd.org Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by hub.freebsd.org (Postfix) with ESMTP id 7BFD437B66D; Tue, 3 Oct 2000 08:25:59 -0700 (PDT) Received: (from dan@localhost) by dan.emsphone.com (8.9.3/8.9.3) id KAA18641; Tue, 3 Oct 2000 10:25:40 -0500 (CDT) (envelope-from dan) Date: Tue, 3 Oct 2000 10:25:40 -0500 From: Dan Nelson To: Artem Koutchine Cc: xuyifeng , questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Where is Berkley DB libdb? Message-ID: <20001003102539.B8413@dan.emsphone.com> References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929095555.A14858@dan.emsphone.com> <00dd01c02ac4$8280a740$0c00a8c0@ipform.ru> <20000930142736.A13227@dan.emsphone.com> <006201c02d3a$ddd12c00$1801a8c0@xyf> <00c301c02d4b$7d445040$0c00a8c0@ipform.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline User-Agent: Mutt/1.3.9i In-Reply-To: <00c301c02d4b$7d445040$0c00a8c0@ipform.ru>; from "Artem Koutchine" on Tue Oct 3 19:06:16 GMT 2000 X-OS: FreeBSD 5.0-CURRENT Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG In the last episode (Oct 03), Artem Koutchine said: > Solution: > install db 2.7.7 from ports > install DB_File 1.73 from CPAN (supposed to support db up to 3.x) > try to build DB_File linked agains the 2.7.7 version of DB: > 1) perl Makefile.PL complains: > Note (probably harmless): No library found for -ldb > 2) try a little hack and make a link from db2 to db > still 'Note (probably harmless): No library found for -ldb' > 3) hell with it, open generate Makefile, add -ldb2 to LDFLAGS > make > make test > make install > try to open the - no luck , which means db lib is still taken from libc Most likely, it means you are still using the DF_File that came with the system. Try removing /usr/libdata/perl/5.6.0/mach/auto/DB_File/ and /usr/libdata/perl/5.6.0/mach/DB_File.pm . This is really more of a perl module-compiling problem than a FreeBSD one. -- Dan Nelson dnelson@emsphone.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Oct 3 11:34:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from osiris.ipform.ru (osiris.ipform.ru [212.158.165.98]) by hub.freebsd.org (Postfix) with ESMTP id A3DFE37B66C; Tue, 3 Oct 2000 11:34:10 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e93IXB806561; Tue, 3 Oct 2000 22:33:11 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <004001c02d68$66262b00$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Dan Nelson" Cc: "xuyifeng" , , References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929095555.A14858@dan.emsphone.com> <00dd01c02ac4$8280a740$0c00a8c0@ipform.ru> <20000930142736.A13227@dan.emsphone.com> <006201c02d3a$ddd12c00$1801a8c0@xyf> <00c301c02d4b$7d445040$0c00a8c0@ipform.ru> <20001003102539.B8413@dan.emsphone.com> Subject: Re: Where is Berkley DB libdb? Date: Tue, 3 Oct 2000 22:33:09 +0400 Organization: IP Form MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG From: "Dan Nelson" > In the last episode (Oct 03), Artem Koutchine said: > > Solution: > > install db 2.7.7 from ports > > install DB_File 1.73 from CPAN (supposed to support db up to 3.x) > > try to build DB_File linked agains the 2.7.7 version of DB: > > 1) perl Makefile.PL complains: > > Note (probably harmless): No library found for -ldb > > 2) try a little hack and make a link from db2 to db > > still 'Note (probably harmless): No library found for -ldb' > > 3) hell with it, open generate Makefile, add -ldb2 to LDFLAGS > > make > > make test > > make install > > try to open the - no luck , which means db lib is still taken from libc > > Most likely, it means you are still using the DF_File that came with > the system. Try removing /usr/libdata/perl/5.6.0/mach/auto/DB_File/ > and /usr/libdata/perl/5.6.0/mach/DB_File.pm . Nope, i checked, there is only ONE DB_File on my system and it is excatly the same which i have installed from CPAN. > This is really more of a > perl module-compiling problem than a FreeBSD one. Oh, i see. What bothers me is that this perl mode-compling problem happens only on RedHat and on FreeBSD. Here is what i got from developers: # Impractical. # # Several important libc functions depend on having databases # available. Something which exports an ndbm-compatible interface is # required by SUSv3/POSIX.1-200x. The on-disk file formats are in any # case incompatible between db 1.x and db y.x for all y > 1. # # -GAWollman Artem To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Oct 4 19:58:14 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 3897337B503; Wed, 4 Oct 2000 19:58:09 -0700 (PDT) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13h0rC-0007cu-00; Wed, 4 Oct 2000 19:34:02 -0700 Date: Wed, 4 Oct 2000 19:33:57 -0700 (PDT) From: Tom Samplonius To: Artem Koutchine Cc: xuyifeng , Dan Nelson , questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Where is Berkley DB libdb? In-Reply-To: <00c301c02d4b$7d445040$0c00a8c0@ipform.ru> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Tue, 3 Oct 2000, Artem Koutchine wrote: > So, lets get to it onces again. > > Given: > db file created with 2.7.0 os Linux Slackware > FreeBSD 4.1.1-stable with 1.85 included in libc (damn it, get it out of I'm under the impression that db files created with versions prior to version 3.something are not cross-platform, so I doubt that this will ever work unless you use 3.1 everywhere. 3.1 co-exists with previous versions better than any previous version because the default install location is /usr/local/BerkeleyDB.3.1. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Oct 5 2:27:30 2000 Delivered-To: freebsd-database@freebsd.org Received: from osiris.ipform.ru (osiris.ipform.ru [212.158.165.98]) by hub.freebsd.org (Postfix) with ESMTP id C5B0937B503; Thu, 5 Oct 2000 02:27:24 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e959QP838181; Thu, 5 Oct 2000 13:26:26 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <008301c02eae$5d194be0$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Tom Samplonius" Cc: "xuyifeng" , "Dan Nelson" , , References: Subject: Cannot use any other BDB than builtin Berkeley DB Date: Thu, 5 Oct 2000 13:26:22 +0400 Organization: IP Form MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG From: "Tom Samplonius" > On Tue, 3 Oct 2000, Artem Koutchine wrote: > > > So, lets get to it onces again. > > > > Given: > > db file created with 2.7.0 os Linux Slackware > > FreeBSD 4.1.1-stable with 1.85 included in libc (damn it, get it out of > > I'm under the impression that db files created with versions prior to > version 3.something are not cross-platform, so I doubt that this will ever > work unless you use 3.1 everywhere. 3.1 co-exists with previous versions > better than any previous version because the default install location is > /usr/local/BerkeleyDB.3.1. Well, we have installed BDB 3.1.14 on the linux box (Mandrake 7.1) and 3.1.17 on FreeBSD (4.1.1-stable) from the ports. Then Installed DB_File perl module version 1.73 on linux and then install the same DB_File (the same sources from CPAN) on FreeBSD. Building DB_File on freebsd complained that library for -ldb not found, but build anyway and installed. Rebuilt the db file from a text file on FreeBSD and got the same db file as it was for 1.85 (built in libc). Well, then we rebuilt DB_File again, specifing in Makefile -ldb3 and /L/usr/local/lib manually. It built okay. Rebuilt db file and got the same db file again as for 1.85, anyway, tried reading db2 file created on linux - guess what, no luck. SO! HOW THE HECK DO I INSTALL ANS *USE* Berkeley DB OTHER THAN 1.85 BUILT IN LIBC? Artem To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Oct 5 9:40:31 2000 Delivered-To: freebsd-database@freebsd.org Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by hub.freebsd.org (Postfix) with ESMTP id BF15637B502; Thu, 5 Oct 2000 09:40:25 -0700 (PDT) Received: (from dan@localhost) by dan.emsphone.com (8.11.1/8.9.3) id e95Gdgk07243; Thu, 5 Oct 2000 11:39:42 -0500 (CDT) (envelope-from dan) Date: Thu, 5 Oct 2000 11:39:42 -0500 From: Dan Nelson To: Artem Koutchine Cc: Tom Samplonius , xuyifeng , questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Cannot use any other BDB than builtin Berkeley DB Message-ID: <20001005113942.A5389@dan.emsphone.com> References: <008301c02eae$5d194be0$0c00a8c0@ipform.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline User-Agent: Mutt/1.3.9i In-Reply-To: <008301c02eae$5d194be0$0c00a8c0@ipform.ru>; from "Artem Koutchine" on Thu Oct 5 13:26:22 GMT 2000 X-OS: FreeBSD 5.0-CURRENT Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG In the last episode (Oct 05), Artem Koutchine said: > Well, then we rebuilt DB_File again, specifing in Makefile -ldb3 and > -L/usr/local/lib manually. It built okay. Rebuilt db file and got the > same db file again as for 1.85, anyway, tried reading db2 file > created on linux - guess what, no luck. > > SO! HOW THE HECK DO I INSTALL ANS *USE* > Berkeley DB OTHER THAN 1.85 BUILT IN LIBC? Try also adding -DCOMPAT185. This is still a perl module problem. DB_File's configure script is broken. It should really have an explicit switch saying "I will be linking with berkeley db ##", but all it does is guess, and guess badly. -- Dan Nelson dnelson@emsphone.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Oct 5 20: 4:29 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 7E53F37B502; Thu, 5 Oct 2000 20:04:25 -0700 (PDT) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13hNPk-0001MU-00; Thu, 5 Oct 2000 19:39:12 -0700 Date: Thu, 5 Oct 2000 19:38:39 -0700 (PDT) From: Tom Samplonius To: xuyifeng Cc: Artem Koutchine , questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Cannot use any other BDB than builtin Berkeley DB In-Reply-To: <003101c02ec9$b8eb33a0$1801a8c0@xyf> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 5 Oct 2000, xuyifeng wrote: > sigh, why do FreeBSD have such stupid design? > Regards, > XuYifeng How exactly is this a FreeBSD problem? There are three different DB APIs. The rather stupid DB_File perl module tries to use whatever API it thinks you might want, and doesn't seem to look in the default locations for any of the libraries. Tom 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 6 1: 7:40 2000 Delivered-To: freebsd-database@freebsd.org Received: from osiris.ipform.ru (osiris.ipform.ru [212.158.165.98]) by hub.freebsd.org (Postfix) with ESMTP id F336A37B66C; Fri, 6 Oct 2000 01:07:33 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e9687B841705; Fri, 6 Oct 2000 12:07:12 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <004d01c02f6c$6f0d7420$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Tom Samplonius" , "xuyifeng" Cc: , References: Subject: Re: Cannot use any other BDB than builtin Berkeley DB Date: Fri, 6 Oct 2000 12:02:17 +0400 Organization: IP Form MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Okay, I will be very glad to think that DB_File is a stupid silly perl module which does not know how to link to the need library. The problem is that i cannot tell it to link to what i need. Would anyone else please try to do what i am trying to do. I need some input here. Artem ----- Original Message ----- From: "Tom Samplonius" To: "xuyifeng" Cc: "Artem Koutchine" ; ; Sent: Friday, October 06, 2000 6:38 AM Subject: Re: Cannot use any other BDB than builtin Berkeley DB > > On Thu, 5 Oct 2000, xuyifeng wrote: > > > sigh, why do FreeBSD have such stupid design? > > Regards, > > XuYifeng > > How exactly is this a FreeBSD problem? There are three different DB > APIs. The rather stupid DB_File perl module tries to use whatever API it > thinks you might want, and doesn't seem to look in the default locations > for any of the libraries. > > Tom > > Tom > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message