[web2py] Re: add record no longer available in smartgrid since switch to ms sql

I found the reason. I needed to add user_signature=False The default for this parameter is True and will prevent you from adding records!!! On Thursday, January 18, 2024 at 1:47:37 PM UTC+1 Davidiam wrote: > I recently switched from sqlite to MS SQL and my application no longer > all

[web2py] add record no longer available in smartgrid since switch to ms sql

I recently switched from sqlite to MS SQL and my application no longer allows me to add new records using the smartgrad. I have editable and deletable set to True but I can only view the records. If I use a basic SQLFORM I can add records, but I would prefer using the smartgrid. Is there a tri

[web2py] PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'D:\\Data\\XYZ\\applications\\MyApp\\private\\app.log'

We have activated logging in our applications and have defined 2 back-ups for the rotation. We often get errors when running web2py shell scripts because I think that the the web2py web application and the web2py shell script are both trying to access the log file. It looks like it is trying t

[web2py] Does anyone know why exceptions are not always passed up the call stack when running a script from the web2py shell?

2.22.5-stable+timestamp.2022.06.04.18.13.51 (Running on Microsoft-IIS/10.0, Python 3.9.13) I am trying to catch errors in web2py shell scripts which are run in batch, but some exceptions are not being passed up the call stack when running in shell mode. My situation is as follows: 1. Create

[web2py] Re: web2py 2.23.0 is giving a 403 error when I try to package my applications

