[indiana-discuss] 回复: [Fwd: Re: sysbench pkg for opensolaris 2008.05]

[Luojia Chen]

Hi, Tom,

To solve the problem, you'd set the LD_LIBRARY_PATH pointing to the "/usr/mysql/5.0/lib/mysql" where libmysqlclient_r.so.15 was located.


Thanks,
Jenny

>  
>  -------- Original Message --------
>  Subject: Re: [indiana-discuss] sysbench pkg for opensolaris 2008.05
>  Date: Fri, 15 Aug 2008 10:42:40 -0400
>  From: Tom Georgoulias <tomg at mcclatchyinteractive.com>
>  Organization: McClatchy Interactive
>  To: indiana-discuss at opensolaris.org
>  References: <48A1C6E4.9040305 at mcclatchyinteractive.com>
>  
>  Tom Georgoulias wrote:
>  > I want to repeat some sysbench tests that I've run with Mysql 5 and 
> Red 
>  > Hat Enterprise Linux 5 using Opensolaris 2008.05, but I cannot find 
> a 
>  > pkg for sysbench at pkg.opensolaris.org.  Does anyone know where I 
> can 
>  > get one without having to compile from source?
>  > 
>  > Doesn't look like building from scratch is easy or fun.  ;)
>  > 
>  > http://www.opensolaris.org/jive/thread.jspa?threadID=13182&tstart=0
>  
>  As expected, I'll have to compile from source.
>  
>  Here's what I'm using to build sysbench
>  
>  Hardware is Sunfire x4240 running Opensolaris snv_95.
>  
>  pkg:/SUNWmysql5 at 5.0.45,5.11-0.95:20080807T154006Z
>  pkg:/SUNWgcc at 3.4.3,5.11-0.95:20080807T162946Z
>  
>  I got SUNWmysql5 and SUNWgcc from pkg.opensolaris.org using the pkg
>  install command.
>  
>  mysql5 is installed in a weird location (/usr/mysql/5.0) so I've been
>  using the following configure:
>  
>  # configure --with-mysql-includes=/usr/mysql/5.0/include/mysql
>  --with-mysql-libs=/usr/mysql/5.0/lib/64/mysql
>  
>  Configure runs clean, but the build fails with this error:
>  <snip>
>  gcc -D_REENTRANT -g -O2 -o sysbench sysbench.o sb_timer.o sb_options.o
>  sb_logger.o db_driver.o  -lpthread tests/fileio/libsbfileio.a
>  tests/threads/libsbthreads.a tests/memory/libsbmemory.a
>  tests/cpu/libsbcpu.a tests/oltp/libsboltp.a tests/mutex/libsbmutex.a
>  drivers/mysql/libsbmysql.a -L/usr/mysql/5.0/lib/64/mysql 
> -lmysqlclient_r -lm
>  ld: fatal: file /usr/mysql/5.0/lib/64/mysql/libmysqlclient_r.so: wrong
>  ELF class: ELFCLASS64
>  ld: fatal: File processing errors. No output written to sysbench
>  collect2: ld returned 1 exit status
>  *** Error code 1
>  make: Fatal error: Command failed for target `sysbench'
>  
>  If I use --with-mysql-libs=/usr/mysql/5.0/lib/mysql, the build works
>  (although I'm guessing I just built a 32-bit sysbench, not a 64-bit version)
>  
>  Unfortunately, using sysbench doesn't work--I get the following error
>  when I try to run the binary:
>  
>  ld.so.1: sysbench: fatal: libmysqlclient_r.so.15: open failed: No such
>  file or directory
>  Killed
>  
>  Seems like the linker can't find the library after all...
>  
>  $ ldd /usr/local/bin/sysbench
>  
>            libpthread.so.1 =>       /lib/libpthread.so.1
>            libmysqlclient_r.so.15 =>        (file not found)
>            libm.so.2 =>     /lib/libm.so.2
>            libc.so.1 =>     /lib/libc.so.1
>  
>  Any suggestions or tips are greatly appreciated.
>  
>  Thanks,
>  Tom
>  
>  
>  
>  
>  
>  _______________________________________________
>  indiana-discuss mailing list
>  indiana-discuss at opensolaris.org
>  http://mail.opensolaris.org/mailman/listinfo/indiana-discuss
>