[web2py] Re: DePy 2015

2015-03-11 Thread Massimo Di Pierro
For sponsors: http://mdp.cdm.depaul.edu/DePy2015/default/sponsor_form On Thursday, 26 February 2015 17:39:28 UTC-6, Massimo Di Pierro wrote: Hello everybody, I am happy to announce DePy 2015. A conference on Python hosted at DePaul on May 29 30. The conference will focus specifically on

[web2py] Executesql SQLFORM.grid

2015-03-11 Thread LaDarrius Stewart
Is there anyway to move rows generated from executesql into a grid. With the use of executesql in web2py for complex queries I was surprised not to see this question asked anywhere else that I could find. -- This message is for named person(s) only. It may contain confidential and/or legally

Re: [web2py] Re: Running multiple lines of SQL in executesql

2015-03-11 Thread Naveed Ahmed
Yes it works from the DB’s interface and yes, I’m using MySQL. From: Brian M Sent: Wednesday, March 11, 2015 3:18 PM To: web2py@googlegroups.com Subject: Re: [web2py] Re: Running multiple lines of SQL in executesql Strange. Does that same query work if you enter it directly in your DB's

[web2py] Re: integrating materialize.css

2015-03-11 Thread Anthony
Also, the ui argument to the grid can be a dictionary of classes for the various elements of the grid. Anthony On Wednesday, March 11, 2015 at 4:51:26 PM UTC-4, Massimo Di Pierro wrote: You can use any framework you like. The problem is that grid and forms may not have the right classes.

Re: [web2py] Re: Running multiple lines of SQL in executesql

2015-03-11 Thread Brian M
Strange. Does that same query work if you enter it directly in your DB's interface? I'm guessing from the link you provided that you're using MySQL; I've only done it with MS SQL and SQLite but I'd think that the triple quoting technique should work with other databases too. On Wednesday,

[web2py] Re: web2py in-browser editor failing to load on Chrome

