Re: [web2py] Re: Web2py, nginx, installation on Raspberry Pi

2014-08-26 Thread Jason Brower
As crazy as it sounds, I did run that script. It was a fresh install from a NOOBS image. There has got to be some different. Just don't know what it is. BR, Jason Brower On Mon, Aug 25, 2014 at 1:20 AM, Art Aquino art9...@gmail.com wrote: Run this script:

[web2py] Scheduler error

2014-08-26 Thread Prasad Muley
Hi, I've web2py 2.3 version. I tried to use scheduler for mail sending. I got this error while creating a worker for scheduler $ python web2py.py -K send_mail_app [12:07:02] web2py Web

[web2py] Re: What am i doing wrong here? (virtualfields)

2014-08-26 Thread Remco Boerma
Exactly, i noticed the difference between the 4th and 6th too late, but now that i know... A workaround to this confusion would be highly appreciated. Remco Op woensdag 20 augustus 2014 16:57:44 UTC+2 schreef Anthony: Depends on where you look in the book:

[web2py] Re: Scheduler error

2014-08-26 Thread Niphlod
there's yet a scheduler_task table in the database. Fix migrations in the usual way, or set Scheduler(db,,migrate=False) to avoid the error. On Tuesday, August 26, 2014 8:58:06 AM UTC+2, Prasad Muley wrote: Hi, I've web2py 2.3 version. I tried to use scheduler for mail sending. I

Re: [web2py] Re: Scheduler error

2014-08-26 Thread Prasad Muley
Thanks. It works. On Tue, Aug 26, 2014 at 1:04 PM, Niphlod niph...@gmail.com wrote: there's yet a scheduler_task table in the database. Fix migrations in the usual way, or set Scheduler(db,,migrate=False) to avoid the error. On Tuesday, August 26, 2014 8:58:06 AM UTC+2, Prasad Muley

Re: [web2py] Re: Scheduler error

2014-08-26 Thread Prasad Muley
Hi, I tried to access db.scheduler_run table but it is giving me following error in web2py shell and app admin UI. *OperationalError: (1054, Unknown column 'scheduler_run.scheduler_task' in 'field list')* On Tue, Aug 26, 2014 at 1:04 PM, Niphlod niph...@gmail.com wrote: there's yet a

Re: [web2py] Re: Scheduler error

