[google-appengine] Re: Migrating App Engine php5 with google libraries

[Jukka Hautakorpi]

Thanks

Those did help a little and got my test project forward.
Google documentation about this is really painful to read..
For example
"Access legacy bundled services for PHP 7+"
What does lecacy bundled service mean ?? 

I know i didn't need composer any libraries for example to make the mail 
work, but with php 7.4 it requires this installed via composer.
Yet if I add 
/vendor/
into .gcloudignore 
the library functions still works...


perjantai 12. elokuuta 2022 klo 1.08.35 UTC+3 Osvaldo Lopez Acuña kirjoitti:

> You can start by taking a look at this guide 
>  
> (if you haven't already done it) about Migrating from PHP5.5 to 7.2. In this 
> GCP document 
>  
> you will learn about subjects related to migrating an app to PHP7+ in the 
> App Engine standard environment. And finally, in this other document 
> 
>  
> you will find information about migrating and Apps using legacy bundled 
> services.
>
> On Thursday, August 11, 2022 at 9:59:03 AM UTC-5 jukka.ha...@gmail.com 
> wrote:
>
>> 
>>
>> I have php app with few hundred users made with php5. It is using some 
>> google libraries, but Actually I don't have them or composer in my local 
>> linux development project, yet they still work. Somehow google environment 
>> has those as default:
>>   require_once 'google/appengine/api/mail/Message.php';
>>   use \google\appengine\api\mail\Message; 
>>
>> Now I also need to add use Google\Cloud\Storage\StorageClient and also 
>> would like to migrate my app to standard php7 evironment with app.py
>>
>>1. Do i need the composer libraries the php7 version when running in 
>>google's servers ?
>>2. Can I upload a second version of my php5 app to run in php7 for 
>>testing before making it promoted version ?
>>
>>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/a79bf0ec-6009-4b47-b15a-14827bcfc3edn%40googlegroups.com.

[google-appengine] Migrating App Engine php5 with google libraries

[Jukka Hautakorpi]

 

I have php app with few hundred users made with php5. It is using some 
google libraries, but Actually I don't have them or composer in my local 
linux development project, yet they still work. Somehow google environment 
has those as default:
  require_once 'google/appengine/api/mail/Message.php';
  use \google\appengine\api\mail\Message; 

Now I also need to add use Google\Cloud\Storage\StorageClient and also 
would like to migrate my app to standard php7 evironment with app.py

   1. Do i need the composer libraries the php7 version when running in 
   google's servers ?
   2. Can I upload a second version of my php5 app to run in php7 for 
   testing before making it promoted version ?

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/b13c3266-ab30-4966-88cb-31d0116c942dn%40googlegroups.com.

[google-appengine] Google App Engine Mailjet gives 500 error

[Jukka Hautakorpi]

When trying to use mailjet with php 7 Google App engine, 
the request to that file gives 500-error and I cannot see any details of 
the error anywhere in developer console!

- runtime: php72
-mailjet/mailjet-apiv3-php": "^1.5"
-This file works 100% on my own server.

- I have narrowed the cause of error to the line
$mj = new \Mailjet\Client(MAILJET_API_KEY, MAILJET_SECRET_KEY, 
true,['version' => 'v3.1']);
but it's from the docs and nothing weird about it, and these api keys of 
course also works.

Put perhaps the path or something is different in my gae than in my apache ?
the row that i have is use \Mailjet\Resources; and it's working in my own 
server ok.


Do I need some custom php.ini settings to make this work ? 

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/46ab4ff2-6765-4481-85ac-08a3984c9040n%40googlegroups.com.

[google-appengine] Re: quotas

[Jukka Hautakorpi]

some features require you to enable billing. if not enabled you get quota  
warning even if it's under free tier.

maanantai 24. elokuuta 2020 klo 14.33.44 UTC+3 Denis T (Google Cloud 
Platform Support) kirjoitti:

> Hello,
>
> The “quotaExceeded” errors are showing that a certain quota is being 
> reached. Based on the error message you provided I’m not quite sure which 
> GAE quota  is affected in 
> particular. However, you can double-check that on the App Engine quotas 
>  page.
> If you don’t see any limit is being reached, please contact the Google 
> Cloud Platform technical support  team 
> for a more detailed project inspection.
>
> On Sunday, August 23, 2020 at 6:30:50 PM UTC+2 ma...@gmsolustion.online 
> wrote:
>
>>
>> I am very far from the limit  quota
>>
>> ihave this limite only when i sync google group members 
>>
>> On Friday, August 21, 2020 at 10:22:22 PM UTC+2 wus...@google.com wrote:
>>
>>> please check that service quota limit.
>>>
>>> On Friday, August 21, 2020 at 4:50:30 AM UTC-4 ma...@gmsolustion.online 
>>> wrote:
>>>
 have you any info for this error please

 temporary error: quotaExceeded backing off: 60 seconds, retry: 7/10

>>>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/b860dfc4-b91a-4c65-9a71-6763f85fb7f5n%40googlegroups.com.

[google-appengine] Re: Spending LImits Going Away :(

[Jukka Hautakorpi]

Is there a simple example how to disable after budget alert, let's say php 
google app engine application ?

keskiviikko 2. syyskuuta 2020 klo 22.19.57 UTC+3 Alexis (Google Cloud 
Platform Support) kirjoitti:

>
> Hello everyone,
>
> To summarize this conversation, it is possible to set proactive limits by:
> - Maximum number of instance[1] in an app
> - Disable your app programmatically[2] for any resource consumption, etc..
> - Cap API limits to prevent too many requests[3]
>
> If I understood properly, Joshua's situation is about caching. So in that 
> case, we are talking about resource limits related to CPU cycles, or maybe 
> amount of requests... I suspect that whatever resource spiked by this 
> situation, can probably make use of the second option above or even the 
> third if it's API consumption. But it all depends on how fast this happened 
> and I would agree that having a hard cap feature would prevent the delay.
>
> In terms of instantaneous hard caps (with no delays), a feature request[4] 
> can be done. However, I think it would be advantageous to clarify how such 
> a cap can be helpful without impacting scalability. Please see below.
>
> When submitting a feature request:
> - Try to clarify how the limit should differentiate a CPU cycle that is 
> legit and versus one that isn't legit. Would you want that on all your 
> instances? Would you mind if it stopped all your services as a false alarm? 
> (The current solution for that is max instances in my first point above 
> because scaling is a horizontal concept and it doesn't completely stop 
> things since it's a delta quantity. If some of the other issues mentioned 
> were due to excessive instances or API requests ,  then please refer to the 
> above).
>
> I hope this message consolidates the research and saves time for any new 
> person reading this post. Thank you in advance.
>
> [1] 
> https://cloud.google.com/appengine/docs/managing-costs#specify_the_maximum_number_of_instances
> [2] 
> https://cloud.google.com/appengine/docs/managing-costs#disable_your_app_programmatically
> [3] https://cloud.google.com/apis/docs/capping-api-usage
> [4] 
> https://cloud.google.com/support/docs/issue-trackers?hl=id#trackers-list
>
> On Wednesday, September 2, 2020 at 11:18:59 AM UTC-4 vit@gmail.com 
> wrote:
>
>> Canceling a simple and straightforward option "daily spending limit" is a 
>> very cruel action for beginners just starting to learn the platform. A 
>> separate warning should be given in the starter guide:
>>
>> In order not to go bankrupt when using GCP, you first need to carefully 
>> study the documentation section https://cloud.google.com/cost-management.
>>
>> My story.
>>
>> Ndb model with a lot of indexed fields (since the field property indexed 
>> = True by default). The cost of writing one entry to such a model was very 
>> high.
>>
>> The main program sent a message to the queue when a fairly rare event 
>> occurred. The handler of such a message from the queue updated the 
>> corresponding record in the model, and then an exception occurred due to an 
>> error in the code, and the handler exited with an error code.
>>
>> The platform initiated several processing retries, which also failed. In 
>> each attempt, there was a write to the model.
>>
>> The main program, not finding the results of processing, added a new 
>> message to the queue, which caused a new series of attempts described 
>> above. And so on.
>>
>> The daily budget was depleted within a few minutes and the program was 
>> stopped by a fuse "daily spending limit".
>>
>> In the current reality, I would have received a bill for several thousand 
>> dollars if I had reacted to this situation within 24 hours.
>>
>> Yes, then I changed the model, leaving indexed=True only for a couple of 
>> fields where it was really necessary and changed the logic of both the main 
>> program and the message handler from the queue.
>>
>> But all this happened later.
>>
>> вторник, 25 августа 2020 г. в 20:03:33 UTC+4, Joshua Smith: 
>>
>>> Once again last night, my wallet was saved when a runaway bot chewed up 
>>> my site’s whole daily spending limit. I got an email from a user, set up a 
>>> firewall rule, and goosed my budget to get things going again.
>>>
>>> I’m *very* concerned about Google’s decision to remove this feature. 
>>> Offering a cloud service that bills by usage without having a way to limit 
>>> the spend shifts an unreasonable amount of risk onto the subscriber.
>>>
>>> I’ve set up budget alerts, as suggested, but I’m concerned that:
>>>
>>> - What if my bill shoots up really fast? How quickly is this alert going 
>>> to go out?
>>>
>>> - What if I am away from the computer (remember when we used to be able 
>>> to leave our houses? good times… good times…)?
>>>
>>> I run this particular site as a not-for-profit social good. (It’s a site 
>>> that small town governments use to post their meetings.) I make *no* money 
>>> on it.
>>>
>>> I’d be perfectly happ

[google-appengine] Question about billing, please share your experience

[Jukka Hautakorpi]

Hello!

I'm so worried now

I have few cloud projects, just Google App Engines, under the free tier.
Then I have one Cloud Sql instance that costs around 9 USD per month. No 
startup-discount-codes.

I can see from the graphs that it' 0,31 usd or closte to it per day

BUT all the graphs show that monthly total "Actual costs" are close to 120 
USD!


What is that ?

If I have to pay 120 usd from these small apps, i will stop using gae 
imediately and just buy regular web-server for 20usd / month

https://pasteimg.com/image/image.29q0

So please tell me what is that

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/e694efda-4148-4562-b3e4-d5f64f704ff0n%40googlegroups.com.

[google-appengine] Re: PHP app engine cannot connect to cloud sql

[Jukka Hautakorpi]

With php 5.6 application sql-connection was working fine with mysqli 
procedural.
But not with FLEX

Turns out that you need:

php.ini with
mysqli.default_socket="/cloudsql/xprojectname:europe-west1:yyysqlinstancename"

And in app.yaml, maybe not both..
env_variables:
  CLOUDSQL_CONNECTION_NAME: 
"xprojectname:europe-west1:yyysqlinstancename"

beta_settings:
  cloud_sql_instances: "xprojectname:europe-west1:yyysqlinstancename"

And also when connecting, cannot leave server address empty anymore, but 
put localhost
$db_host  =  'localhost';
$db_user  =  "root"; // mySQL database user
$db_password  =  ""; // mySQL database password 
$db_name  =  "nn"; // the name of your mySQL database
$db_socket  =  
"/cloudsql/xprojectname:europe-west1:yyysqlinstancename"; //no : in 
starting of this string!
$db_port = null;
$mysqli = new mysqli($db_host, $db_user, $db_password, $db_name, $db_port, 
$db_socket);


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/d3416995-4a3e-4ad1-b13a-ba6dc6c2f686%40googlegroups.com.

[google-appengine] google app engine and big file generating

[Jukka Hautakorpi]

I have a gae php+sql -app
that I want to extend to generate big set of files. Php script will make 
these files from few 2 mb templates.

These files will be 100-500 mb total, and then zip them and push / return 
to user's browser, same way as google drive "zip files" seems to work, so i 
can assume that
1.  To generate such big set of files, it can't just be in the gae's ram, 
so we can save the files to Cloud Storage. I see that I can also zip files 
in cloud storage and then return this, so should not be a problem

2.  If there are 20 users generating files at the same time, we need a 
simple queue so that backend is processing some kind of job queue
what is the technique of making such a job queues and then run them with 
fifo-principle ?

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/05fb7cf3-f6cf-4d17-b46f-53581ad49e91%40googlegroups.com.

[google-appengine] app.yaml mismatch in documentation with php7.3

[Jukka Hautakorpi]

I'm changing GAE app from php55 to php73

And the problem is this:

#php55:
- url: /api1/.*
  script: mod_rewrite.php
  secure: always

When my api path gets queries, everything need to go to one php-script 
mod_rewrite.php
this was in google's own docs:
https://cloud.google.com/appengine/docs/standard/php/config/mod_rewrite

But now when I want php73:
#php73:
- url: /api1/.*
  script: auto
  secure: always

it does not let me put anything else than auto in there anymore
"ERROR: (gcloud.app.deploy) INVALID_ARGUMENT: script field for handler 
'/api1/.*' must be set to 'auto' for runtime php73."


And in the documentation 
https://cloud.google.com/appengine/docs/standard/php7/runtime
does not give working example how to accomplish this.

It does say about entrypoint, but that's not enough because I need to have 
2 "entrypoints"

/api1/.*
and norman index.php in the root,
NOT JUST ONE!

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/cf65663a-8f91-4dde-a4f2-c46b66242d58%40googlegroups.com.

Re: [google-appengine] Gae project defining more simple way

[Jukka Hautakorpi]

Thanks! This will help me not to make mistakes!



maanantai 2. heinäkuuta 2018 18.31.52 UTC+3 Steren Giannini kirjoitti:
>
> Hi,
>
> When deploying, we recommend to always create a new version instead of 
> overriding an existing one. This is achieved by not passing the --version 
> flag when running gcloud app deploy.
>
> When doing so, you can then safely rollback to the previously serving 
> version if something goes wrong with the new one.
>
> Regarding gcloud, we are evaluating better solutions to give the project 
> context. In the meantime, you can use the --project flag to endure you are 
> deploying to the right project.
>
> Steren
> Product Manager
> Google Cloud Platform
>
> On Mon, Jul 2, 2018, 07:42 Jukka Hautakorpi  > wrote:
>
>> Hello
>>
>> I have few project that i update every now and then. Php and GAE.
>> Used to use the old cmd tools (appcfg.py) but had to update to gcloud
>>
>> I made a mistake and run command 
>>
>> gcloud app deploy project222/app.yaml --version=1 --promote
>>
>> without reading closely enough and it updated this project over another 
>> one! huuuge mistake
>>
>> How can i make it more simple when dealing with multiple projects 
>> withouth always having to first set project with 
>> gcloud config set project projectname 
>>
>> ?
>>
>> Thanks
>>
>>
>> -- 
>> 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 google-appengi...@googlegroups.com .
>> To post to this group, send email to google-a...@googlegroups.com 
>> .
>> 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/26689fe5-ed15-434e-8513-69449948286d%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/google-appengine/26689fe5-ed15-434e-8513-69449948286d%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/d871be98-a307-4ebc-877b-a99fff456cab%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Gae project defining more simple way

[Jukka Hautakorpi]

Hello

I have few project that i update every now and then. Php and GAE.
Used to use the old cmd tools (appcfg.py) but had to update to gcloud

I made a mistake and run command 

gcloud app deploy project222/app.yaml --version=1 --promote

without reading closely enough and it updated this project over another 
one! huuuge mistake

How can i make it more simple when dealing with multiple projects withouth 
always having to first set project with 
gcloud config set project projectname 

?

Thanks


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/26689fe5-ed15-434e-8513-69449948286d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: GAE node.js and websockets

[Jukka Hautakorpi]

Thank you for clarification. That's a shame. Hope it will come later!

-Jukka


maanantai 27. marraskuuta 2017 0.15.01 UTC+2 Kamran (Google Cloud Support) 
kirjoitti:
>
>
> Hello Jukka,
>
> An answer to a similar question has been posted on this stackoverflow 
> thread 
> <https://stackoverflow.com/questions/38937401/socket-io-in-node-app-on-google-app-engine?answertab=votes#tab-top>.
>  
> The github link was removed because it was not production ready.
>
> Sincerely,
>
>
> On Sunday, November 26, 2017 at 4:25:56 PM UTC-5, Jukka Hautakorpi wrote:
>>
>> I would like to make a websocket (server) app that my iot-device will 
>> connect
>>
>> I saw that there was an example of this in the url 
>> https://medium.com/google-cloud/a-node-js-websocket-server-on-google-app-engine-c6c32a486e9a
>>
>> but the google's github repo of these files has been deleted. (
>> https://github.com/GoogleCloudPlatform/nodejs-docs-samples/tree/master/appengine/websockets
>>  
>> )
>>
>> I tried simple websockets chat application and it works on localhost but 
>> not when deployed to the gae. Even if i opened the firewall rule as in the 
>> instructions.
>>
>> Is this kind of scenario supported with gae ? why it was removed from the 
>> repo?
>>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/26d69930-a983-4ed9-9d6a-54bcfecc8673%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] GAE node.js and websockets

