php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #51147 mysql_connect can't resolve hostname within apache module
Submitted: 2010-02-25 18:25 UTC Modified: 2011-11-04 10:15 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: kugel at rci dot rutgers dot edu Assigned: mysql (profile)
Status: Not a bug Package: MySQL related
PHP Version: 5.2.12 OS:
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: kugel at rci dot rutgers dot edu
New email:
PHP Version: OS:

 

 [2010-02-25 18:25 UTC] kugel at rci dot rutgers dot edu
Description:
------------
When this is run from the command line: "php mytest.php" on the local 
machine, it connects successfully to the remote database.  When it's 
run as a webpage, it dies with the mysql_error message of "Unknown 
MySQL server host 'mysql.vobj.org' (2)"

Command line access "mysql -h mysql.vobj.org ..." works fine.

If I substitute the IP address for the hostname, the webpage connects.

NOTE: vobj.org is hosted by dreamhost, and while mysql.vobj.org maps 
to 
67.205.28.132, 67.205.28.132 maps to thadison.masevo.dreamhost.com.
Maybe there's some IP security check that causes failure without 
generating a useful error message.

Fedora 11 host, Apache/2.2.13 (Fedora)

Reproduce code:
---------------
<?php

# $host='67.205.28.132';
$host='mysql.vobj.org';
$database='bugdemo';
$dbuser='bugdemo';
$pw='PHPisGreat';

$link = mysql_connect($host,$dbuser,$pw)
    or die('Could not connect: ' . mysql_error() );
mysql_select_db($database) or die('Could not select database '.$database);

echo "successful connection<br />\n";
mysql_close($link);
?>

Expected result:
----------------
Code should say "successful connection<br />\n"

Actual result:
--------------
Could not connect: MySQL server host 'mysql.vobj.org' (2)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-03-09 20:48 UTC] jani@php.net
-Package: Feature/Change Request +Package: MySQL related
 [2010-05-11 12:46 UTC] andrey@php.net
-Status: Open +Status: Feedback
 [2010-05-11 12:46 UTC] andrey@php.net
Operating system?
 [2010-05-11 12:47 UTC] andrey@php.net
-Assigned To: +Assigned To: mysql
 [2010-05-11 12:55 UTC] pajoye@php.net
Fedora 11 host, Apache/2.2.13 (Fedora) (from the report)
 [2011-11-04 10:15 UTC] uw@php.net
-Status: Feedback +Status: Bogus
 [2011-11-04 10:15 UTC] uw@php.net
There are no IP checks in libmysql.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 11:01:30 2024 UTC