"Call to undefined function mysql_connect()" - Help!

Discussion in 'Server Operation' started by dannyg, Oct 28, 2006.

  1. dannyg

    dannyg New Member

    Hi,

    I'm currently in the process of trying to install a script onto my server (which I have installed and setup) but whenever I try and setup this script, I get:

    Fatal error: Call to undefined function mysql_connect() in /var/www/status/config.php on line 31

    I edited my php.ini and uncommented "extension=mysql.so", then restarted Apache but it still doesn't work.

    I'm currently using Webmin to administrate my server. I heard somewehre about needing the line "--with-mysql" but I don't know what this means.

    My PHPInfo file: http://www.dannyg.co.uk/info.php

    Any help would be very very much appreciated,

    Thanks in advance,

    Daniel.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    MySQL is not enabled in your PHP. Did you install the php-mysql pacakge from your linux distribution? Which php.ini did you edit?
     
  3. dannyg

    dannyg New Member

    I did "apt-get install php5" and I installed MySQL via Webmin. The PHP works fine (hence the info.php page). Thats all I have installed as far as PHP and MySQL goes.

    I edited the file in "/etc/php5/apache2/php.ini"

    Thanks,

    Daniel.
     
    Last edited: Oct 28, 2006
  4. falko

    falko Super Moderator ISPConfig Developer

  5. sysconfig

    sysconfig New Member

    Yes, you are correct you could able to see the MySQL section in phpinfo page , you should have compatible php-mysql client also as suggest by other expert here.

    However, sometime I have faced this issues after upgrading mysql I suggest you Put this into your my.ini file under the [MYSQLD] section:

    old_password=1

    and restart your mysql service and check.

    Thanks,
     
  6. fmosse

    fmosse New Member

    Hi!

    I have the same problem.

    I am getting these message:

    "Fatal error: Call to undefined function: mysql_connect() in /var/www/html/php/news/news/config.php on line 4"

    The server has webmin 1.500 installed.

    This is my phpinfo data:


    PHP Logo
    PHP Version 4.3.9

    System Linux mail.nocuts.com.ar 2.6.9-42.EL #1 Sat Aug 12 09:17:58 CDT 2006 i686
    Build Date Jul 12 2006 13:43:33
    Configure Command './configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-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' '--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=shared' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-xml' '--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr' '--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--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,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mime-magic=/usr/share/file/magic.mime' '--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/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

    Zend logo This program makes use of the Zend Scripting Language Engine:
    Zend Engine v1.3.0, 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_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 2047 2047
    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 On On
    log_errors_max_len 1024 1024
    magic_quotes_gpc Off Off
    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 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

    apache2handler
    Apache Version Apache/2.0.52 (CentOS)
    Apache API Version 20020903
    Server Administrator root@localhost
    Hostname:port cursosinteractivos.com.ar: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_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_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
    HTTP_HOST www.cursosinteractivos.com.ar
    HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7
    HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_LANGUAGE es-es,es;q=0.8,en-us;q=0.5,en;q=0.3
    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 /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
    SERVER_SIGNATURE <address>Apache/2.0.52 (CentOS) Server at www.cursosinteractivos.com.ar Port 80</address>
    SERVER_SOFTWARE Apache/2.0.52 (CentOS)
    SERVER_NAME www.cursosinteractivos.com.ar
    SERVER_ADDR 190.2.52.33
    SERVER_PORT 80
    REMOTE_ADDR 190.55.10.231
    DOCUMENT_ROOT /var/www/html
    SERVER_ADMIN root@localhost
    SCRIPT_FILENAME /var/www/html/php/news/news/phpinfo.php
    REMOTE_PORT 14626
    GATEWAY_INTERFACE CGI/1.1
    SERVER_PROTOCOL HTTP/1.1
    REQUEST_METHOD GET
    QUERY_STRING no value
    REQUEST_URI /php/news/news/phpinfo.php
    SCRIPT_NAME /php/news/news/phpinfo.php

    HTTP Headers Information
    HTTP Request Headers
    HTTP Request GET /php/news/news/phpinfo.php HTTP/1.1
    Host www.cursosinteractivos.com.ar
    User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7
    Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Language es-es,es;q=0.8,en-us;q=0.5,en;q=0.3
    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/4.3.9
    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.12.1 OpenSSL/0.9.7a zlib/1.2.1.2 libidn/0.5.6

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

    dio
    dio support enabled

    exif
    EXIF Support enabled
    EXIF Version 1.4 $Id: exif.c,v 1.118.2.35 2005/03/05 18:30:47 rasmus 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.4

    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.130.2.10 2004/06/01 21:05:33 iliaa Exp $
    Total Links 0/unlimited
    API Version 3001
    Vendor Name OpenLDAP
    Vendor Version 20213

    mime_magic
    mime_magic support enabled

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

    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.5 01-December-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 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.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 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=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
    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.7

    yp
    YP Support enabled

    zlib
    ZLib Support enabled
    Compiled Version 1.2.1.2
    Linked Version 1.2.1.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
    CONSOLE /dev/pts/0
    SELINUX_INIT YES
    TERM linux
    INIT_VERSION sysvinit-2.85
    PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
    runlevel 5
    RUNLEVEL 5
    PWD /
    previous N
    PREVLEVEL N
    SHLVL 3
    HOME /
    _ /sbin/initlog

    PHP Variables
    Variable Value
    _SERVER["HTTP_HOST"] www.cursosinteractivos.com.ar
    _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7
    _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    _SERVER["HTTP_ACCEPT_LANGUAGE"] es-es,es;q=0.8,en-us;q=0.5,en;q=0.3
    _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"] /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
    _SERVER["SERVER_SIGNATURE"] <address>Apache/2.0.52 (CentOS) Server at www.cursosinteractivos.com.ar Port 80</address>
    _SERVER["SERVER_SOFTWARE"] Apache/2.0.52 (CentOS)
    _SERVER["SERVER_NAME"] www.cursosinteractivos.com.ar
    _SERVER["SERVER_ADDR"] 190.2.52.33
    _SERVER["SERVER_PORT"] 80
    _SERVER["REMOTE_ADDR"] 190.55.10.231
    _SERVER["DOCUMENT_ROOT"] /var/www/html
    _SERVER["SERVER_ADMIN"] root@localhost
    _SERVER["SCRIPT_FILENAME"] /var/www/html/php/news/news/phpinfo.php
    _SERVER["REMOTE_PORT"] 14626
    _SERVER["GATEWAY_INTERFACE"] CGI/1.1
    _SERVER["SERVER_PROTOCOL"] HTTP/1.1
    _SERVER["REQUEST_METHOD"] GET
    _SERVER["QUERY_STRING"] no value
    _SERVER["REQUEST_URI"] /php/news/news/phpinfo.php
    _SERVER["SCRIPT_NAME"] /php/news/news/phpinfo.php
    _SERVER["PHP_SELF"] /php/news/news/phpinfo.php
    _SERVER["PATH_TRANSLATED"] /var/www/html/php/news/news/phpinfo.php
    _SERVER["argv"]

    Array

    _SERVER["argc"] 0
    _ENV["LANG"] C
    _ENV["CONSOLE"] /dev/pts/0
    _ENV["SELINUX_INIT"] YES
    _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["previous"] N
    _ENV["PREVLEVEL"] N
    _ENV["SHLVL"] 3
    _ENV["HOME"] /
    _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@php.net.
     
  7. fmosse

    fmosse New Member

    [Avatar]
    2010-01-09 23:04:34 ARST
    Hi!

    We have webmin 1.500 installed. I have created a MySQL database. But in the php files we get

    Call to undefined function: mysql_connect()

    You can see phpinfo in

    http://190.2.52.33/php/news/news/phpinfo.php

    What can we do?

    Thanks
    Francisco
     

Share This Page