Monday, July 31, 2017

[google-cloud-sql-discuss] Cannot seem to write to Second Generation Cloud SQL?

I have a small test audio site where users can register, upload and play tracks 
  1. I have set up a LAMP stack using the Cloud launcher creating VM001
  2. set up phpMyAdmin locally
  3. deployed script which writes input data to local database
  4. have now created a 2nd Generation Cloud SQL db_cloud
  5. Have allowed the VM001 IP address under Access Control>>Authorisaion
  6. have created a user MEMEME with password
  7. added IP address to phpMyAdmin which i can log into with the user credentials (not Root)
  8. i have imported the database from local >> db_cloud
Ie  - i have a local setup which is tried and tested and works fine
AND 
now i am attempting to use Google Cloud SQL service instead of local database.

everything seems to be in working order
EXCEPT

  1. new inputs eg new user / new uploads /  etc do not seem to be written to the external database
  2. user cannot play existing tracks
Have i missed anything in terms of permissions for connecting between my Google Compute Engine VM instance and Google SQL instance?

THanks

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/71c04ee2-9efa-4a70-b589-8ff6c13e8bd2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment