Re: [web2py] Re: web2py -> py4web

2024-07-21 Thread Chitti Siva
Hi, Why are you adding in this mail loop and why you reply on this mail. Please remove my mail in this mail loop. Thank & Regards, Siva Chitti. On Thu, 18 Jul, 2024, 6:57 pm xgp.l...@gmail.com, wrote: > Hi Massimo. > > At the moment I haven't moved to py4web. I would like you to consider > sup

Re: [web2py] Re: web2py -> py4web

2024-07-16 Thread Carlos Correia
Hi, Moving to Python 3 is a must! As for Web2py I have several servers using it (one of them is an ERP) and I don't know when I will have time to move them to Py4web, so I beg you not to drop Web2py support. Best regards, Carlos Às 04:49 de 17/07/24, Massimo Di Pierro escreveu: It is very

Re: [web2py] Re: web2py -> py4web

2024-07-15 Thread Christian Varas
Hi Massimo, In my case I have still one app in production using web2py, I haven’t migrated yet because is quite big. For the rest of my apps, are all migrated to py4web and they work so much faster :). In my opinion, drop the support of python 2.7 is recommended to avoid security issues, and also

Re: [web2py] Re: Application Issues After MySQL Database Update

2024-06-01 Thread sandeep patel
Thank you @villas for guidance. I'm pleased to inform you that I have identified and fixed the problem. The application is now running smoothly. Many Thanks SP~ On Thu, May 30, 2024 at 5:25 PM villas wrote: > As this error seems to indicate a mismatch in the expected char set of the > data. >

Re: [web2py] Re: web2py 2.26.1 released

2023-10-30 Thread Jim S
I highly recommend moving to py4web. These days I dread working on web2py apps we haven't yet converted to py4web. py4web is so much faster for execution and development. Much more flexibility in form and grid layouts. If there is something missing, let us know, we'd love to get more people

Re: [web2py] Re: web2py 2.26.1 released

2023-10-30 Thread Christian Varas
In my opinion Web2py is really comfortable but I strongly recommend to move to py4web. The scheduler in web2py is replaced with celery which is more powerful and py4web framework is really fast, light and is easy to code like in web2py. I’ve moved all my apps from web2py to py4web and I can’t compl

Re: [web2py] Re: web2py 2.26.1 released

2023-10-30 Thread António Ramos
I´m so comfortable with web2py, the admin dashboard and the scheduler are blocking me from moving to py4web... Regards Em seg., 30 de out. de 2023 às 04:48, Raul Monares escreveu: > Great news. I appreatiate your work on both platforms > > On Sunday, October 29, 2023 at 3:13:31 PM UTC-6 Massimo

Re: [web2py] Re: app not loading external python library

2023-10-27 Thread Al Ex
pip install urllib3_secure_extra in my virtual env solved the problem. Thank you Tom for pointing to the solution, I had missed that thread. On October 27, 2023 at 16:59:18, Tom Clerckx (tcler...@gmail.com) wrote: I think this is the same issue as was discussed a few months ago: See this threa

Re: [web2py] Re: AssertionError: Header names/values must be of type str

2023-10-25 Thread Massimo DiPierro
Can you try once more? On Wed, 25 Oct 2023 at 23:03, Al Ex wrote: > I tried with a new installation of web2py > > $ git clone --recursive https://github.com/web2py/web2py.git > > > It gives the same error > > * > ERROR:Rocket.Errors.Thread-11:T

Re: [web2py] Re: uwsgi with web2py hard crash/locking with nginx

2023-10-17 Thread Christian Varas
While I can't provide a specific solution, it might be a better approach to keep resource-intensive tasks separate from web2py, using a tool like Celery. This way, these tasks can run in the background without impacting the web server. This is a small docx about how to put it together: https://doc

Re: [web2py] Re: How do I query and display Authors and their respective books

2023-10-11 Thread Sh. Moiz Sh. Husain Bhai Nagpurwala
Thanks for the reply. It addresses my question. Thanks and Regards. On Wed, 11 Oct 2023, 12:27 Clemens, wrote: > Hello, > > all you need to know (including examples) is described here: > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation > >

Re: [web2py] Re: administrator login with 2fa

