PHP/mySQL question

andyhuck

Hello,

This question may have nothing to do with PHP but i'm going to post it anyways, cause i'm not sure.

I'm writting a PHP script that is to be run on a server (Let's call it Server A). And I have a mySQL database on Server B.

I am trying to connect to Server B with the script running on Server A and get the information i need through a query.

Code:

$db=mysql_connect("Server B");
mysql_select_db("database",$db);

$result=mysql_list_tables("database");

while($row= mysql_fetch_row($result))
{
print $row[0];
}

This code works when the script is on the same server that the database is on. I'm pretty sure that there is a problem when I try to select the database i want.

Any ideas?

thanks
Andy

simon622

The problem will undoubtably be in the connection string.

normally you connect like this;

$domain = --ABSOLUTE PATH TO THE SERVER -- 
mysql_connect($domain,$username,$password);

You shouldn't be connecting to localhost.

Hope this works

andyhuck

thanks Simon,

i've narrowed it down to being in the line of code

$db=mysql_connect("Server B");

and i think my mistake comes in the ("Server B") part of the code.

so far i've just been putting ("localhost") in there. and i'm wondering if i'll need to put any backslashes or special characters in there to be able to connect to another server.

also, do i need to put an IP address or server name?

thanks
Andy

simon622

The domain part should be refernced as an absolute if its on a different server for example;

mysql_connect([string host[:port][:/socketpath]],[string user],[string password]);

The host should be pointed the the root of your server. You should be able to use either DNS or IP address. I personally would use IP address, as this goes diectly though to the server in question.

You should then use the port arguement to point at the database port.

andyhuck

ok, i hadn't tried to use a port number before and i thought that was going to do it. but when i tried it, i still didn't change anything.

$db=mysql_connect("IP:3306");

i tried the IP address and the server name.

the server also does not require a username and password.

any more ideas?

thanks again
Andy

andyhuck

i tried this now;

$db=mysql_connect("IP:3306") or die ("fail");

$result=mysql_list_tables("contactlist") or die ("failed");

and when i ran it, the page displayed "failed".

i also tried this with a normal query such as;

$result=mysql_query("select NAME from consultants",$db) or die ("failed");

and this also displayed "failed".

could this mean that there is some kind of security issue that i'm not taking into account?

could this mean that i'm not connecting to the proper IP and therefore when i try to make a query, there is nothing there?

yahelb

Could be that the user does NOT have permision to execute sql.

try to login without php ..

somthing like:
mysql -u=user -p=password --host=server a -port=3306 ...

or mysql front. ..

hope this could help

yahel

andyhuck

after talking with a co-worker, we think it is a security issue.

just like how a browser cannot right information to a server.

my co-worker believes that we have to use odbc except that neither one of us is familiar with it.

any suggestions on how this would work with odbc while i research it myself?

thanks
Andy

andyhuck

i got it working by using;

GRANT ALL PRIVILEGES ON db.* TO andyhuck@'IP';

on the mySQL server.

thanks
Andy