A collection of samples that demonstrate how to call Google Cloud services from PHP.

Operating system and version (Windows, Mac OS X, Android, iOS, Win10 Mobile) Mac OS X High Sierra

Browser and version (Chrome, Firefox, Safari, IE, MS Edge, Opera 15+, Android Browser) Chrome

Reduced test cases and potential fixes using CodePen or JS Bin I am not totally sure how to create the reduced test case since the issue is that it seems to be completely skipping bootstrap. In my original site, I had the minified bootstrap css as the first lines in my style.css file, and then my custom CSS after that. I thought that was the problem, so I removed that and used the CDN link to boostrap css. That didn't work either so then I tried putting the non-minified bootstrap code directly into my style.css file and again it wouldn't register it. The rest of the CSS (my custom CSS) worked but the bootstrap classes would not. I go into more detail about this below.

In my first attempt to do this, I created this website as a test on Google Cloud: boxplotdata.com. As you can see, some of the CSS is loading but the bootstrap is not (it's not hiding the smaller versions of things until the screen size changes). This same exact code works perfectly on my non-Google cloud website, boxplotanalytics.com. But when I copied the exact same thing over to the Google Cloud version it stopped working.

I contacted the Bitnami help team since I am using their Wordpress instance on Google Cloud, and in order to try to produce an error for them, I created an entirely new project in Google Cloud, and this time followed tutorials from the Bitnami website in order to make sure I did all steps correctly. This second Google Cloud project is at datakeepteam.com.

I used SFTP to get into the server, and uploaded my theme as I usually do with my non-Google hosts. I got this error when I clicked on Appearance >> Themes in WordPress:

The following themes are installed but incomplete.

Name Description boxplot-theme Stylesheet is not readable.

This happened with the first project too (boxplotdata.com). To fix it, I deleted the bootstrap part of my stylesheet (I had the minified bootstrap as the first part of my stylesheet, then my custom CSS code below that) and then it recognized the stylesheet.

However, this time, I stopped at this point in case this helps solve the problem. Any idea why the bootstrap code isn't being recognized?

Thank you, Barb

I created a laravel application on app engine by following the steps highlighted here https://cloud.google.com/community/tutorials/run-laravel-on-appengine-flexible

I setup everything as indicated and I can even acess the database from my mysql client using all the users I created and make changes to the database, but when I run the application from the app engine url I get this error

PDOException in PDOConnection.php line 43: SQLSTATE[HY000] [2002] No such file or directory

 in PDOConnection.php line 43
at PDO->__construct('mysql:unix_socket=/cloudsql/{removed};dbname={removed}', '{removed}', '{removed}', array(0, 2, 0, false, false)) in PDOConnection.php line 43
at PDOConnection->__construct('mysql:unix_socket=/cloudsql{removed};dbname={removed}', {removed}', {removed}', array(0, 2, 0, false, false)) in Connector.php line 65
at Connector->createPdoConnection('mysql:unix_socket=/cloudsql/{removed};dbname={removed}', '{removed}', '{removed}', array(0, 2, 0, false, false)) in Connector.php line 44
at Connector->createConnection('mysql:unix_socket=/cloudsql{removed};dbname={removed}', array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => {removed}', 'username' => '{removed}', 'password' => {removed}', 'unix_socket' => '/cloudsql/{removed}', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, 'name' => 'mysql'), array(0, 2, 0, false, false)) in MySqlConnector.php line 24
at MySqlConnector->connect(array('driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => '{removed}', 'username' => '{removed}', 'password' => '{removed}', 'unix_socket' => '/cloudsql/{removed}', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null, 'name' => 'mysql')) in ConnectionFactory.php line 183

The thing I don't understand is why I am able to connect to the database using PDO in the standard environment but can't in the flexible and this only affects the laravel installation as provided in the aforementioned tutorial.

Need help because it has been several days without any results

Related

Split from #852

Steps

1. Create a Laravel 6 project based on this tutorial.

2. Create GAE configuration files:

2.a. Create a .cloudignore file:

# This file specifies files that are *not* uploaded to Google Cloud Platform
# using gcloud. It follows the same syntax as .gitignore, with the addition of
# "#!include" directives (which insert the entries of the given .gitignore-style
# file at that point).
#
# For more information, run:
#   $ gcloud topic gcloudignore
#
.gcloudignore

# If you would like to upload your .git directory, .gitignore file or files
# from your .gitignore file, remove the corresponding line
# below:
.git
.gitignore

# PHP Composer dependencies:
/vendor/

# Ignore .env file for local development
.env
.env.example

2.b. Create an api/app-staging.yaml file (some variable have been removed for security purposes):

service: staging
runtime: php73

runtime_config:
  document_root: public

env_variables:
  APP_STORAGE: /tmp
  VIEW_COMPILED_PATH: /tmp

  APP_DEBUG: true
  LOG_CHANNEL: stack
  BROADCAST_DRIVER: log
  CACHE_DRIVER: file
  QUEUE_CONNECTION: sync
  SESSION_DRIVER: cookie
  SESSION_LIFETIME: 120

2.c. Create a cloudbuild-staging.yaml file based on Automate App Engine deployments with Cloud Build:

steps:
  - name: "gcr.io/cloud-builders/gcloud"
    args: ["app", "deploy", "app-staging.yaml"]
    timeout: "1600s"
    dir: "api"

  env:
    - COMMIT_SHA=$COMMIT_SHA

3. Deploy directly from your local machine.

   gcloud app deploy app-staging.yaml
   

   This should build and deploy successfully, and the deployed website should load.

4. Add a build trigger for the staging branch that triggers a build using the cloudbuild-staging.yaml configuration.

5. Commit and push your changes the the trigger branch (staging).

6. Visit the deployed website.

Expected

The website loads.

Actual

Exception
The /workspace/bootstrap/cache directory must be present and writable.

Environment

macOS Catalina 10.15.6 Laravel Framework 6.18.25 PHP 7.4.7 (local) PHP 7.3 (Google App Engine Image)

I don't seem to be able to get past the error of file_put_contents(/tmp/framework/sessions/): failed to open stream: No such file or directory

php artisan --version Laravel Framework 5.8.3

So I have researched this, and read https://github.com/GoogleCloudPlatform/php-docs-samples/issues/706

I have also followed exactly the guide on https://cloud.google.com/community/tutorials/run-laravel-on-appengine-standard

However, I repeatedly get the issue of: file_put_contents(/tmp/framework/sessions/): failed to open stream: No such file or directory

The two differences I see from the guide are:

1. "Create a new Laravel project using the laravel installer: laravel new blog" Instead I did: composer create-project laravel/laravel --prefer-dist test_laravel_app

2. "composer remove --dev beyondcode/laravel-dump-server" returns: beyondcode/laravel-dump-server is not required in your composer.json and has not been removed Package "beyondcode/laravel-dump-server" listed for update is not installed. Ignoring.

I have tried using: php artisan route:clear php artisan config:clear php artisan cache:clear composer dump-autoload

These are intended to be simple examples that explicitly show:

• Importing the client library
• Instantiating a client
• Making a single API call
• Printing the result

Product covered:

• BigQuery
  • [x] - sample
  • [x] - test
• Datastore
  • [x] - sample
  • [x] - test
• Language
  • [x] - sample
  • [x] - test
• Logging
  • [x] - sample
  • [x] - test
• Pub/Sub
  • [x] - sample
  • [x] - test
• Speech
  • [x] - sample
  • [x] - test
• Storage
  • [x] - sample
  • [x] - test
• Translate
  • [x] - sample
  • [x] - test
• Vision
  • [x] - sample
  • [x] - test

For reference, see the corresponding samples in other languages:

• GoogleCloudPlatform/nodejs-docs-samples (samples are on master in various quickstart.js files)
• GoogleCloudPlatform/python-docs-samples#547
• GoogleCloudPlatform/ruby-docs-samples#77
• GoogleCloudPlatform/golang-samples#131
• GoogleCloudPlatform/java-docs-samples (pending)
• GoogleCloudPlatform/dotnet-docs-samples (pending)

Thanks!

I try to install Laravel 5.7 but i always got error "Class 'BeyondCode\DumpServer\DumpServerServiceProvider' not found". Its new on Laravel 5.7, and already on composer.json but why it can't be load?

its my composer.json

{
    "name": "laravel/laravel",
    "description": "The Laravel Framework.",
    "keywords": ["framework", "laravel"],
    "license": "MIT",
    "type": "project",
    "require": {
        "php": "7.2.*",
        "fideloper/proxy": "^4.0",
        "google/cloud": "^0.82.0",
        "laravel/framework": "5.7.*",
        "laravel/tinker": "^1.0"
    },
    "require-dev": {
        "beyondcode/laravel-dump-server": "^1.2",
        "filp/whoops": "^2.0",
        "fzaninotto/faker": "^1.4",
        "mockery/mockery": "^1.0",
        "nunomaduro/collision": "^2.0",
        "phpunit/phpunit": "^7.0"
    },
    "autoload": {
        "classmap": [
            "database/seeds",
            "database/factories"
        ],
        "psr-4": {
            "App\\": "app/"
        }
    },
    "autoload-dev": {
        "psr-4": {
            "Tests\\": "tests/"
        }
    },
    "extra": {
        "laravel": {
            "dont-discover": [
            ]
        }
    },
    "scripts": {
        "post-root-package-install": [
            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "@php artisan key:generate"
        ],
        "post-autoload-dump": [
            "Illuminate\\Foundation\\ComposerScripts::postAutoloadDump",
            "@php artisan package:discover"
        ],
        "post-install-cmd": [
            "Illuminate\\Foundation\\ComposerScripts::postInstall",
            "chmod -R 755 bootstrap\/cache"
        ],
        "post-update-cmd": [
            "Illuminate\\Foundation\\ComposerScripts::postUpdate",
            "chmod -R 755 bootstrap\/cache"
        ],
    },
    "config": {
        "preferred-install": "dist",
        "sort-packages": true,
        "optimize-autoloader": true
    },
    "minimum-stability": "dev",
    "prefer-stable": true
}

I haven't had this issue before, but today I started getting the error: "The requested PHP extension gd is missing from your system Flexible environment" when trying to the deploy my application.

My php.ini looks likes this:

extension=gd.so extension=curl.so extension=imagick.so extension=fileinfo.so

I'm getting the following output:

Loading composer repositories with package information Installing dependencies from lock file Your requirements could not be resolved to an installable set of packages.

Problem 1 - Installation request for dompdf/dompdf v0.8.0 -> satisfiable by dompdf/dompdf[v0.8.0]. - dompdf/dompdf v0.8.0 requires ext-gd * -> the requested PHP extension gd is missing from your system. Problem 2 - dompdf/dompdf v0.8.0 requires ext-gd * -> the requested PHP extension gd is missing from your system. - barryvdh/laravel-dompdf v0.8.1 requires dompdf/dompdf ^0.8 -> satisfiable by dompdf/dompdf[v0.8.0]. - Installation request for barryvdh/laravel-dompdf v0.8.1 -> satisfiable by barryvdh/laravel-dompdf[v0.8.1].

To enable extensions, verify that they are enabled in your .ini files: - /opt/php56/lib/php-cli.ini - /opt/php56/lib/ext.enabled/ext-apcu.ini - /opt/php56/lib/ext.enabled/ext-json.ini - /opt/php56/lib/ext.enabled/ext-libsodium.ini - /opt/php56/lib/ext.enabled/ext-mailparse.ini - /opt/php56/lib/ext.enabled/ext-memcached.ini You can also run php --ini inside terminal to see which files are used by PHP in CLI mode. The command '/bin/sh -c /build-scripts/composer.sh' returned a non-zero code: 2 ERROR ERROR: build step "gcr.io/cloud-builders/docker@sha256:f0bdb31bcf87dad333755477c02916411d5ac9ea891497d304a360b01f2fcb10" failed: exit status 2

Relies on https://github.com/googleapis/google-cloud-php/pull/3621 being merged and tagged.

cc @shaffeeullah

One of the tests is failing locally, I'll comment on it inline for reviewer thoughts.

I got all the way through deployment and hit:

Error establishing a database connection

when I tried to load the site. I'd guess a password issue, though it looks OK in wp-config.php.

I don't see anything in the cloud console logs to help. Is there some extra step to allow the app engine standard app to connect to Cloud SQL? On https://cloud.google.com/appengine/docs/standard/php/cloud-sql/ I see

Add the Cloud SQL instance connection name, database, user, and password to the
 nvironment variables in app.yaml.
appengine/standard/cloudsql/app.yaml VIEW ON GITHUB
env_variables:
  # Replace project, instance, database, user and password with the values obtained
  # when configuring your Cloud SQL instance.
  MYSQL_DSN: mysql:unix_socket=/cloudsql/INSTANCE_CONNECTION_NAME;dbname=DATABASE
  MYSQL_USER: root
  MYSQL_PASSWORD: ''

and the generated app.yaml doesn't seem to have that section.

Nope, adding that doesn't seem to have fixed it. :-(

I realized today that the following Error Reporting sample:

$msg = array(
        'message' => $e->getMessage(),
        'serviceContext' => array('service' => 'myapp'),
        // ... add more metadata
    );

Does not produce log messages that are processed by Stackdriver Error Reporting.

While waiting for the Stackdriver error parser to be updated, we must update our code sample to log errors in the appropriate format:

This code produces a payload that is correctly processed, I tested it and another person confirmed:

$msg = array(
        'message' => sprintf("PHP Notice: %s", (string)$e),
        'serviceContext' => array('service' => 'myapp'),
        // ... add more metadata
    );

I wanted to submit a PR, but realize that there are tests associated. Please update the sample as soon as possible to fix the Stackdriver Error Reporting compute engine instructions: https://cloud.google.com/error-reporting/docs/setup/compute-engine

I have a wordpress setup running in the Standard Environment. Execution locally with CloudSQL also works.

But performing Plugin maintenance via wp always fails:

# vendor/bin/wp plugins list --path=wordpress
PHP Warning:  require_once(google/appengine/api/urlfetch_service_pb.php): failed to open stream: No such file or directory in /Users/Sebastian.Just/development/workspaces/gcp/wordpress2/wordpress/wp-content/plugins/google-app-engine/modules/urlfetch.php on line 72
Warning: require_once(google/appengine/api/urlfetch_service_pb.php): failed to open stream: No such file or directory in /Users/Sebastian.Just/development/workspaces/gcp/wordpress2/wordpress/wp-content/plugins/google-app-engine/modules/urlfetch.php on line 72
PHP Fatal error:  require_once(): Failed opening required 'google/appengine/api/urlfetch_service_pb.php' (include_path='.:') in /Users/Sebastian.Just/development/workspaces/gcp/wordpress2/wordpress/wp-content/plugins/google-app-engine/modules/urlfetch.php on line 72
Fatal error: require_once(): Failed opening required 'google/appengine/api/urlfetch_service_pb.php' (include_path='.:') in /Users/Sebastian.Just/development/workspaces/gcp/wordpress2/wordpress/wp-content/plugins/google-app-engine/modules/urlfetch.php on line 72 

And it's true - those files really don't exist starting with google/appengine/ - but I'm unsure how the required_once even makes up those file names

Can I use the local server to update/install plugins or will this screw up some file paths in the Wordpress database?

The endpoints/getting-started sample app is outdated, and needs to be either upgraded to the new format or removed.

I have started upgrading the sample in https://github.com/GoogleCloudPlatform/php-docs-samples/commit/f36e623812240582b26ebbcab6593e3f3a58930b, but I'm not sure this works, or is even still a part of our cloud site samples.

Universal Analytics is going to be retired in less than 2 months, and the PHP library is still in beta. When did Google turn into a sloppy startup? New documentation is also very unclear on the whole workflow. Tbh, I'm actively pushing my customers to move to Matomo or whatever other open platform - we're not enthusiastic of doing rushed implementation work in the next month (and even then, who knows when it will gets stable).

I know php-samples-reviewers only has 2 people, but we should update the php-sample-reviewers so that it's synced correctly. php-admin are the repo owners.

Running the longRunningRecognize code :

$op = $speechCLient->longRunningRecognize($config, $audio);
$op->pollUntilComplete(); 
...others 

would return the following warning/error

PHP Deprecated:  Implicit conversion from float 1687.5 to int loses precision in /path/to/php/project/root/vendor/google/gax/src/PollingTrait.php on line 93

This PR contains the following updates:

| Package | Type | Update | Change | |---|---|---|---| | monolog/monolog | require | major | ^2.0 -> ^3.0 |

Release Notes

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

• [ ] If you want to rebase/retry this PR, check this box

This PR has been generated by Mend Renovate. View repository job log here.