MySQL Bugs: #49799: Cant Compile My Programs With Mysql 5.5

Bug #49799	Cant Compile My Programs With Mysql 5.5
Submitted:	18 Dec 2009 9:46	Modified:	27 Apr 2018 12:06
Reporter:	Hernando Gonzalez	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S2 (Serious)
Version:	Mysql 5.5	OS:	Linux (RHEL 5.4)
Assigned to:		CPU Architecture:	Any
Tags:	cant, compile, wrong

Description:
Hi, i Update to Mysql 5.5 from 5.4, so i remove first all mysql 5.4 content, and later install all content from Mysql 5.5, everything runs fine, no problem.

But when i try compile my programs, the system cant find mysql libraries, or includes.

i try with this:

* export CPPFLAGS="-I/usr/include/mysql"
* export LDFLAGS="-L/usr/lib64/mysql -lmysqlclient -lz -lm" 
* --with-mysql-libs="/usr/lib64/mysql" 
* --with-mysql-includes="/usr/include/mysql" 

But nothing, is impossible to compile.

Is very strange becouse, with mysql 5.4.3, i dont have this problem, my compilation runs fine.

How to repeat:
Well, i use this program http://github.com/mangos/mangos/, you can try compile that source, and, at least me, cant compile with MySQL 5.5.

Thank you for the report.

Have you tried mysql_config utility?

If not pllease try: if you used binary distribution before most likely paths were changed. See our user manual for description of difference between source and binary distributions.

This shows MySQL 5.4.3

        --cflags         [-I/usr/include/mysql  -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -DUNIV_LINUX]
        --include        [-I/usr/include/mysql]
        --libs           [-rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lmygcc]
        --libs_r         [-rdynamic -L/usr/lib64/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmygcc]
        --plugindir      [/usr/lib64/mysql/plugin]
        --socket         [/var/lib/mysql/mysql.sock]
        --port           [0]
        --version        [5.4.3-beta]
        --libmysqld-libs [-rdynamic -L/usr/lib64/mysql -lmysqld -ldl -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmygcc]
        --variable=VAR   VAR is one of:
                pkgincludedir [/usr/include/mysql]
                pkglibdir     [/usr/lib64/mysql]
                plugindir     [/usr/lib64/mysql/plugin]

And this Shows MySQL 5.5

        --cflags         [-I/usr/include/mysql  -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -DUNIV_LINUX]
        --include        [-I/usr/include/mysql]
        --libs           [-rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lmygcc]
        --libs_r         [-rdynamic -L/usr/lib64/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmygcc]
        --plugindir      [/usr/lib64/mysql/plugin]
        --socket         [/var/lib/mysql/mysql.sock]
        --port           [0]
        --version        [5.5.0-m2]
        --libmysqld-libs [-rdynamic -L/usr/lib64/mysql -lmysqld -ldl -lz -lpthread -lcrypt -lnsl -lm -lpthread -lmygcc]
        --variable=VAR   VAR is one of:
                pkgincludedir [/usr/include/mysql]
                pkglibdir     [/usr/lib64/mysql]
                plugindir     [/usr/lib64/mysql/plugin]

Thank you for the feedback.

Please send exact compilation error you get. Also provide configure options you used to compile MySQL.

* I use this way:

autoreconf --install --force
aclocal
autoheader
autoconf
automake --add-missing
automake src/bindings/ScriptDev2/Makefile

mkdir objdir
cd objdir

export CFLAGS = "-msse3 -g -O3"
export CXXFLAGS = "-msse3 -g -O3"

../configure --with-std-malloc="yes" --prefix=/opt/test --sysconfdir=/opt/test/etc --datadir=/opt/test/sql --enable-cli

make
make install

* (with the before options that i mentioned, appear the same error, if i swith back to 5.4.3 compile withou problems)

* The Error is alredy upload.

Thanks!

So, is possible, some way to fix it?

Hernando,

thnak you for the data provided. I still can not repeat the problem. Please try to build MySQL not from objdir, but from source dir itself: we have bug #45616 about problems with build you use. If problem still exists please send us exampe of C file which you can not compile.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Posted by developer:
 
Not reproducible and no feedback on information request.