[Jukka Hautakorpi]

I would like to make a websocket (server) app that my iot-device will 
connect

I saw that there was an example of this in the url 
https://medium.com/google-cloud/a-node-js-websocket-server-on-google-app-engine-c6c32a486e9a

but the google's github repo of these files has been deleted. 
(https://github.com/GoogleCloudPlatform/nodejs-docs-samples/tree/master/appengine/websockets
 
)

I tried simple websockets chat application and it works on localhost but 
not when deployed to the gae. Even if i opened the firewall rule as in the 
instructions.

Is this kind of scenario supported with gae ? why it was removed from the 
repo?

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/91d92fad-b0a8-45b1-bc14-d590a6df3e13%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: gae php mail quota too low, error?

[Jukka Hautakorpi]

Please Google check this problem out! It must be a bug in the quota limits! 

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/bfbffa76-d61b-4209-9019-06534b7d480d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: gae php mail quota too low, error?

[Jukka Hautakorpi]

I've seen these limits and they cannot be the reason.
There must be some other bug in the limiting system of sending the mail.
I also got this error by sending manually 4 feedbacks with this form:
tuunixajopaivakirja.appspot.com/index.php?sivu=palaute
(https removed from link)
so there was NO documented limit=quota that could have been exeeded!

what's going on??



