http://blog.gmane.org/gmane.comp.python.web2py hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.python.web2py/88329 <pre>There have been numerous posts on a web2py based cms, and I know there are many solutions out there, at varying stages of development. They each have a different focus so it is not a simple question of "which one is best". I won't try and mention them by name. However, A colleague of mine was talking about Joomla and I wanted to be able to offer some "strategy" on a comparable web2py cms. Would anyone care to comment on which of the web2py cms' would be a contender to Joomla ? If not now, perhaps with a roadmap for the future. Personally, and I've said it before, cms functionality is very important, and I think we should highlight the cms offerings on the web2py website. Not necessarily one, but showcase the "best of ...". For example, look at http://www.zope.org/the-world-of-zope It mentions Plone and Silva. Such a thing would also strenghten the adopton of web2py. Are they production ready enough to do that ? Thankyou. Andrew W </pre> Andrew 2012-05-25T03:54:54 http://permalink.gmane.org/gmane.comp.python.web2py/88328 <pre>I don't think it's the DAL, I think it's in the drivers or the db systems. Something like this worked on SQLite but Psycopg2 raises an exception: list_1 = [2,4.5] list_2 = [] db((db.sometable.id.belongs(list_1) &amp; ~(db.sometable.id.belongs(list_2)).select() On Thursday, May 24, 2012 2:35:44 PM UTC-4, Anthony wrote: </pre> Cliff Kachinske 2012-05-25T02:46:24 http://permalink.gmane.org/gmane.comp.python.web2py/88327 <pre>I installed web2py with mod_wsgi on centos 5.2. I haven't used it extensively, but I did get it to work for a couple of my web2py applications. Instead of running the install script, I manually implemented most of the steps from the setup-web2py-fedora.sh script. I have selinux disabled in this configuration. The following is a record of what I did... No guarantees... ############################################################ You will probably need the following packages. httpd.i386 mod_ssl.i386 wget.i386 httpd-devel.i386 sqlite-devel.i386 zlib-devel.i386 The python on most servers is 2.5, so I will rebuild it for 2.7 =============================================================== /usr/local/Python-2.7.2 ./configure --prefix=/usr/local --with-threads --enable-shared --with-zlib=/usr/include make &amp;&amp; make install Rebuild mod_wsgi to use the new python: ======================================= /usr/local/tar# wget http://modwsgi.googlecode.com/files/mod_wsgi-3.3.tar.gz cd /usr/local/mod_wsgi-3.3 ./configure --with-python=/usr/local/bin/python make &amp;&amp; make install Install web2py somewhere. It must be owned by the apache process. ================================================================= mkdir -p /opt/web-apps chmod 755 /opt chmod 755 /opt/web-apps cd /opt/web-apps wget http://web2py.com/examples/static/web2py_src.zip unzip web2py_src.zip chown -R apache:apache web2py Setup SSL ========= mkdir -p /etc/httpd/ssl openssl genrsa 1024 &gt; /etc/httpd/ssl/self_signed.key openssl req -new -x509 -nodes -sha1 -days 365 -key /etc/httpd/ssl/self_signed.yum list httpd mod_ssl mod_wsgi wget python httpd-devel sqlite-devel zlib-devel key &gt; /etc/httpd/ssl/self_signed.cert (supply appropriate responses) openssl x509 -noout -fingerprint -text &lt; /etc/httpd/ssl/self_signed.cert &gt; /etc/httpd/ssl/self_signed.info Setup web2py admin password =========================== cd /opt/web-apps/web2py sudo -u apache python -c "from gluon.main import save_password; save_password(raw_input('admin password: '),443)" xxxx Configure Apache ================ /etc/httpd/conf.d ... wsgi.conf .............................................. LoadModule wsgi_module modules/mod_wsgi.so WSGISocketPrefix run/wsgi ............................................................ - mod_python interferes with mod_wsgi. - hide or remove mod_python.conf from /etc/httpd/conf.d ############################################################ ############################################################ I followed various instructions I found in the web2py group to build web2py.conf. There are simpler configurations, but I needed web2py to coexist with other pre-existing httpd applications. This configuration serves two named web2py apps: app1 and app2 --- /etc/httpd/conf.d/web2py.conf -------------------------- NameVirtualHost *:80 NameVirtualHost *:443 &lt;VirtualHost *:80&gt; ServerName MyServer RewriteEngine on RewriteRule ^/app1(.*)$ /w2p/app1$1 [PT,L] RewriteRule ^/app2(.*)$ /w2p/app2$1 [PT,L] # RewriteLog "/var/log/httpd/rewrite_log" # RewriteLogLevel 9 WSGIScriptAlias /w2p /opt/web-apps/web2py/wsgihandler.py WSGIDaemonProcess web2py user=apache group=apache home=/opt/web-apps/web2py WSGIProcessGroup web2py &lt;Directory /opt/web-apps/web2py&gt; AllowOverride None Order Allow,Deny Deny from all &lt;Files wsgihandler.py&gt; Allow from all &lt;/Files&gt; &lt;/Directory&gt; AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 &lt;Directory /opt/web-apps/web2py/applications/*/static&gt; Options -Indexes Order Allow,Deny Allow from all &lt;/Directory&gt; &lt;Location /admin&gt; Deny from all &lt;/Location&gt; &lt;LocationMatch ^/([^/]+)/appadmin&gt; Deny from all &lt;/LocationMatch&gt; CustomLog /var/log/httpd/access_log common ErrorLog /var/log/httpd/error_log &lt;/VirtualHost&gt; &lt;VirtualHost *:443&gt; ServerName MyServer SSLEngine on SSLCertificateFile /etc/httpd/ssl/self_signed.cert SSLCertificateKeyFile /etc/httpd/ssl/self_signed.key RewriteEngine on RewriteRule ^/admin(.*)$ /w2p/admin$1 [PT,L] RewriteRule ^/examples(.*)$ /w2p/examples$1 [PT,L] # RewriteLog "/var/log/httpd/rewrite_log" # RewriteLogLevel 9 WSGIScriptAlias /w2p /opt/web-apps/web2py/wsgihandler.py WSGIDaemonProcess web2py2 user=apache group=apache home=/opt/web-apps/web2py WSGIProcessGroup web2py2 &lt;Directory /opt/web-apps/web2py&gt; AllowOverride None Order Allow,Deny Deny from all &lt;Files wsgihandler.py&gt; Allow from all &lt;/Files&gt; &lt;/Directory&gt; AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 &lt;Directory /opt/web-apps/web2py/applications/*/static&gt; Options -Indexes ExpiresActive On ExpiresDefault "access plus 1 hour" Order Allow,Deny Allow from all &lt;/Directory&gt; CustomLog /var/log/httpd/access_log common ErrorLog /var/log/httpd/error_log &lt;/VirtualHost&gt; ------------------------------------------------------------ ############################################################ </pre> tomt 2012-05-25T02:24:06 http://permalink.gmane.org/gmane.comp.python.web2py/88326 <pre>I installed web2py with mod_wsgi on centos 5.2. I haven't used it extensively, but I did get it to work for a couple of my web2py applications. Instead of running the install script, I manually implemented most of the steps from the setup-web2py-fedora.sh script. The following is a record of what I did... No guarantees... ############################################################ You will probably need the following packages. httpd.i386 mod_ssl.i386 wget.i386 httpd-devel.i386 sqlite-devel.i386 zlib-devel.i386 The python on most servers is 2.5, so I will rebuild it for 2.7 =============================================================== /usr/local/Python-2.7.2 ./configure --prefix=/usr/local --with-threads --enable-shared --with-zlib=/usr/include make &amp;&amp; make install Rebuild mod_wsgi to use the new python: ======================================= /usr/local/tar# wget http://modwsgi.googlecode.com/files/mod_wsgi-3.3.tar.gz cd /usr/local/mod_wsgi-3.3 ./configure --with-python=/usr/local/bin/python make &amp;&amp; make install Install web2py somewhere. It must be owned by the apache process. ================================================================= mkdir -p /opt/web-apps chmod 755 /opt chmod 755 /opt/web-apps cd /opt/web-apps wget http://web2py.com/examples/static/web2py_src.zip unzip web2py_src.zip chown -R apache:apache web2py Setup SSL ========= mkdir -p /etc/httpd/ssl openssl genrsa 1024 &gt; /etc/httpd/ssl/self_signed.key openssl req -new -x509 -nodes -sha1 -days 365 -key /etc/httpd/ssl/self_signed.yum list httpd mod_ssl mod_wsgi wget python httpd-devel sqlite-devel zlib-devel key &gt; /etc/httpd/ssl/self_signed.cert (supply appropriate responses) openssl x509 -noout -fingerprint -text &lt; /etc/httpd/ssl/self_signed.cert &gt; /etc/httpd/ssl/self_signed.info Setup web2py admin password =========================== cd /opt/web-apps/web2py sudo -u apache python -c "from gluon.main import save_password; save_password(raw_input('admin password: '),443)" xxxx Configure Apache ================ /etc/httpd/conf.d ... wsgi.conf .............................................. LoadModule wsgi_module modules/mod_wsgi.so WSGISocketPrefix run/wsgi ............................................................ - mod_python interferes with mod_wsgi. - hide or remove mod_python.conf from /etc/httpd/conf.d ############################################################ ############################################################ I followed various instructions I found in the web2py group to build web2py.conf. There are simpler configurations, but I needed web2py to coexist with other pre-existing httpd applications. This configuration serves two named web2py apps: app1 and app2 --- /etc/httpd/conf.d/web2py.conf -------------------------- NameVirtualHost *:80 NameVirtualHost *:443 &lt;VirtualHost *:80&gt; ServerName MyServer RewriteEngine on RewriteRule ^/app1(.*)$ /w2p/app1$1 [PT,L] RewriteRule ^/app2(.*)$ /w2p/app2$1 [PT,L] # RewriteLog "/var/log/httpd/rewrite_log" # RewriteLogLevel 9 WSGIScriptAlias /w2p /opt/web-apps/web2py/wsgihandler.py WSGIDaemonProcess web2py user=apache group=apache home=/opt/web-apps/web2py WSGIProcessGroup web2py &lt;Directory /opt/web-apps/web2py&gt; AllowOverride None Order Allow,Deny Deny from all &lt;Files wsgihandler.py&gt; Allow from all &lt;/Files&gt; &lt;/Directory&gt; AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 &lt;Directory /opt/web-apps/web2py/applications/*/static&gt; Options -Indexes Order Allow,Deny Allow from all &lt;/Directory&gt; &lt;Location /admin&gt; Deny from all &lt;/Location&gt; &lt;LocationMatch ^/([^/]+)/appadmin&gt; Deny from all &lt;/LocationMatch&gt; CustomLog /var/log/httpd/access_log common ErrorLog /var/log/httpd/error_log &lt;/VirtualHost&gt; &lt;VirtualHost *:443&gt; ServerName MyServer SSLEngine on SSLCertificateFile /etc/httpd/ssl/self_signed.cert SSLCertificateKeyFile /etc/httpd/ssl/self_signed.key RewriteEngine on RewriteRule ^/admin(.*)$ /w2p/admin$1 [PT,L] RewriteRule ^/examples(.*)$ /w2p/examples$1 [PT,L] ############################################################ # RewriteLog "/var/log/httpd/rewrite_log" # RewriteLogLevel 9 WSGIScriptAlias /w2p /opt/web-apps/web2py/wsgihandler.py WSGIDaemonProcess web2py2 user=apache group=apache home=/opt/web-apps/web2py WSGIProcessGroup web2py2 &lt;Directory /opt/web-apps/web2py&gt; AllowOverride None Order Allow,Deny Deny from all &lt;Files wsgihandler.py&gt; Allow from all &lt;/Files&gt; &lt;/Directory&gt; AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 &lt;Directory /opt/web-apps/web2py/applications/*/static&gt; Options -Indexes ExpiresActive On ExpiresDefault "access plus 1 hour" Order Allow,Deny Allow from all &lt;/Directory&gt; CustomLog /var/log/httpd/access_log common ErrorLog /var/log/httpd/error_log &lt;/VirtualHost&gt; ------------------------------------------------------------ ############################################################ ps: I disabled selinux. </pre> tomt 2012-05-25T02:17:53 http://permalink.gmane.org/gmane.comp.python.web2py/88325 <pre> You might have better luck with this, where the comment isn't eating the closing }} on the first line. {{#some comment if True:}} ... {{pass}} </pre> Jonathan Lundell 2012-05-25T01:32:44 http://permalink.gmane.org/gmane.comp.python.web2py/88324 <pre> It's true that comments are tricky in template code. It's possible (I don't remember exactly) that the closing brackets in {{ if True: # comment }} are treated as part of the comment. In that case, it might work to write: {{if True: #comment }} html {{pass}} or {{ # comment if True:}} html {{pass}} </pre> Jonathan Lundell 2012-05-25T01:29:25 http://permalink.gmane.org/gmane.comp.python.web2py/88323 <pre>ah, ok, I am not familiar with template implementation but shouldn't be a more explanatory error than "IndentationError: expected an indented block" ? it took me some minutes to figure out the problem, I was looking in the code and couldn't understand what is the problem I reported that, {{if True: #some comment}} here some html {{pass}} but of course there was a much longer if condition with code inside, if we care about ... about me I think next time I will follow your advice and will put comments from views in their own line {{#some comment}} {{if True:}} ... {{pass}} </pre> Vasile Ermicioi 2012-05-25T01:25:56 http://permalink.gmane.org/gmane.comp.python.web2py/88322 <pre>Impressive Paolo, Looks like you're a web2py developer yourself ! I'm not adept in the art of css , but it this the solution we've been looking for ? Regards Andrew W On Friday, May 25, 2012 11:16:37 AM UTC+12, Paolo Caruccio wrote: &gt;&gt;</pre> Andrew 2012-05-25T01:01:17 http://permalink.gmane.org/gmane.comp.python.web2py/88321 <pre>So far, I have been developing my app locally on my laptop (I am just using the built in rocket server with sqlite on my windows laptop and it is working great!!) However, I am now trying to get my app uploaded to the google app engine using SQL , instead of using noSQL. I have my db set up this way if not request.env.web2py_runtime_gae: ## if NOT running on Google App Engine use SQLite or other DB db = DAL('sqlite://storage.sqlite') else: ## connect to Google BigTable (optional 'google:datastore://namespace') #db = DAL('google:datastore') #for no SQL db= DAL('google:sqlstore') #for SQL ## store sessions and tickets there session.connect(request, response, db = db) When I use the db=DAL('google:sqlstore') option to use SQL, and when I try to access my app through google app engine, it sends me to a page that just says "Internal error, ticket issued unknown"(it is not the typical web2py error message, seems to be coming from google app engine). And when I click on the link "unknown" it sends me to the web2py administration site. The example , and welcome apps seems to be working fine on my google app engine instance so I figured I am doing something wrong in my app. I tried using the noSQL option, and if I do that, it at least sends me to a web2py error page because I am using join related commands to access my database (hence the reason I want to use SQL). I looked through the documentation and it seems like google's sql can do everything that sqlite can do. I also believe I'm not performing any writes or reads into the filesystem since google app engine prohibits it. Is there anything crucial I am missing? Is there somethign </pre> Umpei Kurokawa 2012-05-24T19:00:16 http://permalink.gmane.org/gmane.comp.python.web2py/88320 <pre>Here's the onclick event for the delete button link: onclick="if(confirm(w2p_ajax_confirm_message||'Are you sure you want to delete this object?')){ajax('/myapp/default/index/delete/mytable/1',[],'');jQuery(this).closest('tr').remove();};return false;" The problem is when you click delete, it sends an Ajax request to delete the record, but it also immediately removes the row from the table (regardless of whether the Ajax request is ultimately successful). Perhaps instead, it should do: ajax('/myapp/default/index/delete/mytable/1',[],':eval'); The Ajax call can then return some Javascript that either pops up a message indicating the deletion failed (possibly due to it being the last record), or if successful, it could delete the row from the table. That would ensure the record isn't removed from the table unless it was really deleted from the database. Anthony On Thursday, May 24, 2012 6:23:58 PM UTC-4, Niphlod wrote: &gt;</pre> Anthony 2012-05-25T00:54:37 http://permalink.gmane.org/gmane.comp.python.web2py/88319 <pre>Hello, I'm in the process of running web2py on Apache for the first time. I found some excellent tutorials on this, such as: http://ochiba77.blogspot.co.nz/2011/10/how-to-setup-web2py-apache-wsgi.html, and also Martin Mulone's Blog site. Thanks for sharing the knowledge (BTW, I think it makes sense to include this in the book - Deployment recipes). With a minimal amount of fuss I was able to get the Welcome app to come up. I then pointed to an existing app that connects to a SQL Server database, and I get the error: File "E:\TWLApps\web2py\gluon\dal.py", line 2600, in __init__ raise RuntimeError, "Unable to import driver" RuntimeError: Unable to import driver *I stopped Apache and started the normal "python web2py.py ...." and my MSSQL app works fine !* So, something with my apache config is stopping web2py finding, or loading the (pyodbc?) driver - I think !. I've searched the forum and web but I haven't found this particular issue. Any pointers would be appreciated. Thanks Andrew W </pre> Andrew 2012-05-25T00:41:21 http://permalink.gmane.org/gmane.comp.python.web2py/88318 <pre>See: https://groups.google.com/forum/#!searchin/web2py/view$20comment/web2py/GDWuByevUzI/26SHLCtw2A8J Yes, it's mostly plain Python but obviously not strictly plain Python. Just put your comments on their own lines. On Thursday, May 24, 2012 3:31:40 PM UTC-7, Vasile Ermicioi wrote: </pre> pbreit 2012-05-24T23:21:04 http://permalink.gmane.org/gmane.comp.python.web2py/88317 <pre>Andrew, I played a bit on this subject. Please replace the below files (before backup them) with attached ones: 1. welcome &gt; models &gt; menu.py (check the changes in response.menu) 2. welcome &gt; views &gt; layout.html (heavily changed) 3. welcome &gt; static &gt; css &gt; web2py.css (find the comment "bootswatch" to see the changes) Now, if you download a css from bootswatch.com or built it from http://stylebootstrap.info, replacing default one you shouldn't have problems. For the menu I used one of solutions that Anthony proposed. In attachement also some images to show how several themes are rendered in several modern browsers. Last notes: a) this is an experiment. You have to obtain official changes from web2py developers b) my enviroment: windows 7, python 2.7.2, web2py version 2.0.00 (2012-05-23 09:27:57) dev Il giorno lunedì 21 maggio 2012 20:42:38 UTC+2, Andrew ha scritto: &gt;</pre> Paolo Caruccio 2012-05-24T23:16:37 http://permalink.gmane.org/gmane.comp.python.web2py/88316 <pre> I'm not understand how this works, but I feel that is an interesting idea. Can you specify a use case? Why and how is tied to postfix? Are these lists defined in postfix side or web2py side? By the way, I was trying to browse the code via github but you are using tabs for indentation, making a litter bit harder to follow the code. Ricardo </pre> Ricardo Pedroso 2012-05-24T22:54:42 http://permalink.gmane.org/gmane.comp.python.web2py/88315 <pre>rows are storage objects....... rows = [] for row in rows1: row.table_name = 'news' rows.append(row) for row in rows2: row.table_name = 'article' rows.append(row) should work as intended. Il giorno giovedì 24 maggio 2012 13:53:38 UTC+2, CtrlSoft ha scritto: </pre> Niphlod 2012-05-24T22:32:16 http://permalink.gmane.org/gmane.comp.python.web2py/88314 <pre>I read that all code between brackets {{ }} is plain python and {{pass}} is only necessary when you mix with html and in python that is valid code if True: #some comment print 'hello' </pre> Vasile Ermicioi 2012-05-24T22:31:40 http://permalink.gmane.org/gmane.comp.python.web2py/88313 <pre>well, the intended design is NOT to reload page if a row is deleted (better user experience). Small corner cases are "delete every row in the page and be "forced" to click on next page to have new records", etc..... Anyway, you can intercept delete operations.... deletable = request.vars.stoptoyingaround and False or True if request.args(0) == 'delete': if db(db.parameter).count() &lt;= 1: response.flash = 'deleting the last row is not allowed' redirect(URL('yoururl', vars=dict(stoptoyingaround=1))) ....... caveat: if you're using the "args" argument to SQLFORM.grid() 'delete' would be the first arg after the "base" ones. if you like to have your users to play with the delete button when there is 1 row left (and not harm your database while playing), you can skip the deletable assignement based on request.vars. As a nice side effect, you can count your table only when it's needed ;-) </pre> Niphlod 2012-05-24T22:23:58 http://permalink.gmane.org/gmane.comp.python.web2py/88312 <pre>I think I recall seeing it written somewhere that you can't do that type of comment in between view tags. I think it needs to be: {{# comment or {{if True: # comment pass}} On Thursday, May 24, 2012 1:04:30 PM UTC-7, Vasile Ermicioi wrote: </pre> pbreit 2012-05-24T22:24:01 http://permalink.gmane.org/gmane.comp.python.web2py/88311 <pre> {{if True:}} here some html {{pass}} works fine (missed a } near True) </pre> Vasile Ermicioi 2012-05-24T22:21:56 http://permalink.gmane.org/gmane.comp.python.web2py/88310 <pre>{{if True:} here some html {{pass}} works fine </pre> Vasile Ermicioi 2012-05-24T22:21:13 http://permalink.gmane.org/gmane.comp.python.web2py/88309 <pre>it works fine if I removed it </pre> Vasile Ermicioi 2012-05-24T22:20:31 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.web2py