[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
>  >