[web2py] Re: no-email edit in profile

2018-12-18 Thread appjarbiz
Alternately, simply remove line 3628 of gluon/tools.py table_user['email'].writable = False On Friday, December 14, 2018 at 10:25:10 AM UTC-6, Leonel Câmara wrote: > > I think this problem was caused by CAS, but there were other problems, > namely that it would not check the new email

[web2py] Re: hello and a question about deployment

2018-12-03 Thread appjarbiz
It really depends on your use case. I've deployed production Web2py on dedicated server, Heroku, and now AWS Lambda (Serverless). Heroku gives you the best metrics and ops, but If I had to do it again, I would do them all on AWS Lambda due to the reduced cost during down time and the auto-sca

[web2py] getting status of the DAL db connection pool

2018-12-02 Thread appjarbiz
Is there a way to view the status of the DAL DB connection pool from within a request? I'd like to have my model write the status of the connection pool to the logger or to a debug function response. This is so I can debug and adjust my pool size for different deployment configurations. Also

[web2py] Re: MySql encryption using DAL

2018-11-30 Thread appjarbiz
Thanks Massimo. These are the steps and syntax to connect to Amazon's RDS using SSL. *Step1:* Download Amazons's CA certificate from here: https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem and save it into web2py/applications/myapp/private/ssl/rds-combined-ca-bundle.pem *Step2:

[web2py] Re: AWS Lambda Deployment Recipe

2018-11-28 Thread appjarbiz
Thank you Anthony, I added the wsgibase wrapper after my initial post. I was modifying gluon/main.py but I added the wrapper (lambda_handler.py) to avoid that. I confirmed which environ variables are coming through as unicode and submitted an issue to zappa. https://github.com/Miserlou/Zappa/i

[web2py] AWS Lambda Deployment Recipe

2018-11-27 Thread appjarbiz
I've created a first pass at an AWS Lambda deployment recipe which uses an open-source tool called Zappa. I welcome an comments or suggested improvements. In particular, step 3 requires modifying gluon/main.py which I would like to avoid. Deployment Recipe: https://docs.google.com/document/d/1

[web2py] How to get tickets in DB working

2018-11-23 Thread appjarbiz
I had to modify Web2Py as follows to get tickets stored in the DB (necessary for cloud deployment with no filesystem) It working for tracebacks but not for snapshots. I needed to modify Web2Py 2.17.2 to: 1) Use JSON instead of Pickle for serialization as Pickle has errors serializing to MySQL

[web2py] Re: AWS Lambda Serverless and Zappa

2018-11-22 Thread appjarbiz
Hey arafay, Sorry for the delay. I plan to post a deployment recipe soon. There are a lot of little gotchas I've had to work through. I was able to do it successfully with Zappa (https://github.com/Miserlou/Zappa) I'm working on doing it for another app and should be able to post my steps i

[web2py] Re: AWS Lambda Serverless and Zappa