torstai 5. lokakuuta 2017 18.43.03 UTC+3 Yannick (Cloud Platform Support) 
kirjoitti:
>
> Hello Jukka, in addition to the quotas, you should also make sure you are 
> not running into one of the following limits: 
> https://cloud.google.com/appengine/docs/standard/python/mail/#quotas_and_limits
>
> Another important question is, what happened once you tried to resend that 
> message? Does it fail again? Can you send other messages?
>
> On Thursday, October 5, 2017 at 6:05:05 AM UTC-4, Jukka Hautakorpi wrote:
>>
>> And just checked that billing is enabled.
>> I cannot find mail - limit from the quotas set-page?!
>>
>> And here are today's quotas:
>>
>> Mail
>> If you need a higher mail quota, you can use SendGrid to send email. 
>> Learn more 
>> Resource Usage today Daily quota Per-minute quota Rate limit status 
>> Mail API Calls 
>> 6 of 1 771 789
>> 0 % 
>> -- of 4 928
>> Standard rate
>> Recipients Emailed 
>> 6 of 100
>> 6 % -- 
>> Standard rate
>> Message Body Data Sent 
>> 0,04 of 29,5764 GB
>> 0 % 
>> -- of 0,08 GB
>> Standard rate
>>
>>
>>
>> torstai 5. lokakuuta 2017 12.50.46 UTC+3 Jukka Hautakorpi kirjoitti:
>>>
>>>
>>> I have gae php app that has different php files to send me emails and 
>>> also some notifications for customers
>>>
>>> i have received sometimes errors about the quotas and after testing it, 
>>> it seems that i can only send 1 - 14 emails / day.
>>>
>>> Yesterday i received error once more and it was from the php feedback 
>>> form that sends only 1 mail to me.
>>> So the limit cannot be "too many emails / second or hour" because there 
>>> was only 1 mail to be sent to me.
>>>
>>> How can the quota limit be so vary and give errors so easily ? i only 
>>> send 0-20 emails per day.
>>>
>>> google\appengine\runtime\OverQuotaError
>>>> The API call mail.Send() required more quota than is available.
>>>> google\appengine\runtime\ApiProxy::makeSyncCall
>>>> Request
>>>> POST xxx.appspot.com/index.php?sivu=palaute
>>>> Status
>>>> 500
>>>> User agent
>>>> Mozilla/5.0
>>>>  (Linux; Android 7.0; SM-G930F Build/NRD90M; wv) AppleWebKit/537.36 
>>>> (KHTML, like Gecko) Version/4.0 Chrome/61.0.3163.98 Mobile Safari/
>>>> 537.36
>>>> Service
>>>> default
>>>> Version
>>>> 1
>>>>
>>>>
>>> And to be sure you understand, for this 20 max email / day, i won't be 
>>> changing the code to use the external api, i want to use the old 
>>> mail-function !
>>>
>>>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/48f2a99b-bfb7-4df7-bc99-6e6a3be8f16d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: gae php mail quota too low, error?

