Google Database timeout

[GoogleCodeExporter]

What steps will reproduce the problem?
1.configure mi ip in google cloud
2.trying to enter to claapme.info/claaps
3.enter an user an pass

What is the name of your database instance?
crucial-bonito-58:inicio 

What is the expected output? What do you see instead?
it must access the database and switch to next page when the user and pass is 
correct, instead it timeout and stay in the same page.

I already got the public ip from my server and the problem stays the same.

Please provide any additional information below.

Original issue reported on code.google.com by jgam...@gmail.com on 9 Sep 2014 at 6:15

[GoogleCodeExporter]

We can't debug your application. You need to tell us more about the exact calls 
you are making to your database, and what errors, if any, you are getting from 
those calls.

Original comment by cwes...@google.com on 10 Sep 2014 at 5:16

[GoogleCodeExporter]

We use the following:

$this->conn = new mysqli($this->db_host, $this->db_user,$this->db_pass, 
$this->db_name);

with the info for our account.

It returns:

Error en la conexion
Can't connect to MySQL server on '173.194.108.157' (110)

Original comment by dsinte...@gmail.com on 10 Sep 2014 at 10:09

[GoogleCodeExporter]

we already put the ip of our site in the google cloud platform

Original comment by dsinte...@gmail.com on 10 Sep 2014 at 10:17

[GoogleCodeExporter]

Are all attempts to connect failing, or just some of them?

I see four IP addresses authorized to access this instance (I won't publish 
your IPs here). Are you sure that you are trying to access from one of those? 
Please check those addresses in the console against your host(s).

There are limits to the number of connections you can have: 
https://developers.google.com/cloud-sql/faq#sizeqps . Check to make sure you 
aren't exceeding this limit; if you are, you may need to use connection pooling 
within your servers.

Original comment by cwes...@google.com on 11 Sep 2014 at 5:22

[GoogleCodeExporter]

All of the attemps from 23.229.157.192 fail, even when its already registered 
for authorization.

Original comment by dsinte...@gmail.com on 11 Sep 2014 at 9:46

[GoogleCodeExporter]

I checked, and that IP address is authorized in the console.

I checked our connection logs, and there are many successful attempts to 
connect from this IP address, and no failures. My next guess is that you've 
forgotten to grant access to this IP from within MySQL itself. In other words, 
you're request is getting as far as the mysql server, but the server is 
rejecting it, not the network firewall. See 
http://dev.mysql.com/doc/refman/5.6/en/grant.html for granting rights on 
objects to 'username'@'host'. We suspect you haven't added this particular 
host, and that's why MySQL itself is rejecting the connection.

Original comment by cwes...@google.com on 12 Sep 2014 at 9:07

[GoogleCodeExporter]

Technical support for individual applications is not provided via the issue 
tracker.

If you need individual help with your project, please visit 
https://cloud.google.com/support/ to choose options which will meet your needs.

Original comment by khash...@google.com on 17 Mar 2015 at 3:49

• Changed state: Invalid