HI Again...
I am trying to find out if there is a ajax grid control to select
display and select items. Also a drop down combo box.
--
...
Teddy Lubasi Nyambe
Opensource Zambia
Lusaka, ZAMBIA
Cell: +260 97
Hi,
I generate the CA certificate and private key using OpenSSL on my Windows
XP machine:
openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout
private_key.key -out server.crt
and able to deploy to Rocket server :
web2py.py -a password -i 127.0.0.1 -p 8000 -c
Done. Issue 1135.
Thanks!
On Saturday, November 3, 2012 2:23:03 AM UTC+13, Massimo Di Pierro wrote:
Can you please open a ticket about this. We can fix it asap.
On Friday, 2 November 2012 02:32:07 UTC-5, Mark Kirkwood wrote:
Suppose I have a simple controller like:
I'd like to have an application folder on dropbox, so I've replaced the
application folder with a link on the folder in dropbox -- but it doesn't
work. The problem is not dropbox related I think -- it's more an issue of
the shortcut link in windows. Any workaround?
--
Hello,
I still think the [Wiki] should not be displayed if you are not logged
in. A wiki administrator would be logged in. The general public don't
need to see it.
The change is a little more complicated than I first suggested. There is
more happening after the if self.auth.user:
Hi
Did you implement this?
After trying Whoosh (and finding dificult to implement stemmer/lematization
for my language) i'm looking for another solution.
Is sunburnt the best solution to use solr with python/web2py?
Did you try solrpy?
Andrej
On Friday, July 6, 2012 8:45:21 PM UTC+2, David
too much certificates there for ssl. one key, one cert.
ca-cert is used if you're willing to auth users through x509, but given
that your understanding on certificates is basic I'd say you don't need it.
Il giorno martedì 6 novembre 2012 04:00:37 UTC+1, Amit ha scritto:
Thanks for your
You are right Niphold, I am able to deploy the certificate and start the
web server without using --ca-cert option,But I have to use X509
authentication and for that I have written below code :
*db.py :*
from gluon.contrib.login_methods.x509_auth import X509Auth
Interesting!
2012/11/6 Emilius Omeen om...@bk.ru
in current realization web2py app connect only with mysql db, and Asterisk
get sip peers configuration from DB, Asterisk get dialplan configuration
from DB too. In next versions I think need to add possibility to change
asterisk conf files
Thanks Niphlod this is a really clear explanation. It seems to me somewhat
clearer than the section in the book on migrations. Maybe you could refresh
the bit in the book with some of this post.
Peter
On Monday, 5 November 2012 21:04:36 UTC, Niphlod wrote:
in the normal way (i.e. a new
hem... one thing is helping you to create certs and key for a SSL protected
webserver, quite another to help you managing a credential store (I really
don't have time for that).
You have problems on finding out what OpenSSL is and want to manage X509 ?
Really ?
Maybe it's time to read some
I want to export a certain query in SQLFORM.grid to a CSV, but once I press
on the (any) export option bellow the SQLFORM.grid, it exports the whole
table and not just the ones meeting the certain criteria.
Any ideas?
--
I suggest looking at code gluon/contrib/login_methods/x509_auth.py.
Basically you can extract anything from client supplied cert and use it
with the auth tables of web2py. That is really simple.
The tedious part id getting to know what stuff you can put in the cert.
That is more related to
Hi,
I'm working on a site, for my company. I want to give only access to
accounts :
- listed in my ldap server
or
- listed in local Auth db().
So, I don't want other people to be able to register.
This is my Auth() config (Some values I replaced with '*' for
confidentiallity sake) :
###
I do not want the wiki menu to be displayed to anyone except an 'admin' and
I hope that this option will eventually become available.
Until then, this is my workaround solution:
Create a view for the wiki controller function. Place inside that view
this script:
{{if not
Hi yes, I'm using Apache SOLR ... its really proven stable solution with
enough documentation. In python I have used mySolr
http://mysolr.redtuna.org/en/latest/ which is actively developed and has
enough features, developers respond in github discussion etc. ... and
plays well with web2py. (I
Hi Michele,
I used Simpatica to generates the certificates but failed to deploy to the
web2py server, please check once the first mail in this mail chain where I
explained the problem in details.
Regards,
Amit
On Tue, Nov 6, 2012 at 4:52 PM, Michele Comitini michele.comit...@gmail.com
wrote:
Hi Amirshk
Good opportunity to learn by trying some experimentation at the commandline.
For example, open up a shell:
python web2py.py -S yourapp -M
query = (db.credit_transactions_tags.transaction_ref == 9)
rows = db(query).select()
UL([LI(r.id) for r in rows]).xml()
Note:
1.
Hey there! :)
Other day, other doubt. :P
In my controller I define a form with SQLFORM.factory. This form contains a
dropdown.
Here is the code.
def mansioni():
form = SQLFORM.factory(
Field('just_a_dropdown', requires=IS_IN_SET({'first_choice': 'First
choice', 'second_choice':
Is there a way to run a Controller or Model Function in a wiki page created
with auth.wiki()
I am thinking some like
{{ =insertImage(5) }}
as you would have in a view.
Thanks
Simon
--
I would just try to play around with the callback function...
def callback(): query = (db.page.id == db.comment.page_id) \
( (db.page.title.contains(request.vars.keyword) | \
(db.comment.body.contains(request.vars.keyword) )
pages =
What is your python version?
2012/11/6 Amit amit.khaw...@gmail.com
Hi Michele,
I used Simpatica to generates the certificates but failed to deploy to the
web2py server, please check once the first mail in this mail chain where I
explained the problem in details.
Regards,
Amit
On Tue,
I am using Python 2.7.2.
On Tue, Nov 6, 2012 at 6:33 PM, Michele Comitini michele.comit...@gmail.com
wrote:
What is your python version?
2012/11/6 Amit amit.khaw...@gmail.com
Hi Michele,
I used Simpatica to generates the certificates but failed to deploy to
the web2py server, please
https://github.com/web2py/web2py/blob/master/gluon/main.py#L824
The log seems to say that your certificate file is not there, or not
accessible
mic
2012/11/6 Amit amit.khaw...@gmail.com
I am using Python 2.7.2.
On Tue, Nov 6, 2012 at 6:33 PM, Michele Comitini
michele.comit...@gmail.com
I have used below link to generate server certificates, client certificates
and CA certificates, imported client and CA certificates to Mozilla
Firefox browser and then deploy server certificates and CA certificate to
the Rocket server :
D:\web2py2.1.1\web2pyweb2py.py -a password -i 127.0.0.1
On 6 November 2012 12:50, Aurelijus Useckas aurelijus.usec...@gmail.comwrote:
I want to export a certain query in SQLFORM.grid to a CSV, but once I
press on the (any) export option bellow the SQLFORM.grid, it exports the
whole table and not just the ones meeting the certain criteria.
This
This helps. I will take a closer look today.
On Tuesday, 6 November 2012 01:58:38 UTC-6, Neil wrote:
It seems to be there, as I can import it from a normal python shell. Here
is what I get from the web2py shell:
from matplotlib.projections.geo import AitoffAxes
Traceback (most recent call
This is not normal and it is scary. It could be a ldap issue of a
ldap_login issue. I will check it asap today.
Massimo
On Tuesday, 6 November 2012 05:24:26 UTC-6, apinho wrote:
Hi,
I'm working on a site, for my company. I want to give only access to
accounts :
- listed in my ldap
requires=IS_EMPTY_OR(IS_IN_SET())
On Tuesday, 6 November 2012 06:46:24 UTC-6, David Sorrentino wrote:
Hey there! :)
Other day, other doubt. :P
In my controller I define a form with SQLFORM.factory. This form contains
a dropdown.
Here is the code.
def mansioni():
form =
OK
On Tuesday, November 6, 2012 3:35:10 PM UTC+2, Johann Spies wrote:
On 6 November 2012 12:50, Aurelijus Useckas
aureliju...@gmail.comjavascript:
wrote:
I want to export a certain query in SQLFORM.grid to a CSV, but once I
press on the (any) export option bellow the SQLFORM.grid, it
one sec.
export is meant to give the user the full resultset he can access (let's
say, offline consultation).
Currently, only the with hidden cols exports honour the current query.
Before calling it a bug we should agree on what functionalities expose on
the grid .
Il giorno martedì 6 novembre
Hi, I am facing the problem that my Login (.../user/login) form uses
translations for its labels and I need to forbid this behavior. What is the
correct way of doing this?
Thanks, Jan
--
More specifically. You are shadowing the crud usually defined in db.py on
your models with the name of your function which is also called crud.
http://en.wikipedia.org/wiki/Variable_shadowing
Segunda-feira, 5 de Novembro de 2012 19:04:29 UTC, Thiago Abreu escreveu:
I'm trying to generate a
On 6 November 2012 15:57, Niphlod niph...@gmail.com wrote:
one sec.
export is meant to give the user the full resultset he can access (let's
say, offline consultation).
Currently, only the with hidden cols exports honour the current query.
Before calling it a bug we should agree on what
I would personally expect the export to give the representation only of the
fields I've made a query for.
On Tue, Nov 6, 2012 at 4:10 PM, Johann Spies johann.sp...@gmail.com wrote:
On 6 November 2012 15:57, Niphlod niph...@gmail.com wrote:
one sec.
export is meant to give the user the full
to me instead it's useful to let them download the whole table are we
saying we should support 6*2 = 12 formats (current 6, with filters and
without filters) ? How would you name them ?
--
auth.messages settings... these are the defaults, but they get to be
translated by default (and normally is a good thing). If you set them as
auth.messages.label_first_name = 'test' they shouldn't be translated at all.
label_first_name='First name',
label_last_name='Last name',
Hi Massimo, and thank you for your reply. :)
I had already tried requires=IS_EMPTY_OR(IS_IN_SET()) and it seems not
to work. The form is not accepted because the selected value is not in the
set.
Perhaps I am missing something!?
Cheers,
David
On 6 November 2012 14:42, Massimo Di Pierro
Hi, thanks for quick hint. Tried adding auth.messages.label_password=
'Password' into my model, but the label still gets translated. I modified
it to 'test', but the label didnt change.
Jan
Dne úterý, 6. listopadu 2012 15:29:48 UTC+1 Niphlod napsal(a):
auth.messages settings... these are the
self.subject.Email is [] i.e. an empty list. Check if that is the problem.
mic
Il giorno 06/nov/2012 14:32, Amit amit.khaw...@gmail.com ha scritto:
I have used below link to generate server certificates, client
certificates and CA certificates, imported client and CA certificates to
if you don't change the string that has already a translation it gets
translated.
try with auth.messages.label_password= 'Password ##fixed in english'
Il giorno martedì 6 novembre 2012 15:56:50 UTC+1, Jan Rozhon ha scritto:
Hi, thanks for quick hint. Tried adding auth.messages.label_password=
How about
IS_EMPTY_OR(IS_IN_SET(,zero=''))
On Tuesday, 6 November 2012 08:31:49 UTC-6, David Sorrentino wrote:
Hi Massimo, and thank you for your reply. :)
I had already tried requires=IS_EMPTY_OR(IS_IN_SET()) and it seems not
to work. The form is not accepted because the
Hello, I have the following table that worked in web2py 1.99.7, but now I
upgraded to 2.2.1, and I got this error that I don't know how to solve:
Traceback (most recent call last):
File
/home/dewes/Dropbox/desenvolvimento/novo_web2py/web2py/gluon/restricted.py,
line 212, in restricted
I put a number of drop-down menus in model/menu.py
On Safari, these drop-down menus have some flickering/ghost problems. The
problem shows up consistently when you move the mouse pointer *quickly* to
different drop-down lists.
There doesn't seem to be a problem on Chrome.
I suspect it has to
I think it depends on how many records are in the table.
If you get a couple million rows, that's quite a load for a spread sheet to
import.
On Tuesday, November 6, 2012 9:24:26 AM UTC-5, Niphlod wrote:
to me instead it's useful to let them download the whole table are we
saying we
The issue is that SQLite allows to do:
something = []
db(db.tablename.fieldname.belongs(something)).select()
However this fails on postgres (not sure what about the others).
I am using SQLite for development so I don't notice the error until I move
the code into production.
Not only I have
format = '%(role)' is not valid python. a mapping is something like
%(variablename)s . in this case, it gets passed to the user dictionary,
so you should use a variablename that is a key of the user dict.
Il giorno martedì 6 novembre 2012 16:51:14 UTC+1, Dewes ha scritto:
Hello, I have the
Ok, I am stupid! :P
I was overwriting the value of the zero field with
*form.custom.widget.just_a_dropdown[0]
= 'new_value'* .
This was messing up the validation, obviously.
Thank you for your help Massimo.
Have a nice day,
David
On 6 November 2012 16:30, Massimo Di Pierro
uhm.
elif second==[] or second==():
return '(1=0)'
why this is not reached ?
what is printed when you use
db(db.tablename.fieldname.belongs([]))._select() ?
Il giorno martedì 6 novembre 2012 17:01:08 UTC+1, Marin Pranjić ha scritto:
The issue is that SQLite allows to do:
I tried the same statements (on Mac) and I cannot reproduce the problem.
Anyway, note the logic:
NATIVE_IMPORTER = __builtin__.__import__
...
def custom_importer(name, globals=None, locals=None, fromlist=None,
level=-1):
return NATIVE_IMPORTER(name, globals, locals, fromlist,
I tried this:
db(db.auth_user.id.belongs())._select(db.auth_user.id)
And it prints:
'SELECT auth_user.id FROM auth_user WHERE (1=0);'
So, it works as expected.
My question is invalid because I have something else in code:
db.tablename.fieldname.belongs(set())
Which is not working:
'SELECT
Gave it a try...no luck.
--
FWIW, My users will be filtering test station settings to upload the csv to
thier test bench software. My users will need only thier own filtered data
in the CSVso big Me Too! here
--
ok then post a bug so it doesn't get lost.
PS: I remember asking for the same thing and patching DAL, but it was for
empty lists indeed.
Il giorno martedì 6 novembre 2012 17:27:04 UTC+1, Marin Pranjić ha scritto:
I tried this:
db(db.auth_user.id.belongs())._select(db.auth_user.id)
And it
ok, i understand I'll try it and return in forun
tks Câmara!
On Tue, Nov 6, 2012 at 12:06 PM, Leonel Câmara leonelcam...@gmail.comwrote:
More specifically. You are shadowing the crud usually defined in db.py on
your models with the name of your function which is also called crud.
I just try with SQLFORM and it works
form = SQLFORM(db[request.args(0)], request.args(1))
Richard
On Tue, Nov 6, 2012 at 11:27 AM, Bill Thayer bill.tha...@live.com wrote:
Gave it a try...no luck.
--
--
Done: http://code.google.com/p/web2py/issues/detail?id=1147
Is there a reason for
elif second==[] or second==()
while it could easily be
elif not second
?
This should fix it.
--
really don't know (but probably to ckeck for nulls)
the complete code is
def BELONGS(self, first, second):
if isinstance(second, str):
return '(%s IN (%s))' % (self.expand(first), second[:-1])
elif second==[] or second==():
return '(1=0)'
items =
Use the scheduler. It runs as an *independent* process. If the web server
is running or not have no influence on the scheduler. Read more here:
http://web2py.com/books/default/chapter/29/04?search=scheduler#Scheduler-%28experimental%29
--
Solved it. Your first intuition was correct - conflict in modules, which
I should have picked up on immediately with the additional debug info.
On Tuesday, November 6, 2012 4:26:30 PM UTC, Massimo Di Pierro wrote:
I tried the same statements (on Mac) and I cannot reproduce the problem.
Dear ALL ,
i am trying to do this :
sup = db(
(db.Supplements.Category == (request.args(1)).replace('_',' ')) (db.
Supplements.Users == str(request.args(0)) or 'Both')
).select(db.Supplements.ALL)
But its not working , any help ???
REgards,
--
I don't think that functions in the controller are callable with a
parameter from the web page like form objects are but I could be wrong...
without double checking my code I believe you can call controllers like
this:
@{controller/function/args}
I found that on the markmin cheatsheet.
if you
Dear Fellow Web2py Developers,
Sorry for the extended email, I wanted to introduce myself and give some
background.
I am enjoying web2py tremendously. Two years ago, I came to web2py from
php where I had hacked together multiple web applications, despite a
non-programming background. I am a
How Can i do :
(query) (db.table.Field == i or s) ???
regards
On Tuesday, November 6, 2012 7:33:09 PM UTC+2, Hassan Alnatour wrote:
Dear ALL ,
i am trying to do this :
sup = db(
(db.Supplements.Category == (request.args(1)).replace('_',' ')) (db.
Supplements.Users ==
Hi everyone
Latest development on this issue...
1. http://www.bioinformatics.org/refgene gives me an Invalid request
2. http://www.bioinformatics.org/refgene/admin says that Admin is disabled
because insecure channel
3. https://www.bioinformatics.org/refgene/admin gives me an unrecoverable
On 6 Nov 2012, at 10:55 AM, Maurice Ling mauricel...@gmail.com wrote:
Hi everyone
Latest development on this issue...
1. http://www.bioinformatics.org/refgene gives me an Invalid request
2. http://www.bioinformatics.org/refgene/admin says that Admin is disabled
because insecure channel
As advised by lyn2py,
the current router.py is the same as router.example.py and routes.py is the
same as routes.example.py
On Tuesday, 6 November 2012 13:05:13 UTC-6, Jonathan Lundell wrote:
On 6 Nov 2012, at 10:55 AM, Maurice Ling mauri...@gmail.com javascript:
wrote:
Hi everyone
Thank you vilas,
I think my question is not clear enough for me.
I mean:
1- searching page and comment may mean searching the result of joining
the two tables, which will lead to repetition of the found page (# of
repetitions are the number of associated comments). can 'distinct' solve
This code works. Note the commented out line.
for v in form.vars:
if v[:7] == 'remove_' and form.vars[v] == 'on':
# del db.class_users[v[7:]]
db(db.class_users.id==v[7:]).delete()
This code, which should be equivalent, raises the exception shown below.
On 6 Nov 2012, at 11:10 AM, Maurice Ling mauricel...@gmail.com wrote:
As advised by lyn2py,
the current router.py is the same as router.example.py and routes.py is the
same as routes.example.py
web2py ignores router.py. Copy router.example.py to routes.py.
On Tuesday, 6 November 2012
Yup, done that and still gives me the same errors.
1. http://www.bioinformatics.org/refgene gives me an Invalid request
2. http://www.bioinformatics.org/refgene/admin says that Admin is disabled
because insecure channel
3. https://www.bioinformatics.org/refgene/admin gives me an unrecoverable
On 6 Nov 2012, at 11:27 AM, Maurice Ling mauricel...@gmail.com wrote:
Yup, done that and still gives me the same errors.
You're restarting web2py after making routing changes, right?
1. http://www.bioinformatics.org/refgene gives me an Invalid request
What's the whole message? There should
del db.sometable[something] requires that the id == something exists.
db(db.sometable.id == something).delete() instead returns the number of
records deleted if there was any, otherwise it simply deletes nothing.
On Tuesday, November 6, 2012 8:14:33 PM UTC+1, Cliff Kachinske wrote:
This code
don't get it. you are doing str(request.args(0)) . If request.args(0) is
None (i.e. there is no request.args[0]), str(None) returns 'None' as a
string.
'None' as a string is True, so it doesn't get to be ORed with 'Both'.
None or 'Both'
'Both'
str(None) or 'Both'
'None'
None and str(None) or
Thanks for letting us know. The new custom_import actually works (the old
one did not) so it will pick conflicts that before were not picked.
On Tuesday, 6 November 2012 11:14:28 UTC-6, Neil wrote:
Solved it. Your first intuition was correct - conflict in modules, which
I should have picked
I'm helping Maurice with this. We're running Apache on Linux with
mod_wsgi. This is a shared host environment where each hosted website is
under the user's public_html directory. Normally, we run symlinks from the
docroot to the hosted website as follows:
ln -s
On 6 Nov 2012, at 12:01 PM, J.W. Bizzaro jwbizz...@gmail.com wrote:
I'm helping Maurice with this. We're running Apache on Linux with mod_wsgi.
This is a shared host environment where each hosted website is under the
user's public_html directory. Normally, we run symlinks from the docroot
Hi Askraf,
I added the 'distinct' clause to stop any repeated rows, so yes I think
that would help.
Much depends how you wish to present the results. If you are happy for a
simple list of page titles, then what I proposed seems reasonable. I
thought you might be showing a link to each
Hi Hassan --
In web2py, the Field object is a subclass of Expression. That's how you
can use it with comparison symbols. When you pass it to the database
connection as a function, it produces a Set which loosely represents the
rows of the database that will eventually be selected (but the
One more point -- your request.args(1) should be request.args[1]
(with square brackets). The first form calls request.args as a function
and passes it the value 1. The second form treats request.args as a
Storage object and asks for the subscript 1.
-- Joe Barnhart
Nope,
Nope, no change still the local translation of the word Password in the
form :(. Inserted into db.py in the auth section.
Jan
Dne úterý, 6. listopadu 2012 16:18:49 UTC+1 Niphlod napsal(a):
if you don't change the string that has already a translation it gets
translated.
try with
did you put that between
auth = Auth(...)
and
auth.define_tables() ?
On Tuesday, November 6, 2012 11:32:18 PM UTC+1, Jan Rozhon wrote:
Nope, no change still the local translation of the word Password in the
form :(. Inserted into db.py in the auth section.
Jan
Dne úterý, 6. listopadu
I'm no genius but (6-5)*1 should be 1 and 5 is between 0 and 10,000
I think
Pstart:GHzPstop:GHzPoints:
enter an integer between 0 and -49995
GHz
from decimal import *
def loadpull_points_in_range(pstop, pstart):
return IS_INT_IN_RANGE(0,
i agree that i expected the export buttons to export what is shown above.
if you want to export the whole table, remove all filters so that the whole
table is shown above and then click export.
(note that i do expect export to export all the rows that match the query
even if the table above
what webserver are you using? for security some web servers don't follow
symlinks unless explicitly told they can.
On Tuesday, November 6, 2012 12:40:37 AM UTC-8, dederocks wrote:
I'd like to have an application folder on dropbox, so I've replaced the
application folder with a link on the
good question.i don't know the answer to it, but i suspect there is a
way in your oncreate method to determine which table just had a creation
and do different actions based on that.
On Monday, November 5, 2012 11:41:17 PM UTC-8, vivek wrote:
Hi ,
So in this case how do I make
Didn't have ANY problems with this line of work in 2 years of deployment.
So your post does help with migration errors but...
I have 81 tickets today mostly related to lambda taking [1|2] arguments
but only [0|1] given. This leads to all sorts of variations leading to
errors because
OK, got a solution that has been working well for last few days now.
I made 2 mistakes previously that caused me trouble:
1) The child processes are independent. I had used ctrl+c to kill
web2py, which was passed on to the child processes.
When kill -9 [web2py PID] was used the child processes
Er... it should and you're thinking right, but...
IS_INT_IN_RANGE(0,int(Decimal(pstop)-Decimal(pstart)*1))
translates to x-y*1 and not (x-y)*1.
Regards,
Ales
On Wednesday, November 7, 2012 2:15:04 AM UTC+1, Bill Thayer wrote:
I'm no genius but (6-5)*1 should be 1 and 5
On Tuesday, November 6, 2012 3:54:47 PM UTC-5, Jonathan Lundell wrote:
Your wsgi configuration should be pointing to wsgihandler.py in the web2py
root directory, wherever that happens to be. I'm not much of an expert
there, but I can help with routing once you have web2py up and running
Hi,
I filled the email address in the certificate but what I think is problem
with surname , please check below the log:
*File D:\web2py2.1.1\web2py\gluon\contrib\login_methods\x509_auth.py in
get_user at line 91* code arguments variables
Function argument list
Hi,
I have a packed a Web2py application that is about 1.9Gb (lots of upload
files). When trying to upload it to production server the following error
occurs:
Traceback (most recent call last):
File /home/tempName/web2py/gluon/restricted.py, line 212, in restricted
exec ccode in
Yep, thats the place I put it to. Is there a way to force english if I
cannot prevent translation? I have tried modifying routes.py in my app,
but no luck so far.
Thanks, Jan
On 06/11/12 23:53, Niphlod wrote:
did you put that between
auth = Auth(...)
and
auth.define_tables() ?
On Tuesday,
93 matches
Mail list logo