[web2py] Scheduler error

2014-08-25 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

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

2014-08-25 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 wrote: Run this script: scripts/setup-web2py-nginx-uwsgi-ubuntu.sh It works

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

2014-08-25 Thread Derek
Have you actually looked at it? I believe it just returns asterisks. On Monday, August 25, 2014 3:02:49 PM UTC-7, Mark Li wrote: > > I am currently looking into whether or not password fields should be > cleared on registration error after the form fails server-side validation. > At the moment,

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

2014-08-25 Thread Mark Li
I am currently looking into whether or not password fields should be cleared on registration error after the form fails server-side validation. At the moment, web2py shows the password after a registration error, instead of leaving it blank. While this may make editing the password easier (in c

[web2py] Re: Scheduler task finishes but row not marked COMPLETED

2014-08-25 Thread Niphlod
sorry for not being able to pinpoint the root cause, but every task you queue has potentially zillions of variables to go though. if a def mytask(a, b): return a+b works, then the "culprit" of the scheduler not being able to finish the task MAY (I'm pretty sure scheduler is ATM robustly

[web2py] Re: multiple DAL

2014-08-25 Thread Niphlod
or you can just use migrate=False and leave it be. On Monday, August 25, 2014 7:49:32 PM UTC+2, Leonel Câmara wrote: > > Ohh then you also need to pass the "folder" argument to your DAL as the > sqlite file will not be in your application's database folder but in the > other app's folder. > --

[web2py] Re: Using cache for improving pagination recipe in the manual?

2014-08-25 Thread Derek
This is one of those cases of mixing your controller with your view. Please don't do that. Look here for that... http://en.wikipedia.org/wiki/Link_prefetching and please keep your html out of your controllers. they should only go in views. On Monday, August 18, 2014 1:07:00 AM UTC-7, Giacomo

[web2py] Re: multiple DAL

2014-08-25 Thread Leonel Câmara
Ohh then you also need to pass the "folder" argument to your DAL as the sqlite file will not be in your application's database folder but in the other app's folder. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: share datebases with different application

2014-08-25 Thread Derek
Sure, why not. But the question is, why? If it's authentication, there is a central authentication service that you can use. On Monday, August 25, 2014 4:17:44 AM UTC-7, eric cuver wrote: > > Hi, > > I have 2 applications (AppA, AppB). Each application has a database > (AppA.db, AppB.db). > The

[web2py] Re: multiple DAL

2014-08-25 Thread eric cuver
Le lundi 25 août 2014 18:29:02 UTC+2, Leonel Câmara a écrit : > > Yes you can, however you probably don't want both DALs using the same db > (sqlite is pointing to the same file). Also remember to do > db1.define_table, db2.define_table, etc. Instead of just db.define_table. > > Anyway, why do

[web2py] Re: OAUTH - FACEBOOK - IMAGE PROFILE ACCOUNT

2014-08-25 Thread Leonel Câmara
What I use in my applications is to simply fetch the image from here: "http://graph.facebook.com/%(user_id)s/picture?width=%(width)s&height=%(height)s" Replacing the templated variables accordingly. Then you can do something like this: import urllib2 picrequest = urllib2.Request(PROPER_

Re: [web2py] Re: Requirements per application

2014-08-25 Thread Derek
That's not possible for django or any other python webapp. where did you get this idea? On Monday, August 25, 2014 1:12:12 AM UTC-7, Kuba Kozłowicz wrote: > > Yea, well with different instances you can do it, but I asked if that is > possible for one instance, which contains multiple apps. > > S

[web2py] Re: (Very) Slow raw SQL queries

2014-08-25 Thread Derek
so here is his code... SELECT TIMESTAMPDIFF(...) AS 'duration', TIMESTAMPDIFF(...) - INTERVAL 1 HOUR, TIMESTAMP(...) + INTERVAL CAST(...) AS 'timediff', ris.ODATE as 'date', CONCAT(...) as 'service' FROM ... AS ris JOIN ... as sd on

[web2py] OAUTH - FACEBOOK - IMAGE PROFILE ACCOUNT

2014-08-25 Thread piero crisci
Hi all I am trying to get Facebook user url photo profile . With google Api i can get from user['picture'] but can manage how get in Facebook. It seem to be in the basic information from Facebook documentation but i can' t manage to retrieve it this is what i wrote in my module (not in model) c

[web2py] Re: (Very) Slow raw SQL queries

2014-08-25 Thread Derek
I believe the timings did that, it's not in the query. On Monday, August 25, 2014 9:24:41 AM UTC-7, Cliff Kachinske wrote: > > Why is '\n', the newline character, sprinkled throughout your query? > > See what happens if you get rid of them. > > On Monday, August 25, 2014 4:54:53 AM UTC-4, Mehmet A

Re: [web2py] Facebook OAuth - newbie question

2014-08-25 Thread piero crisci
You can try this Modify in #default.py def user(): if auth.is_logged_in() and request.args[0] == 'login': return redirect(URL('default','index')) elif auth.is_logged_in() == False and request.args[0] == 'login': if request.args[1] == 'facebook': facebook_

[web2py] Re: pytds support for mssql?

2014-08-25 Thread Derek
So just an update, it appears there is an issue in tds.py and the author has added a branch sp1d3rx-problem and it does fix it. Now the only issue with pytds is DSN support.\ To fix the tds.py look around line 2570 or so and comment out this: #if not msg['server'] and self.login: #

[web2py] Re: multiple DAL

2014-08-25 Thread Leonel Câmara
Yes you can, however you probably don't want both DALs using the same db (sqlite is pointing to the same file). Also remember to do db1.define_table, db2.define_table, etc. Instead of just db.define_table. Anyway, why do you want 2 DALs with exactly the same model? -- Resources: - http://web2p

[web2py] Re: (Very) Slow raw SQL queries

2014-08-25 Thread Cliff Kachinske
Why is '\n', the newline character, sprinkled throughout your query? See what happens if you get rid of them. On Monday, August 25, 2014 4:54:53 AM UTC-4, Mehmet A. wrote: > > Hi, > db.executesql() takes 30 seconds to return a result while page-loading, > despite the fact that same query takes 0

[web2py] Re: Content-Type does not get set for response.stream method

2014-08-25 Thread Kuba Kozłowicz
So instead of using: return response.stream(file_path, chunk_size=10**6, filename='output.pdf') I simply use: pdf_data = open(file_path,"rb").read() return pdf_data and it works. No idea why, because I thought "stream" method was supposed to be used to stream files, but it does not work. W

[web2py] Re: SQLFORM - field_id - not work

2014-08-25 Thread Rohit Raj Sharma
i think you want to fetch data of particular row...Please use the following code for the same def myfunctionit_detail(): links = [lambda row: A('Upload',_href=URL("default","myfunction",args=[row.id] ))] query = ((db.tracker.id>=0 ) ) grid = SQLFORM.grid(query=query, links=links,maxtex

[web2py] (Very) Slow raw SQL queries

2014-08-25 Thread Mehmet A.
Hi, db.executesql() takes 30 seconds to return a result while page-loading, despite the fact that same query takes 0.5-1 second if I try it on MySQL console or web2py debug console or web2py shell. [4] dbs._timings > [('SELECT 1;', 0.01632424926758), > ('SET FOREIGN_KEY_CHECKS=1;', 0.003999

[web2py] Re: DAL calls fail after first stored procedure call

2014-08-25 Thread Josh L
For now I'm just using a mysqldb.connect(options) object directly with a cursor to call my SP, bypassing the web2py DAL completely. Of course this means I have to create a new DB connection for every SP call, and I'm thinking performance wise this might be worse off than just not using an SP al

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-08-25 Thread Giacomo Dorigo
Hi Massimo, I was reading this page in the manual: http://web2py.com/books/default/chapter/29/12/components-and-plugins#Layout-plugins *What do you think about putting the (presently) default bootstrap 2 layout in a plugin?* In this way you will ship directly web2py with these: static/plugin_lay

Re: [web2py] Re: Requirements per application

2014-08-25 Thread Kuba Kozłowicz
Yea, well with different instances you can do it, but I asked if that is possible for one instance, which contains multiple apps. So it's impossible. W dniu niedziela, 24 sierpnia 2014 12:13:57 UTC+2 użytkownik Michele Comitini napisał: > > I think you just need to make some python virtualenvs

[web2py] Google Cloud SQL and web2py_filesystem table.

2014-08-25 Thread Mikael Brandt
Hello and thanks for web2py! I am trying to run a web2py app on Google App Engine using two separate databases, one running Google Cloud SQL to enable complex queries, and one using the default Google Datastore to just be really scalable. All my tests run nicely using SQLite locally, but when I

[web2py] Re: Scheduler task finishes but row not marked COMPLETED

2014-08-25 Thread Stephen Weiss
No, not doing any print statements, only logger.debug calls. The work that the running task does make Popen calls, not popen2 calls, if that's any help. However, I don't know how to go about checking if the stderr and/or stdout pipes are not filled. No, I didn't try running the task in a web2p

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

2014-08-25 Thread Art Aquino
Run this script: scripts/setup-web2py-nginx-uwsgi-ubuntu.sh It works on the pi. I did it yesterday and its all working. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Repor

[web2py] multiple DAL

2014-08-25 Thread eric cuver
hello everybody, can we create multiple DAL in same model. for example: db1 = DAL('sqlite://storage.sqlite') db.define_table() db.define_table() db2 = DAL('sqlite://storage.sqlite') db.define_table() db.define_table() -- Resources: - http://web2py.com - http:/

[web2py] share datebases with different application

2014-08-25 Thread eric cuver
Hi, I have 2 applications (AppA, AppB). Each application has a database (AppA.db, AppB.db). There is a table in AppA (AppA.table), which should be used in AppB and There is a table in AppB (AppB.table), which should be used in AppA it's possible with web2py ? -- Resources: - http://web2py.co

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

2014-08-25 Thread Massimo Di Pierro
I used the same script on two different machines. I get Ubuntu 14.04.1 LTS (from Digital Ocean Droplet) works fine Ubuntu 14.04.1 LTS (from AWS Image) "internal server error" In both cases these were fresh installations and the only code that run was setup-web2py-nginx-uwsgi-ubuntu.sh On Mond

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

2014-08-25 Thread Jim S
Ubuntu 14.04.1 / nginx / uwsgi is working for me without problems. I used the script referenced in the book to install it and it worked fine. I don't recall doing anything special. -Jim On Monday, August 25, 2014 10:26:16 AM UTC-5, Massimo Di Pierro wrote: > > I am having a similar problem to

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

2014-08-25 Thread Massimo Di Pierro
I am having a similar problem too. When I run on Ubuntu 14.04 everything works as intended. When I run on Ubuntu 14.04.1 LTS I get "Internal server error" I only get the error with uwsgi-emperor, not if I run uwsgi manually. Same command line manual and in the emperor configuration. On Sunday,

[web2py] vps.net ubuntu script installation for web2py doesn't appear to work

2014-08-25 Thread 'sasogeek' via web2py-users
I just watched the vimeo video made by Massimo some time back and used it as a guide to get web2py running on a node I just acquired at vps.net. Once everything was done, I tried to go to the ip but all I get is the default apache server page. It works! This is the default web page for this se

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

2014-08-25 Thread Massimo Di Pierro
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 to internationalize this? On Friday, 22 August 2014 10:33:28 UTC-5, Calvin wrote: > > Hi Massimo > > Here's an example: > > T.M("hell

[web2py] Re: SQLFORM - field_id - not work

2014-08-25 Thread Anthony
What do you expect it to do, and what is happening instead? On Monday, August 25, 2014 3:00:47 AM UTC-4, Dmitry Ermolaev wrote: > > SQLFORM.grid(db.pets, > field_id = db.pets.url, > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] SQLFORM - field_id - not work

2014-08-25 Thread Dmitry Ermolaev
SQLFORM.grid(db.pets, field_id = db.pets.url, -- 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 ar