[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

Thanks for posting. No failed logins were recorded in the event viewer after I got this error. I was able to see failed logins previously in the event viewer but they were unrelated to the SQL Server Connection attempt. On Thursday, August 21, 2014 9:45:11 AM UTC-5, Willoughby wrote: > > Login

[web2py] Re: SAML2 Service Provider app in web2py?

Incidentally, I just committed an experimental SAML2 login method for Web2py. Please contact me privately and perhaps you can help me test it. Massimo On Thursday, 21 August 2014 09:05:29 UTC-5, Wei Wang wrote: > > I have the need to use a SAML2 identity provider (specifically, a NetIQ > produc

[web2py] Re: bootstrap 3 - if you care help test trunk now

Most of these issues have been addressed today. I could use some help with the style of Field(.., 'list:string') and Field(...,'boolean') On Wednesday, 20 August 2014 15:33:58 UTC-5, Miquel Fontanals wrote: > > Hi > > I've found some issues testing an existing app > > 1.- Not bs3 related > > db.d

Re: [web2py] Re: Is the user registration code broken?

On Thu, Aug 21, 2014 at 3:39 PM, Anthony wrote: > > Are you just using the welcome app as is with no modification? If not, please > show your code. > I created an application (without using the wizard) and added: # coding: utf8 from gluon.tools import Auth auth = Auth(db) auth.define_tables(use

[web2py] Re: How do I apply placeholder text to web2py forms?

Method 1 can be easily generalized in a function that set the placeholder for all sqlform fields and strip away all labels and comments: def autoset_form_placeholders(form, form_labels=False, form_comments=False): for f in form.fields: if f == 'id': pass else:

[web2py] Re: Scheduler task finishes but row not marked COMPLETED

Yes, those messages appear far back in the logs, which I didn't include. I only included a snapshot of the debug output at the end of the scheduled task's work, as setting the status to COMPLETED would be at that point, not? -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] list and sublist in model

I tried to create product table which has a category and productType, when I want to add

[web2py] Re: I don't have a gluon forder in my web2py folder

I am using windows and when I downloaded web2py I unzipped it and I have been using it, it works fine, however, I noticed that between the extras folder and the handlers folder the gluon folder is missing. I also noticed that there is a zip folder inside the web2py folder which is called librar

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

Here is my welcome message: On Thursday, August 21, 2014 9:48:29 AM UTC-5, Niphlod wrote: > > that's indeed very strange. What driver is DAL using ? (you can see it > even when you start web

[web2py] Re: pytds support for mssql?

my bad, wrong error pasted. Here's the same error on the latest version... Traceback (most recent call last): File "C:\Temp\web2py_src\web2py\gluon\restricted.py", line 220, in restricted exec ccode in environment File "C:/Temp/web2py_src/web2py/applications/test/models/db.py"

[web2py] Re: pytds support for mssql?

BTW: I don't see any dbapi.py in the main repo. are you on the latest version ? On Thursday, August 21, 2014 10:53:06 PM UTC+2, Niphlod wrote: > > > > On Thursday, August 21, 2014 10:34:17 PM UTC+2, Derek wrote: >> >> I've been working on adding it to the DAL but I ran into some issues with

[web2py] Re: pytds support for mssql?

On Thursday, August 21, 2014 10:34:17 PM UTC+2, Derek wrote: > > I've been working on adding it to the DAL but I ran into some issues with > it... the main thing is it doesn't support DSN syntax, but I got past that > by modifying the DAL.py file myself (just to see what it would look like > o

[web2py] Re: pytds support for mssql?

I've been working on adding it to the DAL but I ran into some issues with it... the main thing is it doesn't support DSN syntax, but I got past that by modifying the DAL.py file myself (just to see what it would look like once I got past that point). Now I am getting an error (which I reported

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

You've already done way more than I could have hoped. I'll see what I can find regarding ssl slow-down with nginx and report back. Thanks for all the help. -Jim On Thu, Aug 21, 2014 at 12:25 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > If your url is http when page charged compl

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

If your url is http when page charged completly there is no redirecting. If it related to your SSL certificate or nginx conf, I am far from an expert. I would say that if it long only for the first time it is not related to the overhead of encryption for your server... So you have to investigate a

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

I'm not doing and redirecting from http to https. It's just when I specify https that I'm getting the symptoms. I don't think I'm doing any re-writing. At least there is nothing there that I setup Would that be in the same file? /etc/nginx/sites-available/web2py On Thu, Aug 21, 2014 at 12:05

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

Ok, what I was about to wrote before I doubt of me. Maybe your issue come from bad nginx syntax for permanent redirection from HTTP to HTTPS... Mine redirect like that : return 301 https://domain.something$request_uri; # http://wiki.nginx.org/Pitfalls#Taxing_Rewrites Richard On Thu, Aug 21, 2

[web2py] Re: Total newbie, advice on storing scans

Web2py has an 'upload' field type that helps you manage file uploads. "Upload" is a little bit of a misnomer because you can select the file path to store the file (or an existing path) and the blob is not stored in the database. You can read more here: http://web2py.com/books/default/chapter/

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

Clarification - the uwsgi restart had no delay on the first request running https or http -Jim On Thu, Aug 21, 2014 at 10:21 AM, Jim Steil wrote: > uswgi restart - no delay > > nginx restart - about a 12 second delay for the first request if running > https > > nginx restart - no delay if runn

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

uswgi restart - no delay nginx restart - about a 12 second delay for the first request if running https nginx restart - no delay if running http -Jim On Thu, Aug 21, 2014 at 10:08 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > I have 10m and I don't have this issue... > > I don't

[web2py] Re: How to set the Pythonpath for the Scheduler

probably because of sudo . did you try with sudo -E ? this is more an "upstart issue" than a web2py one, maybe you'll find more info asking on stackoverflow or ubuntu forums On Thursday, August 21, 2014 4:56:24 PM UTC+2, Serbitar wrote: > > so like this: > > description "web2py task schedule

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

I have 10m and I don't have this issue... I don't think it coming from nginx. There is very few parameters in nginx config that could explain your latency... Does it happen only on reboot of VM, or it happen when you restart nginx, or uwsgi. What happen if you restart nginx only vs restart uwsgi

[web2py] Re: web2.py + mpld3: how to display the generated HTML

Or return XML(make_html), whatever you find easier. On Wednesday, August 20, 2014 12:19:54 PM UTC+2, Stavros Anastasiadis wrote: > > I am trying to use mpld3 (http://mpld3.github.io/index.html) to generate > an example plot with web2py. > > so far in my simple example: > > controller: > > def exa

[web2py] Re: How to set the Pythonpath for the Scheduler

so like this: description "web2py task scheduler" start on (local-filesystems and net-device-up IFACE=eth0) stop on shutdown respawn limit 8 60 # Give up if restart occurs 8 times in 60 seconds. env PYTHONPATH=/home/networkanalytics/git/franz.git/src/lib/ exec sudo -u www-data python /home/www-dat

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

I've changed the following in /etc/nginx/sites-available/web2py ssl_session_cache shared:SSL:10m;-> to 60m ssl_session_timeout 10m; -> to 60m Still took a long time (5-10 seconds) for the first request but maybe now it will not cause that to happen again for greater intervals. -Jim On We

[web2py] Re: Web2py Mobile Interface

Hi Massimo I get the requires "gitpython module" so I cannot complete a pull request. I was hoping to be able to install the app as I would on the PC but that option is not available... should it be? Thanks Greg On Friday, 22 August 2014 00:07:36 UTC+10, Massimo Di Pierro wrote: > > What error

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

Login errors can be seen in the event viewer too IIRC, you might check there for clues. On Wednesday, August 20, 2014 9:50:17 PM UTC-4, Ryan Hood wrote: > > Thanks for the advice and for sharing your experiences. Also appreciate > the mmsql4 tip. So this will probably surprise you, but I still

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

that's indeed very strange. What driver is DAL using ? (you can see it even when you start web2py as a "welcome" message in the cmdline) On Thursday, August 21, 2014 3:50:17 AM UTC+2, Ryan Hood wrote: > > Thanks for the advice and for sharing your experiences. Also appreciate > the mmsql4 tip.

Re: [web2py] Slow first time access on production with Ubuntu/NGINX/UWSGI

The profiler tell you the time spent on what, so it a good start for code improvement. But if you were not experimenting the slowmotion in other configuration (other VM) it shouldn't be your code but uwsgi/nginx config as stated by Niphold. Richard On Wed, Aug 20, 2014 at 10:17 PM, Cliff Kachins

[web2py] Re: scheduler causing mariadb deadlocks

On Thursday, August 21, 2014 8:38:51 AM UTC+2, Christophe Varoqui wrote: > > > > On Wednesday, August 20, 2014 10:01:55 PM UTC+2, Niphlod wrote: >> >> well, you're definitely a power-user if you're submitting 1000 >> tasks/minute. >> > > Well, it's more like a burst of 1000 tasks submitted in a

[web2py] Re: Is the user registration code broken?

Are you just using the welcome app as is with no modification? If not, please show your code. Anthony On Thursday, August 21, 2014 9:22:02 AM UTC-4, Nicholas Cole wrote: > > I'm just trying my first web2py application, using the downloads available > for OS X. > > I have tried enabling the user

[web2py] Re: Scheduler task finishes but row not marked COMPLETED

it still looks very weird. There should be lines "task starting", "looping", etc. I guess you activated the DEBUG log but that is not configured to be on DEBUG level on logging.conf. On Thursday, August 21, 2014 12:38:04 PM UTC+2, Stephen Weiss wrote: > > > Here's a run taken from a shell in whi

[web2py] Re: Total newbie, advice on storing scans

Hi Gari, I have a prototyp with web2py where you can upload an image and make an ocr-recognition. The prototype is not very complex. One table for the images and a process which starts "tesseract" for every uploaded image and put the textresult in the database to the documents. Am Mittwoch, 2

[web2py] Re: Web2py Mobile Interface

What error do you get when you try install an app? On Thursday, 21 August 2014 08:15:25 UTC-5, Greg Vaughan wrote: > > Hi Everyone, > > I decided that it would be advantageous if i were able to code on the go > to fix any issues that I see occurring in my hosted webapps. So I installed > web2py

[web2py] SAML2 Service Provider app in web2py?

I have the need to use a SAML2 identity provider (specifically, a NetIQ product) for authentication and authorization in some web2py apps. I searched in this group, also googled "web2py and SAML", but did not find anything that seems readily available. My thoughts on building a "Service Provide

[web2py] Re: bootstrap 3 - if you care help test trunk now

Hi I've found some issues testing an existing app 1.- Not bs3 related db.define_table("parent", Field('name'), format='%(name)s') db.define_table("child", Field('parent', 'reference parent')) In current version when I create/edit the child using SQLFORM the field parent becomes a dropdown of p

[web2py] Re: Scheduler task finishes but row not marked COMPLETED

Here's a run taken from a shell in which scheduler was run manually with '-D 0' option enabled. DEBUG:Tool: lines are loggers from within my models file tasks.py. At the end I hit Ctrl-C to quit the scheduler process. DEBUG:web2py.scheduler.centos-63#6814:recording heartbeat (RUNNING) D

[web2py] Re: scheduler causing mariadb deadlocks

On Wednesday, August 20, 2014 10:01:55 PM UTC+2, Niphlod wrote: > > well, you're definitely a power-user if you're submitting 1000 > tasks/minute. > Well, it's more like a burst of 1000 tasks submitted in a minute, with such bursts happening every 10 minutes. The schedule has plenty of time to

[web2py] Re: DAL calls fail after first stored procedure call

This still seems to be an issue for me running 2.9.5-stable+timestamp.2014.03.16.02.35.39. I tried both mysqldb and the default pymysql driver. I want to use a stored procedure to run a lengthy query that is run quite often by my application. This behavior should be easily reproducable using a

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

Thanks for the advice and for sharing your experiences. Also appreciate the mmsql4 tip. So this will probably surprise you, but I still get the same SSL error when I switch to this connection string: mssql://DRIVER={SQL Server};SERVER=localhost;DATABASE=testDB;UID=testUser;PWD=password. I aga

[web2py] Total newbie, advice on storing scans

Hi I'm writing a web app for my home server to allow me to scan and store images of official correspondence, so I can shred the paper and recycle it. A document archive. I have the scanner components written [using pyinsane] I have an idea of the models required, tables to hold the sender, da

[web2py] Is the user registration code broken?

I'm just trying my first web2py application, using the downloads available for OS X. I have tried enabling the user registration system, but whenever I try to register a user I get the following error, and it looks to me as if something is broken in the gluon code. Is that right? Ticket ID 1

[web2py] Web2py Mobile Interface

Hi Everyone, I decided that it would be advantageous if i were able to code on the go to fix any issues that I see occurring in my hosted webapps. So I installed web2py on my android tablet. The process was relatively painless and the standard welcome app works perfectly... however when I attem

[web2py] Re: How to set the Pythonpath for the Scheduler

upstart has the "env" directive env PYTHONPATH=/srv/example/src/example/ On Thursday, August 21, 2014 9:44:51 AM UTC+2, Serbitar wrote: > > I want to use modules not in the standard PYTHONPATH to be used by tasks > in the web2py sheduler. > How do I change the PYTHONPATH for a scheduler confi

[web2py] How to set the Pythonpath for the Scheduler

I want to use modules not in the standard PYTHONPATH to be used by tasks in the web2py sheduler. How do I change the PYTHONPATH for a scheduler configured using the web2py-scheduler.conf in init. I tried exporting the PYTHONPATH there, but it didnt work, -- Resources: - http://web2py.com - htt