rAthena configure on ubuntu - mysql issues

[adaboost]

Checked out the latest from SVN (following guide: http://rathena.org/wiki/Configure).  Having issues with passing configure tests for mysql.  Seems like the library can't be linked to compress, pow@GLIBC_2.2.5, etc...

 

Did some googling but can't seem to find a solution.  Most are solved by installing mysql, but it's installed already - see dpkg logs at bottom :-(

 

Any solutions?

 

Running:

 

uname -a

Linux <username> 2.6.32-042stab065.3 #1 SMP Mon Nov 12 21:59:14 MSK 2012 x86_64 GNU/Linux

 

./configure --enable-packetver=20121001 --enable-64bit

...

 

checking for inflateEnd in -lz... yes

checking zlib.h usability... yes

checking zlib.h presence... yes

checking for zlib.h... yes

checking for library containing sqrt... -lm

checking for library containing clock_gettime... no

checking for pthread_create in -lpthread... yes

checking for pthread_sigmask in -lpthread... yes

checking for pthread_attr_init in -lpthread... yes

checking for pthread_attr_setstacksize in -lpthread... yes

checking for pthread_attr_destroy in -lpthread... yes

checking for pthread_cancel in -lpthread... yes

checking for pthread_join in -lpthread... yes

checking for mysql_config... /usr/bin/mysql_config

checking for mysql_init in -lmysqlclient... no

checking mysql.h usability... yes

checking mysql.h presence... yes

checking for mysql.h... yes

checking MySQL library (required)... no

configure: error: MySQL not found or incompatible

 

 

In config.log:

configure:5754: checking for mysql_config

configure:5772: found /usr/bin/mysql_config

configure:5785: result: /usr/bin/mysql_config

configure:5809: checking for mysql_init in -lmysqlclient

configure:5834: gcc -o conftest -g -O2 -DMAXCONN=16384 -pipe -ffast-math -Wall -DHAS_TLS -flto -fno-strict-aliasing -DHAVE_SETRLIMIT -DHAVE_STRNLEN -DPACKETVER=20121001 -Wno-unused -Wno-parentheses  -Wno-pointer-sign -Wno-switch  -I../common -I/usr/include -I/usr/include/mysql  -flto -L/usr/lib -lpthread -Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient conftest.c -lmysqlclient  -lpthread -lpthread -lpthread -lpthread -lpthread -lpthread -lpthread -lm -lz  >&5

/usr/lib/libmysqlclient.so: undefined reference to `compress'

/usr/lib/libmysqlclient.so: undefined reference to `pow@GLIBC_2.2.5'

/usr/lib/libmysqlclient.so: undefined reference to `log@GLIBC_2.2.5'

/usr/lib/libmysqlclient.so: undefined reference to `floor@GLIBC_2.2.5'

/usr/lib/libmysqlclient.so: undefined reference to `uncompress'

 

 

Setup (Ubuntu 10.10 maverick):

dpkg -l | grep -i mysql | grep "^ii"

ii  libmysqlclient-dev                                          5.1.58-1ubuntu1                 MySQL database development files

ii  libmysqlclient16                                            5.1.58-1ubuntu1                 MySQL database client library

ii  mysql-client-5.1                                            5.1.58-1ubuntu1                 MySQL database client binaries

ii  mysql-client-core-5.1                                       5.1.58-1ubuntu1                 MySQL database core client binaries

ii  mysql-common                                                5.1.58-1ubuntu1                 MySQL database common files

ii  mysql-server                                                5.1.58-1ubuntu1                 MySQL database server

ii  mysql-server-5.1                                            5.1.58-1ubuntu1                 MySQL database server binaries

ii  mysql-server-core-5.1                                       5.1.58-1ubuntu1                 MySQL database server binaries

 

 

dpkg -l | grep -i zlib

ii  zlib1g                                                      1:1.2.3.4.dfsg-3ubuntu3         compression library - runtime

ii  zlib1g-dev                                                  1:1.2.3.4.dfsg-3ubuntu3         compression library - development

 

 

[Lighta]

you need libmysqlclient-dev, I used to have that issue too.

I've put the package I uses to install in tools/config.pl if that help you to reduce some dependancy.

[yakuu]

./configure && make sql

[adaboost]

./configure errors out so it doesn't create any Makefiles :-/

 

Any recommendations on a OS distribution and OS version that works?  I am used to running on ubuntu, but I'd be willing to try other linux based distributions if anyone had success with them.  Maybe an older ubuntu 10.04?

[yakuu]

apt-get update ?

Edited February 18, 2013 by yakuu

[Brian]

./configure && make sql

No. 

apt-get update ?

Probably not, since adaboost already ran 'dpkg' and showed he has all the MySQL stuff installed.

Also, 'apt-get update' only fetches the update list. You have to do upgrade to install them:

apt-get update
apt-get upgrade

@adaboost: I'm not sure why it's not working for you.

When I setup rAthena on Ubuntu/Debian (with an external MySQL Server), these are the only packages I have to install:

apt-get install cmake gcc libmysqlclient-dev libpcre3-dev make subversion

[rokimoki]

@Lighta thanks, I installed that package and worked, thanks.