[web2py] Re: Not seeing logging.error messages in nginx error_log

2016-05-04 Thread Chris Guest
Hi DaveS, So to clarify when I used mod_wsgi & apache I used to get logging.error messages saved into my apache error.log . Now that I use uwsgi & nginx this doesn't happen. I am not sure what your answer means as I am not familiar with what a logging.conf file is. I cannot find a logging.conf

[web2py] Re: Not seeing logging.error messages in nginx error_log

2016-05-04 Thread Dave S
On Wednesday, May 4, 2016 at 6:09:58 PM UTC-7, Dave S wrote: > > On Wednesday, May 4, 2016 at 5:32:47 PM UTC-7, Chris Guest wrote: >> >> Not seeing logging.error in nginx error_log >> >> >> I have a mostly successful install of web2py application with uwsgi and >> nginx on centos using

[web2py] Re: Not seeing logging.error messages in nginx error_log

2016-05-04 Thread Dave S
On Wednesday, May 4, 2016 at 5:32:47 PM UTC-7, Chris Guest wrote: > > Not seeing logging.error in nginx error_log > > > I have a mostly successful install of web2py application with uwsgi and > nginx on centos using setup-web2py-nginx-uwsgi-centos70.sh . > > But I can't figure out how to

[web2py] Not seeing logging.error messages in nginx error_log

2016-05-04 Thread Chris Guest
Not seeing logging.error in nginx error_log I have a mostly successful install of web2py application with uwsgi and nginx on centos using setup-web2py-nginx-uwsgi-centos70.sh . But I can't figure out how to configure nginx, uwsgi and wsgihandler.py so that logging.error messages appear in the

[web2py] Re: web2py 2.14.4 is OUT

2016-05-04 Thread Derek
PYTDS is now DBAPI 2.0 compliant, which means you can now use it with Web2py. It's fully python not dependent on any installed libraries, for your MSSQL needs. That means you can use this in pypy or ironpython as well... On Tuesday, April 12, 2016 at 2:29:26 PM UTC-7, Massimo Di Pierro wrote:

[web2py] Re: View SQL generated by SQLFORM.grid

2016-05-04 Thread Jim S
I did what you suggested and I get this statement: SELECT workorder.workorderId, workorder.parent_workorder, workorder.siteId, workorder.created, workorder.needed, workorder.productId, workorder.productName, workorder.productSiteId, workorder.pullFromStock, workorder.bomId, workorder.quantity,

[web2py] Strange trouble with password_reset

2016-05-04 Thread Kirill Shatalaev
Hello, I'm using web2py 2.14.5-stable+timestamp.2016.04.14.03.26.16 mail = logging for testing purposes. So, controller: def user(): return dict(form=auth()) Registering new user goes as it must. Email verification (this is console output): 2016-05-05 01:21:14,601 - web2py - WARNING -

[web2py] Re: User group names based on username instead of id

2016-05-04 Thread Antonio Salazar
I actually read that section two days ago, when the requirements were still being defined. I don't know why I forgot it. Probably the ominous warning *"The creation of the group can be disabled [...] although we do not suggest doing so."* got me thinking why and the rest slipped my mind. Later

[web2py] Re: User group names based on username instead of id

2016-05-04 Thread Niphlod
http://web2py.com/books/default/chapter/29/09/access-control#Authorization On Wednesday, May 4, 2016 at 9:59:13 PM UTC+2, Antonio Salazar wrote: > > Thank you! > > For some reason I was thinking of this setting as a boolean, and figuring > how to use a callback to rename the group :/ > > P.S.

[web2py] Re: View SQL generated by SQLFORM.grid

2016-05-04 Thread Niphlod
response.toolbar() shows db statistics, I guess is the fastest method out there. On Wednesday, May 4, 2016 at 9:32:10 PM UTC+2, Jim S wrote: > > I pass a query to SQLFORM.grid. Is there a way to see the SQL that last > executed on behalf of the grid? I'm trying to tune my db for the SQL >

[web2py] Re: User group names based on username instead of id

2016-05-04 Thread Antonio Salazar
Thank you! For some reason I was thinking of this setting as a boolean, and figuring how to use a callback to rename the group :/ On Wednesday, May 4, 2016 at 2:01:16 PM UTC-5, Niphlod wrote: > > from the source it seems that the setting > > create_user_groups > > which has a default of > >

[web2py] View SQL generated by SQLFORM.grid

