Re: [web2py] Re: debian 10 : mysql Ver 8.0.19 f : mysql_secure_installation

2020-04-23 Thread L c
Thank you again, i was feeling alone . Le mercredi 22 avril 2020 21:11:44 UTC+2, Jim S a écrit : > > I'm happy you got it working. > > -Jim > > On Wed, Apr 22, 2020 at 1:39 PM L c > > wrote: > >> oh i forgot i have hollowed your advice, updating pymysql >> thanks again >> >> Le mercredi 22 avril

[web2py] how to execute web2py with Rocket using SSL?

2020-04-23 Thread VJ Sosa
Hello Everyone, Maybe this is a silly question, but I run web2py using the following command: python3 web2py.py -i 0.0.0.0 -p 8080 --nogui -a 'Password' Everything goes well. My application is working . My application includes an authentication part, and so far it is running on HTTP, so browse

[web2py] Virtual Fields using PyDAL outside of web2py

2020-04-23 Thread Jim S
Given the following: from pydal import DAL from pydal.objects import Field, FieldMethod, FieldVirtual from qlf import util ccfg = util.Config() db = DAL(ccfg.connect_db.dal_string, migrate=False, pool_size=5) db.define_table('workorder', Field('parent_workorder', 'reference workor

Re: [web2py] Re: Beginners question on Authentication ...

2020-04-23 Thread Jon Paris
Responses in-line Jim - but before I get to that I really want to thank you for your assistance and patience. I now have to give some serious thought to whether following this document is a worthwhile exercise as it seems to be so far off the mark as far as the current version is concerned. O

[web2py] Re: Virtual Fields using PyDAL outside of web2py

2020-04-23 Thread Jim S
I should also mention that I have been looking at this post, but can't see what I'm doing wrong.. https://groups.google.com/forum/?pli=1#!newtopic/web2py/web2py/PpouIgeIwX8 On Thursday, April 23, 2020 at 9:41:23 AM UTC-5, Jim S wrote: > > Given the following: > > from pydal import DAL > from py

Re: [web2py] Re: Beginners question on Authentication ...

2020-04-23 Thread Jim S
Jon I'd really encourage you to not give up on this. I think your assessment is correct; there have been a lot changes to the code since that doc was originally written and it might be hard to navigate. I went through it back in 2011, I read it from front to back before even trying to code wi

Re: [web2py] Beginners question on Authentication ...

2020-04-23 Thread Jon Paris
Thanks Jim - I appreciate it. Yes - I keep forgetting that for some reason Python has redefined a lot of terms. Dictionaries confused me until I realized that they were pretty much the same as keyed arrays in PHP and other languages. Not sure why so much relabelling but it certainly makes the l

Re: [web2py] Beginners question on Authentication ...

2020-04-23 Thread Jim S
I've played with it a bit. After using web2py, I miss some of the web2py features that aren't there in py4web. SQLFORM.grid is the biggest one. I use that all over the place. I think Massimo is working on something similar in py4web but I haven't seen it yet. For those of us with large web2

[web2py] Re: Virtual Fields using PyDAL outside of web2py

2020-04-23 Thread Massimiliano
Maybe you miss fieldname: db.workorder.children = Field.Virtual(*fieldname*, lambda row: db(db. workorder.parent_workorder == row.id).select()) On Thursday, April 23, 2020 at 4:41:23 PM UTC+2, Jim S wrote: > > Given the following: > > from pydal import DAL > from pydal.objects import Field, Fie

[web2py] Re: Virtual Fields using PyDAL outside of web2py

2020-04-23 Thread Jim S
Massimiliano Thanks for the reply. Adding the fieldname didn't help, but pushed me to look again at the other post I'd referenced. In it I missed adding the tablename to the row.id. It should be row.workorder.id. I made that change and now it works. So, the solution is: db.workorder.child

[web2py] Re: how to execute web2py with Rocket using SSL?

2020-04-23 Thread VJ Sosa
I have tried the same command, running web2py with python 2.7.17 and it works: python web2py.py -c web2py.crt -k web2py.key -i 0.0.0.0 -p 8080 --nogui -a 'Password' The problem occurs when running web2py with python3. I found the same discussion in this link < here

[web2py] Re: how to execute web2py with Rocket using SSL?

2020-04-23 Thread Jim S
What is your version of web2py? -Jim On Thursday, April 23, 2020 at 11:12:02 AM UTC-5, VJ Sosa wrote: > > I have tried the same command, running web2py with python 2.7.17 and it > works: > > python web2py.py -c web2py.crt -k web2py.key -i 0.0.0.0 -p 8080 --nogui -a > 'Password' > > > The proble

[web2py] Re: how to execute web2py with Rocket using SSL?

2020-04-23 Thread VJ Sosa
Hi, Thanks for asking: Web2py Version 2.18.5-stable+timestamp.2019.04.08.04.22.03 Python version: 3.6.9 Regards, Víctor El jueves, 23 de abril de 2020, 19:05:17 (UTC+2), Jim S escribió: > > What is your version of web2py? > > -Jim > > On Thursday, April 23, 2020 at 11:12:02 AM UTC-5, VJ Sosa w

[web2py] Re: how to execute web2py with Rocket using SSL?

2020-04-23 Thread Jim S
VJ I just ran a test and can confirm I'm getting the same results as you. I just cloned the latest web2py from git. I ran under Python 2.7 and it worked fine. Running under Python 3.7 and I get results like you. To do a little debugging, I put a print statement ahead of line 105 in gluon/rocke

[web2py] How do I hide automatically generated child columns in web2py's SmartGrid?

2020-04-23 Thread Andrew Rogers
(I also asked this question here https://stackoverflow.com/questions/61402508/how-do-i-hide-child-columns-in-web2pys-smartgrid ) I love the way web2py smartgrid creates automatic child links to referenced tables. But i can't find how to customise them. I want to show only some of the child tabl

[web2py] Re: How do i get mu download function to download my image with its original name

2020-04-23 Thread Dave S
On Saturday, April 18, 2020 at 8:57:59 AM UTC-7, mostwanted wrote: > > I want to download an image but i want it to download with its originally > saved name, is there a way I can modify my download function to do this? So > far its downloading properly as desired its just that its renaming ima