[wplug] MySQL help?
Scott Bourns
scott at scottbourns.com
Mon Jun 9 14:11:18 EDT 2003
Hey, it's:
phpinfo();
Just sent an attached html file - too big according to admin, so here's the
attached text file.
See anything?
Thanks for the phpinfo(); tip!
Scott
On 6/9/03 1:38 PM, "Chris" <vze2f6h6 at verizon.net> wrote:
>
>> -----Original Message-----
>> From: wplug-admin at wplug.org [mailto:wplug-admin at wplug.org] On Behalf Of
>> Scott Bourns
>> Sent: Monday, June 09, 2003 1:18 PM
>> To: wplug at wplug.org
>> Subject: [wplug] MySQL help?
>>
>> Problem: I can log in from localhost, via telnet or terminal, and do
>> whatever I want to the tables I'm testing; but I can't access the MySQL
>> tables remotely and a simple PHP page with mysql_connect() returns:
>>
>> Fatal error : Call to undefined function: mysql_connect() in
>> /var/www/html/mysqltest.php on line 2
>>
>> --------------
>>
>> Any ideas?
>>
>> Thanks in advance!
>>
>> Scott
>>
>
> It's been a while since I used it but try calling "php_info();" I think
> that's it.
>
> This should tell you if it's been complied for mysql or not.
>
> Chris Romano
>
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
>
>
-------------- next part --------------
PHP Version 4.2.2
System Linux daffy.perf.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 i686 i386 GNU/Linux
Build Date Sep 3 2002 05:25:09
Configure Command './configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-linux-gnu' '--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' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-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-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=/usr/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-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mcal' '--with-apxs2=/usr/sbin/apxs'
Server API Apache 2.0 Filter
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Debug Build no
Thread Safety disabled
This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
------------------------------------------------------------------------
PHP 4 Credits
------------------------------------------------------------------------
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen 1 1
always_populate_raw_post_data 0 0
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_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_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 1 1
gpc_order GPC GPC
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF9900 #FF9900
highlight.default #0000CC #0000CC
highlight.html #000000 #000000
highlight.keyword #006600 #006600
highlight.string #CC0000 #CC0000
html_errors On On
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/share/pear .:/usr/share/pear
log_errors Off Off
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
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
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 at localhost.com me at localhost.com
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
short_open_tag Off Off
SMTP localhost localhost
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 20M 20M
upload_tmp_dir /var/www/html/tmp /var/www/html/tmp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance Off Off
yp
YP Support enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.4
wddx
WDDX Support enabled
WDDX Session Serializer 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
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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
sockets
Sockets Support enabled
shmop
shmop support enabled
session
Session Support enabled
Directive Local Value Master Value
session.auto_start Off Off
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_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_trans_sid 1 1
pspell
PSpell Support enabled
posix
Revision $Revision: 1.42.2.2 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.6b [engine] 9 Jul 2001
iconv
iconv support enabled
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
gmp
gmp support enabled
gettext
GetText Support enabled
gd
GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with freetype
JPG Support enabled
PNG Support enabled
WBMP Support enabled
ftp
FTP support enabled
exif
EXIF Support enabled
EXIF Version 1.2
Supported EXIF Version 02100
Supported filetypes JPEG,TIFF
domxml
DOM/XML enabled
libxml Version 2.4.23
HTML Support enabled
XPath Support enabled
XPointer Support enabled
dio
dio support enabled
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT
dba
DBA support enabled
Supported handlers gdbm db3
curl
CURL support enabled
CURL Information libcurl 7.9.8 (OpenSSL 0.9.6b) (ipv6 enabled)
ctype
ctype functions enabled (experimental)
calendar
Calendar support enabled
bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001
bcmath
BCMath support enabled
zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.4
Linked Version 1.1.4
Directive Local Value Master Value
zlib.output_compression Off Off
imap
IMAP Support enabled
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.116.2.1 2002/04/23 18:59:57 derick Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20025
Apache 2.0
Additional Modules
sysvshm
sysvsem
Environment
Variable Value
CONSOLE /dev/console
TERM linux
INIT_VERSION sysvinit-2.84
AUTOBOOT YES
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
RUNLEVEL 5
runlevel 5
BOOT_FILE /boot/vmlinuz-2.4.18-14
PWD /
LANG en_US.UTF-8
PREVLEVEL N
previous N
HOME /
SHLVL 2
BOOT_IMAGE linux
_ /sbin/initlog
PHP Variables
Variable Value
_SERVER["UNIQUE_ID"] c3cGeH8AAAEAABAwIZUAAAADÊ
_SERVER["HTTP_HOST"] xxx.xxx.xxx.xxxÊ
_SERVER["HTTP_CONNECTION"] keep-aliveÊ
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us) AppleWebKit/74 (KHTML, like Gecko) Safari/74Ê
_SERVER["HTTP_ACCEPT"] */*Ê
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us, ja;q=0.62, de-de;q=0.93, de;q=0.90, fr-fr;q=0.86, fr;q=0.83, nl-nl;q=0.79, nl;q=0.76, it-it;q=0.72, it;q=0.69, ja-jp;q=0.66, en;q=0.97, es-es;q=0.59, es;q=0.55, da-dk;q=0.52, da;q=0.48, fi-fi;q=0.45, fi;q=0.41, ko-kr;q=0.38, ko;q=0.34, no-no;q=0.31, no;q=0.28, pt-pt;q=0.24, pt;q=0.21, sv-se;q=0.17, sv;q=0.14, zh-cn;q=0.10, zh-tw;q=0.07, zh;q=0.03Ê
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/binÊ
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.40 Server at xxx.xxx.xxx.xxx Port 80</address>
Ê
_SERVER["SERVER_SOFTWARE"] Apache/2.0.40 (Red Hat Linux)Ê
_SERVER["SERVER_NAME"] xxx.xxx.xxx.xxxÊ
_SERVER["SERVER_ADDR"] xxx.xxx.xxx.xxxÊ
_SERVER["SERVER_PORT"] 80Ê
_SERVER["REMOTE_ADDR"] xxx.xxx.xxx.xxxÊ
_SERVER["DOCUMENT_ROOT"] /var/www/htmlÊ
_SERVER["SERVER_ADMIN"] webmaster at mydomain.comÊ
_SERVER["SCRIPT_FILENAME"] /var/www/html/phpinfo.phpÊ
_SERVER["REMOTE_PORT"] 1461Ê
_SERVER["GATEWAY_INTERFACE"] CGI/1.1Ê
_SERVER["SERVER_PROTOCOL"] HTTP/1.1Ê
_SERVER["REQUEST_METHOD"] GETÊ
_SERVER["QUERY_STRING"] Ê
_SERVER["REQUEST_URI"] /phpinfo.phpÊ
_SERVER["SCRIPT_NAME"] /phpinfo.phpÊ
_SERVER["PHP_SELF"] /phpinfo.phpÊ
_SERVER["argv"]
Array
(
)
Ê
_SERVER["argc"] 0Ê
_ENV["CONSOLE"] /dev/consoleÊ
_ENV["TERM"] linuxÊ
_ENV["INIT_VERSION"] sysvinit-2.84Ê
_ENV["AUTOBOOT"] YESÊ
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/binÊ
_ENV["RUNLEVEL"] 5Ê
_ENV["runlevel"] 5Ê
_ENV["BOOT_FILE"] /boot/vmlinuz-2.4.18-14Ê
_ENV["PWD"] /Ê
_ENV["LANG"] en_US.UTF-8Ê
_ENV["PREVLEVEL"] NÊ
_ENV["previous"] NÊ
_ENV["HOME"] /Ê
_ENV["SHLVL"] 2Ê
_ENV["BOOT_IMAGE"] linuxÊ
_ENV["_"] /sbin/initlogÊ
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 at php.net.
yp
YP Support enabled
xml
XML Support active
XML Namespace Support active
EXPAT Version expat_1.95.4
wddx
WDDX Support enabled
WDDX Session Serializer 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
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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
sockets
Sockets Support enabled
shmop
shmop support enabled
session
Session Support enabled
Directive Local Value Master Value
session.auto_start Off Off
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_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_trans_sid 1 1
pspell
PSpell Support enabled
posix
Revision $Revision: 1.42.2.2 $
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.4 22-Aug-2000
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.6b [engine] 9 Jul 2001
iconv
iconv support enabled
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
gmp
gmp support enabled
gettext
GetText Support enabled
gd
GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with freetype
JPG Support enabled
PNG Support enabled
WBMP Support enabled
ftp
FTP support enabled
exif
EXIF Support enabled
EXIF Version 1.2
Supported EXIF Version 02100
Supported filetypes JPEG,TIFF
domxml
DOM/XML enabled
libxml Version 2.4.23
HTML Support enabled
XPath Support enabled
XPointer Support enabled
dio
dio support enabled
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL
ODBC
PostgreSQL
Microsoft SQL Server
FrontBase
Oracle 8 (not really)
Sybase-CT
dba
DBA support enabled
Supported handlers gdbm db3
curl
CURL support enabled
CURL Information libcurl 7.9.8 (OpenSSL 0.9.6b) (ipv6 enabled)
ctype
ctype functions enabled (experimental)
calendar
Calendar support enabled
bz2
BZip2 Support Enabled
BZip2 Version 1.0.2, 30-Dec-2001
bcmath
BCMath support enabled
zlib
ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.4
Linked Version 1.1.4
Directive Local Value Master Value
zlib.output_compression Off Off
imap
IMAP Support enabled
IMAP c-Client Version 2001
SSL Support enabled
Kerberos Support enabled
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.116.2.1 2002/04/23 18:59:57 derick Exp $
Total Links 0/unlimited
API Version 2004
Vendor Name OpenLDAP
Vendor Version 20025
Apache 2.0
Additional Modules
sysvshm
sysvsem
More information about the wplug
mailing list