2014-08-26 Thread Niphlod
I'd strongly advise you to read the section on the book about migrations and fixing broke migrations. If you're starting now with the scheduler, please do the following: - delete all databases/*_scheduler_*.table files - delete scheduler_worker, scheduler_tasks, scheduler_run table from your

[web2py] Re: Hi, Is there a way to block ip address if there are more no of requests from the same ip address

2014-08-26 Thread Richard Penman
Try putting something like this in your controller to detect and ban IP addresses that download too fast: # block malicious crawlers that download too fast BAN_IP_TIME = 60

[web2py] Re: How can Web2py prevent web scraping?

2014-08-26 Thread Richard Penman
I created a simpler system just counting requests and then blocking when exceeded maximum in a time frame: http://www.web2pyslices.com/slice/show/1991/block-fast-bots On Friday, May 10, 2013 1:36:22 AM UTC+2, Derek wrote: I've read an idea about using a 'ticket' system... each session gets X

[web2py] Re: Google Cloud SQL and web2py_filesystem table.

2014-08-26 Thread Leonel Câmara
I guess -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group.

[web2py] Re: Google Cloud SQL and web2py_filesystem table.

2014-08-26 Thread Leonel Câmara
I guess a quick solution for you, could be to monkeypatch isProgrammingError to something like this def isProgrammingError(self, exception): return exception.__class__.__name__ == 'ProgrammingError' -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Spontaneous .table file corruption?

2014-08-26 Thread lpg
Anyone else seen this? Database .table files are getting corrupted spontaneously. This happened overnight on a testing server that doesn't get users. No updates on application code, nor web2py. https://www.dropbox.com/s/p34vdbdszdpsr1q/Screenshot%202014-08-26%2010.14.24.png?dl=0 Relevant

[web2py] Re: putting in a custom render function with T.M()

2014-08-26 Thread Calvin
Thanks for clarifying, Massimo. MARKMIN will have to do for now. On Monday, 25 August 2014 23:18:43 UTC+8, Massimo Di Pierro wrote: At this time T.M does not support extra. You can do: MARKMIN(hello ``you``:custom, extra=dict(custom=lambda x: SPAN(x, _style=font-size:0.8em))) Do you need

[web2py] Re: Spontaneous .table file corruption?

2014-08-26 Thread Leonel Câmara
Is the databases folder under version control and someone updated it on the server? Is someone using windows for development? What happens if you run the database table files by dos2unix? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: Spontaneous .table file corruption?

2014-08-26 Thread Lucas Geiger
No version control. Workin on Ubuntu. I think the system is OOMing . Seems unsafe for table definitions to die if the system goes out of memory. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Spontaneous .table file corruption?

2014-08-26 Thread Leonel Câmara
Yes OOM is a possible cause. It doesn't seem unsafe as the system goes out of memory loading the table definitions so it doesn't really do anything, -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Registration passworld field security risk on form failure?

2014-08-26 Thread Mark Li
Looking at the password input through Firebug/developer tools, and the value of the password input is the plaintext of the password I entered. I have a test site here: http://tedlee.pythonanywhere.com/welcome/default/user/register Typing in a password and failing registration will return that

[web2py] Re: Registration passworld field security risk on form failure?

2014-08-26 Thread Willoughby
Using the same Firebug, look at the Net tab - look at your post and the response. On Tuesday, August 26, 2014 1:32:14 PM UTC-4, Mark Li wrote: Looking at the password input through Firebug/developer tools, and the value of the password input is the plaintext of the password I entered. I

Re: [web2py] Re: Web2py, nginx, installation on Raspberry Pi

2014-08-26 Thread Paolo Valleri
For rpi I see few alternatives: - switch to upstart (mind that would be a big change for your operating system) - create your own uwsgi script in /etc/init.d/ (google for it) - place the command line a posted before in /etc/rc.local (mind to add an at the end) - uninstall the uwsgi installed by

Re: [web2py] Re: Web2py, nginx, installation on Raspberry Pi

2014-08-26 Thread Jason (spot) Brower
Thanks. I will probably try with the repos version and submit a pull request with a script for the web2py source. Also making a tool to publish to Qt cloud services. Perhaps we could add it to admin. On Aug 26, 2014 9:31 PM, Paolo Valleri paolo.vall...@gmail.com wrote: For rpi I see few

[web2py] IS_EMPTY_OR(IS_IN_DB incompatible with custom form?

2014-08-26 Thread José L .
Hi, I'm using a custom form to represent the fields of a table. This table has referenced fields. If I use: db.define_table('department', Field('dept_id'), Field('nombre'),format='%(nombre)s') db.define_table('employee', Field('firstName'), Field('lastName'),

[web2py] Re: Spontaneous .table file corruption?

2014-08-26 Thread Niphlod
There's nothing web2py can do about how python handles OOM saving pickles in a directory. It's not really rocket science what web2py does. It's a web framework, not an operating system ^_^ And, BTW, .table files are just needed for migrations, so in theory they should be present only in your

[web2py] Re: How can Web2py prevent web scraping?

2014-08-26 Thread Derek
You should use proper HTTP status codes. 429 is the appropriate response code. http://tools.ietf.org/html/rfc6585 While 503 did have wording suggesting it can be used for rate limiting, that has been removed. http://trac.tools.ietf.org/wg/httpbis/trac/ticket/255 503 and 403 were both used for

[web2py] Re: Hi, Is there a way to block ip address if there are more no of requests from the same ip address

2014-08-26 Thread Derek
once again, use 429 not 503 please read your RFCs. On Tuesday, August 26, 2014 5:31:07 AM UTC-7, Richard Penman wrote: Try putting something like this in your model to detect and ban IP addresses that download too fast: # block malicious crawlers that download too fast

[web2py] Re: IS_EMPTY_OR(IS_IN_DB incompatible with custom form?

2014-08-26 Thread Anthony
On Tuesday, August 26, 2014 3:13:35 PM UTC-4, José L. wrote: Hi, I'm using a custom form to represent the fields of a table. This table has referenced fields. If I use: db.define_table('department', Field('dept_id'), Field('nombre'),format='%(nombre)s')

[web2py] Re: Web2py Mobile Interface

2014-08-26 Thread Dave S
On Thursday, August 21, 2014 7:46:01 AM UTC-7, Greg Vaughan wrote: Hi Massimo I get the requires gitpython module so I cannot complete a pull request. I was hoping to be able to install the app as I would on the PC but that option is not available... should it be? Did you try the

Re: [web2py] Re: How can Web2py prevent web scraping?

2014-08-26 Thread Richard Baron Penman
Thanks for info On Tue, Aug 26, 2014 at 10:26 PM, Derek sp1d...@gmail.com wrote: You should use proper HTTP status codes. 429 is the appropriate response code. http://tools.ietf.org/html/rfc6585 While 503 did have wording suggesting it can be used for rate limiting, that has been removed.