php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #36014 PDO_MYSQL missing mysql_query
Submitted: 2006-01-14 21:54 UTC Modified: 2006-01-22 01:00 UTC
Votes:12
Avg. Score:4.4 ± 0.9
Reproduced:12 of 12 (100.0%)
Same Version:2 (16.7%)
Same OS:1 (8.3%)
From: FranciscSimon at yahoo dot de Assigned:
Status: No Feedback Package: PDO related
PHP Version: 5.1.2 OS: Mandriva 2006
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2006-01-14 21:54 UTC] FranciscSimon at yahoo dot de
Description:
------------
Hi,

i installed first PDO with pecl install PDO. After i tried first pecl install PDO_MYSQL and it doesn't work. After that i decide to compile it manualy. during ./configure it shows me this configure: error

=>
....
configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?

compiling command was 

phpize && ./configure && make && make install

THX 

:-) 

Frank



Reproduce code:
---------------
configure: WARNING: You will need re2c 0.9.11 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-01-14 22:53 UTC] tony2001@php.net
Put your config.log somewhere and paste the URL here.
 [2006-01-16 15:13 UTC] dstloukal at post dot cz
Hello,

I had the same problem. So I tried to use

./configure --with-pdo-mysql=/path/to/your/mysql/installation
(E.G.: /usr/local/mysql)

and it is all right now.
 [2006-01-22 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, 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".
 [2009-04-02 09:50 UTC] cocowool at gmail dot com
i also had this problem
my system is fc10 and php is 5.2.6
when i used "pecl install pdo_mysql"
the error listed below:

downloading PDO_MYSQL-1.0.2.tgz ...
Starting to download PDO_MYSQL-1.0.2.tgz (14,778 bytes)
.....done: 14,778 bytes
7 source files, building
running: phpize
Configuring for:
PHP Api Version:         20041225
Zend Module Api No:      20060613
Zend Extension Api No:   220060519
config.m4:104: warning: AC_CACHE_VAL(pdo_inc_path, ...): suspicious cache-id, must contain _cv_ to be cached
../../lib/autoconf/general.m4:1974: AC_CACHE_VAL is expanded from...
../../lib/autoconf/general.m4:1994: AC_CACHE_CHECK is expanded from...
aclocal.m4:2729: PHP_CHECK_PDO_INCLUDES is expanded from...
config.m4:104: the top level
config.m4:104: warning: AC_CACHE_VAL(pdo_inc_path, ...): suspicious cache-id, must contain _cv_ to be cached
../../lib/autoconf/general.m4:1974: AC_CACHE_VAL is expanded from...
../../lib/autoconf/general.m4:1994: AC_CACHE_CHECK is expanded from...
aclocal.m4:2729: PHP_CHECK_PDO_INCLUDES is expanded from...
config.m4:104: the top level
building in /var/tmp/pear-build-root/PDO_MYSQL-1.0.2
running: /var/tmp/PDO_MYSQL/configure
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for a sed that does not truncate output... /bin/sed
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking whether gcc and cc understand -c and -o together... yes
checking for system library directory... lib
checking if compiler supports -R... no
checking if compiler supports -Wl,-rpath,... yes
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for PHP prefix... /usr
checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib
checking for PHP extension directory... /usr/lib/php/modules
checking for PHP installed headers prefix... /usr/include/php
checking for re2c... no
configure: WARNING: You will need re2c 0.12.0 or later if you want to regenerate PHP parsers.
checking for gawk... gawk
checking for MySQL support for PDO... yes, shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_query in -lmysqlclient... no
configure: error: mysql_query missing!?
ERROR: `/var/tmp/PDO_MYSQL/configure' failed

anyone can help

thanks
 [2010-10-02 19:59 UTC] casualbabies at yahoo dot co dot jp
Hi.

I had this problem that error messeges
"ERROR: `/var/tmp/PDO_MYSQL/configure' failed" when installing pdo_mysql.

But i resolved this problem

that reason why this masseges appear is you don't install php-mysql.

if you install php-mysql by "yum -y install php-mysql", you will already have 
install pdo and pdo-mysql

you don't need to use "pecl install pdo_mysql".

then you should insert to php.ini
"extension=pdo.so"
"extension=pdo-mysql.so"

you can work pdo.

Have a fun!!
 [2011-01-21 22:45 UTC] aleksey000 at hotmail dot com
Had the same problem, which also caused "Couldn't locate driver named mysql" when 
running doctrine:insert-sql in symfony. yum -y install php-mysql as per prev post 
resolved the issue. Thank you!

Fedora 14
PHP 5.3.4
 [2019-06-06 08:44 UTC] 1120238065 at qq dot com
Hi,

i have the same problem 

anyone can help me
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 25 06:01:35 2024 UTC