2016-05-04 Thread Jim S
I pass a query to SQLFORM.grid. Is there a way to see the SQL that last executed on behalf of the grid? I'm trying to tune my db for the SQL statement used to show the list of records. -Jim -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: User group names based on username instead of id

2016-05-04 Thread Niphlod
from the source it seems that the setting create_user_groups which has a default of "user_%(id)s" can be used. in your case it seems that setting it to user_%(username)s should do the trick. On Wednesday, May 4, 2016 at 8:48:49 PM UTC+2, Antonio Salazar wrote: > > I've disabled user group

[web2py] User group names based on username instead of id

2016-05-04 Thread Antonio Salazar
I've disabled user group creation, but now I need user-specific permissions, so I'm going to re-enable it and create the missing user groups. I'd really like the groups to be user_[username] instead of user_[user_id]. Is there an upgrade-friendly way to base the group name on something other

[web2py] Re: Enabling Unicode characters in URL

2016-05-04 Thread Leonel Câmara
For functions, specially since in python 2 the identifiers must be ascii. If percent encoded args don't work then that's actually a bug/missing feature of web2py which doesn't unquote args. Please file an issue in github so the devs get properly motivated to close it. In the meantime you will

Re: [web2py] Re: login by ajax

2016-05-04 Thread Val K
Hi! It seems, that ajax_login isn't exist yet? if not user: self.log_event(self.messages['login_failed_log'], request.post_vars) # invalid login session.flash =

[web2py] Re: Enabling Unicode characters in URL

2016-05-04 Thread Kenneth
Hi Niphld, Do I need to configure "routes.py" to accept percent-encoded function? is it "args_match" that I need to configure? Just tried to pass encoded string "%ED%95%9C%EA%B8%80" as argument, I am getting "Invalid request". Thank you. On Wednesday, May 4, 2016 at 8:09:22 AM UTC-4,

[web2py] db is not defined in other model files

2016-05-04 Thread Vic Ding
Hi all, I have a weird problem with web2py on apache. I created db1.py and created defined tables in it and it works fine. I created another model, name is my_list.py and it does not work. Error is db is not defined in my_list.py. Any idea what the problem might be? Thanks! -- Resources: -

[web2py] create file outside of web2py using IDE

2016-05-04 Thread Vic Ding
Hi all, I am using Pycharm together with web2py. I created a model file models/db1.py in IDE and sync it back to the server through SSH. The file is pickup by the server (I can see it in the web IDE) however, I get a complain when visiting the site name 'db' is not defined How can I deal with

[web2py] Re: How to get rows in right format

2016-05-04 Thread Anthony
I'm not sure there is a "standard" way, but if you want to use the DAL API to generate the query, then you'll have to manipulate the data using Python after retrieving the results. Alternatively, you could generate the SQL code manually and use group_concat (if using MySQL or SQLite -- there

Re: [web2py] Re: Flash messages not showing correctly

2016-05-04 Thread Krzysztof Socha
Thanks... It is just this 'tweaking' that I am worried about... It is not always easy to test every functionality of the page to make sure that I have done all the tweaking necessary... Thanks anyway. Krzysztof. On Tue, May 3, 2016 at 5:58 PM, Anthony wrote: > For the most

[web2py] Re: Enabling Unicode characters in URL

2016-05-04 Thread Niphlod
BTW: you NEED to get your hands dirty with routes.py because a percent-encoded fragment won't ever be mapped to a function or a controller. On Wednesday, May 4, 2016 at 1:55:53 PM UTC+2, Leonel Câmara wrote: > > I don't think that's possible, they need to come pre-encoded, don't worry > the

[web2py] Re: Enabling Unicode characters in URL

2016-05-04 Thread Leonel Câmara
I don't think that's possible, they need to come pre-encoded, don't worry the browser will show the unicode characters in the adress bar and not those ugly percents. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: How to add response headers to cache file?

2016-05-04 Thread Antonio
import os cache.disk.folder = os.path.join('/home/minondoa/', 'Appz/web2py/applications/Prueba/') @cache.action(time_expire=21600, cache_model=cache.disk) def index(): #response.headers['Content-Type'] = None response.headers['Access-Control-Allow-Origin'] = request.env.http_origin

[web2py] Re: How to get rows in right format

2016-05-04 Thread Marko Seppälä
I need to do very complex queries. Actually so complex that I don't even know how to do it properly, even though I managed to get it work without list reference. I discussed with one expert yesterday and he recommended not to use list reference in my case. So currently I'm wondering what is