1 (edited by carmi 2006-02-11 18:27)

Topic: MySQL PHP Database Support Problem

Hello,

I am trying to install PunBB on a linode through SSH. I am running debian and have installed apache with php. I installed mysql-server through apt-get and I installed php4-mysql also through apt-get. When I access the ip address with a browser I can see the phpinfo file and everything seems fine. The output is

PHP Logo
PHP Version 4.3.10-16

System     Linux li3-247 2.4.29-linode39-1um #1 Wed Jan 19 12:22:14 EST 2005 i686
Build Date     Aug 24 2005 19:29:12
Configure Command     '../configure' '--prefix=/usr' '--with-apxs=/usr/bin/apxs' '--with-config-file-path=/etc/php4/apache' '--enable-memory-limit' '--disable-debug' '--with-regex=php' '--disable-rpath' '--disable-static' '--with-pic' '--with-layout=GNU' '--with-pear=/usr/share/php' '--enable-calendar' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-bcmath' '--with-bz2' '--enable-ctype' '--with-db4' '--with-iconv' '--enable-exif' '--enable-filepro' '--enable-ftp' '--with-gettext' '--enable-mbstring' '--with-pcre-regex=/usr' '--enable-shmop' '--enable-sockets' '--enable-wddx' '--disable-xml' '--with-expat-dir=/usr' '--with-xmlrpc' '--enable-yp' '--with-zlib' '--without-pgsql' '--with-kerberos=/usr' '--with-openssl=/usr' '--with-zip=/usr' '--enable-dbx' '--with-mime-magic=/usr/share/misc/file/magic.mime' '--with-exec-dir=/usr/lib/php4/libexec' '--without-mm' '--with-curl=shared,/usr' '--with-dom=shared,/usr' '--with-dom-xslt=shared,/usr' '--with-dom-exslt=shared,/usr' '--with-zlib-dir=/usr' '--with-gd=shared,/usr' '--enable-gd-native-ttf' '--with-jpeg-dir=shared,/usr' '--with-xpm-dir=shared,/usr/X11R6' '--with-png-dir=shared,/usr' '--with-freetype-dir=shared,/usr' '--with-imap=shared,/usr' '--with-imap-ssl' '--with-ldap=shared,/usr' '--with-mcal=shared,/usr' '--with-mhash=shared,/usr' '--with-mysql=shared,/usr' '--with-unixODBC=shared,/usr' '--with-recode=shared,/usr' '--enable-xslt=shared' '--with-xslt-sablot=shared,/usr' '--with-snmp=shared,/usr' '--with-sybase-ct=shared,/usr' '--with-ttf=shared,/usr' '--with-t1lib=shared,/usr'
Server API     Apache
Virtual Directory Support     disabled
Configuration File (php.ini) Path     /etc/php4/apache/php.ini
PHP API     20020918
PHP Extension     20020429
Zend Extension     20021010
Debug Build     no
Thread Safety     disabled
Registered PHP Streams     php, http, ftp, https, ftps, compress.bzip2, compress.zlib

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

PHP Credits
Configuration
PHP Core
Directive    Local Value    Master Value
allow_call_time_pass_reference    On    On
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_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    On    On
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    2039    2039
expose_php    On    On
extension_dir    /usr/lib/php4/20020429    /usr/lib/php4/20020429
file_uploads    On    On
gpc_order    GPC    GPC
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/php:/usr/share/pear    .:/usr/share/php:/usr/share/pear
log_errors    Off    Off
log_errors_max_len    1024    1024
magic_quotes_gpc    On    On
magic_quotes_runtime    Off    Off
magic_quotes_sybase    Off    Off
max_execution_time    30    30
max_input_time    60    60
memory_limit    8M    8M
open_basedir    no value    no value
output_buffering    no value    no value
output_handler    no value    no value
post_max_size    8M    8M
precision    12    12
register_argc_argv    On    On
register_globals    Off    Off
report_memleaks    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

apache
APACHE_INCLUDE     no value
APACHE_TARGET     no value
Apache Version     Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-16
Apache Release     10333100
Apache API Version     19990320
Hostname:Port     localhost:80
User/Group     www-data(33)/33
Max Requests     Per Child: 100 - Keep Alive: on - Max Per Connection: 100
Timeouts     Connection: 300 - Keep-Alive: 15
Server Root     /etc/apache
Loaded Modules     mod_php4, mod_setenvif, mod_expires, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_cgi, mod_dir, mod_autoindex, mod_status, mod_negotiation, mod_mime, mod_mime_magic, mod_log_config, mod_macro, mod_so, http_core

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

