Re: Help making r-cran-rsqlite use Debian's sqlite3 (Was: Re: Bug#657919: ITP: r-cran-digest - Create cryptographic hash digests of R objects)
On Thu, Feb 2, 2012 at 2:46 PM, Dirk Eddelbuettel <edd@debian.org> wrote:
>
> On 2 February 2012 at 14:18, Carlos Borroto wrote:
> | On Tue, Jan 31, 2012 at 5:37 AM, Andreas Tille <tille@debian.org> wrote:
> | >> | They all build right now. I'm missing the license text to add for
> | >> | packages using MIT and Artistic-2, an easy fix I think. The only major
> | >> | issue I found was with RSQLite, which includes the sqlite3 source, but
> | >> | I'm guessing I need to link against Debian's sqlite3.
> | >>
> | >> Then you may need to patch the upstream configure. When I was doing the
> | >> automatic builds of 2000+ (at the time) CRAN packages that were autogenerated
> | >> as .deb package, I just left it as is. Given that R needs to run on Windoze,
> | >> OS X and various Linux/Unix flavours it was defensible for for Seth to
> | >> include the sources.
> | >
> | > For the manual packaging targeting at a Debian release I would strongly
> | > recommend to use Debian packaged sqlite3 (by patching upstream
> | > configure).
> |
> | I have taken a look at the upstream's configure, but haven't quite
> | understand how to correctly patch it. They did include
> | '--with-sqlite-dir', '--with-sqlite-inc' and '--with-sqlite-lib',
> | these can be use to avoid using the bundled sqlite3. How could I set
> | these options when the package builds?
>
> I have several dozen debian/rules files around, but rarely need it. Here it
> was I have commented out for Rmpi aka r-cran-rmpi:
>
> #!/usr/bin/make -f
> # -*- makefile -*-
> # debian/rules file for the Debian/GNU Linux r-cran-rmpi package
> # Copyright 2003-2010 by Dirk Eddelbuettel <edd@debian.org>
>
> include /usr/share/R/debian/r-cran.mk
>
> ##extraInstallFlags="--configure-args=--with-mpi=/usr/lib/openmpi"
> extraInstallFlags="--no-test-load"
>
>
> I think extraInstallFlags is due to a patch Steffen once needed / supplied.
>
Thanks!, I think that did the trick....
Before:
$ ldd /usr/lib/R/site-library/RSQLite/libs/RSQLite.so | grep sqlite
$
After:
$ ldd /usr/lib/R/site-library/RSQLite/libs/RSQLite.so | grep sqlite
libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
(0x00007fa474ed4000)
$
Beside modifying 'debian/rules', I also added libsqlite3-dev as a
source dependency and libsqlite3-0 as a package dependency.
Carlos
Reply to: