[R] RMySQL loading error

[Patrice Seyed]

but of course; danke. -P

Prof Brian Ripley wrote:
> On Wed, 17 May 2006, Patrice Seyed wrote:
>
>> i was able to install DBI and RMySQL cleanly. I get the error below on
>> "library('RMySQL')".
>>
>> The file it is complaining about is located in /usr/lib/mysql/, where is
>> R trying to load it from? Tried a symlink into /usr/local/lib/mysql to
>> no avail. thx. -P
>
> You need /usr/lib/mysql in the your ld.so load path: normally this is 
> done via ldconfig: for example my FC3 system has in /etc/ld.so.conf:
>
> include ld.so.conf.d/*.conf
> /usr/lib/mysql
> /usr/lib64/mysql
> /usr/i486-linux-libc5/lib
>
> In short, mysql has not been installed completely.
>
>> Loading required package: DBI
>> Error in dyn.load(x, as.logical(local), as.logical(now)) :
>>        unable to load shared library
>> '/usr/local/IT/R-2.1.0/library/RMySQL/libs/RMySQL.so':
>>  libmysqlclient.so.10: cannot open shared object file: No such file or
>> directory
>> Error in library("RMySQL") : .First.lib failed for 'RMySQL'
>> > q()
>>
>> # find / -name libmysqlclient.so.10
>> /usr/lib/mysql/libmysqlclient.so.10
>>
>>
>


-- 
Patrice Seyed
Linux System Administrator - LinGA
RHCE, SCSA
Boston University Medical Campus