Hi George,
Here are my app.yaml contents:
runtime: php
env: flex
runtime_config:
document_root: public
skip_files:
- .env
env_variables:
APP_LOG: errorlog
APP_KEY: base64:BEVs/DqwJFIx+WAhNu/AMgbs3uv4rOyg84kgFgMg81M=
STORAGE_DIR: /tmp
CACHE_DRIVER: database
SESSION_DRIVER: database
DB_HOST: localhost
DB_DATABASE: zoho_portal
DB_USERNAME: root
DB_PASSWORD: PASS
DB_SOCKET: "/cloudsql/zoho-portal-159018:us-central1:zoho-portal"
beta_settings:
cloud_sql_instances: "zoho-portal-159018:us-central1:zoho-portal"Enter
code here...
For migrations, I ran the following commands:
- *./cloud_sql_proxy -instances=zoho-portal=tcp:3307
-dir="/var/run/mysqld/" *(ran this from my '*~*' home directory, used
port 3307 as 3306 was busy)
- *mysql -h 127.0.0.1 -u root -p -e "CREATE DATABASE zoho_portal;"*
- *php artisan session:table*
-
*php artisan migrate --force *
Here is the output of "*gcloud sql instances describe zoho-portal*":
connectionName: zoho-portal-159018:us-central1:zoho-portal
etag: '"S7mq0U3H_YqBSBXO0x5cA9E1UOg/MjI"'
instance: zoho-portal
instanceType: CLOUDSQL_INSTANCE
ipAddresses:
- ipAddress: 104.197.134.245
kind: sql#instance
project: zoho-portal-159018
region: us-central1
serverCaCert:
cert: |-
-----BEGIN CERTIFICATE-----
MIIDITCCAgmgAwIBAgIBADANBgkqhkiG9w0BAQUFADBIMSMwIQYDVQQDExpHb29n
bGUgQ2xvdWQgU1FMIFNlcnZlciBDQTEUMBIGA1UEChMLR29vZ2xlLCBJbmMxCzAJ
BgNVBAYTAlVTMB4XDTE3MDIyMTE2NTgyM1oXDTE5MDIyMTE2NTkyM1owSDEjMCEG
A1UEAxMaR29vZ2xlIENsb3VkIFNRTCBTZXJ2ZXIgQ0ExFDASBgNVBAoTC0dvb2ds
ZSwgSW5jMQswCQYDVQQGEwJVUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoC
ggEBAKCPDkQPGuLW+zyms2m5FrqoNmRPwZ5NhfNnvkoEHTsXuOSO9xHULJ8NEVFi
C5LECS/Xasnn4OLWtBa1YoRVjDpK2/oXKJCJpp8O53S56wRrasw4LhrUAL28jpOA
Yp0YRXUX23Awaj2fqIsAg/8FxN+dkvJ/mH2PP6U987Jcdf4I/7nzL8uR4L3oxK+q
hLjIL7t5Dtgypw0zXljcTfU58c74mogOBsxGvzysTuI6u+ajqEufIK2iHBGJtX7B
BNz5exUT2bywun25zzyKkR8iHr8y19C0FnjAjfoJBrbxUzq3NUyTQt39bALJZer2
7sHYOGmsa/4KU8pKLxI0dnGHhCUCAwEAAaMWMBQwEgYDVR0TAQH/BAgwBgEB/wIB
ADANBgkqhkiG9w0BAQUFAAOCAQEAHY6KDZLi7ZgjNPXe+j1H+e7aWzHkyP5F9bYI
KyRnsH9TNSHWz6N2W4U3kyYUyg3SgXmQ9r+tuBWVcOsnUDT6Ft87yNz4hWqmTODp
HR24FmU+M69MmvRUz0zYJVklBZmsjlyIjg7HjccUmr1tsY+//e7Knmb2S13DdDFO
e90qtLJ/qEhJmMA+34CZLy7zAcvhyivWKpQzc9g5/gFgy9STTWrraPYM2FIs8BNH
UBqFenNltiaeUAM71Qm7EGPuqBKzCghZkqc5i36rib3nNAIrcmltteW+R9XAO9dJ
18A0cmDzconCmCM1nC2IMe0p8sq8Q4XAe6ZlHiSqq2SyFbCTpA==
-----END CERTIFICATE-----
certSerialNumber: '0'
commonName: C=US,O=Google\, Inc,CN=Google Cloud SQL Server CA
createTime: '2017-02-21T16:58:23.901000+00:00'
expirationTime: '2019-02-21T16:59:23.901000+00:00'
instance: zoho-portal
kind: sql#sslCert
sha1Fingerprint: f9542f8127049fbd53fc7fd31bd354d4d193b342
serviceAccountEmailAddress: cf7gohcs4bai7ifkuygjlj2qgq@speckle-umbrella-
7.iam.gserviceaccount.com
settings:
activationPolicy: ALWAYS
backupConfiguration:
- binaryLogEnabled: true
enabled: true
id: 2c4b4c97-96e8-45e2-8f84-0f799259c262
kind: sql#backupConfiguration
startTime: 08:00
ipConfiguration:
enabled: true
kind: sql#ipConfiguration
kind: sql#settings
pricingPlan: PER_USE
replicationType: SYNCHRONOUS
settingsVersion: '22'
tier: db-f1-micro
state: RUNNABLE
On Thursday, June 15, 2017 at 12:51:44 AM UTC+5, George (Cloud Platform
Support) wrote:
>
> How does your final, corrected app.yaml look like? Does it contain a line
> similar to the following one?
>
> # Ensure we skip ".env", which is only for local development
> skip_files:
> - .env
>
> What migration commands did you employ, exactly?
>
> What is the result of running the "gcloud sql instances describe
> YOUR_INSTANCE_NAME" command?
>
--
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/28cdb9c3-3dcb-4432-b410-c653ab9d755a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