[Jukka Hautakorpi]

And just checked that billing is enabled.
I cannot find mail - limit from the quotas set-page?!

And here are today's quotas:

Mail
If you need a higher mail quota, you can use SendGrid to send email. Learn 
more 
Resource Usage today Daily quota Per-minute quota Rate limit status 
Mail API Calls 
6 of 1 771 789
0 % 
-- of 4 928
Standard rate
Recipients Emailed 
6 of 100
6 % -- 
Standard rate
Message Body Data Sent 
0,04 of 29,5764 GB
0 % 
-- of 0,08 GB
Standard rate



torstai 5. lokakuuta 2017 12.50.46 UTC+3 Jukka Hautakorpi kirjoitti:
>
>
> I have gae php app that has different php files to send me emails and also 
> some notifications for customers
>
> i have received sometimes errors about the quotas and after testing it, it 
> seems that i can only send 1 - 14 emails / day.
>
> Yesterday i received error once more and it was from the php feedback form 
> that sends only 1 mail to me.
> So the limit cannot be "too many emails / second or hour" because there 
> was only 1 mail to be sent to me.
>
> How can the quota limit be so vary and give errors so easily ? i only send 
> 0-20 emails per day.
>
> google\appengine\runtime\OverQuotaError
>> The API call mail.Send() required more quota than is available.
>> google\appengine\runtime\ApiProxy::makeSyncCall
>> Request
>> POST xxx.appspot.com/index.php?sivu=palaute
>> Status
>> 500
>> User agent
>> Mozilla/5.0
>>  (Linux; Android 7.0; SM-G930F Build/NRD90M; wv) AppleWebKit/537.36 
>> (KHTML, like Gecko) Version/4.0 Chrome/61.0.3163.98 Mobile Safari/537.36
>> Service
>> default
>> Version
>> 1
>>
>>
> And to be sure you understand, for this 20 max email / day, i won't be 
> changing the code to use the external api, i want to use the old 
> mail-function !
>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/2bda049a-7c98-4e72-bd7e-470e397387ff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] gae php mail quota too low, error?

