[web2py] Re: Web2py dal significantly slower than raw query

y, October 2, 2023 at 8:04:04 PM UTC+2 Jim S wrote: > >> The only thing I can see is that the SQL needs to be 'built' by pydal, >> but I find it hard to believe it takes a whole second. Massimo might have >> to add context here. >> >> -Jim >>

[web2py] Re: Web2py dal significantly slower than raw query

is it my Monday-morning-brain? > > If your raw query is slower, could it be because you're converting to a > dict instead of a list as in your dal query? > > -Jim > > On Monday, October 2, 2023 at 3:07:26 AM UTC-5 urban@gmail.com wrote: > >> i

[web2py] Web2py dal significantly slower than raw query

ids = tuple(m['id'] for m in relevant_models) raw_q = db.executesql(""" SELECT * FROM "table" WHERE ("table".ref_id" IN {}); """.format(str(ids)), as_dict=True) 1.8s ids = tuple(m['id'] for m in relevant_models) dal_q

Re: [web2py] Active directory authentication

e: > We do AD authentication with Shibboleth as our service provider on IIS > 10. I don't know if that would be an option. We couldn't find anything > else that worked on Windows. > > Sent from Outlook for Android <https://aka.ms/AAb9ysg> > -

[web2py] How to send another email after registration verification url is visited

How do I send an additional email after the user verifies their registration via emailed link default/user/verify_email/ That is, where do I specify additional things that should happen upon verification. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://git

[web2py] How do I send an additional email after the user verifies their registration via emailed link woshiEC/default/user/verify_email/ urban....@gmail.com's profile photo urban....@gmail.com

How do I send an additional email after the user verifies their registration via emailed link default/user/verify_email/ That is, where do I specify additional things that should happen upon verification. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://git

[web2py] Re: How to send email after user goes to the registration verification link (sent to their email)

That is, where do I specify additional things that should happen upon verification. On Tuesday, September 20, 2022 at 1:31:14 PM UTC+2 urban@gmail.com wrote: > How do I send an additional email after the user verifies their > registration via emailed link > > woshiEC/

[web2py] How to send email after user goes to the registration verification link (sent to their email)

How do I send an additional email after the user verifies their registration via emailed link woshiEC/default/user/verify_email/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/l

[web2py] Web2Py reset_password 303

When user requests a new password they get an email with a link in the following format: default/user/reset_password/ uuid However, when clicked it redirects back to home page. The page returns HTTP code 303.

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

; Clemens > > On 31.03.22 18:33, urban@gmail.com wrote: > > Am I correct in assuming this error is occurring because python is unable > to import the module and so web2py is trying to import it from local > modules: > > File "/opt/web2py/gluon/custom_import.py

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

ems like it shouldn't cause a problem. > > -Jim > > On Thursday, March 31, 2022 at 9:52:06 AM UTC-5 urban@gmail.com wrote: > >> Upon inspection it seems psycopg2 is installed at 3 locations. . >> >> */home/ouruser/.local/lib/python3.6/site-packages/psycopg2*

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

nger support > python 3.6 > > https://www.psycopg.org/psycopg3/docs/basic/install.html > > > > On Thursday, March 31, 2022 at 9:01:24 AM UTC-5 urban@gmail.com wrote: > >> Thank you for the reply! >> >> I believe we've already tried sudo pip install

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

This would explain why it works when you run it interactively. What user > is running your uwsgi process? > > Also, if possible I'd move to a newer version of python3. Python 3.6 is > end-of-life as of 12/23/2021 > > -Jim > > > On Thursday, March 31, 2022 at

[web2py] Centos 7 uwsgi no driver for psycopg2

Hi, Trying to setup web2py, python3 centos 7, nginx, uwsgi. The application is already running on centos 7 with python 2.7. With python 3.6 I get the following error: class 'RuntimeError'> Failure to connect, tried 5 times: Traceback (most recent call last): File "/opt/web2py/gluon/packages/d

[web2py] Azure Active Directory

I've managed to setup a login page with msal which redirects me to a web2py request handler where I'm able to get the token and the username. I assume I could now programmatically register the user if they're not yet registered. However, how would I integrate this login with standard web2py aut

Re: [web2py] Active directory authentication

"Still trying to wade through the seemingly half outdated guides" I'm referring to Azure guides not Web2Py. On Thursday, March 3, 2022 at 2:10:33 PM UTC+1 urban@gmail.com wrote: > No it's not on-premise. They said so explicitly. Apologise for the low > info quest

Re: [web2py] Active directory authentication

efault/chapter/29/09/access-control#LDAP and > https://github.com/web2py/web2py/blob/master/gluon/contrib/login_methods/ldap_auth.py > > Nico > > > Il giorno mer 2 mar 2022 alle ore 16:48 urban@gmail.com < > urban@gmail.com> ha scritto: > >> We're

[web2py] Active directory authentication

We're looking into adding AD authentication to our app. We have an active directory account and an app registered on it. In the documentation I found this example of enabling AD auth: from gluon.contrib.login_methods.ldap_auth import ldap_auth auth.settings.login_methods.append( ldap_auth(