ID: 30254 User updated by: mave at clanteamtreff dot com -Summary: MySQL Connection lost on ftp_close Reported By: mave at clanteamtreff dot com Status: Open -Bug Type: FTP related +Bug Type: Sockets related Operating System: Debian 3.0 r2 kernel 2.6.7 PHP Version: 5.0.1 New Comment:
im currently develope some new interfaces, the problem i told with problems on ftp_close() can reproduced with all socket connections. This mean, my SQL Connection gets lost if any command closes a socket connection. I connect to sql server ( mysql_connect(...) ) then i want to use file_get_contents with fopen wrappers from an ftpserver. The File read from the ftp server is sucessfully, but after that command, the mysql connection is lost. All the Commands i have testet with using sockets or something like this, kills the mysql connection. If there are any questitions, just ask. (Sorry for my bad english, i hope you understand all) Previous Comments: ------------------------------------------------------------------------ [2004-09-27 12:51:37] mave at clanteamtreff dot com Description: ------------ currently i use a MySQL Class to handle the Connection to the Database. No i wrote a litte FTP tool, to get a logfile from an other server. After the command ftp_close my MySQL Connection is broken, he tells me, MySQL Connection lost during Query or Connection to MySQL lost, reconnecting. If i deactivate the ftp_close command, the whole page runns perfectly. I think there is a problem with handling the resources. I use the XAMPP Linux 1.4.8 from www.apachefriends.org. Reproduce code: --------------- $handle = ftp_connect(gethostbyname("localhost"), 21); $res = ftp_login( $handle, $login, $pass); if( !$res ) echo "Can't login to FTP"; $f_name = "/tmp/FTP-TMP.".randomstring(20); $file = fopen( $f_name, "w+" ); if( !$file ) echo "Can't fopen the File"; ftp_fget( $handle, $file, "lastout.txt", FTP_ASCII); ... $kontent = writemessage($out); // Produce the output fclose($file); ftp_close($handle); // clean up unlink($f_name); // clean up Expected result: ---------------- Output from the MySQL Class: [MySQL]: Verbindung zum Host verloren, neuaufbau der Verbindung (that means connection lost, reconnecting) And the rest of the Page can't connect to the mysql server. after i remove the "ftp_close($handle);" line, it works fine. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30254&edit=1