[Jukka Hautakorpi]

I have gae php app that has different php files to send me emails and also 
some notifications for customers

i have received sometimes errors about the quotas and after testing it, it 
seems that i can only send 1 - 14 emails / day.

Yesterday i received error once more and it was from the php feedback form 
that sends only 1 mail to me.
So the limit cannot be "too many emails / second or hour" because there was 
only 1 mail to be sent to me.

How can the quota limit be so vary and give errors so easily ? i only send 
0-20 emails per day.

google\appengine\runtime\OverQuotaError
> The API call mail.Send() required more quota than is available.
> google\appengine\runtime\ApiProxy::makeSyncCall
> Request
> POST xxx.appspot.com/index.php?sivu=palaute
> Status
> 500
> User agent
> Mozilla/5.0
>  (Linux; Android 7.0; SM-G930F Build/NRD90M; wv) AppleWebKit/537.36 
> (KHTML, like Gecko) Version/4.0 Chrome/61.0.3163.98 Mobile Safari/537.36
> Service
> default
> Version
> 1
>
>
And to be sure you understand, for this 20 max email / day, i won't be 
changing the code to use the external api, i want to use the old 
mail-function !

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/c638e156-5385-4d89-a896-415364565d34%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: GAE php mail function question

[Jukka Hautakorpi]

>
> Ok, thanks
>

I also noticed a weird bug in my code, the $headers - variable is not even 
used in the GAE message sending
i tought that it was in use and tried to alter it.

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/2347544e-4592-45a3-a1fc-28ddca8cc7ed%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: GAE php mail function question

[Jukka Hautakorpi]

>
> Problem PARTLY resolved by changing $message->setTextBody($body); to 
> $message->setHtmlBody($body) 
> bu 
>
But this does not explain the weirdness that all the other files & 
functions that work exactly like that  in the example does work beautiful 
html messages even tough there is no setHtmlBody 
and i still need question does the mail() function work or did i 
misunderstood..

part of sourcecode of setTextBody -message that is still html:

X-Google-Appengine-App-Id: e~x
X-Google-Appengine-App-Id-Alias: xxx
X-Backend-Scan: 1

Message-ID: 
Subject: =?UTF-8?Q?Tuunix_Ajop=C3=A4iv=C3=A4kirja=2C_uusi_salasana_=2D_2017=
2D07=2D18_4?=
=?UTF-8?Q?650?=
From: tuu...@tuunix.fi
To: ju...@tuunix.fi
Content-Type: multipart/alternative; boundary="f403045ec682cb1688055491aba9"
X-Spam-Status: No, score=-1.9 required=15.0 tests=BAYES_00,
HEADER_FROM_DIFFERENT_DOMAINS,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,
RCVD_IN_MSPIKE_H3,RCVD_IN_MSPIKE_WL,RP_MATCHES_RCVD,SPF_PASS,
URIBL_BLOCKED
autolearn=ham autolearn_force=no version=3.4.0
X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on mailgw1.xx.fi
X-Virus-Scanned: clamav-milter 0.99.2 at mailgw1.xx.fi
X-Virus-Status: Clean

--f403045ec682cb1688055491aba9
Content-Type: text/plain; charset="UTF-8"; format=flowed; delsp=yes
Content-Transfer-Encoding: base64

VGVydmV0dWxvYSBrw6R5dHTDpG3DpMOkbiBUdXVuaXggYWpvcMOkaXbDpGtpcmphYSENClNpbnVs
bGUgb24gbHVvdHUgdXVzaSBzYWxhc2FuYS4NClZvaXQga2lyamF1dHVhIG9zb2l0dGVlc3NhIGh0
dHA6Ly90dXVuaXhham9wYWl2YWtpcmphLmFwcHNwb3QuY29tIEF2YWEgIA0KQWpvcMOkaXbDpGtp
cmphIHTDpHN0w6QNCg0KU2FsYXNhbmFzaSBvbiBzaXJlZW5pNjc1DQoNCg0KTWlrw6RsaSBldCBv
bGUga3V1bGx1dGthYW4gbW9pc2VzdGEgcGFsdmVsdXN0YSBqYSBlcMOkaWxldCBldHTDpCB2aWVz
dGkgdHVsaSAgDQp2w6TDpHLDpMOkbiBvc29pdHRlZXNlZW4sIHbDpGxpdMOkIHTDpG3DpCB2aWVz
dGkgb3NvaXR0ZWVzZWVuIHR1dW5peEB0dXVuaXguZmksICANCktpaXRvcyENCg==
--f403045ec682cb1688055491aba9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Tervetuloa k=C3=A4ytt=C3=A4m=C3=A4=C3=A4n Tuunix ajop=C3=A4iv=C3=A4kirjaa!<=
br />
Sinulle on luotu uusi salasana.Voit kirjautua osoitteessa http://tuun=
ixajopaivakirja.appspot.com  http://tuunixajopaivakirja.appspot.=
com/">Avaa Ajop=C3=A4iv=C3=A4kirja t=C3=A4st=C3=A4Salasanas=
i on xxx
Mik=C3=A4li et ole kuullutkaan moisesta 
palvelusta ja ep=C3=A4i=
let ett=C3=A4 viesti tuli v=C3=A4=C3=A4r=C3=A4=C3=A4n osoitteeseen, v=C3=A4=
lit=C3=A4 t=C3=A4m=C3=A4 viesti osoitteeseen tuu...@tuunix.fi, Kiitos!<=
br />
--f403045ec682cb1688055491aba9--



