From owner-freebsd-database Tue Sep 26 9:10:15 2000 Delivered-To: freebsd-database@freebsd.org Received: from gg.burdadigital.com (mail.incubate.de [212.14.77.2]) by hub.freebsd.org (Postfix) with ESMTP id C14E037B424 for ; Tue, 26 Sep 2000 09:10:05 -0700 (PDT) Received: by gg.burdadigital.com (8.9.3/8.9.3) id SAA06861; Tue, 26 Sep 2000 18:12:48 +0200 (CEST) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Tue Sep 26 18:12:48 2000 From: Imdat Solak To: Cc: Subject: Bug in PHP4 accessing Sybase with freetds Date: Tue, 26 Sep 2000 18:08:03 +0200 Message-Id: <19340821093947.27766@mail.bd.intern> In-Reply-To: <20000803161257.26001@mail.bd.intern> References: <20000803161257.26001@mail.bd.intern> X-Mailer: CTM PowerMail 3.0.5 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello, couple of people reported that there is a bug accessing Sybase by using PHP4.0.1pl1 with freetds on FreeBSD 3.4 with Apache. Namely, Apache crashes with a "Segmentation fault" when you do a DELETE, INSERT or UPDATE in the Sybase DB. The crash happens only after successfull DELETE, INSERT or UPDATE statements, i.e. if there was a DB-error (cannot delete, insert or update), then Apache doesn't crash. I followed the bug and found first a workaround and second a solution, which works on my site. As not everybody is interested in this topic, I put the doc describing the solution on my site: http://www.imdat.de/php/sybase_php_freetds_bug.txt I will send this to PHP.NET and to the freetds-guys, too, as the bug is in both, freetds AND php4 (I also checked PHP4.0.2, it still has the same bug). Hope to have helped best imdat -- Imdat Solak Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Sep 27 5: 6:44 2000 Delivered-To: freebsd-database@freebsd.org Received: from alpha1.dlinc.com (alpha1.dlinc.com [208.128.117.6]) by hub.freebsd.org (Postfix) with ESMTP id 35A0037B42C for ; Wed, 27 Sep 2000 05:06:34 -0700 (PDT) Received: from dice.com (grpwise.dlinc.com [208.160.60.2]) by alpha1.dlinc.com (8.9.3/8.9.3) with SMTP id HAA16134 for ; Wed, 27 Sep 2000 07:05:27 -0500 (CDT) Received: from D_and_L_Online-Message_Server by dice.com with Novell_GroupWise; Wed, 27 Sep 2000 07:06:29 -0500 Message-Id: X-Mailer: Novell GroupWise 5.2 Date: Wed, 27 Sep 2000 07:06:05 -0500 From: "Kevin Riggins" To: freebsd-database@freebsd.org Subject: Oracle 8.1.6 install on FreeBSD 4.1.1 Stable..... Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello people, Has anyone had any success installing Oracle 8.1.6 for Linux on FreeBSD = 4.1.1. I keep getting an error when the jre tries to start up. Output = from runInstaller follows: Any help much appreciated, Kevin Riggins Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1= .1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... ldt_clear: modify_ldt: Function not implemented ldt_setup: modify_ldt: Function not implemented SIGSEGV received at bfbff240 in /usr/local/src/oracle/stage/Components/orac= le.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads/libjav= a.so. Processing terminated Wed Sep 27 17:12:09 2000 jre full version "JDK 1.1.8 IBM build l118-20000429 (JIT enabled: jitc)" Operating Environment --------------------- Host : stonefoot.courtave.net. OS Level : 2.2.12.FreeBSD 4.1.1-STABLE #0: Tue Sep 26 17:53:13 CDT = 2000 root@s glibc Version : 2.1.2 No. of Procs : 1 Memory Info: error obtaining mem info User Limits (in bytes except for NOFILE and NPROC) - RLIMIT_FSIZE : infinity RLIMIT_DATA : 536870912 RLIMIT_STACK : 2088960 RLIMIT_CORE : 1024000000 RLIMIT_NOFILE : 1064 RLIMIT_NPROC : 531 Application Environment ----------------------- Signal Handlers - SIGQUIT : ignored SIGILL : sysThreadIDump (libjava.so) SIGABRT : sysThreadIDump (libjava.so) SIGFPE : sysThreadIDump (libjava.so) SIGBUS : sysThreadIDump (libjava.so) SIGSEGV : sysThreadIDump (libjava.so) SIGPIPE : ignored SIGUSR1 : doSuspendLoop (libjava.so) Environment Variables - FTP_PASSIVE_MODE=3DYES HISTSIZE=3D1000 HOSTNAME=3Dstonefoot.courtave.net LOGNAME=3Doracle ORACLE_SID=3DORCL HISTFILESIZE=3D1000 NLS_LANG=3Damerican THREADS_TYPE=3Dnative_threads MAIL=3D/var/spool/mail/oracle LD_LIBRARY_PATH=3D/usr/local/src/oracle/stage/Components/oracle.swd= .jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads:/u01/app/ora= cle/product/8.1.5/lib:/compat/linux/lib ORACLE_BASE=3D/u01/app/oracle CLASSPATH=3D/tmp/OraInstall:../stage/Components/oracle.swd.oui/1.7.= 0.18.0A/1/DataFiles/Expanded/lib/OraInstaller.jar:../stage/Components/oracl= e.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstImages.jar:../stage/Comp= onents/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstHelp.jar:../= stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/oracle= ice.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded= /lib/help.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Ex= panded/lib/ewt.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFil= es/Expanded/lib/xmlparser.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0= A/1/DataFiles/Expanded/lib/swingaccess.jar:/usr/local/src/jdk118/lib/rt.jar= :/usr/local/src/jdk118/lib/i18n.jar:/usr/local/src/jdk118/lib/math.jar:/usr= /local/src/jdk118/lib/classes.zip TERM=3Dlinux HOSTTYPE=3Di386 PATH=3D/compat/linux/bin:/compat/linux/sbin:/compat/linux/usr/bin:/= compat/linux/usr/sbin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/u01/app= /oracle/product/8.1.5/bin HOME=3D/home/oracle INPUTRC=3D/etc/inputrc SHELL=3D/compat/linux/bin/bash USER=3Doracle ORA_NLS33=3D/u01/app/oracle/product/8.1.5/ocommon/nls/admin/data BLOCKSIZE=3DK ORACLE_TERM=3D386x JAVA_HOME=3D/usr/local/src/jdk118 DISPLAY=3D208.160.60.62:0 ORACLE_HOME=3D/u01/app/oracle/product/8.1.5 OSTYPE=3DLinux SHLVL=3D1 LIBPATH=3D/usr/local/src/jdk118/lib/linux/native_threads Libraries Loaded by the JVM ---------------------------
libjitc.so Current Thread Details ---------------------- dump crashed To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Sep 27 7: 4:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from chmls06.mediaone.net (chmls06.mediaone.net [24.147.1.144]) by hub.freebsd.org (Postfix) with ESMTP id 1087437B42C for ; Wed, 27 Sep 2000 07:04:12 -0700 (PDT) Received: from ahp (h0050dac1a3dc.ne.mediaone.net [24.128.185.247]) by chmls06.mediaone.net (8.8.7/8.8.7) with SMTP id KAA29927; Wed, 27 Sep 2000 10:04:08 -0400 (EDT) From: "Allen Pulsifer" To: "Kevin Riggins" Cc: "freebsd-database@FreeBSD. ORG" , Subject: RE: Oracle 8.1.6 install on FreeBSD 4.1.1 Stable..... Date: Wed, 27 Sep 2000 10:04:17 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG > Has anyone had any success installing Oracle 8.1.6 for Linux > on FreeBSD 4.1.1. Kevin, No luck. I was having the same problem. If you substitute the FreeBSD JRE for the Linux JRE, you can get the installer to start up, but it won't install anything. I banged my head on it for a while before giving up and installing Linux. You may have some luck if you install Andrew Gallatin's patches for the Linux emulator. Enclosed is a copy of his patch announcement. Let me know if you get anywhere. Allen -----Original Message----- From: owner-freebsd-emulation@FreeBSD.ORG [mailto:owner-freebsd-emulation@FreeBSD.ORG]On Behalf Of Andrew Gallatin Sent: Friday, September 15, 2000 2:34 PM To: Gerald Pfeifer Cc: freebsd-emulation@FreeBSD.ORG; freebsd-java@FreeBSD.ORG Subject: Re: IBM JDK 1.3 now working (pointer to patches) As promised, here's a new diff for 4.0-release: http://www.cs.duke.edu/~gallatin/linux_sa_siginfo/4.0-release.diff And a new diff to the pre-smpng -current: http://www.cs.duke.edu/~gallatin/linux_sa_siginfo/diff As for -stable -- Sean O'Connell took care of that yesterday. The 4.0-release diff should (almost) apply to -stable. I don't have an up-to-date -stable tree laying around & I don't have time to make -stable diff right now. I obtained this diff by applying the patches that Sean O'Connell posted yesterday (thanks Sean) and cleaning up 2 rejects. Both have a change in that rather than hitting the thread stack problem over the head by changing the map flag to MAP_ANON from MAP_STACK, I'm now detecting the allocation of a thread stack in the region typically reserved for the main process stack and adjusting vm_maxsaddr to reflect the current stacksize resource limit. Drew To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Sep 27 7: 9: 4 2000 Delivered-To: freebsd-database@freebsd.org Received: from duke.cs.duke.edu (duke.cs.duke.edu [152.3.140.1]) by hub.freebsd.org (Postfix) with ESMTP id 426C337B422 for ; Wed, 27 Sep 2000 07:09:01 -0700 (PDT) Received: from grasshopper.cs.duke.edu (grasshopper.cs.duke.edu [152.3.145.30]) by duke.cs.duke.edu (8.9.3/8.9.3) with ESMTP id KAA10024; Wed, 27 Sep 2000 10:08:59 -0400 (EDT) Received: (from gallatin@localhost) by grasshopper.cs.duke.edu (8.11.0/8.9.1) id e8RE8xt31090; Wed, 27 Sep 2000 10:08:59 -0400 (EDT) (envelope-from gallatin@cs.duke.edu) From: Andrew Gallatin MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Wed, 27 Sep 2000 10:08:58 -0400 (EDT) To: "Allen Pulsifer" Cc: "Kevin Riggins" , "freebsd-database@FreeBSD. ORG" Subject: RE: Oracle 8.1.6 install on FreeBSD 4.1.1 Stable..... In-Reply-To: References: X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <14801.65181.173829.678713@grasshopper.cs.duke.edu> Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG My patches allow IBM's jdk 1.3 to work, not IBM's jdk 1.1.8. I think that Oracle uses IBM's jdk 1.1.8, so my patches may not help you. I wasted a morning trying to get 1.1.8 to work & got confused by some x86'isms which I don't understand (I'm mainly an alpha programmer). Since 1.1.8 is not in my critical path, I probably won't spend any more time on it. Cheers, Drew To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Sep 29 5:30:23 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 A8A0B37B423; Fri, 29 Sep 2000 05:29:43 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e8TCT3R50176; Fri, 29 Sep 2000 16:29:18 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: Cc: Subject: Where is Berkley DB libdb? Date: Fri, 29 Sep 2000 16:23:59 +0400 Organization: IP Form MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" 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 Hi! I didn't get ANY response on the first time, so i am reposting the question, in a shorter form. I could not find any libdb.* file in my 4.1-stable (cvsed weekly), so, i installed berkeley db 2.7.7 from the ports. That gave me libdb2.* I have perl package DB_File which uses berkley db and it worked before, so db IS in the system, now i installed a newer version of DB_File and it works, but i don't know what versoon of db it uses so, 1) Did someone compiled berkeley db statically into some other library (libc?) like the one on Red Hat did? not good. 2) What version of db is installed by default, how can i see it? 3) How can i avoid all this mess and make every single executable use the version i have installed (2.7.7). 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. Artem To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Sep 29 7: 4:20 2000 Delivered-To: freebsd-database@freebsd.org Received: from ulv.it.uu.se (ulv.it.uu.se [130.238.9.167]) by hub.freebsd.org (Postfix) with ESMTP id 2DC8437B423; Fri, 29 Sep 2000 07:04:15 -0700 (PDT) Received: (from ertr1013@localhost) by ulv.it.uu.se (8.8.5/8.8.5) id QAA04761; Fri, 29 Sep 2000 16:04:02 +0200 (MET DST) Date: Fri, 29 Sep 2000 16:04:02 +0200 From: Erik Trulsson To: "Artem Koutchine" Cc: , Subject: Re: Where is Berkley DB libdb? Message-ID: <20000929160401.A4637@student.uu.se> References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru>; from matrix@ipform.ru on Fri, Sep 29, 2000 at 04:23:59PM +0400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Fri, Sep 29, 2000 at 04:23:59PM +0400, Artem Koutchine wrote: > Hi! > I didn't get ANY response on the first time, so i am reposting the question, > in > a shorter form. > > I could not find any libdb.* file in my 4.1-stable (cvsed weekly), so, i > installed > berkeley db 2.7.7 from the ports. That gave me libdb2.* > I have perl package DB_File which uses berkley db and it worked before, so > db IS in the system, now i installed a newer version of DB_File and it > works, but > i don't know what versoon of db it uses > so, > 1) Did someone compiled berkeley db statically into some other library > (libc?) like > the one on Red Hat did? not good. A quick browse of the source shows that it is indeed in libc. > 2) What version of db is installed by default, how can i see it? Looking at the source it appears to be version 1.85 > 3) How can i avoid all this mess and make every single executable use the > version > i have installed (2.7.7). Probably not without a lot of problems. You would basically have to replace the system version with the new one, make world, make sure that any database files that the system use have been updated. Not for the faint of heart. (Basically, if you don't know how to check the sources to see what version of db it has you shouldn't even try this.) Note that files created with the 2.x versions of DB are *not* compatible with the older 1.x versions. > > 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. This is not really an OS problem but rather a problem with different DB versions using different file formats and newer versions not being able of handling the old formats. -- Erik Trulsson ertr1013@student.uu.se To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Sep 29 7:56: 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 AF3C937B424; Fri, 29 Sep 2000 07:55:58 -0700 (PDT) Received: (from dan@localhost) by dan.emsphone.com (8.9.3/8.9.3) id JAA24361; Fri, 29 Sep 2000 09:55:55 -0500 (CDT) (envelope-from dan) Date: Fri, 29 Sep 2000 09:55:55 -0500 From: Dan Nelson To: Artem Koutchine Cc: questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Where is Berkley DB libdb? Message-ID: <20000929095555.A14858@dan.emsphone.com> References: <037201c02a10$e72e7a00$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: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru>; from "Artem Koutchine" on Fri Sep 29 16:23:59 GMT 2000 X-OS: FreeBSD 5.0-CURRENT Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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). > 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. -- 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 Fri Sep 29 11:16:59 2000 Delivered-To: freebsd-database@freebsd.org Received: from xena.gsicomp.on.ca (cr677933-a.ktchnr1.on.wave.home.com [24.42.130.87]) by hub.freebsd.org (Postfix) with ESMTP id CCF9037B422; Fri, 29 Sep 2000 11:16:55 -0700 (PDT) Received: from localhost (matt@localhost) by xena.gsicomp.on.ca (8.10.1/8.9.2) with SMTP id e8TIGiM88928; Fri, 29 Sep 2000 14:16:44 -0400 (EDT) (envelope-from matt@xena.gsicomp.on.ca) Date: Fri, 29 Sep 2000 14:16:43 -0400 (EDT) From: Matthew Emmerton To: Erik Trulsson Cc: Artem Koutchine , questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Where is Berkley DB libdb? In-Reply-To: <20000929160401.A4637@student.uu.se> 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 Fri, 29 Sep 2000, Erik Trulsson wrote: > > 3) How can i avoid all this mess and make every single executable use the > > version > > i have installed (2.7.7). > > Probably not without a lot of problems. You would basically have to replace > the system version with the new one, make world, make sure that any > database files that the system use have been updated. Not for the faint of > heart. (Basically, if you don't know how to check the sources to see what > version of db it has you shouldn't even try this.) > > Note that files created with the 2.x versions of DB are *not* compatible with > the older 1.x versions. And to make things worse, 3.0 is not compatible with 2.x or 1.x, and 3.1 is not compatible with 3.0 or 2.x or 1.x. 3.1 is used by some newer software, such as cyrus-2.0.x. -- Matthew Emmerton GSI Computer Services To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Sep 30 2:57: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 5CE3637B502; Sat, 30 Sep 2000 02:57:28 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e8U9vER54867; Sat, 30 Sep 2000 13:57:15 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <00df01c02ac4$d0729260$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Erik Trulsson" Cc: , References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929160401.A4637@student.uu.se> Subject: Re: Where is Berkley DB libdb? Date: Sat, 30 Sep 2000 13:51:30 +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: "Erik Trulsson" > On Fri, Sep 29, 2000 at 04:23:59PM +0400, Artem Koutchine wrote: > > 1) Did someone compiled berkeley db statically into some other library > > (libc?) like > > the one on Red Hat did? not good. > > A quick browse of the source shows that it is indeed in libc. > > > 2) What version of db is installed by default, how can i see it? > > Looking at the source it appears to be version 1.85 > > > > 3) How can i avoid all this mess and make every single executable use the > > version > > i have installed (2.7.7). > > Probably not without a lot of problems. You would basically have to replace > the system version with the new one, make world, make sure that any > database files that the system use have been updated. Not for the faint of > heart. (Basically, if you don't know how to check the sources to see what > version of db it has you shouldn't even try this.) > > Note that files created with the 2.x versions of DB are *not* compatible with > the older 1.x versions. > > > > > 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. > > This is not really an OS problem but rather a problem with different DB > versions using different file formats and newer versions not being able of > handling the old formats. Oh really? I think THIS IS oS problem because somebody put in many respects external package into the source code and keeps it a very old version, whereas 3.x already exists, they still use 1.x This plain sucks, because this kills the idea of several oses working together. THIS MUST BE CHANGED either by finaly updating the version in src or making it an external package (i mean a separate db library, why not?) I am writing a letter to the developers. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Sep 30 2:58: 7 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 68E7437B503; Sat, 30 Sep 2000 02:55:31 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e8U9t4R54850; Sat, 30 Sep 2000 13:55:05 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <00dd01c02ac4$8280a740$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Dan Nelson" Cc: , References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929095555.A14858@dan.emsphone.com> Subject: Re: Where is Berkley DB libdb? Date: Sat, 30 Sep 2000 13:37:11 +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 (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). > > 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? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Sep 30 3: 9:23 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 20E7837B502; Sat, 30 Sep 2000 03:09:12 -0700 (PDT) Received: from wp2 (wp2 [192.168.0.12]) by osiris.ipform.ru (8.11.0/8.11.0) with SMTP id e8UA7dR54900; Sat, 30 Sep 2000 14:07:46 +0400 (MSD) (envelope-from matrix@ipform.ru) Message-ID: <00e001c02ac6$4c041100$0c00a8c0@ipform.ru> From: "Artem Koutchine" To: "Matthew Emmerton" , "Erik Trulsson" Cc: , References: Subject: Re: Where is Berkley DB libdb? Date: Sat, 30 Sep 2000 13:40:42 +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 > > Note that files created with the 2.x versions of DB are *not* compatible with > > the older 1.x versions. > > And to make things worse, 3.0 is not compatible with 2.x or 1.x, and 3.1 > is not compatible with 3.0 or 2.x or 1.x. > > 3.1 is used by some newer software, such as cyrus-2.0.x. wait wait wait 3.x *IS* backwards compatible with 2.x an 1.x, that is files of version 1.x and 2.x can be accesses in 3.x, but not vice versa. So, everything should be just fine, it libdb was of version 3.x Anyways, i still cannot get it, how can use at least make DB_FIle use the newer version (libdb2). To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Sep 30 12:27:44 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 A7CEE37B503; Sat, 30 Sep 2000 12:27:39 -0700 (PDT) Received: (from dan@localhost) by dan.emsphone.com (8.9.3/8.9.3) id OAA07025; Sat, 30 Sep 2000 14:27:36 -0500 (CDT) (envelope-from dan) Date: Sat, 30 Sep 2000 14:27:36 -0500 From: Dan Nelson To: Artem Koutchine Cc: questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Where is Berkley DB libdb? Message-ID: <20000930142736.A13227@dan.emsphone.com> References: <037201c02a10$e72e7a00$0c00a8c0@ipform.ru> <20000929095555.A14858@dan.emsphone.com> <00dd01c02ac4$8280a740$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: <00dd01c02ac4$8280a740$0c00a8c0@ipform.ru>; from "Artem Koutchine" on Sat Sep 30 13:37:11 GMT 2000 X-OS: FreeBSD 5.0-CURRENT Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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-database" in the body of the message