Re: [web2py] 504 Gateway Time-out

2014-03-20 Thread Johann Spies
Check your /etc/nginx */sites-available/web2py* *RegardsJohann* On 20 March 2014 01:46, António Ramos ramstei...@gmail.com wrote: 2014-03-19 12:24 GMT+00:00 Johann Spies johann.sp...@gmail.com: uwsgi_read_timeout sorry my ignorance , where do i do that? -- Resources: -

[web2py] Re: I am trying to build a page to display video files list with thumbnail like youtube do.

2014-03-20 Thread Ravi
How to generate thumbnail for video files automatically? On Wednesday, March 19, 2014 12:29:44 PM UTC+5:30, Ravi wrote: Hi ! I am new to web2py and python and trying to build a page to display video files list with thumbnail like youtube do. I am using Expose to display files and folder

[web2py] Re: uploading a csv file and read it with python module pandas

2014-03-20 Thread greaneym
Gastron, try using read_csv instead of read.csv? data = read_csv('csvfiles/train.csv') this syntax works for me. Margaret On Wednesday, March 19, 2014 8:50:15 AM UTC-5, Gaston wrote: I am statistician and new in web2py. I tried to build an application that allows users to: - upload a

Re: [web2py] Re: Web2py on Koding.com

2014-03-20 Thread António Ramos
I looked at koding as an alternative to action.io where i have some problems, maybe because i´m no root there. (or even worse, i suck at linux !!) In koding i installed web2py but i cannot start it from the command line What is the tricK? python web2py.py -i 0.0.0.0 -p 8000 -a 123 does not

[web2py] Re: Database access without DAL but with connection pool

2014-03-20 Thread Cliff Kachinske
Derek, the conventional wisdom is connecting to a db is expensive. I'm willing to be convinced, but I need some data. Can you point me to some? Because if your statement is true, we could eliminate some pretty hairy code in the DAL to support pooling. On Wednesday, March 19, 2014 7:44:10 PM

[web2py] Re: uploading a csv file and read it with python module pandas

2014-03-20 Thread Anthony
Something like: record = db.mytable(id) data = pd.read_csv(db.mytable.myfile.retrieve(record.myfile)[1]) Anthony On Wednesday, March 19, 2014 9:50:15 AM UTC-4, Gaston wrote: I am statistician and new in web2py. I tried to build an application that allows users to: - upload a csv

Re: [web2py] Re: Web2py on Koding.com

2014-03-20 Thread wuelfhis asuaje
Well i must tell you i couldn't even, i just configured the apache to serve web2py by wsgi on port 80 it's very easy Let me know if you want the config files ! On Thu, Mar 20, 2014 at 6:50 AM, António Ramos ramstei...@gmail.com wrote: I looked at koding as an alternative to action.io where i

Re: [web2py] Re: Web2py on Koding.com

2014-03-20 Thread 黄祥
had you by any chance made the admin app worked in koding.com with apache installed? best regards, stifan -- 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)

Re: [web2py] Python Performance Issue, Part 2

2014-03-20 Thread horridohobbyist
processes=1 and threads=30 also seems to solve the performance problem. BTW, I'm having a dickens of a time reproducing the problem in my servers (either the actual server or the VM). I have not been able to discover how to reset the state of my tests, so I have to blindly go around trying to

[web2py] Re: bug in dal.py _select geoexpand: convert geography as well

2014-03-20 Thread Massimo Di Pierro
done On Wednesday, 19 March 2014 17:19:36 UTC-5, sunny wrote: geoexpand should expand geography as well. otherwise geography fields will not be converted to text. the fix for me was to change the if part in geoexpand (dal.py:1713) -if isinstance(field.type,str) and

[web2py] Re: Bootstrap3 package - help to test

2014-03-20 Thread Luiz Felipe Pedone
Hi Paolo! This package is available on GitHub? I think I can help you out with the development. Em segunda-feira, 23 de dezembro de 2013 18h20min48s UTC-2, Paolo Caruccio escreveu: I just completed a package that applies the bootstrap3 style to some web2py elements - the current version

[web2py] quick question on auth

2014-03-20 Thread Daniel McBrearty
hey people, spent the last 24 hours or so working through the tutorials omn w2p, new to it as well as python though did a fair amount of webdev in other lamguages and frameworks. I must say, it looks nice. Right now I am working through the image blog tutorial and seeing that in fact I could

