MySQL Connect problems
 

Hi

I am able to start the mysql console and send commands like Show Status etc

but in a .php file when i give a line like

mysql_connect("localhost", "root", "xxx");

nothing seems to happen, even if i give the next lines as

echo "Hello World !!!";

this is not echoed to the browser

what could i be doing wrong

Note: i am a regular user of PHP/MySQL in the Windows environment.


vnb400

can you get anything from php? such as phpinfo()

then assuming that you have apache and php setup properly, you should turn on error printing in the phpini..

Hi

After executing phpinfo() i get a long list of configuration settings, significant among them being

'--without-mysql'

is this the problem, if so how do i correct this (in which configuration file)

if necessary i will post the entire message returned by phpinfo()

Thanks
vnb400

You will need to compile your php with mysql. You add the mysql when you configure the make file. The basic commands are:

./configure <<add your configuration settings here>>
make
make install

recompiling is what i would also do. however someone here (@ LQ) told me that they were able to add mysql support without recompiling. it was here in the programming forum, so you might be able to find it with a search.

though recompiling php does not take long at all, so it may be just as fast to do that.

the best thing to do with every compile is
and review all the options..

You don't have to recompile if it's windows because php comes with the dlls and they can be linked in dynamically. I believe that the same approach is possible with Linux by creating the appropriate .so file but most people just reconfigue and recompile php that way the module is directly in the php version and cuts out to overheads of a call to an external library.

Hi

I am totally new to development on Linux platform, these terms like recompile or .so file or ./configure are alien to me.

I installed Fedora coder 4 , start httpd and mysqld service from the main menu , created a simple php file with statments

$status = mysql_connect("localhost", "root", "xxxOnTheRocks");
if($status)
echo "Connected";
else
echo "Failed to connect to MySQL";


it stops at $status = ...

Can someone guide me on how to proceed.

On account of this problem, i have avoided bidding for Linux-based project which require MySQL database.


vnb400

Which distribution are you using? You can put that in your profile for this forum for future reference ..
Depending on your distribution, it might be easier to use package-managers to re/install mysql

There are a number of thing that you will need to do to isolate the problem:

1. Can you connect to MySQL from the command line?
2. What happens when you echo something out before the connect call?
3. Does your php ini file display errors to the screen?

That should help as a starter, basically you want to ensure that MySQL is running, That php is running alright and that you are seeing the errors that come from php

mysql connect problems
 

Hi

I have use mysql console without any problems, the common statement i test i "show status"

echo "Hello World"; // or anything similar works
if i give the following command

mysql_connect("localhost", "root", "whatTheHeck") or die("Failed to connect ..");

Failed to connect displays on the screen.

I do not get error message on the screen, tried to change displayErrorMessage to On from OFF on phi.ini, that too does not work.

I feel the problem is with PHP, not MySQL, tried to use some SQL Manager in a a .gz file but could not find how to use it.

Tried to use mysql Administrator, could not find how to use it either.

Very frustrating indeed.

vnb400

I believe that the original problem has been skipped over for some reason.

> '--without-mysql'

means that php is running without mysql support. so unless you have done something to fix this, it is not going to work.

what you need to do is either figure out how to install mysql support into a build php install, or recompile php. recompiling is easy, and im sure there is a tutorial or 10 in the tutoial section here at LQ. and hundreds on google.

basically download php
untar
cd into the new untared dir
execute `./configure --help`
see what options apply to you
execute `./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql --with-apxs.....` (there are more options but you get the point)
execute `make`
execute `make install`

again this process has alot of variables to it so getting walked through step by step is not gonna happen, atleast not by be. so find a tutorial use what i have just told you and get started on it.

and by all means if/when you have a problem come back and ask a hundred more questions.

hth

Do you have the mysql extension? phpinfo()

Did you say you were running Fedora4, If so I'm sure that the default does come with mysql, however there are two versions of mysql on php, the older mysql and then mysqli. Check which one you have.

yes you ought to do that.. just for claritys sake

Hi

following is the data displayed by phpinfo() function;

vnb400


System Linux localhost.localdomain 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, /etc/php.d/mysql.ini, /etc/php.d/mysqli.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


Zend logo 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 On On
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 localhost.localdomain: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 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_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_CONNECTION Keep-Alive
HTTP_USER_AGENT Mozilla/5.0 (compatible; Konqueror/3.4; Linux) KHTML/3.4.0 (like Gecko)
HTTP_ACCEPT text/html, image/jpeg, image/png, text/*, image/*, */*
HTTP_ACCEPT_ENCODING x-gzip, x-deflate, gzip, deflate
HTTP_ACCEPT_CHARSET utf-8, utf-8;q=0.5, *;q=0.5
HTTP_ACCEPT_LANGUAGE en
HTTP_HOST localhost
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
SERVER_SIGNATURE <address>Apache/2.0.54 (Fedora) Server at localhost Port 80</address>
SERVER_SOFTWARE Apache/2.0.54 (Fedora)
SERVER_NAME localhost
SERVER_ADDR ::1
SERVER_PORT 80
REMOTE_ADDR ::1
DOCUMENT_ROOT /var/www/html
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/connect.php
REMOTE_PORT 55091
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /connect.php
SCRIPT_NAME /connect.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /connect.php HTTP/1.1
Connection Keep-Alive
User-Agent Mozilla/5.0 (compatible; Konqueror/3.4; Linux) KHTML/3.4.0 (like Gecko)
Accept text/html, image/jpeg, image/png, text/*, image/*, */*
Accept-Encoding x-gzip, x-deflate, gzip, deflate
Accept-Charset utf-8, utf-8;q=0.5, *;q=0.5
Accept-Language en
Host localhost
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


mysql
MySQL Support
enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.11
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -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


mysqli
MysqlI Support
enabled
Client API version 4.1.11
MYSQLI_SOCKET /var/lib/mysql/mysql.sock


Directive
Local Value
Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off


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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
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_CONNECTION"] Keep-Alive
_SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (compatible; Konqueror/3.4; Linux) KHTML/3.4.0 (like Gecko)
_SERVER["HTTP_ACCEPT"] text/html, image/jpeg, image/png, text/*, image/*, */*
_SERVER["HTTP_ACCEPT_ENCODING"] x-gzip, x-deflate, gzip, deflate
_SERVER["HTTP_ACCEPT_CHARSET"] utf-8, utf-8;q=0.5, *;q=0.5
_SERVER["HTTP_ACCEPT_LANGUAGE"] en
_SERVER["HTTP_HOST"] localhost
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.54 (Fedora) Server at localhost Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.0.54 (Fedora)
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_ADDR"] ::1
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] ::1
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/connect.php
_SERVER["REMOTE_PORT"] 55091
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /connect.php
_SERVER["SCRIPT_NAME"] /connect.php
_SERVER["PHP_SELF"] /connect.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

find the php-mysql package, and you'll get the .so extension
put it in the right place, edit your php.ini to include this extension