[web2py] Re: Strange behaviour of URL.verify() / @requires_signature() with big vars

I'm still struggeling with this problem - does anyone have an idea? I narrowed it a bit further down: If the list I'm passing as vars contains 10 items or less @auth.requires_signature() validates correctly and access to the function is granted. However, if the list has 11 or more items I get "

Re: [web2py] .ics file name

> Not just this, the text inside of the file should be utf-8 encoded... > Where this file come from (which software generate it)? > > You have to make sure that it is generated correctly (right encoding), in > thunderbird for instance you can specified it if I remember. In outlook it > may be

[web2py] Re: gunicorn vs uwsgi

On Thu, 3 Oct 2013 06:24:09 +0200 "Roberto De Ioris" wrote: > And don't you think it would be better to understand why ? Sure, I just said it did not work out-of-the-box as with gunicorn. > Maybe it is an easy thing, maybe it is something "isp-specific" that > would be great to address. I'll i

[web2py] Re: Scheduler question

Hi Niphlod, If I could add to the questions (I'm having some success with the scheduler but there's a few gaps in my understanding): What process removes the rows from the scheduler_worker table ? Does it make any difference to Kill a worker by updating it's status or by just Ctl-C (Or closing

Re: [web2py] Re: Multiple domains accessing all apps through URL

Yes, adding "exclusive_domain=True" helped. I get "invalid function (default/...)" now, which is what I wanted. Thank you, Jonathan. domains = { 'domain1.com': 'app1', 'domain2.com': 'app2'}*,* *exclusive_domain=True* * * * * -- Resources: - http://web2py.com - http://web2py.com/boo

[web2py] Re: ordered lists in markmin ... I always get unordered lists

I'll fix and send a PR. > PR sent. -- 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

[web2py] Re: ordered lists in markmin ... I always get unordered lists

On Thursday, 3 October 2013 09:19:42 UTC+10, Massimo Di Pierro wrote: > > No. Could this be the css? have you looked at the source? > Yes, you're are correct. The HTML is but it is styled to a bullet. I'll fix and send a PR. -- Resources: - http://web2py.com - http://web2py.com/book (Documen

Re: [web2py] Re: Multiple domains accessing all apps through URL

On 2 Oct 2013, at 10:36 PM, Anthony wrote: > A couple years ago, Jonathan seemed to think this behavior was a bug and > alluded to a fix in trunk: > https://groups.google.com/d/msg/web2py/elnV_6Ntw3E/KWNlpoJfpWAJ. See if setting exclusive_domain=True in the router helps. > > Anthony > > On W

Re: [web2py] Re: gunicorn vs uwsgi

> >> regarding the https problem, well, if the password file is correct it >> should works transparently (uWSGI honour the X-Forwarded-SSL header >> sent by the webfaction proxy). > > First, I'm not on webfaction, but on something similar to it and it does > not work with uWSGI, while it works wit

[web2py] Change SQLFORM.grid Submit button label

Hello All, I want change the label of Submit button in the SQLFORm.grid. I found two solutions in the forum and both seems to be not working. The first solution given here Changing SQLFORM.grid submit label from python without javascript?

[web2py] Re: User Login causes error on GAE

Version 2.6.4 Upgrade seemed to go OK. Soon after the upgrade I added auth.settings.extra_fields in db.py to add an extra field to the user. This seemed to trigger the login error, and removing that extra field has not resolved the problem. On Thursday, October 3, 2013 3:18:12 AM UTC+4, Massimo

[web2py] Re: Multiple domains accessing all apps through URL

A couple years ago, Jonathan seemed to think this behavior was a bug and alluded to a fix in trunk: https://groups.google.com/d/msg/web2py/elnV_6Ntw3E/KWNlpoJfpWAJ. Anthony On Wednesday, October 2, 2013 7:23:44 PM UTC-4, Massimo Di Pierro wrote: > > You only prevent this from within the apps >

[web2py] Re: Web2py on apache2 is slow

