[R] RMySQL, Solaris and getopt????

[Roggie Boone]

Hi,

I've been struggling with RMySQL installation
for several days.  I'm running Solaris 2.9
and MySQL 4.0. RMySQL (v0.4.3) seems to install
OK, but when I load it in R I get the message:
-------
> library(RMySQL)
Error in dyn.load(x, as.logical(local),
as.logical(now)) :
        unable to load shared library
"/local/rboone/SOFTWARE/R-1.9.1/library/RMySQL/libs/RMySQL.so":
  ld.so.1: /local/rboone/SOFTWARE/R-1.9.1/bin/R.bin:
fatal: relocation error: file
/local/rboone/SOFTWARE/R-1.9.1/library/RMySQL/libs/RMySQL.so:
symbol getopt_long: referenced symbol not found
Error in library(RMySQL) : .First.lib failed
-------

It appears that getopt_long is not linked in.
It does not appear to be in the standard libs
on Solaris (I am on a campus network and use
our network version of gcc compiler).
In the RMySQL distribution, I 
see source code for getopt.c and getopt.h, but
I don't understand what to do with them.  I tried
"gcc -c getopt.c -o getopt.o" but it produced
a screenfull of parse errors, etc.

Anyone have suggestions on what to try?
Thanks,
Roggie Boone