[web2py] PYODBC and IIS App Pool Memory Leak?

2014-12-22 Thread Pbop
We have deployed a web2py app to a client site with the client now doing some testing. On an initial load into the app by the first browser and on stress load of concurrent users, this error is being thrown. class 'gluon.contrib.pypyodbc.Error' (u'HY090', u'[HY090] [Microsoft][ODBC Driver

[web2py] Re: Don't use 64 bit ODBC with Web2Py and SQL Server

2015-01-15 Thread Pbop
We of course changed source to 32 bit when we went to 32 bit ODBC drivers. Did not try pypyodbc and did not know about pytds, which is cool to know! Thanks. For now we have a solution so my message is to just try and save folks a lot of time and grief. -- Resources: - http://web2py.com -

[web2py] Don't use 64 bit ODBC with Web2Py and SQL Server

2015-01-14 Thread Pbop
Spent days trying to track down an error with a Web2Py app and SQL Server 2008 R2 running 64 bit ODBC drivers. Switched to 32 bit drivers and problem solved. The problem is not in Web2Py but in the actual PyOdbc driver. -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: In search of CAS 2 provider and consumer example

2015-01-10 Thread Pbop
For what it is worth we have integrated a web2py app to two different external cas providers both in http and https with no problem including ssls with ssl3.0 disabled in favor of tls. Anyone working on a shib sso? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Design flaw in auth.impersonate ?

2015-04-07 Thread Pbop
Presuming the session is cookie based, why not impersonate in incognito mode or in another browser? -- 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) --- You

[web2py] Re: web3py

2016-01-14 Thread Pbop
Sounds like you have a good approach with option 2. That is my vote! You can't get around that once a decision is made the community will react with some degrees of enthusiasm and pushback. I am curious if the increase in performance is based on a more efficient algorithm, Python3 is doing

[web2py] SOAP XML Element Question

2016-04-24 Thread Pbop
First, I highly recommend http://www.soapclient.com/soaptest.html as a resource to reverse engineer soap parameters and test soap calls. If it works from this site and not in your Web2Py code, your code is broken, not the SOAP client. The soap client parameters are poorly documented and the

[web2py] Struggling with simple SOAP call...

2016-04-19 Thread Pbop
I am trying to learn how to use the pysimplesoap client to consume a service outside of Web2Py. Example in book works great, and I have not some useful threads in the community about authentication which is phase 2, but I am just trying to start simple. Unfortunately, my proof of concept to

Re: [web2py] Re: web3py status

2016-09-05 Thread Pbop
I recommend AbilityPy. People want a framework with rich abilities. The Py gives a nod that this is a python framework (with abilities). Ability preceding Py ensures the framework is at the top of any list of frameworks given the alpha sort of A+B for AbilityPy. The domain is also available

Re: [web2py] Re: web2py for windows server. IIS or Nginx?

2016-11-02 Thread Pbop
We built a SHIB SSO and OAUTH SSO middleware in web2py that handles 1000+ concurrent users with very good results in IIS and ISAPI running a WSGI wrapper ala the cookbook instructions. I hear IIS and FastCGI and wonder if this is a better deployment option? Are you aware of any advantages of

[web2py] Re: Need help to debug this error when using URL from gluon/html.py

2016-12-20 Thread Pbop
Issue appears to have come up a few times on stack overflow. http://stackoverflow.com/questions/9942594/unicodeencodeerror-ascii-codec-cant-encode-character-u-xa0-in-position-20/9942885 On Tuesday, December 20, 2016 at 2:08:00 PM UTC-5, Dave S wrote: > > > On Tuesday, December 20, 2016 at

[web2py] Re: Any ideas on how to prepare web2py apps for GDPR

2017-07-06 Thread Pbop
Making an app ready for GDPR compliance does not have some checklist and is an ongoing commitment to privacy and security by design. Web2Py aligns well with GDPR in many ways out of the box. Here is a fairly comprehensive toolkit to assist in all of the moving pieces for GDPR compliance from a

[web2py] Re: Two database join query

2017-09-01 Thread Pbop
In SQL Server, you can run queries across database tables following the syntax you mention if you have permissions to access both databases and they are on the same server. I presume the same is true on other (not all) database engines. If you have the SQL, then use the executesql feature and

