PHP Forums Archive

Paypal IPN Listener and Go Daddy SQL : No connection.

Tags: php, paypal, ipn

deepsilentwaters posted on 2011-02-09 14:53:25 #

Hello All,
I ve been struggling to implement a clients paypal cart check out. The problem is arising when
The IPN listener coded in PHP is not able to insert sql records in the GoDaddy server.

Paypal Says :
Hello Prateek,

It appears you're not allowed to connect to your MySQL database remotely (mainstreetacadem.db.5126701.hostedresource.com).
This returns system error 110, which means the connection timed out.

PHP Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in test.php on line 165

I would suggest contacting your server provider to double check what the correct way to access your MySQL database is.
PayPal cannot assist you with further assistance in this specific matter.

Best of luck!

Kind regards,
Robert
-------------------------------------------------------------------------
I am still awaiting reply from GoDaddy but researching on it seems that GoDaddy does not allow remote database connections.
For my Download page to work i need 5 variables input from the Paypal IPN output. How do i do it without making the listener insert and the download page extract that from the mysql database?

Please Help,

Prateek

Comments / discussions

Olaf posted on 2011-02-10 07:53:35 #

Hello Prateek,

why do you need a remote database connection? Do you pass data from one server to another one?

If you get a response back from the paypal IPN your database server should be @ localhost (or on the godaddy network)

btw. GoDaddy is a very bad choice for web hosting ;)