[web2py] Re: web2py.scheduler.hpxyz#2791 - ERROR - we received a task that isn't there (15)

2018-02-27 Thread Pierre
I did the change at line 732 and the error continues to show up (immediate=True). Besides there is another problem i forgot to mention earlier : the scheduler_task and scheduler_run tables are not updated properly. what i do is run a python script using the requests and threading module to perf

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
git clone --recursive web2py repo http address On Tue, Feb 27, 2018 at 1:29 AM, pbreit wrote: > Could someone please confirm for me if I can just do a "git pull" or do I > need to do something else to make sure I also get latest DAL? > > -- > Resources: > - http://web2py.com > - http://web2py.co

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
git clone --recursive https://github.com/web2py/web2py.git On Tue, Feb 27, 2018 at 10:20 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > git clone --recursive web2py repo http address > > On Tue, Feb 27, 2018 at 1:29 AM, pbreit wrote: > >> Could someone please confirm for me if I can

Re: [web2py] Error using Postgres

2018-02-27 Thread Morganti
HI Massimo, I could import psycopg2 in web2py shell manually. I used the installation script inside web2py scripts folder. Bellow the entire error: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "/home/www-data/py27env/we

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
I review my code and found what happen... Somehow this query : db()._select(db.table_name.other_table_id, join=db.table_name.on(db.table_name.other_table_id == db.other_table_name.id )) Return (2.14.6) : SELECT table_name.other_table_id FROM other_table_name JOIN table_name ON (table_name.other

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
Found that which seems related : https://groups.google.com/d/msg/web2py/qYgMQ3rhf5E/U6TIDKUlBgAJ And the initial post refered by villas : https://groups.google.com/d/msg/web2py/KpxWh4ikqG8/cDBbhiK_3F8J There is not seems to have any issue being open for this over pyDAL repository Richard On Tue

[web2py] Re: please help us test trunk web2py

2018-02-27 Thread Leonel Câmara
I believe we deprecated empty queries as they caused way too many problems and bugs (e.g. common filters don't work). -- 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

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
CROSS JOIN get included when there is only one tablecolumn asked db(db.auth_user.id == db.auth_membership.user_id).select(db.auth_user.username, db.auth_membership.group_id) Out[1]: In [2]: db(db.auth_user.id == db.auth_membership.user_id)._select(db.auth_user.username, db.auth_membership.group_

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
In [6]: db(db.auth_user.id > 0)._select(db.auth_membership.group_id, join=db.auth_membership.on(db.auth_user.id == db.auth_membership.user_id)) Out[6]: 'SELECT "auth_membership"."group_id" FROM "auth_user" JOIN "auth_membership" ON ("auth_user"."id" = "auth_membership"."user_id") WHERE ("auth_user"

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
@Leonel, I recall about empty query beeing deprecated... But I can't find any reference to it neither in change log of pyDAL nor web2py change log... Niether the book... Which version of the DAL the support been dropped? Richard On Tue, Feb 27, 2018 at 12:01 PM, Richard Vézina < ml.richard.vez

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
Here : https://github.com/web2py/pydal/issues/388 I think the follow up update to the book and change log never occurs... I am fine with patching my code and make sure I don't leave empty query... But I am curious to know if this "CROSS JOIN table_name" addition could be avoid otherwise than prov

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
At least there is a open issue on the book repo : https://github.com/web2py/web2py-book/issues/346 On Tue, Feb 27, 2018 at 12:57 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Here : https://github.com/web2py/pydal/issues/388 > > I think the follow up update to the book and change log

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
What causing the CROSS JOIN issue had been introduce between pyDAL 16.11 and 17.01 There is a compare of the 2 : https://github.com/web2py/pydal/compare/v16.11...v17.01 Richard On Tue, Feb 27, 2018 at 12:59 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > At least there is a open issu

Re: [web2py] Re: session var in table decimal field throws error on postgres

2018-02-27 Thread Jordan Ladora
Sure, really not much to see.. not sure if this is what you're asking, but I've got the module in the modules folder, and in a model I have- *from _vars import ** ...which throws an error that w2p is unable to find it, so I just use- *from sys import pathpath append('...web2py/applications/in

[web2py] selinux users and roles for homemade task queue

2018-02-27 Thread Jordan Ladora
Hi, I have user apache running w2p, and this user cannot log in, has no directory, etc. I also set selinux user mapping for apache on creation to further limit what it can do. ie- *useradd -s /sbin/nologin -d /dev/null -c 'apache webserver' -Z user_u apache* ...and I use apache to also start

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
In 17.01 line 627 if join and not left: cross_joins = iexcluded + list(itables_to_merge) cross_joins contains both tables involve in the query, which wasn't the case in 16.11 I follow up and it could come from helpers.methods.merge_tablempas() (introduced in 17.01) use in _build_jo

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
Out of _build_joins_for_select() itables_to_merge variable has only one table which is the one implicated in the join (in this case "auth_user")... But another merge_tablemaps() occurs in red below : if join: ( # FIXME? ijoin_tables is never used

[web2py] compiling application ?

2018-02-27 Thread Yoel Benitez Fonseca
Is there a way of compiling a web2py application from the command line ? -- Msc. Yoel Benítez Fonseca -- 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) --- Yo

[web2py] Re: cert-based logins

2018-02-27 Thread Dave S
On Thursday, February 8, 2018 at 12:01:05 AM UTC-8, Dave S wrote: > > I'm considering using cert-based logins for privileged users, and staying > with basic login for less privileged users (the privilege itself is managed > by using auth_groups). > > Any additional thoughts about this? > In