mysql_config returns wrong path

Bug #1099681 reported by tsubasa tanaka
28
This bug affects 5 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Triaged
Medium
Unassigned
5.6
Triaged
Medium
Unassigned
5.7
New
Undecided
Unassigned

Bug Description

Percona-Server-5.5.28-rel29.3-388.Linux.x86_64 and Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.x86_64's mysql_config returns wrong path.

$ bin/mysql_config
Usage: bin/mysql_config [OPTIONS]
Options:
        --cflags [-I/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/include -fPIC -g -static-libgcc -fno-omit-frame-pointer -DPERCONA_INNODB_VERSION=rel29.3 -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1]
        --include [-I/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/include]
        --libs [-L/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql -lmysqlclient -lpthread -lm -lrt -ldl]
        --libs_r [-L/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql -lmysqlclient_r -lpthread -lm -lrt -ldl]
        --plugindir [/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql/plugin]
        --socket [/tmp/mysql.sock]
        --port [0]
        --version [5.5.28]
        --libmysqld-libs [-L/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql -lmysqld]
        --variable=VAR VAR is one of:
                pkgincludedir [/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/include]
                pkglibdir [/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql]
                plugindir [/home/ttanaka/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql/plugin]

--libs and --libs_r returns $basedir/lib/mysql but $basedir/lib is correct.

$ ls -l lib/ lib/mysql/
lib/:
total 21988
-rw-r--r-- 1 ttanaka ttanaka 15325922 Jan 7 15:18 libmysqlclient.a
lrwxrwxrwx 1 ttanaka ttanaka 20 Jan 15 12:17 libmysqlclient.so -> libmysqlclient.so.18
lrwxrwxrwx 1 ttanaka ttanaka 24 Jan 15 12:17 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
-rwxr-xr-x 1 ttanaka ttanaka 7168630 Jan 7 15:18 libmysqlclient.so.18.0.0
lrwxrwxrwx 1 ttanaka ttanaka 16 Jan 15 12:17 libmysqlclient_r.a -> libmysqlclient.a
lrwxrwxrwx 1 ttanaka ttanaka 17 Jan 15 12:17 libmysqlclient_r.so -> libmysqlclient.so
lrwxrwxrwx 1 ttanaka ttanaka 17 Jan 15 12:17 libmysqlclient_r.so.18 -> libmysqlclient.so
lrwxrwxrwx 1 ttanaka ttanaka 17 Jan 15 12:17 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
-rw-r--r-- 1 ttanaka ttanaka 10152 Jan 7 15:17 libmysqlservices.a
drwxr-xr-x 3 ttanaka ttanaka 4096 Jan 7 15:19 mysql

lib/mysql/:
total 4
drwxr-xr-x 3 ttanaka ttanaka 4096 Jan 7 15:20 plugin

Tags: pkg
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Indeed, path looks wrong:

[valerii.kravchuk@cisco1 Percona-Server-5.5.28-rel29.3-388.Linux.x86_64]$ bin/mysql_config --libs
-L/home/valerii.kravchuk/Percona-Server-5.5.28-rel29.3-388.Linux.x86_64/lib/mysql -lmysqlclient -lpthread -lm -lrt -ldl
[valerii.kravchuk@cisco1 Percona-Server-5.5.28-rel29.3-388.Linux.x86_64]$ ls -l lib
total 21988
-rw-r--r-- 1 valerii.kravchuk valerii.kravchuk 15325922 Jan 6 22:18 libmysqlclient.a
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 16 Jan 13 04:25 libmysqlclient_r.a -> libmysqlclient.a
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 17 Jan 13 04:25 libmysqlclient_r.so -> libmysqlclient.so
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 17 Jan 13 04:25 libmysqlclient_r.so.18 -> libmysqlclient.so
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 17 Jan 13 04:25 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 20 Jan 13 04:25 libmysqlclient.so -> libmysqlclient.so.18
lrwxrwxrwx 1 valerii.kravchuk valerii.kravchuk 24 Jan 13 04:25 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
-rwxr-xr-x 1 valerii.kravchuk valerii.kravchuk 7168630 Jan 6 22:18 libmysqlclient.so.18.0.0
-rw-r--r-- 1 valerii.kravchuk valerii.kravchuk 10152 Jan 6 22:17 libmysqlservices.a
drwxr-xr-x 3 valerii.kravchuk valerii.kravchuk 4096 Jan 6 22:19 mysql
[valerii.kravchuk@cisco1 Percona-Server-5.5.28-rel29.3-388.Linux.x86_64]$ ls -l lib/mysql
total 4
drwxr-xr-x 3 valerii.kravchuk valerii.kravchuk 4096 Jan 6 22:20 plugin

