Re: [google-appengine] Re: Issue with run-laravel-on-appengine-flexible

Hi Ravi, Did you enable the sqladmin API? The following link will let you do this. https://console.cloud.google.com/flows/enableapi?apiid=sqladmin.googleapis.com On Mon, Dec 25, 2017 at 2:22 PM 'George (Cloud Platform Support)' via Google App Engine wrote: > In App Engine, the local file system

Re: [google-appengine] Re: PHP Flexible Environment: Write access to directory possible?

Hi Jörg, It seems like there is a method call to change the compile dir (and also cache dir). See: https://www.smarty.net/docs/en/api.set.compile.dir.tpl On Fri, Nov 17, 2017 at 1:01 PM 'Jörg Hartgen' via Google App Engine < google-appengine@googlegroups.com> wrote: > Dear Takashi, > > yes, thi

Re: [google-appengine] Re: PHP Flexible Environment: Write access to directory possible?

Hi Jörg, The Flex build pipeline set a stcict permission on everything under document_root. Is it possible to configure smarty to use a directory outside of the document_root (e.g. /tmp, or /app/smarty_cache)? Technically it's possible to introduce a flag for not setting the strict permission at

Re: [google-appengine] Re: Flexible env: post-deploy-cmd from composer.json it not being executed

I said this in another thread, but let me repeat here as well. The new build pipeline for App Engine Flex for PHP, doesn't run `post-deploy-cmd` any more. You may be able to just use `post-install-cmd` as a drop-in replacement, unless you need DB connection. So Søren, unfortunately for your case,

Re: [google-appengine] Re: Why is env_variables not transferred to container on instance

And FYI, I filed an issue on the community articles: https://github.com/GoogleCloudPlatform/community/issues/248 On Thu, Sep 21, 2017 at 12:15 PM Takashi Matsuo wrote: > > Yeah that sounds like a plan to me for now. > > On Thu, Sep 21, 2017 at 12:10 PM Søren Malling > wrote: > >> Hi Takashi, >>

Re: [google-appengine] Re: Why is env_variables not transferred to container on instance

Yeah that sounds like a plan to me for now. On Thu, Sep 21, 2017 at 12:10 PM Søren Malling wrote: > Hi Takashi, > > Thanks for that information - it explains why I haven't been able to make > it work for 2 days :) Could you be so kind to add a note to the PHP > examples, where this is mentioned?

Re: [google-appengine] Re: Why is env_variables not transferred to container on instance

Also, in any case, I don't recommend invoking the db migration during the deployment process, because it's dangerous. What happens if the db migration succeeds, and then the deployment fails? Your app will be in a broken state. So now the recommended way is to use cloud_sql_proxy locally and do th

Re: [google-appengine] Re: Why is env_variables not transferred to container on instance

Are you trying to do DB migration with the post-deploy-cmd? It won't work because we don't run post-deploy-cmd any more, with the new build pipeline. What gcloud version are you using? If you're using the old build pipeline (you can do that by setting a flag `gcloud config set app/use_runtime_bu

Re: [google-appengine] Re: Why is env_variables not transferred to container on instance

Alright, then the container is getting the env vars. Do you have actual problems connecting to the db? On Wed, Sep 20, 2017 at 10:10 PM Søren Malling wrote: > Then I see the environment variables similar to before, including the > MYSQL_* settings > > > PATH=/opt/php/bin:/usr/local/sbin:/usr/loc

[google-appengine] Short Survey: Flex Runtime for PHP

Hi! If you don't care about the Flex Runtime for PHP (env: flex, runtime: php), please stop reading. We have been providing App Engine Flexible Runtime for PHP as Beta for several months now, and we're considering to bring it to GA shortly. Before doing so, we'd like to make sure you are happy ab

Re: [google-appengine] PHP Flex Environment - Copy function fails.

