[web2py] Password Recovery Not Sending (lazyT object being passed to GAE?)

I just uploaded an updated version of web2py to my server, replacing a much older version, and now it won't send password recovery emails. The error in the logs is: Mail.send failure:coercing to Unicode: need string or buffer, lazyT found This suggests to me that somehow a string is not

[web2py] Re: Designing security for different client types in the same app

You have to use something like this most likely. https://en.wikipedia.org/wiki/NSA_encryption_systems And they will need to approve that. I am guessing. On Thursday, July 28, 2016 at 4:48:30 PM UTC-4, Alex Glaros wrote: > > I'm writing an app that government organizations use for project >

[web2py] Re: ProgrammingError: column "worker_stats__tmp" is of type json but expression is of type text

HI I had the same problem and the same error as main post. After following your instructions the error is solved but another error persists. ERROR:web2py.scheduler.rpiblue#2315:Error retrieving status With Version 2.14.6-stable+timestamp.2016.05.09.19.18.48 Database drivers available:

Re: [web2py] Re: Improvements for DevOps

thanks for your response and suggestions. Good to hear that you are aware of those "issues" and hopefully this will be improved in the future (pypi package sounds good). Alex -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Problem sending emails. Various errors from different Ports

It probably would have worked with the way used in the book, but to get it to work I had to create a new gmail account, and use the smtplib for python. My code ended up looking like: import smtplib def send_contact_form(): message = "Test" mail = smtplib.SMTP('smtp.gmail.com', 587)

[web2py] Designing security for different client types in the same app

I'm writing an app that government organizations use for project management and other functionality, and, using the same app, open areas for citizen engagement, for example, crowdsourcing citizen ideas for government projects. Citizens and government share the same data. Everything is locked

[web2py] setattr equivalent for limiting field display in form?

is there a setattr equivalent for limiting fields appearing in a form? below works to limit fields appearing in *grid*, but I'd like to limit them in a *form* without having to type long list of readable = False [setattr(f, 'readable', False) for f in db.auth_membership if f.name not in

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

could you please try with psycopg2 ? On Thursday, July 28, 2016 at 6:53:10 PM UTC+2, Abhishek Ram wrote: > > I am using the default driver pg8000 > > On Thursday, July 28, 2016 at 7:47:41 PM UTC+5:30, Niphlod wrote: >> >> what driver are you using ? it's rather strange that postrgresql acts up

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

I am using the default driver pg8000 On Thursday, July 28, 2016 at 7:47:41 PM UTC+5:30, Niphlod wrote: > > what driver are you using ? it's rather strange that postrgresql acts up > and eat all the available memory, if you didn't tinker with the defaults > settings of postgresql... > > On

[web2py] Re: show_if issue

Thanks. I am new to programming. I want to create a form based on the field selections from another table. How can I accomplish this using web2py? Thanks in advance. On Sunday, July 24, 2016 at 5:32:43 PM UTC-5, Sneka R wrote: > > Can I use show_if for 2 tables? > For example: >

Re: [web2py] Re: Scheduler runs

Ah! Alright. Thanks! On Jul 28, 2016 7:21 AM, "Niphlod" wrote: > are you aware that a task that doesn't return a thing and doesn't fail > won't store any scheduler_run table ? > The rationale is that if you didn't return anything, you don't need the > corresponding line in

[web2py] Re: Amazon Redshift

BTW (funny things happen) today amazon announced that for RDS native backups/restore are available (RDS is PaaS for MSSQL, as redshift is for postgresql). Maybe they'll add the feature for redshift, too. On Tuesday, July 26, 2016 at 5:15:20 PM UTC+2, Alex Glaros wrote: > > thanks Niphlod > >

[web2py] Re: list of time zones

and that usecase should be covered by enabling the dropdown WITHOUT turning the autodetection. On Tuesday, July 26, 2016 at 7:54:39 PM UTC+2, icodk wrote: > > Thanks Niphold. This plugin is one of the best I know. It solves timezone > problem between user browser and server. In my case it is

[web2py] Re: Scheduler runs

are you aware that a task that doesn't return a thing and doesn't fail won't store any scheduler_run table ? The rationale is that if you didn't return anything, you don't need the corresponding line in scheduler_run to retrieve the result. On Tuesday, July 26, 2016 at 8:28:32 PM UTC+2, Sagar

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

what driver are you using ? it's rather strange that postrgresql acts up and eat all the available memory, if you didn't tinker with the defaults settings of postgresql... On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: > > Well the memory leak was from the postgres

[web2py] Re: Using web2py with GreenPlum: Returning clause error