2023-09-03 Thread Clemens
Well, having a method reporting problems is great. My solution is primarily pragmatic: In case move the controllers in and analyse otherwise having them out of access. After migrating to py4web I will think of such error mailing controller, sounds interesting. On Friday, September 1, 2023 at 8

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
And to second your comment, I too have a controller method that allows users with the proper access, the ability to add additional users. The only other reason I would want to access admin is to look at error messages/tickets. But, I have some method in place to read the error messages and for

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
If I try to go to admin/appadmin web2py returns: Admin is disabled because insecure channel Isn't that just the default behavior? -Jim On Friday, September 1, 2023 at 1:00:08 PM UTC-5 Clemens wrote: > I don't and I that's why I (re)move these to a hidden folder on system > level :-) What I ne

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Clemens
I don't and I that's why I (re)move these to a hidden folder on system level :-) What I need is to give customers the option to add new users by themselves. For that I've written a small controller under the control of 2FA and so on. Regards Clemens On Friday, September 1, 2023 at 7:40:19 PM

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
I'm just curious Why do you need access to the admin/appadmin apps in a production environment? I've never used them there. I use in development, but never production -Jim On Friday, September 1, 2023 at 11:54:02 AM UTC-5 Clemens wrote: > Removing the admin app as well as the appadmin contr

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Clemens
Removing the admin app as well as the appadmin controllers should kill all options of administration. Move these to two to a folder away from web2py. And then you can still call https://.../admin/site or https://.../appadmin? On Friday, September 1, 2023 at 6:44:31 PM UTC+2 Ramos wrote: > yes i

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread António Ramos
yes i tried it on the admin app and it just does not work. :) Em sex., 1 de set. de 2023 às 16:53, Jim S escreveu: > So, are you trying to protect the 'admin' application with 2fa? > > If so, can you add the 2fa code to the admin app? > > I haven't tried this before > > On Friday, September 1,

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Clemens
Sorry for not answering any earlier - too much work. Well, in my application (which is in production) I've solved the problem as follows: I've written a controller fully under my control (including 2FA and groups) with just the administration functions I need (users, groups and a rights system

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
So, are you trying to protect the 'admin' application with 2fa? If so, can you add the 2fa code to the admin app? I haven't tried this before On Friday, September 1, 2023 at 10:24:29 AM UTC-5 Ramos wrote: > this admin > > https://mysite.com/admin > > Em sex., 1 de set. de 2023 às 16:08, Jim S

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread António Ramos
this admin https://mysite.com/admin Em sex., 1 de set. de 2023 às 16:08, Jim S escreveu: > What does 'administrator password' mean to you? > > I'm not sure what you're referring to > > -Jim > > On Friday, September 1, 2023 at 9:53:43 AM UTC-5 Ramos wrote: > >> Hello Jim >> this line of code >>

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
What does 'administrator password' mean to you? I'm not sure what you're referring to -Jim On Friday, September 1, 2023 at 9:53:43 AM UTC-5 Ramos wrote: > Hello Jim > this line of code > *auth.settings.auth_two_factor_enabled = True* > *does not protect the administrator password. Only create

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread António Ramos
Hello Jim this line of code *auth.settings.auth_two_factor_enabled = True* *does not protect the administrator password. Only created users.* *That is my question, how to force administrator to use 2fa ?* *regards* *António* Em sex., 1 de set. de 2023 às 15:00, Jim S escreveu: > Here is the code

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread Jim S
Here is the code I wrote that only enforced 2fa for users outside our local networks. There is some commented out code there that additionally allowed me to specify users in a group so only that group was force to 2fa def _two_factor_required(auth_user): """ check whether we need to enf

Re: [web2py] Re: administrator login with 2fa

2023-09-01 Thread António Ramos
Anyone can help me ? Em qua., 30 de ago. de 2023 às 10:14, António Ramos escreveu: > in other words, how do i protect the administrator password? it does not > have a username , just a password. This is scary :) > > > Em ter., 29 de ago. de 2023 às 19:44, António Ramos > escreveu: > >> But that

Re: [web2py] Re: administrator login with 2fa

2023-08-30 Thread António Ramos
in other words, how do i protect the administrator password? it does not have a username , just a password. This is scary :) Em ter., 29 de ago. de 2023 às 19:44, António Ramos escreveu: > But that is for everyone, i just want to start with users with admin > powers > > Clemens escreveu em ter

Re: [web2py] Re: administrator login with 2fa

2023-08-29 Thread António Ramos
But that is for everyone, i just want to start with users with admin powers Clemens escreveu em ter., 29/08/2023 às 18:25 : > Try enabling 2FA via the following setting, since this is for all users: > *auth.settings.auth_two_factor_enabled = True* > > Regards > Clemens > > On Tuesday, August 29,

Re: [web2py] Re: Latest version of web2py and python versions

2022-12-30 Thread Davidiam
Thanks ! Sent from Outlook for Android From: web2py@googlegroups.com on behalf of Leonel Câmara Sent: Wednesday, December 28, 2022 5:14:56 PM To: web2py-users Subject: [web2py] Re: Latest version of web2py and python versions You can us

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
Logging problem solved! Finally! Turns out it was just that web2py is using the file error.log for the wsgi output, while apache (httpd) is using error_log. In case this helps anyone else, on the homebrew version of httpd the log files are located in /opt/homebrew/var/log/httpd So my local ap

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
Okay, my one remaining problem is logging output. I'm using the default logging settings for web2py, and it usually is output in the apache error log. But nothing appears in the error log for my mac installation of apache (homebrew version of httpd). The apache server notices are showing up ther

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
Thanks Massimiliano. I've used local Apache for years so that I can test things like ssl and some routing that are done at the server level. But I've always done it on Linux, and I'm learning that mac is quite different. I've got mod_wsgi set up and working, but I think the issue may just be t

Re: [web2py] Re: Help on macos

2022-12-23 Thread Massimiliano
Sorry I didn't notice that you use apache. Can I ask you why? In my dev machine I use the web2py internal server for simplicity. Anyway have you setup uwsgi to use the right python? Il giorno ven 23 dic 2022 alle ore 09:22 Massimiliano ha scritto: > How do you start web2py? > > Il giorno ven 23

Re: [web2py] Re: Help on macos

2022-12-23 Thread Massimiliano
How do you start web2py? Il giorno ven 23 dic 2022 alle ore 03:39 Ian W. Scott ha scritto: > So it looks like it's a problem importing python modules. I'm using a > virtualenv (pyenv) and web2py isn't finding the modules I installed for > this version. There may be other issues too (since the lo

Re: [web2py] Re: how to point web2py to python3.9 not python3.8?

2022-11-30 Thread lucas
hey massimo, thanks for responding and mine is below. which got me thinking about installing a new version of uwsgi. so i first installed python39-devel using: *yum install python39-devel* then i ran: *pip install uwsgi* and restarted the web services on the server and web2py is not using

Re: [web2py] Re: how to point web2py to python3.9 not python3.8?

2022-11-30 Thread Massimiliano
If you use systemd to start uwsgi, check what uwsgi is started Take a look here: cat /etc/systemd/system/multi-user.target.wants/uwsgi.service mine: [Unit] Description=uWSGI Web2Py After=network.target [Service] ExecStart=*/home/www-data/.pyenv/shims/uwsgi* --ini /home/www-data/uwsgi/w2p.ini #

Re: [web2py] Re: Reset Password does not send email

2022-11-27 Thread Silvian Cedru
Thanks for the information yeah I found it need create an extra app for it . Am Mo., 28. Nov. 2022 um 06:15 Uhr schrieb Maxi < maximiliano.dua...@gmail.com>: > Remember that gmail no longer allows sending emails directly, you must > create an exclusive key for that service. (Less secure applicati

Re: [web2py] Re: Reset Password does not send email

2022-11-27 Thread Maxi
Remember that gmail no longer allows sending emails directly, you must create an exclusive key for that service. (Less secure applications previously) You must enter the configuration and create a key for the service you want, you can have several keys. Recuerden que gmail no permite mas el envio

Re: [web2py] Re: Issue password in plain text before sending when login in the website via HTTPS

2022-11-25 Thread Silvian “Top 10 Answers” Cedru
Hello Chris, thanks for the detailed information appreciate it. chriii...@gmail.com schrieb am Donnerstag, 24. November 2022 um 03:24:06 UTC+7: > Hello. > > TLS is enough to encrypt and secure the connection, the whole point of > HTTPS protocol is to make a clear text channel secure. > > If

Re: [web2py] Re: Issue password in plain text before sending when login in the website via HTTPS

2022-11-23 Thread Christian Varas
Hello. TLS is enough to encrypt and secure the connection, the whole point of HTTPS protocol is to make a clear text channel secure. If someone is sniffing your HTTPS connection, will be not able to read the traffic, except if the attacker performs a Man In the Middle and replace the TLS certific

Re: [web2py] Re: Issue password in plain text before sending when login in the website via HTTPS

2022-11-23 Thread Arglanir
Hello, It is a big question, and does not concern only web2py. You can find people asking the same general question in StackOverflow. And the aswers are generic : The most important is the TLS communication. https://security.stackexchange.com/questions/110415/is-it-ok-to-send-plain-text-password-

Re: [web2py] Re: Issue password in plain text before sending when login in the website via HTTPS

2022-11-21 Thread Silvian Cedru
Thank you, but do you have any suggestions what to do cause our cybersecurity officer keeps complaining about that wo I need change some settings in web2py or do you have an idea how I can sort it out ? Kind regards Am Di., 22. Nov. 2022 um 02:23 Uhr schrieb Christian Varas < chriiisti...@gmail.c

Re: [web2py] Re: Issue password in plain text before sending when login in the website via HTTPS

2022-11-21 Thread Christian Varas
Hi, It's OK, it's the way it works, If you put s local proxy like burp and then you go and capture traffic, it is ok that you can see clear text data because burp proxy puts their own certificate between client and backend, because of that burp proxy can decrypt and show you clear text data. If you

Re: [web2py] Re: Reset Password does not send email

2022-11-14 Thread Silvian Cedru
thank you Jim I will give it a try I will let you know Am Mo., 14. Nov. 2022 um 22:20 Uhr schrieb Jim Steil : > Here is what google wants for smtp settings: > > [image: image.png] > > For web2py you need to set > > server = "smtp.gmail.com:465" # assuming you're using ssl > sender = "your_emai

Re: [web2py] Re: Reset Password does not send email

2022-11-14 Thread Jim Steil
Here is what google wants for smtp settings: [image: image.png] For web2py you need to set server = "smtp.gmail.com:465" # assuming you're using ssl sender = "your_email_address" login = "username:password" # where password is a gmail app password, assuming you have 2FA enabled on your gmai

Re: [web2py] Re: Reset Password does not send email

2022-11-11 Thread Silvian Cedru
Yeah that is what I tried to do but I am not really sure where I enter all the details I got the smtp IP from my own mailserver but I am not really sure where I need to pass the username and data trough do you have any idea ? Am Fr., 11. Nov. 2022 um 22:27 Uhr schrieb Jim S : > Are you passing a

Re: [web2py] Re: Issue with admin acess web2py after deploying on a live server

2022-11-07 Thread Silvian “Top 10 Answers” Cedru
Thanks for the Help appreciate it. Massimiliano schrieb am Montag, 7. November 2022 um 17:48:58 UTC+7: > The password is stored in "parameters_8000.py" that you can change with > > python web2py.py -a 'your password' > > http://web2py.com/books/default/chapter/29/04/the-core#Command-line-options

Re: [web2py] Re: Issue with admin acess web2py after deploying on a live server

2022-11-07 Thread Massimiliano
The password is stored in "parameters_8000.py" that you can change with python web2py.py -a 'your password' http://web2py.com/books/default/chapter/29/04/the-core#Command-line-options Il giorno lun 7 nov 2022 alle ore 11:17 Silvian “Top 10 Answers” Cedru < silvian.ce...@gmail.com> ha scritto:

Re: [web2py] Re: pbkdf2(1000,20,sha512)$etc... in v2.22.5

2022-08-19 Thread Jim S
I think we'll need help from someone who knows more about this than I do. -Jim On Friday, August 19, 2022 at 6:27:15 AM UTC-5 lucas wrote: > ok, i am trying to understand. i'm using web2py 2.22.5 under centos 8 in > console only mode. i searched all of my application files and there is no >

Re: [web2py] Re: pbkdf2(1000,20,sha512)$etc... in v2.22.5

2022-08-19 Thread lucas
ok, i am trying to understand. i'm using web2py 2.22.5 under centos 8 in console only mode. i searched all of my application files and there is no hint of auth.settings.hmac_key = "such and such". when i access auth, session, request, etc., i can see an hmac_key key in auth.settings but it i

Re: [web2py] Re: pbkdf2(1000,20,sha512)$etc... in v2.22.5

2022-08-18 Thread Jim S
I must be misunderstanding something, because that is what I thought I just showed. hashed_password = str(CRYPT(key="pbkdf2(1000,20,sha512):whatever-your-hash-string-is")(plain_text_password)[0]) "whatever-your-hash-string-is needs" to be the same as what you're assigning to auth.settings.hma

Re: [web2py] Re: pbkdf2(1000,20,sha512)$etc... in v2.22.5

2022-08-18 Thread lucas
ok, that sets up the web2py environment. i'm asking how to reproduce or generate the hashed key from regular text within a separate shell script. lucas On Thursday, August 18, 2022 at 8:53:38 AM UTC-4 Jim S wrote: > It should be the same as auth.settings.hmac_key, probably set in db.py > > au

Re: [web2py] Re: pbkdf2(1000,20,sha512)$etc... in v2.22.5

2022-08-18 Thread Jim Steil
It should be the same as auth.settings.hmac_key, probably set in db.py auth.settings.hmac_key = ( "sha512:whatever-your-has-string-is" # before define_tables() ) On Thu, Aug 18, 2022 at 7:44 AM lucas wrote: > but how do you generate the hash string from the regular text string? > > On Th

Re: [web2py] Re: sessions folder under application

2022-07-13 Thread Dave S
On Thursday, July 7, 2022 at 1:07:02 AM UTC-7 Niphlod wrote: > there's an handy session cleaner web2py/sessions2trash.py at master · > web2py/web2py (github.com) > and > a whole section in the docs web2py - Deployment

Re: [web2py] Re: sessions folder under application

2022-07-07 Thread Eliezer (Vlad) Tseytkin
Oops, I missed this section. Thank you very much On Thu, Jul 7, 2022, 4:07 AM Niphlod wrote: > there's an handy session cleaner web2py/sessions2trash.py at master · > web2py/web2py (github.com) > and > a whole section in

Re: [web2py] Re: sessions folder under application

2022-07-07 Thread Niphlod
there's an handy session cleaner web2py/sessions2trash.py at master · web2py/web2py (github.com) and a whole section in the docs web2py - Deployment recipes

Re: [web2py] Re: sessions folder under application

2022-07-06 Thread Eliezer (Vlad) Tseytkin
Invalidating existing sessions is not a problem; they can login again. As long as it doesn't break things... Thank you, Jim! On Wed, Jul 6, 2022, 9:20 AM Jim S wrote: > I believe that you can. > > However, this will invalidate all active sessions and all active users > will have to log in agai

Re: [web2py] Re: Pillow not imported by web2py-win

2022-05-12 Thread Dave S
On Monday, May 9, 2022 at 5:19:42 PM UTC-7 Dave S wrote: > On Sunday, May 8, 2022 at 1:55:52 AM UTC-7 nico...@gmail.com wrote: > >> Hi Dave, >> >> the simplest solution is surely to use web2py from source - and it's even >> better on py3 if possible. >> >> If you're stick with the frozen app (apa

Re: [web2py] Re: Pillow not imported by web2py-win

2022-05-09 Thread Dave S
On Sunday, May 8, 2022 at 1:55:52 AM UTC-7 nico...@gmail.com wrote: > Hi Dave, > > the simplest solution is surely to use web2py from source - and it's even > better on py3 if possible. > > If you're stick with the frozen app (apart from my simple guide on this at > https://github.com/nicozanf

Re: [web2py] Re: Pillow not imported by web2py-win

2022-05-08 Thread Nico Zanferrari
Hi Dave, the simplest solution is surely to use web2py from source - and it's even better on py3 if possible. If you're stick with the frozen app (apart from my simple guide on this at https://github.com/nicozanf/web2py-pyinstaller/blob/master/HOWTO-modules.md), I don't have any special advise -

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-04-04 Thread Rahul
Hey All, This is *finally fixed.* I spent some time debugging on it today. The fix was actually very simple, all I had to do was to convert some values to integer. Here is the final fixed version on *plugin_solidform.py. *For all the folks who want to use this awesome plugin with pyt

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-04-03 Thread Dave S
On Friday, March 25, 2022 at 11:14:07 PM UTC-7 Rahul wrote: > yes I used some things like *trunc *or *ceil *to fix it however the error > persists on the same line. Pretty weird. Also used what was suggested like > // > but did not work for me. I want to get this fixed soon. However, > If it

Re: [web2py] Re: Centos 7 uwsgi no driver for psycopg2

2022-04-03 Thread urban....@gmail.com
I think we've somehow solved this issue. I will report back tomorrow or when I'm sure what exactly we did. On Saturday, April 2, 2022 at 8:29:32 AM UTC+2 Clemens wrote: > I think, that Jims answer is right. Have a try sudo-pip psycopg2 (--> sudo > -H) > > Regards > Clemens > > On 31.03.22 18:

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-04-02 Thread Rahul
Do we have alternatives to this feature ? Rahul On Saturday, March 26, 2022 at 11:44:07 AM UTC+5:30 Rahul wrote: > yes I used some things like *trunc *or *ceil *to fix it however the error > persists on the same line. Pretty weird. Also used what was suggested like > // > but did not work f

Re: [web2py] Re: Centos 7 uwsgi no driver for psycopg2

2022-04-01 Thread Dr. Clemens R. Odendahl
I think, that Jims answer is right. Have a try sudo-pip psycopg2 (--> sudo -H) Regards Clemens On 31.03.22 18:33, urban@gmail.com wrote: Am I correct in assuming this error is occurring because python is u

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-03-25 Thread Rahul
yes I used some things like *trunc *or *ceil *to fix it however the error persists on the same line. Pretty weird. Also used what was suggested like // but did not work for me. I want to get this fixed soon. However, If its not possible to fix it "quickly" perhaps someone can suggest me some

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-03-24 Thread Dave S
On Thursday, March 24, 2022 at 3:21:01 AM UTC-7 Massimiliano wrote: > This could be one problem: > > for i in range((max_row_lines - extra_colspan) / colspan): > > there are many of this. > > *range* take an integer, but a division in python3 return a float... > > Interesting, but why doesn't t

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-03-24 Thread Massimiliano
This could be one problem: for i in range((max_row_lines - extra_colspan) / colspan): there are many of this. *range* take an integer, but a division in python3 return a float... Il giorno gio 24 mar 2022 alle ore 09:47 Rahul ha scritto: > anyone has any ideas ? > > On Wednesday, March 23,

Re: [web2py] Re: left outer join

2022-02-20 Thread Jonathan Clark
Hi, Sorry I hadn't noticed that was what you meant. I was just trying to say that the book has a section on left joins, like many other topics, which you might not have seen. It's a long time since I looked at this, but I thought you could treat a select as a table for this kind of thing, but I'v

Re: [web2py] Re: left outer join

2022-02-20 Thread Al Ex
Thank you But what if the left join is made on an arbitrary select, not an already defined table? Maybe I am missing something evident On February 20, 2022 at 18:15:50, jonatha...@whatho.net ( jonathan.cl...@whatho.net) wrote: http://www.web2py.com/books/default/chapter/29/06/the-database-abs

Re: [web2py] Re: LOAD in py4web

2022-02-17 Thread cdbaron
Thanks a lot. I'll try load_and_trap, but I think htmx may be better. I will look at your applications. El jueves, 17 de febrero de 2022 a las 0:10:33 UTC+1, Jim S escribió: > See this thread for how to replicate LOAD in py4web - > https://groups.google.com/u/1/g/py4web/c/EUpv9IRJ_eo/m/niHzrnR

Re: [web2py] Re: LOAD in py4web

2022-02-16 Thread Jim S
See this thread for how to replicate LOAD in py4web - https://groups.google.com/u/1/g/py4web/c/EUpv9IRJ_eo/m/niHzrnR5AwAJ In short, use load_and_trap from utils.js. I was using this for a while but then transitioned to doing all my reactive-type functions using htmx. https://htmx.org Check ou

Re: [web2py] Re: LOAD in py4web

2022-02-15 Thread cdbaron
I have several projects with web2py and I have already started to study the possibility of migrating to py4web. They are all rendered on the server side and for now I want to keep it that way. I see some challenges that make me a little scared: *LOAD * A Helper: (many times with the callback p

Re: [web2py] Re: LOAD in py4web

2022-02-06 Thread Alexei Vinidiktov
Have you managed to make a welcome template based on Unpoly? On Wednesday, March 4, 2020 at 8:37:51 PM UTC+7 yamand...@gmail.com wrote: > Sorry for the typo. > I want to make a welcome template based on unpoly soon. > > Em sex., 28 de fev. de 2020 às 04:21, AGRogers > escreveu: > >> https://unp

Re: [web2py] Re: DataTable() not a function

2021-12-23 Thread Jim Steil
If you look at your page source can you see what is being rendered for [[=results]] in your script section? Jim On Thu, Dec 23, 2021, 6:38 PM Dave S wrote: > > On Tuesday, December 21, 2021 at 1:05:08 PM UTC-8 Jim S wrote: > >> I wish I could help, but I'm not javascript guru. That's why I've

Re: [web2py] Re: Error ticket for "admin" when trying to create a view

2021-12-20 Thread Dave S
On Friday, December 17, 2021 at 9:12:55 AM UTC-8 mostwanted wrote: > This is happening on a live app, its live, hosted on pythonanywhere. I am > starting to suspect something though, I recently received an email from > pythonanywhere.com informing me that I should change the system image of >

Re: [web2py] Re: Error ticket for "admin" when trying to create a view

2021-12-17 Thread Jim Steil
Yes, I would suspect the image off that is the main thing that changed. Jim On Fri, Dec 17, 2021, 11:13 AM mostwanted wrote: > This is happening on a live app, its live, hosted on pythonanywhere. I am > starting to suspect something though, I recently received an email from > pythonanywhere.com

Re: [web2py] Re: Error ticket for "admin" when trying to create a view

2021-12-17 Thread mostwanted
This is happening on a live app, its live, hosted on pythonanywhere. I am starting to suspect something though, I recently received an email from pythonanywhere.com informing me that I should change the system image of my app because my app is running on an old one called "dangermouse", in a y

Re: [web2py] Re: Error ticket for "admin" when trying to create a view

2021-12-17 Thread Jim Steil
Is it possible your were no longer logged in or that you cleared your browser cache before this happened? Sense really weird. Have you tried with a fresh install of web2py? Jim On Fri, Dec 17, 2021, 5:56 AM mostwanted wrote: > But that's just the thing, I wasn't trying pass any data, i just tr

Re: [web2py] Re: Displaying database information without repeating details

2021-10-28 Thread Massimiliano
You need to create an alias for your field. Look here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=count%28%29#sum-avg-min-max-and-len Massimiliano Il 28 ott 2021, 11:15:48, mostwanted ha scritto: > I am able to group them up using *(groupby) *e.g > (*

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-09 Thread Davidiam
We tried the parameters that were recommended in the link of @Niphlod 's post, but the error is still occurring. What is strange is the error occurs after only about 3 seconds, so there may be something else happening here. I will try to get the developer to comment on this thread as he knows

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-06 Thread Davidiam
Thanks, I was out for a week and just see your reply now. I will try that. On Thursday, September 2, 2021 at 9:34:56 AM UTC+2 Niphlod wrote: > the timeout is part of rocket webserver, not web2py. if you're running > fastcgi, that's where you want to set a timeout: as configuration in IIS > (se

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-02 Thread Dave S
Good to hear from you again! Keeping busy? /dps On Thursday, September 2, 2021 at 12:34:56 AM UTC-7 Niphlod wrote: > the timeout is part of rocket webserver, not web2py. if you're running > fastcgi, that's where you want to set a timeout: as configuration in IIS > (see python - How do I sto

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-02 Thread Niphlod
the timeout is part of rocket webserver, not web2py. if you're running fastcgi, that's where you want to set a timeout: as configuration in IIS (see python - How do I stop FastCGI process exceeding the configured request timeout - Stack Overflow

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-01 Thread Davidiam
I would like to increase the timeout parameters to see if it resolves some issues we are having with internal server error messages. Get Outlook for Android From: web2py@googlegroups.com on behalf of Niphlod Sent: Wednesday, September 1,

Re: [web2py] Re: sqlform insert row id

2021-07-01 Thread Javier Pepe
http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-and-insert-update-delete In form.vars.id store Last ID inserted El jue., 1 de julio de 2021 15:47, Dave S escribió: > > > On Wednesday, June 30, 2021 at 11:35:29 PM UTC-7 Clemens wrote: > >> the insert returns the id of

Re: [web2py] Re: string validation

2021-05-13 Thread Manuele
Thanks for the valuable advice about the regex! This is my solution: https://gist.github.com/manuelep/19a0e9ab6723086fdbf1ffa8e858a5f9 Cheers     Manuele Il 12/05/21 19:08, Raul Monares ha scritto: I found this code on the web # Python code to find the URL from an input string # Using the

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread António Ramos
I didnt because the problem was not in that table. I was looking to the wrong table. Thk u Kevin Keller escreveu em seg., 15/02/2021 às 18:58 : > How did you solve it? > > On Mon, Feb 15, 2021, 17:33 António Ramos wrote: > >> Thank you Jim but i found the problem. >> My fault this time. >> Than

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread Kevin Keller
How did you solve it? On Mon, Feb 15, 2021, 17:33 António Ramos wrote: > Thank you Jim but i found the problem. > My fault this time. > Thank you again. > > PS. Its just me or this forum is abandoned? Should i go elsewhere for help > ? > > Em seg., 15 de fev. de 2021 às 15:46, António Ramos > e

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread António Ramos
Once again thank you Jim for your patience :) Regards from Portugal António Em seg., 15 de fev. de 2021 às 16:59, Jim S escreveu: > No, this forum has not been abandoned. I think the issue may be that most > of us are now spending a much greater amount of time with py4web. That, > and in my c

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread Jim S
No, this forum has not been abandoned. I think the issue may be that most of us are now spending a much greater amount of time with py4web. That, and in my case anyway, I shied away from this question because I haven't used web2py in a restful manner before so wasn't sure I had anything to of

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread António Ramos
Thank you Jim but i found the problem. My fault this time. Thank you again. PS. Its just me or this forum is abandoned? Should i go elsewhere for help ? Em seg., 15 de fev. de 2021 às 15:46, António Ramos escreveu: > Hi Jim > Sorry but dont understand your suggestion. > You mean auth.requires_l

Re: [web2py] Re: Programatically create Row

2021-02-15 Thread Jacinto Parga
So, do you want to storage a dummy row to be proccessed in the same controler or to be passed to another controller or function?. I mean, if you want to use it in the same controller why not a local variable to storage it.. If you have used a SQLFORM. factory to get the values they are storage

Re: [web2py] Re: auth.signature not working

2021-02-15 Thread António Ramos
Hi Jim Sorry but dont understand your suggestion. You mean auth.requires_login() on my restful function like this @auth.requires_login() ? @request.restful() def uploadInvoice(): Does it make sense? Its going to be called by external script. Inside my uploadInvoice i have user = auth.login_bar

Re: [web2py] Re: Programatically create Row

2021-02-13 Thread David Orme
Thanks for the suggestion. I don't need to create the form programmatically - the factory is great for that. I've already got code to create the form but want to create a dummy row on the server side to populate a display example form. Cheers, David On Sat, 13 Feb 2021, 08:37 Jacinto Parga, wrot

Re: [web2py] Re: can i delete sql.log?

2021-02-11 Thread António Ramos
Thank u Em qua., 10 de fev. de 2021 às 23:38, cdbaron escreveu: > Sql.log is an informative file, if you delete it, it will be created again. It > does not affect the operation of the applications. In this file, SQL > queries of the DB migrations are stored. > > El martes, 9 de febrero de 2021 a

Re: [web2py] Re: fake_migration issues

2021-02-10 Thread António Ramos
I have started another post with apparently the same problem. as i have a production app i cant wait much longer so if anyone can help me professionaly with this please contact me privately. Regards Em dom., 31 de jan. de 2021 às 23:58, Dave S escreveu: > On Saturday, January 30, 2021 at 3:32:13

Re: [web2py] Re: fake_migration issues

2021-01-31 Thread Nico Zanferrari
You are right, I'd completely forgotten these issues... I've closed them all, because the zip files in the official repository http://www.web2py.com/init/default/download are fine. Also, you can easily update the web2py program (and/or pydal) by manually substituting the source files inside. Chee

Re: [web2py] Re: Got error when I put 'fields' as an argument to SQLFORM.grid

2021-01-29 Thread Muhammad Atif Ayaz
Thank you very much! On Fri, Jan 29, 2021 at 9:14 AM valq...@gmail.com wrote: > db.table['fieldname'] > > > четверг, 28 января 2021 г. в 07:31:04 UTC+3, at: > >> It gives error: `*AttributeError('str' object has no attribute >> 'tablename')*` >> >> The reason is that the field names are in strin

Re: [web2py] Re: Got error when I put 'fields' as an argument to SQLFORM.grid

2021-01-28 Thread valq...@gmail.com
db.table['fieldname'] четверг, 28 января 2021 г. в 07:31:04 UTC+3, at: > It gives error: `*AttributeError('str' object has no attribute > 'tablename')*` > > The reason is that the field names are in string format not in > db.tablename.fieldname format > > > On Wed, Jan 27, 2021 at 6:30 PM Jim

Re: [web2py] Re: Got error when I put 'fields' as an argument to SQLFORM.grid

2021-01-27 Thread Muhammad Atif Ayaz
It gives error: `*AttributeError('str' object has no attribute 'tablename')* ` The reason is that the field names are in string format not in db.tablename.fieldname format On Wed, Jan 27, 2021 at 6:30 PM Jim Steil wrote: > What is wrong with using the example you provided? > > -Jim > > > On Tu

  1   2   3   4   5   6   7   8   9   10   >