[R-SIG-Mac] RMySQL problem

[Parlamis Franklin]

Thanks for reply, Simon.  This is what I got when I executed the  
'ranlib' command you suggested.

ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(my_pthread.o) has  
no symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(my_thr_init.o)  
has no symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(thr_mutex.o) has  
no symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(my_port.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(strmov.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(bcmp.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(bmove.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(longlong2str.o)  
has no symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(strtoull.o) has  
no symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(strtoll.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a(viossl.o) has no  
symbols
ranlib: file: /usr/local/mysql/lib/libmysqlclient.a 
(viosslfactories.o) has no symbols

I subsequently reinstalled the entire MySQL binary (which includes  
the C API).  However, I am still getting the same error.  Is it  
possible that MySQL is distributing a corrupted library with their  
latest product?  What would I do differently if I were to install  
MySQL from source?

The one thing that truly perplexes me is why the package RMySQL  
worked perfectly under the prior version of R and only stopped  
working when I upgraded to the latest version of R (problem occurred  
before I upgraded MySQL)

On Oct 26, 2005, at 10:43 PM, Simon Urbanek wrote:

> Franklin,
>
> On Oct 27, 2005, at 12:59 AM, Parlamis Franklin wrote:
>
>
>> ld: truncated or malformed archive: /usr/local/mysql/lib/
>> libmysqlclient.a (ranlib structures in table of contents extends past
>> the end of the table of contents, can't load from it)
>>
>>
>
> As the compiler tells you your libmysqlclient is damaged. You can  
> try to run in Terminal:
>
> sudo ranlib /usr/local/mysql/lib/libmysqlclient.a
>
> If that doesn't help, then you need to wait for an update of MySQL  
> (or compile MySQL from sources), because the library is corrupted.
>
> Cheers,
> Simon
>
>