-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/5e443bdc-bf9a-4461-9b0a-ef0e7cf03164%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] GAE php mail function question

[Jukka Hautakorpi]

I have weird problem with my gae php application

i checked the code and noticed that one of the email-sending pages was 
using php mail and not googles's new Message() - method.
But it did work somehow, i can't understand why because i read the docs 
year or 2 ago that mail -function is not in use.
Now i changed it to new Message() -method but the email gets parsed as text 
and my html tags are visible in the thunderbird when i receive the mail.
Also i did not find anymore the new Message() documentation from google's 
site

1. is mail() now actually supported ?
2. how do i get html mail

runtime: php55

this is the code that makes tags visible:

require_once 'google/appengine/api/mail/Message.php';
use \google\appengine\api\mail\Message;

$daterand=date("Y-m-d").' '.rand(1000,);
$subject = "New mail - $daterand";

$eol="\n";
$Momentn = mktime().".".md5(rand(1000,));
$Servername = ereg_replace("www.","",$_SERVER["SERVER_NAME"]);
if(strlen($Servername)<2)$Servername = "PHPMAILSERVER";

$headers= 'To: '.$email;
$headers.=$eol;
$body = "welcome to the app!";
$body.="\r\nLinks and stuff, thanks!";


//$headers= 'To: '.$my_email; //not allowed 2013

$headers  .= 'From: '.$sender_email.$eol; //ei itseä ! google ei tykkää
//GAE DOES NOT ACCEPT: $headers  .= "Message-ID: 
<".$Momentn."@".$Servername.">".$eol;
//GAE DOES NOT ACCEPT: $headers  .= 'Date: '.date("r").$eol;
$headers .= "Content-Type: text/html; charset=UTF-8".$eol;
//GAE DOES NOT ACCEPT:$headers .= "MIME-Version: 1.0\n";
//GAE DOES NOT ACCEPT:$headers .= "Content-transfer-encoding: 7bit\n";
//$mailresult=mail('', $subject, $body, $headers);

if($appengine) {
//use \google\appengine\api\mail\Message;

$body = ''.$body.'';
try
{
  $message = new Message();
  $message->setSender($sender_email);
  $message->addTo($email);
  $message->setSubject($subject);
  $message->setTextBody($body);
  $message->send();
  $mailresult=true;
} catch (InvalidArgumentException $e) {
  $mailresult=false;
}


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/6eb870c2-215e-4f40-a702-2c8124f1ce01%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: GAE php 500 error on split / list

[Jukka Hautakorpi]

Workaround code:
$tmpvar = explode('@', $email);
$username=$tmpvar[0];
$domain=$tmpvar[1];

This did not cause any problems on my local apache server, didn't try the 
local gae-server.


maanantai 10. heinäkuuta 2017 13.38.15 UTC+3 Jukka Hautakorpi kirjoitti:
>
>
> Suddenly my app started to get 500 error with no reasonable reason, from 
> logs just
>  logMessage:  "This request caused a new process to be started for your 
> application, and thus caused your application code to be loaded for the 
> first time. This request may thus take longer and use more CPU than a 
> typical request for your application."  
> logMessage:  "While handling this request, the process that handled this 
> request was found to be using too much memory and was terminated. This is 
> likely to cause a new process to be used for the next request to your 
> application. If you see this message frequently, you may have a memory leak 
> in your application."  
>
> I edited the php code of the page and it was this line:
> list($username,$domain)=split('@',$email);
>
> my apps runtime is php55
>
> Why is this all of a sudden (started 3.7.2017) ?
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/7454fd6b-6ad2-444e-b4f5-dcae7614c6b2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] GAE php 500 error on split / list

[Jukka Hautakorpi]

Suddenly my app started to get 500 error with no reasonable reason, from 
logs just
 logMessage:  "This request caused a new process to be started for your 
application, and thus caused your application code to be loaded for the 
first time. This request may thus take longer and use more CPU than a 
typical request for your application."  
logMessage:  "While handling this request, the process that handled this 
request was found to be using too much memory and was terminated. This is 
likely to cause a new process to be used for the next request to your 
application. If you see this message frequently, you may have a memory leak 
in your application."  

I edited the php code of the page and it was this line:
list($username,$domain)=split('@',$email);

my apps runtime is php55

Why is this all of a sudden (started 3.7.2017) ?

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/0a3f2337-83a3-46c5-8f10-0eb5fc084ced%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Gae + cloud sql 2 beta, how to move ?

[Jukka Hautakorpi]

I have php +cloud sql app and i would like to move the database / instance 
to the new beta.
How can i export and import the data ? 
How can i configure the my app.yaml or so to use the new beta instance ?

I can do it so that there is accepted downtime, during the weekend.

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/bac416e4-5c59-48c6-890d-8202ea5ba3ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Need to speed up gae php+cloudSQL

[Jukka Hautakorpi]