No clue. What do you mean by slow? Anything in python might be considered slow comparatively to php. On Tuesday, October 1, 2013 4:09:38 AM UTC-7, Jayakumar Bellie wrote: > > I have two servers, both are linux same configuration (OS and hardware). > > I have a program running in PHP in one serve

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

You can use it without the @, just have to specify the user and pass in the connection string. If you want to use a domain login, put the doman then the backslash then the username, in the username field. 'trusted_connection' yes, that means it will pass through the authentication that the web2

[web2py] Re: Multiple domains accessing all apps through URL

You only prevent this from within the apps if request.env.http_host != '': redirect() or from the Apache config file. On Wednesday, 2 October 2013 06:55:51 UTC-5, Andriy wrote: > > I`ve successfully connected 2 domains to my apache-web2py configuration > using routes.py. But I have one

[web2py] Re: Unsuccessful password reset

What is this supposed to do? {{=XML('%(key)s')}} Are you sure you are not looking for: Go to password reset Is key a variable? Anyway, I am not sure your problem comes from this code. On Wednesday, 2 October 2013 08:14:17 UTC-5, lesssugar wrote: > > Sorry, Massimo, but I really don't get it.

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

I'm not a database expert. Aren't both of those connection strings equivalent in the DAL? Why are you saying they are different? Does the Trusted_Connection = YES part tell it to connect to the database using Windows Authentication? The main thing I'm trying to do is tell it to connect via

[web2py] Re: ordered lists in markmin ... I always get unordered lists

No. Could this be the css? have you looked at the source? On Wednesday, 2 October 2013 04:04:20 UTC-5, Tim Richardson wrote: > > Documentation says this should become an ordered list: > > + Line 1 > + Line 2 > + Line 3 > > > but when editing source in the book (trunk), above markup becomes an > u

[web2py] Re: User Login causes error on GAE

Which web2py version? Was this on upgrade of what triggered the problem? On Tuesday, 1 October 2013 23:48:18 UTC-5, Andy W wrote: > > My application works fine locally with rocket/SQLlite but on GAE it now > fails when a user logs in. > It was working previously. The problem appeared when I added

Re: [web2py] Re: Is is possible to create a postgres database from web2py application?

Creating a database on each request seems strange, could make sense with in memory sqlite. A transaction represents a state in a space. In postgresql that space is exactly a single db (maybe it will change in the future). You may want to use a what postgresql calls "schema" you can use it but with

Re: [web2py] Re: Bad Request Http body is incomplete

Thank you for your time. Its nothing like what i have. In my case my form is saved correctly. It happened to one user only and i dont know if he still has the same problem. Tomorrow i will check again Thank you 2013/10/2 Sebastián Tromer > Hey, I was running into the same problem. I hope th

Re: [web2py] Re: Is is possible to create a postgres database from web2py application?

let's say it's not a normal thing to do, and DAL doesn't support it out of the box. the problem with postgresql is that a create database should be issued in a non-transaction environment, that is what instead DAL uses by default. Instead of fiddling with DAL, just use raw psycopg commands to do

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

use mssql://oledb_connection_string where oledb_connection_string is the "default" oledb formatted connection string. http://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/ basically as long as there isn't a @ in it, the connection string will be used as it is with pyodb

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

Brian and/or Massimo, Did this issue ever get resolved so that the DAL can connect with windows authentication? If so, what is the syntax for the connection string? Thanks. - Josh -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: help with user_signature

Sorry, I made a silly error is using the user_signature. It should be a part of URL call. This line should read (note the change in ")" bracket) grid = SQLFORM.grid(query, links = [lambda row: A('Results', _class='btn',_href =URL("default","calculate", args=[row.id],user_signature=True, hash_vars

[web2py] HA/Cluster Feature Request?

Any thoughts on this for clustering and High Availability? Could a feature be added to web2py to store session information in the DB, so using sticky session is optional, or if a server goes down it can get the session information. e.g. Proxy with stick session too server A and B Web2py on ser

[web2py] Re: pie.htc and web2py

Paolo, Anthony, Thanks for your help, I just tried and it works! Le mardi 1 octobre 2013 16:22:06 UTC+2, Paolo Caruccio a écrit : > > According to pie istructions > * > * > >> *this path is relative to the HTML file being viewed, not the CSS file >> it is called from.* > > > if you put the pi

[web2py] Accessing Database Administration (appadmin) interface

hi there need some help. i have deployed web2py using Mysql, i have imported a database in a .sql file and i have edit the DAL and set migration to true : (db = DAL('mysql://root:''@localhost/newsite',pool_size=1,check_reserved=['all'], migrate=True). The application is able to run but the iss

[web2py] Re: pie.htc and web2py

Paolo, Anthony, Thanks for your help. I followed the solution of Paolo and it works! My css rule was wrongly writed. Thanks again for your help! Bilal Le mardi 1 octobre 2013 15:31:14 UTC+2, Bilal El a écrit : > > Hello, > > I'm working on a project for users using ie7. And I want to user > b

[web2py] Re: Bad Request Http body is incomplete

Hey, I was running into the same problem. I hope this can solve your problem... I'm developing a RESTful API to add new resources (records in DB) I'm exposing the API using this code in my default.py controller: @request.restful() def api(): rest = module_api.RESTful(db, auth.user_id) de

[web2py] help with user_signature

I am using version 2.6.4 on Windows 7 machine and having a problem with using user_signature and auth.requires_signature. I am using SQLFORM.grid to display a list of scenarios created by the logged-in user. I included an additional button "Results", which calls another function "calculate" an

Re: [web2py] Re: Is is possible to create a postgres database from web2py application?

Creating an app that create database... There is much more thing to consider and there is already thing like webmin for that. Richard On Wed, Oct 2, 2013 at 3:32 PM, Richard Vézina wrote: > Why would someone do that?! > > Richard > > > On Wed, Oct 2, 2013 at 1:48 PM, Cliff Kachinske wrote: > >

Re: [web2py] Re: Is is possible to create a postgres database from web2py application?

Why would someone do that?! Richard On Wed, Oct 2, 2013 at 1:48 PM, Cliff Kachinske wrote: > Oops, maybe not. > > Psycopg2 certainly allows table creation, so maybe it's an adapter > question rather than a dal question. > > > On Wednesday, October 2, 2013 1:44:50 PM UTC-4, Cliff Kachinske wrot

[web2py] Re: gunicorn vs uwsgi

On Wed, 2 Oct 2013 17:32:46 +0200 "Roberto De Ioris" wrote: > > The problem is that when you are just learning, the first objective is > getting things done, you are generally not interested in problems you > do not even immagine will arise (soon or later) Correct. > It is not (only) a matter

[web2py] Re: Is is possible to create a postgres database from web2py application?

Oops, maybe not. Psycopg2 certainly allows table creation, so maybe it's an adapter question rather than a dal question. On Wednesday, October 2, 2013 1:44:50 PM UTC-4, Cliff Kachinske wrote: > > Not for the fainthearted, but this should work. > > db = > DAL('postgres://user_authorized_to_creat

[web2py] Re: Is is possible to create a postgres database from web2py application?

Not for the fainthearted, but this should work. db = DAL('postgres://user_authorized_to_create_db:password_for_that_user@localhost:5432/db_owned_by_that_user, migrate=False) stmt = """CREATE DATABASE foo WITH OWNER some_user_in_the_system""" db.executesql(stmt ... On Wednesday, October 2, 2013

[web2py] Re: How to program a form for one to many relations?

Yeah but this isn't cool if I use further database queries. -- 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 subs

[web2py] Re: How to program a form for one to many relations?

Or you could store all the things as a string and split it nicely in the view, when displaying ;) On Wednesday, October 2, 2013 5:16:18 PM UTC+2, Andreas Wienes wrote: > > Hey guys, > > in the web2py-book is an example for a one-to-many relation. > http://www.web2py.com/books/default/chapter/29/

Re: [web2py] Re: gunicorn vs uwsgi

> > Well, I was mostly thinking if/whether uWSGI's power/advantage is > becoming more obvious when serving big web sites with *LOT* of traffic > where one wants to squueze last drop of performance. The problem is that when you are just learning, the first objective is getting things done, you ar

[web2py] How to program a form for one to many relations?

Hey guys, in the web2py-book is an example for a one-to-many relation. http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#One-to-many-relation db.define_table('person', Field('name'), format='%(name)s') db.define_table('thing',

RES: [web2py] Re: LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

Hello master, Thank you, that was exactly ... Is the log: updated web2py, copy the files .js for application. De: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Em nome de Anthony Enviada em: quarta-feira, 2 de outubro de 2013 11:26 Para: web2py@googlegroups.com Assunto: [web2py]

[web2py] Re: LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

Did you copy the new web2py.js file to your application? On Wednesday, October 2, 2013 10:25:11 AM UTC-4, Meir wrote: > > Hello community! > > > > I have in my application using web2py 2.5 LOAD feature working perfectly. > > I migrated my application to web2py 2.6 and stopped working LOAD, but n

[web2py] LOAD web2py 2.5 - OK | LOAD web2py 2.6 nothing...

Hello community! I have in my application using web2py 2.5 LOAD feature working perfectly. I migrated my application to web2py 2.6 and stopped working LOAD, but not in error ... Any idea? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2

[web2py] Re: gunicorn vs uwsgi

On Wed, 2 Oct 2013 15:16:23 +0200 "Roberto De Ioris" wrote: > While the "complexity" of uWSGI in latest times is questionable > (documentation improved a lot and the quickstart introduce to > basically everything you need), i always suggest newcomers to go > pure-python (rocket, gunicorn, flup...

[web2py] Re: Scheduler question

Il giorno mercoledì 2 ottobre 2013 15:15:16 UTC+2, Marin Pranjić ha scritto: > > Hi, > > I have a task queue that runs in the background. I want to switch to > scheduler because I need more workers. > Queued tasks are long running (video transcoding, 10-20 minutes each). > > 1. If I terminate (C

Re: [web2py] CREATE DATABASE cannot run inside a transaction block

I recommand you using psycopg2 adapter instead of pg8000 that is not as well tested... Richard On Wed, Oct 2, 2013 at 10:11 AM, Richard Vézina wrote: > See my answer to your precedent question!! > > Richard > > > On Wed, Oct 2, 2013 at 8:57 AM, at wrote: > >> Hi, >> >> I am getting following

Re: [web2py] CREATE DATABASE cannot run inside a transaction block

See my answer to your precedent question!! Richard On Wed, Oct 2, 2013 at 8:57 AM, at wrote: > Hi, > > I am getting following error message while trying to run statements: > db0 = DAL('postgres://adminuser:testing@localhost/postgres') > result=db0.executesql('create database mydb owner

Re: [web2py] Is is possible to create a postgres database from web2py application?

You mean : createdb ... ? I think no, you have to create it in postgres with createdb or pgAdminIII and then write the DAL connection string according to your created database : database name, username, password, etc. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?se

Re: [web2py] gunicorn vs uwsgi

+1: I really don't see the issue with uwsgi configs . Il giorno mercoledì 2 ottobre 2013 15:16:23 UTC+2, Roberto De Ioris ha scritto: > > > > Hello, > > > > > > I'm testing both gunicorn and uwsgi with web2py on my (production) > > server with nginx acting as front-end/reverse-proxy. Deployin

[web2py] Is is possible to create a postgres database from web2py application?

Is is possible to create a postgres database from web2py application? Thanks & Regards -- 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

Re: [web2py] .ics file name

Not just this, the text inside of the file should be utf-8 encoded... Where this file come from (which software generate it)? You have to make sure that it is generated correctly (right encoding), in thunderbird for instance you can specified it if I remember. In outlook it may be impossible, so y

Re: [web2py] gunicorn vs uwsgi

> Hello, > > > I'm testing both gunicorn and uwsgi with web2py on my (production) > server with nginx acting as front-end/reverse-proxy. Deploying of > gunicorn is pure simplicity which I like (it reminds me on webpy) and I > can access web2py's admin via https, while having problem to do the same

[web2py] Re: Multiple domains accessing all apps through URL

Its a trunk version, that I`ve took between versions 2.6.3 and 2.6.4. -- 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 yo

