• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

MySQL Errors

Hi,

I'm installing a game server that requires mysql, i installed mysql4 latest on my Fedora Core 4 Server.

This is the errors i got, what should i do?

[game@server eAthena]$ make sql
make SQLFLAG=1 sql
make[1]: Entering directory `/home/game/eAthena'
printf "CC=\"gcc -pipe\" CFLAGS=\"-g -O2 -ffast-math -Wall -Wno-sign-compare -I.                                             ./common  -I/usr/local/mysql/include\" LIB_S=\"-ldl -L/usr/local/lib -L/usr/loca                                             l/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lreso                                             lv -lc -lnss_files -lnss_dns -lresolv\"" > Makefile.cache
cp -r conf-tmpl conf
rm -rf conf/.svn conf/*/.svn
cp -r save-tmpl save
rm -rf save/.svn
sed -e 's/$>/$^/' src/common/Makefile > src/common/GNUmakefile
make -C src/common CC="gcc -pipe" CFLAGS="-g -O2 -ffast-math -Wall -Wno-sign-com                                             pare -I../common  -I/usr/local/mysql/include" LIB_S="-ldl -L/usr/local/lib -L/us                                             r/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns                                              -lresolv -lc -lnss_files -lnss_dns -lresolv"
which: no svnversion in (/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11                                             R6/bin:/home/game/bin:/usr/local/mysql/bin)
make[2]: Entering directory `/home/game/eAthena/src/common'
mkdir obj
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/m                                             ysql/include   -c -o obj/core.o core.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/m                                             ysql/include   -c -o obj/socket.o socket.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/m                                             ysql/include   -c -o obj/timer.o timer.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/db.o db.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/plugins.o plugins.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/lock.o lock.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/nullpo.o nullpo.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/malloc.o malloc.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/showmsg.o showmsg.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/strlib.o strlib.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/utils.o utils.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/graph.o graph.c
graph.c: In function âgraph_createâ:
graph.c:60: warning: pointer targets in passing argument 1 of âgrfio_crc32â differ in signedness
graph.c: In function âgraph_palletâ:
graph.c:83: warning: pointer targets in passing argument 1 of âgrfio_crc32â differ in signedness
graph.c: In function âgraph_outputâ:
graph.c:123: warning: pointer targets in passing argument 1 of âgrfio_crc32â differ in signedness
graph.c: In function âgraph_draw_timerâ:
graph.c:244: warning: pointer targets in assignment differ in signedness
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/grfio.o grfio.c
grfio.c: In function âgrfio_crc32â:
grfio.c:408: warning: pointer targets in passing argument 2 of âcrc32â differ in signedness
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -DMINICORE -o obj/minicore.o core.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -DMINICORE -o obj/minisocket.o socket.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -DMINICORE -o obj/minimalloc.o malloc.c
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/mapindex.o mapindex.c
make -C ../zlib
make[3]: Entering directory `/home/game/eAthena/src/zlib'
gcc -pipe -c -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include unzip.c
gcc -pipe -c -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include ioapi.c
ar rcs unz.o unzip.o ioapi.o
make[3]: Leaving directory `/home/game/eAthena/src/zlib'
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o obj/ers.o ers.c
make[2]: Leaving directory `/home/game/eAthena/src/common'
sed -e 's/$>/$^/' src/login_sql/Makefile > src/login_sql/GNUmakefile
make -C src/login_sql CC="gcc -pipe" CFLAGS="-g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include" LIB_S="-ldl -L/usr/local/lib -L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv" sql
make[2]: Entering directory `/home/game/eAthena/src/login_sql'
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o login.o login.c
login.c: In function âparse_fromcharâ:
login.c:1260: warning: pointer targets in passing argument 1 of âsscanfâ differ in signedness
login.c:1263: warning: pointer targets in passing argument 1 of âsscanfâ differ in signedness
login.c:1369: warning: pointer targets in passing argument 1 of âsprintfâ differ in signedness
login.c:1370: warning: pointer targets in passing argument 1 of âsprintfâ differ in signedness
gcc -pipe -g -O2 -ffast-math -Wall -Wno-sign-compare -I../common  -I/usr/local/mysql/include   -c -o md5calc.o md5calc.c
gcc -pipe -o ../../login-server_sql login.o md5calc.o ../common/obj/core.o ../common/obj/socket.o ../common/obj/timer.o ../common/obj/db.o ../common/obj/plugins.o ../common/obj/lock.o ../common/obj/malloc.o ../common/obj/showmsg.o ../common/obj/utils.o ../common/obj/strlib.o ../common/obj/graph.o ../common/obj/grfio.o ../common/obj/mapindex.o ../common/obj/ers.o ../zlib/unz.o -ldl -L/usr/local/lib -L/usr/local/mysql/lib -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
/usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSSL7Message+0x8): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSSL7Message+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSSL7Message+0x10): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSSL7Message+0x14): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(ssl.o)(.gnu.linkonce.d.__vt_Q25yaSSL7Message+0x18): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(cert_wrapper.o)(.text+0x53): In function `yaSSL::x509::~x509(void)':
cert_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(cert_wrapper.o)(.text+0x275): In function `yaSSL::CertManager::~CertManager(void)':
cert_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.t._._Q25mySTLt4list1ZPQ25yaSSL11SSL_SESSION+0x32): In function `mySTL::list<yaSSL::SSL_SESSION *>::~list(void)':
template_instnt.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.t._._Q25mySTLt4list1ZPQ25yaSSL12input_buffer+0x32): In function `mySTL::list<yaSSL::input_buffer *>::~list(void)':
template_instnt.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.t._._Q25mySTLt4list1ZPQ25yaSSL13output_buffer+0x32): In function `mySTL::list<yaSSL::output_buffer *>::~list(void)':
template_instnt.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.t._._Q25mySTLt4list1ZPUc+0x32):template_instnt.cpp: more undefined references to `__builtin_delete' follow
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.d.__vt_Q25yaSSL13HandShakeBase+0x8): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.d.__vt_Q25yaSSL13HandShakeBase+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.d.__vt_Q25yaSSL13HandShakeBase+0x10): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(template_instnt.o)(.gnu.linkonce.d.__vt_Q25yaSSL13HandShakeBase+0x14): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(yassl_imp.o)(.text+0x23de): In function `yaSSL::ServerDHParams::~ServerDHParams(void)':
yassl_imp.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(yassl_imp.o)(.text+0x3e8f): In function `yaSSL::Connection::~Connection(void)':
yassl_imp.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(yassl_int.o)(.text+0x29ed): In function `yaSSL::SSL_SESSION::~SSL_SESSION(void)':
yassl_int.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(yassl_int.o)(.text+0x2b43): In function `yaSSL::Sessions::~Sessions(void)':
yassl_int.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(yassl_int.o)(.text+0x2e35): In function `yaSSL::SSL_CTX::~SSL_CTX(void)':
yassl_int.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(yassl_int.o)(.text+0x31cc):yassl_int.cpp: more undefined references to `__builtin_delete' follow
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt4HASH+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt4HASH+0x10): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt4HASH+0x14): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt4HASH+0x18): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt4HASH+0x1c): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt11BER_Decoder+0xc): more undefined references to `__pure_virtual' follow
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-asn.o)(.gnu.linkonce.t._._Q28TaoCrypt13DSA_PublicKey+0x9f): In function `TaoCrypt::DSA_PublicKey::~DSA_PublicKey(void)':
asn.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-random.o)(.text+0xf6): In function `TaoCrypt::OS_Seed::~OS_Seed(void)':
random.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x14): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x18): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x1c): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x20): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x24): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-hash.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt17HASHwithTransform+0x28): more undefined references to `__pure_virtual' follow
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.text+0x10ae): In function `yaSSL::RandomPool::~RandomPool(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.text+0x192e): In function `yaSSL::Integer::~Integer(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.text+0x1c36): In function `yaSSL::DiffieHellman::~DiffieHellman(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.t._._Q35yaSSL3DES7DESImpl+0x26): In function `yaSSL::DES::DESImpl::~DESImpl(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.t._._Q35yaSSL3AES7AESImpl+0x71): In function `yaSSL::AES::AESImpl::~AESImpl(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.t._._Q35yaSSL3RSA7RSAImpl+0x6e):crypto_wrapper.cpp: more undefined references to `__builtin_delete' follow
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt9Mode_BASE+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q25yaSSL4Auth+0x8): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q25yaSSL4Auth+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q25yaSSL4Auth+0x10): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q25yaSSL10BulkCipher+0x8): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.d.__vt_Q25yaSSL10BulkCipher+0xc): more undefined references to `__pure_virtual' follow
/usr/local/mysql/lib/libmysqlclient.a(crypto_wrapper.o)(.gnu.linkonce.t._._Q28TaoCrypt14RSA_PrivateKey+0x123): In function `TaoCrypt::RSA_PrivateKey::~RSA_PrivateKey(void)':
crypto_wrapper.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(log.o)(.text+0x20): In function `yaSSL::Log::~Log(void)':
log.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0xc): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0x10): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0x14): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0x18): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0x3c): undefined reference to `__pure_virtual'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-algebra.o)(.gnu.linkonce.d.__vt_Q28TaoCrypt23AbstractEuclideanDomain+0x40): more undefined references to `__pure_virtual' follow
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-file.o)(.text+0x64): In function `TaoCrypt::FileSource::~FileSource(void)':
file.cpp: undefined reference to `__builtin_delete'
/usr/local/mysql/lib/libmysqlclient.a(libtaocrypt_la-file.o)(.text+0x200): In function `TaoCrypt::FileSink::~FileSink(void)':
file.cpp: undefined reference to `__builtin_delete'
collect2: ld returned 1 exit status
make[2]: *** [login-server_sql] Error 1
make[2]: Leaving directory `/home/game/eAthena/src/login_sql'
make[1]: *** [login_sql] Error 2
make[1]: Leaving directory `/home/game/eAthena'
make: *** [sql] Error 2
0
jedistar
Asked:
jedistar
  • 2
  • 2
1 Solution
 
NovaDenizenCommented:
I think your libmysqlclient.a was built with g++, not gcc.  That, or the ssl.o object inside libmysqlclient.a is a c++ object file.  I thought ssl was a C library, and mysql was written in C.  I'm not sure how c++ code has gotten into your setup.

0
 
jedistarAuthor Commented:
How do i fix it?
0
 
NovaDenizenCommented:
This may work.  If you used g++ instead of gcc as your compiler you might be able to dodge these errors.  Check your Makefiles, and look for lines that make gcc your compiler/linker.  They should look something like this:

CC=gcc
COMPILER=gcc
LINKER=gcc

Just replace gcc with g++.
CC=g++
COMPILER=g++

There also may be a setting you use with ./configure, if the software uses the autoconf system.

If this doesn't work, then we would need to back up and figure out how c++ code got into ssl.o or libmysqlclient.a.

0
 
jedistarAuthor Commented:
Tried, same error, anymore should i do?

(thank btw)
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now