From owner-freebsd-database@FreeBSD.ORG Sun Jul 27 17:41:36 2008 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 42573106564A for ; Sun, 27 Jul 2008 17:41:36 +0000 (UTC) (envelope-from chagin.dmitry@gmail.com) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.186]) by mx1.freebsd.org (Postfix) with ESMTP id C013D8FC1C for ; Sun, 27 Jul 2008 17:41:35 +0000 (UTC) (envelope-from chagin.dmitry@gmail.com) Received: by fk-out-0910.google.com with SMTP id k31so3906724fkk.11 for ; Sun, 27 Jul 2008 10:41:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:date:to:cc:subject :in-reply-to:message-id:references:user-agent:mime-version :content-type:from; bh=UmA02ZXJxzCl6RC4h5RcCCiOdVp9V6rRasSMqHBCWtw=; b=MApHfopU9rl8Istn9e9G6F164rbNpTqjGtfzEuCA39UoKOPCnhz9V85JuFjzViVTVl AjeSaeWWzJTSq22Bqq71E9E8bDwR/MMG+mONjZqSV6/46vADctSFK/3SiwY60u445Fj+ Ts6Vdbz8mPVL24uSRHgjH4A47r0USkPrh+rnU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=date:to:cc:subject:in-reply-to:message-id:references:user-agent :mime-version:content-type:from; b=vxhVusl+N41s7/bHd1SywCZZ2GhsXzgPwC/nJAphItqW463d09uYx90LKs9FLm72GJ 20e8KXAVjTguFJ+1eULfthY8tOvwmlbO2FsLrVURk7b872OGMBoBBrNinDyMTtZPKt1l IAaB53qx78QAJSfaqZZAf/AAOKGhOcUwt6jtg= Received: by 10.181.4.17 with SMTP id g17mr1023282bki.67.1217178993839; Sun, 27 Jul 2008 10:16:33 -0700 (PDT) Received: from ora.chd.net ( [78.107.232.239]) by mx.google.com with ESMTPS id 13sm22486973fks.6.2008.07.27.10.16.29 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 27 Jul 2008 10:16:30 -0700 (PDT) Date: Sun, 27 Jul 2008 21:16:05 +0400 (MSD) To: Adrian Penisoara In-Reply-To: <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> Message-ID: References: <78cb3d3f0807260841k336f20a9jce857189c55adb16@mail.gmail.com> <78cb3d3f0807270122r4d2377d9gbf4e3ed5386918fa@mail.gmail.com> <20080727121503.679bc598@deskjail> <78cb3d3f0807271003q3f5ab72dr2147cf7b1a3348fc@mail.gmail.com> User-Agent: Alpine 1.10 (BSF 962 2008-03-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed From: Chagin Dmitry Cc: freebsd-database@freebsd.org, Alexander Leidinger , freebsd-emulation@freebsd.org, rofug@rofug.ro, freebsd-ports@freebsd.org Subject: Re: Q: Is there any use for Oracle database port installation under Linux compat root ? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 27 Jul 2008 17:41:36 -0000 On Sun, 27 Jul 2008, Adrian Penisoara wrote: > Hi, > > On Sun, Jul 27, 2008 at 1:15 PM, Alexander Leidinger < > Alexander@leidinger.net> wrote: > >> Quoting "Adrian Penisoara" (Sun, 27 Jul 2008 11:22:20 >> +0300): >> >>> Hi, >>> >>> I am working on a FreeBSD port for Oracle's XE database package[1] >> (Linux >>> binaries) and I stumbled upon some issues related to USE_LINUX_PREFIX. >>> Before going any further trying to support (as an option) installing the >>> Oracle XE directly under the /compat/linux hierarchy (like the >>> database/linux-oracle-instantclient-* ports are doing), I have to ask ask >>> around the following: >>> >>> (1) Is there any real need/benefit to have an Oracle DB installation >> rooted >>> under /compat/linux (e.g. /compat/linux/usr/lib/oracle/xe/...) ? Side >> note: >>> in this case all shell scripts will need to be ran under >>> /compat/linux/bin/bash. >>> >>> (2) How does one deal with installing manual pages and shared files with >>> USE_LINUX_PREFIX -- do they also have to go under /compat/linux ? Using >>> ${MANPREFIX} as a template gives wrong results in this case... >> >> A port has to install into LINUXPREFIX, if it is an infrastructure >> port (no part has to go outside this location). It has to install into >> the default location (PREFIX/LOCALBASE), if it is an enduser port. >> That's the easy part. > > > Good pointer, I was missing this bit. Thanks. > > >> >> >> Now the classification, what is what, is the hard part. The linux >> png/jpeg or whatever lib is for sure infrastructure. If this would land >> in the default FreeBSD lib path, rest assured it would hurt. A linux >> acroread port is an enduser application, a user will call it directly >> to work with it. It also does not come with libs in the default FreeBSD >> locations, so everything will be fine if it is installed in the default >> location. >> >> For the Oracle stuff I can imagine that it is a hard question. If it >> doesn't put libs into a FreeBSD lib directory (a subdirectory of a lib >> directory is ok, as it will not cause immediate problems), there are no >> immediate objections to putting it into the default FreeBSD location >> (and as the DBA as an enduser would use it, this would fit into the >> description above). But we also have the rule that nothing is allowed >> to be put into the basesystem (/usr/Y instead of /usr/local/Y). Think >> about jails where the base is mounted read-only and only additional >> programs are in a RW part. > > > In the default configuration the binaries (and I mean all of them!) would > be placed under /usr/lib/oracle, since this is a hardcoded path in all > places. > I will also offer a "WITH_BSDHIER" option which will root the installation > into /usr/local/oracle and just make a symlink under /usr/lib. Should I > rather make this the default ? ;) > > There are no libraries (or other binaries for that fact) installed outside > the Oracle hierarchy (this is the general strategy for Oracle RDBMS products > at least). So I guess it very nicely fits into the "enduser" picture you > describe above. I'm just wandering whether a /compat/linux rooted > installation would make sense. > > I am still interested to hear opinions from Oracle DBAs/users on this > subject -- would you need this option ? > hi! I think that ora DBAs will tell that the best place it /home/ORAUSERNAME and this user should have shell /compat/linux/bin/bash thnx! > >> >> >> In the end it comes down to what you are able to do and how hard the >> software is to port. Maybe it is easy to install everything into >> LINUXBASE and install a wrapper into LOCALBASE (/usr/local/bin/Y would >> be a script with #!/compat/linux/bin/bash and start whatever is needed >> to start /compat/linux/bin/Y). Maybe the installation of the software >> allows to install into /usr/local/softwarename and you can make links >> from /usr/local/bin/ to it. >> >> The rules for this are strong suggestions. If it is possible to do, >> do everything you can to follow the rules, if you don't know how to >> make something follow the rules, ask specific questions on ports if >> someone has in idea. If there's no idea, forget the rule and try to do >> something as close as possible to the goal of the rule (and document >> what/why). >> >> Bye, >> Alexander. >> >> > Thank you for your time. > Adrian. > _______________________________________________ > freebsd-emulation@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-emulation > To unsubscribe, send any mail to "freebsd-emulation-unsubscribe@freebsd.org" > -- Have fun! chd