Hallo
ich bekomme folgenden Fehler wenn ich versuche vom localen pc auf eine Mysql zu connecten:
Ich bekomme keine verbindung und weis nicht warum.
Hier die php info
ich bekomme folgenden Fehler wenn ich versuche vom localen pc auf eine Mysql zu connecten:
PHP-Code:
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/web27/html/mysql_config.inc.php on line 76
Notice: Verbindung zur Datenbank nicht möglich.
Mysql-fehlermeldung:
Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/web27/html/mysql_config.inc.php on line 84
Hier die php info
Code:
PHP Version 5.2.11-0.dotdeb.0 System Linux v1030003021.virtualbots.de 2.6.18-128.2.1.el5.028stab064.7 #1 SMP Wed Aug 26 15:47:17 MSD 2009 i686 Build Date Sep 20 2009 15:53:40 Server API CGI/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/cgi Loaded Configuration File /etc/apache2/confixx_phpini/web27/1/php.ini Scan this dir for additional .ini files /etc/php5/cgi/conf.d additional .ini files parsed /etc/php5/cgi/conf.d/curl.ini, /etc/php5/cgi/conf.d/gd.ini, /etc/php5/cgi/conf.d/imap.ini, /etc/php5/cgi/conf.d/mcrypt.ini, /etc/php5/cgi/conf.d/mhash.ini, /etc/php5/cgi/conf.d/mysql.ini, /etc/php5/cgi/conf.d/mysqli.ini, /etc/php5/cgi/conf.d/pdo.ini, /etc/php5/cgi/conf.d/pdo_mysql.ini, /etc/php5/cgi/conf.d/xmlrpc.ini, /etc/php5/cgi/conf.d/xsl.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 https, ftps, compress.zlib, compress.bzip2, php, file, data, http, ftp, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed
This server is protected with the Suhosin Patch 0.9.7 Copyright (c) 2006 Hardened-PHP Project
This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies This program was built by Dotdeb. PHP Credits Configuration PHP Core DirectiveLocal ValueMaster Value allow_call_time_pass_referenceOnOn allow_url_fopenOnOn allow_url_includeOffOff always_populate_raw_post_dataOffOff arg_separator.input&& arg_separator.output&& asp_tagsOffOff auto_append_fileno valueno value auto_globals_jitOnOn auto_prepend_fileno valueno value browscapno valueno value default_charsetno valueno value default_mimetypetext/htmltext/html define_syslog_variablesOffOff disable_classesno valueno value disable_functionsno valueno value display_errorsOnOn display_startup_errorsOffOff doc_rootno valueno value docref_extno valueno value docref_rootno valueno value enable_dlOnOn error_append_stringno valueno value error_logno valueno value error_prepend_stringno valueno value error_reporting61356135 expose_phpOnOn extension_dir/usr/lib/php5/20060613+lfs/usr/lib/php5/20060613+lfs file_uploadsOnOn 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_errorsOnOn ignore_repeated_errorsOffOff ignore_repeated_sourceOffOff ignore_user_abortOffOff implicit_flushOffOff include_path.:/usr/share/php:/usr/share/pear.:/usr/share/php:/usr/share/pear log_errorsOffOff log_errors_max_len10241024 magic_quotes_gpcOnOn magic_quotes_runtimeOffOff magic_quotes_sybaseOffOff mail.force_extra_parametersno valueno value mail_extra_headersOnOn max_execution_time3030 max_input_nesting_level6464 max_input_time6060 memory_limit128M128M open_basedirno valueno value output_bufferingno valueno value output_handlerno valueno value post_max_size8M8M precision1212 realpath_cache_size16K16K realpath_cache_ttl120120 register_argc_argvOnOn register_globalsOffOff register_long_arraysOnOn report_memleaksOnOn report_zend_debugOnOn safe_modeOnOn safe_mode_exec_dirno valueno value safe_mode_gidOffOff safe_mode_include_dirno valueno value sendmail_fromno valueno value sendmail_path/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision100100 short_open_tagOnOn SMTPlocalhostlocalhost smtp_port2525 sql.safe_modeOffOff suhosin.log.phpscript00 suhosin.log.phpscript.is_safeOffOff suhosin.log.phpscript.nameno valueno value suhosin.log.sapino valueno value suhosin.log.scriptno valueno value suhosin.log.script.nameno valueno value suhosin.log.syslogno valueno value suhosin.log.syslog.facilityno valueno value suhosin.log.syslog.priorityno valueno value suhosin.log.use-x-forwarded-forOffOff track_errorsOffOff unserialize_callback_funcno valueno value upload_max_filesize8M8M upload_tmp_dir/var/www/web27/phptmp//var/www/web27/phptmp/ user_dirno valueno value variables_orderEGPCSEGPCS xmlrpc_error_number00 xmlrpc_errorsOffOff y2k_complianceOnOn zend.ze1_compatibility_modeOffOff bcmath BCMath support enabled bz2 BZip2 Support Enabled Stream Wrapper support compress.bz2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.3, 15-Feb-2005 calendar Calendar support enabled cgi-fcgi DirectiveLocal ValueMaster Value cgi.check_shebang_line11 cgi.fix_pathinfo11 cgi.nph00 cgi.rfc2616_headers00 fastcgi.logging11 ctype ctype functions enabled curl cURL support enabled cURL Information libcurl/7.15.5 OpenSSL/0.9.8c zlib/1.2.3 libidn/0.6.5 date date/time support enabled "Olson" Timezone Database Version 2009.13 Timezone Database internal Default timezone Europe/Berlin DirectiveLocal ValueMaster Value date.default_latitude31.766731.7667 date.default_longitude35.233335.2333 date.sunrise_zenith90.58333390.583333 date.sunset_zenith90.58333390.583333 date.timezoneno valueno 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.27 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 287371 2009-08-16 14:31:27Z iliaa $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF filter Input Validation and Filtering enabled Revision $Revision: 288083 $ DirectiveLocal ValueMaster Value filter.defaultunsafe_rawunsafe_raw filter.default_flagsno valueno value ftp FTP support enabled gd GD Support enabled GD Version bundled (2.0.34 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.2.1 T1Lib Support enabled GIF Read Support enabled GIF Create Support enabled JPG Support enabled PNG Support enabled WBMP Support enabled XPM Support enabled XBM 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.3.6 DirectiveLocal ValueMaster Value iconv.input_encodingISO-8859-1ISO-8859-1 iconv.internal_encodingISO-8859-1ISO-8859-1 iconv.output_encodingISO-8859-1ISO-8859-1 imap IMAP c-Client Version 2001 SSL Support enabled Kerberos Support enabled json json support enabled json version 1.2.1 libxml libXML support active libXML Version 2.6.27 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. DirectiveLocal ValueMaster Value mbstring.detect_orderno valueno value mbstring.encoding_translationOffOff mbstring.func_overload00 mbstring.http_inputpasspass mbstring.http_outputpasspass mbstring.internal_encodingno valueno value mbstring.languageneutralneutral mbstring.strict_detectionOffOff mbstring.substitute_characterno valueno value mcrypt mcrypt supportenabled Version 2.5.7 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream DirectiveLocal ValueMaster Value mcrypt.algorithms_dirno valueno value mcrypt.modes_dirno valueno value mhash MHASH support Enabled MHASH API Version 20060101 mime_magic mime_magic supportinvalid magic file, disabled DirectiveLocal ValueMaster Value mime_magic.debugOffOff mime_magic.magicfile/usr/share/file/magic.mime/usr/share/file/magic.mime mysql MySQL Supportenabled Active Persistent Links 0 Active Links 0 Client API version 5.0.84 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/run/mysqld/mysqld.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient DirectiveLocal ValueMaster Value mysql.allow_persistentOnOn mysql.connect_timeout6060 mysql.default_hostno valueno value mysql.default_passwordno valueno value mysql.default_portno valueno value mysql.default_socketno valueno value mysql.default_userno valueno value mysql.max_linksUnlimitedUnlimited mysql.max_persistentUnlimitedUnlimited mysql.trace_modeOffOff mysqli MysqlI Supportenabled Client API library version 5.0.84 Client API header version 5.0.67 MYSQLI_SOCKET /var/run/mysqld/mysqld.sock DirectiveLocal ValueMaster Value mysqli.default_hostno valueno value mysqli.default_port33063306 mysqli.default_pwno valueno value mysqli.default_socketno valueno value mysqli.default_userno valueno value mysqli.max_linksUnlimitedUnlimited mysqli.reconnectOffOff openssl OpenSSL support enabled OpenSSL Version OpenSSL 0.9.8c 05 Sep 2006 pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 7.9 2009-04-11 DirectiveLocal ValueMaster Value pcre.backtrack_limit100000100000 pcre.recursion_limit100000100000 PDO PDO supportenabled PDO drivers mysql pdo_mysql PDO Driver for MySQL, client library version5.0.84 posix Revision $Revision: 286880 $ Reflection Reflectionenabled Version $Id: php_reflection.c 287991 2009-09-03 14:02:51Z sebastian $ session Session Support enabled Registered save handlers files user Registered serializer handlers php php_binary wddx DirectiveLocal ValueMaster Value session.auto_startOffOff session.bug_compat_42OnOn session.bug_compat_warnOnOn session.cache_expire180180 session.cache_limiternocachenocache session.cookie_domainno valueno value session.cookie_httponlyOffOff session.cookie_lifetime00 session.cookie_path// session.cookie_secureOffOff session.entropy_fileno valueno value session.entropy_length00 session.gc_divisor100100 session.gc_maxlifetime14401440 session.gc_probability00 session.hash_bits_per_character44 session.hash_function00 session.namePHPSESSIDPHPSESSID session.referer_checkno valueno value session.save_handlerfilesfiles session.save_path/var/lib/php5/var/lib/php5 session.serialize_handlerphpphp session.use_cookiesOnOn session.use_only_cookiesOffOff session.use_trans_sid00 shmop shmop support enabled SimpleXML Simplexml supportenabled Revision $Revision: 272374 $ Schema support enabled soap Soap Client enabled Soap Server enabled DirectiveLocal ValueMaster Value soap.wsdl_cache11 soap.wsdl_cache_dir/tmp/tmp soap.wsdl_cache_enabled11 soap.wsdl_cache_limit55 soap.wsdl_cache_ttl8640086400 sockets Sockets Support enabled SPL SPL supportenabled 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 DirectiveLocal ValueMaster Value assert.active11 assert.bail00 assert.callbackno valueno value assert.quiet_eval00 assert.warning11 auto_detect_line_endings00 default_socket_timeout6060 safe_mode_allowed_env_varsPHP_PHP_ safe_mode_protected_env_varsLD_LIBRARY_PATHLD_LIBRARY_PATH url_rewriter.tagsa=href,area=href,frame=src,input=src,form=,fieldset=a=href,area=href,frame=src,input=src,form=,fieldset= user_agentno valueno value sysvmsg sysvmsg support enabled Revision $Revision: 272374 $ tokenizer Tokenizer Support enabled wddx WDDX Supportenabled WDDX Session Serializer enabled xml XML Support active XML Namespace Support active libxml2 Version 2.6.27 xmlreader XMLReader enabled xmlrpc core library version xmlrpc-epi v. 0.51 php extension version 0.51 author Dan Libby homepage http://xmlrpc-epi.sourceforge.net open sourced by Epinions.com xmlwriter XMLWriter enabled xsl XSL enabled libxslt Version 1.1.19 libxslt compiled against libxml Version 2.6.27 EXSLT enabled libexslt Version 1.1.19 Zend Optimizer Optimization Pass 1 enabled Optimization Pass 2 enabled Optimization Pass 3 enabled Optimization Pass 4 enabled Optimization Pass 9 disabled Zend Loader enabled License Path no value Obfuscation level 3 zip Zip enabled Extension Version $Id: php_zip.c 287723 2009-08-26 02:16:41Z guenter $ Zip version 1.8.11 Libzip version 0.9.0 zlib ZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.3 Linked Version 1.2.3 DirectiveLocal ValueMaster Value zlib.output_compressionOffOff zlib.output_compression_level-1-1 zlib.output_handlerno valueno value Additional Modules Module Name dbase ionCube Loader sysvsem sysvshm Environment VariableValue DOCUMENT_ROOT /var/www/web27/html GATEWAY_INTERFACE CGI/1.1 HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING gzip,deflate HTTP_ACCEPT_LANGUAGE de-de,de;q=0.8,en-us;q=0.5,en;q=0.3 HTTP_CONNECTION keep-alive HTTP_HOST messi.aionmod.de HTTP_KEEP_ALIVE 300 HTTP_USER_AGENT Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.1.9) Gecko/20100315 Firefox/3.5.9 PATH /bin:/usr/bin PHPRC /etc/apache2/confixx_phpini/web27/1 QUERY_STRING no value REDIRECT_STATUS 200 REMOTE_ADDR 95.89.79.247 REMOTE_PORT 1943 REQUEST_METHOD GET REQUEST_URI /inf.php SCRIPT_FILENAME /var/www/web27/html/inf.php SCRIPT_NAME /inf.php SERVER_ADDR 188.165.68.239 SERVER_ADMIN [no address given] SERVER_NAME messi.aionmod.de SERVER_PORT 80 SERVER_PROTOCOL HTTP/1.1 SERVER_SIGNATURE <address>Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c Server at messi.aionmod.de Port 80</address> SERVER_SOFTWARE Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c PHP Variables VariableValue _SERVER["DOCUMENT_ROOT"]/var/www/web27/html _SERVER["GATEWAY_INTERFACE"]CGI/1.1 _SERVER["HTTP_ACCEPT"]text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 _SERVER["HTTP_ACCEPT_CHARSET"]ISO-8859-1,utf-8;q=0.7,*;q=0.7 _SERVER["HTTP_ACCEPT_ENCODING"]gzip,deflate _SERVER["HTTP_ACCEPT_LANGUAGE"]de-de,de;q=0.8,en-us;q=0.5,en;q=0.3 _SERVER["HTTP_CONNECTION"]keep-alive _SERVER["HTTP_HOST"]messi.aionmod.de _SERVER["HTTP_KEEP_ALIVE"]300 _SERVER["HTTP_USER_AGENT"]Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.1.9) Gecko/20100315 Firefox/3.5.9 _SERVER["PATH"]/bin:/usr/bin _SERVER["PHPRC"]/etc/apache2/confixx_phpini/web27/1 _SERVER["QUERY_STRING"]no value _SERVER["REDIRECT_STATUS"]200 _SERVER["REMOTE_ADDR"]95.89.79.247 _SERVER["REMOTE_PORT"]1943 _SERVER["REQUEST_METHOD"]GET _SERVER["REQUEST_URI"]/inf.php _SERVER["SCRIPT_FILENAME"]/var/www/web27/html/inf.php _SERVER["SCRIPT_NAME"]/inf.php _SERVER["SERVER_ADDR"]188.165.68.239 _SERVER["SERVER_ADMIN"][no address given] _SERVER["SERVER_NAME"]messi.aionmod.de _SERVER["SERVER_PORT"]80 _SERVER["SERVER_PROTOCOL"]HTTP/1.1 _SERVER["SERVER_SIGNATURE"]<address>Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c Server at messi.aionmod.de Port 80</address> _SERVER["SERVER_SOFTWARE"]Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c _SERVER["PHP_SELF"]/inf.php _SERVER["REQUEST_TIME"]1276811266 _SERVER["argv"]Array ( ) _SERVER["argc"]0 _ENV["DOCUMENT_ROOT"]/var/www/web27/html _ENV["GATEWAY_INTERFACE"]CGI/1.1 _ENV["HTTP_ACCEPT"]text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 _ENV["HTTP_ACCEPT_CHARSET"]ISO-8859-1,utf-8;q=0.7,*;q=0.7 _ENV["HTTP_ACCEPT_ENCODING"]gzip,deflate _ENV["HTTP_ACCEPT_LANGUAGE"]de-de,de;q=0.8,en-us;q=0.5,en;q=0.3 _ENV["HTTP_CONNECTION"]keep-alive _ENV["HTTP_HOST"]messi.aionmod.de _ENV["HTTP_KEEP_ALIVE"]300 _ENV["HTTP_USER_AGENT"]Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.1.9) Gecko/20100315 Firefox/3.5.9 _ENV["PATH"]/bin:/usr/bin _ENV["PHPRC"]/etc/apache2/confixx_phpini/web27/1 _ENV["QUERY_STRING"]no value _ENV["REDIRECT_STATUS"]200 _ENV["REMOTE_ADDR"]95.89.79.247 _ENV["REMOTE_PORT"]1943 _ENV["REQUEST_METHOD"]GET _ENV["REQUEST_URI"]/inf.php _ENV["SCRIPT_FILENAME"]/var/www/web27/html/inf.php _ENV["SCRIPT_NAME"]/inf.php _ENV["SERVER_ADDR"]188.165.68.239 _ENV["SERVER_ADMIN"][no address given] _ENV["SERVER_NAME"]messi.aionmod.de _ENV["SERVER_PORT"]80 _ENV["SERVER_PROTOCOL"]HTTP/1.1 _ENV["SERVER_SIGNATURE"]<address>Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c Server at messi.aionmod.de Port 80</address> _ENV["SERVER_SOFTWARE"]Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.11-0.dotdeb.0 with Suhosin-Patch mod_ssl/2.2.3 OpenSSL/0.9.8c 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.
Kommentar