Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-28 Thread Massimo Di Pierro
We are aware of some bugs in pg8000. I strongly suggest you use psycopg8 until the problems have been fixed. On Monday, 28 January 2013 08:04:13 UTC-6, Richard wrote: > > I will try to reproduce to make web2py were using pg8000, because I am not > sure of that. What the behavior of web2py in cas

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-28 Thread Richard Vézina
I will try to reproduce to make web2py were using pg8000, because I am not sure of that. What the behavior of web2py in case psycopg2 is not there? Richard On Sun, Jan 27, 2013 at 6:50 PM, Alan Etkin wrote: > I notice that python-psycopg2 were not installed and web2py was using >> pg8000 to ac

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-27 Thread Alan Etkin
> > I notice that python-psycopg2 were not installed and web2py was using > pg8000 to access postgres (not sure of that)... I wa > If you found an issue related to the pg8000 adapter, maybe you want to report it at the project page: http://code.google.com/p/pg8000/issues/list --

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-27 Thread Richard Vézina
I notice that python-psycopg2 were not installed and web2py was using pg8000 to access postgres (not sure of that)... I was having bizzard decimal (there was more 0 added at the end of my number, most of the time 2 more 0). I was really puzzled about that until I start think about psycopg2 and whic

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-22 Thread Alan Etkin
> Will the already-existing script for CentOS work for 6.3 86_64 ? > I think it's based in a 32 bit os, but I suppose it's needs just rewriting the parts that download libraries for that architecture. --

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-22 Thread Richard Vézina
On Mon, Jan 21, 2013 at 5:30 PM, Arnon Marcus wrote: > M array over Windows 2008R2 Hyper-V, and it has better support for > CentOS/RHEL then for Ubuntu (something relating to virtualization > acceleration...) > I don't know CentOS, but as long as you know a bit of bash I think it could be easy

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-21 Thread Arnon Marcus
I actually ended up choosing CentOS over Ubuntu, as I'm going for a multi-VM array over Windows 2008R2 Hyper-V, and it has better support for CentOS/RHEL then for Ubuntu (something relating to virtualization acceleration...) Will the already-existing script for CentOS work for 6.3 86_64 ? How dif

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-21 Thread Richard Vézina
I just publish the script last version of the script on Bitbucket : https://bitbucket.org/richardv/setup-ubuntu-redmine-unicorn-web2py-uwsgi-nginx/src/4383ed417c128f7d4e46a42c708fe9ff78bec169/setup-ubuntu-redmine-unicorn-web2py-uwsgi-nginx.sh?at=default I plan to publish it on GitHub too in the co

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-21 Thread Richard Vézina
On Tue, Jan 15, 2013 at 10:31 AM, Arnon Marcus wrote: > and postgres, each are "owned" by a different use, each of which is > different from my user - so I don't have permission to edit them... > What should I do? > sudo YOUR COMMAND Richard --

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-15 Thread Arnon Marcus
The folders of web2py, nginx, and postgres, each are "owned" by a different use, each of which is different from my user - so I don't have permission to edit them... What should I do? On Thursday, January 3, 2013 10:55:48 PM UTC+2, Richard wrote: > > I may don't understand... But I think it just

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Richard Vézina
I may don't understand... But I think it just a matter of DNS configuration, you just need to set a local domain name to your machine pointing on their IP address and then configure these VM as well, /etc/hostname ( http://askubuntu.com/questions/87665/how-do-i-change-the-hostname-without-a-restart

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Arnon Marcus
" And you are rigth that is not really supported with DAL, but you can use your imagination... You could use db.table.field.compute to compute a new concatenated column formed from you 3 field and create a validator for this column that enforce uniqueness of this field petty easy isn't it?? " I ac

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Arnon Marcus
" Also, hosting a staging/prod server on your own dev computer is kind of use less you will run 2 VMs at the same time on the same machine (one for the prod/staging VM and one for your Dev machine), and you will get in trouble with memory soon. If you don't have a really prod server, for example

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Richard Vézina
I just try my script with ubuntu 12.10 server and it seems to work just as well with it. When I come back I will update the script, name and description. Richard On Thu, Jan 3, 2013 at 11:53 AM, Richard Vézina wrote: > I will be out of the office for the next two weeks, so it may be possible

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Richard Vézina
I will be out of the office for the next two weeks, so it may be possible that answer to next questions will be delayed... Richard On Thu, Jan 3, 2013 at 10:29 AM, Richard Vézina wrote: > See below > > > On Thu, Jan 3, 2013 at 9:10 AM, Arnon Marcus wrote: > >> An example of something you NEED

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Richard Vézina
See below On Thu, Jan 3, 2013 at 9:10 AM, Arnon Marcus wrote: > An example of something you NEED phpPGadmin/PgAdminIII is > "multi-field uniqueness": > > Lets say you have a table, with 3 fields - first-name, a last-name and > email. > You want a uniqueness to be enforced in the database, for t

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Richard Vézina
See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus wrote: > 10x for the info. > Is there any benefit for using the server vs. the desktop flavor? > > About pgAdmin, I don't really understand what you mean. > We have been using posgreSQL with web2py in production for almost 3 year

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-03 Thread Arnon Marcus
An example of something you NEED phpPGadmin/PgAdminIII is "multi-field uniqueness": Lets say you have a table, with 3 fields - first-name, a last-name and email. You want a uniqueness to be enforced in the database, for the combination of first and last name. I don't know of a way to do this wi

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Arnon Marcus
10x for the info. Is there any benefit for using the server vs. the desktop flavor? About pgAdmin, I don't really understand what you mean. We have been using posgreSQL with web2py in production for almost 3 years now. Using phpPgAdmin on our production was never an option - always a necessity. Ma

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Richard Vézina
Arnon, I test it with 12.04 server 64 bit under VirtualBox with windows 7 64 bit as guest and it works fine. It surely work under ubuntu desktop, but not tested. The purpose of the script is to deploy rapidly a new prod/stage server with basic configuration that you can tweaks for your needs later

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Richard Vézina
I will be glad, if you want to... :) Richard On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Would you suggest we include it in web2py/scripts/? > > > On Friday, 28 December 2012 14:17:12 UTC-6, Richard wrote: >> >> Hello, >> >> This is a new year gif

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Arnon Marcus
How do I manage the database with PGAdminII ? Which database should I choose? What would be the user-name? How can one install phpPGadmin on this configuration? On Sun, Dec 30, 2012 at 2:47 PM, Arnon Marcus wrote: > Is this for the server or desktop flavor ? > > > On Sun, Dec 30, 2012 at 2:16 P

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Arnon Marcus
Is this for the server or desktop flavor ? On Sun, Dec 30, 2012 at 2:16 PM, Arnon Marcus wrote: > Will this work with ubuntu 12.10 ? > > > On Sat, Dec 29, 2012 at 6:12 AM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> Would you suggest we include it in web2py/scripts/? >> >> >>

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-30 Thread Arnon Marcus
Will this work with ubuntu 12.10 ? On Sat, Dec 29, 2012 at 6:12 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Would you suggest we include it in web2py/scripts/? > > > On Friday, 28 December 2012 14:17:12 UTC-6, Richard wrote: >> >> Hello, >> >> This is a new year gift for the one

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-28 Thread Massimo Di Pierro
Would you suggest we include it in web2py/scripts/? On Friday, 28 December 2012 14:17:12 UTC-6, Richard wrote: > > Hello, > > This is a new year gift for the one who would use Redmine beside web2py... > > :) > > The script is largely base on new Niphold web2py nginx deployment script ( > https://

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-28 Thread Richard Vézina
My configuration is pretty similar to what you have. Just try it and report here any issue. Richard On Friday, December 28, 2012, Arnon Marcus wrote: > Holy Shit ! > > This SO AWESOME !! > Just the kind of combination I was looking for ! > > I am so trying this at work next week... > > 10x a lot

Re: [web2py] Redmine beside web2py with Nginx deployment script

2012-12-28 Thread Arnon Marcus
Holy Shit ! This SO AWESOME !! Just the kind of combination I was looking for ! I am so trying this at work next week... 10x a lot! Couple of questions: 1. Can that be used on a vm-based ubuntu, say, on VirtualBox on win7 ? 2. Is it a 64bit flavour of ubuntu? 3. What python version is it using?