Returns: >>>> filename of the w2p file or None on error >>>> >>>> """ >>>> try: >>>> if filenames is None: >>>> app_cleanup(app, request) >>>> * filename = ap

Re: [web2py] Active directory authentication

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 From: web2py@googlegroups.com on be

[web2py] Re: Upgraded to 2.19 and SQL Server date insert throws an error

y, putting the .isoformat in comment, the timestamp is again a string and it works again. On Wednesday, January 11, 2023 at 12:08:54 PM UTC+1 Davidiam wrote: > Hi, > > Has anyone found a solution for this? We are experiencing the same issue > with 2.22.5 and storing the session i

[web2py] Re: Upgraded to 2.19 and SQL Server date insert throws an error

Hi, Has anyone found a solution for this? We are experiencing the same issue with 2.22.5 and storing the session in the db. As a work-around, we have removed the ".isoformat" from the line 1247 of the gluon\globals.py: modified_datetime=request.now, #.isoformat(), What would be the impact of

[web2py] Re: web2py 2.23.0 is giving a 403 error when I try to package my applications

it/web2py.app.%s.w2p' % app, request)* >> w2p_pack(filename, apath(app, request), filenames=filenames) >> return filename >> except Exception as e: >> if raise_ex: >> raise >> return False >> >> On Monday

[web2py] Re: web2py 2.23.0 is giving a 403 error when I try to package my applications

cept Exception as e: if raise_ex: raise return False On Monday, January 9, 2023 at 10:37:57 AM UTC+1 Davidiam wrote: > I found where this is occurring (out of the box run, no mods): > > > C:\Users\u30591\web2py_2.23.0\web2py\applications\admin\controllers\defau

[web2py] Re: web2py 2.23.0 is giving a 403 error when I try to package my applications

e: *web2py_apps_root* = 'C:\\Users\\myuser\\web2py_2.23.0\\web2py\\applications' *a_for_check *= 'C:\\Users\\myuser\\web2py_2.23.0\\web2py\\deposit\\web2py.app.403_test.w2p' On Thursday, January 5, 2023 at 9:54:07 AM UTC+1 Davidiam wrote: > Good Morning, > > We are u

[web2py] Re: web2py 2.23.0 is giving a 403 error when I try to package my applications

5, 2023 at 9:54:07 AM UTC+1 Davidiam wrote: > Good Morning, > > We are using IIS 10 with web2py 2.23.0. > > When I try to pack the welcome application (or any other), using pack_all > I get a 403 error. > When I try to pack the welcome application (or any other), using &g

[web2py] web2py 2.23.0 is giving a 403 error when I try to package my applications

Good Morning, We are using IIS 10 with web2py 2.23.0. When I try to pack the welcome application (or any other), using pack_all I get a 403 error. When I try to pack the welcome application (or any other), using pack_custom, it first displays the file selector and when I click on download as .

[web2py] web2py 2.23.0 is giving a 403 error when I try to package my applications

I are using IIS 10 with web2py 2.23.0. When I try to pack the welcome application (or any other), using pack_all I get a 403 error. When I try to pack the welcome application (or any other), using pack_custom, it first displays the file selector and when I click on download as .w2p I get a 403

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

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

[web2py] Re: Visual Studio Code

I tried the https://github.com/Andyhasit/web2py_intellisense in VS Code, but couldn't get it to work. I am sure that I set it up wrong as I didn't quite understand the instructions in the readme file. 1) I copied *auto_completion_support.py* into the modules folder of my welcome application

[web2py] Latest version of web2py and python versions

Good morning, Can anyone tell me if the latest version of web2py was specifically developed for any specific python version or range of python versions? After years of using an older version, and being limited to the version 3.6, we will be upgrading to the most recent version of web2py, and I

[web2py] A friend has developed a flask application and now wants to add a login and security. I would like to know if it would be feasible to convert the flask application to web2py.

A friend asked me if I would be interested in building the login/security layer for a flask / My SQL application on PyhtonAnywhere, but I don't know Flask and I really like web2py and have already created a few applications using web2py. I told her that web2py has the security included and if i

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

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?

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?

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,

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

Hi web2py folks, I would like to add a command line argument to the startup of web2py which is running on an IIS web server. Can someone tell me the place where I need to add those parameters on the IIS? Kind Regards, David -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] Internal Server Error 500 when doing medium to heavy data processing

Version 2.18.5-stable+timestamp.2019.04.08.04.22.03 (Running on Microsoft-IIS/10.0, Python 3.6.8) Hello, We have been using web2py for a couple of years with very few issues, but lately we have been getting *Internal Server Error 500 *error messages when certain scripts are called. These scri

Re: [web2py] Timeout for data entry screens: Help!

Massimiliano > ha scritto: > >> You can set: >> >> auth.settings.expiration >> >> Value are in seconds. So 86400 is one day, >> >> >> >> Il giorno ven 29 gen 2021 alle ore 14:42 Davidiam >> ha scritto: >> >>> 2.18.5-st

[web2py] Timeout for data entry screens: Help!

2.18.5-stable+timestamp.2019.04.08.04.22.03 (Running on Microsoft-IIS/10.0, Python 3.6.8) Hello, We built some web2py applications and we are now getting feedback from the users that if they don't save their data entry screen data within about 10 minutes, that the save fails and they have to

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

(): if str(nm) == str(app): for h in lgr.handlers: h.close() On Tuesday, October 27, 2020 at 2:09:51 PM UTC+1 Davidiam wrote: > It looks like it uses one handler although the logger rotates the actual > log files. I think that I would need to shut down the logger before

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

ww.TenOutOfTen.org> > roge...@gmail.com > (+95) 09 250018669 <+95%209%20250%20018%20669> (Myanmar) > > > On Mon, 26 Oct 2020 at 23:37, Davidiam wrote: > >> Thank you for your reply, >> Deleting the application folder gives the same error. >> The problem

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

18%20669> (Myanmar) > > > > On Fri, 23 Oct 2020 at 17:07, Davidiam wrote: > >> When using logging in web2py on Windows, we are unable to delete >> applications unless we first stop the server. >> >> The reason is that the app.log is considered "in use"

[web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

When using logging in web2py on Windows, we are unable to delete applications unless we first stop the server. The reason is that the app.log is considered "in use". As the uninstall happens from the admin app, I am not quite sure how best to stop the logger in the application that is being uni

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

correctly. Hope this helps someone ;) On Friday, June 19, 2020 at 7:44:53 AM UTC+2, Davidiam wrote: > > Good Morning, > > I would like to know what I would have to modify in order to connect to MS > SQL from web2py with TLS 1.2. We are running web2py 2.18.5 on a Windows > 201

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

Sorry, I thought the post on top was only for me, I didn't know it was for everyone :S On Saturday, June 20, 2020 at 4:16:33 AM UTC+2, Dave S wrote: > > > > On Thursday, June 18, 2020 at 10:44:53 PM UTC-7, Davidiam wrote: >> >> Good Morning, >> >>

Re: [web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

tible with TLS 1.2? Have you verified it? See here > <https://social.technet.microsoft.com/Forums/en-US/a8fbb819-02c0-4b42-b593-0282605732f1/how-to-confirm-sql-connection-is-using-tls-12> > > for details. > > Nico > > > Il giorno ven 19 giu 2020 alle ore 07:45 Da

[web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

Good Morning, I would like to know what I would have to modify in order to connect to MS SQL from web2py with TLS 1.2. We are running web2py 2.18.5 on a Windows 2016 IIS server. Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and enable TLS 1.2 and now all our MS SQL DB co

[web2py] Making the application name variable in the link in routes.py

Is there a way of referencing the current application in the routes.py as a variable ? For example, We have the following code in our routes.py : error_message_ticket = ('Internal errorTicket issued:' '%(ticket)s' 'ERROR DETECTED'

[web2py] How to use conda installed packages in web2py

Hi, We have an application that requires the pandas package. We thought we could just install pandas in the conda environment used for running web2py, but when we do "import pandas" in web2py we get an error message that it can't find pandas and it seems to be looking for pandas in the modules

[web2py] How to run a specific application instead of welcome in Pycharm Pro

I am using Pycharm Professional for web2py development. When I create a project with an application "XYZ" and I click run, web2py is started and goes directly to the "welcome" app, and not the app "XYZ". I can navigate to the application "XYZ", but I would like it to go directly to this app w

[web2py] Re: mssql set identity_insert on

I agree that this is not good practice, but it is the only workable solution that we have found for multi pillar release. We are also heavily using roles, but here the problem is guaranteeing that users have the same ids on all pillars, otherwise we risk users belonging to the wrong groups in p

[web2py] mssql set identity_insert on

As part of our release process, we need to insert records in the auth tables using specific id's. On sqlite this is no problem, but in mssql we get an error saying insert_identity is off. The solution is to set insert_identity in, but I am not sure how to do this using the web2py DAL. Can any

[web2py] Re: Communication error when saving in admin web interface

, 2019 at 9:30:41 AM UTC+1, Dave S wrote: > > > > On Wednesday, November 6, 2019 at 10:55:34 PM UTC-8, Davidiam wrote: >> >> Windows server 2016, IIS 10, Windows 10, Edge >> >> Version >> >> 2.18.5-stable+timestamp.2019.04.08.04.22.03 >> (Running o

[web2py] Communication error when saving in admin web interface

Windows server 2016, IIS 10, Windows 10, Edge Version 2.18.5-stable+timestamp.2019.04.08.04.22.03 (Running on Microsoft-IIS/10.0, Python 3.6.8) Hello, A few of our developers have been experiencing this so I thought I would ask the forum for help. If we edit a file in the web2py admin consol

[web2py] Re: wfastcgi , iis & python 3 not working?

We have more or less the same configuration with no issues. One thing that might help you though You can setup the admin app to work over https: https://www.youtube.com/watch?v=_4to_44DcJU time : 46:15 Run from web2py base folder : For 2.7 : from gluon.main import save_password; save_passw

[web2py] Re: Uploading a file under the Static section of web2py admin gets exception

On Tuesday, October 22, 2019 at 11:08:07 AM UTC+2, Davidiam wrote: > > Hello, > > I am trying to upload files via the Welcome appadmin in the Static files > section, but the uploads are failing with "Cannot upload file " > > I have now traced this in Pycharm and i

Re: [web2py] Web2Py with LDAP and SAML : Is it worth it for Windows ?

ver simplifying! Hope this helps! > > > On Sunday, August 18, 2019 at 1:35:32 AM UTC-4, Massimo Di Pierro wrote: >> >> web2py or py4web? I could use some help getting it to work for py4web. >> >> On Thursday, 1 August 2019 07:08:10 UTC-7, Davidiam wrote: >>>

[web2py] Re: Setting a pre-authenticated user (no password in auth db) as "logged in" for web2py app

d there is a `settings.renew_session_onlogin` in > login_user, and i think that it is equal to False, and your session is not > renewed, when you using authapi.login_user. In Auth class this variable > equals to True. > > вторник, 22 октября 2019 г., 14:17:47 UTC+5 пользователь Davidiam написал:

[web2py] Re: Setting a pre-authenticated user (no password in auth db) as "logged in" for web2py app

> > пятница, 18 октября 2019 г., 18:34:31 UTC+5 пользователь Davidiam написал: >> >> Hello Ruslan, >> >> I tried to use the "authapi.login_user" method but it looks to me like >> the login_bare method works better and requires less coding to make it work.

[web2py] Uploading a file under the Static section of web2py admin gets exception

Hello, I am trying to upload files via the Welcome appadmin in the Static files section, but the uploads are failing with "Cannot upload file " I have now traced this in Pycharm and it is failing on the call to the count_lines method in the admin\controllers\default.py In the debugger I see t

[web2py] Re: Setting a pre-authenticated user (no password in auth db) as "logged in" for web2py app

n Gareev wrote: > > Hi, i think that a "login_user" method in AuthApi meets your reqests. > > четверг, 17 октября 2019 г., 13:33:43 UTC+5 пользователь Davidiam написал: >> >> Hello, >> >> We pre-authenticate users outside of web2py via SAML and the user

[web2py] Re: Setting a pre-authenticated user (no password in auth db) as "logged in" for web2py app

thApi meets your reqests. > > четверг, 17 октября 2019 г., 13:33:43 UTC+5 пользователь Davidiam написал: >> >> Hello, >> >> We pre-authenticate users outside of web2py via SAML and the user lands >> on a page where he can choose from a list of applications. >>

[web2py] Setting a pre-authenticated user (no password in auth db) as "logged in" for web2py app

Hello, We pre-authenticate users outside of web2py via SAML and the user lands on a page where he can choose from a list of applications. When the user selects an application, he needs to be set as "logged in" for that web2py application as long as there his userid exists in the auth table (no

[web2py] Re: Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

We have looked in this further, and due to the autoincremented ID fields in the Auth tables, we are going to have a very complicated release process. The problem is that the ID will be used in all references to the users and groups but between pillars (DEV,ACC,PRO) the ID's may not be the same w

[web2py] Re: Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

Thanks for your reply. Maybe override was not the best term. We can create the users using the userid and groupid as the ids in the user, group and membership tables, but as Web2Py out of the box creates an id (sequentially incremented) we are concerned that specifying a different id might hav

[web2py] Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

We are planning on using Web2Py in a 3 tier release model (Development, Acceptance, Production) but as the ID fields in the auth tables are used as primary and foreign keys, we are concerned that this will cause inconsistencies between the different pillars. We will be using SSO for access to we

Re: [web2py] Web2Py with LDAP and SAML : Is it worth it for Windows ?

We are working on a Shibboleth implementation now. So far it is working better than the other tests we did on Windows. We wanted to test it using a localhost Shibboleth sp and idp but it wasn't clear to us how we needed to configure it. Thanks for the tip! -- Resources: - http://web2py.com -

[web2py] Re: Web2Py and ldap integration

Thank you very much for the info. In the mean time we have decided to use shibboleth because we had a lot of issues with the python modules on Windows and because the project added the requirement for sso. I will keep your solution as a reference for the future. -- Resources: - http://web2py

[web2py] Web2Py with LDAP and SAML : Is it worth it for Windows ?

We have been trying to implement a web2py project on a Windows IIS server for the last few weeks and we are currently considering abandoning the project due to the absence of LDAP and SAML modules for Windows. We are running python 3.7 with IIS 8. We managed to get that configuration running p

[web2py] Re: Web2Py on IIS, multiple apps under virtual directories

Solved. I needed to add a separate fastcgi per system by modifying the web.confi fastcgi line and adding the and in IIS I needed to add a separate fastcgi application for each installation. On Saturday, July 20, 2019 at 7:30:00 AM UTC+2, Davidiam wrote: > > Hello, > > I have setup

[web2py] Web2Py on IIS, multiple apps under virtual directories

Hello, I have setup Web2Py with IIS using fastcgi and I got the application running (currently testing using the Welcome app). In our project we will have multiple applications running parallel to each other, each under a separate application. To do this, we have created the following structure

[web2py] Web2Py and ldap integration

Hello, I have read and implemented the recipe for Windows active directory ldap integration with Web2Py ( http://www.web2py.com/books/default/chapter/29/09/access-control) and for the most part the documentation is clear except for the last bit where it refers to : from gluon.contrib.login_me