Click to See Complete Forum and Search --> : PHP & MYSQL Problems


AvisVitae382
02-20-2004, 03:27 PM
Hey guys,

I have searched for this answer, but the only results I get are threads that ended with someone saying that php and mysql needed to be configured properly (and thats exactly my question)

I am trying to do a simple apache2/php4/mysql4/phpBB2 forum setup.

Apache is running fine, PHP 4 is running fine
MySQL is running fine as a database server

the problem comes when setting up phpBB2, I run the install.php page, set everything up correctly, and I get the error B]"The php configuration on your server doesn't support the database type that you chose.[/B]

I have compiled and installed version 4.3.4 of PHP and 4.3.2 and neither of them work. I have compiled them both with the axps2 option for Apache and the mySql option for the database. I installed mySQL using the RPMs, but I also have installed the -devel RPMS for the server. I don't get any errors during ./configure, make, or make install on PHP and the mySQL scripts in the makefile seem to work just fine.

I have restarted apache several times and done a reboot of the server.

Any ideas? Thanks

The Linux Kid
02-20-2004, 03:33 PM
Make a script with:


<?

phpinfo();

?>


and post the output here.

The Linux Kid

AvisVitae382
02-20-2004, 03:59 PM
Here ya go:

PHP Version 4.3.3

System Linux CDNTEST 2.4.22-1.2115.nptl #1 Wed Oct 29 15:42:51 EST 2003 i686
Build Date Oct 21 2003 09:55:29
Configure Command './configure' '--host=i386-redhat-linux' '--build=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-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-pear=/usr/share/pear' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-apxs2=/usr/sbin/apxs'
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/imap.ini, /etc/php.d/ldap.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

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2003 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 /usr/lib/php4
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/pear .:/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 14 14
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 me@localhost.com me@localhost.com
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

apache2handler
Apache Version Apache/2.0.48 (Fedora)
Apache API Version 20020903
Server Administrator root@localhost
Hostname:Port cdntest.thompsonmachinery.com:0
User/Group apache(48)/48
Max Requests Per Child: 1000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15
Virtual Server No
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_env mod_mime_magic mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack mod_unique_id 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_imap 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 sapi_apache2 mod_python mod_ssl

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

Apache Environment
Variable Value
UNIQUE_ID J0rOQQq7Gh4AADOAY90AAAAA
HTTP_HOST cdntest
HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031114
HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,*/*;q=0.1
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_ACCEPT_ENCODING gzip,deflate
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_KEEP_ALIVE 300
HTTP_CONNECTION keep-alive
HTTP_CACHE_CONTROL max-age=0
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
SERVER_SIGNATURE <address>Apache/2.0.48 (Fedora) Server at cdntest Port 80</address>
SERVER_SOFTWARE Apache/2.0.48 (Fedora)
SERVER_NAME cdntest
SERVER_ADDR 10.187.26.30
SERVER_PORT 80
REMOTE_ADDR 10.187.26.30
DOCUMENT_ROOT /var/www/html
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/test.php
REMOTE_PORT 32804
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /test.php
SCRIPT_NAME /test.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET /test.php HTTP/1.1
Host cdntest
User-Agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031114
Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,*/*;q=0.1
Accept-Language en-us,en;q=0.5
Accept-Encoding gzip,deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 300
Cache-Control max-age=0
HTTP Response Headers
X-Powered-By PHP/4.3.3
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8

bcmath
BCMath support enabled

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.10.6 OpenSSL/0.9.7a ipv6 zlib/1.2.0.7

dba
DBA support enabled
Supported handlers gdbm 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

dio
dio support enabled

exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.118.2.23 2003/06/25 13:21:54 edink Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

ftp
FTP support enabled

gd
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

gettext
GetText Support enabled

gmp
gmp 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

imap
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled

ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.130.2.4 2003/04/30 21:54:02 iliaa Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20122

mbstring
Multibyte Support enabled
Japanese 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

openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.7a Feb 19 2003

overload
User-Space Object Overloading Support enabled

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 4.3 21-May-2003

posix
Revision $Revision: 1.51.2.2 $