Changed in percona-server:
status: New → Confirmed
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :
Download full text (4.2 KiB)

Does not apply to 5.6.10:

[openxs@chief Percona-Server-5.6.10-alpha60.2-324.Linux.x86_64]$ bin/mysql_config --libs
-L/tmp/Percona-Server-5.6.10-alpha60.2-324.Linux.x86_64/lib -lmysqlclient -lpthread -lm -lrt -ldl
[openxs@chief Percona-Server-5.6.10-alpha60.2-324.Linux.x86_64]$ ls -l lib
total 24316
-rw-r--r-- 1 openxs openxs 16862402 Mar 14 02:00 libmysqlclient.a
lrwxrwxrwx 1 openxs openxs 16 May 21 09:04 libmysqlclient_r.a -> libmysqlclient.a
lrwxrwxrwx 1 openxs openxs 17 May 21 09:04 libmysqlclient_r.so -> libmysqlclient.so
lrwxrwxrwx 1 openxs openxs 17 May 21 09:04 libmysqlclient_r.so.18 -> libmysqlclient.so
lrwxrwxrwx 1 openxs openxs 17 May 21 09:04 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
lrwxrwxrwx 1 openxs openxs 20 May 21 09:04 libmysqlclient.so -> libmysqlclient.so.18
lrwxrwxrwx 1 openxs openxs 24 May 21 09:04 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
-rwxr-xr-x 1 openxs openxs 8014994 Mar 14 02:00 libmysqlclient.so.18.0.0
-rw-r--r-- 1 openxs openxs 15086 Mar 14 01:59 libmysqlservices.a
drwxr-xr-x 3 openxs openxs 4096 Mar 14 02:01 plugin

Does not apply to 5.1.x:

[openxs@chief Percona-Server-5.1.68-rel14.6-551.Linux.x86_64]$ bin/mysql_config --libs
-rdynamic -L/tmp/Percona-Server-5.1.68-rel14.6-551.Linux.x86_64/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
[openxs@chief Percona-Server-5.1.68-rel14.6-551.Linux.x86_64]$ ls -l lib
total 4
drwxr-xr-x 3 openxs openxs 4096 Apr 5 22:54 mysql
[openxs@chief Percona-Server-5.1.68-rel14.6-551.Linux.x86_64]$ ls -l lib/mysql/
total 39428
-rw-r--r-- 1 openxs openxs 11178 Apr 5 22:53 libdbug.a
-rw-r--r-- 1 openxs openxs 1091324 Apr 5 22:53 libheap.a
-rw-r--r-- 1 openxs openxs 3858952 Apr 5 22:53 libmyisam.a
-rw-r--r-- 1 openxs openxs 1447988 Apr 5 22:54 libmyisammrg.a
-rw-r--r-- 1 openxs openxs 9523334 Apr 5 22:53 libmysqlclient.a
-rwxr-xr-x 1 openxs openxs 1005 Apr 5 22:53 libmysqlclient.la
-rw-r--r-- 1 openxs openxs 9571606 Apr 5 22:53 libmysqlclient_r.a
-rwxr-xr-x 1 openxs openxs 1059 Apr 5 22:53 libmysqlclient_r.la
lrwxrwxrwx 1 openxs openxs 26 May 21 08:58 libmysqlclient_r.so -> libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 openxs openxs 26 May 21 08:58 libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 openxs openxs 5177409 Apr 5 22:53 libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 openxs openxs 24 May 21 08:58 libmysqlclient.so -> libmysqlclient.so.16.0.0
lrwxrwxrwx 1 openxs openxs 24 May 21 08:58 libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
-rwxr-xr-x 1 openxs openxs 5151986 Apr 5 22:53 libmysqlclient.so.16.0.0
-rw-r--r-- 1 openxs openxs 2461832 Apr 5 22:53 libmystrings.a
-rw-r--r-- 1 openxs openxs 1954024 Apr 5 22:53 libmysys.a
-rw-r--r-- 1 openxs openxs 82036 Apr 5 22:54 libvio.a
drwxr-xr-x 2 openxs openxs 4096 Apr 5 23:09 plugin

But still applies to 5.5.30-30.2:

[openxs@chief Percona-Server-5.5.30-rel30.2-500.Linux.x86_64]$ bin/mysql_config --libs
-L/tmp/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl
[openxs@chief Percona-Server-5.5.30-rel30.2-500.Linux.x86_64]$ ls -l lib/mysql
total 1412
lrwxrwxrwx 1 openxs ope...

Read more...

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

As my last comment had shown, bug was not repeatable with PS 5.6.10 (latest binaries available at that moment). Should I check with 5.6.11 ones released recently or something else?

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Valerii -

