[web2py] Re: Docker

2017-02-04 Thread Rene Dohmen
@Michael M: Nice solution, with postgres and mysql :) -- 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

[web2py] Re: Docker

2017-02-04 Thread Rene Dohmen
I also builded a docker; containing ssl-nginx-uwsgi based on ubuntu and with some extra python deps (Pillow and gdata). https://github.com/acidjunk/docker-web2py It's meant to be used with an existing app; it will add routes.py for your app. You can get it from docker hub also docker pull

[web2py] Re: Is there a plan to put an official image of web2py on Docker?

2017-01-27 Thread Rene Dohmen
An official package would be souper douper :) I'm now running with: thehipbot/web2py which run fine: Nginx, Uwsgi emperror and Web2py It will use latest web2py version from source. On Tuesday, September 27, 2016 at 5:00:55 AM UTC+2, JorgeH wrote: > > It would be a great idea. > > To have one

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

2016-02-25 Thread Rene Dohmen
Hi Massimo, you could remove me from the list: Formatics.nl I still notice a lot of doublures on the current list. Cheers, Rene -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Janrain: NEW OpenID connect

2015-04-30 Thread Rene Dohmen
I have the same problem: Gmail user can't login anymore. Google Apps for business user can login; but they get a popup telling them it will expire 20 april 2015. R On Thursday, April 23, 2015 at 6:00:34 PM UTC+2, Stefan van den Eertwegh wrote: Dear fellow web2py users, I understand that

[web2py] Re: How to support DB migrations on Heroku?

2014-06-19 Thread Rene Dohmen
on hosted? On Tuesday, June 17, 2014 7:27:25 AM UTC-7, Rene Dohmen wrote: Hi, Are the any users at all using heroku and web2py with a postgres DB? The demo app: http://tranquil-spire-8889.herokuapp.com/ We are running into problems also for: - file uploads - using an already existing DB

[web2py] Re: How to support DB migrations on Heroku?

2014-06-17 Thread Rene Dohmen
, June 13, 2014 4:14:49 PM UTC+2, Rene Dohmen wrote: Hi Web2py Users, I deployed an app with postgres on Heroku following the info in: https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-heroku.sh https://github.com/web2py/web2py/blob/master/gluon/contrib/heroku.py I already had

[web2py] How to support DB migrations on Heroku?

2014-06-13 Thread Rene Dohmen
Hi Web2py Users, I deployed an app with postgres on Heroku following the info in: https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-heroku.sh https://github.com/web2py/web2py/blob/master/gluon/contrib/heroku.py I already had a working postgres database from a previous deployment

Re: [web2py] Re: Web2Py Pages module (basic CMS)

2014-05-08 Thread Rene Dohmen
? Thanks. El martes, 6 de mayo de 2014 19:24:15 UTC+2, Rene Dohmen escribió: Hi Villas, page is a restricted word in postgres and some other DB's I think. We started development in web2py 1.99.1 with sqlite. it's a valid sqlite tableName. The problem for us is that we

Re: [web2py] Re: Uforum - a forum web2py application

2014-05-08 Thread Rene Dohmen
+1 2014-05-08 12:26 GMT+02:00 Stefaan Himpe stefaan.hi...@gmail.com: I have created a web2py forum software, now currently only in the Dutch but wil be ported to english. Ziet er goed uit! -- http://technogems.blogspot.com http://a-touch-of-music.blogspot.com

[web2py] Re: Web2Py Pages module (basic CMS)

2014-05-06 Thread Rene Dohmen
'page' negates the purpose. Thanks for your effort to release this work and it will be very nice to see it in action! Best wishes, D On Thursday, 27 February 2014 20:07:21 UTC, Rene Dohmen wrote: This was solved a while ago :) On Friday, December 20, 2013 9:34:21 AM UTC+1, Ruud Schroen

Re: [web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-25 Thread Rene Dohmen
, smart and robust. Once you have moved the database to postgresql you need only to change the connection string in db.py to connect to your new postgresql copy. 2014-04-25 3:11 GMT+02:00 Rene Dohmen re...@formatics.nl javascript:: With some tweaking the script that Alan Proposed did work

[web2py] Migrating from sqlite to postgres?

2014-04-24 Thread Rene Dohmen
Hi Web2py users, we are struggling, for some time now, with a migration of our apps from sqlite to postgres. We tried a couple of approaches: first we tried doing it with cp_db.py but that had problems with relations and seems broken. Our current approach consist of these steps: 1) export