2015-03-11 Thread Gray Kanarek
For some reason this isn't happening today... I don't really understand (didn't quit browser or reboot computer...), but it's fixed, anyway. On Wednesday, March 11, 2015 at 2:07:02 PM UTC-4, Gray Kanarek wrote: Hi all, I've been using web2py for a couple weeks now and I think it's amazing!

[web2py] Re: web2py in-browser editor failing to load on Chrome

2015-03-11 Thread Dave S
On Wednesday, March 11, 2015 at 11:07:02 AM UTC-7, Gray Kanarek wrote: Hi all, I've been using web2py for a couple weeks now and I think it's amazing! However, today when I tried to work on my app, via the in-browser editor, the editor doesn't load. The admin interface is fine, the

[web2py] Re: integrating materialize.css

2015-03-11 Thread Massimo Di Pierro
You can use any framework you like. The problem is that grid and forms may not have the right classes. Two solutions are: - add the right classes via JS - create a formstyle (look into sqlhtml.py for examples) that can serialize forms in the proper format. We definitively need better docs

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread Dave S
On Wednesday, March 11, 2015 at 6:50:28 AM UTC-7, mcm wrote: If you do not have the email you can use the registration_id and username fields. Most details are on the book: http://web2py.com/books/default/chapter/29/09/access-control Would it be appropriate to add some of the comments

[web2py] import_from_csv_file and id_map={}

2015-03-11 Thread Tom Clerckx
I recently learned (by searching through the google-group) the usefulness of the id_map={} parameter in the db.import_from_csv_file function. I was wondering why this is not included in the documentation of web2py? Is this on the 'todo' list or is there another reason why it is not included?

[web2py] Re: how to insert dynamic record id into field in form

2015-03-11 Thread Gray Kanarek
You can probably use the compute keyword to the particular field. http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Computed-fields On Tuesday, March 10, 2015 at 3:49:05 PM UTC-4, Alex Glaros wrote: I want to insert the record id into one of its fields during

[web2py] Re: IMPORTANT - DROPPING SUPPORT FOR PYTHON 2.5?

2015-03-11 Thread Gary Cowell
On Saturday, 7 March 2015 19:18:17 UTC, Massimo Di Pierro wrote: Who is opposed? Why? It would mean support going for Red Hat 5 I think Red Hat 6 is on 2.6, Red Hat 7 is 2.7. Everything I have is at least Red Hat 6. But that would be the reason, most probably -- Resources: -

[web2py] web2py in-browser editor failing to load on Chrome

2015-03-11 Thread Gray Kanarek
Hi all, I've been using web2py for a couple weeks now and I think it's amazing! However, today when I tried to work on my app, via the in-browser editor, the editor doesn't load. The admin interface is fine, the design page works fine, but the editor itself is mostly blank. This happens

[web2py] Re: type 'exceptions.NameError'(name 'auth' is not defined)

2015-03-11 Thread Dave S
On Wednesday, March 11, 2015 at 7:38:20 AM UTC-7, Anthony wrote: Obviously auth hasn't been defined at that point. Hard to say why without knowing more about the app (i.e., where is this code, where is auth defined, etc.). If this is the out-of-the-box style, with blog_entries in a

[web2py] Re: web2py in-browser editor failing to load on Chrome

2015-03-11 Thread Massimo Di Pierro
perhaps your browser was caching an older version of the js files? On Wednesday, 11 March 2015 15:54:49 UTC-5, Gray Kanarek wrote: For some reason this isn't happening today... I don't really understand (didn't quit browser or reboot computer...), but it's fixed, anyway. On Wednesday, March

[web2py] Re: DAL: INSERT-query's devilry

2015-03-11 Thread Val K
OK guys! My concrete suggestion: - Add attrubute _insert_with_returning to Table class - Fix adapter Postgres.py : def _insert(self, table, fields): table_rname = table.sqlsafe if fields: keys = ','.join(f.sqlsafe_name for f, v in fields)

[web2py] Re: IMPORTANT - DROPPING SUPPORT FOR PYTHON 2.5?

2015-03-11 Thread LightDot
RHEL 5 (and naturally CentOS 5 etc.) ship with python 2.4.3, that's already water under the bridge as far ar web2py goes. Keeping python 2.6 compatibility for a good while longer would be greatly appreciated - we have quite a few production apps on RHEL 6 / Scientific Linux 6, but python 2.5

[web2py] Re: Global search form example

2015-03-11 Thread Gael Princivalle
Thanks Ron but I've don't understand your answer, and I've don't find anything about this question page 84 of the web2py_manual_5th.pdf book. Anyway I can imagine the solution is crawling all searchable fields in all tables, saving in the for loop all rows references (function/args), and

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread LoveWeb2py
Those are exactly the two I don't have so far from the list I saw in another post I have: SSL_CIPHER, SSL_CLIENT_I_DN, SSL_CLIENT_CERT, SSL_CLIENT_VERIFY The following are not being passed (probably a problem with my ssl.conf: SSL_CLIENT_RAW_CERT, SSL_SESSION_ID, SSL_CLIENT_SERIAL Almost

[web2py] Re: parameterized router BASE breaks appadmin redirection

2015-03-11 Thread cowbert
I am still having issues with this on 2.9.12. Here is my routes.py: BASE = '/web2py' routes_in = ( (BASE + '/$anything', '/$anything'), ) routes_out = [(x, y) for (y, x) in routes_in] In this case, if I try to go to an admin url (like /web2py/admin/debug) and I am not logged in as admin,

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread Michele Comitini
You can read any of the fields a certificate contains eventually. see here for some ideas: https://code.google.com/p/simpatica/ It's a working PKI that allows to generate csr and sign them with a valid signin certificate 2015-03-11 13:48 GMT+01:00 LoveWeb2py atayloru...@gmail.com: Once

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread LoveWeb2py
Also make sure to have these settings in your virtualhost SSLEngine On SSLOptions +stdEnvVars To verify the variables are being passed properly look at {{=request.env}} in a view and look for SSL variables. On Wednesday, March 11, 2015 at 8:22:15 AM UTC-4, LoveWeb2py wrote: Thank you so much

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread LoveWeb2py
Once authentication happens how can I make them members of groups. I notice now they don't have an entry in Auth user. Should I have them register first and once they're reigstered they can use PKI authentication? This is uncharted waters for me so I'm trying to figure out the best approach for

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread Michele Comitini
I am glad someone is using x509 Auth, it is a very simple way to handle user security, One important piece of the puzzle (with apache) is: SSLVerifyClient optional The optional allows one to accept any user on the website, while having some web2py actions require a valid user certificate just

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread LoveWeb2py
Thank you so much for posting and for x509 auth. I got it working. For anyone who finds this. If you're using apache you need to change line 33 in x509_auth.py from self.ssl_client_raw_cert = self.request.env.ssl_client_cert It's the same cert that gets decoded by X509.FORMAT_PEM, but I

[web2py] Re: type 'exceptions.NameError'(name 'auth' is not defined)

2015-03-11 Thread Anthony
Obviously auth hasn't been defined at that point. Hard to say why without knowing more about the app (i.e., where is this code, where is auth defined, etc.). On Wednesday, March 11, 2015 at 9:54:54 AM UTC-4, Mark Billion wrote: We've been very stable, but this just happened last night. Im

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd wsgi

2015-03-11 Thread Michele Comitini
If you do not have the email you can use the registration_id and username fields. Most details are on the book: http://web2py.com/books/default/chapter/29/09/access-control 2015-03-11 14:08 GMT+01:00 Michele Comitini michele.comit...@gmail.com: You can read any of the fields a certificate

[web2py] type 'exceptions.NameError'(name 'auth' is not defined)

2015-03-11 Thread Mark Billion
We've been very stable, but this just happened last night. Im guessing its a random error, but wanted to see if anyone had any thoughts. Here's the code . 6. 7. 8. 9. 10. 11. #global route to static images. g_im_handle = '/home/mmb21167/web2py/ba_1_1/applications/welcome/static/%s'

[web2py] Executesql SQLFORM.grid

2015-03-11 Thread Tim Richardson
the grid does many things that rely on DAL support. -- 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