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.com<javascript:> > > 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.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<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 address you mention, I think you should use bridged networking (easier >>> solution to allow internet connection to a VM with VB) interface in you >>> network VirtualBox machine this way all the VM you host on this computer >>> will use the network card (the one of you computer) and get each a IP >>> address. That is far from the purpose of this script. And you maybe need a >>> syst admin if you don't know how to do this kind of stuff your self. 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. >>> >>> Richard >>> >>> >>> 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 machines stuff... Would appreciate any pointers you could give >>>> me... >>>> >>>> >>>> On Sun, Dec 30, 2012 at 10:36 AM, Richard Vézina <ml.richa...@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.richa...@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....@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_t1099dIf4J<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 >>>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> >>>> >>>> -- >>>> >>>> >>>> >>>> >>> >>> -- >> >> >> >> > > --