Indeed I reset from Invalid to New due to significant changes between 5.6.10 and 5.6.11.

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Indeed, 5.6.11 is affected:

[openxs@centos Percona-Server-5.6.11-rc60.3-375.Linux.x86_64]$ bin/mysql_config --libs
-L/home/openxs/Percona-Server-5.6.11-rc60.3-375.Linux.x86_64/lib/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl
[openxs@centos Percona-Server-5.6.11-rc60.3-375.Linux.x86_64]$ ls -l lib/mysql
total 1080
lrwxrwxrwx. 1 openxs openxs 16 Jun 6 11:13 libjemalloc.so -> libjemalloc.so.1
-rwxr-xr-x. 1 openxs openxs 1098044 Jun 3 00:28 libjemalloc.so.1
drwxr-xr-x. 3 openxs openxs 4096 Jun 3 00:27 plugin
[openxs@centos Percona-Server-5.6.11-rc60.3-375.Linux.x86_64]$ ls -l lib
total 16376
-rw-r--r--. 1 openxs openxs 11073046 Jun 1 11:26 libmysqlclient.a
lrwxrwxrwx. 1 openxs openxs 16 Jun 6 11:13 libmysqlclient_r.a -> libmysqlclient.a
lrwxrwxrwx. 1 openxs openxs 17 Jun 6 11:13 libmysqlclient_r.so -> libmysqlclient.so
lrwxrwxrwx. 1 openxs openxs 17 Jun 6 11:13 libmysqlclient_r.so.18 -> libmysqlclient.so
lrwxrwxrwx. 1 openxs openxs 17 Jun 6 11:13 libmysqlclient_r.so.18.0.0 -> libmysqlclient.so
lrwxrwxrwx. 1 openxs openxs 20 Jun 6 11:13 libmysqlclient.so -> libmysqlclient.so.18
lrwxrwxrwx. 1 openxs openxs 24 Jun 6 11:13 libmysqlclient.so.18 -> libmysqlclient.so.18.0.0
-rwxr-xr-x. 1 openxs openxs 5669301 Jun 1 11:26 libmysqlclient.so.18.0.0
-rw-r--r--. 1 openxs openxs 15054 Jun 1 11:25 libmysqlservices.a
drwxr-xr-x. 3 openxs openxs 4096 Jun 3 00:28 mysql

Revision history for this message
tsubasa tanaka (yoku0825) wrote :

I see PS5.6.19(and PXC 5.6.19) is still affected.

$ bin/mysql_config
Usage: bin/mysql_config [OPTIONS]
Options:
        --cflags [-I/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/include -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -DPERCONA_INNODB_VERSION=rel67.0 -fPIC -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1]
        --cxxflags [-I/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/include -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -DPERCONA_INNODB_VERSION=rel67.0 -fPIC -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1]
        --include [-I/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/include]
        --libs [-L/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql -lperconaserverclient -lpthread -lm -lrt -lssl -lcrypto -ldl]
        --libs_r [-L/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql -lperconaserverclient_r -lpthread -lm -lrt -lssl -lcrypto -ldl]
        --plugindir [/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql/plugin]
        --socket [/tmp/mysql.sock]
        --port [0]
        --version [5.6.19-67.0]
        --libmysqld-libs [-L/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql -lmysqld]
        --variable=VAR VAR is one of:
                pkgincludedir [/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/include]
                pkglibdir [/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql]
                plugindir [/home/ttanaka/Percona-Server-5.6.19-rel67.0-618.Linux.x86_64/lib/mysql/plugin]

And I found "mysql_config --variable=pkglibdir" is wrong too.

Revision history for this message
monty solomon (monty+launchpad) wrote :

The output of

$ mysql_config --libs
-L/usr/lib64 -lperconaserverclient -lpthread -lm -lrt -lssl -lcrypto -ldl

is missing -L/usr/lib64/mysql

for the libraries

libperconaserverclient.a
libperconaserverclient_r.a

$ mysql_config --version
5.5.39-36.0

$ mysql_config --version
5.6.20-68.0

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Related bug 1366169.

tags: added: pkg
Revision history for this message
tsubasa tanaka (yoku0825) wrote :

This is still in 5.6.34.

$ /usr/local/percona5634/bin/mysql_config --libs
-L/usr/local/percona5634/lib/mysql -lperconaserverclient -lpthread -lz -lm -lrt -lssl -lcrypto -ldl

$ ll /usr/local/percona5634/lib/mysql
total 1856
lrwxrwxrwx 1 root root 16 Nov 24 00:19 libjemalloc.so -> libjemalloc.so.1
-rwxr-xr-x 1 root root 1893761 Nov 24 00:19 libjemalloc.so.1
drwxr-xr-x 3 root root 4096 Dec 21 15:44 plugin

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1298

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.