Newbie speaking… I've followed the 'perfect setup for CentOS 5.0' and I've got everything running fairly well. However, I can't fire up my test MySQL script - I get So I went to the search engine and found 42,900 occurrences of this. I've poked around in the forums and found near hits to answer my problem, but nothing exact - one of the problems I'm bumping into is that so many of the answers presume that PHP is running on Windows, which doesn't really help me. * I understand that MySQL isn't turned on by default in PHP5. * I understand that MySQL is loaded on my system, since I'm running ISPConfig and it uses MySQL. * I understand that my PHP probably doesn't have MySQL installed as an extension, since phpinfo says and there's no table further down for it (I rather thought that 'the perfect setup' for a LAMPS install would automatically have php with MySQL, but that's another story.) So I'm wondering - how to activate MySQL in PHP5, and it seems as if I have to recompile PHP. I’ve got 3 questions: 1) I’m guessing that I can take the entire configure command in the big box at the top of the phpinfo() display and run that (tweaking the ‘-–without-mysql’ of course). True? 2) What directory do I run this from? There’s a pile of ‘.h’ files in ‘/usr/include/php/main’ - do I go there? Or where? 3) Do I need anything else? Thanks for any help ... swggy
No. Mysql is compiled fine. What all the sources you found in the internat take not in account that today all php installations are compiled modular, so --without-mysql just means that mysql is loaded as module and not compiled in. Do not do this if you dont want to mess up your installation! Yes 1) Make sure that you have the php mysql module installed: yum install php-mysql If the command says that it is already installed, you must check if the module is loaded. Have a look at the php.ini file, the file is most likely in /etc/php5/apache2/ php.ini or a similar location in the /etc directory. There must be a line in the file like: extension=mysql.so if you do not have this line, add it at the end of the file and restart your apache webserver.
Thanks, but that didn't fix it ... I did 'yum install php-mysql' and got back 'nothing to do'. Then I found that mysql.so wasn't in the ini file, so I added 'extension=mysql.so' to the bottom of the file as you said, but nothing changed. I then tried moving it to the extensions area instead, but nothing. I also tried adding mysqli.so there, since I'm reading that PHP5 takes mysqli instead of mysql, but nothing. I can get in through Putty on the CLI with ...of course that's not PHP, but it does confirm that the username and no pwd gets access. phpinfo says my config file is /etc/php.ini (which is the file I've been making your changes to), and it says that 'extension_dir=./' - is that OK? The tables at the bottom of the phpinfo report jump straight from 'mime_magic' to 'openssl', so adding the 'extension=mysql.so' doesn't seem to have had any effect... I also see that I have the following in /usr/lib/php/modules: So I may be a little further, but not there yet. Any other thoughts? - thanks.
i have same problem on perfect suse 10.2 isconfig is working, phpmyadmin is working - all users can login and root has all mysql privileges but when i test script to connect mysql then there is mysql_connect error message...
Contrary to your response, the PHP site itself here... http://us2.php.net/mysql says clearly that for PHP 5 on a Linux OS, PHP needs to be reconfigured before MySQL is supported: Are you wrong? Are they wrong? Am I missing something? Everything still seems to point to the need to reconfigure with the MySQL optin turned on. I just don't have an answer yet. Maybe I need to ask on another forum?
No. No. Yes. You neither read what I said not what they said properly. php.net is talking about statically compiled in mysql support which is not used anymore in most linux distributions. They all use modular PHP now where the mysql module is loaded in form of a mysql.so file. But if you want to mess up your setup, please recompile it. Please post the output of: locate php.ini Also set: extension_dir=/usr/lib/php/modules in all php.ini files that you find in /etc and its subdirectories.
Here's the output - it's only in /etc ... and hey, presto, changing 'extension_dir=./' to 'extension_dir=/usr/lib/php/modules' did the trick. Don't be too grumpy with the newbie - I'm vey grateful. Thanks.
same issue I tried changing the extensions_dir. But it does not seem to help me. Maybe I am not changing them in all the php.ini files? How can I find all of them? ( Forgive the newbie question please ) I am following the tutorial at: http://www.howtoforge.com/intrusion-detection-with-snort-mysql-apache2-on-ubuntu-7.10
php-mysql issue I did install php-mysql here is the result of phpinfo() PHP Version 5.2.3-1ubuntu6.3 System Linux thunder 2.6.22-14-generic #1 SMP Tue Feb 12 07:42:25 UTC 2008 i686 Build Date Jan 10 2008 09:24:13 Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/apache2 Loaded Configuration File /etc/php5/apache2/php.ini Scan this dir for additional .ini files /etc/php5/apache2/conf.d additional .ini files parsed /etc/php5/apache2/conf.d/gd.ini, /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.* Zend logo <http://www.zend.com/> This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies ------------------------------------------------------------------------ PHP Credits </test.php?=PHPB8B5F2A0-3C92-11d3-A3A9-4C7B08C10000> ------------------------------------------------------------------------ Configuration PHP Core Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen On On allow_url_include Off Off 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 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 6135 6135 expose_php On On extension_dir /usr/lib/php5/ext /usr/lib/php5/ext 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/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 mail.force_extra_parameters /no value/ /no value/ max_execution_time 30 30 max_input_nesting_level 64 64 max_input_time 60 60 memory_limit 128M 128M 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 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays On On 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.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3 Apache API Version 20051115 Server Administrator webmaster@localhost Hostnameort thunder.home:0 User/Group www-data(33)/33 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 15 Virtual Server Yes Server Root /etc/apache2 Loaded Modules core mod_log_config mod_logio prefork http_core mod_so mod_alias mod_auth_basic mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_mime mod_negotiation mod_php5 mod_setenvif mod_status Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0 Apache Environment Variable Value HTTP_HOST x.x.x.x HTTP_USER_AGENT Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.13) Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/2.0.0.13 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_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 PATH /usr/local/bin:/usr/bin:/bin SERVER_SIGNATURE <address>Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3 Server at x.x.x.x Port 80</address> SERVER_SOFTWARE Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3 SERVER_NAME x.x.x.x SERVER_ADDR x.x.x.x SERVER_PORT 80 REMOTE_ADDR x.x.x.x DOCUMENT_ROOT /var/www/ SERVER_ADMIN webmaster@localhost SCRIPT_FILENAME /var/www/test.php REMOTE_PORT 38174 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 x.x.x.x User-Agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.13) Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/2.0.0.13 Accept text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 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 Connection keep-alive HTTP Response Headers X-Powered-By PHP/5.2.3-1ubuntu6.3 Keep-Alive timeout=15, max=100 Connection Keep-Alive Transfer-Encoding chunked Content-Type text/html bcmath BCMath support enabled bz2 BZip2 Support Enabled Stream Wrapper support compress.bz2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.4, 20-Dec-2006 calendar Calendar support enabled ctype ctype functions enabled date date/time support enabled "Olson" Timezone Database Version 2007.5 Timezone Database internal Default timezone America/New_York Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone /no value/ /no value/ dba DBA support enabled Supported handlers db4 dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.6.30 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled exif EXIF Support enabled EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.19 2007/02/27 03:04:40 iliaa Exp $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF filter Input Validation and Filtering enabled Revision $Revision: 1.52.2.39 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags /no value/ /no value/ ftp FTP support enabled gd GD Support enabled GD Version 2.0 or higher FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.3.5 T1Lib Support enabled GIF Read Support enabled GIF Create Support enabled JPG Support enabled PNG Support enabled WBMP Support enabled gettext GetText Support enabled hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconv iconv support enabled iconv implementation glibc iconv library version 2.6.1 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 json json support enabled json version 1.2.1 libxml libXML support active libXML Version 2.6.30 libXML streams enabled mbstring Multibyte Support enabled Multibyte string engine libmbfl Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 4.4.4 Multibyte regex (oniguruma) backtrack check On 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.strict_detection Off Off mbstring.substitute_character /no value/ /no value/ 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.8e 23 Feb 2007 pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 7.4 2007-09-21 posix Revision $Revision: 1.70.2.3.2.15 $ Reflection Reflection enabled Version $Id: php_reflection.c,v 1.164.2.33.2.39 2007/05/29 08:44:05 helly Exp $ 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 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_httponly Off Off 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.hash_bits_per_character 4 4 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/php5 /var/lib/php5 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.151.2.22.2.26 $ Schema support enabled soap Soap Client enabled Soap Server enabled Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 sockets Sockets Support enabled SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException 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.20.2.3.2.6 $ tokenizer Tokenizer Support enabled wddx WDDX Support enabled WDDX Session Serializer enabled xml XML Support active XML Namespace Support active libxml2 Version 2.6.30 xmlreader XMLReader enabled xmlwriter XMLWriter enabled zip Zip enabled Extension Version $Id: php_zip.c,v 1.1.2.33 2007/05/19 22:25:11 pajoye Exp $ Zip version 2.0.0 Libzip version 0.7.1 zlib ZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.1.1 Linked Version 1.2.3.3 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 PATH /usr/local/bin:/usr/bin:/bin LANG C PWD / PHP Variables Variable Value _SERVER["HTTP_HOST"] x.x.x.x _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.13) Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/2.0.0.13 _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_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["PATH"] /usr/local/bin:/usr/bin:/bin _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3 Server at x.x.x.x Port 80</address> _SERVER["SERVER_SOFTWARE"] Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3 _SERVER["SERVER_NAME"] x.x.x.x _SERVER["SERVER_ADDR"] x.x.x.x _SERVER["SERVER_PORT"] 80 _SERVER["REMOTE_ADDR"] x.x.x.x _SERVER["DOCUMENT_ROOT"] /var/www/ _SERVER["SERVER_ADMIN"] webmaster@localhost _SERVER["SCRIPT_FILENAME"] /var/www/test.php _SERVER["REMOTE_PORT"] 38174 _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["REQUEST_TIME"] 1207829544 _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["PATH"] /usr/local/bin:/usr/bin:/bin _ENV["LANG"] C _ENV["PWD"] / 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 [email protected].