2018-09-08 Thread appjarbiz
On Saturday, September 8, 2018 at 2:47:55 PM UTC-5, Anthony wrote: > > You can use InDBMigrator (see > https://groups.google.com/d/msg/web2py/lZnL4hRloSc/SSEBnIM0CQAJ). Also, > rather than edit main.py, you can just ensure all the folders are there to > begin with. Finally, make sure to put se

[web2py] Re: AWS Lambda Serverless and Zappa

2018-09-08 Thread appjarbiz
Thank you Anthony! That got me past the filesystem issues. Now it seems like I'm stuck in gluon._compat and urllib. It is having problems importing. cannot import name urllib_quote_plus: ImportError Traceback (most recent call last): File "/var/task/handler.py", line 585, in lambda_handler re

[web2py] AWS Lambda Serverless and Zappa

2018-09-08 Thread appjarbiz
I am trying to migrate my Web2Py app from Heroku to AWS Lambda, using Zappa. I can get it to start running, but I'm running into errors because web2py is trying to write to the filesystem. I commented out create_missing_app_folders() and create_missing_folders() from gluon/main.py, however,

[web2py] Re: MySql encryption using DAL

2018-08-31 Thread appjarbiz
I was curious if the ability to connect securely to a database service (without an SSH tunnel) was added to 2.17.1? Thanks. On Wednesday, January 31, 2018 at 12:27:01 AM UTC-6, appj...@gmail.com wrote: > > Hi, I wanted to check back to see if there was any update on this. > > With more and

[web2py] Re: heroku, web2py and gunicorn

2018-08-03 Thread appjarbiz
Thank you Stifan, that's worked! For reference for anyone else out there running web2py on Heroku here is my working production Procfile: web: gunicorn wsgihandler --max-requests 1000 --timeout 10 --max-requests-jitter 100 On Friday, August 3, 2018 at 5:11:33 AM UTC-5, 黄祥 wrote: > > pls

[web2py] Re: heroku, web2py and gunicorn

2018-08-02 Thread appjarbiz
What is the syntax to do that? I assume I need to let it know about web2py/wsgihandler. My current syntax (running on Heroku) is: python anyserver.py -s gunicorn -i 0.0.0.0 -p $PORT On Thursday, August 2, 2018 at 5:20:15 PM UTC-5, 黄祥 wrote: > > had you try to run the gunicorn itself (without

[web2py] Re: heroku, web2py and gunicorn

2018-08-02 Thread appjarbiz
Is there a syntax to pass gunicorn options like --timeout or --max-requests into the anyserver.py command line? python anyserver.py -s gunicorn -i 0.0.0.0 -p $PORT --max-requests 1000 adding the --max-requests to the command line doesn't get passed through. Thanks. On Thursday, April 19

[web2py] Re: MySql encryption using DAL

2018-01-30 Thread appjarbiz
Hi, I wanted to check back to see if there was any update on this. With more and more database solutions moving to hosted DB services (so no SSH tunnels), Web2Py apps do not have the ability to connect to these securely. We are stuck hosting a dedicated machine to server our MySQL and run

Re: [web2py] Re: MySql encryption using DAL

2017-10-23 Thread appjarbiz
I am using "autossh" which is a monitor wrapper around ssh that restarts the ssh connection if it gets dropped. It appears to be working well. On Thursday, October 12, 2017 at 4:52:49 PM UTC-5, appj...@gmail.com wrote: > > I'm using Heroku. Would the VPN option be more stable/reliable/performant

Re: [web2py] Re: MySql encryption using DAL

2017-10-12 Thread appjarbiz
I'm using Heroku. Would the VPN option be more stable/reliable/performant than an SSH tunnel? On Thursday, October 12, 2017 at 8:07:36 AM UTC-5, CDA wrote: > > Depending on the type of cloud service you may be able to setup VPN over > internet and connect your DB via the VPN tunnel. > > On Oct 1

[web2py] Re: MySql encryption using DAL

2017-10-11 Thread appjarbiz
On Wednesday, October 11, 2017 at 11:52:02 AM UTC-5, Massimo Di Pierro wrote: > > > > On Saturday, 7 October 2017 01:55:53 UTC-5, appj...@gmail.com > wrote: >> >> Thank you Massimo! >> >> There is a great detailed deployment recipe for SSH tunneling to your >> database server from a Heroku ap

[web2py] Re: MySql encryption using DAL

2017-10-06 Thread appjarbiz
> > Thank you Massimo, but this presents 2 problems: >> > 1) I am using Heroku for the app and it boots with a non-interactive Procfile. If I put: ssh -L 3307:localhost:3306 myusern...@db.example.com in the procfile, it wants to prompt me for a password through stdin. I could use sshpass

[web2py] MySql encryption using DAL

2017-10-05 Thread appjarbiz
Hello, I have a Web2py app I'm moving from a dedicated server to the cloud but I'm leaving my MySQL database on the original server. I am connecting to mysql via the DAL: db = DAL('mysql://username:passw...@db.example.com/', pool_size=8, migrate = migrate_dev, lazy_tables=True, fake_migrate=Tr