FC4: How to Add MySQL support into PHP?

[pushback]

Hello,

I have my Apache and MySQL servers running great, but PHP will not talk to MySQL. Here's what I get now in the httpd error log:

[client 192.168.100.1] PHP Fatal error: Call to undefined function mysql_pconnect()

[Choozo]

How was Apache, MySQL and PHP installed?

If by RPM, PHP support should already be there unless php_mysql was omitted?

Put up this small PHP file (test.php) on your webserver, and check the output:
<?php phpinfo(); ?>

[Icarus]

Try installing the mod_php apache module

[thaddaeus]

the function name may be incorrect. the function i use is mysql_connect("location","username","password")

php function list (http://www.php.net/quickref.php) will lists all php functions includeing mysql access functions

[Choozo]

the function name may be incorrect. the function i use is mysql_connect("location","username","password")The mysql_pconnect() opens a persistent connection.

[pushback]

PHP was installed when the core was installed, as was Apache & MySQL.

Here's the phpinfo output. Thanks for the help.

PHP Version 5.0.4

System Linux apollo.fourkings.com 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT 2005 i686
Build Date May 9 2005 11:21:49
Configure Command './configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/usr/share/file/magic.mime' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/ldap.ini
PHP API 20031224
PHP Extension 20041030
Zend Extension 220040412
Debug Build no
Thread Safety disabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.bzip2, compress.zlib, https, ftps
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors Off Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2047 2047
expose_php On On
extension_dir /usr/lib/php/modules /usr/lib/php/modules
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/pear .:/usr/share/pear
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time 60 60
memory_limit 8M 8M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
register_argc_argv On On
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache2handler
Apache Version Apache/2.0.54 (Fedora)
Apache API Version 20020903
Server Administrator root@localhost
Hostname:Port www.bestdivespots.com:0
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 120 - Keep-Alive: 15
Virtual Server Yes
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_access mod_auth mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap mod_include mod_log_config mod_logio mod_env mod_mime_magic mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy proxy_ftp proxy_http proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_perl mod_php5 mod_python mod_ssl

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0


Apache Environment
Variable Value
HTTP_ACCEPT */*
HTTP_ACCEPT_LANGUAGE en-us
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
HTTP_HOST www.bestdivespots.com
HTTP_CONNECTION Keep-Alive
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE <address>Apache/2.0.54 (Fedora) Server at www.bestdivespots.com Port 80</address>
SERVER_SOFTWARE Apache/2.0.54 (Fedora)
SERVER_NAME www.bestdivespots.com
SERVER_ADDR 192.168.100.3
SERVER_PORT 80
REMOTE_ADDR 192.168.100.1
DOCUMENT_ROOT /var/www/html/bestdivespots
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/bestdivespots/phpinfo.php
REMOTE_PORT 1635
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /phpinfo.php
SCRIPT_NAME /phpinfo.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /phpinfo.php HTTP/1.1
Accept */*
Accept-Language en-us
Accept-Encoding gzip, deflate
User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Host www.bestdivespots.com
Connection Keep-Alive
HTTP Response Headers
X-Powered-By PHP/5.0.4
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8


bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001


calendar
Calendar support enabled


ctype
ctype functions enabled


curl
CURL support enabled
CURL Information libcurl/7.13.1 OpenSSL/0.9.7f zlib/1.2.2.2 libidn/0.5.15


dbx
dbx support enabled
dbx version 1.1.0
supported databases MySQL ODBC PostgreSQL Microsoft SQL Server FrontBase Oracle 8 (oci8) Sybase-CT SQLite

Directive Local Value Master Value
dbx.colnames_case lowercase lowercase


dio
dio support enabled


exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.162.2.8 2005/03/17 17:20:35 iliaa Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF


ftp
FTP support enabled


gettext
GetText Support enabled


gmp
gmp support enabled


iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.3.5

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.154.2.2 2005/01/19 00:27:42 sniper Exp $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20223


libxml
libXML support active
libXML Version 2.6.19
libXML streams enabled


mime_magic
mime_magic support invalid magic file, disabled

Directive Local Value Master Value
mime_magic.debug Off Off
mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime


openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7f 22 Mar 2005


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 5.0 13-Sep-2004


posix
Revision $Revision: 1.60.2.2 $


pspell
PSpell Support enabled


session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php/session /var/lib/php/session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


shmop
shmop support enabled


SimpleXML
Simplexml support enabled
Revision $Revision: 1.139.2.4 $
Schema support enabled


sockets
Sockets Support enabled


SPL
SPL support enabled
Interfaces RecursiveIterator, SeekableIterator
Classes ArrayObject, ArrayIterator, CachingIterator, CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator


standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.83 90.83
date.sunset_zenith 90.83 90.83
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentr y a=href,area=href,frame=src,input=src,form=fakeentr y
user_agent no value no value


sysvmsg
sysvmsg support enabled
Revision $Revision: 1.16.2.3 $


tokenizer
Tokenizer Support enabled


wddx
WDDX Support enabled
WDDX Session Serializer enabled


xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.19


yp
YP Support enabled


zlib
ZLib Support enabled
Compiled Version 1.2.2.2
Linked Version 1.2.2.2

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name
sysvsem
sysvshm


Environment
Variable Value
LANG C
SELINUX_INIT YES
CONSOLE /dev/pts/0
TERM linux
INIT_VERSION sysvinit-2.85
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
RUNLEVEL 5
runlevel 5
PWD /
PREVLEVEL N
previous N
HOME /
SHLVL 2
_ /usr/sbin/httpd


PHP Variables
Variable Value
_SERVER["HTTP_ACCEPT"] */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
_SERVER["HTTP_HOST"] www.bestdivespots.com
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.54 (Fedora) Server at www.bestdivespots.com Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.54 (Fedora)
_SERVER["SERVER_NAME"] www.bestdivespots.com
_SERVER["SERVER_ADDR"] 192.168.100.3
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.100.1
_SERVER["DOCUMENT_ROOT"] /var/www/html/bestdivespots
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/bestdivespots/phpinfo.php
_SERVER["REMOTE_PORT"] 1635
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /phpinfo.php
_SERVER["SCRIPT_NAME"] /phpinfo.php
_SERVER["PHP_SELF"] /phpinfo.php
_SERVER["argv"] Array
(
)

_SERVER["argc"] 0
_ENV["LANG"] C
_ENV["SELINUX_INIT"] YES
_ENV["CONSOLE"] /dev/pts/0
_ENV["TERM"] linux
_ENV["INIT_VERSION"] sysvinit-2.85
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_ENV["RUNLEVEL"] 5
_ENV["runlevel"] 5
_ENV["PWD"] /
_ENV["PREVLEVEL"] N
_ENV["previous"] N
_ENV["HOME"] /
_ENV["SHLVL"] 2
_ENV["_"] /usr/sbin/httpd


PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.

[pushback]

Try installing the mod_php apache module


When I do this I get an error starting httpd that says the module is already loaded.

[bwkaz]

'--without-mysql' I don't know for sure, but this looks suspect to me.

There should be a version somewhere of PHP that wasn't configured with --disable-mysql... the problem would be finding it.

Either that, or you might be able to reinstall PHP (after installing mysql) -- I don't know if it's even possible for the PHP rpm to do this, but it might detect at runtime whether mysql is installed, and install a separate version of PHP if it is.

Or, look for a php+mysql package (or something like that).

[pushback]

OK--I decoded to try to reinstall mysql, but I run into an error while running the configure script. So I downloaded a tarball from the php site--when I run the configure script I get.

configure: error: xml2-config not found. Please check your libxml2 installation.

So, I tried to install libxml2 through yum but I get :

Nothing to do

[Choozo]

PHP was installed when the core was installed, as was Apache & MySQL.Look into the package management tool in FC4, and add support for MySQL in PHP.

Reinstalling MySQL and PHP from source may be a losing battle when those packages have already been prepared for your distro in the form of RPMs, as you already have experienced.

[bwkaz]

when I run the configure script If you plan on compiling all these packages, you'll need to install the -devel version of all the packages that they depend on. And you'll run into problems when you want to upgrade or remove them, or compile anything else that depends on them (unless you stuff the compiled version in the same place as the RPM version, but that causes problems if it decides to overwrite some files but not all).

[pushback]

Look into the package management tool in FC4, and add support for MySQL in PHP.

Reinstalling MySQL and PHP from source may be a losing battle when those packages have already been prepared for your distro in the form of RPMs, as you already have experienced.

What package management tool?

Does everyone go through these steps when tyring to get PHP to work with MySQL? I am surprised the core did not install with the support in place.

[Choozo]

What package management tool?

Does everyone go through these steps when tyring to get PHP to work with MySQL? I am surprised the core did not install with the support in place.
I believe it is YUM in Fedora?

Usually Apache/MySQL/PHP is set up to run straight from the installation. I'm not sure why this seems to be a problem in FC4 (using Mandrake myself).

[Icarus]

I've never had a problem getting PHP working in Apache (once I've installed all the proper modules and added mod_php moudle to the apache config) with FC2 or before, I doubt there was a major change that screwed it up.

But if we were talking about migrating apache 1 to apache 2, then we have some issues :D

[Choozo]

I believe the problem here is getting PHP to recognize MySQL functions, not getting Apache to parse PHP.

In Mandrake there is a package called 'php-mysql' which handles that.

[pushback]

I believe the problem here is getting PHP to recognize MySQL functions, not getting Apache to parse PHP.

In Mandrake there is a package called 'php-mysql' which handles that.


Yes ... and I have php-mysql installed.

apollo[root]:/root-> rpm -q php-mysql
php-mysql-5.0.4-10.3
apollo[root]:/root->


Still won't work.

Is there a php-mysql module to load? I have the libphp5.so module loaded but I cannot find a php-mysql.so if there is one.

[Choozo]

This (https://www.redhat.com/archives/fedora-list/2005-July/msg01408.html) link may be of help (first hit on a G4L [google.com/linux] search for "FC4 PHP MySQL").

[Syngin]

In Debian the php/mysql package is this:

php4-mysql

This is definitely one of the reason I use Debian. I can have a running and basically configured LAMP box up inside 45 mins with apt.

Edit: Oops sorry. Didn't realize you were talking about PHP5.