Yes you are correct plus there was 10,000+ requests a second just hitting
the site I think I really need a load balanced. We are getting on average
500-1000 new members a day.
On Apr 16, 2012 10:59 PM, "pbreit" wrote:
> Don't forget you probably spent quite a bit if time tuning your Pyramid
> app
I defined the following table:
db.define_table('OpeningHours',
Field('nodeID','reference
Node',default='',notnull=True,ondelete='CASCADE',writable=False,readable=False),
Field('dayID','reference
Day',default='',notnull=True,ondelete='RESTRICT'),
Field('fromTime',type='time'),
Fie
Don't forget you probably spent quite a bit if time tuning your Pyramid app.
The best ways to scale are:
1) Cache
2) Cache
3) Cache
Web2py makes caching queries super easy.
If you are serving a lot of static assets, check out Cloudflare for free
CDN.
Yeah the site can't even handle half the load the pyramid version handled.
I really hope I can fix this. Just told some of the members to use it but
it buckles it doesn't use much memory but kills the processor.
The load bandwidth out going went from 0.2MB/sec to 1.6MB/s
On Sun, Apr 15, 2012 at 1
Solved!
Thanks again for your help. yes, I had the db's defined in the model.
But, they *weren't* quite identical. AND, I wanted to get the id from the
"old" table because I will be using it later after I've munged the rest of
the record--to update the original record in the original table.
> On Monday, April 16, 2012 1:57:02 PM UTC-3, Alan Etkin wrote:I think it
probably will, since
> replacing anything with "_" would set compatible table name strings.
My mistake, with Massimo regular expression command the brackets are not
replaced by underscore (they are removed), so I assume th
Thanks Massimo. I wasn't aware of that option. Time to re-read the doc.
On Monday, April 16, 2012 9:30:25 PM UTC+8, weheh wrote:
>
> auth_user_table = db.define_table(
> ... the usual suspects ...
> Field('avatar', 'upload', ondelete='CASCADE', ...)
> )
>
> Using the auth.profile() rou
Doubt this is the problem but your code doesn't look right to me. Did you
say you were trying to move a record from one db into an identical table in
another db? SO would expect to see something like:
db1 = DAL(...
db2 = DAL(...
row = db1.joke(jokenum)
db2.joke.insert(**row.as_dict())
Still can't solve this problem.
here is the new code, which I *think* matches your recommendation:
row = jodb(jodb.joke.id==jokenum).select().first()
jodb.pending.insert(**row.as_dict())
And I still get the seq error for the table:
currval of sequence "pending_id_seq" is
not yet defined
I had sort of a dumb thought after seeing another framework (can't remember
the name): is it possible or desirable to combine controller and view code
in one file? Since controller and view files are almost always used
together, I wondered if it might be easier just to code them in same file
(w
Good one.
You earned a browser bookmark.
Thanks.
On Wednesday, March 7, 2012 4:44:00 AM UTC-5, peter wrote:
>
> As I have commented before, sqlform.grid has a particular way of
> searching. Its combination of search and 'queries' is very powerful.
> However the search does not really work in t
I have restarted postgresql. I have deleted the table and the migration.
I have tried to do a "fake migration" within web2py. Now, this table
seems to be corrupted somehow because the currval for the id_seq of the
table won't update. Wow. What a big mess.
Any clues on how to recover from t
Sorry if I was not clear enough. It was https that had the problem - it was
as though no server existed.
The cause was found to be some firewall magic and unrelated to web2py.
I checked http as well because web2py displayed *please visit http://* on
the console. I wanted to check if there has been
You have to first register your application id in App Engine using the
Administration Console:
https://developers.google.com/appengine/docs/python/gettingstarted/uploading
Hi Peter,
Just to say thank you so much for your posting this, and with this help I
did get it working OK.
@Book Editor. In the absence of other documentation, perhaps this example
ought to be mentioned in the book?
Thanks, David
On Wednesday, 7 March 2012 09:44:00 UTC, peter wrote:
>
>
Thanks. Certainly the documentation. I'll give some thought to whether
there is some other behavior.
Now I have a deeper problem:
currval of sequence "pending_id_seq" is
not yet defined in this session
This refers to the id field. I'll change the model and go out to pgadmin
and manually
>
> I think I am trying to do something very simple, but I don't understand
> row objects (why can't they be a normal Python type instead of a web2py
> class?).
It acts like a dictionary, but you can do row.field instead of having to do
row['field']. It also has a way of storing and returning
>
> You may comment out the line: auth.settings.create_user_groups = False if
> you're getting the table-not-exist error and that should fix it.
>
> As you can see above, I also setup the email account credentials (though
> dummy ones in the code above) in the model, and have tested those
> cre
I think I am trying to do something very simple, but I don't understand row
objects (why can't they be a normal Python type instead of a web2py class?).
I have gotten this error no matter what I try:
insert() takes exactly 1 argument (2 given)
All I want to do is retrieve a row from one table
Hi,
Does any one have experience using Linode's nodebalancer with web2py based
applications?
--
--
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.fittraineronline.com - Fitness Personal Trainers Online
http://www.warplydesigned.com
Hi Anthony,
Thanks for looking into this.
The model code I am using is as follows:
## use PostgreSQL on localhost
db = DAL("postgres://cyan:123456@localhost:5432/mydb")
#
## web2py authentication utilities ##
#
from gluo
>
> 1. when I set *auth.settings.create_user_groups = False*, I suspect that
> 'auth_group' table is not created at all after calling
> 'auth.define_tables()'. Because if I do a 'auth.add_group(...)' after
> 'auth.define_tables()' in a model file, web2py will throw error saying that
> 'auth_gr
Hi group,
Two questions relating to two Auth settings:
1. when I set *auth.settings.create_user_groups = False*, I suspect that
'auth_group' table is not created at all after calling
'auth.define_tables()'. Because if I do a 'auth.add_group(...)' after
'auth.define_tables()' in a model file,
On Monday, April 16, 2012 2:20:03 PM UTC-4, Massimo Di Pierro wrote:
>
> I think it does both. It not, it is a bug.
>
I just tried it, and you're right -- it does delete the old file on update.
Was that fixed recently, or has it always worked that way? I thought I
remembered it not working at so
I don't think so as that would probably cause other saves/updates to fail?
On Mon, Apr 16, 2012 at 11:42 AM, Richard Vézina <
ml.richard.vez...@gmail.com> wrote:
> Could it be permission on file in your prod server (or the failing server)?
>
> Richard
>
> On Mon, Apr 16, 2012 at 2:36 PM, Bruce Wa
Massimo also write a ticket management app here :
http://code.google.com/p/web2py-issuetracker/
Or here :
https://github.com/mdipierro/web2py-appliances/tree/master/IssueTracker
Don't know if there is one more up to date.
But you suppose to be able to configure it so the app collect ticket fro
Could it be permission on file in your prod server (or the failing server)?
Richard
On Mon, Apr 16, 2012 at 2:36 PM, Bruce Wade wrote:
> 1.99.7 and it worked on my old server where I had code and database on the
> same server. Now that I moved database to a different server it doesn't
> work.
>
1.99.7 and it worked on my old server where I had code and database on the
same server. Now that I moved database to a different server it doesn't
work.
On Mon, Apr 16, 2012 at 11:35 AM, Richard Vézina <
ml.richard.vez...@gmail.com> wrote:
> You mean the appadmin controller is not working properl
You mean the appadmin controller is not working properly on update!
Sound like something broke with last version update...
Which version are you using? Not trunk?
Richard
On Mon, Apr 16, 2012 at 2:18 PM, Bruce Wade wrote:
> There is no problem with the database, I can view all the details, I
I think it does both. It not, it is a bug.
On Monday, 16 April 2012 10:27:20 UTC-5, Anthony wrote:
>
> web2py does not like to delete files unless it is told to do so. You can do
>>
>> Field('avatar','upload',autodelete=True)
>>
>> This should work as you expect.
>>
>
> I could be wrong, but if I
You can't connect to https using http as the protocol. Getting a "bad
request" message is exactly what happens when you try. So in your browser,
you need to specifically type https://:3.
On Monday, April 16, 2012 1:42:06 PM UTC-4, Shivakumar GN wrote:
>
> Hi,
>
> I am using python 2.5 on Sol
There is no problem with the database, I can view all the details, I can
use the client facing side to update everything/login etc just the
admin database administration app doesn't save when I make a change.
On Mon, Apr 16, 2012 at 10:02 AM, Richard Vézina <
ml.richard.vez...@gmail.com> wrote
On Apr 16, 2012, at 10:57 AM, Wikus van de Merwe wrote:
> For this type of routing where you don't use complex regular expressions, it
> is better to use the simple router.
> It could make selected functions of the default controller in the default
> application available directly, i.e.
> /f1 ==
Hello,
I have this error the first time i open instant-admin
Traceback (most recent call last):
File "/home/web2py/gluon/restricted.py", line 205,
in restricted exec ccode in environment
File "/home/web2py/applications/webadmin/models/plugin_instant_admin.py",
line 22,
in db = databases.valu
Hi,
I am using python 2.5 on Solaris and web2py 1.99.7
I am trying to get https to work with in built web server as per recipe at
below link.
http://www.web2py.com/AlterEgo/default/show/140
I built ssl module built from source since it was missing in python 2.5
> python web2py.py --nog
For this type of routing where you don't use complex regular expressions,
it is better to use the simple router.
It could make selected functions of the default controller in the default
application available directly, i.e.
/f1 == /my_app/default_controller/f1
To have "/rules" mapped to "/aggat/
Could it be cPickleableStorage now?
2012/4/12 David Zejda
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> After upgrade to 1.99.7. I started receiving this error:
>
> Traceback (most recent call last):
> File "/opt/web2py/gluon/restricted.py", line 194, in restricted
>in code it raise
Ok, in that case, I think you will have to make sure that your prod
database is not corrupted... Can you access database with an other client
then web2py? pg admin 3 maybe if you use postgres...
Then you can try to drop value in auth_user and insert your local dev
values instead, so It will restor
I think it probably will, since replacing anything with "_" would set
compatible table name strings.
There's one caveat:
"abc[something]def" mapping will overwrite the "abc/something/def", so you
cannot have both folders in your mail account.
Although the case is very uneven, perhaps a combine
Johann, Manuele and Massimo,
Thanks for answering my question.
You're right, the problem was somewhere else, in the line before
db.Node.createdOn.represent
db.Node.createdOn.requires=IS_DATETIME(str(T('%Y-%m-%d %H:%M:%S')))
This saves without problem:
db.Node.createdOn.requires=IS_DATETIME(fo
I can log into admin and update code files. I can not update anything in
the database. I guess I should have been more clear.
On Apr 16, 2012 8:36 AM, "Richard Vézina"
wrote:
> Ok, maybe you run in the same problem I had in the pass.
>
> Did you update web2py like this : rm -Rf web2py/
>
> Or som
Hey All,
I'm using the radio button widget in my db. I'm trying to create a more
dynamic form and view that changes as the user clicks each radio button. I
don't mind setting up different databases, if necessary, for each form.
Essentially each time a radio button is clicked, the user needs to
Ok, maybe you run in the same problem I had in the pass.
Did you update web2py like this : rm -Rf web2py/
Or something like that?
If so, you maybe have deleted parameters_443.py file contained in the
web2py root.
This file contain an encrypted copy of your password where web2py look to
confirm
>
> web2py does not like to delete files unless it is told to do so. You can do
>
> Field('avatar','upload',autodelete=True)
>
> This should work as you expect.
>
I could be wrong, but if I recall correctly, autodelete only deletes the
file when the record is deleted, but not when the record is
My issue isn't solved. I wish. I was saying your password issue with the
error message None is solved with a new version. Admin is useless for me
right now in production as I can't update anything with it.
On Mon, Apr 16, 2012 at 7:54 AM, Richard Vézina wrote:
> Yeah, maybe, in dev I use pretty
Yeah, maybe, in dev I use pretty simple password so, maybe there is
constrain about that.
All right if your issue is solved.
Richard
On Mon, Apr 16, 2012 at 10:34 AM, Bruce Wade wrote:
> The None is because you are not meeting the password requirements. That
> error message has been fixed in 1
The None is because you are not meeting the password requirements. That
error message has been fixed in 1.99.7 release.
My issue saves local but doesn't save any changes on my server where my
database server is on a separate computer, and there is no error messages.
On Mon, Apr 16, 2012 at 7:01 A
On Apr 16, 2012, at 7:02 AM, Massimo Di Pierro wrote:
> Shame on me. Than it is a bug. Please open a ticket on google code. web2py
> sets the content-type correctly in gluon/main.html but it seems to lose it
> when an HTTP exception is raised.
It's not just that the content type should be set to
On 16 April 2012 16:03, Massimo Di Pierro wrote:
> No. Batch operations do not bypass the auditing process.
>
Thanks.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
No. Batch operations do not bypass the auditing process.
On Monday, 16 April 2012 08:52:22 UTC-5, Johann Spies wrote:
>
> On 16 April 2012 15:18, Massimo Di Pierro wrote:
>
>> Yes but if you do a batch delete or update web2py has to copy all records
>> from one table to another one by one. That m
Shame on me. Than it is a bug. Please open a ticket on google code. web2py
sets the content-type correctly in gluon/main.html but it seems to lose it
when an HTTP exception is raised.
On Monday, 16 April 2012 08:56:07 UTC-5, Joseph.Piron wrote:
>
> Json indeed :)
>
> On 16 Apr 2012, at 15:44, Jo
With the dev web server when I submit the form I get a none under the first
new password field with 1.99.4 version. It is not changing the password. I
precise that I set the password in the launching web2py box. In that case
the password maybe unchangable.
Richard
On Fri, Apr 13, 2012 at 9:22 PM,
Great!
Thanks
Richard
On Fri, Apr 13, 2012 at 7:33 PM, greenpoise wrote:
> Richard,
> you know what? maybe it does what you want actually because what I get is
> a bunch of records with a txt and one submit button at the end. So,
> basically a grid within a form. I will write it and run it aga
web2py does not like to delete files unless it is told to do so. You can do
Field('avatar','upload',autodelete=True)
This should work as you expect.
On Monday, 16 April 2012 08:30:25 UTC-5, weheh wrote:
>
> auth_user_table = db.define_table(
> ... the usual suspects ...
> Field('avatar',
Json indeed :)
On 16 Apr 2012, at 15:44, Jonathan Lundell wrote:
> On Apr 16, 2012, at 6:24 AM, Massimo Di Pierro wrote:
>> Because IE browsers, when they receive a error page (HTTP x!=200) and the
>> content is less than a certain size, they choose to ignore the content and
>> display an uninf
On 16 April 2012 15:18, Massimo Di Pierro wrote:
> Yes but if you do a batch delete or update web2py has to copy all records
> from one table to another one by one. That may cause a significati slowdown
> that will lock the db for long time. It may have bad consequences.
>
Thanks for your answer
On Apr 16, 2012, at 6:24 AM, Massimo Di Pierro wrote:
> Because IE browsers, when they receive a error page (HTTP x!=200) and the
> content is less than a certain size, they choose to ignore the content and
> display an uninformative canned message instead. web2py injects in the
> content an htm
For me, the advantage i see is to centrally manage(create,change,edit,etc)
all workflow rules of all apps that use workflow.
maybe there is some disadvantagesomewhere else on the line ...
2012/4/16 Carlos Costa
> I think it is.
> What are the advantages with this aproach?
>
> Em 16 de abri
I am beginning to work with jquery, javascript and ajax directly as I work
through tutorials.
I want a grid listing journals with a button for each row which, when
clicked, will open a modal window with another grid (or sqltable) in it
containing a list of articles
published in that journal.
auth_user_table = db.define_table(
... the usual suspects ...
Field('avatar', 'upload', ondelete='CASCADE', ...)
)
Using the auth.profile() routine, if user uploads a profile picture, it
properly appears under the uploads directory. However, if user uploads a
new profile picture, the
Because IE browsers, when they receive a error page (HTTP x!=200) and the
content is less than a certain size, they choose to ignore the content and
display an uninformative canned message instead. web2py injects in the
content an html comment to make it just long enough so that IE browser do
n
As Manuele says, the error is somewhere else (some unbalances bracket
before) yet this:
db.Node.createdOn.represent = lambda v: v.strftime('%d/%m/%Y') # old syntax
should be
db.Node.createdOn.represent = lambda v, row: v.strftime('%d/%m/%Y') # new
syntax
the old syntax breaks grid.
On Monday
Yes but if you do a batch delete or update web2py has to copy all records
from one table to another one by one. That may cause a significati slowdown
that will lock the db for long time. It may have bad consequences.
On Monday, 16 April 2012 04:56:54 UTC-5, Johann Spies wrote:
>
> Will this audi
oops there is a typo in anyserver
replace gnuicorn with unicorn in the source. I just fixed it in trunk.
On Monday, 16 April 2012 01:39:26 UTC-5, Rahul wrote:
>
> It gives me an error -
> *-bash-3.2$ python anyserver.py -s gunicorn -i 72.3.247.225 -p 9065*
> starting gunicorn on 72.3.247.225:906
Hi gents !
I was working on an extjs client intended to discuss with web2py when I
stumbled upon this weird behaviour:
with my client calling "PUT /defaut/api/alarms/1.json", I want the server
to respond a 409 error code with good json return {success: false, errors:
{...}}
and use raise HTTP(
No, I've been tied up doing other (non-web2py) projects lately. I hope to
get back to being more active here in a couple of weeks.
On Sunday, April 15, 2012 2:54:45 AM UTC-4, Gour wrote:
>
> On Mon, 16 Jan 2012 12:41:32 -0800 (PST)
> Ross Peoples
> wrote:
>
> Hello Ross,
>
> > The good news is I
Okay. The
if 0:
from gluon import *
request, session, response, T, cache = current.request,
current.session,current
.response, current.t, current.cache
from gluon.dal import DAL
from gluon.tools import Auth, Service, Crud
db = DAL()
auth = Auth()
service = Service()
I think it is.
What are the advantages with this aproach?
Em 16 de abril de 2012 07:44, António Ramos escreveu:
> I suggest a workflow as a service.
> I have a database where i define all workflows for all databases.
>
> I have something like this way in a Lotus Notes environment.
> I get away wi
I suggest a workflow as a service.
I have a database where i define all workflows for all databases.
I have something like this way in a Lotus Notes environment.
I get away with it very nicely. :)
If i keep control fields in my record
like,
readers
authors
step
next step formula
code to execute in
Il 16/04/2012 10:25, Annet ha scritto:
In db.py I defined a table:
db.define_table('Node',
Field('createdOn',type='datetime',writable=False,readable=False),
migrate=False)
db.Node.createdOn.default=request.now
db.Node.createdOn.requires=IS_DATETIME(str(T('%Y-%m-%d
%H:%M:%S')))
Now, wh
On 16 April 2012 10:25, Annet wrote:
> In db.py I defined a table:
>
> db.define_table('Node',
> Field('createdOn',type='datetime',writable=False,readable=False),
> migrate=False)
>
> db.Node.createdOn.default=request.now
> db.Node.createdOn.requires=IS_DATETIME(str(T('%Y-%m-%d %H:%M:%S')
Will this auditing also work with changes in data that does not come from
form-submission? Say for instance I run a batch update/delete from a
script or using 'selectable' in a grid to select a number of records to be
deleted, will that not bypass the auditing?
I ask because calculated fields are
On 14 April 2012 16:13, weheh wrote:
> I'm trying without success to get web2py mail working with an SSL
> connection. I've searched the forum and come up with this:
>
> mail.settings.tls = True
> mail.settings.login = False # I am not using auth in this case
> mail.settings.server = 'mail.mydom
Thanks Massimo..
On Sunday, 15 April 2012 20:19:48 UTC+5:30, Massimo Di Pierro wrote:
>
> Look into gluon/contrib/login_methods/oauth2_auth.py there is sample code
> in there.
>
> On Saturday, 14 April 2012 09:33:51 UTC-5, SB wrote:
>>
>> how to access google spreadsheets using Oauth2 in web2py.
In db.py I defined a table:
db.define_table('Node',
Field('createdOn',type='datetime',writable=False,readable=False),
migrate=False)
db.Node.createdOn.default=request.now
db.Node.createdOn.requires=IS_DATETIME(str(T('%Y-%m-%d %H:%M:%S')))
Now, when I add this validator:
db.Node.createdO
thanks keith, i understand the difference between 'you' and 'u', was just
trying to be fast and i was surfing via my Blackberry smartphone not a PC
so needed shortcuts. Thanks anyways, would check out for the command line
prompt in my control panel.
Once again, many thanks
On Sun, Apr 15, 2012
On Sun, 15 Apr 2012 09:51:39 +0100
Chibuzo Ottih
wrote:
> Yeah, with instantpress, you can manage users, create tags and
> categories, publish articles in few seconds and more. It also has the
> ability to manage comments.
Thank you.
> To see more, I think you should download it and add it as
77 matches
Mail list logo