[web2py] Re: DAL write permission error

2017-12-07 Thread Pbop
st try > print 'c:\web2py\applications\testme\databases' > and you will be surprised > > > > On Friday, December 8, 2017 at 12:14:18 AM UTC+3, Pbop wrote: >> >> Sorry for not being more clear in my original question so would like to >> offer more specific infor

[web2py] Re: DAL write permission error

2017-12-07 Thread Pbop
Sorry for not being more clear in my original question so would like to offer more specific information I have a SQLITE database located at c:\web2py\applications\testme\databases When running web2py, I have no problem connecting to the database. It loads the test data and works just

[web2py] isomorphic rendering ... a possible future for web2py?

2017-12-01 Thread Pbop
Here is an interesting read for the community. https://whatisjasongoldstein.com/writing/universal-jinja/ The money quote is: "The reason to write fancy frontends isn’t because it’s faster (it’s not), it’s to decouple use actions from pageviews." Enter a new term for at least my vocabulary:

[web2py] cool tool to browse sqlite database

2017-12-03 Thread Pbop
http://sqlitebrowser.org/ -- 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) --- You received this message because you are subscribed to the Google Groups

[web2py] DAL write permission error

2017-12-03 Thread Pbop
On windows in command prompt, running latest version of web2py When on any directory other than web2py\applications\\databases, this works fine: db = gluon.DAL('sqlite://storage.sqlite') and creates a new database or connects to an existing database. When I go db =

[web2py] Re: wfastcgi on IIS ... no more wfastcgi.py script?

2018-02-14 Thread Pbop
For what it is worth, I have web2py deployed under IIS using the ISAPI recipe and web2py screams in speed. The only requirement is the code has to be thread safe and have not yet run into thread safe problems in how we deploy web2py. If it is, you will get much faster performance over fastcgi.

[web2py] Re: An Easy way to Support ADFS / AZURE / OKTA / Sibboleth and other SAML2 SSO Scenarios

2018-12-31 Thread Pbop
: redirect(lweb.AbilityLMS_URL + lweb.landing_path + '?remoteST=%s' % lwebInfo.stateObj['ClientState']) else: error = 'Unkown Error:%s' % BEAUTIFY(lwebInfo) return locals() return locals() On Saturday, December 8, 2018 at 10:37:13 AM UTC-5, Pbop wrote: > > Greetings Fellow Web2Pyers, >

[web2py] Re: An Easy way to Support ADFS / AZURE / OKTA / Sibboleth and other SAML2 SSO Scenarios

2019-01-01 Thread Pbop
Should be http://www.testshib.org/ Once your SP is installed test it against the IDP at... https://samltest.id/start-sp-test/ Or set up a test account with OKTA which has a free IDP account you can create. Pretty sure the same is true for Azure, but that was provided to me by the client. Once

[web2py] An Easy way to Support ADFS / AZURE / OKTA / Sibboleth and other SAML2 SSO Scenarios

2018-12-08 Thread Pbop
Greetings Fellow Web2Pyers, It's the season of giving. I hope what I share inspires others to share some of their tips and tricks in Web2Py that others can use! Many thanks to the community for your great help in the past! This post assumes the reader has limited exposure to SAML2. The

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

2019-08-19 Thread Pbop
I am not familiar enough with how AUTH works but can offer a perspective that might help to the level you want AUTH to support AD or SAML2 SSOs. In both AD and SAML using the Shibboleth IIS Plug-in, you are in essence designating a protected folder on the IIS web-server to require

[web2py] Re: Whats the best way to create an Android or iOS app for web2py project

2019-09-11 Thread Pbop
Suggest you google NSB/App Studio. A simple easy to use tool to create native iphone/droid apps. Other tools out there of course, but this has a manageable learning curve, Use Web2Py or Py4Web for server side back-end. On Friday, September 6, 2019 at 7:28:30 AM UTC-4, Rahul wrote: > > Hey

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

2019-07-24 Thread Pbop
Suggest you research Shibboleth as a SAML layer for your web2py app or if choose to use another framework. You can use Shibboleth to protect a virtual folder to any SAML IDP. If the protected folder is your web2py app, SHIB does the authentication and your web2py app can use any of the identity