aha nevermind... I am a noob. I found the link. > > On Fri, Jun 23, 2017 at 4:22 PM, Thomas Valadez > wrote: > >> Can you point me to some documentation on this? >> >> On Jun 23, 2017 3:46 PM, "'Takashi Matsuo' via Google App Engine" < >> goo

Re: [google-appengine] PHP Flex Environment - Copy function fails.

The document root (default /app) has stricter permission for security reason. The easiest way is to use /tmp. Maybe you can use sys_get_temp_dir for portability. On Fri, Jun 23, 2017 at 2:35 PM Thomas Valadez wrote: > Here is my code, it r

Re: [google-appengine] mysqli in php flex environment doesn't work.

Hi Thomas, Glad you like the Flex runtime. re: mysqli You can specify the default socket name by having `php.ini` with the following (replace the CONNECTION_NAME with yours): ``` mysqli.default_socket= '/cloudsql/CONNECTION_NAME' ``` Also make sure the `sqladmin` api is enabled. You can confirm

Re: [google-appengine] Re: Laravel deployment using Google App Engine: No such file or directory

+Brent Shaffer Adding the author of the tutorial On Wed, Jun 7, 2017 at 8:29 AM 'George (Cloud Platform Support)' via Google App Engine wrote: > Hello Adeel, > > Your app.yaml file is peculiar in some ways. It might be of value to you > checking the "Run Laravel on Google App Engine Flexible E

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, On Thu, Jun 1, 2017 at 2:46 PM Yao Li wrote: > 1. I tested gcr.io/google-appengine/php71 and PsrBatchLogger works on > production, I will test more to make sure it doesn't influence performance > too much. > Great to hear :) Please feel free to ask how to configure the logger. > > 2.

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, Maybe you can use one of our base image: gcr.io/google-appengine/php71 gcr.io/google-appengine/php70 gcr.io/google-appengine/php56 They have pcntl extension enabled by default. On Thu, Jun 1, 2017 at 11:02 AM Yao Li wrote: > 1. I stop using PsrBatchLogger in framework level logging and

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, Few questions, Is the 499 error happening on App Engine Flex? Can you share the reproducible project (like zip files)? Can you share the logs with me? Hopefully can you invite me to your project as a viewer so that I can check the logs? On Wed, May 31, 2017 at 10:45 PM Yao Li wrote:

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, On Tue, May 30, 2017 at 9:39 PM Yao Li wrote: > > I think you can just use other PSR compliant logger, rather than using > the PsrBatchLogger on your local machine. > > Could you give me some examples for other PSR compliant logger? > Monolog? ``` composer require monolog/monolog ```

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, > make the format pretty The new logging library will automatically add some useful metadata (monitored resources, trace id, severity). They look very nice to me on the logging UI, but what do you mean exactly by making the format pretty? On Tue, May 30, 2017 at 5:29 PM Takashi Matsuo w

Re: [google-appengine] Re: GAE Flex PHP env better logging format

Hi Yao, > Does it make API request (Google Logging, will be slow in production) or just print to stdout/stderr (should be super fast in production)? It's making API requests, but in background in batch if you're using the daemon, so it should be fast. > If it has to make API request, is there any

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, I think you can use dispatch file or `target` in `cron.yaml` . Feel free to let us know if

Re: [google-appengine] Re: GAE Flex PHP env better logging format