Apache Environment
Variable    Value
DOCUMENT_ROOT     /var/www
HTTP_ACCEPT     text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET     ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING     gzip,deflate
HTTP_ACCEPT_LANGUAGE     en-us,en;q=0.5
HTTP_CONNECTION     keep-alive
HTTP_HOST     64.62.190.247
HTTP_KEEP_ALIVE     300
HTTP_USER_AGENT     Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
PATH     /bin:/usr/bin:/usr/local/bin
REDIRECT_STATUS     200
REDIRECT_URL     /
REMOTE_ADDR     163.41.136.51
REMOTE_PORT     54138
SCRIPT_FILENAME     /var/www/index.php
SERVER_ADDR     64.62.190.247
SERVER_ADMIN     webmaster@localhost
SERVER_NAME     64.62.190.247
SERVER_PORT     80
SERVER_SIGNATURE     <ADDRESS>Apache/1.3.33 Server at 64.62.190.247 Port 80</ADDRESS>
SERVER_SOFTWARE     Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-16
GATEWAY_INTERFACE     CGI/1.1
SERVER_PROTOCOL     HTTP/1.1
REQUEST_METHOD     GET
QUERY_STRING     no value
REQUEST_URI     /
SCRIPT_NAME     /index.php

HTTP Headers Information
HTTP Request Headers
HTTP Request     GET / HTTP/1.1
Accept     text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Charset     ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding     gzip,deflate
Accept-Language     en-us,en;q=0.5
Connection     keep-alive
Host     64.62.190.247
Keep-Alive     300
User-Agent     Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
HTTP Response Headers
X-Powered-By     PHP/4.3.10-16
Keep-Alive     timeout=15, max=100
Connection     Keep-Alive
Transfer-Encoding     chunked
Content-Type     text/html; charset=iso-8859-1

bcmath
BCMath support     enabled

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

calendar
Calendar support     enabled

ctype
ctype functions     enabled

dba
DBA support     enabled
Supported handlers     cdb cdb_make db4 inifile flatfile

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

Directive    Local Value    Master Value
dbx.colnames_case    unchanged    unchanged

exif
EXIF Support     enabled
EXIF Version     1.4 $Id: exif.c,v 1.118.2.35 2005/03/05 18:30:47 rasmus Exp $
Supported EXIF Version     0220
Supported filetypes     JPEG,TIFF

ftp
FTP support     enabled

gettext
GetText Support     enabled

iconv
iconv support     enabled
iconv implementation     glibc
iconv library version     2.3.2

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

mbstring
Multibyte Support     enabled
Japanese support     enabled
Simplified chinese support     enabled
Traditional chinese support     enabled
Korean support     enabled
Russian support     enabled
Multibyte (japanese) regex support     enabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Directive    Local Value    Master Value
mbstring.detect_order    no value    no value
mbstring.encoding_translation    Off    Off
mbstring.func_overload    0    0
mbstring.http_input    pass    pass
mbstring.http_output    pass    pass
mbstring.internal_encoding    ISO-8859-1    no value
mbstring.language    neutral    neutral
mbstring.substitute_character    no value    no value

mime_magic
mime_magic support    enabled

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

mysql
MySQL Support    enabled
Active Persistent Links     0
Active Links     0
Client API version     4.0.24
MYSQL_MODULE_TYPE     external
MYSQL_SOCKET     /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE     -I/usr/include/mysql
MYSQL_LIBS     -L/usr/lib -lmysqlclient

Directive    Local Value    Master Value
mysql.allow_persistent    On    On
mysql.connect_timeout    60    60
mysql.default_host    no value    no value
mysql.default_password    no value    no value
mysql.default_port    no value    no value
mysql.default_socket    no value    no value
mysql.default_user    no value    no value
mysql.max_links    Unlimited    Unlimited
mysql.max_persistent    Unlimited    Unlimited
mysql.trace_mode    Off    Off

openssl
OpenSSL support     enabled
OpenSSL Version     OpenSSL 0.9.7e 25 Oct 2004

overload
User-Space Object Overloading Support     enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support     enabled
PCRE Library Version     4.5 01-December-2003

posix
Revision     $Revision: 1.51.2.3 $

session
Session Support     enabled
Registered save handlers     files user

Directive    Local Value    Master Value
session.auto_start    Off    Off
session.bug_compat_42    On    On
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    100    100
session.gc_maxlifetime    1440    1440
session.gc_probability    0    0
session.name    PHPSESSID    PHPSESSID
session.referer_check    no value    no value
session.save_handler    files    files
session.save_path    /var/lib/php4    /var/lib/php4
session.serialize_handler    php    php
session.use_cookies    On    On
session.use_only_cookies    Off    Off
session.use_trans_sid    Off    Off

shmop
shmop support     enabled