[web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-24 Thread Rene Dohmen
Hmm , I tried this approach (and some other variants from this thread.): but I run into an error after 15? minutes or so; The error occurs during the execution of the import_from_csv... --- Traceback (most recent call last): File console, line 1, in module File

[web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-24 Thread Rene Dohmen
With some tweaking the script that Alan Proposed did work in my situation. (50+ tables and a lot of references) https://groups.google.com/d/msg/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ In Short: 1) recreate the complete model in postgres: db_new =

[web2py] Re: Weird truncate performance problem after upgrade to 2.8.2

2014-02-27 Thread Rene Dohmen
wrote: What happens if you take the exact SQL that web2py executes and instead execute it outside of web2py altogether (i.e., via some other database client)? On Wednesday, February 26, 2014 7:06:46 PM UTC-5, Rene Dohmen wrote: Hi Web2py-Users, We have an app which imports data form a .csv

[web2py] Re: Web2Py Pages module (basic CMS)

2014-02-27 Thread Rene Dohmen
This was solved a while ago :) On Friday, December 20, 2013 9:34:21 AM UTC+1, Ruud Schroen wrote: We are still working on a plugin. But we are facing a problem regarding reserved keywords which prevents us from creating a plugin. db =

[web2py] Weird truncate performance problem after upgrade to 2.8.2

2014-02-26 Thread Rene Dohmen
Hi Web2py-Users, We have an app which imports data form a .csv file into a sqlite table. The CSV has 70k lines. Once a week we re-import data with a new .csv. The controller that handles this job: 1) handles the upload and moves it to location for future reference 2) truncates the main table

[web2py] Re: Bug on version 2.8.2

2014-02-26 Thread Rene Dohmen
Hi Paulo, Doesn't seem like a bug to me. More like a typo you made in the model... But if I remember correctly you would get an error defining a reference to a non existing table in older web2py releases. You could also build the reference like this; Field('image', db.image) That way you

Re: [web2py] Setting DAL less strict from a model

2014-02-14 Thread Rene Dohmen
is now working without touching your web2py code. A .w2p plugin will be released soon. Kind regards, Rene On Sunday, February 9, 2014 1:55:46 AM UTC+1, Rene Dohmen wrote: Hi, Just checked with trunk Version 2.8.2-stable+timestamp.2014.01.30.08.43.19 and entity_quoting=True in the DAL

[web2py] Re: New to Web2Py: Large Model

2014-02-14 Thread Rene Dohmen
You could use extract_mysql_models.py (in the web2py/scripts folder) On Wednesday, February 12, 2014 4:58:29 PM UTC+1, Juslin Guo wrote: Hi, I have an application in PHP with 500 over tables, what's the best way to managed them in Web2Py, without repeating model definitions nor loading

Re: [web2py] Setting DAL less strict from a model

2014-02-08 Thread Rene Dohmen
Rene On Thursday, February 6, 2014 7:03:29 PM UTC+1, Rene Dohmen wrote: Hi Mic, I will test it later on. But i'm not sure how this would solve the problem; I still need to remove the check_reserved from the DAL connection string. The goal is to NOT change anything in db.py; so the page

Re: [web2py] Setting DAL less strict from a model

2014-02-06 Thread Rene Dohmen
(., entity_quoting=True) after that you should have no conflict with reserved SQL words. You should be able to use any name, e.g. do things like define_table('table', Field('select'), Field('update')) Let us know if that works. mic 2014-02-04 Rene Dohmen re...@formatics.nl javascript:: Hi

[web2py] Setting DAL less strict from a model

2014-02-04 Thread Rene Dohmen
Hi Web2py-users, I have developed a CMS kind of system based on web2py. https://github.com/acidjunk/web2py-pages I actually want to provide a release as a w2p file on a regular basis, so it can be used more easily. But I'm running into a problem if I don't overwrite any core web2py app files.

[web2py] janrain login not working anymore?

2013-12-20 Thread Rene Dohmen
Hi, We use the janrain login method in a couple of our webapps. As of today it suddenly stopped working... Are there any other users that use the janrain login methods? (and have it working?) On the janrain site I found a story about and old and a new way to use janrain. The Iframe way seems