Yes i have thank you.
i seems now working faster

I just now received a newsletter about the new cloudsql 2 beta, i will post 
new topic about that.




keskiviikko 13. tammikuuta 2016 10.42.16 UTC+2 Anthony Shapley kirjoitti:
>
> Hey 
>
> Have you set the SQL Cloud instance to follow the app?
>
> Ant
>
> On Wednesday, January 13, 2016 at 8:40:20 AM UTC, Jukka Hautakorpi wrote:
>>
>> How stupid of me:
>> I re-checked the cloudsql instance at it really was to set running 
>> on-demand.
>>
>> I changed it now and will see how it is affecting.
>>
>> But still like to know that is there a faster sql-like option to read 
>> some of the app's data from there ?
>>
>>
>>
>>
>> keskiviikko 13. tammikuuta 2016 10.31.38 UTC+2 Jukka Hautakorpi kirjoitti:
>>>
>>> Hello
>>>
>>> I've been developing an php+sql app. app engine ver. 1.9.31
>>> ( tuunix-tuntileimaus.appspot.com/indexm.php )
>>>
>>> that is working many times very slow.
>>> I am paying to get the second smallest cloud sql instance (more memory) 
>>> and have set the instance to be running all the time. So it should not be 
>>> restarting after idle perioid.
>>>
>>> I have also set daily limit, but i think that it wont matter because 
>>> there are no users for the app currenly so it should be free from the app 
>>> engine part.
>>> "Billing status Enabled (Daily budget: 0,00 $ boosted by 0,50 $) 
>>> Settings"
>>>
>>>
>>> For loading the initial php-screen (affter logged in) I need to check 
>>> the user session and validate it (from sql) then I need to load the data 
>>> using simple left join that works smooth from mysql, but not from cloud sql.
>>>
>>> How can i make it faster? it is crucial that the loading screen is fast! 
>>> I could copy some of the data to a faster read-only database if it's easy 
>>> to use but i don't want to change whole app for another sql.
>>>
>>> Here are couple logs:
>>>
>>> 09:58:02.130
>>> 200
>>> 8,36 KB
>>> *3,34 s*
>>> /indexm.php
>>> 37.219.169.33 - - [12/Jan/2016:23:58:02 -0800] "GET /indexm.php 
>>> HTTP/1.1" 200 8558 - "Mozilla/5.0 (Windows NT 6.1; WOW64) 
>>> AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36" "
>>> tuunix-tuntileimaus.appspot.com" ms=3337 cpu_ms=21 
>>> cpm_usd=0.00095643101 
>>> instance=00c61b117c63aaef224186a3798ac27fa23xxx app_engine_release=1.9.31 
>>> trace_id=c46a5c43610c5bf97d758acf9d444f85
>>>
>>>
>>> 09:58:31.555
>>> 200
>>> 367 B
>>> 275 ms
>>> /setworktimecomment.php
>>> 37.219.169.33 - - [12/Jan/2016:23:58:31 -0800] "POST 
>>> /setworktimecomment.php HTTP/1.1" 200 367 - "Mozilla/5.0 (Windows NT 6.1; 
>>> WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 
>>> Safari/537.36" "tuunix-tuntileimaus.appspot.com" ms=275 cpu_ms=20 
>>> cpm_usd=4.1015e-05 instance=00c61b117c63aaef224186a3798ac27fa23xxx 
>>> app_engine_release=1.9.31 trace_id=92b17ea4ba9f003a735fa58f2465ba67
>>>
>>> Trace:
>>> http://tinypic.com/r/15xv605/9
>>>
>>>
>>> What should I do ?
>>>
>>>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/79f05fff-c803-4b02-80f6-04af3a6bf1d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Re: Need to speed up gae php+cloudSQL

[Jukka Hautakorpi]

How stupid of me:
I re-checked the cloudsql instance at it really was to set running 
on-demand.

I changed it now and will see how it is affecting.

But still like to know that is there a faster sql-like option to read some 
of the app's data from there ?




keskiviikko 13. tammikuuta 2016 10.31.38 UTC+2 Jukka Hautakorpi kirjoitti:
>
> Hello
>
> I've been developing an php+sql app. app engine ver. 1.9.31
> ( tuunix-tuntileimaus.appspot.com/indexm.php )
>
> that is working many times very slow.
> I am paying to get the second smallest cloud sql instance (more memory) 
> and have set the instance to be running all the time. So it should not be 
> restarting after idle perioid.
>
> I have also set daily limit, but i think that it wont matter because there 
> are no users for the app currenly so it should be free from the app engine 
> part.
> "Billing status Enabled (Daily budget: 0,00 $ boosted by 0,50 $) Settings"
>
>
> For loading the initial php-screen (affter logged in) I need to check the 
> user session and validate it (from sql) then I need to load the data using 
> simple left join that works smooth from mysql, but not from cloud sql.
>
> How can i make it faster? it is crucial that the loading screen is fast! I 
> could copy some of the data to a faster read-only database if it's easy to 
> use but i don't want to change whole app for another sql.
>
> Here are couple logs:
>
> 09:58:02.130
> 200
> 8,36 KB
> *3,34 s*
> /indexm.php
> 37.219.169.33 - - [12/Jan/2016:23:58:02 -0800] "GET /indexm.php HTTP/1.1" 
> 200 8558 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, 
> like Gecko) Chrome/47.0.2526.106 Safari/537.36" "
> tuunix-tuntileimaus.appspot.com" ms=3337 cpu_ms=21 
> cpm_usd=0.00095643101 
> instance=00c61b117c63aaef224186a3798ac27fa23xxx app_engine_release=1.9.31 
> trace_id=c46a5c43610c5bf97d758acf9d444f85
>
>
> 09:58:31.555
> 200
> 367 B
> 275 ms
> /setworktimecomment.php
> 37.219.169.33 - - [12/Jan/2016:23:58:31 -0800] "POST 
> /setworktimecomment.php HTTP/1.1" 200 367 - "Mozilla/5.0 (Windows NT 6.1; 
> WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 
> Safari/537.36" "tuunix-tuntileimaus.appspot.com" ms=275 cpu_ms=20 
> cpm_usd=4.1015e-05 instance=00c61b117c63aaef224186a3798ac27fa23xxx 
> app_engine_release=1.9.31 trace_id=92b17ea4ba9f003a735fa58f2465ba67
>
> Trace:
> http://tinypic.com/r/15xv605/9
>
>
> What should I do ?
>
>

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/244dfcf9-babc-4389-b16b-938df0340c58%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] Need to speed up gae php+cloudSQL