pspell
PSpell Support enabled

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 1 1
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /tmp /tmp
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=,fieldse t= a=href,area=href,frame=src,input=src,form=,fieldse t=
user_agent no value no value

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.5

yp
YP Support enabled

zlib
ZLib Support enabled
Compiled Version 1.2.0.7
Linked Version 1.2.0.7

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
SSH_AGENT_PID 3387
HOSTNAME CDNTEST
TERM xterm
SHELL /bin/bash
DESKTOP_STARTUP_ID no value
HISTSIZE 1000
GTK_RC_FILES /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
WINDOWID 31457353
USER root
LS_COLORS no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
SSH_AUTH_SOCK /tmp/ssh-ZfdJ3319/agent.3319
USERNAME root
SESSION_MANAGER local/CDNTEST:/tmp/.ICE-unix/3319
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
DESKTOP_SESSION default
MAIL /var/spool/mail/root
PWD /root/downloads/php/php-4.3.2
INPUTRC /etc/inputrc
XMODIFIERS @im=none
LANG en_US.UTF-8
GDMSESSION default
SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass
SHLVL 3
HOME /root
GNOME_DESKTOP_SESSION_ID Default
BASH_ENV /root/.bashrc
LOGNAME root
LESSOPEN |/usr/bin/lesspipe.sh %s
DISPLAY :0.0
G_BROKEN_FILENAMES 1
XAUTHORITY /root/.Xauthority
COLORTERM gnome-terminal
_ /usr/sbin/httpd

