6 replies to this topic

[KodeKool]

Hey guys,

               So here's my issue, im doing some work for a client. and am finalizing the site by including the database information; however, i can't seem to connect to the database, which brings me to my question.

 

Using mysqli in php. how come the only thing you can connect to is localhost? everytime i've tried an actual URL it won't connect to the database. I always end up getting this error.

 

Warning: mysqli_real_connect(): [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connecti (trying to connect via tcp://serverName:port)

 

i know why im getting the error. but it seems no matter which way i try to connect, it doesn't work. has anybody run into this problem as well? and if so, did you find a way around it?

 

I know you can work around it by placing this code on the local machine where the database is and changing the connection to localhost. but im not at that point yet and need to be able to connect outside of the local machine. any ideas?

[BlackRabbit]

Well, aside the obvious needs ( a working server in the outside ), you need to address to things, 1 maybe you should increase the timeout for the connection, and then make sure the port is not blocked by any of the firewalls in the tcp route.

Usually, firewalls, proxies, etc has ports closed by default, you need to open then so the communication can flow.

[KodeKool]

lol. the servers up and working and all , but wouldn't i just be able to use the open port to connect? and what advantage would increasing the timeout do? if the connections proper, why wouldn't the default timeout work?

[Orjan]

A firewall can be blocking your application to connect to a remote server. The web server could be bound to only use the loopback ip.

[KodeKool]

so in plain text english, there's no real way to connect my code to the server unless it's on the host system? or i change the firewall settings?

[Orjan]

well, probably. but we can't be sure unless we have investigated further, for example, do the remote server accept connections from your server? many database servers is configured to only accept localhost connections for security reasons.

[KodeKool]

probably not. seeing as how i can't access it through this machine, lol. alright. i'll have to make other arrangements then which makes it a bit more difficult, but i think i can manage, thanks for your help guys, much appreciated