We're developing a new logging library, which is under alpha testing phase ( instructoins ). Please try this and let us know how it works for you. Thanks, On Fri, May 26, 2017 at 9:59 AM '

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Sorry sent it too early... Do you have any other place to return 403 in the code path in your cron handler? Your logic seems fine. I suspect that there might be another check for signed in state of the user, and now it gives you 403. On Fri, May 5, 2017 at 11:35 AM Takashi Matsuo wrote: > > Do

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Do you have any other place to return 403 in your cron code path? On Fri, May 5, 2017 at 10:58 AM Yao Li wrote: > You are right, I found the code to check $_SERVER['HTTP_X_APPENGINE_CRON'] > > public function before() { > if ($_SERVER['HTTP_X_APPENGINE_CRON'] != 'true') { > a\Error::

Re: [google-appengine] Process terminated because the request deadline was exceeded. (Error code 123)

I'd suggest you file an issue at: https://issuetracker.google.com/issues/new?component=187251&template=0 I think it's on App Engine Standard. Do you have any operations which can potentially take very long time in your web handler? Is it possible that one of such operations is taking longer than

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, App Engine Flex doesn't support the handler section in app.yaml. I think you're getting 403 because you're also restricting your cron handlers in your code somewhere. Can you do a quick code review on the cron handler, and change it to check the $_SERVER value as I mentioned? Thanks, On

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, I think your handlers are protected only for authorized users, right? https://cloud.google.com/appengine/docs/flexible/nodejs/scheduling-jobs-with-cron-yaml#securing_urls_for_cron On App Engine flex, it changed how to secure your cron handlers. Check $_SERVER['HTTP_X_APPENGINE_CRON'] and

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Cron works for me on my Flex app. Can you show your cron.yaml, and app.yaml? On Thu, May 4, 2017 at 8:03 AM Yao Li wrote: > btw, I did add cron job routing when initializing app in flex env, the > cron routes are defined in app.yaml (handler part) for standard env. > > > On Thursday, M

Re: [google-appengine] Codeigniter session using database not working in Google App Engine Flexible Environment

Hi Dhandapani, Just a quick note, I downloaded CodeIgniter 3.1.4 and the session with the database backed by CloudSQL v2 works. Potential pitfalls are: - You have to enable Cloud SQL API - You have to add beta_

Re: [google-appengine] Codeigniter session using database not working in Google App Engine Flexible Environment

Hi Dhandapani, Are you able to connect to the database in other part of your app? Are there any suspicious logs? On Wed, May 3, 2017 at 7:59 AM Justin Beckwith wrote: > + a few folks > > On Wed, May 3, 2017 at 2:51 AM, Dhandapani Sattanathan < > dhandapani.sattanat...@ssomens.com> wrote: > >> I

Re: [google-appengine] Re: Using Cloud SQL database with Laravel

Hi Adeel, Go to: https://console.cloud.google.com/apis/api/sqladmin.googleapis.com/overview?project=zoho-portal-159018 And see if the` Cloud SQL API` is enabled. Enable it if not. Just to make sure, you're sending the fake password in the previous e-mail, right? If not, I recommend you change it.

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, FYI, we released a new Runtime image which should capture the logs on stderr by default. On Mon, May 1, 2017 at 10:28 AM Yao Li wrote: > 1. I have to install New Relic agent on instance manually with scrip

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, > 1. flex env doesn't support handlers for routing? No Flex doesn't support handlers. Instead you can put a partial config file for nginx. Put a file named nginx-app.conf. The default configuration is as follows: ``` location / { # try to serve files directly, fallback to the front co

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, On Fri, Apr 28, 2017 at 9:10 AM Yao Li wrote: > Hi Takashi, > > I did get New Relic installed successfully, thanks! > Great :) > > The current issue is 404 for API request from mobile app or Postman > software. > > I have the default service (f-s.appspot.com) in standard environment a

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

I often do: ``` apt-get update && apt-get install -y vim less ``` If you're using runtime:custom, maybe you can install them during development phase On Wed, Apr 26, 2017 at 8:28 PM Yao Li wrote: > I want to check the log file in the docker container, but none of vi, vim, > nano works. Do I need

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, According to their docs, I think you need to use this method: PHP agent installation: Non-standard PHP (advanced) Unfortunately we're not using the debian's official ap

[google-appengine] New logging library for PHP

Hi App Engine for PHP users, (If you're not using PHP, please stop reading) App Engine Standard environment has been providing a great user experiences around logging. It supports filtering with severity, request correlation, high performance log ingestion. Unfortunately, some of the nice features

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, According to "Availability: dynamic", it looks to me that you look at the App Engine Standard instance. Make sure you choose the Flex version. The VM runs a container named `gaeapp` for your application. Did you do `docker ps` in the application container? I'm happy to explain this proc

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, You can ssh into the VM; Go to the Cloud Console, and App Engine -> instances -> ssh. Once ssh into it, you can go into the docker container: ``` sudo docker exec -t -i gaeapp /bin/bash ``` Then you can restart everything in the Docker container by: ``` kill -HUP 1 ``` On Tue, Apr 25,

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, I asked a PM who is responsible for it (it turned out it's not Justin). I will reply you off-thread. On Tue, Apr 25, 2017 at 9:25 AM Yao Li wrote: > Hi Takashi, > > Could you ask Justin to send me a test (alpha) version including memcache? > > As the doc, Redis Lab Memcache supports mem

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Yes, you are right. On Tue, Apr 25, 2017, 8:39 AM Yao Li wrote: > Hi Takashi, > > This instruction is only about Logging, doesn't include memcache, right? > > > On Monday, April 24, 2017 at 9:31:54 PM UTC-7, Takashi Matsuo (Google) > wrote: > >> Hi Yao, >> > Alright, I've just sent you

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Alright, I've just sent you the instructions. Thanks! On Mon, Apr 24, 2017 at 9:17 PM Yao Li wrote: > Yes, I'm interested in the alpha version and new log service. > > I tried Redis Lab Memcache, it doesn't support memcache, only memcached? > > > On Monday, April 24, 2017 at 8:45:36 PM

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Adding our PM On Mon, Apr 24, 2017 at 8:29 PM Yao Li wrote: > I'm interested in App Engine Flex PHP alpha version and did fill the > register form but have not received any response. > I think you are referring to the alpha program of the memcache service. If that's the case, Justin knows more

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, > I copied data from a 1st generation cloud sql instance to a 2nd one, data is exactly same but the size is doubled, is it because of the 2nd generation one specific attribute? Sorry I'm not an expert on that topic. Maybe you can try google-cloud-sql-discuss

Re: [google-appengine] Re: App Engine Flex overwriting public folder permissions on deploy

Hi Donatas, We're re-designing the image build process. I think we should provide a way to opt out from the permission locking behavior. I'll let you know when it's available. For a time be-ing, you can use the custom runtime. ```app.yaml env: flex runtime: custom ``` Dockerfile ``` FROM gcr.i

Re: [google-appengine] Re: App Engine Flex overwriting public folder permissions on deploy

Hi Donatas, What's the use case of writing to the public directory? If it is just for writing temporary file (like temporary cache for performance), you can still use other directories (/tmp, /app/otherdir etc). If you want to dynamically update the content in the public directory, unfortunately i

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, *1. CloudSQL* Yes, we recommend that you use the unix socket. If you're using mysql_connect, you may be able to use 'localhost:/cloudsql/CONNECTION_NAME' as the host name. ```php.ini extension=mysql.so sql.safe_mode=false ``` Then: $db = mysql_connect('localhost:/cloudsql/CONNECTION_NAM

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, On Fri, Apr 21, 2017 at 11:29 PM Yao Li wrote: > > 1. I use Second Generation Instance for Cloud SQL in flex environment, did > enable 'sqladmin' on my project. > > The cloud sql instance log shows: > 10:12:52.4252017-04-21T17:12:52.425362Z 7115 [Note] Aborted connection 7115 > to db:

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Sorry! I was wrong. The constants STDERR is only available for CLI SAPI. Also, the current php-fpm.conf just throws the logs on STDERR away (my fault). We will fix this early next week, but for a time being, you can put a file named php-fpm.conf in the project root with the following: ``

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, > 1 Cloud SQL Connection. I set cloud_sql_instances connection name but it doesn't work. I tried use its actual IP or 'localhost' as host name, neither of them work. Do you use Cloud SQL first generation? If so, unfortunately it's not supported on App Engine Flex. Here is the document fo

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, On Thu, Apr 20, 2017 at 2:41 PM Yao Li wrote: > It works like a charm after add memcache extension, thanks! > Glad to hear! > > In the very beginning, I deployed a default service in standard > environment (my-company.appspot.com) and then a monitor service in flex > environment now (

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

The `Memcache` class comes with `memcache` extension. To enable `memcache` extension on App Engine flex, you can add a dependency in your `composer.json`. ``` $ composer require 'ext-memcache:*' ``` Then our runtime will automatically enable the memcache extension for you. The memcache service fo

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, So adding to my previous e-mail, the `opcache` zend extension is also an extension for opcode caching. XCache used to be a viable option for opcode caching, but it is not very actively maintained. I recommend that you try using opcache, and see if there's enough performance gain. Speaki

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Thanks for the report. My understanding is XCache is for opcode caching, and the last release is 20140918. We're using the standard `opcache` zend extension, and it has been working pretty well for us. The runtime already has the extension, so only you need is to put php.ini with the foll

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Thanks! That makes sense. I will make the change soon and let you know when it's done! On Wed, Apr 19, 2017 at 10:10 AM Yao Li wrote: > I add flag -m to preserve environment variable (composer_auth which has > gitlab token to composer install private repos) in composer.sh line 81: > > https://gi

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, On Wed, Apr 19, 2017 at 8:48 AM Yao Li wrote: > I found an error in the log, it complains "FastCGI sent in stderr: "PHP > message: ALERT-SIMULATION - Unable to open logfile: /dev/stderr". > > I did create a docker image for my business requirement (use own PHP > framework on nginx) based

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, Also feel free to send the app to me if possible so that I can try to reproduce. I'm happy to debug it. Thanks, On Tue, Apr 18, 2017 at 6:32 PM Takashi Matsuo wrote: > > Hi Yao, > > If you put the index.php in the project root folder, you don't have to add > the document_root. > > Here

Re: [google-appengine] App Engine Flex Environment PHP Runtime document root not found

Hi Yao, If you put the index.php in the project root folder, you don't have to add the document_root. Here is the minimum app: ``` $ tree . ├── app.yaml └── index.php 0 directories, 2 files tmatsuo@t-glaptop:~/work/simplestapp$ cat index.php https://my-service-dot-my-app.appspot.com/ If it ret

Re: [google-appengine] App Engine Flexible Runtime PHP (5.6) deployed failure: Failed to execute git clone --no-checkout 'gitAtgitlab.com:xxxx/framework-php.git'

Hi Yao, We're thinking to introduce an option to skip running `composer install` for a short term solution, which I think we can provide in weeks. An ideal solution (potentially with KMS) will definitely take longer. Thanks, On Mon, Apr 17, 2017 at 11:48 AM Yao Li wrote: > Hi Takashi, > > If i

Re: [google-appengine] App Engine Flexible Runtime PHP (5.6) deployed failure: Failed to execute git clone --no-checkout 'gitAtgitlab.com:xxxx/framework-php.git'

Hi Yao, Sorry for the trouble. Unfortunately currently the private repos are not supported with the Flexible Environment. We're working on a solution, and we'll keep you updated. Thanks! On Mon, Apr 17, 2017 at 11:25 AM Justin Beckwith wrote: > Apologies for the trouble. Adding a few folks fr

[google-appengine] [ANN] gcp-php-users Google Group created

Hi folks, We created a google group `gcp-php-users` specifically for PHP developers on Google Cloud. If you're PHP a developer, please consider joining the group at: https://groups.google.com/forum/#!forum/gcp-php-users We want to hear from you! Thanks -- -- Takashi -- You received this messa