PHP Variables
Variable Value
_SERVER["UNIQUE_ID"] J0rOQQq7Gh4AADOAY90AAAAA
_SERVER["HTTP_HOST"] cdntest
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031114
_SERVER["HTTP_ACCEPT"] text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,*/*;q=0.1
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"] gzip,deflate
_SERVER["HTTP_ACCEPT_CHARSET"] ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_KEEP_ALIVE"] 300
_SERVER["HTTP_CONNECTION"] keep-alive
_SERVER["HTTP_CACHE_CONTROL"] max-age=0
_SERVER["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.48 (Fedora) Server at cdntest Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.48 (Fedora)
_SERVER["SERVER_NAME"] cdntest
_SERVER["SERVER_ADDR"] 10.187.26.30
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 10.187.26.30
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/test.php
_SERVER["REMOTE_PORT"] 32804
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /test.php
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["PHP_SELF"] /test.php
_SERVER["PATH_TRANSLATED"] /var/www/html/test.php
_SERVER["argv"]

Array
(
)

_SERVER["argc"] 0
_ENV["SSH_AGENT_PID"] 3387
_ENV["HOSTNAME"] CDNTEST
_ENV["TERM"] xterm
_ENV["SHELL"] /bin/bash
_ENV["DESKTOP_STARTUP_ID"] no value
_ENV["HISTSIZE"] 1000
_ENV["GTK_RC_FILES"] /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
_ENV["WINDOWID"] 31457353
_ENV["USER"] root
_ENV["LS_COLORS"] no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd =40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;4 1:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.b tm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar= 00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00 ;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.b z2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio= 00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00 ;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
_ENV["SSH_AUTH_SOCK"] /tmp/ssh-ZfdJ3319/agent.3319
_ENV["USERNAME"] root
_ENV["SESSION_MANAGER"] local/CDNTEST:/tmp/.ICE-unix/3319
_ENV["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_ENV["DESKTOP_SESSION"] default
_ENV["MAIL"] /var/spool/mail/root
_ENV["PWD"] /root/downloads/php/php-4.3.2
_ENV["INPUTRC"] /etc/inputrc
_ENV["XMODIFIERS"] @im=none
_ENV["LANG"] en_US.UTF-8
_ENV["GDMSESSION"] default
_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass
_ENV["SHLVL"] 3
_ENV["HOME"] /root
_ENV["GNOME_DESKTOP_SESSION_ID"] Default
_ENV["BASH_ENV"] /root/.bashrc
_ENV["LOGNAME"] root
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["DISPLAY"] :0.0
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["XAUTHORITY"] /root/.Xauthority
_ENV["COLORTERM"] gnome-terminal
_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.

END

Choozo
02-20-2004, 04:28 PM
And what type/sort of database have you set phpBB2 to use in its config file(s)?

Cheers :)

AvisVitae382
02-20-2004, 04:40 PM
MySQL 4.x

Choozo
02-20-2004, 04:56 PM
Could it be that phpBB2 lack support for MySQL 4?

Have you tried other simple php-scripts to make a connection to your database?

AvisVitae382
02-20-2004, 05:02 PM
I was going to work up some simple PHP query scripts to pull from MySQL to attempt the connection.

However, PhpBB2 supports mySQL4 according to its documentation, and the option of "MySQL 4.x" in its "Database Type" field during install.

?

The Linux Kid
02-20-2004, 09:57 PM
Ok, first thing, I use phpbb with mySql4

Second thing,

to me, it looks like you have compiled mysql into php, but for some reason it didn't configure itself in php.ini

Hope that helps,

The Linux Kid

AvisVitae382
02-22-2004, 02:58 AM
what should I do to php.ini ?

The Linux Kid
02-22-2004, 02:46 PM
Can you pls post your php.ini??

Thanks.

AvisVitae382
02-22-2004, 09:09 PM
I'll post it tomorrow afternoon. The server is at work, and we use Sunday's for system maintenance, so I'd rather wait until then.

Thanks guys for your help, and in advance for anything else you can offer.

The Linux Kid
02-23-2004, 01:45 AM
Ok I'll check back then...

The Linux Kid

AvisVitae382
02-23-2004, 03:42 PM
ok, confusion here ..

I have two php.ini files (not counting the ones that come with the source files).

One is in /etc/
One is in /usr/local/lib

The PHP documentation says to cp the -dist file to /usr/local/lib, which I did,

Which one of these is the PHP interpreter using? I will post that one.

Thanks

AvisVitae382
02-23-2004, 04:02 PM
Previous post still applies, but here is php.ini ; Default port to connect to.
pfpro.defaultport = 443

; Default timeout in seconds.
pfpro.defaulttimeout = 30

; Default proxy IP address (if required).
;pfpro.proxyaddress =

; Default proxy port.
;pfpro.proxyport =

; Default proxy logon.
;pfpro.proxylogon =

; Default proxy password.
;pfpro.proxypassword =

[Sockets]
; Use the system read() function instead of the php_read() wrapper.
sockets.use_system_read = On

[com]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file =
; allow Distributed-COM calls
;com.allow_dcom = true
; autoregister constants of a components typlib on com_load()
;com.autoregister_typelib = true
; register constants casesensitive
;com.autoregister_casesensitive = false
; show warnings on duplicate constat registrations
;com.autoregister_verbose = true

[Printer]
;printer.default_printer = ""

[mbstring]
; language for internal character representation.
;mbstring.language = Japanese

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP

; http input encoding.
;mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS

; enable automatic encoding translation accoding to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
; portable libs/applications.
;mbstring.encoding_translation = Off

AvisVitae382
02-23-2004, 04:06 PM
continued


; automatic encoding detection order.
; auto means
;mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
;mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
;mbstring.func_overload = 0

[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
;fbsql.batchSize = 1000

[Crack]
; Modify the setting below to match the directory location of the cracklib
; dictionary files. Include the base filename, but not the file extension.
; crack.default_dictionary = "c:\php\lib\cracklib_dict"

[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel = UCS-2LE
;exif.encode_jis =
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel = JIS

; Local Variables:
; tab-width: 4
; End:

AvisVitae382
02-23-2004, 05:56 PM
Just FYI:

I wrote a PHP script that run the " Select * from " query to a mySQL table, and it didn't work. It works on another server running all the same stuff except under Windows 2000 / IIS 6

The error returned, from PHP, "Fatal error: Call to undefined function: mysql_connect() in [www directory] on line 5"

Suggests to me that PHP is not installed correctly for mySQL, since mysql_connect() is an internal function of the PHP core

Any thoughts on fixing this?