mySQL Developer package

dmband445 · 07-24-2008, 08:09 AM

I am trying to install SphinxSearch on a Linux system for use by a wiki. I am on a Windows machine remoting into a Linux RHEL box. I run the configure for the Sphinx package and it seems fine, but then I try to do make and I get an error that says mysql.h doesn't exist: Oh yeah, and I'm pretty new with Linux, so try to dumb it down a little if you can

Code:

[root@BUILD sphinx-0.9.8]# make
Making all in src
make[1]: Entering directory `/root/sphinx-0.9.8/src'
if test -d ../.svn; then svn info .. --xml | perl svnxrev.pl; fi;
make  all-am
make[2]: Entering directory `/root/sphinx-0.9.8/src'
if g++ -DHAVE_CONFIG_H -I. -I. -I../config  -DSYSCONFDIR="\"/usr/local/etc\"" -I/usr/local/include -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv   -Wall -g -D_FILE_OFFSET_BITS=64 -O3 -DNDEBUG -MT sphinx.o -MD -MP -MF ".deps/sphinx.Tpo" -c -o sphinx.o sphinx.cpp; \
        then mv -f ".deps/sphinx.Tpo" ".deps/sphinx.Po"; else rm -f ".deps/sphinx.Tpo"; exit 1; fi
In file included from sphinx.cpp:14:
sphinx.h:54:19: error: mysql.h: No such file or directory
sphinx.h:1102: error: ISO C++ forbids declaration of âMYSQL_RESâ with no type
sphinx.h:1102: error: expected â;â before â*â token
sphinx.h:1103: error: ISO C++ forbids declaration of âMYSQL_FIELDâ with no type
sphinx.h:1103: error: expected â;â before â*â token
sphinx.h:1104: error: âMYSQL_ROWâ does not name a type
sphinx.h:1105: error: âMYSQLâ does not name a type
sphinx.cpp: In constructor âCSphSource_MySQL::CSphSource_MySQL(const char*)â:
sphinx.cpp:16697: error: class âCSphSource_MySQLâ does not have any field named âm_pMysqlResultâ
sphinx.cpp:16698: error: class âCSphSource_MySQLâ does not have any field named âm_pMysqlFieldsâ
sphinx.cpp:16699: error: class âCSphSource_MySQLâ does not have any field named âm_tMysqlRowâ
sphinx.cpp: In member function âvirtual void CSphSource_MySQL::SqlDismissResult()â:
sphinx.cpp:16706: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16709: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16709: error: âmysql_free_resultâ was not declared in this scope
sphinx.cpp:16711: error: âm_pMysqlFieldsâ was not declared in this scope
sphinx.cpp: In member function âvirtual bool CSphSource_MySQL::SqlQuery(const char*)â:
sphinx.cpp:16717: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16717: error: âmysql_queryâ was not declared in this scope
sphinx.cpp:16720: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16720: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16720: error: âmysql_use_resultâ was not declared in this scope
sphinx.cpp:16721: error: âm_pMysqlFieldsâ was not declared in this scope
sphinx.cpp: In member function âvirtual bool CSphSource_MySQL::SqlIsError()â:
sphinx.cpp:16728: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16728: error: âmysql_errnoâ was not declared in this scope
sphinx.cpp: In member function âvirtual const char* CSphSource_MySQL::SqlError()â:
sphinx.cpp:16734: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16734: error: âmysql_errorâ was not declared in this scope
sphinx.cpp: In member function âvirtual bool CSphSource_MySQL::SqlConnect()â:
sphinx.cpp:16740: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16740: error: âmysql_initâ was not declared in this scope
sphinx.cpp:16743: error: âmysql_real_connectâ was not declared in this scope
sphinx.cpp: In member function âvirtual void CSphSource_MySQL::SqlDisconnect()â:
sphinx.cpp:16749: error: âm_tMysqlDriverâ was not declared in this scope
sphinx.cpp:16749: error: âmysql_closeâ was not declared in this scope
sphinx.cpp: In member function âvirtual int CSphSource_MySQL::SqlNumFields()â:
sphinx.cpp:16755: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16758: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16758: error: âmysql_num_fieldsâ was not declared in this scope
sphinx.cpp: In member function âvirtual bool CSphSource_MySQL::SqlFetchRow()â:
sphinx.cpp:16764: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16767: error: âm_tMysqlRowâ was not declared in this scope
sphinx.cpp:16767: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16767: error: âmysql_fetch_rowâ was not declared in this scope
sphinx.cpp: In member function âvirtual const char* CSphSource_MySQL::SqlColumn(int)â:
sphinx.cpp:16774: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16777: error: âm_tMysqlRowâ was not declared in this scope
sphinx.cpp: In member function âvirtual const char* CSphSource_MySQL::SqlFieldName(int)â:
sphinx.cpp:16783: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16786: error: âm_pMysqlFieldsâ was not declared in this scope
sphinx.cpp:16787: error: âm_pMysqlResultâ was not declared in this scope
sphinx.cpp:16787: error: âmysql_fetch_fieldsâ was not declared in this scope
sphinx.cpp:16789: error: âm_pMysqlFieldsâ was not declared in this scope
make[2]: *** [sphinx.o] Error 1
make[2]: Leaving directory `/root/sphinx-0.9.8/src'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/root/sphinx-0.9.8/src'
make: *** [all-recursive] Error 1

Now I can't do a yum install mysql-devel because the box I am connecting to does not have an active internet connection, it's just used locally here. So I download the tarball and try to install it and get this:

Code:

       warning: mysql-devel-5.0.22-2.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 4f2a6fd2
error: Failed dependencies:
                openssl-devel is needed by mysql-devel-5.0.22-2.1.i386

So then I tried downloading openssl-devel and FTPing it over and installing it. I get yet another required package, saying:

Code:

        warning: openssl-devel-0.9.8a-5.2.i386.rpm: Header V3 DSAsignature:NOKEY,key
ID 4f2a6fd2
        error: Failed dependencies:
                krb5-devel is needed by openssl-devel-0.9.8a-5.2.i386
                openssl = 0.9.8a-5.2 is needed by openssl-devel-0.9.8a-5.2.i386

So of course, I do the same thing with the krb5-devel package, download it, FTP it, etc.
and get this:

Code:

        warning: krb5-devel-1.2.2-24.i386.rpm:Header V3DSAsignature:NOKEY,keyID
        db42a60e error: Failed dependencies:
        krb5-libs = 1.2.2-24 is needed by krb5-devel-1.2.2-24.i386
        libcom_err.so.3 is needed by krb5-devel-1.2.2-24.i386

Then I go get the krb5-libs rpm and repeat all over, and get this:

Code:

warning: krb5-libs-1.2.2-24.i386.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e
Preparing... ########################################### [100%]
                package krb5-libs-1.5-17 (which is newer than krb5-libs-1.2.2-24) is already installed
                file /etc/krb5.conf from install of krb5-libs-1.2.2-24 conflicts with file from package
                krb5-libs-1.5-17

Someone please point me in the right direction!!

lensman3 · 07-25-2008, 03:38 PM

Since this is RHEL box, have you tried to use yum to install the libraries? Since your login above is /root then you have super user stroke so try and install from the prebuilt rpm's. I run Fedora Core 9, so there should be something equivalent to yum for Redhat's paid system.

Try installing from yum, yum will sort out and install the dependencies for you. If yum doesn't work try the binary rpm''s.

07-25-2008, 03:38 PM	#2 (permalink)
lensman3 Registered User Join Date: Oct 2007 Location: Littleton, Colorado USA Posts: 470 OS: xp 64 sp2 Fedora Core 8 (vmware xp core 8 x32) Minix	Re: mySQL Developer package Since this is RHEL box, have you tried to use yum to install the libraries? Since your login above is /root then you have super user stroke so try and install from the prebuilt rpm's. I run Fedora Core 9, so there should be something equivalent to yum for Redhat's paid system. Try installing from yum, yum will sort out and install the dependencies for you. If yum doesn't work try the binary rpm''s.