[web2py] test post

2014-03-20 Thread Daniel McBrearty
excuse me - my last post seems to have disappeared into the sub-ether waveband ... -- 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

[web2py] Problem with uploads using a remote sftp file system

2014-03-20 Thread Chris DeGroot
I am trying to deploy my web2py app on Heroku. I have a database table containing an upload field that I want to put on a remote filesystem using sftp. In db.py, I have set up the file system: from fs import sftpfs file_system = sftpfs.SFTPFS('???',

[web2py] form.custom.begin doesn't add the form _class and other attributes

2014-03-20 Thread Leonel Câmara
{{form['_class'] = 'service-form'}} {{form['_role'] = 'form''}} {{=form.custom.begin}} The generated html was: form action=# enctype=multipart/form-data method=post Is this the supposed behavior or am I doing something wrong? The way I see it the output should be form action=#

[web2py] please help testing windows and mac binary

2014-03-20 Thread Massimo Di Pierro
problems have been reported with the windows and mac binaries for 2.9.x. Can you please help? Download the nightly builds: http://web2py.com/examples/static/nightly/web2py_win.zip http://web2py.com/examples/static/nightly/web2py_osx.zip and let us know if they work/do-not-work for you. Which OS

Re: [web2py] please help testing windows and mac binary

2014-03-20 Thread Marin Pranjić
windows 8.1 C:\Users\Marin\Desktop\web2pyweb2py.exe Traceback (most recent call last): File string, line 6, in module File __main__.py, line 128, in module File __main__web2py__.py, line 18, in module File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 15, in modu le File

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Dave S
On Thursday, March 20, 2014 9:16:13 AM UTC-7, Massimo Di Pierro wrote: problems have been reported with the windows and mac binaries for 2.9.x. Can you please help? Download the nightly builds: http://web2py.com/examples/static/nightly/web2py_win.zip

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Leonel Câmara
Why even distribute binaries? -- 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 Groups

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Najtsirk
Does not work on Win 7 Home Premium 64-bit On Thursday, 20 March 2014 17:16:13 UTC+1, Massimo Di Pierro wrote: problems have been reported with the windows and mac binaries for 2.9.x. Can you please help? Download the nightly builds: http://web2py.com/examples/static/nightly/web2py_win.zip

[web2py] Re: quick question on auth

2014-03-20 Thread Leonel Câmara
Keep reading the book: http://web2py.com/books/default/chapter/29/09/access-control#Other-login-methods-and-login-forms -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] list reference with ondelete=set null breaking when delete parent

2014-03-20 Thread André Kablu
I have 2 tables, using sqlite: db.define_table('color', Field('color', 'string')) db.define_table('tshirt', Field('name', 'string'), Field('colors', 'list:reference color', ondelete=SET NULL)) When I delete a color, all

[web2py] list reference with ondelete=set null breaking when delete parent

2014-03-20 Thread André Kablu
I have 2 tables, using sqlite: db.define_table('color', Field('color', 'string')) db.define_table('tshirt', Field('name', 'string'), Field('colors', 'list:reference color', ondelete=SET NULL)) When I delete a color, all

[web2py] Re: form.custom.begin doesn't add the form _class and other attributes

2014-03-20 Thread André Kablu
you can do it by using FORM(_class='yourclass', _role='role') Em quinta-feira, 20 de março de 2014 13h14min17s UTC-3, Leonel Câmara escreveu: {{form['_class'] = 'service-form'}} {{form['_role'] = 'form''}} {{=form.custom.begin}} The generated html was: form action=#

[web2py] Re: Problem with uploads using a remote sftp file system

2014-03-20 Thread Chris DeGroot
After some digging, I think I may have found the issue. See my pull request: https://github.com/web2py/web2py/pull/409. Comments welcome. On Wednesday, March 19, 2014 9:45:13 PM UTC-4, Chris DeGroot wrote: I am trying to deploy my web2py app on Heroku. I have a database table containing

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Chris DeGroot
Hi Massimo, I don't think the binary is working on my system; I am using OSX Mavericks (10.9.2). I never use the binaries, so I don't know what to expect, but if I try to launch the application (i.e. by double clicking on it), an icon starts to appear in the Dock and then disappears. Chris

[web2py] Can I query muliitple legacy databases?

2014-03-20 Thread learning
I know what Python and web framework are, but need help understanding something about web2py. I have an old application that uses vbscript/asp. It hits multiple databases and brings it back to the user for a seamless experience. In other words, they don't have to go to ten pages to get

[web2py] Re: uploading a csv file and read it with python module pandas

2014-03-20 Thread Gaston
Thanks Margaret. But the idea was to get a csv file (with pandas) already uploaded by users On Thursday, March 20, 2014 12:10:13 PM UTC+1, greaneym wrote: Gastron, try using read_csv instead of read.csv? data = read_csv('csvfiles/train.csv') this syntax works for me. Margaret On

[web2py] Re: form.custom.begin doesn't add the form _class and other attributes

2014-03-20 Thread Leonel Câmara
Yeah, I know I can do that. However, I actually think that, if this really doesn't work, then it is a bug; as there is no way to add a class or other attributes to the form HTML element in custom forms, which are supposed to be custom. -- Resources: - http://web2py.com -

[web2py] Re: list reference with ondelete=set null breaking when delete parent

2014-03-20 Thread Leonel Câmara
I think you should have a third table anyway or searches for T-shirts of a given colour will be quite slow. -- 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)

[web2py] Re: Database access without DAL but with connection pool

2014-03-20 Thread Derek
I can't point you to any, you are welcome to do tests yourself. (note: this is why i said believe it or not) On Thursday, March 20, 2014 6:22:20 AM UTC-7, Cliff Kachinske wrote: Derek, the conventional wisdom is connecting to a db is expensive. I'm willing to be convinced, but I need some

[web2py] Re: form.custom.begin doesn't add the form _class and other attributes

2014-03-20 Thread Anthony
It's not a bug, but it is a limitation. form.custom.begin is not an HTML helper (can't be because it's just the opening tag of the form), so it cannot be manipulated the same way you can manipulate other helper objects. In any case, if you're building a custom form (and for some reason cannot

Re: [web2py] Re: list reference with ondelete=set null breaking when delete parent

2014-03-20 Thread Kablu®
I will migrate it later to mongodb, but wanted it to work on sqlite too for dev, and not have to create a lot of validators on each delete or update. That`s why I was wondering if web2py can handle this transparently. On Thu, Mar 20, 2014 at 4:07 PM, Leonel Câmara leonelcam...@gmail.comwrote:

[web2py] Re: Can I query muliitple legacy databases?

2014-03-20 Thread 黄祥
hm, pardon me, not sure what do you want to achieve. is it something like this? e.g. ## Use SQLite db0 = DAL('sqlite://testmultipledb.sqlite') ## Use MySQL db1 = DAL('mysql://root:@localhost/testmultipledb') ## Use PostgreSQL db2 = DAL('postgres://postgres:a@localhost/testmultipledb')

[web2py] Re: pytds support for mssql?

2014-03-20 Thread Niphlod
+1. It's been sitting on my todolist (and I submitted a patch to make it work without requiring an install) but until DSN/SSPI are kinda transparent I didn't want to introduce it in DAL's core. There were also some problems on properly closing connections, but I didn't dig deeper in it. On

[web2py] Re: howto: ajax call in FORM with signed URL

2014-03-20 Thread Niphlod
again missing a point... ajax callbacks **should** be signed simply because simply there's no way to do sign urls in javascript - meaning...if you move the signing part to a piece of code that is executed on the client, you lost all the benefits of the signature itself, 'cause it can be

[web2py] Re: Boots trap user graph

2014-03-20 Thread Jim S
I'm having good luck building charts using Highcharts. http://www.highcharts.com/ -Jim On Wednesday, March 19, 2014 3:24:35 AM UTC-5, Anubhav Singh wrote: hi guys, is there any easy script for create a user log graph . if yes please help me because i have little knowledge of

[web2py] Can I query muliitple legacy databases?

2014-03-20 Thread Brian M
It works great. I've got reporting sites at work that pull from several different databases using a mix of DAL queries and executesql. Just use the DAL to make the connections to the databases and then query it whichever way best fits your needs! -- Resources: - http://web2py.com -

[web2py] Re: Boots trap user graph

2014-03-20 Thread PN
The solution will depend on what user activity you are trying to log/graph. You can use Google Analytics (the code is built into web2py, but there are tons of help pages available) to track usage report. There are many useful standard reports (how often, what location, what device, etc.) and if

[web2py] Re: Pulling data every 30s for a ticker with web2py

2014-03-20 Thread PN
You can also use web2py components (see the chapter titled 'Components and Plugins' in the web2py book). Basically first make a normal web2py page that reads the remote API every time the page is loaded, and displays the results. Then, load this page as a component into another page, and

Re: [web2py] Re: list reference with ondelete=set null breaking when delete parent

2014-03-20 Thread André Kablu
Yes just migrated to mongodb, and there really exist some issue. using CASCADE or SET NULL, it does not matter, web2py does not respect and remove the reference from the referencing collection or delete the reference... Em quinta-feira, 20 de março de 2014 16h16min43s UTC-3, André Kablu

[web2py] Grid 2 list boxes first list box to restrict values in second

2014-03-20 Thread Dan Kozlowski
Is there any way within a grid with 2 list boxes that the selected value in the first list box can sub select the the second the values in the listbox ? A example would be selecting a state and only selecting cities in that state. Example : State : IL Cites : Chicago Calumet

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Chris DeGroot
Apparently my post was deleted... the binary does not seem to work on OSX 10.9.2. The icon flashes briefly and then disappears. Chris On Thursday, March 20, 2014 12:16:13 PM UTC-4, Massimo Di Pierro wrote: problems have been reported with the windows and mac binaries for 2.9.x. Can you

[web2py] Re: Can I query muliitple legacy databases?

2014-03-20 Thread learning
I don't know about the syntax. I'm trying to decide which Framework I should go with. I have one database that has information about personal details. Another database has information about various purchases, still another database has information about other family members. This is an

[web2py] Re: I am trying to build a page to display video files list with thumbnail like youtube do.

2014-03-20 Thread Андрей Генералов
How about that would use a wiki? it's support youtube urls четверг, 20 марта 2014 г., 15:30:58 UTC+6 пользователь Ravi написал: How to generate thumbnail for video files automatically? On Wednesday, March 19, 2014 12:29:44 PM UTC+5:30, Ravi wrote: Hi ! I am new to web2py and python and

[web2py] Re: test post

2014-03-20 Thread Massimo Di Pierro
Lots of users have been having this problem recently. I do not know what to say. Must be a Google bug. we do not delete post unless requested by the author. On Thursday, 20 March 2014 04:21:38 UTC-5, Daniel McBrearty wrote: excuse me - my last post seems to have disappeared into the sub-ether

[web2py] Re: quick question on auth

2014-03-20 Thread Tim Richardson
On Friday, 21 March 2014 05:08:04 UTC+11, Leonel Câmara wrote: Keep reading the book: http://web2py.com/books/default/chapter/29/09/access-control#Other-login-methods-and-login-forms or even

[web2py] Re: pytds support for mssql?

2014-03-20 Thread Tim Richardson
+1 this, sounds great. -- 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 Groups

[web2py] Re: Can I query muliitple legacy databases?

2014-03-20 Thread Brian M
Setup a connection to each of your databases as shown above - then db1 will represent the connection to the first database, db2 the second and so on - or you can just as easily name the database connections db_customer, db_purchases, db_relatives and so on so the names are a bit more

[web2py] Free web2py hosting for a free software web2py application

2014-03-20 Thread pang
Hello, I write most of the code for *karakolas, a free software web2py application for managing grupos de consumo*. These are asociations of people that join their shopping baskets so that they can order their food directly from the local farmers, taking into account ecological, social and

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Massimo Di Pierro
Please try again these builds: http://web2py.com/examples/static/nightly/web2py_win.zip http://web2py.com/examples/static/nightly/web2py_osx.zip On Thursday, 20 March 2014 11:16:13 UTC-5, Massimo Di Pierro wrote: problems have been reported with the windows and mac binaries for 2.9.x. Can

[web2py] subscripts inside database

2014-03-20 Thread Chris Hepworth
In my current project I have a table that accepts chemical formulas. To accurately display a formula, however, I need to be able to render subscripts. I had tried to put an HTML sub tag around the number, but this is saved as lt;subgt; Normally I would love that web2py does this automatically

[web2py] Re: subscripts inside database

2014-03-20 Thread 黄祥
i think you can achieve it using XML() html helper. e.g. *insert data contain html* db.test_html.insert(test = 'h3Heading 3/h3\ntest\nh3Again/h3\nul\nlione/li\nlitwo/li\n/ul') ) *view.html* {{extend 'layout_default.html'}} {{=DIV(*XML*(T(row.test), sanitize = True) ) }} best regards, stifan

[web2py] Re: Free web2py hosting for a free software web2py application

2014-03-20 Thread 黄祥
had you already tried in pythonanywhere.com or koding.com? best regards, stifan -- 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

[web2py] Re: Boots trap user graph

2014-03-20 Thread 黄祥
i think you can produce the graph / chart using either, javascript (process in client e.g. highchart, rgraph, etc), python (process in server e.g. pygal, etc) or online (pass parameter online, e.g. google chart). the choice is yours. best regards, stifan -- Resources: - http://web2py.com -

[web2py] Re: Grid 2 list boxes first list box to restrict values in second

2014-03-20 Thread 黄祥
i think you can achieve it using jquery. ref: http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#Conditional-fields-in-forms best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: I am trying to build a page to display video files list with thumbnail like youtube do.

2014-03-20 Thread 黄祥
not sure is massimo's minimalist streaming audio, is what you looking for ref : https://groups.google.com/forum/#!topic/web2py/B1l_RfCYpXA best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Python Performance Issue, Part 2

2014-03-20 Thread 黄祥
i think it make the other users more clear, if you can also provide the configuration and procedures also for what are you doing. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Login form adittional fields

2014-03-20 Thread xgp . latino
Hi all, After looking everywhere, have no more choice but to ask. I defined a custom auth.table with custom fields. Login via 1 of these fields and password on custom login form based on form.custom.widget is working flawlessly. Problem is, now i have to authenticate using 3 fields from this

[web2py] Re: web2pyslices

2014-03-20 Thread 黄祥
i think you can report the bug or issue about web2pyslices in this forum too, if it crucial like security leak, i think it better to notice the experts here directly to their email (e.g. massimo, anthony, etc). best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Password feild type seems to save in plain text for me.

2014-03-20 Thread 黄祥
i'm not sure about this, i think the password field type is made by string field type, checked on sql.log in databases folders. if you want to have the cryted value one, i think you can achieve it using something like : e.g. db.auth_user.bulk_insert([{first_name : a, last_name : a, email :

[web2py] Re: SQLFORM to json

2014-03-20 Thread 黄祥
web2py support json field type also, or another way around is you can achieve it using as_dict or as_list(). ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#as_dict-and-as_list best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread Dave S
On Thursday, March 20, 2014 4:10:35 PM UTC-7, Massimo Di Pierro wrote: Please try again these builds: http://web2py.com/examples/static/nightly/web2py_win.zip http://web2py.com/examples/static/nightly/web2py_osx.zip The Windows version launches with a double-click and I get the welcome

[web2py] Re: please help testing windows and mac binary

2014-03-20 Thread 黄祥
run smoothly on win 7 home premium 64 bit. no problem occured when : tested web2py.exe tested admin page tested add new app tested new app login best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Version ugrade throws ticket when /admin accessed - dead in water

2014-03-20 Thread weheh
Just upgraded to 2.9.5-stable and ran into an issue. Whenever I try to access admin I get an internal error and a ticket. The console complains: I:\web2py\applications\admin\controllers/default.py:807: Warning: 'with' will become a reserved keyword in Python 2.6 I'm running python 2.5.X. The

[web2py] Re: Version ugrade throws ticket when /admin accessed - dead in water

2014-03-20 Thread weheh
Installation was from source. -- 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 Groups

[web2py] Re: 2.9.5-stable Version throws ticket when /admin accessed - dead in water

2014-03-20 Thread weheh
Gaah! I just restored the older version of web2py from which I upgraded (ashamed to say it's 2.3.2) and now I'm getting the same error. So apparently, something got corrupted along the way. Note to self: don't attempt upgrades just before a major release. -- Resources: - http://web2py.com -