{MySQL} extension=php_mysql.dll

Bonjour,
je recrée un post pour mon problème qui en fais qu'une partie régler.
je rappel mon problème :
Voila au lieu de gerer ma base de donnée par WAMP SERVER,j'ai decider de me crée un serveur sous linux.
j'ai installer un serveur apache (apache2) et un serveur mysql (mysql-server).
a priori tout va bien,mais sur mon serveur apache,il ne voit pas ma base de donnée ...
pourtant je fais une requete basique :
sur mon serveur mysql je me connecte bien avec mon login root et mon mot de passe qui est le meme dans ma page ... donc je ne comprend pas,est ce que il y a besoin de definir le serveur mysql dans apache ?

mon code ereur :
Fatal error: Call to undefined function mysql_connect() in /var/www/menu_client.php on line 60

ligne 60 : mysql_connect("localhost", "root", "gloob" );

quelqu'un aurai une idée ?

Donc j'ai vu dans le forum qu'il faut faire une modification dans le php.ini (etc/php5/apache2/php.ini)

avec la ligne : extension=php_mysql.dll

mais mon problème viens de la :

il faut que aussi la ligne "extension_dir" pointe vers le dossier de DLL ? mais ou trouver ce dossier ?
Configuration: Windows XP
Firefox 3.0.14

33 réponses

Résumé de la discussion

La discussion porte sur une erreur PHP sur un serveur Linux avec Apache et MySQL: la fonction mysql_connect est indéfinie, empêchant la connexion à la base de données locale. Plusieurs répondants recommandent d'activer l'extension PHP MySQL et de corriger le php.ini, car sous Linux les modules DLL de Windows ne sont pas utilisables et l extension se charge en .so. Des échanges mettent en avant le problème du fichier php.ini inadapté ou d'un extension_dir mal configuré, avec des exemples comme extension_dir pointant vers /usr/lib/php5/20060613+lfs et l'instruction extension=mysql.so. Une précision utile : phpinfo() permet de vérifier le chemin extension_dir et l'état des extensions actives, et la solution consiste à relancer Apache et MySQL après avoir installé ou réactivé le module mysql.