[web2py] Scheduler question

Hi, I have a task queue that runs in the background. I want to switch to scheduler because I need more workers. Queued tasks are long running (video transcoding, 10-20 minutes each). 1. If I terminate (Ctrl+C) scheduler process, scheduler_run record is STOPPED and scheduler_task record is back

[web2py] Re: Unsuccessful password reset

Sorry, Massimo, but I really don't get it. Is the slash causing the problem? I use '[controller]/[view.html]' to render other emails and it's all ok. I even tried to do it this way in the mailing view: Go to password reset - and nothing, still the same error. I would be grateful for another h

[web2py] CREATE DATABASE cannot run inside a transaction block

Hi, I am getting following error message while trying to run statements: db0 = DAL('postgres://adminuser:testing@localhost/postgres') result=db0.executesql('create database mydb owner user1;') ('ERROR', '25001', 'CREATE DATABASE cannot run inside a transaction block') Can someone help

[web2py] Re: Table inheritance: _before_insert?

No, passing a table object into db.define_table() only copies the tables fields, not its other attributes. Anyway, if you want to set the default value for a field, you would do it using the "default" argument to Field(): standard_fields = db.Table(db, 'standard_fields', Field('created_on',

[web2py] gunicorn vs uwsgi

Hello, I'm testing both gunicorn and uwsgi with web2py on my (production) server with nginx acting as front-end/reverse-proxy. Deploying of gunicorn is pure simplicity which I like (it reminds me on webpy) and I can access web2py's admin via https, while having problem to do the same with uwsgi.

[web2py] Re: Multiple domains accessing all apps through URL

What version of web2py? This came up a long time ago, but I thought it was resolved. On Wednesday, October 2, 2013 7:55:51 AM UTC-4, Andriy wrote: > > I`ve successfully connected 2 domains to my apache-web2py configuration > using routes.py. But I have one problem - all apps are accessible from

[web2py] Multiple domains accessing all apps through URL

I`ve successfully connected 2 domains to my apache-web2py configuration using routes.py. But I have one problem - all apps are accessible from one-another if I add app-name to domain URL. For example, I defined: domains = { 'domain1.com': 'app1', 'domain2.com': 'app2'} www.domain1.co

[web2py] Re: pie.htc and web2py

I use PIE.htc with web2py, it works as intended. Originally, the problem was that web2py did not recognize the .htc extension and therefore served it with the wrong file type by default. But that was fixed somewhere around web2py 1.99.x, gluon.contenttype should now contain the proper value for

[web2py] ordered lists in markmin ... I always get unordered lists

Documentation says this should become an ordered list: + Line 1 + Line 2 + Line 3 but when editing source in the book (trunk), above markup becomes an unordered list ... Am I doing something wrong? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

Re: [web2py] Re: Forcing SSL mode (on GAE)

Hi, you use the yaml configuration to force ssl, such as: handlers: - url: /youraccount/.* script: accounts.py login: required secure: always see https://developers.google.com/appengine/docs/python/config/appconfig#Python_app_yaml_Secure_URLs Cheers! pd Am Donnerstag, 7. Februar 2013

[web2py] Re: web2py how does it get executed

Thank you. Let me digest that. I am a database guy :) On Wednesday, October 2, 2013 1:13:26 AM UTC+5:30, Niphlod wrote: > > web2py.py is the main wrapper for presenting the widget and starting the > rocket webserver (fine for development and small-sized intranets). > In production, web2py.py is n

Re: [web2py] Re: crud forms for multiple records? Multiple tables?

thanks rischard. On Tuesday, 1 October 2013 19:00:49 UTC+5, Richard wrote: > > But you can mimick crud authentication with > auth.has_membership('role_name') or auth.has_permission(...), read the book > about that. > > Richard > > > On Tue, Oct 1, 2013 at 9:59 AM, Richard Vézina > > > wrote: >