[RESOLVED] troubleshoot a connecction

jrough

When this function calls the connect() function I get the returned message from the second function "unable to select database". See asterisks. So I tried a test page to see if my connection strings work and the connection strings work so I don't know how to troubleshoot this? Any suggestions?
thanks,

function doLogin($username, $password)
	{
		$this->connect();

	$this->username = $username;
	$this->password = $password;

	// check db for user and pass here.
	$sql = sprintf("SELECT * FROM user_tbl WHERE UserName = '%s' and Password = '%s' ",
		$this->clean($this->username), md5($this->clean($this->password)));				
	$result = mysql_query($sql, $this->connection);

	// If no user/password combo exists return false
	if(mysql_affected_rows($this->connection) != 1)
	{
		$this->disconnect();
		return false;
	}
	else // matching login ok
	{
		$row = mysql_fetch_assoc($result);

		// more secure to regenerate a new id.
		session_regenerate_id();

		//set session vars up
		$_SESSION['LoggedIn'] = true;
		$_SESSION['userName'] = $this->username;

	}

	$this->disconnect();
	return true;
}

function connect()
	{
		$this->connection = mysql_connect($this->db_host, $this->db_user, $this->db_password) 
							or die("Unable to connect to MySQL");
		mysql_select_db($this->db_name, $this->connection) or die("Unable to select DB!");   *********  

	// Valid connection object? everything ok?
	if($this->connection)
	{
		return true;
	}
	else return false;
}

$connection= mysql_connect('Xxx.XXX.XX.XX', 'myuser', 'mypassword')or die("Unable to connect to MySQL");
mysql_select_db('mydatabase', $connection) or die("Unable to select DB!");

if ($connection)
    echo "hello";
[code=php]

sneakyimp

Try adding the output of [man]mysql_error[/man] to your die statements so you get more info. It might tell you there's a permission problem or whatever.

jrough

Okay, that was helpful. It passes the connection step but it can't select the database. The error is in this line:
mysql_select_db($this->db_name, $this->connection) or die(mysql_error() );
It does appear to be an access issue.

I get this error:
"Access denied for user ''@'localhost' to database 'mydatabase' "

But why does it think it is the user@localhost because in the connection string I put in the IP address for the remote server? How do I change the user to be able to connect? I notice the root user connects via the mysql user.
mysql@myIPaddress. I don't know what the mysql user password is but I do have root access on the Mysql server. There is no root password and I need a password. I know this isn't advised but about 6 people use the root login so I can't change it.
I did add a user and a password but that user is @.

thanks,

sneakyimp

As far as I can tell, your db connection line doesn't use a connection string, it uses :

        $this->connection = mysql_connect($this->db_host, $this->db_user, $this->db_password)
                            or die("Unable to connect to MySQL");

And that connection is being made. However, when you try to select the db permission is denied.

The bottom line is that whoever is connecting needs permission or you will be denied. You either need to change your PHP to use a different user who has permissions or you need to grant permission to the user who is connecting.