Bobot (l’IA à votre service)
  1. Bonjour

    Si ton serveur est sous linux, je doute beaucoup que ton extension soit php_mysql.dll. Je ne connais pas linux, mais je pencherais fortement pour mysql.so
    Pour le répertoire, si c'est comme sous windows, c'est un sous-répertoire "ext" contenu dans le répertoire où se trouve PHP
    0
    1. oui pas con ! je suis d'accord avec toi , sa mérite quelque seconde de réflexion !
      mais mysql.so doit bien etre quelque part ?
      0
      1. Dans le sous répertoire ext, justement !
        Et s'il ne s'appelle pas comme ça, il n'y a quand même pas des tonnes de sous-répertoires de php à explorer pour trouver !
        0
        1. dans mon dossier PHP5 , je n'ai que apache2 & conf.d !
          0
          1. pour améliorer l'aide j'amene mon phpinfo();

            System Linux damien-desktop 2.6.28-15-generic #49-Ubuntu SMP Tue Aug 18 18:40:08 UTC 2009 i686
            Build Date Aug 21 2009 18:45:50
            Server API Apache 2.0 Handler
            Virtual Directory Support disabled
            Configuration File (php.ini) Path /etc/php5/apache2
            Loaded Configuration File (none)
            Scan this dir for additional .ini files /etc/php5/apache2/conf.d
            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.*
            0
            1. C'est tout ? Cest un peu court ! Il devrait y avoir une suite, beaucoup plus longue que ce que tu montres...
              Quant aux sous-répertoires, ça n'a visiblement rien à voir avec ce qui se passe sous windows. J'ai 5 sous-répertoires, dont "ext" et aucun "apache2".
              Il y avait une valeur dans extension_dir avant que tu y touches ?
              Il vaudrait mieux que ce soit quelqu'un qui a une installation linux qui te réponde.
              0
              1. oui,mais j'ai mit que le debut ....

                il y avai "./" dans l'extension_dir

                merçi comme meme de m'aider ..

                voila la suite ...

                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 no value no value
                expose_php On On
                extension_dir /usr/lib/php5/20060613+lfs /usr/lib/php5/20060613+lfs
                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 -1 -1
                memory_limit 128M 128M
                open_basedir no value no value
                output_buffering 0 0
                output_handler no value no value
                post_max_size 8M 8M
                precision 14 14
                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 /usr/lib/php5/libexec /usr/lib/php5/libexec
                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
                suhosin.log.phpscript 0 0
                suhosin.log.phpscript.is_safe Off Off
                suhosin.log.phpscript.name no value no value
                suhosin.log.sapi no value no value
                suhosin.log.script no value no value
                suhosin.log.script.name no value no value
                suhosin.log.syslog no value no value
                suhosin.log.syslog.facility no value no value
                suhosin.log.syslog.priority no value no value
                suhosin.log.use-x-forwarded-for 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.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                Apache API Version 20051115
                Server Administrator webmaster@localhost
                Hostname:Port 127.0.1.1:80
                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_deflate 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 192.168.1.54
                HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                HTTP_ACCEPT_LANGUAGE fr,fr-fr;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
                HTTP_CACHE_CONTROL max-age=0
                PATH /usr/local/bin:/usr/bin:/bin
                SERVER_SIGNATURE <address>Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch Server at 192.168.1.54 Port 80</address>
                SERVER_SOFTWARE Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                SERVER_NAME 192.168.1.54
                SERVER_ADDR 192.168.1.54
                SERVER_PORT 80
                REMOTE_ADDR 192.168.1.183
                DOCUMENT_ROOT /var/www
                SERVER_ADMIN webmaster@localhost
                SCRIPT_FILENAME /var/www/test.php
                REMOTE_PORT 1877
                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 192.168.1.54
                User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                Accept-Language fr,fr-fr;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
                Cache-Control max-age=0
                HTTP Response Headers
                X-Powered-By PHP/5.2.6-3ubuntu4.2
                Vary Accept-Encoding
                Content-Encoding gzip

                bcmath
                BCMath support enabled

                bz2
                BZip2 Support Enabled
                Stream Wrapper support compress.bz2://
                Stream Filter support bzip2.decompress, bzip2.compress
                BZip2 Version 1.0.5, 10-Dec-2007

                calendar
                Calendar support enabled

                ctype
                ctype functions enabled

                date
                date/time support enabled
                "Olson" Timezone Database Version 0.system
                Timezone Database internal
                Default timezone System/Localtime

                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 cdb cdb_make db4 inifile flatfile

                dom
                DOM/XML enabled
                DOM/XML API Version 20031129
                libxml Version 2.6.32
                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.25 2008/03/12 17:33:14 iliaa Exp $
                Supported EXIF Version 0220
                Supported filetypes JPEG,TIFF

                filter
                Input Validation and Filtering enabled
                Revision $Revision: 1.52.2.42 $

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

                ftp
                FTP 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.9

                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.32
                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.8g 19 Oct 2007

                pcre
                PCRE (Perl Compatible Regular Expressions) Support enabled
                PCRE Library Version 7.8 2008-09-05

                Directive Local Value Master Value
                pcre.backtrack_limit 100000 100000
                pcre.recursion_limit 100000 100000

                posix
                Revision $Revision: 1.70.2.3.2.18 $

                Reflection
                Reflection enabled
                Version $Id: php_reflection.c,v 1.164.2.33.2.50 2008/03/13 15:56:21 iliaa 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.39 $
                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,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
                user_agent no value no value

                sysvmsg
                sysvmsg support enabled
                Revision $Revision: 1.20.2.3.2.7 $

                tokenizer
                Tokenizer Support enabled

                wddx
                WDDX Support enabled
                WDDX Session Serializer enabled

                xml
                XML Support active
                XML Namespace Support active
                libxml2 Version 2.6.32

                xmlreader
                XMLReader enabled

                xmlwriter
                XMLWriter enabled

                zip
                Zip enabled
                Extension Version $Id: php_zip.c,v 1.1.2.43 2008/01/18 00:51:38 pajoye Exp $
                Zip version 1.8.11
                Libzip version 0.8.0-compatible

                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
                APACHE_PID_FILE /var/run/apache2.pid
                PATH /usr/local/bin:/usr/bin:/bin
                LANG C
                APACHE_RUN_GROUP www-data
                APACHE_RUN_USER www-data
                PWD /etc/php5

                PHP Variables
                Variable Value
                _SERVER["HTTP_HOST"] 192.168.1.54
                _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                _SERVER["HTTP_ACCEPT_LANGUAGE"] fr,fr-fr;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["HTTP_CACHE_CONTROL"] max-age=0
                _SERVER["PATH"] /usr/local/bin:/usr/bin:/bin
                _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch Server at 192.168.1.54 Port 80</address>
                _SERVER["SERVER_SOFTWARE"] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                _SERVER["SERVER_NAME"] 192.168.1.54
                _SERVER["SERVER_ADDR"] 192.168.1.54
                _SERVER["SERVER_PORT"] 80
                _SERVER["REMOTE_ADDR"] 192.168.1.183
                _SERVER["DOCUMENT_ROOT"] /var/www
                _SERVER["SERVER_ADMIN"] webmaster@localhost
                _SERVER["SCRIPT_FILENAME"] /var/www/test.php
                _SERVER["REMOTE_PORT"] 1877
                _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"] 1253010789
                _SERVER["argv"]

                Array
                (
                )

                _SERVER["argc"] 0
                _ENV["APACHE_PID_FILE"] /var/run/apache2.pid
                _ENV["PATH"] /usr/local/bin:/usr/bin:/bin
                _ENV["LANG"] C
                _ENV["APACHE_RUN_GROUP"] www-data
                _ENV["APACHE_RUN_USER"] www-data
                _ENV["PWD"] /etc/php5
                0
                1. je lis : extension_dir /usr/lib/php5/20060613+lfs
                  Ce répertoire existe-t-il ? Toi tu dis qu'il n'y a que apache2 & conf.d dans ton répertoire PHP5
                  D'ailleurs, tu écrivais PHP5 en majuscules, alors que c'est en minuscules. Ça n'a pas d'importance sous windows, mais ça change tout sous linux, il faut TOUJOURS respecter la casse (majuscules / minuscules) dans les noms de répertoires et de fichiers.
                  alors, finalement, qu'y a-t-il dans la ligne extension_dir de ton php.ini ?
                  0
                  1. Je lis : extension_dir /usr/lib/php5/20060613+lfs

                    oui,je suis aller voir ce qu'il y avais : gd.so,mysqli.so,pdo_mysql.so,pdo.so !
                    0
                    1. j'ai bien verifier ... il y a bien mysql.so dans mon php.ini est il est bien pointer ... donc !!!
                      0
                      1. Alors pourquoi dis-tu qu'il n'y a que apache2 & conf.d dans php5 ????
                        Il n'y a que ces 4 extensions ? Les autres doivent bien être trouvables, c'est peut-être toi qui as demandé une version minimale à l'installation
                        Tu n'as pas répondu à la question : qu'y a-t-il dans la ligne extension_dir de ton php.ini ?
                        0
                        1. par ce que j'ai re telecharger PHP5 en mettant le élements qui me manqué ...

                          extension_dir : il y a le lien jusqu'a c'est 4 extension !

                          est j'ai mit mysql.so
                          0
                          1. est j'ai mit mysql.so
                            Qu'est ce que ça veut dire ??? Je suppose qu'à la place de 'est' il faut lire 'et'..
                            Est-ce qu'il faut que je comprenne que tu as trouvé le fichier mysql.so et que tu l'as mis dans le bon répertoire ? et que tu as aussi mis dans le fichier php.ini la ligne extension=mysql.so ?
                            0
                            1. exactement sa !
                              est j'ai redemaré Mysql et Apache,mais toujour pareil !
                              0
                              1. Es-tu sûr que le php.ini que tu modifies est le bon ? Parfois, suite à des tentatives d'installation ratées, il traîne des copies dans des répertoires qui ne servent plus
                                Vérifications à faire :
                                -l'extension mysql n'apparaît-t-elle toujours pas dans le phpinfo() ?
                                -dans php.ini tu as bien écrit extension=mysql.so sans ; au début de la ligne
                                -masque une extensions chargées en mettant un ; au début de la ligne extension=.., redémarre apache et vérifie avec phpinfo que l'extension en question a bien disparu. Tu seras sûr qu'il s'agit bien du bon php.ini
                                0
                                1. Quand j'ai remit le php 5, il n'y avais pas de php.ini donc j'ai mit l'ancien ...

                                  je vais vérifier tout ce que tu ma dit !
                                  0
                                  1. si,je n'avais pas mit de php.ini ,il y a c'est fichiers :

                                    php.ini-development
                                    php.ini-production

                                    pour : extension=mysql.so "oui c'est bon "
                                    0
                                    1. je viens d'enlever mon php.ini est j'ai prit un php.ini-development que j'ai modifié en php.ini !
                                      sa ne marcher pas ! mais je refais un tour dans le fichier est j'ai remarque que

                                      extension_dir='ext' ce qui est okay,il va bien sur un bon répertoire ! mais il y avais le ";" devant donc je les enlever !

                                      et

                                      extension=msql.so avais aussi le ";" devant donc je les enlever aussi !

                                      mysql.so qui doit etre dans le repertoire ext ? je ne vois pas les extensions mais je vois que un mysql ....

                                      j'ai redemaré mes 2 serveurs mais toujour rien :(

                                      je vais refaire un tour dans mon php info();
                                      0
                                      1. PHP Logo
                                        PHP Version 5.2.6-3ubuntu4.2

                                        System Linux damien-desktop 2.6.28-15-generic #49-Ubuntu SMP Tue Aug 18 18:40:08 UTC 2009 i686
                                        Build Date Aug 21 2009 18:45:50
                                        Server API Apache 2.0 Handler
                                        Virtual Directory Support disabled
                                        Configuration File (php.ini) Path /etc/php5/apache2
                                        Loaded Configuration File (none)
                                        Scan this dir for additional .ini files /etc/php5/apache2/conf.d
                                        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.*

                                        Suhosin logo This server is protected with the Suhosin Patch 0.9.6.2
                                        Copyright (c) 2006 Hardened-PHP Project

                                        Zend logo This program makes use of the Zend Scripting Language Engine:
                                        Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies

                                        PHP Credits
                                        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 no value no value
                                        expose_php On On
                                        extension_dir /usr/lib/php5/20060613+lfs /usr/lib/php5/20060613+lfs
                                        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 -1 -1
                                        memory_limit 128M 128M
                                        open_basedir no value no value
                                        output_buffering 0 0
                                        output_handler no value no value
                                        post_max_size 8M 8M
                                        precision 14 14
                                        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 /usr/lib/php5/libexec /usr/lib/php5/libexec
                                        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
                                        suhosin.log.phpscript 0 0
                                        suhosin.log.phpscript.is_safe Off Off
                                        suhosin.log.phpscript.name no value no value
                                        suhosin.log.sapi no value no value
                                        suhosin.log.script no value no value
                                        suhosin.log.script.name no value no value
                                        suhosin.log.syslog no value no value
                                        suhosin.log.syslog.facility no value no value
                                        suhosin.log.syslog.priority no value no value
                                        suhosin.log.use-x-forwarded-for 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.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                                        Apache API Version 20051115
                                        Server Administrator webmaster@localhost
                                        Hostname:Port 127.0.1.1:80
                                        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_deflate 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 192.168.1.54
                                        HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                                        HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                                        HTTP_ACCEPT_LANGUAGE fr,fr-fr;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 /usr/local/bin:/usr/bin:/bin
                                        SERVER_SIGNATURE <address>Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch Server at 192.168.1.54 Port 80</address>
                                        SERVER_SOFTWARE Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                                        SERVER_NAME 192.168.1.54
                                        SERVER_ADDR 192.168.1.54
                                        SERVER_PORT 80
                                        REMOTE_ADDR 192.168.1.183
                                        DOCUMENT_ROOT /var/www
                                        SERVER_ADMIN webmaster@localhost
                                        SCRIPT_FILENAME /var/www/test.php
                                        REMOTE_PORT 1054
                                        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 192.168.1.54
                                        User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                                        Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                                        Accept-Language fr,fr-fr;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/5.2.6-3ubuntu4.2
                                        Vary Accept-Encoding
                                        Content-Encoding gzip

                                        bcmath
                                        BCMath support enabled

                                        bz2
                                        BZip2 Support Enabled
                                        Stream Wrapper support compress.bz2://
                                        Stream Filter support bzip2.decompress, bzip2.compress
                                        BZip2 Version 1.0.5, 10-Dec-2007

                                        calendar
                                        Calendar support enabled

                                        ctype
                                        ctype functions enabled

                                        date
                                        date/time support enabled
                                        "Olson" Timezone Database Version 0.system
                                        Timezone Database internal
                                        Default timezone System/Localtime

                                        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 cdb cdb_make db4 inifile flatfile

                                        dom
                                        DOM/XML enabled
                                        DOM/XML API Version 20031129
                                        libxml Version 2.6.32
                                        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.25 2008/03/12 17:33:14 iliaa Exp $
                                        Supported EXIF Version 0220
                                        Supported filetypes JPEG,TIFF

                                        filter
                                        Input Validation and Filtering enabled
                                        Revision $Revision: 1.52.2.42 $

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

                                        ftp
                                        FTP 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.9

                                        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.32
                                        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.8g 19 Oct 2007

                                        pcre
                                        PCRE (Perl Compatible Regular Expressions) Support enabled
                                        PCRE Library Version 7.8 2008-09-05

                                        Directive Local Value Master Value
                                        pcre.backtrack_limit 100000 100000
                                        pcre.recursion_limit 100000 100000

                                        posix
                                        Revision $Revision: 1.70.2.3.2.18 $

                                        Reflection
                                        Reflection enabled
                                        Version $Id: php_reflection.c,v 1.164.2.33.2.50 2008/03/13 15:56:21 iliaa 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.39 $
                                        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,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
                                        user_agent no value no value

                                        sysvmsg
                                        sysvmsg support enabled
                                        Revision $Revision: 1.20.2.3.2.7 $

                                        tokenizer
                                        Tokenizer Support enabled

                                        wddx
                                        WDDX Support enabled
                                        WDDX Session Serializer enabled

                                        xml
                                        XML Support active
                                        XML Namespace Support active
                                        libxml2 Version 2.6.32

                                        xmlreader
                                        XMLReader enabled

                                        xmlwriter
                                        XMLWriter enabled

                                        zip
                                        Zip enabled
                                        Extension Version $Id: php_zip.c,v 1.1.2.43 2008/01/18 00:51:38 pajoye Exp $
                                        Zip version 1.8.11
                                        Libzip version 0.8.0-compatible

                                        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
                                        APACHE_PID_FILE /var/run/apache2.pid
                                        PATH /usr/local/bin:/usr/bin:/bin
                                        LANG C
                                        APACHE_RUN_GROUP www-data
                                        APACHE_RUN_USER www-data
                                        PWD /etc/php5

                                        PHP Variables
                                        Variable Value
                                        _SERVER["HTTP_HOST"] 192.168.1.54
                                        _SERVER["HTTP_USER_AGENT"] Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14
                                        _SERVER["HTTP_ACCEPT"] text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
                                        _SERVER["HTTP_ACCEPT_LANGUAGE"] fr,fr-fr;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"] /usr/local/bin:/usr/bin:/bin
                                        _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch Server at 192.168.1.54 Port 80</address>
                                        _SERVER["SERVER_SOFTWARE"] Apache/2.2.11 (Ubuntu) PHP/5.2.6-3ubuntu4.2 with Suhosin-Patch
                                        _SERVER["SERVER_NAME"] 192.168.1.54
                                        _SERVER["SERVER_ADDR"] 192.168.1.54
                                        _SERVER["SERVER_PORT"] 80
                                        _SERVER["REMOTE_ADDR"] 192.168.1.183
                                        _SERVER["DOCUMENT_ROOT"] /var/www
                                        _SERVER["SERVER_ADMIN"] webmaster@localhost
                                        _SERVER["SCRIPT_FILENAME"] /var/www/test.php
                                        _SERVER["REMOTE_PORT"] 1054
                                        _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"] 1253027284
                                        _SERVER["argv"]

                                        Array
                                        (
                                        )

                                        _SERVER["argc"] 0
                                        _ENV["APACHE_PID_FILE"] /var/run/apache2.pid
                                        _ENV["PATH"] /usr/local/bin:/usr/bin:/bin
                                        _ENV["LANG"] C
                                        _ENV["APACHE_RUN_GROUP"] www-data
                                        _ENV["APACHE_RUN_USER"] www-data
                                        _ENV["PWD"] /etc/php5

                                        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.
                                        0
                                        1. Tout à l'heure, tu avais les fichiers dans un répertoire 20060613+lfs , maintenant c'est dans un répertoire ext, et tu te mets à me parler de 2 serveurs maintenant...
                                          Vraiment pas facile de te suivre.
                                          mysql_so peut bien être où il veut, l'essentiel est que les informations extension_dir et extension= permettent de le retrouver
                                          0
                                          • 1
                                          • 2