Re: [web2py] Redmine beside web2py with Nginx deployment script
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 spame...@gmail.com wrote: 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
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 case psycopg2 is not there? Richard On Sun, Jan 27, 2013 at 6:50 PM, Alan Etkin spam...@gmail.comjavascript: wrote: 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
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 which adapted was using web2py. I will alter my script to install this dependency since psycopg2 is the default postgres adapter used by web2py. Richard On Tue, Jan 22, 2013 at 4:00 PM, Alan Etkin spame...@gmail.com wrote: 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
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
On Mon, Jan 21, 2013 at 5:30 PM, Arnon Marcus a.m.mar...@gmail.com 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 to adapt it for CentOS... The main task will be to identified the equivalent packages names... If you make any effort in this direction, think to others users and publish your script here... Richard --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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
On Tue, Jan 15, 2013 at 10:31 AM, Arnon Marcus a.m.mar...@gmail.com 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
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 coming days as soon as I install and test the HG Git Plugin for Mercurial. :) Richard On Mon, Jan 21, 2013 at 12:14 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: On Tue, Jan 15, 2013 at 10:31 AM, Arnon Marcus a.m.mar...@gmail.comwrote: 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
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 difficult would it be to mix up your script with that one, to make a CentOS-6.3+NginX+uwsgi+Redmine+Web2py configuration? On Mon, Jan 21, 2013 at 1:29 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: 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 coming days as soon as I install and test the HG Git Plugin for Mercurial. :) Richard On Mon, Jan 21, 2013 at 12:14 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: On Tue, Jan 15, 2013 at 10:31 AM, Arnon Marcus a.m.mar...@gmail.comwrote: 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
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 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) and tell nginx hostname... ?! Richard On Thu, Jan 3, 2013 at 3:38 PM, Arnon Marcus a.m.m...@gmail.comjavascript: wrote: 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 forthe 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 ESXi or bare metal dedicated server, you should stick with one VM where you configure Nginx, etc. and you developpe with Rocket server included in web2py. I guess I did not make myself clear enough. That is not exactly my intent, and that's not what we're doing. The machine I've installed the VM on, is a BOXX bare metal dedicated to become this server. You may ask then why a VM at all? why not install it fresh as the main os? Well, I have my reasons, but that's beside the point. The machine is a 64bit double-dual-core AMD with 8GB of RAM. The application is for intranet-use, so it's not going to have too much load anyways - it's going to serve up to 60 clients total at the very most - and mostly not all simultaneously. I don't expect it to have a problem running 2 VMs, I would just have to give each one around 3.5GB of RAM. You may then ask then why a 64bit VM stack? Well, future-proofing - We are supposed to get a newer dedicated bare-metal, which would probably have 16GB of RAM at least. But in any case, the 2 VMs are NOT your typical prod/dev configuration - it's more of a stable/nightly configuration - I want some of the workers to be able to QA new code by using a different server-instance. We DO also have a dev-environment, in each of the developer's machine, using the Rocket server as you said - that's on-top of the 2 VMs I'm planning. Another reason for having the production server served from a VM, is for backup reasons - it's easier/quicker to clone an entire VM-image with the whole stack + database, in case something goes wrong. Plug, we are almost a purely Microsoft-stack based shop, so I think it's going to be easier that way - with having all the remote-desktop experience super-simple, having the server logged in to the active-directory, etc... So then the question still remains - how do my users use this server on our network? Using the domain of the hosting machine as the host-address, doesn't work... So what address should they use? On Thursday, January 3, 2013 7:12:09 AM UTC-8, Richard wrote: See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus a.m.m...@gmail.comwrote: 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. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't have your database installed in one machine, and have your phpPgAdmin hosted on another - in its configuration file, you have to specify the local path of the pg_dump.exe and stuff like that it needs for it's operation. And again, we need it's operation for unsupported feattures of postgreSQL in web2py. As for PgAdmin-III, well, we basically only use if when transferring our database + schema as an SQL string, from one machine to another. Somehow the same thing using phpPgAdmin doesn't take us the whole way the same way PgAdmin-III does when doing that. If we were starting a new project, I could have agreed with you - we wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a database somewhere else (meaning, outside the virtual machine I just installed thanks to you), we need PgAdmin-III for the
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 with the DAL in web2py - if there is, i'd love to hear about it. My programmer raised this concern a year ago in these forums, and she was ridiculed. I don't this this is such a non-trivial need in production, as to be ridiculed... It's actually a pretty common and very useful feature. Perhaps not every database supports it, but so what? I think enough people who use web2py in production use it in conjunction with PostgreSQL, to justify the merit of such a feature-request. But until then, and until all other unsupported DAL features exist, the usage of phpPGadmin/PgAdminIII for PostgreSQl is a necessity - regardless of OS. So I would really appreciate any help in that direction. Thank you. On Sunday, December 30, 2012 8:36:44 PM UTC+2, Richard wrote: 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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richa...@gmail.comjavascript: wrote: I will be glad, if you want to... :) Richard On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro massimo@gmail.com javascript: 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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus a.m.mar...@gmail.com 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 years now. Using phpPgAdmin on our production was never an option - always a necessity. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't have your database installed in one machine, and have your phpPgAdmin hosted on another - in its configuration file, you have to specify the local path of the pg_dump.exe and stuff like that it needs for it's operation. And again, we need it's operation for unsupported feattures of postgreSQL in web2py. As for PgAdmin-III, well, we basically only use if when transferring our database + schema as an SQL string, from one machine to another. Somehow the same thing using phpPgAdmin doesn't take us the whole way the same way PgAdmin-III does when doing that. If we were starting a new project, I could have agreed with you - we wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a database somewhere else (meaning, outside the virtual machine I just installed thanks to you), we need PgAdmin-III for the database transferring. And since the installation of it in ubuntu is extremely simple, and having our solution installing a default ubuntu installation of postgreSQL, I would have expected the installation of PgAdmin-II to have automatically identified the postgreSQL service/process that is running - but when I launch it, and try to connect, it apparently doesn't find it properly. I can't seem to be able to connect to the postgreSQL service with it. I don't see any redmine database I can connect to. I think we are confusing the database node, with the connection-string/setting for PgAdmin to find the server/service/process/whatever... I am not sure I follow you about service/process, as far as I know you only need to connect to postgres, you need a ip, an user name and a password. So you need to configure you connection in pgAdmin for that. You may need to open access from the prod/staging server, firewall, pg_hba.conf and postgresql.conf in /etc/postgresql/.../.../* About the last point pg_hba.conf, I prefer connect remote sever with ssh, less difficult then setting up SSL with postgres, search for ssh fowarding for that, here the command : ssh -L local-port:HOSTNAMEorIP:distant-port ( http://www.debianadmin.com/howto-use-ssh-local-and-remote-port-forwarding.html ) About phpPgAdmin, I can't see what you can't do with pgAdmin, I tweak my database as I which with pgAdmin from remote machine (my dev environnement) without limit, I would not rely on phpPgAdmin for that, but it surely a matter of choice. If you prefer phpPgAdmin go for it (google with the write keyword should allow you to find the way you can configure nginx with php support and then install phpPgAdmin). Any thought? And any pointers you could give me for trying to install phpPgAdmin? I was able to locate where web2py is and where redmine is. But where is nginx? How do I further configure it for php ? Any configuration file I should know aboout? Google And what about web2py? Is it connected to postgreSQL? I guess not, because it's just the welcome application, that uses sqlite by default, right? I guess if I can connect to postgreSQL with PgAdmin, I will have found the specification I need to use in the connection string in web2py for our application (we currently use the default settings for postgreSQL connection and it works) Web2py is just installed, you app should have a connection string that where you define the location of your database server and user name and password. I think, I should have create a web2py dummy app deployed with my script :-P I was able to install everything smoothly on ubuntu 12.04 desktop x64 with virtual box on windows 7 x64. Web2py and redmine are loadingsuccessfully locally with firefox. But how do I access them elsewhere on our intranet? That mean that the script if working well for you (if you can connect to both site web2py welcome and redmine)... About the intranet, I don't really understand... I presume that you have deploy a virtual machine on you own desktop computer, if so, and regarding your next sentence and the 10.0.2.15 ip
Re: [web2py] Redmine beside web2py with Nginx deployment script
See below On Thu, Jan 3, 2013 at 9:10 AM, Arnon Marcus a.m.mar...@gmail.com 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 the combination of first and last name. I don't know of a way to do this with the DAL in web2py - if there is, i'd love to hear about it. You can write this rule with this command that you create on the table : CREATE UNIQUE INDEX name ON table (column [, ...]); And you can use pgAdmin to send it to the server and check that it effectively applyed Ref.: http://www.postgresql.org/docs/9.1/static/indexes-unique.html 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?? And I would do both of these solution at the same time, in order to make sure web2py don't try to create a duplicated entry, and at postgres level to make there is no duplicated entry. There is an other reason to make both, to avoid web2py raising tikect if app try to create a duplicates... If there is no rule in your app to prevent duplicate database will return error and web2py will raise a ticket because he don't know what to do. Anyway, it is always a good idea to make sure that your database is full proof even if you app is already OK. Because imagine you want to use an other framework then web2py in the future, you would not mess up your data with you new app in the new framework that do not not yet that the 3 columns should be unique together. My programmer raised this concern a year ago in these forums, and she was ridiculed. I don't this this is such a non-trivial need in production, as to be ridiculed... It's actually a pretty common and very useful feature. Perhaps not every database supports it, but so what? I think enough people who use web2py in production use it in conjunction with PostgreSQL, to justify the merit of such a feature-request. I don't think this is a feature... You need to wrote your own solution for that the I suggest you self. I think Massimo try the best he can (with the help of the community) to make DAL feel as most as possible like SQL, but DAL is not SQL... Richard But until then, and until all other unsupported DAL features exist, the usage of phpPGadmin/PgAdminIII for PostgreSQl is a necessity - regardless of OS. So I would really appreciate any help in that direction. Thank you. On Sunday, December 30, 2012 8:36:44 PM UTC+2, Richard wrote: 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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richa...@gmail.comwrote: I will be glad, if you want to... :) Richard On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro massimo@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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**for**um/?fromgroups=#!searchin/** web2**py/nginx$20niphold/web2py/**15J3**T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable),
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 ml.richard.vez...@gmail.com wrote: See below On Thu, Jan 3, 2013 at 9:10 AM, Arnon Marcus a.m.mar...@gmail.com 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 the combination of first and last name. I don't know of a way to do this with the DAL in web2py - if there is, i'd love to hear about it. You can write this rule with this command that you create on the table : CREATE UNIQUE INDEX name ON table (column [, ...]); And you can use pgAdmin to send it to the server and check that it effectively applyed Ref.: http://www.postgresql.org/docs/9.1/static/indexes-unique.html 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?? And I would do both of these solution at the same time, in order to make sure web2py don't try to create a duplicated entry, and at postgres level to make there is no duplicated entry. There is an other reason to make both, to avoid web2py raising tikect if app try to create a duplicates... If there is no rule in your app to prevent duplicate database will return error and web2py will raise a ticket because he don't know what to do. Anyway, it is always a good idea to make sure that your database is full proof even if you app is already OK. Because imagine you want to use an other framework then web2py in the future, you would not mess up your data with you new app in the new framework that do not not yet that the 3 columns should be unique together. My programmer raised this concern a year ago in these forums, and she was ridiculed. I don't this this is such a non-trivial need in production, as to be ridiculed... It's actually a pretty common and very useful feature. Perhaps not every database supports it, but so what? I think enough people who use web2py in production use it in conjunction with PostgreSQL, to justify the merit of such a feature-request. I don't think this is a feature... You need to wrote your own solution for that the I suggest you self. I think Massimo try the best he can (with the help of the community) to make DAL feel as most as possible like SQL, but DAL is not SQL... Richard But until then, and until all other unsupported DAL features exist, the usage of phpPGadmin/PgAdminIII for PostgreSQl is a necessity - regardless of OS. So I would really appreciate any help in that direction. Thank you. On Sunday, December 30, 2012 8:36:44 PM UTC+2, Richard wrote: 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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richa...@gmail.comwrote: I will be glad, if you want to... :) Richard On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro massimo@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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**for**um/?fromgroups=#!searchin/** web2**py/nginx$20niphold/web2py/**15J3**T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) -
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 ml.richard.vez...@gmail.com wrote: 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 ml.richard.vez...@gmail.com wrote: See below On Thu, Jan 3, 2013 at 9:10 AM, Arnon Marcus a.m.mar...@gmail.comwrote: 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 with the DAL in web2py - if there is, i'd love to hear about it. You can write this rule with this command that you create on the table : CREATE UNIQUE INDEX name ON table (column [, ...]); And you can use pgAdmin to send it to the server and check that it effectively applyed Ref.: http://www.postgresql.org/docs/9.1/static/indexes-unique.html 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?? And I would do both of these solution at the same time, in order to make sure web2py don't try to create a duplicated entry, and at postgres level to make there is no duplicated entry. There is an other reason to make both, to avoid web2py raising tikect if app try to create a duplicates... If there is no rule in your app to prevent duplicate database will return error and web2py will raise a ticket because he don't know what to do. Anyway, it is always a good idea to make sure that your database is full proof even if you app is already OK. Because imagine you want to use an other framework then web2py in the future, you would not mess up your data with you new app in the new framework that do not not yet that the 3 columns should be unique together. My programmer raised this concern a year ago in these forums, and she was ridiculed. I don't this this is such a non-trivial need in production, as to be ridiculed... It's actually a pretty common and very useful feature. Perhaps not every database supports it, but so what? I think enough people who use web2py in production use it in conjunction with PostgreSQL, to justify the merit of such a feature-request. I don't think this is a feature... You need to wrote your own solution for that the I suggest you self. I think Massimo try the best he can (with the help of the community) to make DAL feel as most as possible like SQL, but DAL is not SQL... Richard But until then, and until all other unsupported DAL features exist, the usage of phpPGadmin/PgAdminIII for PostgreSQl is a necessity - regardless of OS. So I would really appreciate any help in that direction. Thank you. On Sunday, December 30, 2012 8:36:44 PM UTC+2, Richard wrote: 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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richa...@gmail.comwrote: I will be glad, if you want to... :) Richard On Fri, Dec 28, 2012 at 11:12 PM, Massimo Di Pierro massimo@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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**for**um/?fromgroups=#!searchin/* *web2**py/nginx$20niphold/web2py/**15J3**T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 ESXi or bare metal dedicated server, you should stick with one VM where you configure Nginx, etc. and you developpe with Rocket server included in web2py. I guess I did not make myself clear enough. That is not exactly my intent, and that's not what we're doing. The machine I've installed the VM on, is a BOXX bare metal dedicated to become this server. You may ask then why a VM at all? why not install it fresh as the main os? Well, I have my reasons, but that's beside the point. The machine is a 64bit double-dual-core AMD with 8GB of RAM. The application is for intranet-use, so it's not going to have too much load anyways - it's going to serve up to 60 clients total at the very most - and mostly not all simultaneously. I don't expect it to have a problem running 2 VMs, I would just have to give each one around 3.5GB of RAM. You may then ask then why a 64bit VM stack? Well, future-proofing - We are supposed to get a newer dedicated bare-metal, which would probably have 16GB of RAM at least. But in any case, the 2 VMs are NOT your typical prod/dev configuration - it's more of a stable/nightly configuration - I want some of the workers to be able to QA new code by using a different server-instance. We DO also have a dev-environment, in each of the developer's machine, using the Rocket server as you said - that's on-top of the 2 VMs I'm planning. Another reason for having the production server served from a VM, is for backup reasons - it's easier/quicker to clone an entire VM-image with the whole stack + database, in case something goes wrong. Plug, we are almost a purely Microsoft-stack based shop, so I think it's going to be easier that way - with having all the remote-desktop experience super-simple, having the server logged in to the active-directory, etc... So then the question still remains - how do my users use this server on our network? Using the domain of the hosting machine as the host-address, doesn't work... So what address should they use? On Thursday, January 3, 2013 7:12:09 AM UTC-8, Richard wrote: See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus a.m.m...@gmail.comjavascript: 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 years now. Using phpPgAdmin on our production was never an option - always a necessity. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't have your database installed in one machine, and have your phpPgAdmin hosted on another - in its configuration file, you have to specify the local path of the pg_dump.exe and stuff like that it needs for it's operation. And again, we need it's operation for unsupported feattures of postgreSQL in web2py. As for PgAdmin-III, well, we basically only use if when transferring our database + schema as an SQL string, from one machine to another. Somehow the same thing using phpPgAdmin doesn't take us the whole way the same way PgAdmin-III does when doing that. If we were starting a new project, I could have agreed with you - we wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a database somewhere else (meaning, outside the virtual machine I just installed thanks to you), we need PgAdmin-III for the database transferring. And since the installation of it in ubuntu is extremely simple, and having our solution installing a default ubuntu installation of postgreSQL, I would have expected the installation of PgAdmin-II to have automatically identified the postgreSQL service/process that is running - but when I launch it, and try to connect, it apparently doesn't find it properly. I can't seem to be able to connect to the postgreSQL service with it. I don't see any redmine database I can connect to. I think we are confusing the database node, with the connection-string/setting for PgAdmin to find the server/service/process/whatever... I am not sure I follow you about service/process, as
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 actually thought about that as I was writing the response to you, but as you said, it shouldn't be enough anyway... So you see, you are sayingyourself that there is a need for PGadminIII or phpPGadmin. And yes, it IS a matter of preference - some things are easier to do with phphPGadmin, and my programmer is used to working with phpMyAdmin, so it's a work-preference - they both do mostly the same things - some things are better done in PGadminIII but for the most part, for general use, phpPGadmin is just fine, and it's more comfortable to have it in your browser as you work. There is a UI for defining multi-field-uniqunessdefinitions there, and it's just much more productive and fun to do it that way instead of writing SQL... I also disagree with that not being a feature, I don't see that as an SQL thing - if it were, it would have been supported in all relational databases - it's a feature of PostgreSQL that exists in all of its user interfaces. The DAL is somewhat like Microsoft's entity-framework, and a such, it should support all database common usage patterns - especially the useful ones. Thanks for all your help, in any case, it's very cool what youv'e done with this script! :) On Thu, Jan 3, 2013 at 12:38 PM, Arnon Marcus a.m.mar...@gmail.com wrote: 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 ESXi or bare metal dedicated server, you should stick with one VM where you configure Nginx, etc. and you developpe with Rocket server included in web2py. I guess I did not make myself clear enough. That is not exactly my intent, and that's not what we're doing. The machine I've installed the VM on, is a BOXX bare metal dedicated to become this server. You may ask then why a VM at all? why not install it fresh as the main os? Well, I have my reasons, but that's beside the point. The machine is a 64bit double-dual-core AMD with 8GB of RAM. The application is for intranet-use, so it's not going to have too much load anyways - it's going to serve up to 60 clients total at the very most - and mostly not all simultaneously. I don't expect it to have a problem running 2 VMs, I would just have to give each one around 3.5GB of RAM. You may then ask then why a 64bit VM stack? Well, future-proofing - We are supposed to get a newer dedicated bare-metal, which would probably have 16GB of RAM at least. But in any case, the 2 VMs are NOT your typical prod/dev configuration - it's more of a stable/nightly configuration - I want some of the workers to be able to QA new code by using a different server-instance. We DO also have a dev-environment, in each of the developer's machine, using the Rocket server as you said - that's on-top of the 2 VMs I'm planning. Another reason for having the production server served from a VM, is for backup reasons - it's easier/quicker to clone an entire VM-image with the whole stack + database, in case something goes wrong. Plug, we are almost a purely Microsoft-stack based shop, so I think it's going to be easier that way - with having all the remote-desktop experience super-simple, having the server logged in to the active-directory, etc... So then the question still remains - how do my users use this server on our network? Using the domain of the hosting machine as the host-address, doesn't work... So what address should they use? On Thursday, January 3, 2013 7:12:09 AM UTC-8, Richard wrote: See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus a.m.m...@gmail.com 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 years now. Using phpPgAdmin on our production was never an option - always a necessity. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't
Re: [web2py] Redmine beside web2py with Nginx deployment script
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) and tell nginx hostname... ?! Richard On Thu, Jan 3, 2013 at 3:38 PM, Arnon Marcus a.m.mar...@gmail.com wrote: 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 ESXi or bare metal dedicated server, you should stick with one VM where you configure Nginx, etc. and you developpe with Rocket server included in web2py. I guess I did not make myself clear enough. That is not exactly my intent, and that's not what we're doing. The machine I've installed the VM on, is a BOXX bare metal dedicated to become this server. You may ask then why a VM at all? why not install it fresh as the main os? Well, I have my reasons, but that's beside the point. The machine is a 64bit double-dual-core AMD with 8GB of RAM. The application is for intranet-use, so it's not going to have too much load anyways - it's going to serve up to 60 clients total at the very most - and mostly not all simultaneously. I don't expect it to have a problem running 2 VMs, I would just have to give each one around 3.5GB of RAM. You may then ask then why a 64bit VM stack? Well, future-proofing - We are supposed to get a newer dedicated bare-metal, which would probably have 16GB of RAM at least. But in any case, the 2 VMs are NOT your typical prod/dev configuration - it's more of a stable/nightly configuration - I want some of the workers to be able to QA new code by using a different server-instance. We DO also have a dev-environment, in each of the developer's machine, using the Rocket server as you said - that's on-top of the 2 VMs I'm planning. Another reason for having the production server served from a VM, is for backup reasons - it's easier/quicker to clone an entire VM-image with the whole stack + database, in case something goes wrong. Plug, we are almost a purely Microsoft-stack based shop, so I think it's going to be easier that way - with having all the remote-desktop experience super-simple, having the server logged in to the active-directory, etc... So then the question still remains - how do my users use this server on our network? Using the domain of the hosting machine as the host-address, doesn't work... So what address should they use? On Thursday, January 3, 2013 7:12:09 AM UTC-8, Richard wrote: See below answer... On Sun, Dec 30, 2012 at 3:55 PM, Arnon Marcus a.m.m...@gmail.com 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 years now. Using phpPgAdmin on our production was never an option - always a necessity. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't have your database installed in one machine, and have your phpPgAdmin hosted on another - in its configuration file, you have to specify the local path of the pg_dump.exe and stuff like that it needs for it's operation. And again, we need it's operation for unsupported feattures of postgreSQL in web2py. As for PgAdmin-III, well, we basically only use if when transferring our database + schema as an SQL string, from one machine to another. Somehow the same thing using phpPgAdmin doesn't take us the whole way the same way PgAdmin-III does when doing that. If we were starting a new project, I could have agreed with you - we wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a database somewhere else (meaning, outside the virtual machine I just installed thanks to you), we need PgAdmin-III for the database transferring. And since the installation of it in ubuntu is extremely simple, and having our solution installing a default ubuntu installation of postgreSQL, I would have expected the installation of PgAdmin-II to have automatically identified the postgreSQL service/process that is running - but when I launch
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script ( https://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
Is this for the server or desktop flavor ? On Sun, Dec 30, 2012 at 2:16 PM, Arnon Marcus a.m.mar...@gmail.com 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/? 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://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 a.m.mar...@gmail.com wrote: Is this for the server or desktop flavor ? On Sun, Dec 30, 2012 at 2:16 PM, Arnon Marcus a.m.mar...@gmail.comwrote: 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 who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 gift for the one who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script ( https://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: 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 gift for the one who would use Redmine beside web2py... :) The script is largely base on new Niphold web2py nginx deployment script (https://groups.google.com/**forum/?fromgroups=#!searchin/** web2py/nginx$20niphold/web2py/**15J3T35_K_w/v_t1099dIf4Jhttps://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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. Maybe it's becuse we are using an outdated version of web2py, but from our experience, the DAL isn't perfect - there are many advanced features of PostgreSQL that are not supported (I can give you a list of those), so we HAVE to use some kind of interface to further customize our schema outside of web2py. I don't really see how we can do this in a dev machine and not need to do the same for the prod. machine. If they share a database, then the database is on the prod. machine - and we need phpPgAdmin. If each of them have a separate machine, then we need 2 phpPgAdmins one on each machine. As far as I know, you can't have your database installed inone machine, and have your phpPgAdmin hosted on another - in its configuration file, you have to specify the local path of the pg_dump.exe and stuff like that it needs for it's operation. And again, we need it's operation for unsupported feattures of postgreSQL in web2py. As for PgAdmin-III, well, we basically only use if when transferring our database + schema as an SQL string, from one machine to another. Somehow the same thing using phpPgAdmin doesn't take us the whole way the same way PgAdmin-III does when doing that. If we were starting a new project, I could have agreed with you - we wouldn't need phpPgAdmin AND PgAdmin-III. But since we already have a database somewhere else (meaning, outside the virtual machine I just installed thanks to you), we need PgAdmin-III for the database transferring. And since the installation of it in ubuntu is extremely simple, and having our solution installing a default ubuntu installation of postgreSQL, I would have expected the installation of PgAdmin-II to have automatically identified the postgreSQL service/process that is running - but when I launch it, and try to connect, it apparently doesn't find it properly. I can't seem to be able to connect to the postgreSQL service with it. I don't see any redmine database I can connect to. I think we are confusing the database node, with the connection-string/setting for PgAdmin to find the server/service/process/whatever... Any thought? And any pointers you could give me for trying to install phpPgAdmin? I was able to locate where web2py is and where redmine is. But where is nginx? How do I further configure it for php ? Any configuration file I should know aboout? And what about web2py? Is it connected to postgreSQL? I guess not, because it's just the welcome application, that uses sqlite by default, right? I guess if I can connect to postgreSQL with PgAdmin, I will have found the specification I need to use in the connection string in web2py for our application (we currently use the default settings for postgreSQL connection and it works) I was able to install everything smoothly on ubuntu 12.04 desktop x64 with virtual box on windows 7 x64. Web2py and redmine are loading successfully locally with firefox. But how do I access them elsewhere on our intranet? I tries ifcondif in the reminal, and got a 10.0.2.15 ip adress... That's not usefull, I guess... I'll admit I am a nube at linux and virtual machinesstuff... Would appreciate any pointers you could give me... On Sun, Dec 30, 2012 at 10:36 AM, Richard Vézina ml.richard.vez...@gmail.com wrote: 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. Since you don't really require Nginx for develppment it make no sens to install pgAdmin on the staging/prod server, you generally install it on your dev system. You can install phpPGAdmin if you want, but when I try it (very longtime ago, may have change) it was not the same quality of phpmyadmin, just for you to know that. I let you find your way to install it (google...). Default postgres database name is redmine and user name for redemine is redmine and the password is the one you enter when the script ask for it. You can, try it with 12.10, but I prefer 12.04 since it LTS and I don't want to setup new environnement in less than a year. Richard On Sun, Dec 30, 2012 at 1:26 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: 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 gift for the one who would use Redmine beside web2py... :) The script is largely base on new Niphold
Re: [web2py] Redmine beside web2py with Nginx deployment script
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? 2.6/2.7? 32/64 bit? 4. What version/flavor of PostgresSQL is it insalling? 8.x/9.x? 32/64bit? On Friday, December 28, 2012 12:17:12 PM UTC-8, 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://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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 a.m.mar...@gmail.com 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! 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? 2.6/2.7? 32/64 bit? 4. What version/flavor of PostgresSQL is it insalling? 8.x/9.x? 32/64bit? On Friday, December 28, 2012 12:17:12 PM UTC-8, 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://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard -- --
Re: [web2py] Redmine beside web2py with Nginx deployment script
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://groups.google.com/forum/?fromgroups=#!searchin/web2py/nginx$20niphold/web2py/15J3T35_K_w/v_t1099dIf4J ). I spend many hours write it, test it and debug Redmine, so I copyright it and distribute it under CC without commercial use. Executing it in a fresh Ubuntu 12.04 server you will get : - Latest Redmine stable (2.2.0 from http://rubyforge.org), - Rails (3.2.9 from GEM) - Ruby (ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]) (Ubuntu ruby-dev package that should correspond to the latest stable Ruby) - working with Unicorn (latest stable from GEM), - web2py (latest stable) - uWSGI (I think latest stable), start in Emperor mode - Nginx (Ubuntu default) - PostgreSQL (Ubuntu default) - Redmine database will be installed in PostgreSQL - Self Signed SSL Certificat I try to make the script asking all the question at the beginning of the installation process just after launch it, but there is a confirmation asked during execution where you have to choose which language to use for the Redmine default values. Just hit enter you will get English Redmine default values. At the end of the execution, you should access your sever like this : http://IPADSRESS/ # web2py Welcome should appear http://IPADSRESS/redmine # Redmine! Please report issue, submit improvement or post any comment here, and I will be glad to improve the script. Happy new year to all! Richard --