[Jukka Hautakorpi]

Hello

I've been developing an php+sql app. app engine ver. 1.9.31
( tuunix-tuntileimaus.appspot.com/indexm.php )

that is working many times very slow.
I am paying to get the second smallest cloud sql instance (more memory) and 
have set the instance to be running all the time. So it should not be 
restarting after idle perioid.

I have also set daily limit, but i think that it wont matter because there 
are no users for the app currenly so it should be free from the app engine 
part.
"Billing status Enabled (Daily budget: 0,00 $ boosted by 0,50 $) Settings"


For loading the initial php-screen (affter logged in) I need to check the 
user session and validate it (from sql) then I need to load the data using 
simple left join that works smooth from mysql, but not from cloud sql.

How can i make it faster? it is crucial that the loading screen is fast! I 
could copy some of the data to a faster read-only database if it's easy to 
use but i don't want to change whole app for another sql.

Here are couple logs:

09:58:02.130
200
8,36 KB
*3,34 s*
/indexm.php
37.219.169.33 - - [12/Jan/2016:23:58:02 -0800] "GET /indexm.php HTTP/1.1" 
200 8558 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, 
like Gecko) Chrome/47.0.2526.106 Safari/537.36" 
"tuunix-tuntileimaus.appspot.com" ms=3337 cpu_ms=21 
cpm_usd=0.00095643101 
instance=00c61b117c63aaef224186a3798ac27fa23xxx app_engine_release=1.9.31 
trace_id=c46a5c43610c5bf97d758acf9d444f85


09:58:31.555
200
367 B
275 ms
/setworktimecomment.php
37.219.169.33 - - [12/Jan/2016:23:58:31 -0800] "POST 
/setworktimecomment.php HTTP/1.1" 200 367 - "Mozilla/5.0 (Windows NT 6.1; 
WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 
Safari/537.36" "tuunix-tuntileimaus.appspot.com" ms=275 cpu_ms=20 
cpm_usd=4.1015e-05 instance=00c61b117c63aaef224186a3798ac27fa23xxx 
app_engine_release=1.9.31 trace_id=92b17ea4ba9f003a735fa58f2465ba67

Trace:
http://tinypic.com/r/15xv605/9


What should I do ?

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
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/7ad1ec3d-4c5b-426a-8071-f5f9be4e36e4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] What is the state of GAE php?

[Jukka Hautakorpi]

I would like to know that what is the state of google app engine php, is it 
still going to be a developed product or is it already in the "to be 
killed" list ?

Why am i asking this? 
Because https://github.com/GoogleCloudPlatform/appengine-php  has not been 
updated at all.

And the blog https://gae-php-tips.appspot.com/ has not been updated in over 
half year.

Im using gae php for my apps and i'd hate to see it shut down.


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/6cd0189e-f30d-4138-8769-19a10aa332ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] App Failed to load

[Jukka Hautakorpi]

Im testing my gae / php / sql app and was using my mobile phone samsung gs 
3.
I have made a app shortcut to my home screen where i use to lauch the app.
And also use it from pc chrome browser, but in this case i was not around 
my pc.

Didn't update the app in many days now and jul 27. was really bad hicckup. 
I seemed only to load 1 file from the app. Even tough other sites worked ok 
with the phone (so not a wireless network problem at my end)
What i would like to know is why, was there a network error between my 
phone and gae. Like i said, other sites worked ok and app worked flawlessly 
3 hours earlier.
It also worked about 2 hours later when i tested it again.
But i cannot release the if this kind of error occurs and there is no 
reason for it!

app is not in english yet but u can test it from
http://urlgone.com/c62cb7/
u: testad...@teippiviritykset.com pw: henki465


Here is a pics from the logs:











-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/26a0f1cb-2e1f-4258-aa0f-9b901f974eba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[google-appengine] App Failed to load

[Jukka Hautakorpi]

'm testing my gae / php / sql app and was using my mobile phone samsung gs 
3.
I have made a app shortcut to my home screen where i use to lauch the app.
And also use it from pc chrome browser, but in this case i was not around 
my pc.

Didn't update the app in many days now and jul 27. was really bad hicckup. 
I seemed only to load 1 file from the app. Even tough other sites worked ok 
with the phone (so not a wireless network problem at my end)
*What i would like to know is why, was there a network error between my 
phone and gae. *Like i said, other sites worked ok and app worked 
flawlessly 3 hours earlier.
It also worked about 2 hours later when i tested it again.
*But i cannot release the if this kind of error occurs and there is no 
reason for it!*

app is not in english yet but u can test it from
http://urlgone.com/c62cb7/
u: testad...@teippiviritykset.com pw: henki465


Here is a pics from the logs:








-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/dde9c335-1d7b-43fb-8bcd-a6fe773454b2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.