Hi Nicolas, I still have this same issue I am getting the error SQLSTATE[HY000] [2002] No such file or directory when trying to connect to Cloud SQL from my app engine. It works fine on my "default" service which is a PHP standard environment.
I have this issue in my custom runtime flexible environment app engine. My custom runtime is based on goole app engine php image gcr.io/google_appengine/php:2017-05-11-11-57 I am using 2nd gen cloud sql with PDO to connect to the instance.Custom runtime is on a different service but under same project as cloud sql. If i use the unix socket I am getting the error SQLSTATE[HY000] [2002] No such file or directory So I tried to use the cloud sql ip as host. In that situation i was getting a connection timeout error. I also added the beta settings to my app.yaml and used env variables from app.yaml still no luck. My app.yaml looks like below. My service is basically a pub/sub worker service i want to run a php script. runtime: custom env: flexservice: workerentrypoint: php index.phpbeta_settings: cloud_sql_instances: "<project-id>:<zone>:<instance-name>"env_variables: MYSQL_DSN: mysql:unix_socket=/cloudsql/<connect-name>;dbname=<db-name> MYSQL_USER: <username> MYSQL_PASSWORD: <password> I've been breaking my head for few days, I am stuck with this, I'd really appreciate some direction from you Cheers Karthik On Tuesday, 9 May 2017 04:31:45 UTC+12, Nicholas (Google Cloud Support) wrote: > > Connecting to a Cloud SQL instance requires the use of a Unix socket and > the appropriate extension available to the runtime. *mysql* and *mysqli* > are enabled by default > <https://cloud.google.com/appengine/docs/standard/php/runtime#PHP_Enabled_extensions> > > in the PHP runtime for App Engine. An example of connecting using > *mysqli_connect* can be found here > <http://stackoverflow.com/questions/24554143/connection-issue-connecting-from-php-app-engine-instance-to-a-cloud-sql-instance>. > > The key element here is the use of the *socket* argument in the > *mysqli_connect()* call. > > Note that the PHP team recommends using *PDO* or *mysqli* > <http://php.net/manual/en/mysqlinfo.api.choosing.php>, not the original > *mysql*. Are you facing any particular challenges with using mysqli or > PDO? > > On Sunday, April 30, 2017 at 11:08:15 PM UTC-4, Abinav Chandar wrote: >> >> Can this only be done with the PDO or can it also be done with >> mysql_connect() >> >> On Thursday, September 29, 2016 at 5:11:22 PM UTC-5, Kevin Lau wrote: >>> >>> >>> down votefavorite >>> <http://stackoverflow.com/questions/39778544/why-does-my-php-app-engine-not-connect-to-cloud-sql#> >>> >>> I am trying to connect my app engine PHP app to cloud sql via unix >>> socket (I assume that is correct so that I don't have to connect to the >>> ip). The connect via IP works but the unix socket does not. Any ideas? It's >>> also weird that when I ssh into the box, I don't see any /cloudsql/ >>> directory. I can create it by manually starting cloud_sql_proxy but that >>> doesn't persist as soon as I turn debug off. >>> >>> >>> I'm using: $db = new pdo( >>> 'mysql:unix_socket=/cloudsql/testproject-xxxxxx:us-central1:library;dbname=books', >>> >>> 'phpapp', // username 'somepw' // password ); >>> >>> And get SQLSTATE[HY000] [2002] No such file or directory >>> >> -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/429b360f-efb0-4c6a-8ed6-aab94fcd315d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
