The classic MySQL connect error

Discussion in 'Installation/Configuration' started by swggy, May 25, 2007.

  1. swggy

    swggy New Member

    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 ...
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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:

    if you do not have this line, add it at the end of the file and restart your apache webserver.
  3. swggy

    swggy New Member

    Thanks, but that didn't fix it ...
    • I did 'yum install php-mysql' and got back 'nothing to do'.
    • Then I found that wasn't in the ini file, so I added '' 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 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 '' 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.
  4. pyro

    pyro New Member

    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... :confused:
  5. swggy

    swggy New Member

    Contrary to your response, the PHP site itself here... 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?
  6. swggy

    swggy New Member

    Pyro - once I get a response that fixes my problem I'll post it.
  7. till

    till Super Moderator Staff Member ISPConfig Developer



    Yes. You neither read what I said not what they said properly. 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 file.

    But if you want to mess up your setup, please recompile it.

    Please post the output of:

    locate php.ini

    Also set:


    in all php.ini files that you find in /etc and its subdirectories.
  8. till

    till Super Moderator Staff Member ISPConfig Developer


    yast -i php-mysql
  9. swggy

    swggy New Member

    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.

  10. pyro

    pyro New Member

    yess- extension_dir=/usr/lib/php5/modules did the trick.

  11. darvish

    darvish New Member

  12. falko

    falko Super Moderator ISPConfig Developer

    Please run
    apt-get install php5-mysql
    and restart Apache.
  13. darvish

    darvish New Member

    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,
    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.zlib, https, ftps
    Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3,
    sslv2, tls
    Registered Stream Filters string.rot13, string.toupper,
    string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*,

    Zend logo <> 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>



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


    Apache Version Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3
    Apache API Version 20051115
    Server Administrator [email protected]
    Hostname:port 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

    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:
    Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/

    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_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
    REMOTE_ADDR x.x.x.x
    DOCUMENT_ROOT /var/www/
    SERVER_ADMIN [email protected]
    SCRIPT_FILENAME /var/www/test.php
    REMOTE_PORT 38174
    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:
    Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/

    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 support enabled


    BZip2 Support Enabled
    Stream Wrapper support compress.bz2://
    Stream Filter support bzip2.decompress, bzip2.compress
    BZip2 Version 1.0.4, 20-Dec-2006


    Calendar support enabled


    ctype functions enabled


    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 support enabled
    Supported handlers db4


    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 Support enabled
    EXIF Version 1.4 $Id: exif.c,v 2007/02/27 03:04:40
    Exp $
    Supported EXIF Version 0220
    Supported filetypes JPEG,TIFF


    Input Validation and Filtering enabled
    Revision $Revision: $

    Directive Local Value Master Value
    filter.default unsafe_raw unsafe_raw
    filter.default_flags /no value/ /no value/


    FTP support enabled


    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 Support enabled


    hash support enabled
    Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128
    ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,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 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 support enabled
    json version 1.2.1


    libXML support active
    libXML Version 2.6.30
    libXML streams enabled


    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 support invalid magic file, disabled

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


    OpenSSL support enabled
    OpenSSL Version OpenSSL 0.9.8e 23 Feb 2007


    PCRE (Perl Compatible Regular Expressions) Support enabled
    PCRE Library Version 7.4 2007-09-21


    Revision $Revision: $


    Reflection enabled
    Version $Id: php_reflection.c,v 2007/05/29 08:44:05
    helly Exp $


    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 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 support enabled


    Simplexml support enabled
    Revision $Revision: $
    Schema support enabled


    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 Support enabled


    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


    Regex Library Bundled library enabled
    Dynamic Library Support enabled
    Path to sendmail /usr/sbin/sendmail -t -i

    Directive Local Value Master Value 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=
    user_agent /no value/ /no value/


    sysvmsg support enabled
    Revision $Revision: $


    Tokenizer Support enabled


    WDDX Support enabled
    WDDX Session Serializer enabled


    XML Support active
    XML Namespace Support active
    libxml2 Version 2.6.30


    XMLReader enabled


    XMLWriter enabled


    Zip enabled
    Extension Version $Id: php_zip.c,v 2007/05/19 22:25:11 pajoye
    Exp $
    Zip version 2.0.0
    Libzip version 0.7.1


    ZLib Support enabled
    Stream Wrapper support compress.zlib://
    Stream Filter support zlib.inflate, zlib.deflate
    Compiled Version
    Linked Version

    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


    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: Gecko/20080325 Ubuntu/7.10 (gutsy) Firefox/
    _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_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["REMOTE_ADDR"] x.x.x.x
    _SERVER["DOCUMENT_ROOT"] /var/www/
    _SERVER["SERVER_ADMIN"] [email protected]
    _SERVER["SCRIPT_FILENAME"] /var/www/test.php
    _SERVER["REMOTE_PORT"] 38174
    _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["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

    If you did not receive a copy of the PHP license, or have any questions
    about PHP licensing, please contact [email protected].
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    Please run:

    apt-get install --reinstall php5-mysql
    /etc/init.d/apache2 restart

Share This Page