sockets
Sockets Support     enabled

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
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=,fieldset=    a=href,area=href,frame=src,input=src,form=,fieldset=
user_agent    no value    no value

sysvmsg
sysvmsg support    enabled
Revision     $Revision: 1.4.2.5 $

tokenizer
Tokenizer Support     enabled

wddx
WDDX Support    enabled
WDDX Session Serializer     enabled

xml
XML Support     active
XML Namespace Support     active
EXPAT Version     expat_1.95.8

xmlrpc
core library version     xmlrpc-epi v. 0.51
php extension version     0.51
author     Dan Libby
homepage     http://xmlrpc-epi.sourceforge.net
open sourced by     Epinions.com

yp
YP Support     enabled

zip
Zip support     enabled

zlib
ZLib Support     enabled
Compiled Version     1.2.2
Linked Version     1.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
filepro
sysvsem
sysvshm

Environment
Variable    Value
LANG     C
PATH     /bin:/usr/bin:/usr/local/bin

PHP Variables
Variable    Value
_SERVER["DOCUMENT_ROOT"]    /var/www
_SERVER["HTTP_ACCEPT"]    text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
_SERVER["HTTP_ACCEPT_CHARSET"]    ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_ACCEPT_ENCODING"]    gzip,deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"]    en-us,en;q=0.5
_SERVER["HTTP_CONNECTION"]    keep-alive
_SERVER["HTTP_HOST"]    64.62.190.247
_SERVER["HTTP_KEEP_ALIVE"]    300
_SERVER["HTTP_USER_AGENT"]    Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
_SERVER["PATH"]    /bin:/usr/bin:/usr/local/bin
_SERVER["REDIRECT_STATUS"]    200
_SERVER["REDIRECT_URL"]    /
_SERVER["REMOTE_ADDR"]    163.41.136.51
_SERVER["REMOTE_PORT"]    54138
_SERVER["SCRIPT_FILENAME"]    /var/www/index.php
_SERVER["SERVER_ADDR"]    64.62.190.247
_SERVER["SERVER_ADMIN"]    webmaster@localhost
_SERVER["SERVER_NAME"]    64.62.190.247
_SERVER["SERVER_PORT"]    80
_SERVER["SERVER_SIGNATURE"]    <ADDRESS>Apache/1.3.33 Server at 64.62.190.247 Port 80</ADDRESS>
_SERVER["SERVER_SOFTWARE"]    Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-16
_SERVER["GATEWAY_INTERFACE"]    CGI/1.1
_SERVER["SERVER_PROTOCOL"]    HTTP/1.1
_SERVER["REQUEST_METHOD"]    GET
_SERVER["QUERY_STRING"]    no value
_SERVER["REQUEST_URI"]    /
_SERVER["SCRIPT_NAME"]    /index.php
_SERVER["PATH_TRANSLATED"]    /var/www/index.php
_SERVER["PHP_SELF"]    /index.php
_SERVER["argv"]    

Array
(
)

_SERVER["argc"]    0
_ENV["LANG"]    C
_ENV["PATH"]    /bin:/usr/bin:/usr/local/bin

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.

I have according to install procedures moved all files from the upload directory to the place I want to install to (punbb_mysql). I got an error when I accessed http://mydomain/punbb_mysql while index.php was there so I renamed index.php to ori.index.php. Now I am shown a listing of the files in http://mydomain/punbb_mysql but when I run install.php I get the following error message:

This PHP environment does not have support for any of the databases that PunBB supports. PHP needs to have support for either MySQL, PostgreSQL or SQLite in order for PunBB to be installed.

I thought that to get mysql working with php I only needed to issue the php4-mysql command through apt-get and that would add the module for mysql to php and everything would be peachy. Unfortunetly this is not what is happening and I need a little help on how to get php to support mysql.

Thanks,
Evan

Re: MySQL PHP Database Support Problem

Well, your phpinfo() output shows that MySQL support is not enabled in your PHP installation. How to enable it is a Debian issue though and I'm not sure how to help you. Perhaps there's a Debian user here that can help?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

3

Re: MySQL PHP Database Support Problem

carmi,

apt-get install php4-mysql does install MySQL support into Debian and should add a line to your php.ini file.

Have you restarted Apache?

4

Re: MySQL PHP Database Support Problem

hcgtv wrote:

carmi,

apt-get install php4-mysql does install MySQL support into Debian and should add a line to your php.ini file.

Have you restarted Apache?

You nailed the problem on the head. Thanks. All I had to do was go to /etc/init.d and run

./apache restart

and after restarting apache everything worked fine.

Thanks so much Evan.

p.s. I am going to edit my original posts and include phpinfo information so if i change it people wanting help with this same problem can compare there phpinfo to mine. Hope you dont mind. smile