[web2py] Re: Web2Py Pages module (basic CMS)

2013-11-19 Thread Rene Dohmen
Hi List, Ruud, thanks for sharing. :) I'll build a w2p plugin from it at the end of this week. We are still testing it; and need to upgrade fancy box to fancybox2. Kind Regards, Rene On Wednesday, November 20, 2013 12:06:47 AM UTC+1, Ruud Schroen wrote: Also i forgot to mention: The app

[web2py] Small error in current online web2py book

2013-03-08 Thread Rene Dohmen
I don't know if this is the correct place to post this: http://www.web2py.com/book/default/chapter/01#security Serves me: invalid function (default/chapter) Original page: http://web2py.com/init/default/what (containing the link) Greets Rene -- --- You received this message because you are

[web2py] Re: SQLFORM.grid and joins

2013-03-01 Thread Rene Dohmen
Hi Massimo, We did print the t-shirt ourselves ;-) I'll send you one. Kind Regards, Rene On Thursday, February 28, 2013 6:06:56 PM UTC+1, Massimo Di Pierro wrote: Where did you get that? I want one. -- --- You received this message because you are subscribed to the Google Groups

[web2py] scheduler problem in trunk when using datetime as return value?

2012-12-10 Thread Rene Dohmen
Hi, I like the new scheduler concept a lot. It looks promising. Something goes wrong when I try to return a datetime in the method I wanted to schedule... A Simple JSON parsing error -- raise TypeError(repr(o) + is not JSON serializable) TypeError: datetime.datetime(2012, 12, 10, 15, 57, 59,

[web2py] Missing dumps() in rss2 contrib

2012-11-19 Thread Rene Dohmen
Hi All, i'm running web2py 2.2.1 When I try to return a rss with the generic.rss view or when I try to follow example http://www.web2py.com/examples/simple_examples/rss_aggregator It serves a ticket with: 'module' object has no attribute 'dumps' The gluon/contrib/rss2 - doesn't have a dumps

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
to loosen the restrictions on reserved keywords on a per app basis. Kind Regards Rene Dohmen --

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
problems with a field group in a mysql table. It would be cool if there is a way to loosen the restrictions on reserved keywords on a per app basis. Kind Regards Rene Dohmen -- --

[web2py] Mysql reserved words in a legacy db

2012-06-20 Thread Rene Dohmen
. Is there a way to force the DAL to quote the fieldNames in its insert and update query's? With our previous framework we didn't experience any problems with a field group in a mysql table. It would be cool if there is a way to loosen the restrictions on reserved keywords on a per app basis. Kind Regards Rene

Re: [web2py] Quoting reserved words in DAL

2012-06-20 Thread Rene Dohmen
I'm having the same problem: https://groups.google.com/d/msg/web2py/hCsxVaDLfT4/K6UMbG5p5uAJ On Mon, Jun 18, 2012 at 9:30 AM, Michael Toomim too...@gmail.com wrote: I just got bit by the reserved-word problem: https://groups.google.com/d/msg/web2py/aSPtD_mGXdM/c7et_2l_54wJ I am trying to

[web2py] Autologin via janrain?

2012-05-21 Thread Rene Dohmen
Hi List, I'm building an app where users can make quiz content together; login via janrain (only facebook provider). We also have a small iOS app (game) to test the quiz content; it reads the data from a xml that is composed on the fly by a controller function. Is there an easy way to

[web2py] Web2py support the netherlands

2012-03-15 Thread Rene Dohmen
if this is the correct place to request it) Kind Regards, Rene Dohmen

[web2py] Re: Routes.py and janrain login

2012-02-13 Thread Rene Dohmen
work the 1st time R On Feb 2, 2:51 am, Rene Dohmen acidj...@gmail.com wrote: Hi List, I've installed mod_wsgi on our server and added a vhost so that each application is accessible viawww.examples.com/app_name One of the apps is ready; so I created another vhost and started an separate

[web2py] Routes.py and janrain login

2012-02-01 Thread Rene Dohmen
Hi List, I've installed mod_wsgi on our server and added a vhost so that each application is accessible via www.examples.com/app_name One of the apps is ready; so I created another vhost and started an separate instance of web2py. The second instance uses a routes.py to remove the appname from