the returning statement is in /dialects/ :-P it definitely is a huge improvement over the "usual" lastval()/currval()/etc, BUT AFAIK it's not turned on by default. @giobar0, thoughts ? On Wednesday, July 27, 2016 at 9:21:04 AM UTC+2, Massimo Di Pierro wrote: > > grep RETURNING > >

[web2py] Re: web2py and jwt

ahem. a GET instead of a POST. On Wednesday, July 27, 2016 at 8:56:32 AM UTC+2, Abdu Adil wrote: > > (I used this link to > add jwt()) > > I want to use restful API with JWT, so I did this > > auth = Auth(db,

[web2py] Re: show_if issue

I hate to barge in, but show_if works ONLY for very very very simple conditions: those conditions are translated at the best of possibilities to jquery selectors which are BY FAR not a complete uber-logic such as any DAL expression you throw at it. != True/False == True/False == value !=

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

confirmed, I can't reproduce. Which version of web2py are you on ? On Thursday, July 28, 2016 at 3:42:26 PM UTC+2, Niphlod wrote: > > next_run_time should definitely be there, no matter what... let me check. > > On Thursday, July 28, 2016 at 10:52:40 AM UTC+2, schnee wrote: >> >> As a quick fix

Re: [web2py] Re: Improvements for DevOps

Nice answer... And constructive "critics". We will improve overtime, I guess... Richard On Thu, Jul 28, 2016 at 9:37 AM, Niphlod wrote: > These are all fair points, and I tried to change it over the years by > myself. > Unfortunately, everything I attempted failed, but let's

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

next_run_time should definitely be there, no matter what... let me check. On Thursday, July 28, 2016 at 10:52:40 AM UTC+2, schnee wrote: > > As a quick fix I just added the "next_run_time" argument to the queue_task > function and it's working: > > scheduler.queue_task( > test, >

[web2py] Re: Improvements for DevOps

These are all fair points, and I tried to change it over the years by myself. Unfortunately, everything I attempted failed, but let's "mitigate" point by point. The uttely big disadvantage in retrieving web2py is the lack of a web2py package on pypi. Would that - finally - be available, pretty

[web2py] Re: problem with import type field data

> > Tanks Dave, > > this is a little extract .csv of the database, > together record ok saved via the web2py form, and also record imported from > a dbf with db browser > > >

[web2py] Improvements for DevOps

I'm using deployment scripts (which check dependencies and webp2y version, perform updates if necessary, etc.) for easy deployment of my applications and there are a few pitfalls with web2py. It would be good if this could be resolved and thus make web2py more professional. Sometime ago you

[web2py] Re: problem with import type field data

Tanks Dave, this is the extract csv of the database, together record ok saved via the web2py form, and also record imported from a dbf with db browser

[web2py] Re: Problem sending emails. Various errors from different Ports

Hi, AFAIK you must use port 587 with gmail. Also, I usspect setting ssl=True is causing issues (port 587 uses TLS). Try removing: mail.settings.ssl = True mail.settings.tls = True This is how I do it with gmail: mail.settings.sender = 'm...@gmail.com' mail.settings.server =

[web2py] Re: Excel like filter in grid

The project is on github? Em quinta-feira, 28 de julho de 2016 04:10:37 UTC-3, Gael Princivalle escreveu: > > Thank you guys but making a plug-in is another time investment and I have > other priorities. If someone wants to make it I'll be happy to give a hand. > > Il giorno mercoledì 27 luglio

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

As a quick fix I just added the "next_run_time" argument to the queue_task function and it's working: scheduler.queue_task( test, pargs=[], pvars={}, start_time = datetime.datetime(2016, 7, 29, 0, 0), next_run_time = datetime.datetime(2016, 7, 29, 0, 0),

[web2py] fake_migrate bug on GAE

I realize this was a foolish mistake, but there really should be a way to fix it, and I believe there is not. If you have fake_migrate=True and define a new table, then push to GAE, you will never be able to use that new table's name for anything else because GAE doesn't offer access to a

[web2py] SQLForm.grid csv export

Hello, I'm pretty new to Web2py. I need some help with the SQLForm.grid export CSV functionality.I have the following basic structure: *db.py* db.define_table('test', Field('name', 'string', length=50, notnull=True), Field('email', 'string',

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

A simple example: scheduler = Scheduler(db, utc_time=False) def test(): print("test") return True scheduler.queue_task( test, pargs=[], pvars={}, start_time = datetime.datetime(2016, 7, 29, 0, 0), stop_time = None, #datetime

[web2py] Re: Excel like filter in grid

Thank you guys but making a plug-in is another time investment and I have other priorities. If someone wants to make it I'll be happy to give a hand. Il giorno mercoledì 27 luglio 2016 20:32:02 UTC+2, Ron Chatterjee ha scritto: > > This can be a good plugin for w2p to have. Add this to grid