Hi,

I am having trouble installing sphinx search on my server, I am wanting to use sphinx
search for my media wiki install. I am following the install instructions located here
http://www.mediawiki.org/wiki/Extension:SphinxSearch

Please see below for what happens during installation:

------------------------------------------------------------------------------------------

Server software specs:

Mysql version: 5.0.27
PHP Version: 5.2.0
FreeBSD Version: 6.1-RELEASE-p10


STEP 1 - Install Sphinx:

$ tar xzvf sphinx-0.9.8.tar.gz
$ cd sphinx

# pwd
/usr/local/www/test.com/temp-sphinx/sphinx-0.9.9

# ./configure

checking build environment
--------------------------

checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... config/install-sh -c -d
checking for gawk... no
checking for mawk... no
checking for nawk... nawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no

checking for compiler programs
------------------------------

checking whether to compile debug version... no
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking for ranlib... ranlib

checking for header files
-------------------------

checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for ANSI C header files... yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking sys/file.h usability... yes
checking sys/file.h presence... yes
checking for sys/file.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking for unistd.h... (cached) yes
checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
checking expat.h usability... yes
checking expat.h presence... yes
checking for expat.h... yes
checking iconv.h usability... yes
checking iconv.h presence... yes
checking for iconv.h... yes
checking zlib.h usability... yes
checking zlib.h presence... yes
checking for zlib.h... yes
checking sql.h usability... no
checking sql.h presence... no
checking for sql.h... no

checking for types
------------------

checking for stdbool.h that conforms to C99... yes
checking for _Bool... yes
checking for an ANSI C-conforming const... yes
checking for inline... inline
checking for off_t... yes
checking for size_t... yes
checking whether time.h and sys/time.h may both be included... yes

checking for library functions
------------------------------

checking for pid_t... yes
checking vfork.h usability... no
checking vfork.h presence... no
checking for vfork.h... no
checking for fork... yes
checking for vfork... yes
checking for working fork... yes
checking for working vfork... (cached) yes
checking for stdlib.h... (cached) yes
checking for GNU libc compatible malloc... yes
checking for stdlib.h... (cached) yes
checking for GNU libc compatible realloc... yes
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking for sys/socket.h... (cached) yes
checking types of arguments for select... int,fd_set *,struct timeval *
checking return type of signal handlers... void
checking whether lstat dereferences a symlink specified with a trailing slash... no
checking whether stat accepts an empty string... no
checking for vprintf... yes
checking for _doprnt... no
checking for library containing setsockopt... none required
checking for library containing gethostbyname... none required
checking for library containing XML_Parse... -lexpat
checking for library containing iconv... -liconv
checking for library containing inflate... -lz
checking for library containing logf... -lm
checking for library containing SQLConnect... no
checking for dup2... yes
checking for gethostbyname... yes
checking for gettimeofday... yes
checking for memmove... yes
checking for memset... yes
checking for select... yes
checking for socket... yes
checking for strcasecmp... yes
checking for strchr... yes
checking for strerror... yes
checking for strncasecmp... yes
checking for strstr... yes
checking for strtol... yes
checking for logf... yes
checking for pread... yes
checking for clock_gettime in -lrt... no
checking for clock_gettime... yes
checking for LOCK_EX in sys/file.h... yes
checking for F_SETLKW in fcntl.h... yes

configuring Sphinx
------------------

checking for CFLAGS needed for pthreads... -pthread
checking for LIBS needed for pthreads... -lpthread
checking for pthreads... found
checking whether to compile with MySQL support... yes
checking for mysql_config... mysql_config
checking for mysql_real_connect... yes
checking MySQL include files... -I/usr/local/mysql/include/mysql
checking MySQL libraries... -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lm
checking whether to compile with PostgreSQL support... no
checking whether to use 64-bit document/word IDs... no
checking whether to compile with libstemmer support... no
checking for libexpat... found
checking for libiconv... found
checking for iconv() arg types... const char **
checking for UnixODBC... not found
configure: WARNING: ODBC source support will NOT be available
checking for unaligned RAM access... yes

generating configuration files
------------------------------

configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating libstemmer_c/Makefile
config.status: creating sphinx.conf.dist
config.status: creating sphinx-min.conf.dist
config.status: creating config/config.h
config.status: config/config.h is unchanged
config.status: executing depfiles commands

configuration done
------------------

You can now run 'make' to build Sphinx binaries,
and then run 'make install' to install them.


# make
Making all in src
if test -d ../.svn; then svn info .. --xml | perl svnxrev.pl; fi;
make all-am
Making all in test


# make install
Making install in src
if test -d ../.svn; then svn info .. --xml | perl svnxrev.pl; fi;
make install-am
test -z "/usr/local/bin" || ../config/install-sh -c -d "/usr/local/bin"
/usr/bin/install -c 'indexer' '/usr/local/bin/indexer'
/usr/bin/install -c 'searchd' '/usr/local/bin/searchd'
/usr/bin/install -c 'search' '/usr/local/bin/search'
/usr/bin/install -c 'spelldump' '/usr/local/bin/spelldump'
/usr/bin/install -c 'indextool' '/usr/local/bin/indextool'
Making install in test
test -z "/usr/local/etc" || config/install-sh -c -d "/usr/local/etc"
/usr/bin/install -c -m 644 'sphinx.conf.dist' '/usr/local/etc/sphinx.conf.dist'
/usr/bin/install -c -m 644 'sphinx-min.conf.dist' '/usr/local/etc/sphinx-min.conf.dist'
/usr/bin/install -c -m 644 'example.sql' '/usr/local/etc/example.sql'
make install-data-hook
mkdir -p /usr/local/var/data && mkdir -p /usr/local/var/log



STEP 2 - Configure sphinx:

Modify /var/data/sphinx/sphinx.conf with mysql login details

STEP 3 - Run Sphinx Indexer:

# /usr/local/sphinx/bin/indexer --config /var/data/sphinx/sphinx.conf -all
/libexec/ld-elf.so.1: Shared object "libmysqlclient.so.15" not found, required by
"indexer"

------------------------------------------------------------------------------------

If you can see anything in the logs or suggest anything to try and get it up and running,
it would really help me out. Thanks

P.S - I have mysql client installed.

What does 'ls -l /usr/local/lib/mysql/libmysqlclient.so*' return?

What does 'ls -l /usr/local/lib/mysql/libmysqlclient.so*' return?

ls -l /usr/local/lib/mysql/libmysqlclient.so*
ls: /usr/local/lib/mysql/libmysqlclient.so*: No such file or directory


Hmm looks like it may not be installed after all, previously I was doing a locate on libmysqlclient.so and it was showing that it existed in that located but when I go to the location it does not exist.

Could you please let me know how to install the mysqlclient and will it affect any mysql databases while I install it?

Thanks for your help

Probably something like 'pkg_add -r libmysqlclient'?

Moved: This thread is more suitable in Other *NIX and has been moved accordingly to help your thread/question get the exposure it deserves. (That's where the BSD crowd hangs out)